Senior Manager Net Revenue Management

PepsiCo; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

PepsiCo seeks an ICC - Revenue Growth Management Senior Analyst to drive analytics across pricing, promotions, assortment, and trade investments. You will aggregate data, harmonize datasets, and work with Market Cluster Leads to tailor outputs for diverse markets worldwide.

Responsibilities include developing advanced analytics, building insights for leadership, and expanding the RGM playbook with visualizations in Tableau/Power BI. Strong Excel and communication skills are essential.

Qualifications

• +7 years of experience in Retail Analytics/Category Management/Revenue Management.
• 2-3 years of experience with large data sets in CPG/Consulting/ICC.
• Experience in RGM lever practices- Pricing, Promo, Assortment, Trade Investment.
• Strong analytics skills with data viz tools (Tableau, Power BI).
• Strong Advanced Analytics acumen, Agile ways of working, data science exposure.
• Experience developing data-driven models for sales and marketing.
• Ability to manage multiple work streams under tight deadlines.
• Experience working with stakeholders across North America, LATAM, APAC, or EMEA (preferred).
• Excellent MS Excel skills and handling complex datasets.
• Clear communication in English for senior audiences.
• Bachelor’s in commerce/business/admin/Engg.; Master’s a plus.
• Best-in-class time management and multi-tasking.

Responsibilities

• Conduct data analyses across Pricing, Promotion, Assortment, and Trade Investment.
• Lead data aggregation and harmonization for RGM analytics.
• Collaborate with Market Cluster Leads to interpret market dynamics.
• Implement advanced analytics to derive Next Gen RGM insights.
• Create comprehensive insight summaries for RGM leadership.
• Standardize reporting and leverage technology to improve processes.
• Foster inclusive and collaborative work environments.
• Apply Advanced Analytics (Price Elasticity, Promotion Effectiveness) using Python, R, Tableau/Power BI.

Skills

Python

R

Tableau

Power BI

Excel

PowerPoint

Education

Bachelor's in commerce/business administration/Engineering

Master's degree (plus)

Tools

Alteryx

KNIME

Tableau

Power BI

Job description

Overview

ICC is a growing function within PepsiCo that leverages one strategy and common approach to introduce new, technology-driven capabilities and elevate service quality while meeting current and future business needs. PEP RGM is a key priority function where transformation, technology, strategy and capabilities enablement are aimed to be the best in class, and to be standardized and deployed globally. The vision is to develop playbook to develop analytic packs with insights across Brand Ladders, Channel PPA, In-Market Pack Price realization, Trade Investment Strategy, Promo ROI and Mix Management. This work will accelerate growth through efficient positioning across price tiers, optimized channel-based package types, right pricing, well directed commercial strategy and increase promotional ROI driven by enhanced and standardized insights.

This position will be part of the ICC - Revenue growth Management organization. This position contributes to the success of the company and contribute to growth through strategy development, and implementation of RGM frameworks. The incumbement will work for different markets across the globe and work with different stakeholders to develop RGM playbooks and ensure analytics execution

Functional Responsibilities

• ICC RGM Senior Analyst will be responsible for conducting data analyses across all RGM levers - Pricing, Promotion, Assortment Mix and Trade Investment
• Lead data aggregation and harmonization that will form the backbone of RGM analytics
• Collaborate with Market Cluster Leads to understand market dynamics and incorporate market feedback into analyses
• Bring out Next Gen Revenue Management insights by implementing advance analytics
• Integrate insights comprehensive summaries for RGM Tower Lead and RGM leader
• Improve understanding of pricing, promotions, pack architecture and trade investments through use of data analytic tools and visualization tools
• Improve processes of analyses and data management across category business units and marketing functions
• Develop observations/insights for each analysis in the RGM playbook and synthesize insights across analyses to create a storyline of opportunities
• Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology
• Create an inclusive and collaborative environment
• Adavanced Analytics – Price Elasticity, Promotion Effectiveness and knowledge of Python, R, Tableau/Power Bi

Key Activities

• Perform granular level analysis to identify growth opportunities
• Prepare data for the analyses to be performed (Data Pre-processing Tools – Alteryx/KNIME exp preferred)
• Understand the nuances of the product category and market to tailor the output according to business needs
• Run the analyses and create visualizations (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

Qualifications

• +7 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 / ICC Organizations
• Experience in any of the RGM lever practices- Pricing, Promo, Assortment, Trade Investment
• Strong analytics skills with expertise in data analytics and data visualization tools like Tableau, Power BI
• Strong Advanced Analytics acumen, Agile ways of working, managing high end data science
• 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.
• Experience working with stakeholders in North America, LATAM, APAC, or EMEA markets (preferred)
• 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 Tableau / Power Bi is preferred
• 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
• 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.
• Bachelor’s in commerce/business administration/Engg., Master’s degree is a plus
• Best-in-class time management skills, ability to multitask, set priorities and plan