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.

PepsiCo México: 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 Database Developer will operate within a team of other database developers, data analysts, data engineers, and software engineers to produce simpler, faster, and more insightful solutions for supply chain performance managers, decision makers, specialists and frontline personnel.

The Data Engineer's primary responsibilities include:

• Apply your data modeling, database design and database development skills in collaborative manner to help the team create, maintain, monitor, and/or improve business owned dashboards, ETL processes, reports, tools, and custom web applications.
• Design and construct new MS SQL Server and Oracle database objects that enable efficient storage and retrieval of data.
• Help identify and resolve inefficiencies in team and application MS SQL Server and Oracle databases, Tableau/PowerBI dashboard extracts and queries, and ETL database operations.
• Translate Business/User requirements into conceptual database designs.

Your Impact

As a Data Engineer (Database Developer) your responsibilities would consist of

• Develop database tables, stored procedures, indexes, functions, views, and triggers as necessary to achieve efficient input/output of data to Frito Lay North America business team User facing apps, tools, dashboards, and reports
• Ensure database operations are producing complete and accurate data stories and results for business decision making Users
• Work closely with web developers, dashboard developers, reporting analysts, and data engineers to understand and construct as necessary the data functionality (algorithms), structure, and speed requirements needed to produce positive User experiences
• Proactively monitor database health, table data freshness, slow performing or high memory usage queries/stored procedures, storage constraints, memory constraints, dormant tables, missing or un-used indexes
• Connect and Collaborate with IT DBAs to identify opportunities to enhance our database capabilities (database upgrades, configuration changes, new functionality, etc.) and reliability (e.g., back-ups, test environment, up-time, etc.)

Qualifications

Who Are We Looking For?

• Fluent in English
• 1+ years of relational database development experience (MS SQL Server or Oracle preferred)
• Intermediate/Advanced SQL and Python skills
• Experience in optimizing database performance
• 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.)
• Understanding the uses and general best practices of stored procedures, indexes, functions, views, and triggers.
• Experience creating or executing ETL processes

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.