Data Warehouse Architect

We are looking for a hands-on Lead Data Engineer / Cloud Data Warehouse Architect to design, build, and optimize scalable cloud data pipelines, Lakehouse architectures, and enterprise data/ML products. In this position, you will establish data engineering best practices, enforce data governance policies, mentor engineering staff, and collaborate across data science and analytics teams.

Role: Lead Data Engineer / Cloud Data Warehouse Architect

Location: Lansing, MI (Onsite required from Day 1; occasional travel to Ann Arbor, MI)

Work Arrangement: Hybrid (Mandatory in-office on Wednesdays & Thursdays - no remote-only option)

Education: Bachelor's Degree in Computer Science, Data Science, or Information Systems

About the Position

We are looking for a hands-on Lead Data Engineer / Cloud Data Warehouse Architect to design, build, and optimize scalable cloud data pipelines, Lakehouse architectures, and enterprise data/ML products. In this position, you will establish data engineering best practices, enforce data governance policies, mentor engineering staff, and collaborate across data science and analytics teams.

Must-Have Skills & Experience

• Cloud Data Lake Engineering (4+ Years): Hands-on experience ingesting relational, semi-structured, and unstructured data into enterprise Data Lakes (AWS, Azure, or GCP) via Extract & Load pipelines.
• Data Transformation & Lineage (4+ Years): Transforming cloud Data Lake datasets into production Data Products with clear traceability to Critical Data Elements (CDEs) in source systems.
• Data Modeling & Programming (4+ Years): Strong proficiency in SQL, Python, PySpark, and R, query tuning, Star-schema operational data stores, and Lakehouse / Medallion Architecture (Parquet formats).
• Data Governance & Access Control (2+ Years): Enforcing row/column-level Data Sharing Policies so subscribers only access entitled data versions.
• Communication: Clear, concise written and verbal communication to lead technical discussions and mentor peers.

Preferred Tech Stack

• Cloud & Big Data: Databricks, Spark, Kafka, AWS Glue, Redshift Spectrum, SageMaker, DBT
• DevOps & Orchestration: Terraform, Docker, Kubernetes, GitHub, Jenkins, YAML, DAGs
• Databases & BI: Relational, NoSQL, Graph DBs, Power BI, Tableau

Interview Process

• Round 1: Virtual interview (Candidates must join from a laptop, be ready to share their screen, and provide a live verification photo).
• Round 2: In-person interview in Lansing, MI.