← Assignments

Senior Data & BI Consultant (Azure Databricks & Power BI)

Freelance East Flanders Senior

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.

What we are looking for

Specific skills

  • Proven experience as a BI Consultant 5 yr Senior Must have
  • Proven experience with data warehousing concepts, processes and architectures Must have
  • Proven experience with Data Management (ETL) Must have
  • Proven experience with Databricks 2 yr Medior Must have
  • Proven experience with Data Vault modelling Must have
  • Proven experience with Python 2 yr Medior Must have
  • Proven experience with SQL scripts 2 yr Medior Must have
  • Proven experience with star schema modelling Must have
  • Proven experience working in an MS Azure environment 5 yr Senior Must have
  • Certified as “Databricks Data Engineer Associate" - please attach the certificate here Must have
  • Proven experience in data analysis Should have
  • Proven experience with the SAP BW reporting tools (including Analysis for Office) Should have
  • Proven experience in information modelling (designing logical data models) Should have
  • Proven experience with Power BI as a reporting tool Should have
  • Proven experience with reporting tools Should have
  • Proven experience with requirements analysis Should have
  • Proven experience with SAP Datasphere Should have

General skills

  • During an interview, the candidate demonstrates a strong ability to learn Must have
  • During an interview, the candidate demonstrates a pragmatic and solution-oriented attitude Must have
  • Language requirement: Dutch at European CEFR level C2. Must have

Domain knowledge

  • Proven domain knowledge of Asset Management Should have

Industry knowledge

  • Proven experience in the Belgian energy sector Should have