Power BI Developer

About Sonata Software:Sonata Software, with $1 Billion Revenue, is the leading Modernization company. Our unique Modernization approach through Platformation.AI helps create Efficient and Agile digital businesses to drive intelligent ecosystems of the future. Our bouquet of Modernization Engineering Services cuts across Data, Cloud, Dynamics, Automation, Cyber Security, and around newer technologies like Generative AI, Microsoft Fabric, and other modernization platforms.Title: Sr. Power BI Developer Type: Full TimeLocation: GurugramWork Mode:4 days Work From OfficeWe are seeking a skilled Power BI Developer with strong expertise in data modeling, DAX, and Excel-based reporting, along with exposure to Microsoft Copilot Studio (AI/automation tools). The ideal candidate will design and develop scalable reporting solutions, optimize data models, and leverage AI-driven capabilities for enhanced analytics and automationKey ResponsibilitiesPower BI DevelopmentDesign and develop interactive dashboards and reports using Power BIImplement data transformations using Power QueryPublish, schedule, and maintain reports in Power BI ServiceData ModelingBuild efficient data models (Star/Snowflake schema)Handle fact and dimension tables, relationships, and hierarchiesOptimize model performance for large datasets (millions of records)Implement aggregation tables, incremental refresh, and composite modelsDAX DevelopmentCreate advanced DAX measures, calculated columns, and KPIsImplement time intelligence functions (YTD, MTD, YoY, etc.)Optimize DAX for performance tuning and scalabilityCopilot Studio / AI IntegrationWork with Microsoft Copilot Studio (Power Virtual Agents / AI tools)Design AI-driven workflows, bots, and automationIntegrate Power BI insights with Copilot or conversational AI interfaces