Data Engineer

Location: Piscataway, NJ (hybrid)

Responsibilities

• Architect and maintain robust Airflow pipelines that pull data from digital touchpoints into Snowflake.
• Create modular, tested, and well-documented dbt models that transform raw data into reliable, business-ready datasets, owning the end-to-end lifecycle from source to exposure.
• Provision and manage cloud data infrastructure, including Snowflake objects, Airflow environments, and supporting GCP resources, using Terraform with version control and peer reviews.
• Enforce data quality, observability, and testing standards across the data pipelines.
• Optimize Snowflake performance and manage warehouse costs through clustering, query profiling, and resource monitors, treating cost as a core engineering concern.
• Align pipelines with platform standards, including branching strategies, 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–3 years of hands-on experience in data or analytics engineering, preferably in a digital or e-commerce setting.

Technologies

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

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• Basic life insurance
• Paid parental leave
• Disability coverage
• Participation in the 401(k) retirement plan with company matching contributions
• Discretionary bonuses
• Profit-sharing
• Long-term incentives for Executive-level roles
• Minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours)
• 13 paid holidays
• Paid sick leave (adjusted based on role and location)

Relocation

• No Relocation Assistance Offered

Compensation

Salary range is USD 96,800 to 137,000 per year. Pay is determined by experience, qualifications, and location, with eligible discretionary bonuses, profit-sharing, and long-term incentives for executive-level roles.

About Colgate-Palmolive

Colgate-Palmolive Company is a global consumer products company operating in more than 200 countries, with market-leading brands in Oral Care, Personal Care, Home Care, Skin Care, and Pet Nutrition. Our products are trusted in more households than any other brand, making Colgate a recognized name worldwide.

Role Summary

We are seeking a detail-oriented Data Engineer to join our Digital Tech & Data team. In this role, you will build and maintain data pipelines that support our digital ecosystem, ingesting raw data from multiple digital touchpoints and delivering clean, robust data that business teams can rely on.

Our Commitment to Inclusion

Our success starts with our people. We cultivate talent from diverse backgrounds and perspectives to better serve consumers globally, and we strive to maintain an inclusive environment where everyone feels valued and able to contribute.

Equal Opportunity Employer

Colgate is an equal opportunity employer. All qualified applicants will be considered without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status, or any other characteristic protected by law.