This Job Vacancy has Expired!

Data Scientist Service Medior - 12 months - Brussels

Octopus Computer Associates

Posted on Apr 6, 2022 by Octopus Computer Associates

Brussel, Belgium
Immediate Start
Annual Salary

Data Scientist Service Medior - 12 months - Brussels

One of our important clients is currently looking for the support of a specialized company with expert knowledge of data mining, data gathering/processing (in VBA, Excel, R), data quality and data visualization but also with knowledge of the electricity market


The consultant will work on the following and non-exhaustive list of tasks:

  • Data mining of large excel or R database and perform quality checks (based on existing tools or by developing new excel/VBA tools);
  • Data comparison of different sources in order to build scenarios for the CRM, including visuals;
  • Automatization of excel/VBA/R tools in order to facilitate the analysis;
  • Documentation of the tools used/created;
  • Support the SMA team for inputting data in the economic dispatch tool used ( ANTARES ) and perform quality checks on the input, including visuals;
  • Support the SMA team for the analysis of the output data from ANTARES, including among others performing tests, developing tools to perform quality checks and validate the data, developing visuals for the relevant indicators, developing tools to compare results of different auctions;
  • Extraction, Analysis and Validation of hourly data, ensuring the coherency of databases, including visuals;

Skills required:

Therefore it is expected expert knowledge of the following tools

  • R Studio

R is a software language with focus on statistical data analysis.
R is in use for more than 5 years within the team. Several scripts were developed by the French TSO (RTE) to input and output data from ANTARES. The team has also further developed scripts for their own studies and analysis. R is more and more used and replaces Excel/VBA in the Scripting where a lot of data needs to be handled.
RTE packages:


Excel and VBA are a lot use to conduct analyses or to input data into the ANTARES tool. It is one of the way the teams uses to analyse data (up to a certain size). Many of the databases used by SMA are stored in Excel format. For this task, it is not a must to know VBA. Moreover, most of the tasks expected from the consultant requires its usages.
Moreover, a general knowledge of ANTARES (mainly the input/output interface) or an economic dispatch tool is considered as 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 analyze it.

  • Visualization tools

Additional knowledge regarding visualization tool (QGIS, PowerBI, ...) is considered as a nice to have in order to provide the expected visuals described in the list of tasks. However, most of the tasks can be fulfilled with excel.
In addition of the above-mentioned hard skills, the following soft skills are expected:

  • You have good knowledge and interest in the energy market;
  • You have good knowledge/experience in data mining/processing of big amount of data with Rstudio tool;
  • You have at least and minimum two years of experience with similar project in the past;
  • You are able to work independently and in a team;
  • You have an analytical and innovative mind;
  • You are fluent in French or Dutch, and fluent in English.

If you are interested in this please send me your CV and I will contact you for more details.

Reference: 1557321990

Set up alerts to get notified of new vacancies.