Haystack
← Back to Jobs
Technology
CS

Data Analytics Engineer Data Modeling

Corporate Solutions General, Inc.Spring, TX🇺🇸United StatesPosted Sep 24, 2026

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
Spring, TX, United States
Posted
23 hours ago
SQLSpringSnowflakeAzurePower BIPythondbt

Job Description


Data Analytics Engineer - Data Modeling/Onsite Only-5 Days Each Week/Spring, Texas/Long Term Contract Opportunity
Interview Process: Face To Face Interview
DO NOT SHARE IRRELEVANT PROFILES AND THOSE WHO DO NOT MEET THE CRITERIA .

Here's the JD for your review.
Top Skills: Star Schema Data Modelling, DBT, Snowflake, SQL, ADF
Data Analytics Engineer - Data Modeling
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
  • Azure Data Factory (ADF)
  • Power BI Semantic Models
  • Python or Power Query
  • 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.

Similar jobs