Senior Data Engineer

Senior Data Engineer

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.

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

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.

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 the validation of key operational and financial metrics from source systems through Snowflake and into reporting outputs.

• Data environments, including development, test, and production
• Snowflake schemas and database objects
• Naming conventions
• Access control and role‑based permissions
• Transformation logic and reusable patterns
• Deployment and change management practices
• Documentation and data model stewardship

Ensure the data environment aligns with security, compliance, audit, and operational requirements.

Act as a gatekeeper for changes that materially affect data structure, semantic definitions, reporting logic, or data integrity.

Provide clear architectural guidance to integration engineers, data movement resources, reporting analysts, and external vendors.

Review and approve data structures, transformations, and reporting‑layer changes implemented by internal teams or vendor partners.

Partner with analytics, Power BI, and business reporting teams to ensure data is usable, performant, accurate, and well‑documented.

Serve as an escalation point for complex Snowflake, data…