OverviewFSV R&A Role will be responsible for providing data and analytics including data acquisition and validation, as well as interpretation of the results.
This role also provides meaningful insights and recommendations to the Sales Leadership team. Process levels will include Brand Optimization, Asset Fill Level Analysis, Activate New Cash Discount Assets, Remove Inactive Products from POG Sets, Eliminate Single Facings from GFV, Create focus brand distribution tracker, mech rate/vend price analysis, reporting, contract detail report and Topline/Operational metric analysis
ResponsibilitiesFunctional 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
