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

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.