Data Engineer: Airflow, Snowflake, dbt | Hybrid NJ | Travel

Colgate; Piscataway Township (NJ); Hybrid; USD 97,000 - 137,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with company match

Paid parental leave

Vacation days

Job summary

Colgate-Palmolive is seeking a passionate Data Engineer to join our Digital Tech & Data team. You will build and maintain data pipelines from touchpoints to Snowflake, ensuring clean, reliable data for business users.

You will design production-grade pipelines in Airflow, develop dbt models, and manage cloud infrastructure with Terraform. The role emphasizes data quality, observability, and cost-aware optimization in a hybrid work environment in New Jersey.

Qualifications

• Bachelor's degree in CS, IS, engineering, mathematics, or related field.
• 2–3 years of hands-on data engineering or analytics experience.
• Experience in a digital or e-commerce environment is a plus.
• Proven ability to build production-grade data pipelines.

Responsibilities

• Design, build, and maintain production-grade data pipelines in Airflow.
• Develop modular, tested dbt models transforming raw data into business datasets.
• Provision and manage Snowflake objects and Airflow environments via Terraform.
• Implement data quality, observability, and testing across pipelines.
• Tune Snowflake performance and manage warehouse cost.

Skills

Python

SQL

Airflow

Snowflake

dbt

Terraform

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related discipline

Tools

Airflow

Snowflake

dbt

Terraform

Job description

Colgate-Palmolive is seeking a passionate Data Engineer to join our Digital Tech & Data team. You will build and maintain data pipelines from touchpoints to Snowflake, ensuring clean, reliable data for business users.

You will design production-grade pipelines in Airflow, develop dbt models, and manage cloud infrastructure with Terraform. The role emphasizes data quality, observability, and cost-aware optimization in a hybrid work environment in New Jersey.