A&M Insights & Analytics Specialist

The A&M Consulting Team was established in 2023 as a service within the Strategy & Transformation Function. This team works in close partnership with the Global Marketing Transformation Office (MTO) to support the Powering Positive Growth Marketing Transformation agenda. Through The Becoming Better Investors workstream, A&M Consulting has led the diagnostics and delivery of +$500MM of reinvestable savings. The program is expected to continue to expand throughout 2025/2026 across all sectors.

This role is responsible for A&M spend process mapping and providing analytical support to A&M Experts to develop the proposal for A&M right sizing optimization, A&M allocation and A&M efficiency & effectiveness opportunities.

The scope covers the data collection & processing (including A&M spend cube set up, review & validation, leveraging internal data tools to gather required data), creation of Market Factbook by synthesizing & analysing the qualitative and quantitative data received from the market, addressing different hypotheses with customized analyses based on the data & SME conversations, managing internal & external benchmarks database, support in automation efforts related to data collection, validation & reporting, building & managing best practice library.

Responsibilities

• Main point of contact for all BBI data-related queries from internal teams, markets, external stakeholders
• Provide responses to ad-hoc follow-ups when double-click required with tables/charts/stories using relevant data
• Support processes/formatting for output adherence and delivery to agreed scope – in line with the agreed timelines, aligned templates and content management

Data Management

• Maintenance & Regular Update of Data Dictionary to ensure all data required for A&M Consulting team are collected
• Coordination for data collections & processing for all new projects from multiple sources (e.g. marketing, insights, finance), which includes collection, formatting, clearing gaps, liaising with local SME to clarify & validate the data quality and accuracy.
• A&M spend cube set up, ownership of the data processing & validation to ensure the quality outputs
• Leverage internal & external data tools to extract relevant data for analysis and queries received (e.g. Cockpit)
• Ownership over Quality checks and on-going changes required based on changing phases of the project and new information.
• Provide informed responses to A&M Senior Expert when double-click required with tables/charts/stories using relevant data

Diagnostics

• Provide preliminary commentary to explain business performance, drivers, and optimization opportunities; leverage business performance explanations from teams around the world to incorporate considerations beyond data into reporting
• A&M Expert:
• Lead the assigned part of the problem solving, as part of Market Deep Dive: develop hypothesis to address given problem statement, prepare set of analyses & data required to perform them to support the hypothesis, develop creative solutions to drive efficiencies & effectiveness of A&M spend
• Identifies inefficiencies in working and non-working A&M spend, develops hypothesis for driving efficiency and right sizing of A&M spend in the BU. Apply identified set of proven high-impact levers to size opportunity.
• Identify above-market opportunities and channel to the right teams/functions to deliver (incl. S&T-driven opportunities)
• Maintain, further develop, and share the toolkit of proven levers/initiatives across markets
• Provides recommendations on S&T service catalogue leverage in the BU and work with Sector S&T Design leads /Sector PMO in understanding size of the prize and resourcing requirements.
• Together with project manager and Senior A&M Expert co-leads development of the portfolio of A&M optimisation initiatives and ensures support during Deliver stage of the project.
• Co-leads development and alignment of ambitious but realistic A&M efficiency target for the BU.
• Establishes A&M spending frameworks, processes and ways of working, agency roster to ensure sustained A&M optimisation and right-sizing in the BU.
• Support internal capability building effort in A&M process mapping to enable PepsiCo to drive further Marketing transformation projects independently and developing sustainable solutions for the BU in the long term.
• Support in deploying the necessary tools and processes to make change stick, building continuous productivity management

Governance & Reporting

• Ensures structured governance around data and maintaining collaboration with broader teams (e.g. can organize and lead quarterly meetings with cross-functional teams to review data governances, address issues, coordinate plans, build data inventory)
• Participate in weekly / daily meetings and reviews with A&M Experts, Analysts and Project Managers; preparation for SteerCo & other internal communication from data / knowledge management side
• Liaise and align with A&M Allocation team to setup and execute ongoing reportings, analytics, (utilizing dashboards, templated decks, and reporting tools); partnering with A&M Experts, Analysts & Project Managers
• Prepare material for stakeholder meetings, data reviews (e.g. PPT)

Way of Working Improvements (Automation, New Methods)

• Supports automation efforts related to data collection, validation and reporting (e.g. work on the automation streams for Scorecards, or Prodigy);
• Establish safeguards and automate data quality checks, e.g., regular trend-watch of data streams to identify and address potential trend breaks.
• Research new methods of data collections, or automation programs within the company
• Implement best practices for data entry and management to ensure consistency and accuracy
• Improve existing processes based on feedback loop; leverage global/regional synchronization efforts to drive further streamlining and unification of data sets for future digitalization work; support simplification, standardization and digitalization efforts (in cooperation with global and CC stakeholders)

Qualifications

• A mid-level Insight or Analytics professional with experience in a leading consumer goods company. With atleast 7 years+ experience
• Education: Masters in Maths, Statistics, Economics, Sociology, Marketing
• Experience in working with large data cubes
• Can synthesize multiple, disparate data sources.
• Strong collaborator: actively creates and participates in opportunities to co-create solutions across markets; will be willing and able to embrace Responsive Ways of Working
• Proven analytics, business analytics, research experience, consumer insights experience or commercial experience in combination with strong analytical skills
• High degree of familiarity with CPG and Food & Beverage industry A&M services providers
• Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually
• Operational experience from business servicing sector and/or consulting experience would be a plus
• Fluent English – obligatory