Haystack
← Back to Jobs
Other
UC

Senior Microsoft Fabric Data Modeler

UniqueHire Consulting LLCWalnut Creek, CA🇺🇸United StatesPosted 15 Sept 2026

Why This Role Stands Out

Advance your career as a Senior Microsoft Fabric Data Modeler with a role offering significant growth opportunities and the chance to shape impactful data solutions. You'll thrive here if you're a skilled professional eager to contribute to a reputable company and develop your expertise in a collaborative environment. Apply today to explore this exciting long-term contract position.

Quick Overview

Seniority
Mid Senior
Work mode
On Site
Location
Walnut Creek, CA, United States
Posted
18 hours ago
MySQLSQLETLAzureERPPower BIReconciliation

Job Description

Role: Senior Microsoft Fabric Data Modeler

Location : Walnut Creek ,CA– Local Profile Only(final round is in person)

Long Term Contract

Visa type : H1B

Client Interview:  In-person Only

Note: client is looking for experience in more into Data modelling and not just ETL 

Role Summary
Seeking an experienced Microsoft Fabric Data Modeler to transform an on-premises MySQL Vessel ERP data model into a scalable Microsoft Fabric analytics platform. The role will own dimensional modeling, Gold-layer design, semantic model development, and collaboration with Power BI developers to enable enterprise self-service reporting.

Key Responsibilities

  • Analyze complex MySQL ERP schemas and business processes.
  • Design enterprise-grade Star Schema data (models Facts, Dimensions, Bridge Tables, SCDs).
  • Develop and optimize Bronze, Silver, and Gold layer data models in Microsoft Fabric.
  • Build and maintain Fabric Semantic Models for reusable enterprise reporting.
  • Define KPIs, measures, hierarchies, relationships, and Row-Level Security (RLS).
  • Partner with Data Engineers to design analytics-ready data structures.
  • Collaborate closely with Power BI developers to deliver performant dashboards and self-service reporting solutions.
  • Work with business stakeholders to translate reporting requirements into scalable data models.
  • Ensure data quality, reconciliation, governance, and documentation standards.
  • Optimize Direct Lake, semantic model performance, and reporting scalability.

Required Skills

  • 7-10+ years of experience in Data Warehousing, Data Modeling, and BI solutions.
  • Strong expertise in Star Schema, Dimensional Modeling, and Data Warehouse design.
  • Hands-on experience with Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Semantic Models.
  • Advanced SQL skills and experience working with MySQL or other enterprise ERP databases.
  • Strong knowledge of Power BI Semantic Modeling, DAX, and self-service analytics.
  • Experience with Azure Data Services including Azure Data Factory, Azure Data Lake Storage, and cloud-based analytics architectures.
  • Excellent communication skills with the ability to work across business and technical teams.

Preferred Qualifications

  • Microsoft Fabric certifications (DP-600, DP-700).

 

📩 𝗜𝗻𝘁𝗲𝗿𝗲𝘀𝘁𝗲𝗱 𝗖𝗮𝗻𝗱𝗶𝗱𝗮𝘁𝗲𝘀: Please connect or share resumes at:

Similar jobs

Browse related jobs

Apply now