Data Warehouse Architect

RG Talent Inc; Lansing (MI); On-site; USD 90,000 - 130,000; Full time

Job summary

RG Talent Inc. is seeking a data integration specialist with CP4D and Teradata expertise. The role requires SQL/BTEQ, Unix/Linux scripting, and strong ETL capabilities for handling large enterprise datasets.

Preferred background includes public health or state government projects, with knowledge of data governance, OpenShift or Kubernetes, and modern CI/CD practices. Bachelor’s degree required.

Qualifications

• Hands-on CP4D experience for data analytics and integration.
• Teradata 20 with SQL/BTEQ, performance optimization on large datasets.
• Unix/Linux scripting and system operations expertise.
• Advanced SQL for analysis and ETL support; strong data integration skills.
• Experience in public health or state government projects is a plus.

Skills

CP4D experience

Teradata 20 experience

Unix/Linux scripting

Advanced SQL

Public health/state govt experience

Python

MDM & data governance

Translate business requirements

Enterprise data environments

CI/CD & Agile

Education

Bachelor’s degree in computer science, Information Systems, Data Analytics, or related field

Tools

IBM Cloud Pak for Data

Teradata 20

IBM DataStage

IBM Knowledge Catalog

OpenShift

Kubernetes

Git/version control

Job description

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 State of Michigan 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.

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.