POWER BI Developer with Copilot Studio

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 with Copilot

Type: Full Time

Location: Gurugram

Work Mode: 5 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