This role is for one of Weekday’s clients
Min Experience: 4+ years
Location: India
JobType: full-time
We are looking for an experienced Data Analyst with 4–8 years of experience to join our analytics team and drive data-led decision-making across the CPG/FMCG business. The ideal candidate will have strong expertise in Power BI, along with hands-on experience in Pricing Analytics, Distribution Analytics, sales performance, and commercial analytics.
You will work closely with business, sales, marketing, revenue, and commercial stakeholders to transform complex datasets into actionable insights, dashboards, and recommendations that support pricing strategies, distribution expansion, revenue growth, and overall business performance.
Requirements
Key Responsibilities
- Develop, maintain, and optimize interactive Power BI dashboards and reports for sales, pricing, distribution, revenue, and business performance.
- Analyze CPG/FMCG datasets to identify trends, patterns, opportunities, and performance gaps across products, categories, channels, regions, and customers.
- Conduct Pricing Analytics, including price-performance analysis, price changes, discount analysis, price elasticity, promotional effectiveness, and revenue impact.
- Perform Distribution Analytics to evaluate distribution coverage, availability, channel performance, geographic penetration, and product-level distribution trends.
- Track key commercial and sales KPIs and provide actionable insights to business stakeholders.
- Build automated reporting solutions that reduce manual reporting and improve data accessibility.
- Collaborate with sales, marketing, finance, category management, and commercial teams to understand business requirements and translate them into analytical solutions.
- Identify data quality issues and work with relevant teams to improve data accuracy, consistency, and reliability.
- Present analytical findings and business recommendations to stakeholders in a clear and structured manner.
- Continuously improve existing dashboards, analytical models, and reporting processes.
Must-Have Skills
- Power BI – strong hands-on experience in dashboard development, data modeling, visualization, DAX, Power Query, and report optimization.
- CPG / FMCG Analytics – strong understanding of consumer packaged goods, sales, distribution, categories, channels, and commercial metrics.
- Pricing & Distribution Analytics – practical experience analyzing pricing, promotions, distribution, assortment, sales performance, and commercial effectiveness.
- Strong analytical and problem-solving capabilities.
- Ability to translate business questions into meaningful data-driven insights.
- Strong stakeholder communication and presentation skills.
- Experience working with large and complex datasets.
Good-to-Have Skills
- Power BI Copilot / AI – exposure to AI-assisted analytics, Copilot capabilities, or AI-driven reporting and insights.
- Advanced Excel – strong knowledge of Pivot Tables, Power Query, advanced formulas, data modeling, and analytical functions.
- SQL – ability to write queries, perform data extraction, joins, aggregations, transformations, and validation.
- Experience with sales, revenue, trade promotion, category, or commercial analytics.
- Exposure to automation and self-service BI solutions.
Qualifications
- Bachelor's or Master's degree in Analytics, Statistics, Mathematics, Economics, Business, Computer Science, or a related field.
- 4–8 years of relevant experience in Data Analytics, Business Intelligence, Commercial Analytics, Sales Analytics, or a similar role.
- Prior experience in the CPG/FMCG industry is strongly preferred.