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 Time
Location: Gurugram
Work Mode:4 days Work From Office
We 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 automation
Key Responsibilities
Power BI Development
Design and develop interactive dashboards and reports using Power BI
Implement data transformations using Power Query
Publish, schedule, and maintain reports in Power BI Service
Data Modeling
Build efficient data models (Star/Snowflake schema)
Handle fact and dimension tables, relationships, and hierarchies
Optimize model performance for large datasets (millions of records)
Implement aggregation tables, incremental refresh, and composite models
DAX Development
Create advanced DAX measures, calculated columns, and KPIs
Implement time intelligence functions (YTD, MTD, YoY, etc.)
Optimize DAX for performance tuning and scalability
Copilot Studio / AI Integration
Work with Microsoft Copilot Studio (Power Virtual Agents / AI tools)
Design AI-driven workflows, bots, and automation
Integrate Power BI insights with Copilot or conversational AI interfaces

Work arrangement
No