Data Engineer

Responsibilities

• Architect and sustain production-grade data pipelines using Airflow to ingest data from digital touchpoints into Snowflake
• Develop modular, tested, and well-documented dbt models that transform raw data into reliable, business-ready datasets, overseeing the full lifecycle from source definition to exposure
• Provision and manage cloud data infrastructure including Snowflake objects, Airflow environments, and supporting GCP resources with Terraform, all under version control and peer-reviewed processes
• Enforce data quality, observability, and testing standards across all pipelines
• Optimize Snowflake performance and manage warehouse costs through clustering, query profiling, and resource monitors
• Align pipelines with platform standards, including branching, CI/CD for dbt and Airflow, code reviews, documentation, and naming conventions

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field
• 2 to 3 years of hands-on experience in data engineering or analytics engineering, ideally in a digital or e-commerce setting

Technologies

• Airflow
• Snowflake
• dbt
• Terraform
• Google Cloud Platform (GCP)
• Python
• SQL

Benefits

• Medical, dental, and vision insurance
• Basic life insurance
• Paid parental leave
• Disability coverage
• 401(k) retirement plan with company matching
• Discretionary bonuses and profit-sharing
• Long-term incentives for eligible roles
• Minimum of 15 vacation/PTO days (hourly employees receive at least 120 hours)
• 13 paid holidays
• Paid sick leave, adjusted by role and location

No Relocation Assistance

No Relocation Assistance Offered

About Colgate-Palmolive

Colgate-Palmolive is a global consumer products company active in more than 200 countries, specializing in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Its brands are widely recognized and trusted in households around the world.

Equal Opportunity and Inclusion

Colgate-Palmolive is an equal opportunity employer. The company is committed to inclusion and belonging, maintaining policies that prevent discrimination and foster a respectful work environment for diverse backgrounds.

Salary: USD 96,800 - 137,000 per year. Location: Piscataway, NJ (hybrid). Education: Bachelor's degree. Experience: 2 to 3 years.