Data Warehouse Architect

Manager has requested 2 professional references for this role, please attach to submission in a separate document.

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.