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
- MA
Data Management and Analytics Engineer with Security Clearance
NewMAG Aerospace
Fairfax, VA🇺🇸$80.5k - $149.5k/yrHybrid23 hours agoGCPOracleSQL+11Technology - HA
Data Analytics Engineer
NewHCL America Inc.
United States🇺🇸Hybrid23 hours agoETLTechnology - BL
Network Operations Analytics Engineer with Security Clearance
NewBy Light Professional IT Services
Macdill AFB, FL🇺🇸HybridYesterdayTechnology - MO
Analytics Engineer
NewModal
New York🇺🇸On-siteYesterdaySQLSnowflakeFinancial Reporting+3Technology - TR
Senior Analytics Engineer, FinOps
NewTrupanion
Seattle🇺🇸$120k - $130k/yrHybridYesterdaySQLDatabricksGit+2Technology - SN
Analytics Engineer
NewSBA NETWORK SERVICES
Boca Raton, FL🇺🇸HybridYesterdaySQLMachine LearningAzure+5Technology