Data Engineer: Scalable Snowflake Pipelines (Python)

Colgate Palmolive; Piscataway Township (NJ); On-site; USD 77,000 - 121,000; Full time

Job summary

Colgate-Palmolive is hiring a Data Engineer to design, build, and maintain data pipelines across ingestion to consumption. You will work with Snowflake, dbt, Python, and SQL, following Medallion Architecture, to deliver trusted data for multi-functional teams.

Collaboration with IT and business stakeholders is key to translating requirements into scalable data solutions. The role emphasizes performance, cost optimization, and strong adherence to code quality, with cloud infrastructure experience

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or related field.
• 2+ years of professional experience as a Data Engineer or related role.
• Proven experience in Python, SQL, and cloud infrastructure (AWS/GCP), with hands-on expertise building scalable data pipelines, managing databases, and utilizing Git, containerization (Docker/Kubernetes), Terraform, Airflow, and Snowflake/dbt.

Responsibilities

• Design, build, and maintain production data pipelines using Snowflake, dbt, Python, and SQL following Medallion Architecture standards.
• Assemble large-scale datasets aligned with enterprise standards while optimizing infrastructure for performance and cost.
• Drive continuous pipeline improvement by automating workflows, tuning queries, and evaluating new data tech.
• Partner with business and IT stakeholders to translate requirements into scalable data delivery solutions.
• Enforce code quality and enterprise compliance through peer reviews, documentation, and design standards.

Skills

Python

SQL

Cloud infrastructure

Git

Docker

Kubernetes

Terraform

Airflow

Snowflake

dbt

Education

Bachelor's degree in CS/IT/Engineering

Tools

GitHub

GitHub Actions

Selenium

Job description

Colgate-Palmolive is hiring a Data Engineer to design, build, and maintain data pipelines across ingestion to consumption. You will work with Snowflake, dbt, Python, and SQL, following Medallion Architecture, to deliver trusted data for multi-functional teams.

Collaboration with IT and business stakeholders is key to translating requirements into scalable data solutions. The role emphasizes performance, cost optimization, and strong adherence to code quality, with cloud infrastructure experience