ClearpointCo
Data Modeler
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler with 7+ years of experience, focusing on SQL, Microsoft Fabric, and Power BI. The contract is for over 6 months, hybrid in the I-10 West Houston area, requiring local candidates for occasional office meetings.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
500
-
🗓️ - Date
November 12, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Houston, TX
-
🧠 - Skills detailed
#SQL (Structured Query Language) #DAX #Microsoft Power BI #Dataflow #BI (Business Intelligence) #Data Modeling
Role description
•
•
•
•
•
•
•
•
• NO THIRD PARTIES PLEASE
•
•
•
•
•
•
•
• This is a contract to hire position for a very stable organization. Great teammates and a great opportunity for growth and a long career. I-10 West Houston area location for the company.
•
•
•
• The position is REMOTE; however, I am seeking a local Houston candidate as there will be periodic times to come into the office for team meetings.
•
•
•
•
•
•
•
•
•
• Summary:
Seeking a Data Modeler that will be responsible for cleaning up to optimize workflows.
This position will require strong hands-on Data Modeler experience.
Requirements:
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.
•
•
•
•
•
•
•
•
• NO THIRD PARTIES PLEASE
•
•
•
•
•
•
•
• This is a contract to hire position for a very stable organization. Great teammates and a great opportunity for growth and a long career. I-10 West Houston area location for the company.
•
•
•
• The position is REMOTE; however, I am seeking a local Houston candidate as there will be periodic times to come into the office for team meetings.
•
•
•
•
•
•
•
•
•
• Summary:
Seeking a Data Modeler that will be responsible for cleaning up to optimize workflows.
This position will require strong hands-on Data Modeler experience.
Requirements:
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.
