← Assignments

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

Freelance East Flanders Senior

Will you help a large Flemish organisation migrate from SAP BW/HANA to Azure Databricks? As part of a self-managing team, you will help build the new data and reporting platform, from analysis to Power BI report, and act as the point of contact for the business.

A large Flemish organisation is building a hybrid data and information landscape in which an SAP-oriented platform (with BW and HANA systems) is combined 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, built up in different data and information layers and integrated with one another. This forms the basis for (advanced) analytics use cases and reports.

In one of the business domains, a data warehouse was built in the SAP stack (SAP BW, HANA) years ago. The growing digitalisation of how 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 those needs, a migration to the Azure Databricks data platform is under way.

To help build the new data and reporting platform on Azure, the organisation is looking for an experienced Data & BI consultant.

  • You further develop the organisation's data and information platform in line with the organisation's architecture and design principles.
  • You analyse and model the data analytics and business intelligence use cases and shape them using the various components of the platform.
  • You handle BI and data requests end-to-end and guide the client throughout the entire delivery process.
  • 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 design the data model in the different layers of the platform in accordance with the organisation's BI rules.
  • 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, comply with the organisation's ICT Change and Release process and help monitor that process.
  • You verify the work carried out on the basis of a test plan and help make the test data available so that the test cases can be executed.
  • You ensure that your work fits within the organisation's monitoring and alerting set-up, so that all errors become visible immediately and the agreed service levels can be met.
  • You maintain the organisation's data and information platform in operation: you run and monitor the daily load jobs and "keep it running" activities.
  • You take on incident and problem management.
  • You follow up on planned interventions and assist with them.
  • You assist the data team in resolving technical issues.
  • You share responsibility for the lifecycle management and updates/upgrades of the existing environments.
  • You develop overarching communication and training material and keep it up to date (in Enterprise Architect, Confluence and Jira).
  • 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 concerned: 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 future innovations and guide them through the introduction of these changes.

The organisation has structured its data teams by domain: within each domain, data and BI specialists develop the data and information products for that domain.

You will join a self-managing team of SAP BI and MS Azure BI experts and information analysts in the domain concerned. This is where the migration from SAP BW/HANA to Azure Databricks is taking place, and you will actively contribute to it.

Because of the close interaction with the business, a very good command of Dutch, both spoken and written, is essential.

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 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 Asset Management domain knowledge Should have

Industry knowledge

  • Proven experience in the Belgian energy sector Should have