apply by 11 November 2026
BI & Data Consultant – Asset Planning
- Databricks
- Python
- Power BI
- ETL processes
- data models
- Dutch
For a major organisation in the energy and utilities sector, the BI & Data Consultant will support the Asset Planning department, which is responsible for budgeting and long-term investment planning across electricity, gas, public lighting, wastewater and heating networks. The assignment modernises and centralises the existing budgeting process by transforming Excel-based solutions into a structured, scalable data environment built on Databricks, combining data engineering, BI, data modelling and business analysis. Responsibilities include designing the Databricks environment, migrating budgeting solutions, developing Python data pipelines and ETL processes, integrating and analysing data, building data models, and developing Power BI reports and dashboards. The consultant will implement historisation, traceability, audit trails and data quality controls; support controlled data input and data governance; help prepare and monitor annual budgets and multi-year investment plans; analyse technical and financial information; collaborate with stakeholders; translate business requirements into technical solutions; optimise data processing, reporting and information management; support users through documentation, training and communication; and contribute to the potential development of a user interface on top of Databricks.
> Profile and essential requirements
- At least 1 year of demonstrable experience as a BI Consultant
- at least 1 year of experience in data management and data processing
- practical experience with Databricks, Python and Power BI
- experience developing and maintaining ETL processes
- experience designing and implementing data models
- ability to independently build and configure technical data solutions
- strong analytical and conceptual thinking skills
- ability to translate business needs into structured data solutions
- excellent communication and stakeholder management skills
- Dutch at CEFR C2 level – mandatory. Although the formal experience requirement starts at one year, the consultant must be sufficiently autonomous to set up and deliver a working technical solution.
> Optional assets
- experience with data governance, data historisation and audit trails
- knowledge of SCD Type 2
- experience with reporting and business intelligence tools
- experience in requirements analysis
- knowledge of asset management or infrastructure investment planning
- experience with technical asset data
- previous experience in the energy, utilities or infrastructure sector
- familiarity with financial forecasting, budgeting and long-term investment planning. The ideal candidate enjoys combining technical development with business analysis, is comfortable working independently with Databricks, Python and Power BI, understands data modelling and structured data management, can convert complex Excel processes into reliable, scalable solutions, works well with technical teams and business stakeholders, is analytical, pragmatic and solution-oriented, and can balance a broader architectural perspective with hands-on implementation.
- data governance
- data historisation
- audit trails
- SCD Type 2
- reporting and business intelligence tools
- requirements analysis
- asset management
- infrastructure investment planning
- technical asset data
- energy, utilities or infrastructure sector
- financial forecasting
- budgeting
- long-term investment planning
- data management and data processing
- analytical and conceptual thinking
- communication and stakeholder management
> Additional details
Sector: Energy & Utilities. The team plans budgets and long-term investments across electricity, gas, public lighting, wastewater and heating networks. The user interface built on top of Databricks is a potential development.