Data Engineer: Build Scalable Snowflake Pipelines

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

Job summary

Colgate-Palmolive in Piscataway, NJ is seeking a Data Engineer to design, build, and maintain scalable data pipelines from ingestion to consumption using Snowflake, dbt, Python, and SQL, following the Medallion Architecture.

You will partner with IT and business teams to translate requirements into reliable data delivery solutions, while enforcing code quality through GitHub reviews and solid documentation. This role requires a Bachelor's degree and 2+ years in data engineering.

Qualifications

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

Responsibilities

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

Skills

Python

SQL

Git

Docker

Kubernetes

Terraform

Airflow

Snowflake

dbt

AWS

GCP

Education

Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field

Tools

Snowflake

dbt

Python

SQL

Job description

Colgate-Palmolive in Piscataway, NJ is seeking a Data Engineer to design, build, and maintain scalable data pipelines from ingestion to consumption using Snowflake, dbt, Python, and SQL, following the Medallion Architecture.

You will partner with IT and business teams to translate requirements into reliable data delivery solutions, while enforcing code quality through GitHub reviews and solid documentation. This role requires a Bachelor's degree and 2+ years in data engineering.