Job Description

Overview:The Insights Reporting Analyst\xe2\x80\x99s role will work primarily with \xe2\x80\x9cInternational Beverage Group\xe2\x80\x9d where his/her role will be focused on enhancing and automating business reporting to fuel stronger, faster business performance insight for IBG Marketing and Insights teams. 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 to manage the in scope delivery of the work.The role\xe2\x80\x99s scope is to manage the IBG scorecards.The role will have short-term responsibilities for knowledge transfer from the business and effectively establishing business process and communication methods with teams they support; both are crucial requirements to enabling the organization to deliver answers to on-going business questions. Responsibilities:Functional Responsibilities:

• Execute against team charter (SLA) for Reporting & Analytics for PBNA

• 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
• 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 \xe2\x80\x93 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)

Qualifications:\xc2\xb7 A junior/mid-level Insight or Analytics professional with experience in a leading consumer goods company. 4 years+ experience\xc2\xb7 Education: MA in economics, math, marketing or management\xc2\xb7 Launguage: English Fluent\xc2\xb7 Potential to develop leadership and influencing profile in line with Insights Leader of the future definition: Motivates action through fact-based, inspirational material\xc2\xb7 Has a track record of identifying and championing new processes for improving fact-based decision making\xc2\xb7 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.\xc2\xb7 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\xc2\xb7 Can easily see how insights/research learning can improve businesses impact and frames up reporting efforts and opportunities to inform business decisions\xc2\xb7 Proven analytics, shopper research experience, consumer insights experience or commercial experience in combination with strong analytical skills\xc2\xb7 High degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen/IRi (POS and HH panel), GlobalData, Kantar, etc.\xc2\xb7 Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually\xc2\xb7 Able to lead a small team and coach team members\xc2\xb7 Proficient with PowerPoint and Excel; including ability to write complex formulas\xc2\xb7 Experience with Tableau and PowerBI will be a plus\xc2\xb7 Operational experience from business servicing sector and/or consulting experience would be a plu\\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

PepsiCo