Loading, Please wait..!!
Data Warehouse Architect
-
Posted on: Nov 17, 2026
-
Lansing, Michigan
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Data Warehouse Architect roles in Michigan.
View Salary Guide →Find your match !
Job Title :
Data Warehouse Architect
Job Type :
Full-Time
Job Location :
Lansing Michigan United States
Remote :
No
Job Description :
The Data Warehouse Architect 3 is a technical leadership role focused on designing, developing, and maintaining enterprise data pipelines and infrastructure within a cloud environment. This role requires expertise in data modeling, Lakehouse and Medallion Architecture, and delivery of data and machine learning products using agile DevOps practices. The architect will collaborate with cross-functional teams, enforce data governance, and mentor data engineers to support the State of Michigan's data initiatives.
Responsibilities:- Design, develop, and maintain data pipelines to move, transform, and prepare data for analytics and operational use.
- Architect and optimize data infrastructure including storage, orchestration frameworks, and ETL/ELT processes.
- Ensure data quality, reliability, and security by establishing standards and governance practices.
- Lead and mentor data engineering staff by providing technical guidance and code reviews.
- Collaborate with data scientists, analysts, product teams, and business stakeholders to meet organizational data needs.
- Support best practice adoption and provide training to data engineers within the state hosting environment.
- Enforce data sharing policies and automate data governance using cloud service provider tools.
- Bachelor's degree in Computer Science, Data Science, Information Systems, or related field.
- Minimum 4 years hands-on experience building and hydrating enterprise Data Lakes on cloud platforms (AWS, Azure, or Google).
- Minimum 4 years experience transforming datasets in a Data Lake to deliver traceable Data Products.
- At least 2 years experience enforcing Data Sharing Policies to control user access to Data Products.
- Proficiency in SQL, Python, R, Spark, and related data programming languages.
- Experience with data modeling, Lakehouse, and Medallion Architecture concepts.
- Knowledge of relational, semi-structured, and unstructured data sources and formats (CSV, JSON, Parquet, etc.).
- Strong written and verbal communication skills.
- Experience designing star-schema operational data stores and using visualization tools like Power BI or Tableau.
- Proficiency with DevOps tools such as GitHub, Jenkins, Terraform, YAML, DAGs, Docker, Databricks, and SageMaker.
- Experience promoting data engineering standards and best practices across developer communities.
- Experience implementing data governance and security automation on cloud platforms.
- Familiarity with Kafka, Kubernetes, NoSQL and Graph databases, Glue, DBT, and machine learning frameworks.
- Experience with scripting and orchestration tools including Terraform scripting, DAGs scripting, and YAML.
- Hybrid work schedule with mandatory in-office presence on Wednesdays and Thursdays (non-negotiable).
- Candidates must be located in or willing to relocate to the Lansing, Michigan area prior to start date at their own expense.
- Occasional travel to Ann Arbor for in-person meetings is required.
- Security clearance and right to represent documentation required.
- Candidate must be prepared for both virtual and in-person interviews, including screen sharing and identity verification.
- Full-time position, 40 hours per week.
- Hybrid schedule with required in-office days on Wednesday and Thursday.
- Assignment duration projected from December 10, 2026, through November 1, 2027, with possible extension based on business needs.
Similar Jobs You May Be Interested In
Data Engineer Lead Data Warehouse Architect
Data Warehouse Architect
Data Engineer Lead Data Warehouse Architect
Data Warehouse Architect Hybrid
Data Engineer Lead Data Warehouse Architect
Data Warehouse Architect / Data Engineering Lead
Data Engineer Lead / Data Warehouse Architect
Data Warehouse Architect
Dhhs Data Warehouse Architect
Data Warehouse Architect
Data Warehouse Architect
Data Warehouse BI Architect
Position Details
Posted:
Nov 17, 2026
Reference Number:
208013-17788
Employment:
Full-time
City:
Lansing
Job Origin:
CIEPAL_ORGANIC_FEED
Share this job:
Please wait..!!

