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 impactDevelopment of pricing strategies for recommendationsSupport 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 & competitorsMaintain database pack P&L model of each market and run simulation when requiredLiaise 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-starterStrong analytical & numerical skillsEffective problem-solving skills to devise solutions to drive profitability and support revenue and market share goalsFinancial modelling - P&L simulations; applying financial data to consumer research findings and output Diligent and attention to detailsGood 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