Consumer & Shopper Insights Analyst
PepsiCo · New Cairo
OverviewThe BI Insights Analyst role will work primarily with Egypt Teams on Snacks as a Businesses.
This includes connecting multiple data sources through curated metrics and developing calculated metrics to focus on the key outcome and diagnostic measures. A critical element of this role is complete working knowledge on Nielsen/Retail Zoom/Kantar World Panel databases and software.
This role will be focused on brand performance insights to fuel stronger, faster decisions for growth.
A candidate needs to have good knowledge of business insights, market research, excel and power point. Knowledge of Power BI is good to have.
Responsibilities
- Execute against team charter (SLA) for Insights Supervisor for Business Insights
- Execute market, portfolio, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools)
- Provide business performance explanations, incorporating considerations beyond data into the reporting
- Explain business performance, drivers, and optimization opportunities
- Provide responses to ad-hoc follow-ups when double-click (additional questions) required with tables/charts/stories using relevant data
- Recurring Tracker and Report maintenance
- Execute monthly and quarterly Reporting / Trackers
- Support adhoc requests, diagnostics from stakeholders
- Support building BI Capabilities
- Coordinate with Stakeholders and Automation teams in building new capabilities within the team
- Ensure project completion on time and subsequent adoption
- Stakeholder Management
- Build relationship and manage stakeholder expectation
- Engage stakeholders on key S&T initiative based on digital Transformation and productivity
Qualifications
- A mid-level Insight or Analytics professional with experience in a leading consumer goods company. 4 to 5 years+ experience
- Language: English Fluent
- Has a track record of identifying and championing new processes for improving fact-based decision making
- Can synthesize multiple, disparate data sources into compelling growth strategies. Formulates a strong POV and can articulate future scenarios and is an exceptional storyteller.
- Strong collaborator; Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets or brands; will be willing and able to embrace Responsive Ways of Working
- Can easily see how insights/research learning can improve businesses impact and frames up reporting efforts and opportunities to inform business decisions
- Proven analytics, shopper research experience, consumer insights experience or commercial experience in combination with strong analytical skills
- High degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen/IRi (POS and HH panel), GlobalData, Kantar, etc.
- Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually
- Proficient with PowerPoint and Excel; including ability to write complex formulas
- Experience with Tableau and PowerBI is good to have
- Operational experience from business servicing sector and/or consulting experience would be a plus
- Education: Bachelor’s or master’s degree in economics, math, marketing or management background
- Execute against team charter (SLA) for Insights Supervisor for Business Insights
- Execute market, portfolio, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools)
- Provide business performance explanations, incorporating considerations beyond data into the reporting
- Explain business performance, drivers, and optimization opportunities
- Provide responses to ad-hoc follow-ups when double-click (additional questions) required with tables/charts/stories using relevant data
- Recurring Tracker and Report maintenance
- Execute monthly and quarterly Reporting / Trackers
- Support adhoc requests, diagnostics from stakeholders
- Support building BI Capabilities
- Coordinate with Stakeholders and Automation teams in building new capabilities within the team
- Ensure project completion on time and subsequent adoption
- Stakeholder Management
- Build relationship and manage stakeholder expectation
- Engage stakeholders on key S&T initiative based on digital Transformation and productivity
- A mid-level Insight or Analytics professional with experience in a leading consumer goods company. 4 to 5 years+ experience
- Language: English Fluent
- Has a track record of identifying and championing new processes for improving fact-based decision making
- Can synthesize multiple, disparate data sources into compelling growth strategies. Formulates a strong POV and can articulate future scenarios and is an exceptional storyteller.
- Strong collaborator; Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets or brands; will be willing and able to embrace Responsive Ways of Working
- Can easily see how insights/research learning can improve businesses impact and frames up reporting efforts and opportunities to inform business decisions
- Proven analytics, shopper research experience, consumer insights experience or commercial experience in combination with strong analytical skills
- High degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen/IRi (POS and HH panel), GlobalData, Kantar, etc.
- Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually
- Proficient with PowerPoint and Excel; including ability to write complex formulas
- Experience with Tableau and PowerBI is good to have
- Operational experience from business servicing sector and/or consulting experience would be a plus
- Education: Bachelor’s or master’s degree in economics, math, marketing or management background