LD&T Data Engineer

Overview At PepsiCo, you’ll discover a place where our mission is to create smiles around the world. With a portfolio of more than 500 beloved brands including Gatorade, Lay’s and Quaker, our work touches millions of people every day.

At the heart of the company is a team of thinkers, creators, and problem-solvers who collaborate to innovate and turn ideas into action. Driven by innovation and a focus on creating joyful moments through food and drinks, our decisions are guided by consumer centricity, creating opportunities for our associates to do meaningful work and make a lasting impact in the communities we serve.

Whatever your role, you’ll be part of a global community that values your ideas and empowers you to make an impact on your career and on the world around you. Responsibilities We are seeking a highly skilled Data Engineer with a strong technical foundation to design, build, and optimize the data infrastructure that powers business insights and automation across the organization.

In this role, you will develop and maintain robust ETL/ELT pipelines, transform raw data into clean and reliable datasets, and enable self-service analytics for stakeholders. You will work extensively with SQL and Python to extract, clean, and model large volumes of data, while leveraging cloud platforms to build scalable, cost-efficient solutions. The ideal candidate is passionate about data quality, thrives on automating manual processes through RPA and scripting, and enjoys partnering with business teams to translate their needs into actionable dashboards and reports using tools such as Power BI and Tableau. This is a hands-on, technically focused position for someone who is comfortable owning the full data lifecycle, from ingestion and cleaning through to modeling, automation, and visualization.

Design, develop, and maintain scalable ETL/ELT pipelines to ingest data from diverse source systems into cloud data warehouses and lakes. Write, optimize, and troubleshoot complex SQL queries and Python scripts to extract, clean, transform, and model large datasets. Perform data cleaning, validation, and quality checks to ensure the accuracy, consistency, and reliability of downstream reporting and analytics. Build and maintain automated workflows using RPA tools and scripting to streamline repetitive business processes and reduce manual effort. Deploy and manage data solutions on cloud platforms (e.g., Azure, AWS, or GCP), optimizing for performance, scalability, and cost. Develop and maintain interactive dashboards and reports in Power BI and/or Tableau to deliver actionable business insights. Collaborate with business stakeholders, analysts, and cross-functional teams to gather requirements and translate them into technical solutions. Document data pipelines, data models, and processes, and follow best practices for version control, testing, and monitoring.

The expected compensation range for this position is between $73,400 - $122,850. Location, confirmed job-related skills, experience, and education will be considered in setting actual starting salary. Your recruiter can share more about the specific salary range during the hiring process. Bonus based on performance and eligibility target payout is 5% of annual salary paid out annually. Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement. In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility: Medical, Dental, Vision, Disability, Health, and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan.

Bachelor's degree (required) in Computer Science, Information Systems, Engineering, Data Science, or a related field, or equivalent practical experience. 3+