Skip to content
Staffactory
  • Careers
Log inContact us
Loading roles…

Work with Staffactory

Browse jobsContact us

Services

  • Contract staffing
  • Contract-to-hire staffing
  • Direct hire staffing
  • IT solutions

Media

  • Blog
  • Vlogs
  • Case studies

Company

  • About
  • FAQ
  • Contact

Careers

  • Browse jobs

Legal

  • Terms & services
  • Privacy policy
Staffactory

We leverage decades of consulting experience in operations, technology, and staffing services to shape strategic roles and source exceptional candidates.

Staffactory LLC, 5901 W Century Blvd, Suite 750, Los Angeles, California 90045
contact@staffactory.com · +1 310-929-8421

© 2026 Staffactory LLC and its Affiliates. All rights reserved.

Careers

Find your dream job

Contract, contract-to-hire, and direct hire roles across the United States.

101 roles

Opening a role requires accepting our Terms and Conditions.

Project Manager 3

Lansing, MI · Hybrid · REQ-91009

Lab Technician

Brecksville, OH · Onsite · REQ-53870

IT Sourcing Consultant 2

Lansing, MI · Hybrid · REQ-16731

Communications Associate

Remote · Remote · REQ-69592

Business Analyst 5

Lansing, MI · Hybrid · REQ-85314

Project Manager 3

Lansing, MI · Hybrid · REQ-48175

Human Resources - Research Librarian

Washington, D.C. · Hybrid · REQ-11036

Field Service Technician

Salinas, CA · Onsite · REQ-63897

Field Service Technician

Rutland, VT · Onsite · REQ-26758

Legal - Ombudsman Specialist

Washington, D.C. · Hybrid · REQ-79619

Data Warehouse Architect 3

Location
Lansing, MI
Work type
Hybrid
Employment
Temporary · W2 or C2C
Req ID
REQ-58202
Apply now

About the role

Position: Data Warehouse Architect 3

Location: Lansing, MI 48917

Start Date: 12/10/2026

Minimum Education Level: Bachelor's Degree

REQUIRED:

  • Resume
  • R2R
  • Meets Work Location
  • Cover Sheet
  • References
  • Occasionally traveling to Ann Arbor for in-person meetings

Position Overview

We are seeking an experienced Data Engineering Lead / Data Warehouse Architect to lead the design, development, and implementation of enterprise data engineering solutions across cloud platforms.

The role focuses on building and maintaining enterprise Data Lakes, implementing Lakehouse and Medallion Architecture, developing scalable data pipelines, and delivering trusted data products for analytics, operational, and machine learning applications.

The selected candidate will serve as the primary technical lead, providing architectural guidance, promoting data engineering best practices, and mentoring data engineering teams. This position will also collaborate with data scientists, analysts, product teams, and business stakeholders to ensure data solutions align with enterprise requirements and strategic objectives.

Key Responsibilities

  • Lead the design, development, and maintenance of enterprise data pipelines that extract, ingest, transform, and prepare data from multiple sources.
  • Architect and optimize cloud-based data infrastructure, including Data Lakes, Lakehouse environments, storage solutions, orchestration frameworks, and ETL/ELT processes.
  • Develop scalable data products using Lakehouse and Medallion Architecture concepts.
  • Build data pipelines that ingest relational, semi-structured, and unstructured data from multiple sources.
  • Transform datasets into reliable data products while maintaining data lineage and traceability to critical data elements in systems of record.
  • Implement and enforce data-sharing policies to ensure users can access only the appropriate versions of subscribed data products based on their permissions.
  • Design and implement data models, including relational models and Star-schema-based operational data stores.
  • Develop and optimize data processing solutions using Python, PySpark, Spark, SQL, and other relevant programming technologies.
  • Establish data quality, validation, security, governance, and monitoring standards.
  • Architect and optimize data storage and processing solutions using cloud-native services and distributed data technologies.
  • Provide technical leadership, mentorship, and guidance to data engineering staff.
  • Review technical designs and code to ensure compliance with enterprise data engineering standards and best practices.
  • Collaborate with data scientists, analysts, developers, product teams, and business stakeholders to deliver scalable data and ML solutions.
  • Support the adoption of data engineering best practices and provide technical training to development teams.
  • Promote scalable, reliable, and supportable data and machine learning product delivery across the organization.

