Data Engineer

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

Benefits offered by this job

Salary range

Bonuses & profit-sharing

Medical, dental, vision

Paid parental leave

Disability coverage

401(k) with company match

Vacation/PTO 15 days

13 paid holidays

Paid sick leave

Job summary

Colgate-Palmolive seeks a Data Engineer in Piscataway, NJ to design and maintain production data pipelines using Snowflake, dbt, Python, and SQL. The role emphasizes compliant, efficient, and well-documented solutions in a hybrid setup.

You will collaborate with business and IT stakeholders, automate workflows, and optimize pipelines for performance and cost while ensuring enterprise standards and governance.

Qualifications

• Bachelor’s degree in a related field (CS/IT/Engineering).
• 2+ years of professional experience as a Data Engineer or similar.
• Proficiency in Python and SQL; experience building scalable data pipelines.

Responsibilities

• Design, build, and maintain production data pipelines from ingestion to consumption.
• Assemble large-scale datasets aligned with enterprise standards.
• Automate workflows, tune queries, and improve pipelines continuously.
• Collaborate with stakeholders to translate requirements into scalable data delivery.

Skills

Python

SQL

Airflow

Git

Docker

Kubernetes

Terraform

Snowflake

dbt

AWS

GCP

Education

Bachelor’s Degree

Tools

Snowflake/dbt

Git

Docker/Kubernetes

Terraform

Airflow

Job description

Colgate-Palmolive is seeking a Data Engineer to help build production-ready data pipelines that move data from ingestion to a consumption layer. The role is based in Piscataway, NJ and follows Medallion Architecture, with an emphasis on compliant, efficient, and well-documented solutions. This is a hybrid position supporting ongoing improvements across the data platform.

You will work with Snowflake, dbt, Python, and SQL to design and maintain end-to-end pipelines, while collaborating with business and IT stakeholders to translate requirements into scalable data delivery. The focus includes assembling enterprise-aligned datasets, optimizing performance and cost, and keeping workflows reliable through automation and tuning.

What you’ll do

• Design, build, and maintain production data pipelines from ingestion to consumption using Snowflake, dbt, Python, and SQL, aligned to Medallion Architecture standards.
• Assemble large-scale, complex datasets in line with enterprise standards, optimizing infrastructure for both performance and cost.
• Improve pipelines continuously by automating manual workflows, tuning query execution, and evaluating emerging data technologies.
• Partner with business and IT stakeholders to convert functional requirements into scalable data delivery solutions and address technical pipeline blockers.
• Maintain code quality and enterprise compliance through peer GitHub code reviews, technical documentation, and pipeline design standards.

Requirements

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

Technologies

• Snowflake, dbt, Python, SQL
• AWS, GCP
• Git
• Docker, Kubernetes
• Terraform, Airflow
• GitHub

Preferred qualifications

• Previous experience in a Data Engineering role working closely with other programmers (Software Engineers, Data Scientists, etc.).
• Experience with network, server, and application‑status monitoring.
• Familiarity with software‑automation production systems (GitHub Actions, Selenium, etc.).
• Familiarity with code deployment tools.
• Familiarity with preparing datasets for AI/ML models, vector embeddings, or feature engineering.

Compensation and benefits

• Salary range: USD 76,800 - 121,000 per year.
• Pay is determined based on experience, qualifications, and location.
• Salaried employees may also be eligible for discretionary bonuses, profit‑sharing, and long‑term incentives for Executive‑level roles.
• Comprehensive benefits package including medical, dental, vision, and basic life insurance.
• Paid parental leave.
• Disability coverage.
• Participation in the 401(k) retirement plan with company matching contributions, subject to eligibility requirements.
• Minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours).
• 13 paid holidays (vacation days are prorated based on hire date within the calendar year).
• Paid sick leave adjusted based on role and location in accordance with local laws.

Location, travel, and work authorization

• Location: Piscataway, NJ, United States (hybrid).
• Travel: up to 10% of time.
• Work visa sponsorship: not available for this position.
• Relocation assistance: no relocation assistance offered.