Data Engineer

Overview:countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®, DORITOS ®, CHEETOS ®, GATORADE ®, PEPSI ®, QUAKER ® and more. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands that generate more than $1 billion each in estimated annual retail sales.Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability and human capital at the center of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people.Our employees drive our culture. No two days are the same; we are dynamic and full of passionate teams that embrace new ideas through our collaborative spirit. At PepsiCo, we know that ourcommitted to fostering a diverse workforce by creating a collaborative, equitable and inclusive space where everyone, regardless of what we look like, where we come from or who we love, has a voice. At PepsiCo we create a Space to be y( )u.**Responsibilities**:**Data Engineer (MBS)****Main Purpose**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:2) Develop ETL pipelines using python and Databricks to enable scalable, accurate, and resilient data processes and end-user tools.3) Partner with supply chain solutions team members to solve supply chain challenges by using analytic and data capabilities.4) Partner with Business Teams and Database Developers to collaborate and align on process and data architecture to achieve performant, reliable solutions.5) Diagnose, troubleshoot, and repair issues in existing ETL pipelines and tools.6) Support team with various ad-hoc requests including data analysis, tool troubleshooting, and end-user support**Accountabilities**- Develop ETL Pipelines, database tables, views, indexes to transform, prepare, and stage data for user facing tools, dashboards, and reports.- Work closely with other team members (business analysts, data engineers, Tableau and PowerBI developers) to collaborate, design, plan work, and develop complete business solutions.- Support team with ad-hoc analytics, tool troubleshooting, and support end-users directly to resolve tool issues.Thank you so much for thinking about PepsiCo to start or continue your careerQualifications:- 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**Non Technical Skills**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.