PepsiCo - Analyst - Insights Reporting

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