Data Analyst

EPSA; Brussel Hoofdstad; Sur place; EUR 60 000 - 90 000; Plein temps

Résumé du poste

EPSA in Belgium seeks a proactive energy data analyst (energy geek) to support grid studies, data infrastructure, and simulations using ANTARES. The role combines data collection, tool development, and scenario analysis to inform energy transition projects in BE and EU contexts.

You will work with the team on data mining, processing in VBA/Excel, R/Python, and visualization; you will challenge projections and help build robust data pipelines for hourly dispatch studies.

Qualifications

• Experience in energy data analysis and modeling.
• Strong programming skills in Python or R.
• Proficient in Excel and VBA for data processing.

Responsabilités

• Consolidate historical data into model inputs.
• Collect projection scenarios and ensure consistency with defined stories.
• Develop tools in R/Python/VBA/Excel to adjust parameters or data items.
• Create visualisations of simulation outputs using R/Power BI/QGIS.
• Critically analyze results and support data engineering interfaces.

Connaissances

Data analysis

Teamwork

Analytical mind

English/Dutch/French

Outils

R

Python

Excel

VBA

ANTARES

Power BI

QGIS

Description du poste

On top of the development of the grid, asset and system management and market facilitation above mentioned, the TSO in Belgium is also responsible to conduct several security of supply studies (short, medium and long term), vision studies, cost benefit analysis of future grid projects,... Those studies are based on economic dispatch tools, which evaluate the need for additional generation capacity, the economic outputs or the margin available in the system for every hour of the year.

This assignment requires a knowledge of energy sector in Belgium and in Europe (i.e. main policies and targets), especially in the electricity sector. The consultant will support the team in building future energy scenarios (e.g. trajectories for future electricity demand in Belgium and in Europe, looking at EV, HP and industry projection; trajectories for supply side with thermal and RES production; …). This leads to a very high amount of data collection and consolidation from different sources, tools creation and review, slide/figure creations,… Previous experience in market simulations is a plus (for instance, using an economic dispatch tool like ANTARES)

.
Our client is therefore looking for a pro-active, “energy geek” and “data geek”. 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,…

)
They need 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 te

am:- Use, and when possible improve, data management processes at S

MA.- Contribute, and when possible improve, data collection processes and definition – creation of scenarios and model building datase

ts.- Support the model building, including quality checks on the built mode

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

ns.
Example of t

asksA non-exhaustive list of tasks (and description) is given be

• low: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 storyli
• nes;Create & review tools in R/Python/VBA/Excel in order to input/change different parameters or data items in the model or simulation ANTARES t
• ool;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 tr
• endsData engineering and interfaces between t
• oolsOther tasks (not yet defi

ned)
Requirem

ents:Hard s

• skillsR 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’) an
• d VBAExcel and VBA 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 fo
• rmat.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 b
• asis.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 analys
• e it.Any experience with market simulations can be valued

here.
Soft

• nimum.You have knowledge of and strong interest in the energy m
• arket;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 req

uired.
About the p

• rofile:You are passionate in about the energy tra
• nsitionYou are interested to deliver high quality tools to improve the team’s func
• tioningYou are looking to invest a team on the medium term where you could face challenging projects and grow an ex