Junior Data Consultant Asset Planning

We are looking for a Junior Data Consultant to reinforce an asset planning team that prepares and monitors the budgets for network assets in electricity, gas, public lighting, sewerage and district heating. A forecasting project is drawing on the team's people, and at the same time the budget process is being digitalised: the current Excel budget file is to become a central database. You will lay the first foundations of that solution in Databricks and help the team plan its long-term investments on reliable, traceable data.

Your role

• Help prepare and follow up the budget and the multi-year investment plan, on both the technical and the financial side.
• Collect and analyse data from several applications and from internal and external parties to get an accurate view of the situation.
• Set up a basic structure in Databricks at short notice and translate the existing Excel solution into a central database.
• Keep a history of budget changes, using SCD Type 2 among other techniques, with clear traceability of changes, decisions, assumptions and scenarios.
• Support controlled data entry through interfaces and bulk uploads.
• Advise the team in its decisions and look for optimisations and best practices to manage, open up and process information.
• Work closely with internal and external stakeholders during budget preparation, and advise them on long-term planning and budgets.
• Provide training and communication on the information and the processes.
• Act as an independent facilitator and coordinator who keeps information and processes consistent.
• At a later stage, contribute to an interface built on top of Databricks.

You have

• At least one year of experience as a BI Consultant.
• Proven experience with ETL in data management.
• At least one year of experience in data management.
• At least one year of experience processing and analysing data with Databricks.
• At least one year of experience processing and analysing data with Python.
• At least one year of experience processing and analysing data with Power BI.
• At least one year of experience designing data models.
• Dutch at C2 level.

A plus

• Strong analytical thinking.
• Strong conceptual thinking.
• Experience with audit trails.
• Experience with data governance.
• Experience with reporting tools.
• Experience in requirements analysis.
• Experience with technical assets and asset management.
• Knowledge of data historisation.
• Skill in information analysis.
• Skill in data preparation.
• Enjoyment of working in a team.
• A results-oriented approach.
• The ability to keep a helicopter view while staying pragmatic in operations.
• A strong sense of responsibility.
• Flexibility.
• A sense of initiative.
• Good communication skills.