Required Qualifications

Education

  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.

Professional Experience

  • 4+ years of hands-on experience building and maintaining enterprise Data Lakes on a Cloud Service Provider (AWS, Azure, or Google Cloud) using relational, semi-structured, and unstructured data sources.
  • 4+ years of hands-on experience developing extraction and loading data pipelines.
  • 4+ years of experience transforming Data Lake datasets into data products while maintaining traceability of attributes and features to critical data elements in systems of record.
  • 2+ years of experience implementing and enforcing data-sharing policies to ensure users receive only the data product versions they are authorized to access at the time of subscription.
  • 4+ years of experience designing and implementing enterprise data, analytics, and AI solutions using cloud-based data platforms.
  • 4+ years of experience modeling and working with relational data services.
  • 4+ years of experience programming and developing data solutions using Python, PySpark, SQL, or similar technologies.
  • Experience developing and optimizing SQL queries to extract data from relational databases, flat files, CSV, HTML, JSON, and other data sources.
  • Experience implementing Lakehouse and Medallion Architecture using Parquet data formats.
  • Experience designing and delivering Star-schema-based operational data stores for reporting and visualization.
  • Strong written and verbal communication skills.

Preferred Qualifications

  • Proficiency with DevOps and infrastructure automation tools, including GitHub, Jenkins, Terraform, YAML, DAGs, and Docker.
  • Experience with Databricks, Amazon SageMaker, and other cloud-based data and machine learning platforms.
  • Experience building data and ML pipelines that extract and store data from multiple sources into Parquet destinations.
  • Experience promoting enterprise data engineering standards, architecture guidelines, and development best practices.
  • Experience mentoring developers and influencing teams to adopt scalable and supportable data and ML product delivery practices.
  • Experience implementing data governance and data security tools available through cloud service providers.
  • Knowledge of automated data-sharing policy enforcement and access controls at the point of data product subscription.
  • Experience with distributed data architectures and large-scale data processing.
  • Familiarity with data visualization tools such as Power BI and Tableau.

Technical Skills

Programming and Scripting

  • SQL
  • Python
  • R
  • Spark / PySpark
  • Terraform scripting
  • DAGs scripting
  • YAML scripting

Cloud and Data Engineering

  • AWS, Microsoft Azure, or Google Cloud
  • Databricks
  • Amazon SageMaker
  • AWS Glue
  • Lakehouse and Medallion Architecture
  • Parquet
  • Data pipelines and ETL/ELT
  • Data modeling

Big Data and Distributed Technologies

  • Apache Spark
  • Apache Kafka
  • Kubernetes
  • Docker
  • NoSQL databases
  • Graph databases

Data Governance and Analytics

  • DataHub
  • Data governance and data security
  • Data sharing policies
  • Data lineage and traceability
  • Power BI
  • Tableau

DevOps and Development Tools

  • GitHub
  • Jenkins
  • Terraform
  • YAML
  • DAGs
  • Juniper Notebooks
  • DBT

Key Competencies

  • Enterprise data architecture and engineering leadership.
  • Cloud-based Data Lake and Lakehouse implementation.
  • Data pipeline development and optimization.
  • Data governance, security, and access management.
  • Data modeling and product delivery.
  • Technical mentoring and knowledge sharing.
  • Cross-functional collaboration and stakeholder communication.

Requirements

Must have

  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.
  • 4+ years of hands-on experience building and maintaining enterprise Data Lakes on a Cloud Service Provider (AWS, Azure, or Google Cloud) using relational, semi-structured, and unstructured data sources.
  • 4+ years of hands-on experience developing extraction and loading data pipelines.
  • 4+ years of experience transforming Data Lake datasets into data products while maintaining traceability of attributes and features to critical data elements in systems of record.
  • 2+ years of experience implementing and enforcing data-sharing policies to ensure users receive only the data product versions they are authorized to access at the time of subscription.

Experience: 4–10 years

‹ All roles