Data Warehouse Architect 5

Lansing, MI, US • Posted 2 hours ago • Updated 2 hours ago
Contract Corp To Corp
Contract W2
On-site
$DOE
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • IBM DataStage
  • Advanced SQL
  • Data Warehouse Architect 5
  • IBM Cloud Pak for Data (CP4D)
  • Teradata 20
  • SQL/BTEQ
  • Unix/Linux scripting
  • ETL support
  • hands-on experience with IBM Cloud Pak for Data (CP4D).
  • strong experience with Teradata 20
  • including SQL/BTEQ
  • performance optimization
  • and working with large enterprise datasets.
  • Unix/Linux scripting and system operations
  • Advanced SQL for analysis and ETL support

Summary

Role: Data Warehouse Architect 5

Location: Lansing, MI

Work Mode: Hybrid

Duration: 12 Months

Required Skills:

  • Public health, Health Industry, or State Government experience. Preferred.
  • Hands-on experience with IBM Cloud Pak for Data (CP4D). Required. 1 + yrs.
  • Strong experience with Teradata 20, including SQL/BTEQ, performance optimization, and working with large enterprise datasets. Required. 3 + yrs.
  • Unix/Linux scripting and system operations. Required. 5 + yrs.
  • Master Data Management (MDM) and data governance principles. Required.
  • Create automation scripts using Python, Shell scripting. Required.

Data Warehouse Architect 5, IBM DataStage, IBM Cloud Pak for Data (CP4D), Teradata 20, SQL/BTEQ, Unix/Linux scripting, Advanced SQL, ETL support.

Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Position will be hybrid, in office 2 days a week upon start, Wednesday and Thursday are required on-site days and cannot be altered.

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10477050
  • Position Id: 2026-57299
  • Posted 2 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lansing, Michigan

Today

Easy Apply

Third Party, Contract

Hybrid in Lansing, Michigan

Today

Easy Apply

Contract

DOE

Lansing, Michigan

Today

Easy Apply

Third Party, Contract

$95

Lansing, Michigan

2d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs