Associate Analyst Business Intelligence & Reporting

Overview

Responsibilities

• Support Commercial function with performance reporting against established KPIs, including ad-hoc
• reporting requests using internal and shipment / POS data and market data systems (IRI)
• Power Bi skills - must have, Good to have - Python / R / modelling experience
• Functional Responsibilities
• Support Commercial function with performance reporting against established KPIs, including ad-hoc
• reporting requests using internal and shipment / POS data and market data systems (IRI)
• Power Bi skills - must have, Good to have - Python / R / modelling experience
• Develop on-demand reports and Scorecards delivering improved agility through ease of access and
• enhanced visualization
• Collate and format large and complex sets of data across multiple channels, customers and sales areas.
• Analyze data to distil meaningful insights on performance trends and opportunities
• Analyze key innovation or portfolio activity effectiveness to monitor return on investment and identify
• opportunities for improvement and customization by Channel, Brand, Customer and/or Market
• Assist with field sales execution and compliance reporting
• Present insights and recommendations to Sales Leadership team on a established time period and in a clear,
• concise manner
• Manage expectations through verbal and written interactions with headquarter partners
• Ensure delivery of accurate and timely data in accordance with agreed service level agreements (SLA)
• Work across multiple functions to aid in collecting insights for action-oriented cause of change analysis
• Ability to focus against speed of execution and quality of service delivery rather than achievement of SLAs
• Recognize opportunities and take action to improve delivery of work
• Implement continued improvements and simplifications of processes, standardization of reporting and
• optimal use of technology
• Create an inclusive and collaborative environment
  

Qualifications

• +5 years of experience in Data Analysis and Reporting.
• Bachelor’s in commerce/business administration/marketing or Finance, Master’s degree is a plus
• Prior Fast Moving Consumer Goods (FMCG) company experience required
• Development experience related to Data Analytics and Reporting including the usage of relevant tools and software packages (i.e Power BI)
• Strong hands on PowerBI (DAX calculations, Relationship building, Connecting to different various data sources)
• Requires a high level of analytical, critical thinking, and problem solving skills as well as great attention to detail
• Propensity to learn PepsiCo software systems
• Strong knowledge of MS Office programs specifically Excel, Power Point, and Access
• Ability to provide superior customer service
• Best-in-class time management skills, ability to multitask, set priorities and plan