Microsoft Fabric Data Modeler

Sonata Software North America Inc.; Phoenix (AZ); On-site; USD 120,000 - 165,000; Full time

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.

Skills

Data Warehousing

Data Modeling

BI Solutions

SQL

Power BI Semantic Modeling

DAX

Azure Data Services

Microsoft Fabric

OneLake

Lakehouse

Semantic Models

MySQL

Tools

Microsoft Fabric

OneLake

Lakehouse

Semantic Models

Azure Data Factory

Azure Data Lake Storage

Job description

About Sonata Software
Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency, and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services.

About Sonata Software
Sonata Software, with over $1.2 Billion Revenue, is a leading AI-first Modernization Engineering company, powered by our unique PlatformationTM framework. Our 6400+ AI Engineers are helping enterprises transform from systems to intelligent business platforms leveraging partner ecosystem to drive speed, efficiency, and growth. Our bouquet of Modernization Engineering Services with AI -first approach cuts across Cloud, Data, AI, Dynamics, Test Automation, and Managed Services.
Sonata’s AI-led modernization is enabled by a powerful suite of proprietary tools and assets. At the core is the Harmoni.AI Enterprise Platform, which includes AgentBridge-a governance and observability framework; AgentBuilder-a development toolkit for fungible agents integrated into enterprise systems; and the Agent Marketplace-an internal ecosystem for modular, reusable agents.
Headquartered in Bengaluru, India, Sonata Software has a strong global presence, including key regions US, UK, India, Malaysia, Mexico, Australia, DACH (Germany/Switzerland) & Nordics (Finland). We are a trusted partner of Fortune 500 companies in Banking, Financial Services and Insurance; Healthcare and Lifesciences; Telecom, Media, and Technology; and Retail, Manufacturing and Distribution space.
Deep collaborations with partners like Microsoft, AWS, Salesforce, and Snowflake strengthen our ability to deliver cutting-edge AI solutions. Our 30+years of partnership with Microsoft, and being part of the elite Microsoft Inner Circle, places us among the top 1% of global Microsoft partners. Sonata is now among the first companies to earn the Microsoft Frontier Partner Badge Also; Sonata Software is proud to achieve AWS Premier Tier Status in the AWS Partner Network.
Role: Microsoft Fabric Data Modeler
Location: Phoenix, AZ (On-site)
Ideal Experience

• 10-12+ years of experience 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, 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, 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.
• 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.

Why join Sonata Software?
At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next.
Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.