Senior Power BI Integration Consultant

The Government Sector is creating a Project from scratch with Microsoft Fabric’s semantic modeling feature. They aim to integrate semantic models with their existing Enterprise Data Warehouse (EDW) to enhance reporting and data consumption. The ministry handles vast amounts of data, including tourism insights and telecommunications data, stored in a centralized location. Their data engineering team is currently refining these data structures to streamline reporting and improve the efficiency of their on-premises solutions.

Design and implement a Semantic Model for the Government Sector Project with Microsoft Fabric tenant. The semantic model should support continuous deployment and include development, test, and production environments. It should significantly improve upon the existing SQL views used in the on-premises SSAS cube. Initially, the model will include a limited number of SQL tables to demonstrate the potential of utilizing Microsoft Fabric for semantic modeling within the data landscape.

This Project is from scratch. We'll work first on the POC and if approved, we'll start the implementation and building a team of 4-5 Data Engineers.

• Interview process that respects people and their time
• Professional and open IT community
• Internal meet-ups and resources for knowledge sharing
• Time for recovery and relaxation
• Bright online and offline events
• Opportunity to become part of our internal volunteer community

Deliver in full the Scope of Work:

• Establish and manage connections to SQL Server tables within the Enterprise Data Warehouse.
• Configure and deploy Microsoft Fabric workspaces and deployment pipelines, ensuring secure access according to organizational standards.
• Refactor SQL views into semantic models using SQL/M-Query/DAX to optimize performance and reduce resource-intensive operations.
• Endorse and maintain semantic models to support self-service reporting and make them discoverable for end users.
• Enable and manage the semantic model’s XMLA endpoint for third-party application access.
• Train and educate internal teams on Power BI Semantic Models and their integration with Microsoft Fabric features.

• Proficiency in Microsoft Fabric and Power BI: Strong knowledge of Microsoft Fabric, including workspace and capacity management, and expertise in Power BI Desktop for developing and managing reports.
• Experience with Tabular Editor: Skilled in using Tabular Editor for building and managing data models.
• SQL, M-Query, and DAX Expertise: Proficiency in refactoring SQL views into semantic models using SQL, M-Query, and DAX.
• Familiarity with XMLA Endpoint: Experience in publishing and managing data models using the XMLA endpoint.
• On-premises Data Gateway Knowledge: Understanding of On-premises Data Gateway or VNet gateway for secure data refreshes.
• C# Scripting Skills: Ability to use C# scripts to accelerate development in Tabular Editor.
• Team Education and Training: Experience educating internal teams on Power BI and Microsoft Fabric features.