Job Description

Overview This role will help to enable accelerated growth for PepsiCo by building pipelines, aligning data, and performing descriptive and prescriptive analytics approaches for PepsiCo to drive actionable insights at the national, regional, and store level. Specifically, this person will provide a consistent structure for retailer discussions (i.e. Joint Business Planning) and identification of opportunities through local analysis. Primary responsibilities include creating and sharing visually compelling customer presentations on overall PepsiCo results, driving tool clean up to support customer presentations, modeling retailer profitability by linking scan data with shipment metric, and scaling best practices across PepsiCo Business Units within 7 Eleven and Dollar General accounts. This person will also support ad hoc analysis as needed to support projects such as Annual Operations Planning meetings and internal strategy projects. Responsibilities Own Dollar General and 7- Eleven performance analytics project including: Execute market, portfolio, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools) Execute market, portfolio and brand level reporting for Customer KPI performance (Utilizing dashboards, templated decks and reporting tools) Provide business performance explanations, incorporating considerations beyond data into the reporting Explain business performance, drivers, and optimization opportunities Monitor key channel, customer, competitor and emerging player performance and execute reporting at required intervals Provide responses to ad-hoc follow-ups when double-click (additional qustions) required with tables/charts/stories using relevant data Own the process to collaborate with CATMAN during the IRI yearly restate period to ensure all geographies & product migrating correctly across all categories and data models Support relationships with the key end-user stakeholders on PepsiCo Dollar General & 7-Eleven teams Own flawless execution of analytics exercises Responsible for managing multiple priorities being able to manage deadlines and deliverables Lead communication with Business Partners and potentially end-users on matters such as available capacity, changes of scope of existing projects and planning of future projects Deliver outputs in line with the agreed timelines and formats while updating existing project management tools Flag and monitor any business risks related to delivering the requested outputs Partner with stakeholders and service center leadership to develop and finetune internal COE processes (work-flow mapping, pain-points and bottlenecks management) both related to service delivery and internal center operations Improve existing processes based on frequent Business Partner & end-user feedback loop Qualifications An experienced analytics profession with experience in Consumer Goods business. 4-7years+ experience Education: MBA, Masters or Bachelors in economics, math, marketing or management High degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen/IRi (POS and HH panel), GlobalData, Kantar Worldpanel, etc. Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to address business questions in a robust way that translates to simple outputs Proficient with Tableau or Power BI and Advanced Excel Strong collaborator: Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets will be willing and able to embrace Responsive Ways of Working Can easily see how insights/research learning can improve businesses impact and frames up reporting efforts and opportunities to inform business decisions Proven analytics, shopper research experience, or consumer insights experience applying statistics to CPG industry business problems Operational experience from business servicing sector and/or consulting experience would be a plus Language: English Fluent Essential: World-class stakeholder management skills High degree of organizational savvy Solution-oriented approach to problem solving Ability to challenge requests in a constructive way that does not damage relationships or slow progress Depth and breadth of syndicated data analytics and statistical modeling Complete understanding of internal & external data sources that could contribute to analytics roles across service centers Strong analytical thinking with proven ability to connect data & insight from category consumption, brands drivers, macro & micro trends, and future forces of consumer change and deliver clear implications for the business

foundit