DeveloperJobs.io
← Back to all jobs

Job Description

Colgate-Palmolive is hiring a Data Engineer (hybrid) in Piscataway, NJ to design and run data pipelines that move from source systems to downstream consumption. The role uses the medallion architecture (Bronze, Silver, Gold) to support data quality and data-driven decision-making, with a stack spanning Snowflake, dbt, Python, and SQL.

Key Responsibilities

  • Build, support, and maintain data pipelines from source to consumption layers using Snowflake, dbt, Python, and SQL.
  • Implement the medallion architecture (Bronze, Silver, Gold) to keep data organized and progressing with quality controls.
  • Assemble large, sophisticated datasets aligned to functional and non-functional business requirements.
  • Use a standard data engineering technology stack to deliver pipelines that follow enterprise standards and best practices, including compliance expectations.
  • Identify and implement internal process improvements, including automating manual workflows and optimizing data delivery.
  • Research and evaluate new and emerging tools and technologies in the data engineering space.
  • Gather requirements in partnership with stakeholders across the organization.
  • Assist with data-related technical issues and support data infrastructure needs.
  • Advise on and/or review proposed or ongoing data engineering pipelines and their components.
  • Collaborate with business and technical teams to meet shared goals, and participate in code reviews to reinforce data engineering standards.
  • Ensure solutions comply with standards set by the Data Engineering team and align with organizational 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 in a related role.
  • Experience developing with Python and SQL.
  • Proficiency 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 using Git, GitHub, or other version-controlled code management tools.
  • Experience with cloud infrastructure and services such as GCP and AWS.
  • Experience managing infrastructure deployments using Infrastructure as Code tools such as Terraform.
  • Experience working with container-based frameworks such as Kubernetes and Docker (preferred).
  • Experience with workflow management tools such as Airflow.

Technologies

  • Snowflake
  • dbt
  • Python
  • SQL
  • Git
  • GitHub
  • GCP
  • AWS
  • Terraform
  • Kubernetes
  • Docker
  • Airflow
  • Infrastructure as Code

Preferred Qualifications

  • Previous experience in a Data Engineering role working closely with other programmers such as Software Engineers and Data Scientists.
  • Experience with network, server, and application-status monitoring.
  • Familiarity with software-automation production systems such as GitHub Actions and Selenium.
  • Familiarity with code deployment tools.
  • Familiarity with preparing datasets for AI/ML models, including vector embeddings or feature engineering.

Compensation and Benefits

Salary Range: USD 96,800 to 137,000 per year. Pay is determined based on experience, qualifications, and location. Salaried employees may be eligible for discretionary bonuses, profit-sharing, and long-term incentives for Executive-level roles.

  • Comprehensive benefits package including medical, dental, vision, basic life insurance, paid parental leave, and disability coverage.
  • Participation in the 401(k) retirement plan with company matching contributions (subject to eligibility).
  • Minimum of 15 vacation/PTO days (hourly employees receive a minimum of 120 hours).
  • 13 paid holidays (vacation days are prorated based on hire date within the calendar year).
  • Paid sick leave adjusted based on role and location in accordance with local laws.

Role and Company Overview

Colgate-Palmolive Company is described as a caring, innovative growth company reimagining a healthier future for people, pets, and the planet. The company focuses on Oral Care, Personal Care, Home Care, and Pet Nutrition, with products sold in more than 200 countries and territories.

Education

Bachelor’s Degree in Computer Science, Information Technology, Engineering, or a related field.

Location

Piscataway, NJ (hybrid).

Similar Jobs