Data Warehouse Architect 5 - Local to Michigan preferred
IntelliX Software, Inc.
Dice Job Match Score™
👤 Reviewing your profile...
Job Details
Skills
- CP4D
- Cloud Pak for Data
- Teradata 20
- Teradata
- Unix
- Linux
- Advanced SQL
- ETL
- BTEQ
- SQL
- Python
- MDM
Summary
Position- Data Warehouse Architect 5
Location- Lansing, MI
Hybrid- 2 days’ office in week
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 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.
- Dice Id: 90614925
- Position Id: 1639-25622-1786362148
- Posted 10 hours ago
Company Info
About IntelliX Software, Inc.
By combining a highly-skilled local presence with a proven global development model, IntelliX delivers exceptional value to its customers, becoming a partner in their success.
Founded in 2005, IntelliX Software is a privately-owned company headquartered in the United States, Columbus, Ohio. From the beginning, the owners recognized an opportunity to create a new approach to IT services. IntelliX’ onsite/offshore model is the best of both worlds, providing onsite, local experts to develop one-on-one relationships, backed by global company resources and capabilities. This unique model has allowed IntelliX to craft a custom solution for each and every customer.
Our Vision
To earn global admiration as an IT Outsourcer, by building and maintaining long lasting relationship with people and technology and deliver functional software and excellent services.
We ensure an excellent relationship with our internal and external team; our employees and our clients. Our Team members work towards maximization of profits and to assist as well as enhance our clients’ business profits, productivity and also aim at overall growth of the business venture. We value our customers and try very hard to satisfy them in every way. Our functioning is transparent and we are totally committed towards team work, which would result in better results for our clients.
Our Mission
To strive hard to be a winner in various sectors of Software Outsourcing and consulting, maintaining excellence in our work culture. We also believe in implementing new and innovative concepts in our various project development processes, while ensuring cost effectiveness along with required solutions to our prospective clients.
Partnering with various clients help in bringing fresh ideas into the firm ensuring our youth in innovation, thus improving our quality standards accompanied with growth in the business productivity to be a trustworthy as well as a fair business partner Strong adherence to maintaining quality work along with its regular up-gradation. We would like to also motivate our staff to keep up high standards, keeping in view our clients’ complete satisfaction.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs