Market & Data Analyst

MEERAB GROUP; Brussel; Sur place; EUR 48 000 - 65 000; Plein temps

Résumé du poste

Elia seeks a medior data analyst with a strong interest in the energy transition to support data infrastructure, scenario building, and simulations for energy system studies.

The role involves data mining, processing in VBA/Excel/R/Python, and producing visualisations to help plan the energy transition across BE or EU markets.

Qualifications

• Proficiency in R or Python is required, with emphasis on data analysis.
• Excel and VBA are used to conduct analyses and interface with scripts.
• ANTARES is a core input/output tool; familiarity is a plus.
• Experience with Power BI and QGIS for visualisation is valued.

Responsabilités

• Consolidate historical data into model input datasets.
• Collect projection scenarios from EU countries and challenge data against defined storylines.
• Create and review tools in R/Python/VBA/Excel to input or modify model parameters.
• Develop visualisations of simulation outputs using R, Power BI, and QGIS.
• Support model building, data quality checks, and interpretation of results.

Connaissances

R

Python

Excel

VBA

Outils

ANTARES

Power BI

QGIS

Excel

Description du poste

We are looking for a medior profile with proficient coding skills but mainly with strong interest and knowledge in the energy sector, that is interested by the energy transition and that will help the team getting the right data infrastructure and tools as well as support in performing and analyzing the appropriate simulations to deliver state-of-the‑art studies needed to plan the energy transition. We’re looking for someone who will always questioned the scenarios data, someone able and willing to challenge projections (concerning evolution of PV, wind, H2 thermal units,…) for BE or other EU main countries, able and willing to estimate if those are rather ambitious or realistic,…).

Elia Is Therefore Looking For The Support Of a Specialized Service With Expert Knowledge On Data Analysis (data Mining, Data Gathering/processing (in VBA, Excel, R/Python), Data Visualization) And Energy Systems Scenarios. The Consultant Will Help To Perform Different Tasks In Different Projects Within The SMA Team

• Use, and when possible improve, data management processes at SMA.
• Contribute, and when possible improve, data collection processes and definition – creation of scenarios and model building datasets.
• Support the model building, including quality checks on the built models.
• Support on the impact assessment of (some parts of ) the model building (e.g. the demand assumptions, renewables assumptions, flexibility and storage assumptions..) as well as quality checks on the models and results after simulations.

Example of tasks

A non-exhaustive list of tasks (and description) is given below:

• Consolidate historical data into an model input data set.
• Collect projection scenarios from EU countries, and challenge the data, ensure those are in line with defined storylines;
• Create & review tools in R/Python/VBA/Excel in order to input/change different parameters or data items in the model or simulation ANTARES tool;
• Be able to use and improve, create visualisations of the outputs of simulations (in R, Power BI, Qgis, …)
• Critically analyze results of algorithms, assist in the identification of key trends
• Data engineering and interfaces between tools
• Other tasks (not yet defined)

Requirements

Hard skills

• R or Python (must have)
• R is extensively used in existing tools at SMA. However new tools are rather developed now in Python. Hence, proficiency in one of the two is a must, but experience with both is a plus.

Excel (must have) and VBA (nice to have)

• Excel and VBA are used to conduct analyses or as interface for R/python scripts. It is one of the ways the team explores data (up to a certain size). Many of the databases used by SMA are stored in Excel format.

ANTARES (mainly the input/output interface but also a general knowledge of economic dispatch tool is a nice to have)

• ANTARES is an economic dispatch tool developed by RTE, the French TSO. In the application’s core is an economic dispatch tool for the electricity market. Antares allows to simulate the electricity market on an hourly basis.
• The tool needs to be fed with input data and given the large quantity of data generated by the simulator (depending on the study, more than 10 GB per simulation), several scripts and spreadsheets were developed to input, retrieve data and analyse it.
• Any experience with market simulations can be valued here.

Soft Skills

• Medior profile: 3 yrs experience minimum.
• You have knowledge of and strong interest in the energy market;
• You are able to work independently and in a team;
• You have an analytical and innovative mind;
• Fluent level of Dutch and/or French and English is required.