The key purpose of this position is to support the advanced analytics needs of the business. The position will mainly be responsible for providing a solid understanding of the base business sales drivers including pricing, promotion & consumption forecasts to the Juices, Malt Beverages and Cordial categories.

This would require regular interaction with brand, shopper marketing, bottlers, finance, IBP and country sales teams.

Specifically, the following will be the key focus areas for Analytics Manager:

• Market Mix Modeling (MMM) / Planning & ROI
• Business Drivers: Due-to’s and Forecasting
• Strategic Pricing
• Reporting and maintaining scorecard
• Social listening analysis
• Agency Management

Market Mix Modeling (MMM) / Planning & ROI

• Independently manage multiple Marketing Mix Modeling projects which are identified as key category priorities. Details on Project Management needs listed in Appendix.
• Provide regular MMM training support
• Prepare & present regular category ROI reports to the marketing and sales team

Business Drivers: Due-to’s and Forecasting

• Continuously improve category and brand evaluation and forecasting (Due-Tos).
• Provide forecasting models framework and thought leadership for key brands; leveraging insights from these models to drive growth.
• Recommend options for spend optimization changes to mitigate NR and Volume plan risk through better diagnoses of historical performance drivers and forecasting multiple scenarios
• Update Portfolio distortion planning analysis to support Category Insights to address questions on marketing spending allocation.

Reporting and maintaining scorecards

• Manage Reporting and maintaining scorecard needs for all categories. Provide regular updates, which would require complete ownership of the process of compiling & aligning inputs from all relevant cross functional stakeholders (Insights, Marketing, Finance and Sales)
• Be the lead on Aujan’s data intel interface and ensure data & insights accuracy on the platform.
• Lead social media analytics to highlight new trends, opportunities and concerns (if any) on a monthly or quarterly basis

Requirements:

• Bachelor’s or Master’s Degree in Social Science, Business Administration, Marketing or Statistics
• Min 5-6 years working experience in marketing research, Advanced Analytics preferably at an CPG or a FMCG company and/or 2 years in forecasting/business planning in increasing responsibility positions
• Training: Statistical modelling, Nielsen data
• High analytical skills and wisdom/judgement to evaluate and improve delivery
• Strong knowledge of advanced analytics methods (Marketing Mix Econometric modelling, forecasting simulators)
• Able to understand how to apply marketing mix modelling and ROI learning
• Experience in working with advanced statistics
• Strong knowledge of information sources such as Nielsen, IRI, Euromonitor, HH Panel, Financials, Internal Shipments, and media databases