Lead Data Engineer Data Product

Job Title: Lead Data Engineer Data Product
Location: Warsaw, IN (Onsite)
Experience: 8 12 years

Job Details:
Role Summary: Lead the design and build of Data Products in the GOLD layer, driving the Data Product Factory approach for MVP use cases.

Key Responsibilities:
Own the build of 5 source-aligned data products + 2 MVP data products
Lead dbt project setup (profiles, sources, seeds, models across RAW CURATED GOLD)
Implement anonymization macros (SHA-256 hashing) reused across all sources
Drive Data Product publishing, catalog registration, lineage capture in Horizon
Coordinate with Gen AI Engineer to expose Gold-layer products to AI/BI semantic layer
Sprint planning, backlog grooming, code reviews for 4+ engineers

Must-Have Skills:
8+ years in data engineering with 4+ years leading teams
Expert in Snowflake SQL, dbt (Core/Cloud), Python
Strong on ADF orchestration, Snowpipe, COPY INTO, dynamic tables
Data Product design patterns (FAIR principles, Data Contracts)
Git, CI/CD (Azure DevOps), version-controlled DDL
Good-to-Have: Kimball/Data Vault modeling, healthcare data (Claims, EHR)