As a Senior Data & BI Consultant, you will help build the new Azure data platform of a Belgian utility organisation, where an operational domain is migrating to Azure Databricks. Working in a self-managing team, you will handle BI questions end-to-end, from analysis to Power BI report.
The client is a Belgian organisation responsible for the construction, management and maintenance of public utility networks. The company was formed a few years ago through a merger of former organisations.
The organisation is building a hybrid data and information landscape that combines an SAP-oriented platform (with BW and HANA systems) with a modern data platform in the Microsoft Azure Cloud. Power BI serves as the central reporting tool. Data from various sources and applications is made available to these platforms, structured into different data and information layers and integrated across them. This forms the foundation for delivering (advanced) analytics use cases and reports.
To support all of this, the data teams have been organised by domain. Within this structure, data and BI specialists develop data and information products specific to their domain. In the operational domain concerned, a data warehouse was built in the SAP stack (SAP BW, HANA) years ago. The growing digitalisation of the way the organisation works with its assets (digital meters, digital substations, CLMS for public lighting, ...) is creating growing BI & Analytics needs in this domain. To meet them, a migration to the Azure Databricks data platform is under way.
As an experienced Data & BI consultant, you will help build the new data and reporting platform (on Azure) and contribute your expertise to various projects and maintenance assignments on the organisation's data and information platform.
- You handle BI and data questions end-to-end, from needs analysis and technical design to data modelling in the Azure Databricks data platform and visualisation/reporting in Power BI. You guide the client through the entire delivery process.
- You further develop the platform in line with the organisation's architecture and design principles.
- You analyse, model and shape data analytics and business intelligence use cases using the various components of the data and information platform.
- You draw up functional analyses/specifications and discuss them with the various stakeholders (information analysts, information stewards, key users, ...).
- Based on the analytical needs, you work out the data model in the various layers of the platform in accordance with the internal BI guidelines.
- You are responsible for the technical implementation within an MS Azure environment (Databricks, Power BI), from extraction to final report.
- You follow the standard development cycle within the platform and comply with the internal ICT Change and Release process.
- You verify the work delivered against a test plan and help make test data available so that the test cases can be executed.
- You make sure your work fits into the existing monitoring and alerting setup, so that any errors become visible immediately and the agreed service levels can be met.
- You maintain the organisation's data and information platform in operation and support the data team in keeping the BI and data platforms running:
- Running and monitoring the daily load jobs and "keep it running" activities
- Incident & Problem management
- Following up on and assisting with planned interventions
- Follow-up of the change & release process
- You assist the data team in resolving technical issues.
- You develop overarching communication and training materials and keep them up to date (in Enterprise Architect, Confluence and Jira).
- You share responsibility for lifecycle management and updates/upgrades of the existing environments.
- Drawing on your expertise, you make improvement proposals for the organisation's data and information platform.
- You are the point of contact for the business within the domain: you provide functional support to business users, assist them in using the reporting and analysis tools, or train them.
- You help shape the future of Analytics within the organisation, prepare the client for upcoming innovations and guide them through the introduction of these changes.
As a true team player, you contribute to better collaboration by sharing information with colleagues.
You will join a self-managing team of SAP BI and MS Azure BI experts and information analysts.