Overview

Execute Business Insights & Analytics responsibilities (for PepsiCo Europe Beverages Sector team) as part of the broader Global Business Services function in Hyderabad, India. This role will help to enable accelerated growth for PepsiCo by contributing to the Europe Beverages Sector team while also working alongside the consumer marketing 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
• Execute market, portfolio, brand & promotion campaign performance reporting (utilizing dashboards, templated decks, and reporting tools)
• Analyze & Report category, brand & promotion performance drivers, and optimization opportunities
• Bring impactful insights for the BU by integrating & leveraging multiple data sources such as Internal Sales, Agency (RMS, HHP etc)
• Translate complex data findings into actionable insights and strategic recommendations for decision-making.
• Assist the team in analysing marketing expenses & budgets for better utilization of marketing investments
• Manage Ad-hoc & follow up deep-dives into the Data to address tactical performance issues & challenges
• Collaborate with stakehokders to develop analysis and reports offering strategic plans.
• 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 Pan Europe Quarterly Business Reviews
• Implement innovative solutions to enhance data analysis capabilities and efficiency.
  
  

Qualifications

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