Data Modeler

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