New!
Senior ETL Developer / Data Warehouse Architect PROLIM Corporation
Lansing, MI1 day ago
- $80–$90 Per Hour
- Contractor
Highlights
This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more. 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.
Numbers & Facts
| Location | Lansing, MI |
| Industry | Computer/IT Services |
| Salary | $100.74 |
| Company Size | 100 to 499 employees |
| Year Founded | 2009 |
| Website | http://www.tekwissen.com/ |
Description
Overview:
TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. The below Client runs through fifteen executive departments which carry out the day-to-day administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights, Environment, Health and Human Services, Natural Resources, Secretary of State. This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more. With positions in over 18 state departments, your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer.
Job Title: Data Warehouse Architect 5
Location: Lansing, MI 48933
Duration: 12 Months
Job Type: Hybrid
Work Type: Temporary Assignment
Shift: 8.00AM - 5.00 PM
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 client 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.
TekWissen Group is an equal opportunity employer supporting workforce diversity.
About Company
WE THE TEKWISSEN PEOPLE
TekWissen offers you a broader portfolio of services, industry-leading solutions, and the meaningful innovations that give you greater flexibility and speed to respond to market dynamics, reduced costs and risk to improve enterprise performance, and increased productivity to enable growth.
To keep pace with global market demands, TekWissen keeps its finger on the pulse of change. Our organized approach to guiding a project from its inception to closure. Managing projects is becoming more and more important as we enter the digital era. To cope with the pace that this transition demands, a method is required to manage projects so they can yield quality work, while incorporating efficient use of time and resources.
Project involves identifying which quality standards are relevant to the project and determining how to satisfy them.
It is important to perform quality planning during the Planning Process and should be done alongside the other project planning processes because changes in the quality will likely require changes in the other planning processes, or the desired product quality may require a detailed risk analysis of an identified problem. It is important to remember that quality should be planned, designed, then built in, not added on after the fact.
Capabilities and accomplishments in one TekWissen business enhance the opportunity for success in the others. Put simply, TekWissen's unique combination of attributes promotes success.Similar Jobs
Senior Data Engineer CFS
Lansing, MI7 days ago- $125,000–$155,000 Per Year
Datawarehouse Architect Govan Systems
Lansing, MI29 days ago- Contractor