Data Analyst

Life tastes better with ice cream

With 19.000 expert ice cream colleagues and iconic brands like Wall’s, Cornetto and Ben & Jerry’s, loved in 76 countries, we are the world’s largest Ice Cream company leading the industry.

We create iconic ice cream brands that are part of everyday life, bringing moments of joy to millions of people around the world. Everybody loves ice cream. And as the world’s biggest pure‑play ice cream company, we have the scale and ambition to make a real difference.

What truly sets us apart is how we work.

We move fast and keep things simple. We turn ideas into action, trust people to take ownership, and work as one team to win together with integrity. Our culture is high‑performance, collaborative and focused on getting things done.

We’re curious and ready for what’s next. We embrace digital, use data to make better decisions, and keep learning, including how AI can help us work smarter and serve consumers better.

Job Title- Data Analyst

Location- Mumbai HO

Life tastes better with ice cream

With 19.000 expert ice cream colleagues and iconic brands like Wall’s, Cornetto and Ben & Jerry’s, loved in 76 countries, we are the world’s largest Ice Cream company leading the industry.

We create iconic ice cream brands that are part of everyday life, bringing moments of joy to millions of people around the world. Everybody loves ice cream. And as the world’s biggest pure-play ice cream company, we have the scale and ambition to make a real difference.

What truly sets us apart is how we work.

We move fast and keep things simple. We turn ideas into action, trust people to take ownership, and work as one team to win together with integrity. Our culture is high-performance, collaborative and focused on getting things done.

We’re curious and ready for what’s next. We embrace digital, use data to make better decisions,

and keep learning, including how AI can help us work smarter and serve consumers better.

The role-Data Analyst

What you'll be responsible for

Sales Performance Analytics

• Analyse core sales KPIs such as volume growth, value growth, distribution, assortment, and productivity.

• Perform structured deep-dives to uncover drivers of performance across regions, channels, and categories.

• Develop performance dashboards that give visibility into coverage, frequency, velocity, order patterns, and execution adherence.

• Support Monthly and Quarterly Business Reviews with detailed insight decks and analytical summaries.

• Evaluate sales initiatives, promo effectiveness, NPI performance, and trade investment outcomes.

2. GTM & Route-to-Market Analytics

• Support territory planning, beat optimization, and distributor management analytics.

• Conduct outlet segmentation and universe analytics to identify whitespace and growth opportunities.

• Analyse channel dynamics, customer clusters, and optimizing distribution reach.

• Provide insights on ASM/TSM productivity metrics such as call averages, strike rate, order values, and coverage efficiency.

• Build models that help strengthen retail execution and salesforce deployment strategies.

3. Business Intelligence & Dashboard Development (Power BI)

• Design interactive dashboards with robust backend data models using Power BI.

•Create advanced DAX measures, calculated fields, and clean visualization layouts.

• Build automated and scalable reporting systems with efficient dataflows and ETL pipelines.

• Standardize KPI definitions, metric documentation, and maintain data governance frameworks.

• Ensure consistent refresh cycles, troubleshoot dashboard issues, and manage user access

SQL & Python-based Data Engineering

• Write advanced SQL queries including CTEs, joins, aggregations, and window functions to extract and transform data.

• Use Python (pandas, NumPy) for data preparation, cleansing, forecasting, and exploratory analysis.

• Build reusable data scripts and automation routines for recurring workflows.

• Perform statistical modelling: correlation, regression, clustering, and time-series forecasting (basic to intermediate level).

• Ensure high levels of data accuracy and integrity across all reporting layers.

5. Insights Delivery & Stakeholder Collaboration

• Translate analysis into actionable insights for Sales Excellence, Regional Teams, and Category Leaders.

• Present findings in a structured format using dashboards, reports, and presentations.

• Participate in requirement gathering sessions to understand evolving data needs.

• Provide analytical support for special projects within CD COE.

• Engage in low- to medium-level stakeholder discussions for insights and solution alignment.

We're looking for someone who

Bachelor’s degree in Engineering, Statistics, Mathematics, Computer Science, Economics, or related fields.

• 3–6 years of experience in analytics, business intelligence, or sales analytics roles.

• Strong SQL capabilities for querying and data manipulation.

• Power BI expertise: data modelling, DAX, Power Query, and visual storytelling.

• Basic to Intermediate Python experience (pandas, NumPy, basic modelling).

• Strong understanding of CD/Sales domain metrics and KPI frameworks

Advanced Excel skills including automation, modelling, and complex formulas.

• Excellent analytical, logical reasoning, and problem‑solving skills.

• Ability to handle multiple priorities with strong attention to detail.

Preferred Qualifications

• Experience working in FMCG, Retail, or Consumer Goods analytics.

• Understanding of GTM models, distributor management, and salesforce analytics.

• Exposure to cloud data platforms such as Azure, AWS, or GCP.

• Familiarity with Tableau, Qlik, or other BI tools.

• Certifications in Power BI, SQL, Python, or business analytics.

What you'll get

Alongside meaningful work and strong development, we offer a reward package that typically includes

• Market-competitive pay and performance related rewards

• Flexible ways of working

• Support for health, wellbeing and life outside of work

• Time off to rest and recharge

• Ongoing learning and development opportunities

• Specific benefits vary by location

This is a place for people who are passionate about ice cream and are growth obsessed - both for the business and for themselves. People who act like an owner and drive our business end-to-end. People who are driven by success to deliver more than we ever thought we could!

You’ll thrive here if you value an inclusive culture, with low ego and hierarchy - and if you’re excited to continuously learn and challenge how we work, using digital, data, and new thinking to push us forward.

• Roles with real accountability and visible impact

• Free to move fast, experiment and challenge how things are done

• Continuous learning and development as the business grows

• Reward linked to performance and contribution.

Your career here is shaped by what you deliver, as you work across functions and markets and grow with the business.

Ready to build the future of Ice Cream?

If this sounds like the place where you'd thrive, we'd love to hear from you. Apply online and share your CV. We'll review your application and be in touch with the next steps.

If you are an individual with a disability and require assistance at any time during our recruitment process, please let your Talent Acquisition Partner know.

Additional information

The Magnum Ice Cream Company is an Equal Opportunity Employer. We embrace diversity and are committed to creating an inclusive environment where everyone can do their best work regardless of age, disability, gender identity, race, religion, sexual orientation, or any other protected characteristic.

#TMICC

Why join us?

This is a place for people who are passionate about ice cream and are growth obsessed - both for the business and for themselves. People who act like an owner and drive our business end-to-end. People who are driven by success to deliver more than we ever thought we could!

You’ll thrive here if you value an inclusive culture, with low ego and hierarchy - and if you’re excited to continuously learn and challenge how we work, using digital, data, and new thinking to push us forward.

- Roles with real accountability and visible impact
- Free to move fast, experiment and challenge how things are done
- Continuous learning and development as the business grows
- Reward linked to performance and contribution.

Your career here is shaped by what you deliver, as you work across functions and markets and grow with the business.

Ready to build the future of Ice Cream?

If this sounds like the place where you'd thrive, we'd love to hear from you. Apply online and share your CV. We'll review your application and be in touch with the next steps.

If you are an individual with a disability and require assistance at any time during our recruitment process, please let your Talent Acquisition Partner know.

Additional information

The Magnum Ice Cream Company is an Equal Opportunity Employer. We embrace diversity and are committed to creating an inclusive environment where everyone can do their best work regardless of age, disability, gender identity, race, religion, sexual orientation, or any other protected characteristic.