> Markdown version of [/jobs/ext/1488282-data-warehouse-architect](https://www.wearedevelopers.com/jobs/ext/1488282-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:** Wld Properties V, LLC - **Location:** Houston, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Query Performance, Data Analysis, Big Data, Databases, Customer Data Management, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), Data Retention, Data Structures, Data Warehousing, Database Development, IBM InfoSphere DataStage, Dimensional Modeling, Disaster Recovery, JSON, Metadata Repositories, Microsoft SQL Server, SQL Azure, Performance Tuning, Power BI, SQL Server Integration Services, Systems Integration, Tableau (Software), Extensible Markup Language (XML), Enterprise Data Management, Enterprise Software Applications, Azure Data Factory, Informatica Powercenter, System Availability, Microsoft Fabric, Information Technology, Data Management, Restful APIs - **Published:** July 29, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=663cb751d821c5e4 ## About the Role Required * 8+ years of experience designing and developing enterprise database solutions. * 5+ years of experience designing or maintaining enterprise data warehouses. * Advanced SQL development and performance tuning expertise. * Experience with dimensional modeling (Kimball or Inmon methodologies). * Experience designing ETL/ELT solutions. * Strong understanding of data architecture principles. * Experience integrating multiple enterprise systems. * Excellent analytical, communication, and problem-solving skills. * Ability to work with both technical and business stakeholders. Preferred * Experience with Microsoft SQL Server, Azure SQL, or similar enterprise database platforms. * Experience with SSIS, Azure Data Factory, Microsoft Fabric, Informatica, IBM Data Stage or similar data platforms. * Experience with Power BI, Tableau, or other business intelligence tools. * Experience integrating ERP or dealership management systems such as IntelliDealer, CDK Drive, Procede Excede, or similar enterprise applications. * Experience working with REST APIs, JSON, XML, and enterprise integrations. * Familiarity with data governance, master data management, and data catalog solutions. * Experience in commercial equipment, construction equipment, transportation, manufacturing, or dealership operations. ## Description * Design, develop, and maintain the company's enterprise data warehouse architecture. * Define logical and physical data models that support operational reporting, business intelligence, and analytics. * Establish standards for data modeling, naming conventions, metadata, and documentation. * Design scalable solutions capable of supporting future business growth and acquisitions. * Design and oversee ETL/ELT processes that consolidate data from DMS, financial, CRM, telematics, and third-party systems. * Develop strategies for loading, validating, transforming, and synchronizing enterprise data. * Optimize large-scale data movement and processing. * Evaluate and recommend technologies for data integration and orchestration. * Define enterprise data warehouse standards and governance practices. * Develop processes to improve data quality, consistency, and accuracy. * Collaborate with business stakeholders to establish master data management practices. * Ensure compliance with company security policies and regulatory requirements regarding sensitive business and customer data. * Design data structures that support dashboards, KPIs, operational reporting, and executive analytics. * Partner with business units to understand reporting requirements and translate them into scalable warehouse solutions. * Optimize query performance and reporting efficiency. * Support self-service reporting initiatives. * Develop the long-term roadmap for the company's enterprise database platforms. * Provide technical guidance to developers, database administrators, and analysts. * Participate in enterprise architecture decisions involving data management and warehousing. * Monitor warehouse performance and recommend improvements. * Design strategies for partitioning, indexing, archival, and historical data retention. * Work with IT infrastructure to implement disaster recovery and backup strategies for enterprise data assets. * Ensure high availability and scalability of data warehouse solutions. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) ## 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) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [How software is steering vehicle technology](https://www.wearedevelopers.com/magazine/515-how-software-is-steering-vehicle-technology)