Job Description

Overview:Execute Business Insights & Analytics responsibilities (for UK I&A) focusing on Grains. as part of the broader S&T function in Hyderabad, India. This role will help to enable accelerated growth for PepsiCo by providing an integrated holistic overview to the Grains 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. 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. We expect this process to take around six months, after which the DPEX team will fully assume responsibility. Once this transition is complete, the resource will be reassigned to another unit. Responsibilities:Build Strong Business Insights & Analytics

• Lead monthly ops reviews, MBR (IS&OP) meetings, and quarterly business reviews (QBR), delivering insights on category and brands. Conduct in-depth analyses for Quarterly Stepbacks, Brand Deep Dives, and Annual Operating Plan (AOP) reviews, transforming data into actionable insights and building narrative storyboards.

• Oversee BI reporting across categories (Snacks + Grains) to ensure consistency, filling gaps in current reporting and enhancing performance reports.

• Act as point of contact for subscribed data tools (IRI Circana, NIQ Business Drivers) and maintain data quality and reporting standards in collaboration with agency partners.

• Monitor market and competitor dynamics to proactively identify opportunity areas, coordinating internally to ensure timeline adherence and accuracy.

• Support strategic initiatives (SMART) by managing communication with the management team, ensuring all stakeholders are updated on performance and key deliverables.

• Support the business with market dynamics beyond reporting and data pulls.

• Connect with BU counterparts to identify the gaps in our reporting and deliverables and how to bring more efficiency in the process.

• Manging efficient communication and keeping the management team updated with our performance.

• Proactively identifying the opportunity areas by looking at market and competitor activities

• Coordinating internally with other capabilities and deliver team to maintain timelines and accuracy.

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:

• 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.

PepsiCo