Insights Associate Manager

Job description

Overview

Execute Business Insights & Analytics responsibilities (for PepsiCo Western Europe) 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 WE BU Analytics 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)
·  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

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
Qualifications

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

Differentiating Competencies

·  High organizational agility to navigate a complex, networked organization
·  Experience working in an ambiguous/matrix environment, World-class stakeholder management skills
·  Ability to work remotely and build close relationships
·  Solution-oriented approach to problem solving
·  Proven project management skills and agility to manage priorities
·  Strong experience with and understanding of business intelligence, analytics and continuous data
·  Ability to identify and capitalize on opportunities to gain efficiencies and improve process & deliverables
·  Strong understanding of internal & external data sources that could contribute to the reporting and analysis function
·  Very strong analytical thinking with proven ability to connect data & insight from brands drivers, macro & micro trends, and future forces of consumer change and deliver clear outlook scenarios along with implications for the business