Analytics Insights Manager

at  PepsiCo

Responsibilities:

• Lead, update and own performance tracking to provide consistent and clear guide MU leadership and Senior Management on brand performance and business opportunities
• Competitive intellingence based on open sources and in-market results to inform commercial & NRM teams
• Category foreasting to support “cell x cell” H1 stratetgy and SOM target setting on yearly basis. Perform SOM growth sufficiency assessments on quarter / bi-months (to feed processes of ACP, AOP, MBR)
• Leverage existing data capabilities incl. PGM, PPD 2.0, Consumer Pulse, Landscapes, Macro-s to provide foresight and category outlook serving H2/H3 horizon to inform PSP, QSR, etc.
• Be familiar with statistical modeling, be able to run drivers analysis, correlation model, bi-variate, etc. based on retrospective trends to raise forecast robustness
• Updates / automate / optimize reporting processes based on external data incl. Nielsen, GlobalData, GfK HHP. Manage internal data lakes and own transition of reporting, data to - / -from reporting platforms (e.g. NIQ Discover)
• Lead process of performance deep-dive analyses to serve MBR and day to day business questions at brand, competitor, channel, customer level with aim to identify drivers and fix issues based on different Market data sources (Nielsen/Canadean/Shopper/Consumer/Internal Data). Setup x-function platform (MMR) for performance deep – dives connecting multiple perspectives serving PBR, MBR discussions. Update / maintain /own MU performance scorecards market KPIs for category x channels level that needs to be reported to BU.
• Vendor management. Lead data management process incl. specify LSA with external verndors based on frame contracts, manage transitions, service upgrades, data quality management.
• Provide analytical contribution to business-as-usual decision making process per Sales/Marketing/F&A business questions. Manage analytical projects that aim to deliver advanced analytics for everyday purpose.
• Based on developed best practice lead coaching and training process of Marketing, Finance, other Insights teams on research tools and techniques to ensure effective data usage
• Build Mktg teams Insights capabilities – support in driving data insights culture. Populate NIQ Discover platform. Work closely with Category leads on ad hoc analysis delivery in close cooperation with other business functions.
• Support ad hoc research agenda and analysis e.g. NRM consumer toolbox incl. PV studies, CBC, etc.
• Build and prepare regular updates of the PEP SOM targets and PEP SOM performance evauluation & BOY SOM calculations for both Snacks & Beverages categories (ans subcategories).

Qualifications:

• Strong analytical thinking with proven ability to connect data & insight from category consumption, brands drivers, macro & micro trends, and deliver clear outlook scenarios along with implications for the business
• Market insight technical expertise – experience and understanding across full breadth of market insight techniques – retail audit, consumer panels, loyalty data, market mix, trends, segmentation
• Bussiness acumen and ability to build actionable recommendations
• Forecasting and statistics
• Multitasking and responsive, proactive and curious
• Fluent English
• University degree
• Good relationship building and savvy communication skills

• Lead, update and own performance tracking to provide consistent and clear guide MU leadership and Senior Management on brand performance and business opportunities
• Competitive intellingence based on open sources and in-market results to inform commercial & NRM teams
• Category foreasting to support “cell x cell” H1 stratetgy and SOM target setting on yearly basis. Perform SOM growth sufficiency assessments on quarter / bi-months (to feed processes of ACP, AOP, MBR)
• Leverage existing data capabilities incl. PGM, PPD 2.0, Consumer Pulse, Landscapes, Macro-s to provide foresight and category outlook serving H2/H3 horizon to inform PSP, QSR, etc.
• Be familiar with statistical modeling, be able to run drivers analysis, correlation model, bi-variate, etc. based on retrospective trends to raise forecast robustness
• Updates / automate / optimize reporting processes based on external data incl. Nielsen, GlobalData, GfK HHP. Manage internal data lakes and own transition of reporting, data to - / -from reporting platforms (e.g. NIQ Discover)
• Lead process of performance deep-dive analyses to serve MBR and day to day business questions at brand, competitor, channel, customer level with aim to identify drivers and fix issues based on different Market data sources (Nielsen/Canadean/Shopper/Consumer/Internal Data). Setup x-function platform (MMR) for performance deep – dives connecting multiple perspectives serving PBR, MBR discussions. Update / maintain /own MU performance scorecards market KPIs for category x channels level that needs to be reported to BU.
• Vendor management. Lead data management process incl. specify LSA with external verndors based on frame contracts, manage transitions, service upgrades, data quality management.
• Provide analytical contribution to business-as-usual decision making process per Sales/Marketing/F&A business questions. Manage analytical projects that aim to deliver advanced analytics for everyday purpose.
• Based on developed best practice lead coaching and training process of Marketing, Finance, other Insights teams on research tools and techniques to ensure effective data usage
• Build Mktg teams Insights capabilities – support in driving data insights culture. Populate NIQ Discover platform. Work closely with Category leads on ad hoc analysis delivery in close cooperation with other business functions.
• Support ad hoc research agenda and analysis e.g. NRM consumer toolbox incl. PV studies, CBC, etc.
• Build and prepare regular updates of the PEP SOM targets and PEP SOM performance evauluation & BOY SOM calculations for both Snacks & Beverages categories (ans subcategories)