Senior Analytics Engineer: DBT, Snowflake & Star Schema

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

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