Data Modeler

Sonata Software; Phoenix (AZ); On-site; USD 120,000 - 180,000; Full time

Job summary

Sonata Software in Phoenix, AZ is seeking a Microsoft Fabric Data Modeler with 10-12+ years in Data Warehousing, modeling, and BI to join our on-site team. You will design Bronze-Silver-Gold data models, semantic models, and KPIs, collaborating with Data Engineers and Power BI developers to deliver scalable analytics-ready structures.

The ideal candidate has strong SQL, experience with Fabric, OneLake, Lakehouse, and Azure data services, and the ability to translate business requirements into

Qualifications

• 10-12+ years of experience in Data Warehousing, Data Modeling, and BI solutions.
• Expertise in Bronze, Silver, Gold data models and semantic modeling.
• Strong SQL skills and experience with MySQL or ERP databases.
• Collaboration with Data Engineers and Power BI developers to deliver dashboards.

Responsibilities

• Develop and optimize data models in Microsoft Fabric across Bronze-Silver-Gold layers.
• Build and maintain Fabric Semantic Models for enterprise reporting.
• Define KPIs, measures, hierarchies, and Row-Level Security (RLS).
• Collaborate with Data Engineers and Power BI developers to deliver performant analytics.
• Translate business reporting requirements into scalable data architectures.

Skills

Advanced SQL

Strong communication skills

Self-service analytics

Tools

Microsoft Fabric

OneLake

Lakehouse

Semantic Models

Power BI

DAX

Azure Data Factory

Azure Data Lake Storage

MySQL

Job description

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.
• 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.
• 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.