Note: The job is a remote job and is open to candidates in USA. ClearpointCo is seeking a Senior Fabric Data Engineer for a remote contract opportunity based in Texas. The role focuses on cleaning and optimizing workflows using Microsoft Fabric and data engineering expertise, while translating stakeholder requirements into data models and certified measures and collaborating across data engineering, business intelligence, and business teams.
Responsibilities
- Seeking a Fabric/Data Engineer that will be responsible for cleaning up to optimize workflows
- Translate stakeholder requirements into grain/facts/dimensions and certified measures; collaborate across DE, BI, and business teams
Skills
- REMOTE OPPORTUNITY MUST BE TEXAS BASED
- 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
Benefits
- Contract employment
- Remote work opportunity for Texas-based candidates
Company Overview