Overview
Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 month(s)
10% Travel
Skills
Microsoft Fabric
Star Schemas
Lakehouse/Warehouse
OneLake
Delta tables
Power BI Semantic Models
SQL Proficiency
SCD Implementation
Medallion Architecture
Gold
Bronze
Silver
Power BI & DAX
Job Details
Role: Data Modeler
Location: REMOTE from Houston, TX
Duration: contract for 6 months and the conversion
Job Description:
Requirements:
- 7+ years of Data Modeling experience
- 3+ years in data modeling or analytics engineering with strong SQL.
- Hands-on Microsoft Fabric
- Lakehouse/Warehouse, OneLake, Delta tables, Dataflows Gen2 or Pipelines; familiarity with SQL endpoint usage.
- Star schemas; fact types (transactional, periodic snapshot, accumulating); bridge tables for M:N; degenerate and junk dimensions.
- SCD Type 1/2 with MERGE; effective/expiry dating; handling late-arriving data.
- Power BI semantic modeling and DAX
- Clean tabular model design; CALCULATE/KEEPFILTERS/USERELATIONSHIP; date intelligence; semi-additive measures; model properties (data types, sort-by, formatting).
- Incremental refresh; basic aggregations; RLS.
- Define tests (unique/not-null/accepted values), document metrics, manage endorsements; apply sensitivity labels for PII/regulated data.
- Translate stakeholder requirements into grain/facts/dimensions and certified measures; collaborate across DE, BI, and business teams
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.