About PepsiCo

PepsiCo is a global leader in the food and beverage industry, renowned for iconic brands like Pepsi, Gatorade, Lay's, and Quaker. With operations spanning over 200 countries, PepsiCo employs hundreds of thousands of people worldwide, driving innovation in snacks, beverages, and nutrition. The company is at the forefront of digital transformation, leveraging big data, eCommerce, and IoT to revolutionize business models. PepsiCo's commitment to sustainable growth, data-driven decision-making, and employee development makes it an employer of choice for top talent in technology and engineering.

Role Overview

The eCom Data Engineer Specialist role at PepsiCo in Purchase, New York, is pivotal in building the data foundations that power eCommerce, supply chain, and analytics initiatives. As part of the Data Management and Operations team, you'll develop high-impact data products in hybrid cloud environments, enabling advanced analytics, machine learning, and business innovation. This full-time position offers a salary range of $64,900 - $132,550 USD annually, with opportunities for equity incentives and comprehensive benefits. Ideal for experienced data engineers passionate about scalable pipelines and enterprise data lakes.

Key Impact Areas

Focus on revenue management, manufacturing, logistics, and more, collaborating with business leaders to turn raw data into actionable insights across PepsiCo's global scale.

Key Responsibilities

In this role, you'll take ownership of critical data engineering tasks to drive PepsiCo's digital transformation:

• Own end-to-end data pipeline development, from data modeling and testing to scalability, operability, and metrics monitoring.
• Ensure software quality through rigorous peer code reviews and adherence to world-class engineering standards.
• Define and implement best practices for product development, engineering, and coding within the data team.
• Participate in architecture discussions, influencing decisions that expand PepsiCo's data platforms.
• Lead feature development by validating requirements, assessing systems, and decomposing tasks for agile delivery.
• Deliver high-quality pipelines via analysis, peer reviews, test automation, and cross-team collaboration.
• Innovate with new tools, third-party libraries, or in-house solutions to enhance workflow and quality.
• Support production pipelines through exception handling, monitoring, and debugging.

Qualifications & Requirements

To succeed, candidates need proven expertise in data engineering:

• 4+ years overall technology experience, including 3+ years hands-on in software development, data engineering, and systems architecture.
• 3+ years in SQL optimization and performance tuning.
• Strong background in data modeling, data warehousing, and high-volume ETL/ELT pipelines.
• Experience building/operating highly available, distributed systems for data extraction, ingestion, and processing.
• Familiarity with data profiling and quality tools like Apache Griffin, Deequ, or Great Expectations.
• Current proficiency in Python, orchestration (Airflow, Luigi, Databricks), relational DBs (Postgres, MySQL), MPP systems (Snowflake, Redshift, Synapse), cloud platforms (AWS, Azure), GitHub, CI/CD, and Agile methodologies.

PepsiCo values hybrid work environments, blending on-premise and cloud systems for maximum flexibility.

Benefits & Perks

PepsiCo offers a premium compensation package to support your professional and personal life:

• Salary range: $64,900 - $132,550 USD, adjusted for skills, experience, and location.
• Business development incentive equity based on performance.
• Paid time off including parental leave, vacation, sick, and bereavement.
• Comprehensive health benefits: medical, dental, vision, disability, health/dependent care reimbursement.
• Employee Assistance Program (EAP), accident/group legal/life insurance.
• Defined Contribution Retirement Plan for long-term financial security.

Career Growth

At PepsiCo, data engineers advance quickly in a dynamic environment. Gain exposure to flagship projects in eCommerce and supply chain, mentor juniors, and lead platform expansions. Professional development includes training in emerging tech, leadership programs, and global rotations. High performers access accelerated paths to senior engineering or architecture roles, fostering long-term careers in data innovation.

Why Join Us

Join PepsiCo's data team to shape the future of a Fortune 500 giant. Work on massive-scale data challenges with cutting-edge tools, collaborate with top talent, and impact billions in revenue. Enjoy a hybrid workplace in vibrant Purchase, NY, with unmatched benefits and growth opportunities. PepsiCo's culture emphasizes innovation, inclusivity, and work-life balance, making it the ideal place for data engineers to thrive.

Role FAQs

Q: Is this role remote? It's hybrid, involving on-premise and cloud systems in Purchase, NY.

Q: What tech stack will I use? Python, Airflow/Databricks, Snowflake/Redshift, AWS/Azure, and more.

Q: What's the salary range? $64,900 - $132,550 USD/year, plus benefits and incentives.

Q: Are there growth opportunities? Yes, with leadership tracks and global projects.

Q: How does PepsiCo support data quality? Through tools like Deequ/Great Expectations and best-in-class practices.