Lead Data Engineer Data Product

We are looking for Lead Data Engineer Data Product for our client in Warsaw IN.

Job Title: Lead Data Engineer Data Product

Job Location: Warsaw IN

Job Type: Contract

Job Overview:

Pay Range: $55hr - $60hr

Requirement/Must Have:

• 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.

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.

Nice to Have:

• Kimball/Data Vault modeling.
• Healthcare data (Claims, EHR).

===

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities