Finance Data Engineer & Analyst

Overview

We Are PepsiCo

Join PepsiCo and Dare for Better! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place.

Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries.

Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years.

A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world.

Responsibilities

The Opportunity:

The Data Engineer & Analyst will play a critical role in the success of the Mosaic (global planning tool). Mosaic is transforming the way FP&A teams work across PepsiCo markets by enhancing the availability and quality of financial data for senior leadership.

This role is responsible for live market support, focusing on resolving data issues, ensuring data quality, and optimizing data flow within the system. The candidate will provide guidance on data sources, system connectivity, and data transformation logic while conducting root cause analysis and deploying solutions. Additionally, they will assist local teams in preparing their data for Mosaic, ensuring compliance with Data Quality Rules (DQRs) and SPOT standards.

The role requires close collaboration with IT/BRM, Sector FP&A, the Cockpit team, and other functional teams, including Net Revenue Management, Global Procurement, Coman, and Supply Chain.

Live Market Support & Data Quality

• Develop expertise in Mosaic data, including setup, sources, transformation, and user consumption.
• Perform root cause analysis and deploy ETL/data transformation solutions.
• Validate data pipelines to maintain integrity and align with business needs.
• Troubleshoot tools, conduct ad-hoc analytics, and support end-users.
• Ensure compliance with Data Quality Rules (DQRs) and resolve flagged issues.
• Guide Business Units (BU) in achieving SPOT readiness.

Sustainable Data Solutions & Documentation

• Collaborate with cross-functional teams to implement end-to-end data solutions.
• Maintain documentation for ETL processes and best practices.
• Build resilient data pipelines with proactive monitoring and alerts.
• Standardize master data setup with the Global Mosaic Data team.
• Create user guides and documentation for common data issues.

Qualifications

Who Are We Looking For?

Experience

• At least 1 year of work experience
• Fluent in English
• Experience in data engineering and ETL development in Azure environment (Python Spark, Azure Databricks, Azure Data Factory, SQL, or TM1)
• Familiarity with technical database structures and hierarchy as well as ability to structure highly complex concepts into simple execution
• Experience with data engineering/analysis

If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements.

What can you expect from us:

• Opportunities to learn and develop every day through a wide range of programs.
• Internal digital platforms that promote self-learning.
• Development programs according to Leadership skills.
• Specialized training according to the role.
• Learning experiences with internal and external providers.
• We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.
• Financial wellness programs that will help you reach your goals in all stages of life.
• A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.
• And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.

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.