Commercial Reporting Analyst Jr

Overview:
**We Are PepsiCo**

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 y( )u.

**Join PepsiCo, dare to transform.**

**Responsibilities**:
**Commercial Reporting Analyst Jr**

**Main purpose**

The Role of Commercial reporting Analyst has the objective of supporting Latinamerica sales business teams by creating, executing, and populating the information related to the commercial area with standards reports and BI tools.

Point of contact between the business and the technology teams as troubleshooting for any data or performance issues.

As the Commercial Reporting Analyst, it will be necessary to work through requirements gathering with functional teams of Latam Sales Team, being able to document needs, manage themselves with setting appropriate activities.

**Your Impact**

As The Commercial Reporting Analyst Jr your scope will consist of:

- Capable to analyze a request or issue and provide a solution either with existing reporting tools or by enhancing new functionalities.
- Able to optimize process by leveraging best practices
- Establish process to identify, track, escalate, resolve, and report customer problems
- Participate in fine tuning activities to improve performance and/or ensure the SLA
- Participate the continues improvements meeting
- Responsible of Business Intelligence functional specs documents and the assessment of the project.
- Execute reports according to SLAs (Service level agreement)

Qualifications:
**Who Are We Looking For?**
- Bachellor’s, Associate or Technical degree in progress. Accounting, Business Administration, Data and Analytics, Computer Science or similar. Engineering if posible.
- No professional experience requiered
- Understanding of Business analytics and reporting tools (Tableau, SAP Business Objects, MicroStrategy, Oracle, teradata etc.)
- Expertise using different source systems of data like SAP/BW, Teradata, EDW, Flat files etc.
- Advanced skills on Microsoft Excel
- Intermediate skills on Power BI
- Knowledge of data governance models and Customer/Material hierarchies (desirable)
- Knowledge on creating dynamics Dashboards and Reports at different levels of details. Desirable using the PepsiCo standards reporting tools (e.g. Tableau, Business Objects, MicroStrategy, etc.)
- Basic/intermediate English

We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.