Enterprise Data Warehouse Architect for Analytics & Growth

Doggett Equipment Services Group; Houston (TX); Hybrid; USD 130,000 - 170,000; Full time

Job summary

Doggett Equipment Services Group seeks an experienced Data Warehouse Architect to design and maintain enterprise data warehouse architecture in Houston. You will define data models, standards, and governance to support operational reporting, BI, and analytics across the organization.

You will lead ETL/ELT processes, optimize performance, and collaborate with business units to translate requirements into scalable warehouse solutions.

Qualifications

• 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).
• 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.

Responsibilities

• Design, develop, and maintain the company's enterprise data warehouse architecture.
• Define logical and physical data models that support reporting, BI, and analytics.
• Establish standards for data modeling, naming conventions, metadata, and documentation.
• Design scalable solutions to support growth and acquisitions.
• Design and oversee ETL/ELT processes consolidating data from multiple systems.
• Develop strategies for loading, validating, transforming, and syncing data.
• Optimize large-scale data movement and processing.
• Evaluate technologies for data integration and orchestration.
• Define warehouse standards and governance practices.
• Develop processes to improve data quality and consistency.
• Collaborate with stakeholders to establish master data management practices.
• Ensure compliance with security policies and regulatory requirements.
• Design data structures for dashboards, KPIs, and executive analytics.
• Partner with business units to translate requirements into scalable solutions.
• Optimize query performance and reporting efficiency.
• Support self-service reporting initiatives.
• Develop long-term roadmap for enterprise database platforms.
• Provide technical guidance to developers, DBAs, and analysts.
• Participate in enterprise architecture decisions for data management.
• Monitor warehouse performance and propose improvements.
• Design partitioning, indexing, archival, and historical data retention strategies.
• Coordinate with IT for disaster recovery and backups.
• Ensure high availability and scalability of data warehouse solutions.

Skills

SQL development

Dimensional modeling

Data architecture

ETL/ELT design

Performance tuning

Stakeholder communication

Enterprise systems integration

REST APIs

Power BI/Tableau

Data governance

Tools

SSIS

Azure Data Factory

Informatica

IBM DataStage

Power BI

Tableau

Job description

Doggett Equipment Services Group seeks an experienced Data Warehouse Architect to design and maintain enterprise data warehouse architecture in Houston. You will define data models, standards, and governance to support operational reporting, BI, and analytics across the organization.

You will lead ETL/ELT processes, optimize performance, and collaborate with business units to translate requirements into scalable warehouse solutions.