Haystack
← Back to Jobs
Technology
PAPantheon logo

Data Analytics Engineer

PantheonSpring, TX🇺🇸United StatesPosted Oct 21, 2026

Quick Overview

Seniority
Mid Senior
Work mode
Hybrid
Location
Spring, TX, United States
Posted
Yesterday
Stakeholder ManagementSQLSnowflakedbt

Job Description

Key Responsibilities

Design, develop, and lead implementation of complex star-schema data models, including fact, dimension, bridge, and aggregate tables.
Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable development patterns.
Architect, optimize, and troubleshoot large-scale Snowflake data structures, pipelines, and SQL workloads.
Define and enforce enterprise data modeling standards, best practices, and design patterns.
Lead architectural decisions related to dimensional modeling, normalization, denormalization, and analytical data structures.
Partner with Data Engineers, BI Developers, Product Owners, Architects, and business stakeholders to deliver scalable analytical solutions.
Mentor team members, conduct design reviews, and provide technical leadership across analytics engineering initiatives.
Drive data quality, performance, governance, documentation, and continuous improvement of the analytics platform.

Required Qualifications

Expert-level hands-on experience with DBT development, testing, and deployment practices.
Expert-level experience with Snowflake architecture, performance tuning, and SQL optimization.
Proven experience designing and implementing enterprise-scale dimensional data models.
Deep understanding of data warehousing, analytical modeling, and modern analytics engineering principles.
Experience leading technical design decisions and influencing data architecture strategy.
Strong communication and stakeholder management skills with the ability to translate complex technical concepts into business value.

Similar jobs