For several years, the FAVV has been striving to become a fully data-driven organization and relies on a central data warehouse for its reporting and analysis.

Given the rapidly evolving technologies and business needs, the FAVV now wants to modernize this platform by migrating it to the Microsoft Azure cloud. This transition is accompanied by the implementation of new, powerful tools, including Microsoft Fabric (ETL) and Power BI.

To assist us with this challenge, we are looking for a Power BI Architect profile.

Mission:

• Designing the Power BI architecture (workspaces, shared datasets, management) in the Azure Cloud.
• Implementing and configuring the Power BI platform (workspaces, licenses, gateways, capacity management) in line with the data warehouse platform in the Azure Cloud and integrating the required Azure services.
• Implementing security in accordance with the organization's governance framework and data classification as defined in the metadata management tool: Row-Level Security, access to datasets and reports, Azure AD authentication, protection of sensitive and confidential data.
• Setting up monitoring, including metrics such as execution time, dataset usage/users/reports, etc.
• Implementing multilingualism, publishing, version control, and the lifecycle of reports.
• Defining and establishing standards for dataset modeling and DAX development with the aim of optimization.
• Ensuring optimal performance, integrity, stability, scalability, and cost savings for reporting and datasets.
• Integrating the existing metadata management tool into the new architecture.
• Defining and establishing technical standards: naming, security, governance, monitoring, and CI/CD.
• In collaboration with the MS Fabric architect, ensuring a complete data warehouse and reporting platform, so that Power BI models can be aligned with the Kimball/Snowflake star schemas of the data warehouse.
• In collaboration with the FAVV teams (ICT, Strategic Unit, CISO, DPO), ensuring the consistency of the platform.
• Documenting the architecture and training the ICT teams (BI, CCOE (Cloud Center of Excellence), solution architects).

Expected results:

• Power BI and the necessary reporting services are implemented, configured, and fully integrated with the data warehouse platform in the Azure Cloud, using MS Fabric as the ETL tool.
• The Power BI architecture (workspaces, shared datasets, etc.) is fully set up and secured in accordance with the data governance and classification (security and confidentiality) introduced in the DataGalaxy metadata management tool. DataGalaxy is fully integrated with the Power BI architecture.
• This new platform is stable, has excellent performance, is integrated, and enables scalability and cost optimization for reporting and datasets.
• Monitoring, including all useful metrics (see previous section), as well as multilingualism, publishing, version control, and the lifecycle of reports, is operational.
• Technical standards and modeling of datasets, as well as DAX development that enables performance optimization, are established and aligned with the Kimball/snowflake star schemas of the data warehouse.
• The architecture is documented and explained to the ICT teams (BI, CCOE, Solutions Architect).

Technical skills:

• Power BI Desktop & Service (datasets, reports, dashboards).
• Demonstrable expertise in Azure Data Services.
• Tabular modeling and dataset optimization in the cloud.
• Demonstrable experience with setting up a Power BI cloud reporting platform based on an Azure data warehouse fed by MS Fabric feeds.
• Experience with implementing publishing, security, and monitoring in Power BI.
• Practical knowledge of data warehouse concepts (Kimball/Inmon/DataVault modeling) and data management.
• Practical knowledge of multilingualism and publishing in Power BI.
• Advanced DAX, Power Query, and SQL.
• Security and management at row level for Power BI and data in Azure.
• Power BI integration with Microsoft Fabric/Azure and other data sources.
• CI/CD for Power BI (Azure DevOps or GitHub).
• Knowledge of Sparx Enterprise Architect for documentation is an asset.
• Knowledge of SAP BI is an asset.

Required profile:

• Master's degree in computer science or equivalent experience.
• At least 7 years of experience with Power BI in the Azure Cloud (installation, configuration, implementation, modeling) in a professional environment.
• Excellent communication and didactic skills.
• Strategic vision and focus on optimization.
• Ability to work in a team.
• French/Dutch with a good passive knowledge of the other language (required).

The position can be exercised either full-time or part-time. It concerns a mission of 30 man-days.