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.