Data Engineer
Job Description
Colgate-Palmolive is reimagining a healthier future through Oral Care, Personal Care, Home Care and Pet Nutrition, with products sold in more than 200 countries and territories. In this hybrid role in Piscataway, NJ, you’ll build data pipelines that help enable data-driven decision-making, while working with a modern data engineering stack and a collaborative network of business and technical teams.
You’ll develop and maintain end-to-end pipelines from source to consumption layers using the medallion architecture (Bronze, Silver, Gold). The work includes designing compliant, efficient, sustainable, and well-documented solutions, while gathering requirements and improving internal processes through automation and optimized data delivery.
Responsibilities
- Build, support, and maintain data pipelines from source to consumption layers using Snowflake, dbt, Python, and SQL.
- Implement the medallion architecture to keep data progression organized and support data quality.
- Assemble large, sophisticated datasets aligned to functional and non-functional business requirements.
- Deliver pipelines that follow enterprise standards and data engineering best practices.
- Identify, design, and implement process improvements, including automating manual workflows and optimizing data delivery.
- Research and evaluate new and emerging technologies in the data engineering space.
- Work with stakeholders across the company to gather requirements and support adoption.
- Assist with data-related technical issues and support data infrastructure needs.
- Advise or review proposed or ongoing data engineering pipelines and components.
- Collaborate with business and technical teams to achieve shared goals.
- Perform code reviews and help enforce data engineering standards and best practices.
- Ensure solutions comply with standards set by the Data Engineering team and all applicable policies.
- Build, document, and maintain pipeline components.
Requirements
- Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.
- At least 4 years of professional, hands-on experience as a Data Engineer, Data Architect, or related role.
- Experience developing in Python and SQL.
- Experience with dbt (optional).
- Experience with Snowflake (optional).
- Experience interacting with and using databases and SQL.
- Experience building and optimizing large data pipelines, architectures, and datasets.
- Experience with Git, GitHub, or other version-controlled code management tools.
- Experience with cloud infrastructure and services (GCP, AWS, etc.).
- Experience managing infrastructure deployments using Infrastructure as Code (Terraform).
- Experience working with container-based frameworks (Kubernetes and Docker preferred).
- Experience with workflow management tools such as Airflow.
Tech stack
- Snowflake, dbt, Python, SQL
- Git, GitHub
- GCP, AWS
- Terraform, Kubernetes, Docker
- Airflow
Benefits
- Comprehensive benefits package including medical, dental, vision, basic life insurance, paid parental leave, and disability coverage.
- 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 prorated based on hire date within the calendar year).
- Paid sick leave adjusted based on role and location in accordance with local laws.
Compensation
Salary range: USD 96,800 to 137,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.
Preferred qualifications
- Previous experience in a Data Engineering role working closely with other programmers (Software Engineers, Data Scientists, etc.).
- Experience in 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.