IT - Data Modeler - Intermediate Level

Role Overview

We are seeking a hands-on Data Analytics Engineer with experience in DBT, Snowflake, and dimensional data modeling. This role is responsible for building and maintaining the analytical foundation that supports enterprise reporting and analytics. You will work with the business to understand processes and provide recommendations on data models that best fit the business case.

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 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.
• 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 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.
• Ability to communicate technical concepts to both technical and non-technical stakeholders.
• Experience with GitHub.

Preferred Qualifications

• Azure Data Factory (ADF)
• Python or Power Query
• DP-203 or SnowPro certifications

Benefits

• Supplemental benefits including medical, dental, vision, life, disability, and other insurance plans
• Employee Stock Purchase Program (ESPP)
• 401K program with company match after 12 months of tenure
• Health Savings Account (HSA) on the HDHP plan
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions
• Corporate discount savings program and other discounts
• On-demand training program
• Access to certification prep and a library of technical and leadership courses/books/seminars after 6+ months of tenure
• Certification discounts and perks through associations including CompTIA and IIBA
• Dedicated customer service team for Consultants and a certified Career Coach