Data Engineering Lead

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.

Know more: PepsiCoJobs

Join PepsiCo, dare for better.

The Opportunity

The Development Lead will lead a team of Software Engineers and Database Developers in the execution of several projects; as well as, collaborating with a team of data analysts, data engineers, and visualization developers to produce simpler, faster, and more insightful solutions for supply chain performance managers, decision makers, specialists and frontline personnel.

Your Impact

As Data Lead your responsibilities would consist of:

The Development Lead’s primary responsibilities include:

1. Provide technical expertise and mentorship, guiding the team in data modeling, database design, and development processes. Collaborate with team members to create, enhance, and maintain business-owned dashboards, ETL processes, reports, tools, and custom web applications.
2. Lead the design and construction of new MS SQL Server and Oracle database objects, ensuring efficient data storage and retrieval. Oversee the implementation of database solutions, ETL processes, and web tools, ensuring alignment with project requirements and scalability for future needs.
3. Collaborate with cross-functional teams to plan, execute, and deliver technological solutions within established timelines and quality standards. Act as a liaison between technical teams and business stakeholders, fostering transparent communication and meeting project objectives.
4. Identify opportunities for process improvement within the development lifecycle, implementing best practices and standardized workflows. Promote a culture of continuous improvement, encouraging feedback, and adapting development processes based on lessons learned and industry trends.

¿Who Are We Looking For?

Experience required:

1. Fluent in English
2. Bachelor’s degree or equivalent work experience in business systems or information technology
3. 2+ years of relational database development experience (MS SQL Server or Oracle preferred)
4. Advanced SQL skills
5. 2+ years of experience in optimizing database performance
6. Ability to translate business requirements or business process descriptions into data relationships suggested database objects, and recommended supportive database functionality (e.g., stored procedures, indexes, triggers, etc.)
7. 2+ years of working with uses and general best practices of stored procedures, indexes, functions, views, and triggers.
8. 1+ years of experience creating or executing ETL processes is a plus
9. Experience with JSON is a plus
10. Experience with Python, JavaScript, or other programming language(s) is a plus.
11. Experience with Tableau and/or PowerBI is a plus
12. Knowledge of Databricks is a plus

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:

1. Opportunities to learn and develop every day through a wide range of programs.
2. Internal digital platforms that promote self-learning.
3. Development programs according to Leadership skills.
4. Specialized training according to the role.
5. Learning experiences with internal and external providers.
6. We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.
7. Financial wellness programs that will help you reach your goals in all stages of life.
8. A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.
9. 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.