Data Engineer

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. Know more: PepsiCoJobs Join PepsiCo, dare for better. Responsibilities The Opportunity The Data Engineer will operate within a team of 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. Data Engineer’s primary responsibilities include: Apply your ETL and data transformation skills to help the team create, maintain, monitor, and/or improve business owned dashboards, ETL processes, reports, tools, and custom web applications. Develop ETL pipelines using python and Databricks to enable scalable, accurate, and resilient data processes and end-user tools. Partner with supply chain solutions team members to solve supply chain challenges by using analytic and data capabilities. Partner with Business Teams and Database Developers to collaborate and align on process and data architecture to achieve performant, reliable solutions. Diagnose, troubleshoot, and repair issues in existing ETL pipelines and tools. Support team with various ad-hoc requests including data analysis, tool troubleshooting, and end-user support. Your Impact As Data Engineer your responsibilities would consist of: Develop ETL Pipelines, database tables, views, indexes to transform, prepare, and stage data for user facing tools, dashboards, and reports. Perform data validation to ensure data pipelines meet specications for the business applications. Work closely with other team members (business analysts, data engineers, Tableau and PowerBI developers) to collaborate, design, plan work, and develop complete business solutions. Develop resilient data processes which include failure email notification and detailed logging. Proactively monitor deployed ETL pipelines and resolve issues when failures or issues arise. Support team with ad-hoc analytics, tool troubleshooting, and support end-users directly to resolve tool issues. Qualifications ¿Who Are We Looking For? Key sills and experience required: Fluent in English Bachelor’s degree or equivalent work experience in business systems or information technology 1+ years of data engineering and ETL experience Advanced SQL skills Moderate Python programming skills Experience in using common ETL patterns to process data. Understands best practices and pitfalls of various ETL methods. Ability to translate business requirements or ideas into data architecture and data process design. Experience in designing and creating database tables, indexes, and views to utilize in ETL processes. Familiarity with supply chain or logistics analytics is a plus Familiarity with Azure Databricks, PySpark, or Azure Data Factory is a plus Experience with Tableau and/or PowerBI is a plus Familiarity with web development and other programming language(s) is a plus Competencies required: Excellent communication skills with the ability to translate business needs into IT requirements. Our team values curiosity, creativity, collaboration, and a love for the end-user to rapidly deliver breakthrough solutions that our Users will enjoy using. 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.


The Opportunity The Data Engineer will operate within a team of 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. Data Engineer’s primary responsibilities include: Apply your ETL and data transformation skills to help the team create, maintain, monitor, and/or improve business owned dashboards, ETL processes, reports, tools, and custom web applications. Develop ETL pipelines using python and Databricks to enable scalable, accurate, and resilient data processes and end-user tools. Partner with supply chain solutions team members to solve supply chain challenges by using analytic and data capabilities. Partner with Business Teams and Database Developers to collaborate and align on process and data architecture to achieve performant, reliable solutions. Diagnose, troubleshoot, and repair issues in existing ETL pipelines and tools. Support team with various ad-hoc requests including data analysis, tool troubleshooting, and end-user support. Your Impact As Data Engineer your responsibilities would consist of: Develop ETL Pipelines, database tables, views, indexes to transform, prepare, and stage data for user facing tools, dashboards, and reports. Perform data validation to ensure data pipelines meet specications for the business applications. Work closely with other team members (business analysts, data engineers, Tableau and PowerBI developers) to collaborate, design, plan work, and develop complete business solutions. Develop resilient data processes which include failure email notification and detailed logging. Proactively monitor deployed ETL pipelines and resolve issues when failures or issues arise. Support team with ad-hoc analytics, tool troubleshooting, and support end-users directly to resolve tool issues.


¿Who Are We Looking For? Key sills and experience required: Fluent in English Bachelor’s degree or equivalent work experience in business systems or information technology 1+ years of data engineering and ETL experience Advanced SQL skills Moderate Python programming skills Experience in using common ETL patterns to process data. Understands best practices and pitfalls of various ETL methods. Ability to translate business requirements or ideas into data architecture and data process design. Experience in designing and creating database tables, indexes, and views to utilize in ETL processes. Familiarity with supply chain or logistics analytics is a plus Familiarity with Azure Databricks, PySpark, or Azure Data Factory is a plus Experience with Tableau and/or PowerBI is a plus Familiarity with web development and other programming language(s) is a plus Competencies required: Excellent communication skills with the ability to translate business needs into IT requirements. Our team values curiosity, creativity, collaboration, and a love for the end-user to rapidly deliver breakthrough solutions that our Users will enjoy using. 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.