Log in INEA Candidate Area

Login

 
INEA vacancy search engine

You are here :  Home  ›  List of jobs  ›  Vacancy details

Business Intelligence Manager


Vacancy details

General information

Organisation

INEA is an Executive Agency established by the European Commission and its mission is to provide its stakeholders with high-level programme management in order to benefit economic growth and EU citizens. Currently, INEA implements parts of EU funding programmes for transport, energy, telecommunications and climate action. For the next financing perspective (2021-2027), the Agency will expand its portfolio of programmes with strong focus on contributing to the EC's Green Deal objective.
The three main programmes currently managed by INEA are:
•The Connecting Europe Facility (CEF): supports high-performing, sustainable and interconnected Trans-European Networks.
• Horizon 2020: the EU's Research and Innovation programme for which INEA manages the areas of transport and energy.
•The Innovation Fund: one of the world's largest climate innovation funding programmes, which is likely to have up to €10 billion for demonstration of innovative low-carbon technologies between 2020-2030.
INEA is based in Brussels and has a multinational team of around 300 persons. The number of staff is expected to grow further over the coming years, in view of the Agency's new portfolio 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.
More info on INEA: Website: http://ec.europa.eu/ineaTwitter: @inea_euLinkedIn: http://bit.ly/2ecs3JA  

Position description

Profile

IT services - Business Analyst

Position title

Business Intelligence Manager

Contract

Contract agent

Grade

FGIV

Mission description

Overall Purpose
To provide Business Intelligence solutions to monitor the financial and technical implementation of the programmes under the responsibility of the Agency. S/he will work in unit R1, in the Business Intelligence and Reporting Team under the supervision of the Head of Business Intelligence and Reporting and in close cooperation with the other members of the team.
Working tools: Qlik Sense, R, advanced MS Excel, Oracle, SQL Server, Pentaho, Business Objects, MS Access .

Salary range

35-50 k€

Tasks

Main duties
Provide business intelligence solutions to monitor the financial, technical implementation and policy-relevant components of the delegated Programmes.

Data Processing and Data Analysis:
• Provide user requirements for the design and further development of an INEA Data Warehouse building upon various corporate systems.
• Develop and maintain business intelligence solutions in Qlik Sense, R, Business Objects, MS Access, MS Excel or similar tools. Document the solutions and where appropriate give feedback and training to the stakeholders.
• Ensure data quality and validate data encoding against agreed principles and methodologies in view of maintaining a high degree of reliability of data sources.
• Follow-up IT developments and define new requirements for the corporate systems to be integrated in the Data Warehouse.

Internal and external communication
• Cooperate with colleagues in the Parent DGs, Director's office, Operational Departments, and other stakeholders in view of producing statistics according to their need.
• Produce statistics, prepare data visualisations and draft reports to support the reporting on the implementation of the delegated Programmes.
• Handle requests for information (to be included in briefings or presentations), and prepare the appropriate responses.
• Support the production of publications on the delegated programmes with data and analysis.
• Effective participation and contribution to team work
• Under the leadership of the Head of Business Intelligence and Reporting, carry out his/her tasks in a timely and effective manner and work together with other team members, to support the mission and priorities of the Unit and the Agency.
• Maintain effective communication and share information within the team ensuring that all team members are aware and regularly informed on all developments related to their work and performance.

Interview period - from :

15/04/2021

Interview period : to

30/06/2021

Selection procedure

A - Written tests (30 min)
A case study in English designed to test:
• Your knowledge in the field of the profile
• Your ability to understand, analyse and summarise
• Your drafting ability

This test will be marked out of 40 (pass mark: 20).
Total time allowed for this test: 30 minutes.

B – Oral test (30 min)
Interview with a selection board in English to assess:
• your suitability to carry out the duties of a Business Intelligence Manager,
• your knowledge and experience in the field of Business Intelligence,
• your communication, inter-personal and problem-solving skills,
• your general knowledge about the INEA and related policies,
• your motivation and your ability to adjust to working as a Contractual Agent in a multicultural environment.
This test will be marked out of 100 (pass mark: 50).
Both the oral and written tests will be combined on a total of 140. Minimum mark: 84 out of 140.
Applicants receiving the minimum score and above (84 out 140), all tests combined, will be included in a reserve list of suitable candidates. Please note that inclusion in the reserve list does not guarantee recruitment.

Application procedure

For applications to be valid, candidates must submit:
- a detailed curriculum vitae, in EU CV format* ;
- a letter of motivation, including his/her views on the proposed position (2 pages maximum).

Your CAST application ID number and the reference of CAST must be mentioned in your CV and motivation letter.

Please note that the motivation letter forms an essential basis for the pre-selection decision.
Applications must be submitted through the eRecruitment system on our website at
http://ec.europa.eu/inea/en/mission-objectives/job-opportunities

Closing date: Applications must be sent no later than 12 March 2021 midnight.
Supporting documents showing evidence of the provided information may be requested at a later stage. No document will be sent back to candidates.

Candidates are invited to apply in English to facilitate the selection process.

In no circumstances should candidates approach the Selection Committee themselves, either directly or indirectly concerning this recruitment. The authority habilitated to conclude contracts reserves itself the right to disqualify any candidate who disregards these instructions.

