> Markdown version of [/jobs/ext/2628709-data-warehouse-architect-hybrid](https://www.wearedevelopers.com/jobs/ext/2628709-data-warehouse-architect-hybrid). 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 - Hybrid - **Company:** The Smart - **Location:** Lansing, MI, United States - **Experience:** Expert - **Salary:** $83,200.0 - $166,400.0 - **Contract:** Temporary to permanent - **Skills:** Agile Methodology, Data Analysis, Build Automation, Information Systems, Continuous Integration, Data Governance, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, IBM InfoSphere DataStage, IBM Cloud Computing, Python (Programming Language), Meta-Data Management, OpenShift, Performance Tuning, Shell Script, SQL Databases, Teradata SQL, Extensible Markup Language (XML), Scripting, Kubernetes, Information Technology, Data Analytics, Data Management, Cloud Migration - **Published:** August 10, 2026 - **Apply:** https://www.careerjet.com/jobad/use275f9dd24a808dddce251159a002885 ## About the Role * Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field. * 5+ years of experience developing ETL solutions using IBM DataStage. * 1+ year of hands-on experience with IBM Cloud Pak for Data (CP4D). * 3+ years of experience with Teradata 20, including SQL, BTEQ, and performance optimization. * 5+ years of Unix/Linux scripting and system administration experience. * Strong expertise in advanced SQL development for ETL, reporting, and data analysis. * Proficiency in Python, Shell scripting, XML, and automation technologies. * Experience with data governance, data quality, MDM, and metadata management practices. * Familiarity with IBM Knowledge Catalog, IBM Manta, OpenShift, Kubernetes, and CI/CD pipelines. * Experience working in large enterprise environments, Agile teams, and public sector, healthcare, or highly regulated industries preferred. ## Description As a Data Warehouse Architect, you will lead enterprise data modernization initiatives by designing, developing, and optimizing large-scale ETL and data integration solutions. You will play a key role in cloud migration, data governance, data quality, and analytics initiatives while collaborating with cross-functional teams to deliver scalable and reliable data solutions., * Design, develop, and optimize ETL pipelines using IBM DataStage for enterprise data integration and analytics. * Support migration of on-premises ETL workloads to IBM Cloud Pak for Data (CP4D). * Develop and optimize complex SQL and BTEQ scripts within Teradata environments. * Build automation solutions using Python, Shell scripting, and related technologies. * Implement data governance, data quality, and Master Data Management (MDM) best practices. * Collaborate with architects, DBAs, analysts, and business stakeholders to deliver data solutions. * Troubleshoot ETL workflows and perform root cause analysis for production issues. * Support data integration across multiple enterprise systems and data sources. * Participate in Agile delivery activities including planning, testing, documentation, and continuous improvement. * Contribute to enterprise data architecture modernization and cloud adoption strategies. ## Related Videos - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [This Is Not Your Father's .NET](https://www.wearedevelopers.com/videos/967-this-is-not-your-father-s-net) - [Understanding Kubernetes in a visual way](https://www.wearedevelopers.com/videos/100085-understanding-kubernetes-in-a-visual-way) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [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) - [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script) ## 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) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)