> Markdown version of [/jobs/ext/1982953-data-warehouse-architect](https://www.wearedevelopers.com/jobs/ext/1982953-data-warehouse-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Warehouse Architect

- **Company:** OP Consulting Group LLC
- **Location:** United States
- **Contract:** Temporary contract
- **Skills:** Big Data, Information Systems, Data Governance, Extract Transform Load (ETL), IBM InfoSphere DataStage, IBM Cloud Computing, Python (Programming Language), Performance Tuning, Shell Script, SQL Databases, Teradata SQL, Extensible Markup Language (XML), Data Processing, Sql Optimization, Information Technology, Data Analytics, Data Management
- **Published:** August 8, 2026
- **Apply:** https://www.dice.com/job-detail/607742ed-aabc-4d43-b3eb-162d09fb66bf

## About the Role

* 1 year 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 years 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.

Assignment duration: projected to be a 1-year contract, dependent on business need.

Hybrid work schedule (non-negotiable): Wednesdays and Thursdays are the on-site days each week. Candidates MUST be able to work these days on-site from the beginning. This is non-negotiable and there is NO remote-only option.

## Description

* 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.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [MCP doesn’t suck — your agent does](https://www.wearedevelopers.com/videos/100202-mcp-doesn-t-suck-your-agent-does)
- [Reusing apps between teams and environments through Containers](https://www.wearedevelopers.com/videos/107-reusing-apps-between-teams-and-environments-through-containers)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)