Greetings from Sloka IT Solutions.
Title - Power BI Architect
Language - Dutch, French & English
Location - Kruidtuinlaan, 55 - 1000 Brussel
Duration - 2 months
Workplace type - Hybrid (Full-time or Part-time)
Experience - Minimum of 7 years
Description:
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 necessary 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, security of sensitive and confidential data.
* Setting up monitoring, including statistics 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 of reports and datasets.
* Integrating the existing metadata management tool into the new architecture.
* Defining and establishing technical standards: naming conventions, 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 FASFC teams (ICT, Strategic Unit, CISO, DPO), ensure the consistency of the platform.
* Document the architecture and train 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, performs excellently, is integrated, and enables scalability and cost optimization for reporting and datasets.
* Monitoring, including all useful statistics (see previous section), as well as multilingualism, publishing, version control, and the report lifecycle, are operational.
* Technical standards and dataset modeling, as well as DAX development enabling 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 in setting up a Power BI cloud reporting platform based on an Azure data warehouse fed by MS Fabric feeds.
* Experience in 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.
* Row-level security and management of 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 a plus.
* Knowledge of SAP BI is a plus.
Required profile:
* Master's degree in computer science or equivalent experience.
* Minimum of 7 years of experience with Power BI in the Azure Cloud (installation, configuration, implementation, modeling) in a professional environment.
* Excellent communication and teaching 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 full-time or part-time. This is a 30-man-day assignment.
To assist us in this challenge, we are looking for a Power BI Architect.
* Roles - Expert Business Intelligence (BI) Architect (mandatory) - Most recent experience Any time
Skills:
* Azure Data ServicesLevel Confirmed Most recent experience Any time
* CI/CD voor Power BI (Azure DevOps of GitHub)Level Confirmed Most recent experience Any time
* Datawarehouseconcepten (Kimball/Inmon/DataVault-modellering) en databeheerLevel Expert Most recent experience Any time
* Geavanceerde DAX, POwer Query en SQLLevel Expert Most recent experience Any time
* Power BI Desktop & Service (datasets, rapporten, dashboards)Level Confirmed Most recent experience Any time
* Power BI-integratie met Microsoft Fabric/Azure en andere databronnenLevel Expert Most recent experience Any time
* Publicatie, meertaligheid, beveiliging en monitoring in Power BILevel Confirmed Most recent experience Any time
* Tabulaire modellering en datasetoptimalisatie in de CloudLevel Confirmed Most recent experience Any time
Languages:
* Dutch - Level Native
* English - Level Active knowledge
* French - Level Native
If interested, kindly share your updated CV to sivapriya@sloka.eu