Finance Data Engineer & Analyst

PepsiCo Deutschland GmbH; Ciudad de México; Presencial; USD 25,000 - 40,000; Jornada completa

Descripción de la vacante

Join PepsiCo as a Data Engineer & Analyst, where you will support the Mosaic tool, enhancing financial data quality for leadership. Work closely with various teams to resolve data issues, ensure compliance, and maintain data integrity. Enjoy opportunities for development and flexible working arrangements in a diverse environment.

Servicios

Flexible working arrangements

Recognition programs

Financial wellness programs

Specialized training

Opportunities for self-learning

Benefits for family

Formación

• At least 1 year of work experience.
• Experience in Azure environment.
• Ability to structure complex concepts simply.

Responsabilidades

• Resolve data issues and optimize data flow.
• Collaborate with cross-functional teams.
• Build and maintain resilient data pipelines.

Conocimientos

Data engineering

ETL development

Data analysis

Fluency in English

Herramientas

Azure Data Factory

SQL

Python

Azure Databricks

Spark

TM1

Descripción del empleo

Overview

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.

Know more: PepsiCoJobs

Join PepsiCo, dare for better.

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.

Your Impact:

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?

• 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

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.
• Recognition programs for seniority, behavior, leadership, and life moments.
• Financial wellness programs to help reach your goals.
• Flexible working arrangements to balance personal and work life.
• Benefits for your family, including Wellness Line, discounts, scholarship programs, and aid plans.

We are an equal opportunity employer and value diversity. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability. We respect and value diversity as a workforce and source of innovation.