Job
Description
Overview: This role is responsible for supporting the PBNA Retail team with all reporting and analytics support activities including (but not limited to) key reporting and analysis of performance by Channel, Brand, Customer and Sales Area against key deliverables. Role will be responsible for providing data and analytics leadership to the commercial team, including data acquisition and validation, as well as interpretation of the results. This role also provides meaningful insights and recommendations to the Sales Leadership team across our Sector and/or Division teams. Responsibilities: Support Commercial function with performance reporting against established KPIs, including ad-hoc reporting requests using internal and shipment / POS data and market data systems (IRI) – will include Off-Ticket ROI analysis, CDA Scorecard, distribution reporting, Service Scorecard, Energy performance reporting, Incentive Tracking, Promo/Plus-Up analysis, daily & weekly OTS reporting, Cause of Change/Bain Reprot, OTS & Co-op Scorecards, QBP Deck, Quarterly Customer meeting Decks, and Off-Line Forecast PowerBI skills – must have, Coding Skills – Python / R / modelling experience and ability to understand statistical modelling (regression, cluster analysis, etc.) Present insights and recommendations to Sales Leadership team on an established time period and in a clear, concise manner Create opportunities to improve forecasting, create Predictive Analytics used cases and create opportunities for digital transformation Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology Develop on-demand reports and Scorecards delivering improved agility through ease of access and enhanced visualization Collate and format large and complex sets of data across multiple channels, customers and sales areas. Analyze data to distil meaningful insights on performance trends and opportunities Analyze key innovation or portfolio activity effectiveness to monitor return on investment and identify opportunities for improvement and customization by Channel, Brand, Customer and/or Market Assist with field sales execution and compliance reporting - HI-FI tool fluency to validate Store Sets to Contract requirements (Could be Savvy tool in the future) Manage expectations through verbal and written interactions with headquarter partners Ensure delivery of accurate and timely data in accordance with agreed service level agreements (SLA) Work across multiple functions to aid in collecting insights for action-oriented cause of change analysis Ability to focus against speed of execution and quality of service delivery rather than achievement of SLAs Recognize opportunities and take action to improve delivery of work Create an inclusive and collaborative environment Qualifications: +5 years of experience in Sales/Sales Management Bachelor’s in commerce/business administration/marketing or Finance, Master’s degree is a plus Prior Fast Moving Consumer Goods (FMCG) company experience required Development experience related to Data Analytics and Reporting including the usage of relevant tools and software packages (i.e PowerBI) Requires a high level of analytical, critical thinking, and problem-solving skills as well as great attention to detail Propensity to learn PepsiCo software systems Strong knowledge of MS Office programs specifically Excel, Power Point and Access Ability to provide superior customer service Best-in-class time management skills, ability to multitask, set priorities and plan
