Data Engineer - Lakehouse & AI-Ready Pipelines (Hybrid)

Church & Dwight Co.; Ewing Township (NJ); Hybrid; USD 93,000 - 132,000; Full time

Benefits offered by this job

Medical, dental, vision

Paid vacation and sick time

401k with company match

Paid parental leave

Discounted Employee Stock Purchase

Job summary

Church & Dwight is seeking a Data Engineer to join our Analytics Engineering Group. You will build and maintain ingestion frameworks, ELT pipelines, and curated data products to deliver insights across CHD business functions worldwide.

The role centers on a Databricks lakehouse with Bronze/Silver/Gold architecture, emphasizing reusable engineering, governance, and AI-ready data; you will partner with analytics engineers, data scientists, and business analysts across time zones.

Qualifications

• Bachelor’s degree or equivalent experience required.
• 5+ years of data engineering experience including production ELT pipelines on a cloud data platform.
• Hands-on Databricks experience (Spark, Delta Lake, orchestration, Unity Catalog), preferably on Azure.
• Experience building framework-based ingestion within a medallion architecture.
• Advanced Python (including PySpark and automated testing) and SQL; strong data modeling skills.
• Practical data governance experience: profiling, data quality, MDM, catalog, and lineage.
• Experience with Git and CI/CD for data assets.

Responsibilities

• Build reusable, metadata-driven ingestion frameworks and batch/streaming ELT pipelines with Bronze/Silver/Gold data and quality gates.
• Design dimensional, normalized, and data vault models; build Gold data products with conformed dimensions across regions and source systems.
• Profile sources and implement data quality and reconciliation controls; support master and reference data management.
• Maintain semantic layer, catalog, lineage, and business glossary with data stewards; extend classification and access controls for AI use cases.
• Develop on Databricks (PySpark, Spark SQL, Delta Lake, Delta Live Tables, Workflows, Unity Catalog); optimize performance and cost; contribute to disaster recovery planning.
• Write production-grade Python and SQL; use Git, peer review, and CI/CD; manage configuration as code.
• Prepare AI-ready data: feature tables, training datasets, and RAG content.
• Publish governed data to operational systems through APIs, events, and reverse ETL with versioned interface contracts.
• Support production operations (monitoring, RCA, SLAs) and maintain runbooks for handoff to managed services.

Skills

Python programming

SQL

Data modeling

Git & CI/CD

Problem solving

Communication

Education

Bachelor’s degree in CS/Math/Engineering or equivalent

Tools

Databricks

Azure

Delta Lake

Unity Catalog

Purview/Collibra/Alation/Informatica

Kafka

Power BI

Job description

Church & Dwight is seeking a Data Engineer to join our Analytics Engineering Group. You will build and maintain ingestion frameworks, ELT pipelines, and curated data products to deliver insights across CHD business functions worldwide.

The role centers on a Databricks lakehouse with Bronze/Silver/Gold architecture, emphasizing reusable engineering, governance, and AI-ready data; you will partner with analytics engineers, data scientists, and business analysts across time zones.