Source description
About the role
You are a skilled Power BI Developer with expertise in data modeling, DAX, and Excel-based reporting, as well as exposure to Microsoft Copilot Studio. Your role involves designing and developing scalable reporting solutions, optimizing data models, and leveraging 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 You are a skilled Power BI Developer with expertise in data modeling, DAX, and Excel-based reporting, as well as exposure to Microsoft Copilot Studio. Your role involves designing and developing scalable reporting solutions, optimizing data models, and leveraging 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
More at Sonata Software