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.