Data Analyst

Location: Chennai, India

Function: Data Analytics & Insights – Centre of Excellence (CoE)

Role Summary

As a Junior Data Analyst, you will be a core member of the Centre of Excellence (CoE) team—driving business intelligence across revenue, demand signals, customer behavior, and product performance. This is a high-impact role where your insights will shape decision-making in marketing, merchandising, demand planning, and finance across D2C, B2B, and Q-commerce platforms.

Unlike operational reporting roles, this position is geared toward front-end performance analytics—providing insights that steer business growth.

Key Responsibilities

Focus Area

Data Preparation & Governance

• Pull and harmonize data from Shopify, marketplaces, quick-commerce portals, CRM, and ERP systems.
• Run automated validation scripts to ensure data accuracy before pushing data to dashboards.

• Build and maintain self-serve dashboards in Power BI / Tableau covering GMV, AOV, channel mix, fill rates, contribution margins, and promo ROI.
• Deliver weekly scorecards for category managers and senior leadership.

• Identify trends in SKU performance, promo uplift, geographic splits, and sales velocity.
• Translate complex analysis into actionable insights and strategic recommendations.

• Support the Excellence Manager in demand forecasting that feeds into S&OP processes.
• Build "what-if" models to evaluate pricing, discounting, and product launch scenarios.

• Collaborate with the Data Engineering team to transition recurring reports from Excel to automated SQL/ETL workflows.
• Maintain documentation for data definitions and KPIs to ensure a single source of truth.

• Bachelor’s degree in Statistics, Engineering, Business Analytics, Economics, or related field.
• 2–4 years of experience in data analysis with a focus on revenue / commercial insights (preferred industries: FMCG, D2C, or Retail).
• Proficiency in SQL and Excel; hands-on experience with at least one BI tool (Power BI, Tableau, or Looker).
• Sound understanding of e-commerce KPIs like AOV, conversion rates, retention cohorts, and promo uplift.
• Strong communication skills with the ability to simplify complex data into business-friendly narratives.

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