Senior Data Engineer

Mustang Cat – Houston, 12800 Northwest Freeway, Houston, Texas, United States of America

Posted Saturday, June 6, 2026 at 5:00 AM

Building Texas… Powering the World. Since 1952, Mustang has proudly served the construction, oil & gas, power generation, marine, and manufacturing industries as the authorized Caterpillar® dealer for Southeast Texas. Start your career with Mustang Cat – one of America’s Greatest Midsize Workplaces of 2025!

Snowflake, Semantic Layer & Enterprise Data Platform

Mustang Cat is seeking a highly experienced Senior Data Engineer to design, own, and govern the enterprise data environment, with a strong focus on Snowflake, semantic layer design, trusted reporting, and enterprise data modeling.

This role is responsible for ensuring that data is structured, transformed, secured, documented, and made available in a way that supports accurate operational and financial reporting across the business. The Senior Data Engineer will act as the technical steward of the enterprise data platform, ensuring that data models, reporting layers, metric definitions, semantic structures, and data quality standards are intentionally designed and consistently applied.

The successful candidate must be deeply experienced in Snowflake, advanced SQL, dimensional modeling, analytics‑ready data structures, and semantic layer design. This role will work closely with business stakeholders, reporting teams, application owners, integration engineers, and external vendors to ensure that the data warehouse becomes a trusted foundation for reporting, analytics, and future advanced use cases.

While this role will collaborate with engineers responsible for ingestion, integrations, and data movement, the Senior Data Engineer will focus primarily on data architecture, modeling, semantic layer design, reporting‑layer reliability, governance, and platform stewardship.

Snowflake Data Platform Ownership & Design

• Snowflake data warehouse architecture
• Raw, staging, curated, semantic, and reporting‑ready layers
• Schema and object design
• Data models, views, tables, procedures, and transformation logic
• Storage, compute, and performance optimization strategies
• Define how data should be organized, modeled, and accessed to support reporting, analytics, operational decision‑making, and downstream use cases.
• Ensure the Snowflake environment is designed for scalability, cost efficiency, performance, security, and long‑term maintainability.
• Establish and maintain standards for Snowflake object naming, schema organization, access control, environment separation, and change management.

Data Modeling & Semantic Layer Design

Design and maintain core data models that represent business entities, metrics, relationships, and reporting structures.

Define conformed dimensions, fact tables, shared reference data, hierarchies, and reusable reporting models to ensure consistency across analytics and reporting.

Establish and maintain semantic layer standards so business definitions, calculations, KPIs, and measures are applied consistently across tools and teams.

Partner with reporting and analytics teams to ensure models align with how data is consumed in Power BI and other reporting tools.

Help move critical reporting logic out of isolated reports, spreadsheets, and disconnected BI models into governed Snowflake and semantic‑layer structures where appropriate.

Ensure business metrics are defined once, documented clearly, and used consistently across the enterprise.

Data Quality, Trust & Governance

Define data quality standards, validation frameworks, reconciliation logic, and exception reporting expectations.

Identify upstream data quality issues, transformation gaps, integration problems, and reporting inconsistencies that affect trust in enterprise reporting.

Establish ownership and accountability for critical data domains, business definitions, and reporting metrics.

Ensure data lineage, freshness, completeness, accuracy, and reliability expectations are clearly defined and measurable.

Partner with integration and data movement resources to ensure pipelines conform to data quality, modeling, and governance standards.

Support…