PepsiCo - Analyst - Insights Reporting (4-9 yrs)
Main Purpose :
Functional Responsibilities:
1. Execute against team charter (SLA) for Reporting & Analytics for AMESA
- Execute market, portfolio, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools)
- Execute market, portfolio and brand level reporting for Customer 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
- Monitor key channel, customer, competitor and emerging player performance and execute reporting at required intervals
- Provide responses to ad-hoc follow-ups when double-click (additional qustions) required with tables/charts/stories using relevant data
2. Support Reporting Lead/Sr.Managers/Managers delivering against information needs articularted by Business Partners; addressing business questions and process requirements
- Deliver against needs of stakeholders, requestors and end service users
- Support processes for output adherence and delivery to agreed scope in line with the agreed timelines, aligned templates and content management
- Responsible for managing multiple priorities; being able to manage deadlines and deliverables
- Monitor and act upon regular feedback inputs from end-users and Business Partners for deliverables
- Flag and monitor any business risks related to delivering the operational output (facilities, IT resources, recruitment efforts)
- Support communication processes with Reporting vertical leaders and Business Partners (project planning, workflow monitoring, quality checks, on-going changes)
- Help Reporting vertical leadership develop and finetune internal Center Of Excellence processes (work-flow mapping, pain-points and bottlenecks management) both related to service delivery and internal center operations
- Improve existing processes based on frequent end-user and Business Partner feedback loop
- SSC strategy delivery
- Provide essential data that supports the Hispanic Business growth roadmap, identify whitespaces to identify opportunities.
- Support the Hispanic Business Lead at GBS in Annual AOP or Situation assessments exercise
- Support simplification, standardization and digitalization efforts (in cooperation with global and sector stakeholders)
Key Skills/Experience Required :
- A junior/mid-level Insight or Analytics professional with experience in a leading consumer goods company. 4 years+ experience
- Education: MA in economics, math, marketing or management
- Language: English Fluent
- Can synthesize multiple, disparate data sources into compelling growth strategies. Formulates a strong POV and can articulate future scenarios and is an exceptional story-teller.
- 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
- Has a track record of identifying and championing new processes for improving fact-based decision making
- 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
- Operational experience from business servicing sector and/or consulting experience would be a plus
Differentiating Competencies Required :
Essential :
- Great stakeholder management skills
- Solution-oriented approach to problem solving
- Ability to identify and capitalize on opportunities to gain efficiencies and improve process & deliverables
- Depth and breadth of custom and syndicated research/analytics
- Strong understanding of internal & external data sources that could contribute to the reporting and analysis function
- Very strong analytical thinking with proven ability to connect data & insight from category consumption, brands drivers, macro & micro trends, and future forces of consumer change and deliver clear outlook scenarios along with implications for the business
Main Interactions Within & Outside Organization :
A. Internal :
- Service Center/Vertical Leads
- Business Partners: (Brand team members, regional sales team members, Sector Category team members)
Purpose :
- On-going deliverables, Best practices, capability building, economies of scale, simplification, digitization efforts
- Standard deliverables, key projects, business question needs
Frequency :
- Consistent interaction across the board
- Multiple daily interactions with internal
B. External :
- Research Agencies
- Data Providers
Purpose : Acquiring information, resolving service issues
Frequency : Less frequent with external