Senior Fabric Data Engineer

ClearpointCo.; Houston (TX); On-site; USD 120,000 - 160,000; Part time

Job summary

ClearpointCo. in Houston, TX is seeking a Senior Fabric Data Engineer for a contract role focused on cleaning up and optimizing Fabric workflows.

Strong hands-on Fabric experience is a must, with emphasis on data modeling, SQL, and Power BI. Responsibilities include translating stakeholder requirements into grain/facts/dimensions, collaborating with DE, BI, and business teams, and implementing tests and data governance, including PII labeling.

Qualifications

• 7 years of Data Modeling experience.
• 3 years in data modeling or analytics engineering with strong SQL.
• 2-3 years plus of hands-on Microsoft Fabric experience.
• Experience with Lakehouse/Warehouse, One Lake, Delta tables, Dataflows Gen2 or Pipelines.
• Familiarity with SQL endpoint usage.
• Star schemas; bridging tables for M:N relationships; degenerate dimensions.

Responsibilities

• Translate stakeholder requirements into grain/facts/dimensions and certified measures.
• Collaborate across DE, BI, and business teams to deliver Fabric-based data pipelines.
• Define tests (unique/not-null/accepted values) and document metrics.
• Apply data sensitivity labels for PII/regulated data.
• Maintain clean tabular models with CALCULATE/KEEPFILTERS/USERELATIONSHIP and date intelligence.

Skills

Data modeling

SQL

Microsoft Fabric

Power BI / DAX

ETL / Lakehouse concepts

Dimensional modeling

MergE / SCD concepts

Incremental refresh

Tools

Microsoft Fabric

Delta tables

Dataflows Gen2

Pipelines

SQL endpoint usage

Job description

REMOTE OPPORTUNITY MUST BE TEXAS BASED

Title: Senior Fabric Data Engineer

Location: Houston, Texas

Type: Contract

Summary

Seeking a Fabric/Data Engineer that will be responsible for cleaning up to optimize workflows.

This position will require strong hands-on Fabric/Data Engineering 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.