Data Warehouse Architect 5 - Local to Michigan preferred

Position- Data Warehouse Architect 5

Location- Lansing, MI

Hybrid- 2 days' office in week

Key Responsibilities

• Design, build, enhance, and optimize ETL pipelines using IBM DataStage (parallel/server jobs, performance tuning, job sequencing).
• Support the migration of DataStage workloads from on premise environments to IBM Cloud Pak for Data (CP4D) , including refactoring, modernization, testing, and validation.
• Develop and optimize complex SQL and BTEQ scripts for Teradata 20 , supporting large-scale data integrations and analytics workloads.
• Create automation scripts using Python , Shell scripting , and XML for ETL workflows and data processing.
• Apply Master Data Management (MDM) and data governance principles to ensure consistency, quality, and reliability across systems.
• Work collaboratively with MDHHS data architects, DBAs, analysts, business owners, and technical teams to align deliverables with program objectives.
• Conduct troubleshooting, root cause analysis, and remediation activities for ETL pipeline issues.
• Support Agile delivery, including sprint participation, documentation, testing, and continuous improvement activities.

Required Skills
-1+ years of hands-on experience with IBM Cloud Pak for Data (CP4D).




-3+ years of strong experience with Teradata 20, including SQL/BTEQ, performance optimization, and working with large enterprise datasets.




- 5+ of Unix/Linux scripting and system operations




3 + years of Advanced SQL for analysis and ETL support







Preferred Skills
- Public health, Health Industry, or State Government experience

Required Education
- Bachelor's degree in computer science, Information Systems, Data Analytics, or related field.

Other desired Skills

• 5+ years of experience developing ETL solutions using IBM DataStage.
• Proficiency in:
• Python for automation
• MDM, data quality, and data governance methodologies
• Proven ability to translate business and technical requirements into scalable ETL and data integration solutions.
• Experience in large, complex enterprise data environments with multiple data sources.

• Prior experience supporting State of Michigan projects or other public-sector environments.
• Knowledge of IBM Knowledge Catalog (metadata, lineage, governance).
• Exposure to IBM Manta for lineage and impact analysis.
• Familiarity with cloud-native platforms such as OpenShift or Kubernetes.
• Experience with CI/CD pipelines, version control, and Agile methodologies.