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.