Quick overview
Job description
Data Engineer Lead / Data Warehouse Architect - State of Michigan DHHS - Hybrid Lansing, MI
Long-term contract. Hybrid in Lansing, MI. Michigan residents or candidates willing to relocate. Apply through the Apply button.
MI DHHS 168059 - Data Engineer Lead/Data Warehouse Architect (Level 3)
Location: Lansing, MI (Hybrid). Michigan residents or willing to relocate to Michigan.
Data Engineering Lead excels in data modeling, Lakehouse and Medallion Architecture concepts, and data/ML products delivery using an agile DevOps framework with a mastery of distributed data architectures essential for data, analytical and operational ML applications with demonstrated proficiency in frameworks including Spark, Kafka, Kubernetes, SageMaker, DBT, Jupyter Notebooks, Docker, SQL, and visualization tools such as Power BI/Tableau.
Required Education: Bachelor's Degree
Required Skills:
1. Minimum 4 years of hands-on experience hydrating the enterprise Data Lake on a Cloud Service Provider (AWS, Azure, or Google) from relational, semi-structured and unstructured data sources by building Extract and Load Data Pipelines.
2. Minimum 4 years hands-on experience transforming datasets in a Data Lake on a Cloud Service Provider to deliver Data Products with traceability of their attributes/features to the Critical Data Elements in the systems of record.
3. Minimum 2 years experience enforcing Data Sharing Policies on Data Products so users see only the version of the Data Product they are entitled to at the time of subscription.
Preferred Skills:
- DevOps tools including GitHub/Jenkins/Terraform/YAML/DAGs/Docker/Databricks/SageMaker for building Data/ML pipelines to parquet destinations.
- Promoting Data Engineering Standards and Best Practices among developers.
- Implementing Data Governance and Data Security tools on a CSP to automate enforcement of Data Sharing Policies at the point of subscription.
Roles and Responsibilities:
Primary State of Michigan technology lead engaging with the UoM proof of concept team to support best practice adoption within the state hosting environment, and providing training to DAV data engineers.
- Oversee the design, development, and maintenance of data pipelines for analytics and operational systems.
- Architect and optimize data infrastructure, including storage, orchestration frameworks, and ETL/ELT processes.
- Ensure data quality, reliability, and security through standards, monitoring, validation and governance.
- Lead and mentor data engineering staff, review designs/code.
- Collaborate with data scientists, analysts, product teams, and business stakeholders.
Other Desired Skills:
- BS in Computer Science / Data Science / Information Systems with 4+ years designing and implementing data, analytics, and AI solutions for large enterprises on AWS/Microsoft/Google.
- 4+ years modeling relational data with Python/PySpark/SQL, tuning SQL, and loading multiple sources (relational DB, flat files, CSV, HTML, JSON) into Lakehouse Medallion architecture in parquet.
- 4+ years in Python, R, Spark.
- Designing and delivering Star-schema operational data stores for Power BI visualization (required).
Key Languages: SQL, Python, R, Spark, Terraform, DAGs, YAML, Docker
Other Technologies: Jupyter Notebooks, NoSQL DB, Graph DB, Parquet, Lakehouse/Medallion, Kafka, Kubernetes, Glue, Databricks, Power BI, Tableau, Redshift Spectrum, SageMaker, DBT, DataHub, Machine Learning, GitHub, DevOps
Similar jobs
- LS

Senior Database EngineerRecently posted
London Stock Exchange Group · St Louis, MO · Hybrid · Posted 17 Nov 2026 🇺🇸
OracleShellAWS+5TechnologySalary not listed - KT

Senior Data EngineerRecently posted
Kforce Technology Staffing · Atlanta, GA · Hybrid · Posted 17 Nov 2026 🇺🇸
SQLETLAirflow+5TechnologySalary not listed - QT

Data Engineer LeadRecently posted
QUANTUM TECHNOLOGIES LLC · United States · Hybrid · Posted 17 Nov 2026 🇺🇸
DockerSQLGit+12Technology$83/hr - TE
Data Engineer - San Antonio, TX, Dallas, TX, Austin, TX, Houston, TXRecently posted
TechniPros, LLC · San Antonio, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+2TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · Remote - No Preference · Remote · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · NYC - Hybrid · Hybrid · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - SI

Data Engineer - VC Backed StartupsRecently posted Auto Apply
Signalfire · Bay Area - Hybrid · Hybrid · Posted 17 Nov 2026 🇺🇸
Talent AcquisitionDockerDynamoDB+23TechnologySalary not listed - RS
Senior Azure Data Engineer – Databricks & Microsoft Fabric (only Local candidates from Houston)Recently posted
ResolveTech Solutions Inc. · Houston, TX · On-site · Posted 16 Nov 2026 🇺🇸
OracleSQLGit+13TechnologySalary not listed - DD

Senior Databricks EngineerRecently posted
Dexian DISYS · Plano, TX · Hybrid · Posted 16 Nov 2026 🇺🇸
UnityEngineeringSalary not listed - BC

Data Engineer IV (Customer Experience)Recently posted
BCforward · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLApache SparkETL+6Technology$81 - $85/hr - UC
Data Core SupervisorRecently posted Auto Apply
UCSF · San Francisco · Hybrid · Posted 17 Nov 2026 🇺🇸
RecruitingOnboardingClinical Research+7Salary not listed - SP

Data EngineerRecently posted
SSI People · United States · Hybrid · Posted 16 Nov 2026 🇺🇸
SQLETLScikit-learn+6TechnologySalary not listed