Revenue Management Analyst

Responsibilities Support BU RM Lead on Pricing, Pack Price, Mix and Trade Spend analysis and recommendations for AOP, three-year pricing roadmap, ad-hoc projects e.g. playbook, sugar tax, competition tactical moves, etc. Data gathering from variety sources – internal and external (desk research, syndicated data, competition, etc.) Perform analyses – market trends, key observations, translating complex data into insights Formulate hypothesis & options for pursuing to ensure competitive position in marketplace – formulate volume, revenue, profit, share change impact Development of pricing strategies for recommendations Support BU RM Promo Spend analysis Analyze consumer promotion effectiveness by product, customer for MT / eCom channel eg. Which consumer promotions result in best Lift? Analyze ROI of trade spends by product, market eg. Are there overall country level optimization opportunities by better allocating regional/area budgets? Which type of trade promotion works best for different products/markets? Develop view-point on elasticity of volume to changes in RCP, Trade Spend, ND, etc. by product, market: Is there a positive trade-off that we can make for particular product, market? Develop profitability waterfall at granular level that can be rolled up as required: Are there zones / areas / districts that have lower revenue realization compared to similar geographies? Why? Support BU RM Lead on monthly Pricing Council and quarterly Pricing Governance reporting Support VP RM on monthly RM reporting scorecard Support VP RM on implementation of analytics dashboard – including design & UAT, maintaining database update for RM analytics Track pack performance of PEP & Competitors e.g. MENA FOBO has 17 markets, each with either Nielsen or Canadean data – CSD & LRB Maintain database of each market pack price mix line up of PEP & competitors Maintain database pack P&L model of each market and run simulation when required Liaise with agency , Finance, & Transformation team for automation project Qualifications Specific education/certification, specific functional experience, language etc NEEDED for the job. Please note that this is not necessarily the incumbent’s personal background. Finance or Business degree Consulting background preferred with FMCG projects exposure or 3-year pricing experience Insightful, focused on the big picture, team player, strong communication skills, well-organized, self-starter. Strong analytical & numerical skills Advance excel and power point (advanced/master level) Advanced knowledge of SQL, PowerBI to be able to analyze and solve for complex hypotheses using multiple data sources. Data Science – Basic/Intermediate Effective problem-solving skills to devise solutions to drive profitability and support revenue and market share goals. Financial modelling – P&L simulations; applying financial data to consumer research findings and output Diligent and attention to details Good story telling and ability to articulate analyses in a clear & concise manner. Main interactions within & outside organization / External & Internal Environmental Factors – Key job roles both internally and externally that the job-holder interacts with on a daily, weekly, monthly basis. What is the nature of the interaction? What are the complexities of the environment in which this position exists? Internally – BU RM Lead and Sector VP Externally, project-based interactions with Bottlers/Franchise partners and Research vendors/agencies Comments – key challenges/unique aspects of the position, for example, what is the most difficult challenge for the role over the next 12 months? Change of organization structure and new ways of working Work remotely with minimal knowledge about the markets and businesses Multiple projects – ability to multitasks, delivering on time with good quality work