Power BI Developer

Job description

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