Net Revenue Management

Role & responsibilities:

• GBS NRM analyst will be responsible for conducting data analyses to diagnose and understand business performance by BU x category
• Surmise results in clear, clear PowerPoint presentations for executives
• Run analytics for key strategic NRM projects across all relevant NRM levers (Pricing, Promotion, Assortment Mix & Trade Investment) for BU (e.g. NRM 2.0) and Sector (e.g. regional marketing Price/ Mix) projects
• Develop observations/insights for each analysis in the NRM playbook and synthesize insights across analyses to create a storyline of opportunities
• Aggregate NRM plans during key strategic cycle (e.g. PSP/ AOP) and highlight areas for EUR NRM review vs set strategic guiderails
• Improve processes of analyses and data management across category business units and marketing functions
• Collaborate with Market Cluster Leads to understand market dynamics and incorporate market feedback into analyses
• Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology including migrating tools to Global Analytics Hub
• Create an inclusive and collaborative environment

Key Activities

• Perform granular level analysis to identify growth opportunities
• Prepare data for the analyses to be performed (Excel essential; Alteryx or equiv. desired)
• Prepare executive ready communications (PowerPoint) surmising performance and opportunities across NRM levers
• Understand the nuances of the product category and market to tailor the output according to business needs
• Run the analyses and create visualizations (PowerPoint essential; Power BI and Tableau experience preferred); prepare drill down analyses to derive insights
• Create a storyline out of various analyses output for the business to comprehend the output
• Meet the service level agreements and perform QC of the end-to-end analysis
• Expand playbook analytic pack scope to include additional analyses upon alignment with market

• Strong academic background e.g Bachelors in commerce/business administration/Engg., Masters degree
• +3 years of experience in Retail Analytics/Category Management/Revenue Management
• 2-3 years of relevant professional experience working with large data sets and experience in CPG /Consulting / GBS Organizations
• Very strong analytical skills excellent competency in MS Excel is a must, as is experience of managing complex, incomplete & inconsistent datasets and defining strategic analytics (market sizing/growth forecasts etc).
• Experience in any of the NRM lever practices- Pricing, Promo, Assortment, Trade Investment
• Prior experience in data analytics to derive data driven insights and consolidate them to generate recommendations
• Experience in developing data-driven models for sales and marketing function
• Ability to handle multiple work streams simultaneously and to tight deadlines in a fast-paced and dynamic environment.
• Good collaborator and influencer: Experience working with a breadth of stakeholders and peers levels, functions and across countries in Europe
• Experience in Tableau / Power Bi
• Proven experience using PowerPoint and ability to producing visually compelling presentations (i.e. beyond just operating the software) that are impactful with a senior audience
• Ability to extract key messages from complex data and craft a clear narrative
• Clarity in communication (English language) to enable production of a very high standard of commentary that is impactful and credible amongst our most senior audiences.
• Good commercial and operational instinct to ensure recommendations are practical and executable
• Well organized, self-sufficient and proactive: Best-in-class time management skills, ability to multitask, set priorities and plan
• Can-do, flexible attitude with resliance: Calmly able to respond to rapidally changing, urgent business priroties

Preferred candidate profile

• Highly organized and responsive, with ability to work to SLAs and tight deadlines
• Numerate thinker, good at data analysis with strong attention to detail
• Language skills - English fluent
• Excellent written and oral communication skills; proactively communicates using appropriate methods for situation and audience in clear, concise and professional manner
• Ability to work collaboratively and proactively with multi-functional teams
• Passion and commitment to high quality results
• Seeks to learn more about the PepsiCo business – commercially and operationally to inform recommendations
• Team player with a passion to be part of a high performing culture
• Be flexible, organized and able to handle competing priorities
• Displays trust, openness, transparency and “be vocal”
• Demonstrates inquisition to truly understand the task and the value it adds (vs transactional activity)