Logo
ClearpointCo

Data Modeler

ClearpointCo, Houston, Texas, United States, 77246

Save Job

Pay Range $60.00/hr - $70.00/hr

Remote; local Houston candidate preferred with periodic on‑site meetings.

Summary Seeking a

Data Modeler

to clean up and optimize workflows.

Responsibilities The role focuses on data modeling and architecture for Microsoft Fabric.

Qualifications

7+ years of data modeling experience

3+ years in data modeling or analytics engineering with strong SQL

2-3+ years of hands‑on Microsoft Fabric experience

Experience with Lakehouse/Warehouse, One Lake, Delta tables, Dataflows Gen2 or Pipelines and familiarity with SQL endpoint usage

Knowledge of star schemas, fact types, bridge tables, degenerate and junk dimensions

Experience with SCD Type 1/2, MERGE, effective/expiry dating, handling late‑arriving data

Power BI semantic modeling and DAX

Incremental refresh; basic aggregations; RLS

Define tests, 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

#J-18808-Ljbffr