Overview The PBNA Insights Assistant Analyst’s role will work primarily with Brand Insights & Analytics Team where his/her role will be focused on driving PBNA Sector level priorities, understanding existing scorecards, enhancing and automating business reporting to fuel stronger, faster and better performance insights for the PBNA Brand Insights Team. The role will have responsibilities to deliver projects end to end with 100% Quality, timeliness. Stitching story together from Business Analytics and Consumer Insights 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 be able to deliver value-add insights and strategic presentation focused around future Growth for PepsiCo in an agile manner. The role will have short-term responsibilities of understanding the tools/methodology and multiple data sources which will enable him/her to effectively support the stakeholders and deliver answers to on-going business questions. The role’s scope is covers Energy Category for the brand Rockstar. Responsibilities Execute against team charter (SLA) for Reporting & Analytics for PBNA Creating holistic brand performance view by Analysing work from Retail performance and integrating it with Consumer Insights. (Retail (Panel+POS) :-Expert level) & Consumer: Brand Equity (Beginer level) Drive Insights for Team and execute market, Brand, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools) Execute market, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools) Execute market, 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 questions) required with tables/charts/stories using relevant data Support Reporting Lead/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 Work on building the roadmap of Business growth, identify whitespaces to identify opportunitities Support in Annual AOP or Situation assessments exercise or Leadership Reporting Support simplification, standardization and digitalization efforts (in cooperation with global and sector stakeholders) Qualifications A junior/mid-level Insight or Analytics professional with experience in a leading consumer goods company. 4 years+ experience Education: Masters/Graduate in Economics, Mathematics, Marketing or Management Language: Fluent English Potential to develop leadership and influencing profile in line with Insights Leader of the future definition: Motivates action through fact-based, inspirational material 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 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 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, Zappi 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