EngineerJobs.io
← Back to all jobs

Job Description

Colgate-Palmolive is a caring, innovative growth company focused on 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 will build reliable data capabilities that support data-driven decision-making across the organization.

What you’ll do

As a Data Engineer, you will design, build, and maintain data pipelines from source through to consumption. You will use the medallion architecture (Bronze, Silver, Gold) to keep data progression organized while supporting quality and usability. You will also leverage Snowflake, dbt, Python, and SQL to deliver solutions that are compliant, efficient, sustainable, and well-documented.

  • Build, support, and maintain data pipelines from source to consumption using Snowflake, dbt, Python, and SQL
  • Implement the medallion architecture to support organized data progression and data quality
  • Assemble large, sophisticated data sets aligned to functional and non-functional business requirements
  • Deliver pipelines that follow enterprise standards and best practices
  • Identify and implement internal process improvements, including automating manual work and optimizing delivery
  • Research and evaluate new and emerging technologies in data engineering
  • Gather requirements with stakeholders across the company
  • Assist with data-related technical issues and support data infrastructure needs
  • Advise or review proposed and ongoing pipeline designs and components
  • Collaborate across technical and business teams to achieve shared goals
  • Perform code reviews to help enforce data engineering standards
  • Ensure solutions comply with Data Engineering standards and all applicable policies
  • Build, document, and maintain pipeline components

What you bring

  • 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 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 data sets
  • Experience with Git, GitHub, or other version-controlled code management tools
  • Experience with cloud infrastructure and services (GCP, AWS, etc.)
  • Experience managing deployments using Infrastructure as Code tools such as Terraform
  • Experience with container-based frameworks (Kubernetes & Docker preferred)
  • Experience with workflow management tools such as Airflow

Technologies you’ll work with

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

Benefits

  • 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 requirements)
  • 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

Compensation

Salary range: USD 96,800 - 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

Similar Jobs