_{07th August, 2026}

Data Warehouse Architect #1062147
Job Description:
Job Summary:
The MDHHS/DTMB AS Analytics and Visualization Division is seeking a Senior ETL Developer with extensive experience in IBM DataStage, 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:

• 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 our 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.

 
Additional Info:
 
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve and have a little fun along the way.
We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!
FastTek Global is a financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
 

• Medical and Dental (FastTek pays majority of the medical program)
• Vision
• Personal Time Off (PTO) Program
• Long Term Disability (100% paid)
• Life Insurance (100% paid)
• 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match

 
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023!
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/
AI & Hiring Disclosure
We use AI tools to support parts of our hiring process, such as reviewing applications and identifying potential matches. These tools are designed to promote efficiency, consistency, and fairness, and they are always used under human oversight.
All personal data collected is used solely for recruitment purposes, and you have the right to know, access, or request deletion of your data at any time, subject to legal limits.
If AI will be used in a video interview, you'll be informed in advance and asked for your consent, with the option to opt out.
Our tools are regularly reviewed to detect potential bias and to ensure compliance with all applicable laws and our commitment to inclusive hiring.
To learn more or exercise your rights, please contact us at info@fasttek.com.

Apply For Job