Consumer & Shop Insights Manager

Pepsico; Hyderabad; On-site; INR 1,800,000 - 2,500,000; Full time

Job summary

PepsiCo is seeking an experienced professional in Hyderabad for the Business Insights & Analytics role. The position involves creating dashboards, reporting, and optimizing analytics processes to support business growth across multiple EU markets.

The ideal candidate should have 7-8 years in analytics, strong collaboration skills, and be proficient in tools like Power BI and Excel. Knowledge of FMCG data sources and storytelling skills are essential.

Qualifications

• 7-8 years of experience in Analytics with exposure to Global Fortune 500 FMCG companies.
• Strong collaborator; motivated by working with others.
• Proficient with PowerPoint and Advanced Excel; can create macros and dashboards.

Responsibilities

• Build strong Business Insights & Analytics with reporting and analysis.
• Integrate & optimize Data sets & Reporting system.
• Implement innovative solutions to enhance data analysis capabilities.

Skills

Analytics expertise

Data visualization

Collaboration

Advanced Excel

Power BI

Education

Masters in Economics, Maths/Statistics, Marketing/Management/Business Administration

Tools

Power BI

Excel

SQL

Job description

Overview

Execute Business Insights & Analytics responsibilities (for PepsiCo EU Bevs) focusing on UK, Norway, Sweden, Netherlands, Denmark and Belgium as part of the broader GCC function in Hyderabad, India. This role will help to enable accelerated growth for PepsiCo by contributing to the EU Bevs team to provide an integrated holistic overview to the business. Primary responsibilities include creating/updating existing dashboards, Excel/Power BI reports, delivering periodic and on-demand brand reporting, and addressing ad-hoc requests based on internal and external data sources. The role will have short-term responsibilities for knowledge transfer from the business and flawless delivery of recurring reports. Once established, the role will execute optimization of the data-based Insights & Analytics processes, including ad hoc questions and overall automation of delivery where applicable.

Responsibilities

Build Strong Business Insights & Analytics

• Market, Category, portfolio, brand & promotion campaign performance reporting (utilizing dashboards, templated decks, and reporting tools) In particular ownership of the Flash share reporting and Global data reporting
• Analyze & Report category, brand & promotion performance drivers, build tools/reports
• Bring impactful insights for the BU by integrating & leveraging available data sources primarily focused on NIQ, Global data
• Manage Ad-hoc requests from BU stakeholders to address tactical performance issues & challenges
• Collaborate with stakeholders to develop new value added analysis and reports E.g. NPD Tracking or Segment Scorecards
• MBR (IS&OP) – prepare data/ inputs
• Develop & update monthly Ops deck – analyse data, create first tier narrative
• Support with inputs to Brand SLAM’s & Share tear-downs
• Full ownership of all NIQ database ensuring accurate coding (interfacing with relevant bottler and Nielsen) to ensure correct segmentations. Requirement to be deep expert (navigating multiple languages) on all relevant Manufacturers, Brands, Retailers
• Focus on CSD’s but requirement to also adapt as we move into more segments such as Energy and Sports/Hydration

Build strong Data Processing & Automation

• Integrate & Optimize Data sets & Reporting system to manage heavy data processing for routine reporting
• Explore Automation opportunities with Higher focus on developing significant Insights for the Marketing Teams
• Speed up the Business Intelligence & Insights for timely & impactful decision making
• Help on implementing and automating Quarterly Business Reviews

Implement innovative solutions to enhance data analysis capabilities and efficiency.

Qualifications

Essential:

• 7-8 years of experience in Analytics with exposure to Global Fortune 500 FMCG companies
• Ability to work and think independently
• Good analytics and insights experience - end-to-end understanding of the best research approach
• Can synthesize multiple, disparate data sources into compelling growth strategies. Formulates a strong POV and can articulate future scenarios and is an exceptional story-teller.
• Strong collaborator; Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets or brands; will be willing and able to embrace Responsive Ways of Working
• Proven analytics, data research experience, consumer insights experience or commercial experience in combination with strong analytical skills
• Good degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen (POS and HH panel), Kantar Worldpanel
• Deep understanding of FMCG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually
• Proficient with PowerPoint and Advanced Excel; including ability to write complex formulas
• Ability to create macros and dashboards in Excel
• Good to have Experience: PowerBI and statistical analysis tool(s)
• Operational experience from business servicing sector and/or consulting experience would be a plus
• Fluent English communication skills
• Excellent communication skills, confident and credible with senior stakeholders
• Strong story-telling and presentation skills to turn data into impactful insight and brand strategy that can drive the business forward.

Desirable:

• Education: Masters in Economics, Maths/ Statistics, Marketing/ Management/ Business Administration
• Experience with Agile development methods, Tableau, Business Objects, D3 open source visualization, SQL, R and SPSS will be an added advantage
• Operational experience in business serves and/or consulting experience