Lead Data Engineer Data Produc

Position: Lead Data Engineer Data Product Location: Warsaw, IN***Onsite***Duration: 1 YearsJob DetailsLead 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 ResponsibilitiesOwn the build of 5 source-aligned data products + 2 MVP data productsLead dbt project setup (profiles, sources, seeds, models across RAW CURATED GOLD)Implement anonymization macros (SHA-256 hashing) reused across all sourcesDrive Data Product publishing, catalog registration, lineage capture in HorizonCoordinate with Gen AI Engineer to expose Gold-layer products to AI/BI semantic layerSprint planning, backlog grooming, code reviews for 4+ engineersMust-Have Skills8+ years in data engineering with 4+ years leading teamsExpert in Snowflake SQL, dbt (Core/Cloud), PythonStrong on ADF orchestration, Snowpipe, COPY INTO, dynamic tablesData Product design patterns (FAIR principles, Data Contracts)Git, CI/CD (Azure DevOps), version-controlled DDLGood-to-Have: Kimball/Data Vault modeling, healthcare data (Claims, EHR) Experience: 8 12 years