Data Engineer (AI)

Location: Hybrid in Ewing, New Jersey, USA; in-person attendance is required on Tuesdays, Wednesdays, and Thursdays, with remote work on Mondays and Fridays.

Salary: USD 92,500–131,700 annual base salary; bonus eligible.

Company

Church & Dwight is a consumer products company focused on its people, products, consumers, and environmental impact.

What you will do

• Build reusable, metadata-driven ingestion frameworks and batch/streaming ELT pipelines across Bronze, Silver, and Gold layers with quality gates, incremental and CDC processing, and restartable, idempotent design.
• Design dimensional, normalized, and data vault models and build curated Gold data products with conformed dimensions across regions and source systems.
• Profile data sources, implement data quality and reconciliation controls, and support master and reference data management.
• Maintain the semantic layer, catalog, lineage, and business glossary; extend classification, masking, and access controls for AI use cases.
• Develop and optimize Databricks solutions, including PySpark, Spark SQL, Delta Lake, Delta Live Tables, Workflows, and Unity Catalog, while contributing to disaster recovery planning.
• Prepare AI-ready data, publish governed data through APIs, events, and reverse ETL, and support production monitoring, root cause analysis, service levels, documentation, and runbooks.

Requirements

• Bachelor’s degree in Computer Science, Mathematics, Physics, Engineering, or equivalent experience.
• 5+ years of data engineering experience, including production ELT pipelines on a cloud data platform.
• Hands-on Databricks experience covering Spark, Delta Lake, orchestration, and Unity Catalog.
• 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 with profiling, data quality, MDM, catalog, and lineage.
• Experience with Git and CI/CD for data assets.
• Strong problem-solving skills focused on root cause analysis, clear communication with technical and non-technical partners, and a standards-first approach favoring reusable frameworks and automation.

Nice to have

• 2+ years of Consumer Packaged Goods analytics experience.
• Broader Azure experience with ADLS, Data Factory, Fabric, and Power BI; Databricks certification.
• Experience with Purview, Collibra, Alation, or Informatica.
• Streaming experience with Kafka or Structured Streaming and infrastructure as code.
• Experience preparing data for machine learning or generative AI applications.
• Experience on agile teams distributed across geographies.

Culture & Benefits

• Informal, open, and supportive culture centered on courage, determination, collaboration, ownership, innovation, and growth.
• Medical, dental, vision, and basic life insurance for eligible employees and dependents.
• Paid vacation, sick time, parental leave, paid holidays, and floating holidays.
• 401(k) retirement plan with company match and profit-sharing.
• Discounted employee stock purchase plan.