Join Colgate-Palmolive's Digital Tech & Data team as a Data Engineer and help shape the data foundation that powers our digital ecosystem. You will build and sustain production-grade pipelines with Airflow, move data into Snowflake, and deliver trustworthy datasets to business teams across digital touchpoints. This hybrid, Piscataway-based role sits at the intersection of analytics, engineering, and cloud infrastructure within a global consumer products leader.
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.
