Teradata Architect

COOLSOFT; Michigan; Hybrid; USD 90,000 - 120,000; Full time

Job summary

COOLSOFT is seeking a Senior ETL Architect to design, implement, and optimize DataStage-based ETL pipelines. The role includes migrating on‑prem DataStage workloads to IBM Cloud Pak for Data (CP4D) and building scalable data integrations acrossTeradata 20 environments.

You will develop complex SQL/BTEQ scripts, automate ETL workflows with Python, Shell, and XML, and apply MDM and data governance across enterprise data assets. Strong collaboration with MDHHS data teams is required.

Qualifications

• Bachelor's degree in CS, IS, data analytics, or related field.
• Experience with IBM DataStage ETL development.
• Exposure to CP4D and Teradata 20 is preferred.

Responsibilities

• Design, build, and optimize ETL pipelines with IBM DataStage.
• Support migration of DataStage workloads to CP4D.
• Develop SQL/BTEQ queries for Teradata 20.
• Create automation scripts in Python, Shell, XML.
• Apply MDM and data governance principles across systems.
• Collaborate with data architects, DBAs, analysts, and business owners.
• Troubleshoot ETL issues and perform root cause analysis.
• Support Agile delivery and continuous improvement.

Skills

CP4D experience

Teradata 20

Unix/Linux scripting

Advanced SQL

Education

Bachelor's degree in Computer Science or related field

Tools

IBM DataStage

Python

Shell scripting

Job description

Job Overview

• Location: Lansing, MI
• Contract: Contract
• Duration: 12 Months
• Compensation: DOE

Job title: Architect

Start date: 8/31/2026

End date: 1 Years from projected start date

Client Info: DHHS

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.

Notes

• Manager has requested 2 professional references for this role, please attach to submission in a separate document.
• Interview Process: In-person and Virtual. 1-2 rounds, mix of technical and soft skill interviews. For virtual interviews candidates should join from a laptop and be prepared to share their screen if requested.
• A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual interview to validate candidate.
• Candidate Location: Open to candidates local to the Lansing, Michigan area or those willing to relocate at their own expense with no delays. Candidate MUST relocate before day 1.

Client is seeking a Senior ETL Developer with extensive experience in IBM Data Stage, IBM Cloud Pak for Data (CP4D), and Teradata 20. The resource will support enterprise data modernization efforts, including migration of legacy workloads to CP4D, development of robust ETL pipelines, and technical leadership for data quality, governance, and integration initiatives. This role requires strong analytical capabilities, advanced ETL engineering skills, and the ability to work effectively across complex enterprise environments.

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:

Bachelors 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.

EOE Protected Veterans/Disability