Data Warehouse Architect

Zenfreed•Lansing, MI
•Hybrid

About The Position

The Data Engineering Lead serves as the primary State of Michigan technology lead, working with the University of Michigan proof-of-concept team to support adoption of best practices in the state hosting environment and provide training to DAV data engineers. The role focuses on data modeling, Lakehouse and machine-learning product delivery through an agile DevOps framework, and distributed data architectures for data, analytics, and operational ML applications. The position oversees data pipelines and data infrastructure, and helps ensure that data products are reliable, secure, governed, and suited to organizational needs. It also provides technical guidance and mentorship to data engineering staff and collaborates with data scientists, analysts, product teams, and business stakeholders. This is a W2 position for 40 hours per week on a hybrid schedule. Wednesday and Thursday are required in-office days; remote-only work is not available. Candidates must be local to the Lansing, Michigan area or relocate before their first day at their own expense and be ready to work onsite from day one. The stated work hours are Monday through Friday, approximately 8:00 a.m. to 5:00 p.m. Candidates must be authorized to work in the United States; sponsorship is not available. Employment requires a background check and drug screening.

Requirements

  • At least 4 years of hands-on experience building extract-and-load data pipelines to hydrate an enterprise data lake on a cloud service provider (AWS, Azure, or Google) from relational, semi-structured, and unstructured data sources.
  • At least 4 years of hands-on experience transforming datasets in a cloud data lake to deliver data products, with traceability of attributes or features to critical data elements in systems of record.
  • At least 2 years of experience enforcing data-sharing policies so users can access only the version of a data product to which they are entitled when they subscribe.
  • At least 4 years of experience modeling and leveraging relational data services, with proficiency in Python, PySpark, and SQL programming and tuning SQL queries to extract data from multiple sources.
  • Experience extracting data from relational databases, flat files, CSV, HTML, and JSON sources into a Lakehouse Medallion architecture in Parquet formats.
  • Experience designing and implementing data, analytics, and AI solutions for large enterprises by building data pipelines with cloud service provider data-platform tools.
  • Experience designing and delivering a star-schema-based operational data store to enable visualization of program activities and outcomes in a tool such as Power BI.
  • Bachelor's degree in Computer Science, Data Science, or Information Systems.
  • Must be authorized to work in the United States; sponsorship is unavailable.
  • Must undergo an employment background check and drug screening.
  • Local to the Lansing, Michigan area or willing to relocate before the first day at the candidate's own expense and work onsite from day one.
  • Must work onsite Wednesday and Thursday under the hybrid schedule; remote-only work is not available.

Nice To Haves

  • Proficiency with DevOps tools including GitHub, Jenkins, Terraform, YAML, DAGs, Docker, Databricks, and SageMaker for building data and ML pipelines that extract and store data from multiple sources in Parquet destinations.
  • Experience promoting data engineering standards and best practices among developer communities to support scalable, maintainable data and ML product delivery.
  • Experience implementing cloud service provider data-governance and data-security tools to automate enforcement of data-sharing policies when subscribers access data products.

Responsibilities

  • Oversee the design, development, and maintenance of data pipelines that move, transform, and prepare data for analytics and operational systems.
  • Architect and optimize data infrastructure, including storage solutions, orchestration frameworks, and ETL/ELT processes.
  • Establish standards, monitoring systems, validation, and governance practices to ensure data quality, reliability, and security.
  • Lead and mentor data engineering staff by providing technical guidance, reviewing designs and code, and supporting professional growth.
  • Collaborate with data scientists, analysts, product teams, and business stakeholders to ensure data solutions meet organizational needs and strategic goals.
  • Engage with the University of Michigan proof-of-concept team as the primary State of Michigan technology lead to support best-practice adoption in the state hosting environment.
  • Provide training to DAV data engineers.

Benefits

  • Medical coverage options
  • Dental coverage options
  • Vision coverage options
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service