Senior Microsoft Fabric Data Modeler
Quick facts
- Type
- Full-time
- Location
- Walnut Creek, CA
- Experience
- 7–10 years
- Skills
- SQL
- Industry
- Information Technology — 671 open jobs
- Visa in listing
- H-1B
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
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:
Visa sponsorship record
No public sponsorship records foundWe didn't find H-1B, H-1B1, E-3 or green card (PERM) filings under the name UniqueHire Consulting LLC in the Department of Labor and USCIS data. That doesn't mean the job can't be sponsored — the company may file under a different legal name, be new to sponsorship, or sponsor a visa that isn't in these datasets (for example H-2B or J-1).
Tip: ask the recruiter early, in writing, which visa they sponsor and whether they cover the legal and filing fees.
Which visas can work for this job
- Mentioned in the listing
H-1B
- H-1B cap-exempt employer
Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).
- O-1 (extraordinary ability)
For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.
Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.