Strategic Enterprise Data Warehouse Architect

Doggett Equipment Services Group; Houston (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Doggett Equipment Services Group in Houston seeks a Data Warehouse Architect to design, develop, and maintain the enterprise data warehouse architecture, partnering with business units to translate reporting needs into scalable solutions.

The role focuses on data modeling, ETL/ELT across DMS, financials, CRM, and telematics, governance, data quality, and ensuring high availability to support dashboards and executive analytics.

Qualifications

• 8+ years designing enterprise database solutions.
• 5+ years building enterprise data warehouses.
• Advanced SQL development and performance tuning.
• Dimensional modeling knowledge (Kimball/Inmon).
• Strong data architecture and integration skills.
• Experience with multiple enterprise systems.
• Excellent analytical and communication abilities.
• Ability to collaborate with technical and business stakeholders.

Responsibilities

• Design, develop, and maintain the enterprise data warehouse architecture.
• Define data models for reporting and analytics.
• Establish data modeling standards and governance.
• Design scalable solutions to support growth and acquisitions.
• Oversee ETL/ELT processes across various systems.
• Optimize query performance and reporting efficiency.
• Guide developers and analysts in data management.
• Participate in enterprise architecture decisions for data warehousing.
• Ensure data quality and compliance with security policies.
• Develop long-term roadmap for database platforms.

Skills

SQL development

Performance tuning

Dimensional modeling

Data architecture

ETL/ELT design

Systems integration

Stakeholder communication

Analytical skills

Tools

Microsoft SQL Server

Azure SQL

SSIS

Azure Data Factory

Power BI

Tableau

Informatica

IBM DataStage

IntelliDealer

CDK Drive

Job description

Doggett Equipment Services Group in Houston seeks a Data Warehouse Architect to design, develop, and maintain the enterprise data warehouse architecture, partnering with business units to translate reporting needs into scalable solutions.

The role focuses on data modeling, ETL/ELT across DMS, financials, CRM, and telematics, governance, data quality, and ensuring high availability to support dashboards and executive analytics.