Role - Lead Data Engineer Data Product
Location -Warsaw, (Indiana, US - 100% onsite)
Job Details:
Lead Data Engineer Data Product (Onshore)
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 (Clienture DevOps), version-controlled DDL
Good-to-Have: Kimball/Data Vault modeling, healthcare data (Claims, EHR) Experience: 8 12 years