- 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
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