Data Modeler

Amtex Enterprises Logo
Amtex Enterprises
United States (Remote)
  • Construction

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
Apply for job