Data Engineer

Church & Dwight is seeking a Data Engineer to join its Analytics Engineering Group and help deliver ingestion frameworks, ELT pipelines, and governed data products. This hybrid role is based in Ewing, NJ and supports a Databricks lakehouse built on a Bronze/Silver/Gold medallion architecture, with an emphasis on quality gates, lineage, and AI-ready datasets.

The position centers on developing end-to-end data engineering capabilities, from source profiling and orchestration to dimensional modeling, semantic layer maintenance, and publishing trusted data into operational systems.

Responsibilities

• Build reusable, metadata-driven ingestion frameworks and batch or streaming ELT pipelines that move data through Bronze, Silver, and Gold stages using defined quality gates
• Create pipelines with incremental and CDC processing and implement restartable, idempotent patterns
• Design dimensional, normalized, and data vault models and deliver curated Gold data products with conformed dimensions that reconcile across regions and source systems
• Profile sources and implement automated data quality and reconciliation controls, supporting master and reference data management
• Maintain the semantic layer, catalog, lineage, and business glossary in partnership with data stewards, and extend classification, masking, and access controls for AI use cases
• Develop on Databricks using PySpark, Spark SQL, Delta Lake, Delta Live Tables, Workflows, and Unity Catalog, optimizing for performance and cost and contributing to disaster recovery planning
• Write tested, production-grade Python and SQL using Git, peer review, and CI/CD, with configuration managed as code
• Prepare AI-ready data, including feature tables, training datasets, and RAG content (chunking, embeddings, vector indexes)
• Publish governed data to operational systems via APIs, events, and reverse ETL, using versioned interface contracts
• Support production operations through monitoring, root cause analysis, and service levels, and maintain documentation and runbooks for handoff to managed services

Requirements

• Bachelor’s degree in Computer Science, Mathematics, Physics, Engineering, or equivalent experience required
• 5+ years of data engineering experience, including production ELT pipelines on a cloud data platform
• Hands-on experience with Databricks (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 across dimensional, normalized, and lakehouse patterns
• Practical data governance experience including profiling, data quality, MDM, catalog, and lineage
• Experience using Git and CI/CD for data assets

Technologies

• Databricks, PySpark, Spark SQL, Delta Lake, Delta Live Tables, Workflows, Unity Catalog
• Python, Git, CI/CD
• APIs, Kafka, Structured Streaming
• Azure, ADLS, Data Factory, Fabric, Power BI, Purview, Collibra, Alation, Informatica
• Infrastructure as code, Reverse ETL

Benefits

• Medical, dental, vision
• Basic life insurance
• Paid vacation and sick time
• Paid Parental Leave
• Paid holidays and floating holidays
• 401k retirement plan (with company match and profit-sharing)
• Discounted Employee Stock Purchase Plan

Work Environment

• Hybrid role based in Ewing, NJ
• In-person attendance required on Tuesdays, Wednesdays, and Thursdays
• Remote work options on Mondays and Fridays

Preferred Qualifications

• 2+ years of Consumer Packaged Goods analytics experience
• Broader Azure stack experience (ADLS, Data Factory, Fabric, Power BI) and a Databricks certification
• Experience with governance or catalog tools such as Purview, Collibra, Alation, or Informatica
• Streaming (Kafka, Structured Streaming) and infrastructure as code experience
• Experience preparing data for ML or generative AI applications
• Experience on agile teams distributed across geographies

Location: Ewing, NJ (hybrid) • Salary: USD 92,500 - 131,700 per year • Experience Level: 5+ years