Junior Data Analyst Job in Chennai – Sweet Karam Coffee – Apply Now

Sweet Karam Coffee; Chennai District; On-site; INR 600,000 - 800,000; Full time

Benefits offered by this job

Work in a high-growth D2C and FMCG environment

Collaborate with cross-functional teams

Gain hands-on experience in modern BI tools

Job summary

Sweet Karam Coffee is hiring a Junior Data Analyst for a full-time, on-site role in Chennai, Tamil Nadu, India. This position places you at the center of data-driven decision-making, influencing revenue growth, customer engagement, and product performance.

You will extract and consolidate data, build dashboards, and analyze trends to support marketing, finance, and operations. The ideal candidate has 2–4 years of experience, a degree in a relevant field, and proficiency in SQL and BI tools.

Qualifications

• 2–4 years of experience in data analysis, preferably in FMCG, Retail, or D2C industries.
• Strong proficiency in SQL and Microsoft Excel.
• Hands-on experience with at least one BI tool: Power BI, Tableau, or Looker.

Responsibilities

• Turn raw data into meaningful business strategies.
• Extract and consolidate data from platforms like Shopify and CRM systems.
• Develop what-if models for pricing, discounting, and new product launches.

Skills

SQL

Microsoft Excel

Data Analysis

Business Intelligence

Data Storytelling

Education

Bachelor’s degree in Statistics, Engineering, Economics, Business Analytics, or related fields

Tools

Power BI

Tableau

SQL

Job description

Are you looking to grow your career in data analytics, business intelligence, and e-commerce insights? Sweet Karam Coffee is hiring a Junior Data Analyst for an exciting full-time, on-site role in Chennai, Tamil Nadu, India.

This is not just another reporting role—this opportunity places you at the centre of data-driven decision-making, where your insights will directly influence revenue growth, customer engagement, and product performance across multiple business channels.

Job Overview

• Role: Junior Data Analyst
• Company: Sweet Karam Coffee
• Location: Chennai, Tamil Nadu, India
• Work Mode: On-site, Full-Time
• Function: Data Analytics & Insights – Centre of Excellence (CoE)
• Experience: 2–4 Years

Role Summary

As a Junior Data Analyst, you will be a key contributor to the Centre of Excellence (CoE) team. You’ll work on high-impact analytics projects spanning revenue tracking, demand forecasting, customer behaviour analysis, and product performance insights.

Unlike traditional roles focused only on reporting, this position emphasizes front-end performance analytics—turning raw data into meaningful business strategies. Your work will support teams across marketing, merchandising, finance, and supply chain, especially in D2C, B2B, and quick-commerce ecosystems.

Data Preparation & Governance

• Extract and consolidate data from platforms like Shopify, CRM systems, ERP tools, and marketplaces
• Ensure high data accuracy through automated validation scripts
• Maintain clean, structured datasets for reporting and analytics

Business Intelligence & Dashboards

• Build and manage interactive dashboards using Power BI or Tableau
• Track key metrics such as GMV (Gross Merchandise Value), AOV (Average Order Value), channel mix, and contribution margins
• Deliver weekly performance reports for leadership and category managers

Insights & Data Storytelling

• Analyse trends in SKU performance, promotions, geographic demand, and sales velocity
• Convert complex data findings into clear, actionable business insights
• Support strategic decision-making through compelling storytelling

Forecasting & Scenario Planning

• Assist in demand forecasting aligned with S&OP processes
• Develop what-if models for pricing, discounting, and new product launches
• Collaborate with stakeholders to optimize business outcomes

Process Automation

• Work with data engineering teams to automate recurring reports using SQL and ETL pipelines
• Transition manual Excel-based workflows into scalable automated systems
• Maintain documentation for KPIs, metrics, and data definitions

Required Qualifications

• Bachelor’s degree in Statistics, Engineering, Economics, Business Analytics, or related fields
• 2–4 years of experience in data analysis, preferably in FMCG, Retail, or D2C industries
• Strong proficiency in SQL and Microsoft Excel
• Hands-on experience with at least one BI tool: Power BI, Tableau, or Looker
• Solid understanding of e-commerce KPIs, like:
  • Average Order Value (AOV)
  • Conversion Rates
  • Customer Retention Cohorts
  • Promotional Uplift
• Excellent communication skills with the ability to translate data into business insights

Preferred Skills (Nice-to-Have)

• Experience with Python for statistical analysis or modelling
• Familiarity with platforms such as Shopify, Amazon Seller Central, Blinkit, or Instamart
• Exposure to cloud data warehouses like BigQuery, Snowflake, or Amazon Redshift

Why Join Sweet Karam Coffee?

• Work in a high-growth D2C and FMCG environment
• Be part of a data-driven culture where your insights matter
• Collaborate with cross-functional teams across marketing, finance, and operations
• Gain hands‑on experience in modern BI tools, automation, and advanced analytics
• Opportunity to influence real business outcomes and strategy