Business Reporting Data Analyst

Overview:
PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®, DORITOS ®, CHEETOS ®, GATORADE ®, PEPSI ®, QUAKER ® and more. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands that generate more than $1 billion each in estimated annual retail sales.

Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability and human capital at the center of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people.

Our employees drive our culture. No two days are the same; we are dynamic and full of passionate teams that embrace new ideas through our collaborative spirit. At PepsiCo, we know that our company can only succeed when our associates and the society we serve flourishes. We are committed to fostering a diverse workforce by creating a collaborative, equitable and inclusive space where everyone, regardless of what we look like, where we come from or who we love, has a voice. At PepsiCo we create a Space to be you.

**Business Reporting Data Analyst**:
**Main Purpose**

This role ensure exceptional operational services are provided by his/her organization to sales employees across multiple teams and markets. The services for the supported teams include; providing analytically based diagnostic reporting of actual service and delivery metrics vs. pre-determined standards, preparing executive summaries of results for internal and external audiences, and support leadership with adhoc analysis and data requests. Continuously identify opportunities and implement processes to improve quality and timeliness of output.

**Responsibilities**:
**Accountabilities**
- Support the team function with performance reporting against established KPIs, including ad-hoc reporting requests using internal and shipment / POS data and market data systems (IRI)
- 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
- 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:
**Qualifications**
- Minimum 2 years of experience in managing data is a must.
- Bachelor’s degreed is required
- Prior Fast Moving Consumer Goods (FMCG) company experience required
- Experience in PowerBI is required
- SQL knowledge is required
- Strong knowledge of MS Office programs specifically Excel.

If you have the profile that we are looking, send us your CV by this via, if it's possible that you can participate in this process we will contact you ASAP, if not we will keep your info in our base data for 6 months.

**Thank you so much for your interest in PepsiCo