Lead Data Engineer

Overview Are you ready to drive PepsiCo’s digital evolution and accelerate transformation across our global operations? We are seeking a highly skilled and experienced Azure Data Engineer to join our dynamic team. In this critical role, you will be responsible for designing, developing, and maintaining robust and scalable data solutions on the Microsoft Azure platform. You will work closely with data scientists, analysts, and business stakeholders to translate business requirements into effective data pipelines and data models. Responsibilities Your day-to-day with us * Design, develop, and implement data pipelines and ETL/ELT processes using Azure Data Factory, Azure Databricks, and other relevant Azure services. * Develop and maintain data lakes and data warehouses on Azure, including Azure Data Lake Storage Gen2 and Azure Synapse Analytics. * Build and optimize data models for data warehousing, data marts, and data lakes. * Develop and implement data quality checks and data governance processes. * Troubleshoot and resolve data-related issues. * Collaborate with data scientists and analysts to support data exploration and analysis. * Stay current with the latest advancements in cloud computing and data engineering technologies. * Mentor junior data engineers and contribute to the development of best practices. * Participate in all phases of the software development lifecycle, from requirements gathering to deployment and maintenance. Qualifications What you will need to succeed Education * Bachelor's degree in Computer Science, Engineering, or a related field (Master's degree preferred). Experience * 10+ years of experience in data engineering, with at least 5 years of experience working with Azure data services. * Strong proficiency in SQL, Python, and other relevant programming languages. * Experience with data warehousing and data lake architectures. * Experience with ETL/ELT tools and technologies, such as Azure Data Factory, Azure Databricks, and Apache Spark. * Experience with data modeling and data warehousing concepts. * Experience with data quality and data governance best practices. * Strong analytical and problem-solving skills. * Excellent communication and collaboration skills. * Experience with Agile development methodologies. * Relevant Azure certifications (e.g., Azure Data Engineer Associate) are 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 makes us different? Hybrid work model: combination of remote and collaborative office experience to enable innovation Entrepreneurial environment in leading international company Professional growth possibilities & learning opportunities Variety of benefits to support your physical, emotional and financial wellbeing Volunteering opportunities to help external communities Diverse team with more than 30% of female representation & over 30 nationalities Have a stake in D&I strategy and bring your whole self to work About PepsiCo We believe that culture should be at the cornerstone of everything we do at PepsiCo. We are agile, innovative and not afraid of failure. We want our team to come to work every day excited to explore new ways to bring enjoyment, refreshment and fun to the world. PepsiCo Positive (pep+) is the future of our organization – a strategic end-to-end transformation, with sustainability at the center of how we will create growth and value by operating within planetary boundaries and inspiring positive change for the planet and people. So, if you’re ready to be a part of a playground for those who think big, we’d love to chat. *We encourage the diversity of applicants across gender, age, ethnicity, nationality, sexual orientation, social background, religion or belief and disability #LI-Hybrid


Your day-to-day with us * Design, develop, and implement data pipelines and ETL/ELT processes using Azure Data Factory, Azure Databricks, and other relevant Azure services. * Develop and maintain data lakes and data warehouses on Azure, including Azure Data Lake Storage Gen2 and Azure Synapse Analytics. * Build and optimize data models for data warehousing, data marts, and data lakes. * Develop and implement data quality checks and data governance processes. * Troubleshoot and resolve data-related issues. * Collaborate with data scientists and analysts to support data exploration and analysis. * Stay current with the latest advancements in cloud computing and data engineering technologies. * Mentor junior data engineers and contribute to the development of best practices. * Participate in all phases of the software development lifecycle, from requirements gathering to deployment and maintenance.


What you will need to succeed Education * Bachelor's degree in Computer Science, Engineering, or a related field (Master's degree preferred). Experience * 10+ years of experience in data engineering, with at least 5 years of experience working with Azure data services. * Strong proficiency in SQL, Python, and other relevant programming languages. * Experience with data warehousing and data lake architectures. * Experience with ETL/ELT tools and technologies, such as Azure Data Factory, Azure Databricks, and Apache Spark. * Experience with data modeling and data warehousing concepts. * Experience with data quality and data governance best practices. * Strong analytical and problem-solving skills. * Excellent communication and collaboration skills. * Experience with Agile development methodologies. * Relevant Azure certifications (e.g., Azure Data Engineer Associate) are 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 makes us different? Hybrid work model: combination of remote and collaborative office experience to enable innovation Entrepreneurial environment in leading international company Professional growth possibilities & learning opportunities Variety of benefits to support your physical, emotional and financial wellbeing Volunteering opportunities to help external communities Diverse team with more than 30% of female representation & over 30 nationalities Have a stake in D&I strategy and bring your whole self to work About PepsiCo We believe that culture should be at the cornerstone of everything we do at PepsiCo. We are agile, innovative and not afraid of failure. We want our team to come to work every day excited to explore new ways to bring enjoyment, refreshment and fun to the world. PepsiCo Positive (pep+) is the future of our organization – a strategic end-to-end transformation, with sustainability at the center of how we will create growth and value by operating within planetary boundaries and inspiring positive change for the planet and people. So, if you’re ready to be a part of a playground for those who think big, we’d love to chat. *We encourage the diversity of applicants across gender, age, ethnicity, nationality, sexual orientation, social background, religion or belief and disability #LI-Hybrid