Senior Microsoft Fabric Data Modeler

Sonata Software North America Inc.

Phoenix (AZ)

On-site

USD 120,000 - 165,000

Full time

11 days ago

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Sonata Software North America Inc. is seeking an experienced Microsoft Fabric Data Modeler for our Phoenix, AZ on-site team.

You will design enterprise‑grade data models and semantic layers, collaborating with Power BI developers and data engineers to deliver scalable analytics solutions using Fabric, OneLake, Lakehouse, and SQL across ERP sources. Ideal candidates have 10–12+ years in Data Warehousing, Data Modeling, and BI, with strong SQL and Dimensional Modeling expertise, Azure data

Qualifications

10–12+ years in Data Warehousing, Data Modeling, and BI solutions.
Analyze complex MySQL ERP schemas and business processes.
Design enterprise-grade Star Schema data models (Facts, Dimensions, SCDs).
Develop and optimize Bronze, Silver, and Gold data layers in Microsoft Fabric.
Build and maintain Fabric Semantic Models for enterprise reporting.
Define KPIs, measures, hierarchies, and Row-Level Security (RLS).
Collaborate with Data Engineers to design analytics-ready structures.
Work with Power BI developers to deliver performant dashboards.
Translate reporting requirements into scalable data models.
Ensure data quality, governance, and documentation standards.
Expertise in Dimensional Modeling and Data Warehouse design.
Hands-on with Microsoft Fabric, OneLake, Lakehouse, and Semantic Models.
Advanced SQL skills with MySQL or similar ERP databases.

Responsibilities

Design and implement enterprise data models and semantic layers.
Collaborate with analytics and engineering teams to deliver scalable BI solutions.
Ensure data quality, governance, and documentation across the data warehouse.
Optimize Direct Lake, semantic models, and reporting performance.
Define standards for KPIs, hierarchies, and security in data models.