Data Warehouse Architect
Full Job Description
Data Warehouse Architect (Level 3) - Data Engineering Lead
Location: Lansing, MI 48933
We are seeking a highly skilled Data Engineer Lead / Data Warehouse Architect with an extensive track record in data modeling, Lakehouse and Medallion Architecture concepts. The ideal candidate will excel in delivering data/ML products using an agile DevOps framework within distributed data architectures essential for analytical and operational ML applications.
Roles and Responsibilities:
- Oversee the design, development, and maintenance of robust data pipelines that move, transform, and prepare high-quality data for analytics and operational systems.
- Architect and optimize complex data infrastructure, including scalable storage solutions, orchestration frameworks, and efficient ETL/ELT processes.
- Serve as the primary technology lead engaging with University of Michigan (UoM) proof-of-concept teams to support best practice adoption within state hosting environments. Provide training and mentorship to DAV data engineers on modern engineering standards.
- Ensure rigorous data quality, reliability, and security by establishing industry-standard governance practices, monitoring systems, and implementing validation protocols.
- Lead and mentor a team of data engineering staff through technical guidance, design/code reviews, and professional development initiatives.
- Collaborate with cross-functional partners—including data scientists, analysts, product teams, and business stakeholders—to ensure innovative data solutions meet organizational needs and strategic goals.
Required Qualifications & Skills:
Educational Background:Bachelor's degree in Computer Science/Data Science/Information Systems.
Total Experience:Minimum of 4+ years designing and implementing data, analytics, and AI solutions for large enterprises.
- Leverage cloud service provider tools (AWS/Microsoft Azure/Google Cloud) to build scalable pipelines using a Lakehouse Medallion architecture in Parquet format.
• Model relational data services with minimum 4 years of experience; demonstrate proficiency in Python/Pyspark/SQL, query tuning, and extracting from diverse sources (relational DBs, flat files, CSV, HTML, JSON). - Show demonstrated expertise (minimum 4 years) in programming/scripting languages including Python, R, Spark.
Required:Demonstrated experience designing and delivering Star-schema based operational data stores to enable visualization of program activities/outcomes using tools like Power BI/Tableau.
Key Technologies & Frameworks:
Languages/Scripting: SQL, Python, R, Spark, Terraform Scripting, DAG/YAML scripting, Docker.
Platforms/Concepts: Juniper Notebooks, NoSQL DBs, Graph DBs (Neo4j), Parquet DB, Lakehouse/Medallion Architecture, Kafka, Kubernetes, AWS Glue, Databricks, Power BI/Tableau, Redshift Spectrum, SageMaker, dbt, Datahub.
Pipelines: Machine Learning implementation and CI/CD DevOps practices.
Company
ARK Solutions, Inc.
ARK Solutions, Inc. is a technology solutions provider seeking to engage experienced professionals for long-term contract opportunities in Lansing, MI.
Practice this interview
A voice mock interview for Data Warehouse Architect at ARK Solutions, Inc., with questions from this job description and your resume, and a scored report afterwards.
Set up interview