Data Engineer Lead / Data Warehouse Architect

Govan Systems inc

Lansing (MI)

Hybrid

USD 120,000 - 180,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Govan Systems inc in Michigan seeks a Data Engineer Lead / Data Warehouse Architect to guide data infrastructure and delivery of analytics and ML products in a hybrid Lansing environment. You will oversee data pipelines, governance, and collaboration with data science teams.

The role requires hands-on expertise with Spark, Kafka, Kubernetes, SageMaker, DBT, and visualization tools like Power BI/Tableau, plus strong DevOps practices and cloud experience.

Qualifications

  • Minimum 4 years building data pipelines on a cloud provider (AWS/Azure/GCP).
  • Minimum 4 years transforming datasets to deliver data products with traceability.
  • Minimum 2 years enforcing data sharing policies on data products.

Responsibilities

  • Oversee design, development, and maintenance of data pipelines for analytics and operational systems.
  • Architect and optimize data infrastructure, including storage, orchestration, and ETL/ELT processes.
  • Ensure data quality, reliability, and security through standards, monitoring, validation and governance.
  • Lead and mentor data engineering staff, review designs and code.
  • Collaborate with data scientists, analysts, product teams, and business stakeholders.
  • Engage with UoM proof of concept team to support best practices in the state hosting environment.

Skills

Data Pipelines
Data Transformation
Data Sharing Policy

Education

Bachelor's Degree

Tools

Spark
Kafka
Kubernetes
SageMaker
DBT
Jupyter Notebooks
Docker
Databricks
Power BI
Tableau
Redshift Spectrum
Glue
GitHub
Terraform
YAML

Job description

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.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data Engineer
Lead Data Engineer

MasterApp Labs • Lansing (MI)

Hybrid
USD 83,000 - 165,000
401(k) matching
Dental insurance
Health insurance
+1
Lead Data Engineer/Architect - DHHS
Lead Data Engineer/Architect - DHHS

IO Datasphere, Inc. • Lansing (MI)

On-site
USD 90,000 - 140,000
MI-Lead Data Engineer/Architect
MI-Lead Data Engineer/Architect

AiQualTest LLC • Town of Lansing (NY)

On-site
USD 120,000 - 180,000
Lead Data Engineer/Architect
Lead Data Engineer/Architect

I O DATASPHERE • Lansing (MI)

On-site
USD 90,000 - 130,000
Data Engineer Lead
Data Engineer Lead

Robotic Technologies Automation • Lansing (MI)

On-site
USD 83,000 - 124,000
Data Engineer Lead
Data Engineer Lead

Ethereum Technologies • Lansing (MI)

On-site
USD 83,000 - 118,000
Data Warehouse Architect 3- (Hybrid)
Data Warehouse Architect 3- (Hybrid)

GSK Solutions Inc. • Lansing (MI)

Hybrid
USD 110,000 - 117,000
Data Warehouse Architect
Data Warehouse Architect

RICEFW Technologies Inc • Lansing (MI)

On-site
USD 140,000 - 200,000
Azure Bachelors Degree Architect
Azure Bachelors Degree Architect

COOLSOFT • Lansing (MI)

Hybrid
USD 85,000 - 110,000
Data Warehouse Architect / Data Engineering Lead
Data Warehouse Architect / Data Engineering Lead

Value Innovation Labs • Lansing (MI)

Hybrid
USD 140,000 - 200,000