Senior Data Analytics Engineer: Star Schema & Snowflake Lead

KellyMitchell Group; Spring (TX); On-site; USD 72,000 - 103,000; Full time

Benefits offered by this job

Medical, Dental, & Vision Insurance

Employee-Owned Profit Sharing (ESOP)

401K offered

Job summary

KellyMitchell Group is seeking a Senior Data Analytics Engineer in Spring, TX to lead enterprise-scale dimensional data models, DBT development, and Snowflake optimization in a modern analytics environment.

You will provide technical leadership, shape data modeling standards, and collaborate with data engineers, BI developers, and stakeholders to deliver scalable analytical solutions. Onsite work from Spring, TX is required.

Qualifications

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

Responsibilities

• Design, develop, and lead implementation of complex star-schema data models (fact, dimension, bridge, aggregate).
• Build, optimize, and govern DBT frameworks, models, testing strategies, and reusable patterns.
• Architect, optimize, and troubleshoot large 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, and analytical data structures.
• Partner with Data Engineers, BI Developers, Product Owners, Architects, and stakeholders to deliver scalable analytics 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.

Skills

Data modeling

DBT development

Snowflake

SQL optimization

Data warehousing

Analytics engineering

Technical leadership

Stakeholder management

Tools

DBT

Snowflake

SQL

Job description

KellyMitchell Group is seeking a Senior Data Analytics Engineer in Spring, TX to lead enterprise-scale dimensional data models, DBT development, and Snowflake optimization in a modern analytics environment.

You will provide technical leadership, shape data modeling standards, and collaborate with data engineers, BI developers, and stakeholders to deliver scalable analytical solutions. Onsite work from Spring, TX is required.