Doggett

Data Warehouse Architect

Doggett • $120K — $140K *
Houston, TX 77084In-Person
Information Technology
8 - 10 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 8+ years of experience in designing and developing enterprise database solutions.
  • 5+ years of experience with enterprise data warehouses.
  • Advanced SQL development skills, specifically performance tuning.
  • Proven ability in dimensional modeling using Kimball or Inmon methodologies.
  • Experience in designing ETL/ELT solutions for data warehousing.
  • Strong grasp of data architecture principles and industry best practices.
  • Adept at integrating multiple enterprise systems.

Responsibilities

  • Design and maintain the enterprise data warehouse architecture.
  • Define data models for operational reporting and analytics.
  • Establish and enforce data modeling and documentation standards.
  • Create scalable data solutions for future business needs.
  • Oversee ETL/ELT processes for consolidating diverse data sources.
  • Develop strategies for effective data transformation and validation.
  • Collaborate with business units to translate reporting requirements.

Benefits

  • Collaborative work environment promoting innovation.
  • Opportunities for professional development and training.
  • Access to cutting-edge data technologies and methodologies.
  • Flexible work arrangements to promote work-life balance.
  • Health and wellness programs tailored for employees.
Full Job Description
Data Warehouse Architect

Data Warehouse Architect

Classification

Exempt

Essential Functions
  • 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.


Qualifications

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.


The Data Warehouse Architect must perform the essential duties and responsibilities with or without reasonable accommodation efficiently and accurately, and without causing significant safety threat to self or others. The statements made herein are intended to describe the general nature and level of work being performed by employees assigned to this job classification. They are not intended to be construed as an exhaustive and inclusive list of all responsibilities, duties, and/or skills required of personnel so classified.

About Doggett

Doggett is a leading provider of transportation equipment and related services in the United States. The company offers new and used heavy-duty and medium-duty trucks, trailers, and specialized equipment, as well as aftermarket parts and services. Doggett serves a wide range of industries, including construction, energy, agriculture, and transportation. The company operates a network of more than 40 locations across the southern United States, with a focus on Texas and Louisiana. Doggett is committed to providing its customers with high-quality products and services, and has a reputation for excellence in the industry.
Learn more about Doggett
Size
2,000 employees
Industry
Transportation
Net Income
$50 million
Founded
1993
5 Year Trend
+10%
Revenue
$1 billion
NASDAQ
DOGT
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Doggett

  • Doggett
    Branch Manager
    $80K — $95K *
    Austin, TX 78745 (Travis County)
    Today
    Transportation
    In-Person
  • Doggett
    Data Warehouse Architect
    $120K — $140K *
    Houston, TX 77084 (Harris County)
    Today
    Information Technology
    In-Person
  • Doggett
    Data Systems Analyst
    $80K — $95K *
    Houston, TX 77084 (Harris County)
    Today
    Information Technology
    In-Person
  • Doggett
    Service Manager
    $75K — $95K *
    San Antonio, TX 78228 (Bexar County)
    3 days ago
    Manufacturing & Automotive
    In-Person
  • Doggett
    Heavy Duty Equipment Manager
    $75K — $95K *
    Houston, TX 77084 (Harris County)
    2 weeks ago
    Manufacturing & Automotive
    In-Person

More Information Technology Jobs

Find similar Data Warehouse Architect jobs:

NationwideHouston, TX