Overview 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