*EU CV format available on: https://europa.eu/europass/eportfolio/screen/profile-wizard?lang=en

Appointment and conditions of employment

The jobholder will be assigned on the basis of a shortlist proposed by the selection committee.
The jobholder will be recruited as contract staff, in function group IV, pursuant to Article 3a of the Conditions of Employment of Other Servants of the European Communities (CEOS).
The basic monthly salary within this function group will depend on the number of years of relevant professional experience at appropriate level (in function group IV, either grade 13, grade 14 or grade 16).
The jobholder will serve a probation period of nine months.
The initial contract will be for a duration of 1 year. Afterwards, the contract may be renewed for 1 additional year. If the contract is renewed again, it shall be concluded for an indefinite period.
The place of employment will be Brussels where the Agency has its activities.
For reasons related to the Agency's operational requirements, the candidate will be required to be available at short notice.
For further information on the legal framework of contract agents see the web site of the Directorate-General for Human Resources and Security (DG HR) on the internet at
http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=CONSLEG:1962R0031:20140101:EN:PDF

Publication date

Publication start date

19/02/2021

Publication end date

12/03/2021

Candidate criteria

Eligibility criteria

A. Eligibility criteria
• Be owner of a CAST in the grade for which you are applying* Or be registered in the EPSO/CAST/P/17/2017** before applying;
• 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 authorized 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 European Union and a satisfactory knowledge of another one to the extent necessary to perform his/her 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 call for expression of interest (1) EPSO/CAST/P/17/2017 procedure, your application will be considered only if not outdated and you are available to be flagged for the EPSO testing request during the screening phase of this selection process(2) . The pre-selected candidates will be requested by the Agency to undergo the EPSO tests. Only candidates that have successfully passed the EPSO CAST selection will then be invited for an interview.

In addition, in order to be eligible, a candidate must:
• be a national of one of the Member States of the European Union;
• be entitled to his/her full rights as citizen;
• meet the appropriate character reference as to his/her suitability for the performance of his/her duties;
• have fulfilled any obligations imposed by the applicable laws concerning military service, and;
• be physically fit to perform the duties linked to the post.

Please note that only candidates that comply with the Eligibility criteria will be considered for further steps of this Selection procedure.
(1) https://epso.europa.eu/epsocrs-ref-numbers/epso-cast-p-17-2017_en
(2) Candidates who are blocked and therefore cannot be flagged in order to be invited by EPSO to undergo the EPSO/CAST/P/17/2017 competition, because they have failed in the previous testing windows, will be considered as not eligible regardless of the relevance or not of their CV.

Selection criteria

Essential:
• At least two years of professional experience acquired in positions related to the profile of the post, including in the areas of design and implementation of interactive dashboards.
• Experience with QlikSense and/or SAP Business Objects
• Excellent analytical and communication skills (writing and oral)
• Extensive experience in drafting documents (English) with very good drafting skills (English, C1)
• Very good command of English (C1)

Advantageous:
• Professional experience acquired in the design and implementation ETL solutions and data warehousing
• Solid understanding of relational database theory, relational database management systems (RDBMS) in Oracle and query languages (SQL and PL-SQL)

Personal qualities essential for the position (evaluated during the interview):
• High degree of organisational skills, attention to detail and ability to work under pressure
• Good interpersonal, problem-solving, drafting and communication skills
• Proven ability to work as a team member
• Dynamic, pro-active and service-oriented approach
• Ability to appreciate and follow priorities, sense of initiative and capability to take up responsibility

After having been preselected by the Selection Committee, the Agency will invite for an interview the best candidates that are owner of a CAST in the relevant function group or that have successfully passed the EPSO CAST selection EPSO/CAST/P/17/2017 with a maximum of 10 candidates.

Languages

English (Proficient C1)

Updates on the application process

An acknowledgement of receipt will be sent to all candidates by email to confirm the reception of their application.
All candidates will be informed in due time about the status of their application, i.e. whether they are invited for the selection phase described above or not. These notifications will be sent via email only.
A candidate may request clarifications about the processing of his/her application by sending an email quoting the reference of the vacancy notice concerned, to the following address: INEA-HR-INFO@ec.europa.eu.

Equal opportunities, appeal procedure & data protection

The European Union institutions apply a policy of equal opportunities and accept applications without discrimination on the ground of sex, race, colour, ethnic or social origin, genetic features, language, religion or belief, political or any other opinion, membership of a national minority, property, birth, disability, age or sexual orientation.

A candidate who estimates that a mistake was made in the assessment of his/her profile may ask to have it re-assessed by sending, within 15 calendar days of the date on the email notifying the rejection of his/her application, a request for review, quoting the number of the selection procedure concerned to the Chairman of the Selection Committee at the following address: INEA-HR-INFO@ec.europa.eu
The Selection Committee will reconsider the application and notify the candidate of its decision within 15 working days of receipt of the letter.

The purpose of processing of the data submitted by candidates is to manage the applications in view of a possible pre-selection and recruitment at the INEA. The personal information requested from candidates will be processed in line with Regulation (EU) 2018/1725 of the European Parliament and of the Council of 23 October 2018 on the protection of individuals with regard to the processing of personal data by the Community institutions and bodies and on the free movement of such data.