Data Warehouse Architect 3

Posting Closes on 07/15/206 at 10am EST

In-Person interviews will be conducted  

Duration: This is a 6-month project ending 02/10/2027. The person for this project will be supporting the migration of two IBM tools (from ATL DataStage to Cloud Pak)

Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. ((Monday/Tuesday)

Local candidates ONLY candidates must be located in Michigan at time of submission

Top Skills & Years of Experience:

- 5+ years of experience with ETL (IBM DataStage) - Required

- 1+ years of exposure to Cloud Pak for data - Required

- 5+ years of experience with Unix/Linux

- 3+ years of experience with Master Data Management

Responsibilities and Technical Skills

• Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
• Support the migration of on‑premise DataStage jobs to IBM Cloud Pak for Data (CP4D), including code refactoring, testing, validation, and workflow modernization.
• Use Python and XML to automate processes, perform data transformations, and integrate automation into ETL workflows.
• Work extensively in Linux/Unix environments to write shell scripts, manage file systems, monitor processes, and troubleshoot runtime issues.
• Apply Master Data Management (MDM) principles to ensure data quality, governance, and consistency across enterprise systems.
• Develop complex SQL queries for data extraction, transformation, validation, and performance improvement across relational database platforms.
• Work within Agile teams to support sprint activities, deployments, documentation, and continuous improvement practices.
• Collaborate with data architects, analysts, DBAs, and business users to ensure successful and accurate delivery of data solutions.
• Troubleshoot ETL issues, perform root‑cause analysis, recommend improvements, and ensure adherence to data standards and security policies.

Desired Skills:

- Previous Government experience