Business Intelligence Adviser

Organisation

The European Climate, Environment and Infrastructure Executive Agency (CINEA) mission is to support stakeholders in delivering the European Green Deal through high-quality programme management that helps to implement projects contributing to decarbonisation and sustainable growth. CINEA implements parts of EU funding programmes for transport, energy and climate action; for the financial perspectives 2021-2027 the Agency has expanded its portfolio of programmes with strong focus on contributing to the European Commission’s Green Deal priority.

The main programmes currently managed by CINEA are:

• The Connecting Europe Facility (CEF);

• Horizon Europe: the EU’s Research and Innovation programme for which CINEA manages the areas of cluster on Climate, Energy and Mobility;

• The Innovation Fund;

• LIFE Programme;

• European Maritime, Aquaculture and Fisheries Fund;

• The EU Renewable Energy Mechanism;

• The Public Sector Loan Facility of the Just Transition Mechanism Fund;

The budget managed by CINEA in 2021-2027 period is ca. € 58 billion.

CINEA is based in Brussels with a multinational team of nearly 600 persons. The number of staff will grow further over the coming years and the purpose of this publication is therefore to set up a reserve list, which will be used to cover the growing needs of the Agency. The reserve list may also be used by other Executive Agencies. More info on:

https://cinea.ec.europa.eu/index_en.

Mission description

To develop and maintain modern, state of the art Business Intelligence (BI) solutions for the implementation of funding programmes and projects related to the EU Green Deal under the responsibility of the Agency. The Business Intelligence Adviser will work in the Business Intelligence and Reporting Team of unit A1, under the supervision of the Head of Business Intelligence and Reporting, in close cooperation with colleagues within the Agency and the European Commission.

The working tools are advanced data processing & analysis tools (such as KNIME, R, Python, SQL, Excel, etc) and BI tools (such as QlikSense, PowerBI, LLM etc). The Business Intelligence Adviser needs to be up to date with the latest developments in the field of Business Intelligence, including the use of GIS and artificial intelligence tools. The position is Brussels-based.

Main duties:

The Business Intelligence Adviser will contribute to the team’s work in the areas of implementation of data tools, solutions and management, focusing on Datawarehouse and Business Intelligence solutions for CINEA and its programmes. The mandate includes:

Further development and Maintenance of CINEA’s Datawarehouse, in line with CINEA’s evolving business needs:

• Development, maintenance and documentation of ETL (Extract, Transform, Load) processes.
• Ensure data quality and data encoding against agreed principles and methodologies in view of maintaining a high degree of reliability of data sources.
• Follow-up CINEA’s IT developments and define requirements for their integration into the CINEA Datawarehouse.

Development of Business Intelligence solutions:

• Develop new and update existing business intelligence solutions according to the needs of services in CINEA, the Commission and external stakeholders.
• Document the solutions and give support and training to users.

Eligibility criteria

A. Eligibility criteria

The candidates must have:

• successfully passed a CAST in the function group for which you are applying* OR be registered in a CAST Permanent Call for Expression of Interest in function group FGIV ** by the deadline for application of the current vacancy;
• a level of education which corresponds to completed university studies of at least three years attested by a diploma OR, when in a member state of the European Union access to a profession of an equivalent level to function group IV is by State examination, professional training or any other equivalent procedure, the authority authorised to conclude contract of employment may agree to recognize this qualification as being equivalent to a university degree;
• thorough knowledge of one of the languages of the Communities and a satisfactory knowledge of another EU language to the extent necessary to perform duties.

* Candidates must be included in the European Personnel Selection Office (EPSO) database for contract agents in function group IV and have successfully passed the EPSO selection tests for that function group. Please note that candidates who are on a valid EPSO list published in 2010 (CAST2010) are eligible on the condition they have successfully passed the complementary tests (DB3), as an Annex to the selection procedure CAST2010. The candidates concerned are invited to consult the letter they received from EPSO for further information.

Other eligibility criteria

**In the context of the calls for expression of interest EPSO/CAST/P/2017 FGIV procedures (1), your application will be considered only if you have completed and validated the online application form by the deadline for application to the current vacancy(2) .

The pre-selected candidates will be requested by the Agency to undergo the EPSO computer-based reasoning tests. Only candidates that have successfully passed an EPSO CAST selection in FGIV will be invited for an interview.

(1) https://eu-careers.europa.eu/en/job-opportunities/cast_list

(2) Candidate’s application in the EPSO database must be active during the whole duration of the procedure. Candidates are fully responsible for the creation, validation and regular update of their EPSO profile in the relevant function group, otherwise candidates’ details are not or not anymore visible to the recruiting services and they cannot be invited to sit tests. Candidates whose EPSO CAST profile is blocked and therefore cannot be flagged in order to be invited by EPSO to undergo an EPSO computer-based reasoning test in the required function group will be considered as not eligible regardless of the relevance of their CV.

Selection criteria

B. Selection criteria

Essential:

• At least 3 years of professional experience in the design, implementation and maintenance of Business Intelligence solutions and data warehouses including the use of ETL (Extract, Transform, Load) tools.
• Excellent analytical skills and capacity to use data analytical tools to generate knowledge and additional insights in data.
• Good command of English (written and oral), C1.

Advantageous:

• Experience in corporate data warehouses of the European Commission such as eGrants Data Store, ABAC or SUMMA Datawarehouse
• More than 2 years of professional experience in the design, implementation and maintenance of data warehouses including the use of ETL (Extract, Transform, Load) tools

After having been preselected by the Selection Committee, the Agency will invite for an interview the best candidates that have successfully passed an EPSO CAST in the relevant function group, with a maximum of 15 candidates invited to the interview.

Applications must be introduced no later than 23/08/2024 midnight.

Please do not send applications via email or social media.