Senior Analytics Engineer – dbt & Snowflake

Kelly; Spring (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

Kelly is seeking a hands-on Data Analytics Engineer to build and maintain analytics foundations using DBT, Snowflake, and dimensional modeling. You will design star-schema models, develop DBT pipelines, and optimize Snowflake SQL workloads to deliver trusted datasets for enterprise reporting.

You will collaborate with Data Engineers, BI Developers, Product Owners, and stakeholders to translate requirements into scalable analytical solutions, participate in design discussions, and help promote

Qualifications

• Hands-on DBT development and testing experience.
• Strong Snowflake exposure and SQL optimization skills.
• Proven ability to design star-schema dimensional models.
• Deep understanding of fact and dimension modeling and analytic DW concepts.

Responsibilities

• Design, develop, and maintain star-schema data models (fact and dimension tables).
• Build and support DBT models and testing frameworks for analytics-ready datasets.
• Develop, optimize, and troubleshoot Snowflake SQL workloads.
• Apply dimensional design best practices for scalable data models.

Skills

DBT development

Snowflake

SQL optimization

Star-schema modeling

GitHub

Data warehousing concepts

Stakeholder comms

Tools

DBT

Snowflake

Job description

Top 3 skill sets/technologies required for qualification:

• Strong hands-on experience with DBT development and testing.
• Strong experience with Snowflake and SQL optimization.
• GitHub

• Absolutely needs someone who can come in and hit the ground running - NO TRAINING and ready to deliver!

We are looking for a hands-on Data Analytics Engineer with strong experience in DBT, Snowflake, and dimensional data modeling to help build and maintain the analytical foundation that supports enterprise reporting and analytics.

Key Responsibilities

• Design, develop, and maintain star-schema data models, including fact and dimension tables.
• Build and support DBT models and testing frameworks to deliver trusted, analytics-ready datasets.
• Develop, optimize, and troubleshoot data structures and SQL workloads in Snowflake.
• Apply data modeling best practices and make informed decisions around dimensional design, normalization, and denormalization.
• Partner closely with Data Engineers, BI Developers, Product Owners, and business stakeholders to translate requirements into scalable analytical solutions.
• Participate in design discussions, knowledge sharing, and peer reviews to promote consistent modeling standards across the team.
• Support data delivery from ingestion through transformation and into the semantic layer for reporting and analytics.
• Document modeling decisions and collaborate with team members to continuously improve data architecture and engineering practices.

Required Qualifications

• Strong hands-on experience with DBT development and testing.
• Strong experience with Snowflake and SQL optimization.
• Proven experience designing and implementing star-schema dimensional models.
• Deep understanding of fact and dimension modeling and analytical data warehouse concepts.
• Ability to work effectively in a collaborative, cross-functional team environment and communicate technical concepts to both technical and non-technical stakeholders.

Preferred Qualifications

• DP-203 or SnowPro certifications

Ideal Candidate

A collaborative analytics engineer who enjoys working with teammates and stakeholders to transform complex source data into well-designed star-schema models using DBT and Snowflake, while contributing to a strong engineering culture and data modeling best practices.