Market & Data Analyst

Appsierra Group; Brussel; Sur place; EUR 60 000 - 80 000; Plein temps

Résumé du poste

Elia is seeking a medior data analyst to support data infrastructure, data processing and simulations for energy transition projects. You will help ensure data quality, question projections and contribute to model building for energy systems.

The consultant will engage in data mining, processing (in VBA, Excel, R/Python), visualization (Power BI, Qgis) and tools development within SMA projects, working both independently and in teams.

Qualifications

• Medior profile with at least 3 years of experience in data analysis or a related field.
• Fluent in Dutch and/or French and English.

Responsabilités

• Support data management processes and data collection for SMA projects.
• Create, review and challenge data inputs and scenarios for energy systems models.

Connaissances

R

Python

Dutch

French

English

Outils

Excel

VBA

Power BI

ANTARES

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:

1. Consolidate historical data into an model input data set.

2. Collect projection scenarios from EU countries, and challenge the data, ensure those are in line with defined storylines;

3. 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;

4. Be able to use and improve, create visualisations of the outputs of simulations (in R, Power BI, Qgis, …)

5. Critically analyze results of algorithms, assist in the identification of key trends

6. Data engineering and interfaces between tools

7. 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.