What are the responsibilities and job description for the Data Modeler position at ClearpointCo?
********* 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. Texas area candidates that are willing to relocate to Houston or at the very least commit to coming to periodic on-site 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. MUST have strong Microsoft Fabric experience, which is a key component for this particular role.
Requirements:
- 7 years of Data Modeling experience
- 3 years in data modeling or analytics engineering with strong SQL.
- Must have 2-3 years plus of hands-on Microsoft Fabric experience.
- Lakehouse/Warehouse, One Lake, 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.
Salary : $60 - $70