Data Warehouse Architect

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 year 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 years 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.

Assignment duration: projected to be a 1-year contract, dependent on business need.

Hybrid work schedule (non-negotiable): Wednesdays and Thursdays are the on-site days each week. Candidates MUST be able to work these days on-site from the beginning. This is non-negotiable and there is NO remote-only option.