Revenue Mgmt._FP&A_Assoc. Manager

Job description

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

·  Finance or Business degree
·  Consulting background preferred with FMCG projects exposure or 2 year pricing experience
·  Insightful, focused on the big picture, team player, strong communication skills, well-organized, self-starter
·  Strong analytical & numerical skills
·  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
·  Strong excel and power point (advanced/master level)
·  Advanced knowledge of SQL, Tableau to be able to analyze and solve for complex hypotheses using multiple data sources