LD&T Data Engineer

Responsibilities

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

Benefits

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.

Medical, Dental, Vision, Disability, Health, and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan, subject to elections and eligibility.

Glassdoor

4.0

PepsiCo is a food and beverage company.

Purchase, New York, USA

http://www.pepsico.com

Distribution of Different Job Fields Receiving Sponsorship

66

Represents job field similar to this job

Engineering and Development

Management and Executive

Product Management

Accounting and Finance

Human Resources

Sales

Creatives and Design

Legal and Compliance

Education and Training

Customer Service and Support

Trends of Total Sponsorships

*2026

(32)

2025

(50)

2024

(52)

2023

(62)

Qualifications

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

3+ years of experience in data engineering, data warehousing, or a similar technical data role

Strong proficiency in SQL, including query optimization, stored procedures, and working with large relational datasets

Hands-on programming experience with Python for data extraction, cleaning, transformation, and automation

Proven experience building and maintaining ETL/ELT pipelines and working with data integration tools

Experience with cloud platforms such as Azure, AWS, or GCP and their core data services

Experience automating business processes using RPA tools (e.g., UiPath, Power Automate, Automation Anywhere) and/or Python scripting

Proficiency in data visualization tools such as Power BI and/or Tableau, including building interactive dashboards and reports

Strong understanding of data modeling, data warehousing concepts, and data quality best practices

Excellent analytical, problem-solving, and communication skills, with the ability to collaborate effectively with technical and business stakeholders

3+ years of experience in data engineering, data warehousing, or a similar technical data role.

Required skills

SQL, Python, ETL/ELT Pipelines, Data Modeling, Data Warehousing, Data Quality, Azure, AWS, GCP, UiPath, Power Automate, Power BI, Tableau

Experience

3+ years