Data Warehouse Architect

Role Overview

We are seeking an experienced Data Warehouse Architect / Data Engineering Lead (Level 3) for a direct client position in Lansing, MI. This role is critical to shaping the state of Michigan's data landscape by designing robust enterprise data pipelines and enforcing rigorous security policies.

Key Responsibilities

• Architect and optimize distributed data infrastructures using Cloud Service Providers (AWS/Azure/Google) with expertise in Lakehouse, Medallion Architecture concepts, and Spark/Kafka ecosystems.
• Build ETL/ELT pipelines to hydrate enterprise Data Lakes from relational, semi-structured, and unstructured sources into parquet formats.
• Enforce Data Sharing Policies at the point of subscription using DevOps automation (Jenkins/Terraform/Docker) to ensure users access only authorized data versions.
• Serve as a primary State of Michigan technology lead engaging with UoM teams, providing training and best-practice adoption within state hosting environments.

Required Skills

• Experience: Minimum 4 years hands-on experience in data lake hydration, transformation, and pipeline building on CSP platforms (AWS/Azure/Google).
• Data Modeling: Proficiency in designing Star-schema operational data stores for Power BI/Tableau visualization.
• Tech Stack: Mastery of Python, PySpark, SQL, Terraform, YAML, DAGs, Docker, Kubernetes, and ML frameworks like SageMaker/DBT.