Senior Data Warehouse Architect / Senior ETL Developer

Senior Data Warehouse Architect / Senior ETL DeveloperThe Michigan Department of Health and Human Services (MDHHS), in partnership with the DTMB AS Analytics and Visualization Division, is seeking a Senior ETL Developer / Data Warehouse professional with extensive experience in IBM DataStage, IBM Cloud Pak for Data (CP4D), and Teradata 20.The selected candidate will support enterprise data modernization initiatives, including the migration of legacy workloads to IBM Cloud Pak for Data (CP4D), development and optimization of robust ETL pipelines, and technical initiatives involving data quality, governance, and integration.This role requires strong analytical capabilities, advanced ETL engineering skills, and the ability to work effectively within complex enterprise data environments.Key ResponsibilitiesDesign, build, enhance, and optimize ETL pipelines using IBM DataStage, including parallel jobs, server jobs, performance tuning, and job sequencing.Support migration of DataStage workloads from on-premises environments to IBM Cloud Pak for Data (CP4D).Perform refactoring, modernization, testing, and validation during CP4D migrations.Develop and optimize complex SQL and BTEQ scripts for Teradata 20.Support large-scale data integration and analytics workloads.Create automation scripts using Python, shell scripting, and XML.Apply Master Data Management (MDM) and data governance principles to ensure data consistency, quality, and reliability.Collaborate with MDHHS data architects, DBAs, analysts, business owners, and technical teams.Align technical deliverables with program objectives.Troubleshoot ETL pipeline issues and perform root-cause analysis and remediation.Participate in Agile delivery activities, including sprint participation, documentation, testing, and continuous improvement.Required Qualifications1+ year of hands-on experience with IBM Cloud Pak for Data (CP4D).3+ years of experience with Teradata 20, including SQL/BTEQ, performance optimization, and large enterprise datasets.5+ years of Unix/Linux scripting and system operations experience.3+ years of advanced SQL experience supporting analysis and ETL.Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field.Preferred QualificationsPublic health, healthcare, or state government experience.5+ years of experience developing ETL solutions using IBM DataStage.Proficiency with Python for automation.Experience with MDM, data quality, and data governance methodologies.Proven ability to translate business and technical requirements into scalable ETL and data integration solutions.Experience working in large, complex enterprise data environments with multiple data sources.Previous experience supporting State of Michigan projects or other public-sector environments.Knowledge of IBM Knowledge Catalog, including metadata, data lineage, and governance.Exposure to IBM Manta for lineage and impact analysis.Familiarity with cloud-native platforms such as OpenShift and Kubernetes.Experience with CI/CD pipelines, version control, and Agile methodologies.Key Skills to PrioritizeMust-have / Highest Priority:IBM DataStageIBM Cloud Pak for Data (CP4D)Teradata 20Advanced SQL / BTEQUnix/Linux scriptingETL development and modernizationStrong Plus:PythonMDM / Data GovernanceIBM Knowledge CatalogIBM MantaOpenShift / KubernetesCI/CDState of Michigan / public-sector experienceIdeal CandidateThis is a specialized Senior ETL/Data Warehouse role, not a generic Data Engineer position. The strongest candidates will have hands-on DataStage + CP4D + Teradata 20 experience and be local to Michigan, preferably the Lansing area.