Header

IT Specialist - Data Architecture and Database Administration

The European Insurance and Occupational Pensions Authority (EIOPA) is an independent advisory body to the European Parliament, the Council of the European Union and the European Commission that was established on 1 January 2011.

EIOPA is at the heart of insurance and occupational pensions’ supervision in the European Union. It is part of the European System of Financial Supervision (ESFS) which includes also the European Banking Authority (EBA), the European Securities and Markets Authority (ESMA) and the European Systemic Risk Board (ESRB).

EIOPA’s core responsibilities are to support the stability of the financial system, transparency of markets and financial products as well as the protection of insurance policyholders, pension scheme members and their beneficiaries.

For its offices in Frankfurt am Main, Germany, EIOPA is currently inviting applications for a position as

IT Specialist - Data Architecture and Database Administration

Job description

Major purpose

The Corporate Support Department is responsible for supporting the operational work of the Agency, enhancing its ability to act as a modern, competent and professional organisation with effective governance arrangements, efficient processes and a positive reputation.

It is composed of the following units and teams:

Finance and Procurement Unit

Human Resources Unit

IT Unit

Corporate Services Team

Within the IT Unit, the successful candidate will be responsible for determining the design and information management strategies necessary to store, move and manage data for all IT-related projects at EIOPA. He/she will support day-to-day operations in the field of database services, data quality, data integration and data warehousing.

b) A level of secondary education attested by a diploma giving access to post-secondary education, and relevant professional experience of at least three years, or

c) Where justified in the interests of the service, professional training or professional experience of an equivalent level, preferably in management information systems, library sciences, information science, computer science, business administration or a related field.

Have at least 9 years of proven full-time professional experience in a field relevant for this position acquired after the qualification required under a), b) or c) above.

Proven experience in data modelling;

Proven successful participation in at least one project on data integration, business intelligence (BI) or enterprise information management;

Proven experience in the day-to-day administration of a common database management system, preferably Microsoft SQL Server;

Very good command of oral and written English;

Working knowledge of MS Office, in particular Word, Excel and PowerPoint.

Desirable Skills

Proven work experience in a multicultural environment;

Strong knowledge of database security concepts;

Proven exposure to complex dimensional data models;

Knowledge of SAS;

Knowledge of a third EU language.

For the above position, the following behavioural competencies have to be fulfilled:

Flexibility in terms of openness to taking over other tasks within EIOPA in view of the dynamic and evolving institutional environment;

Excellent team player sharing relevant information and supporting team members without taking over responsibility for their work, being able to work in different teams with different levels of stakeholders in a multicultural environment;

Being able to have and express a critical view towards own performance and open to learn from experience;

Being able to establish and maintain cooperative relationships both inside and outside the organization, ensuring clear communication and mutual comprehension and finding common ground/points of agreement;

Being able to deliver results within tight time frames;

Being able to manage multiple assignments and track progress on numerous processes simultaneously.

Place of employment

Frankfurt am Main, Germany

Function group and grade

AST 4

Monthly basic salary

Step 1: 4,099.01 EUR

Step 2: 4,271.25 EUR

plus specific allowances where applicable*.

Start date

1 March 2017

Contract type and duration

Successful external candidates may be offered an employment contract for three years as a Temporary Agent. The contract may be renewed for a second fixed-term period, and upon its second renewal converted into a contract of indefinite duration.

Reserve list

Possibility of reserve list with validity until up to 12 months

*Summary of Conditions of Employment

1. Successful external candidates will be classified either in step 1or 2.

Grade/step3

Monthly basic salary4

Monthly net salary, including specific allowances5

AST4 Step 1

4,099.01 EUR

4,636.10 EUR

AST4 Step 2

4,271.25 EUR

4,792.08 EUR

2. Salaries are subject to a Union tax deducted at source and are exempt from national taxation;

3. Depending on the individual family situation and the place of origin, the successful jobholder may be entitled to: expatriation allowance (16% of the basic salary), household allowance, dependent child allowance, education allowance, pre-school allowance, installation allowance, reimbursement of removal costs, initial temporary daily subsistence allowance, and other benefits;

4. Annual leave entitlement of two days per calendar month plus additional days for grade, distance from the place of origin and in addition on average 15 EIOPA holidays per year;

7. General and relevant technical training plus professional development opportunities;

Information reserved for applicants employed under Article 2(f) of the CEOS, in EU Agencies other than EIOPA:

According to EIOPA Management Board decision EIOPA-MB-15-072 adopting the implementing rules on the procedure governing the engagement and use of temporary staff under Article 2(f) of the CEOS, and in particular Article 12 (2), if a successful applicant from this external procedure, on the closing day for applications, as well as on the day of taking up duty at EIOPA:

is a member of temporary staff under Article 2(f) of the CEOS, and

is employed within his/her agency in function group and grade included in the range “AST3 – AST5”,

EIOPA shall offer the applicant, in writing, the opportunity either:

a) to be assigned to the post by means of internal mobility, as per Article 10 of EIOPA-MB-15-072. In this case the contract at EIOPA will be in continuity with the contract of the previous agency (namely with regard to grade, step, seniority in step, and duration).

OR

b) in case the eligibility, qualification and professional experience requirements for the grade indicated in this external vacancy notice, (AST4) are met, to be assigned to the post on the basis of a new contract (first fixed-term) of three years duration, subject to the probationary period of 9 months, at the grade indicated in the external vacancy notice (AST4).

Application process

The recruitment process will include a panel interview and a written test. In addition, there may be a pre-screening exercise, a presentation to be delivered by the candidate and a bilateral interview.

(2) Motivation Letter of no more than one page, explaining why you are interested in the post and what would be your added value you would bring to EIOPA if selected.

Applicants will be assessed on the basis of the eligibility and selection criteria specified in the vacancy notice and these must be met by the closing date of the vacancy notice.

Applications should be submitted to recruitment@eiopa.europa.eu, specifying in the subject the reference number above. Deadline for application is23:59 CET on 15 January 2017.

The successful candidate will be required to make an annual declaration in respect of any interests which might be considered prejudicial to his/her independence. Before recruiting a member of staff, EIOPA’s Executive Director will examine whether the successful candidate has any personal interest which may impair his/her independence or any other conflict of interest. To that end, the successful candidate, using a specific form, shall inform the Executive Director via the Ethics Officer of any actual or potential conflict of interest.

For more information on the selection process of temporary agents and on the contractual and working conditions, please, refer to:

[1] Prior to the appointment, the successful candidate will be asked to provide a Police certificate confirming the absence of any criminal record.

[2] Before being engaged, a candidate shall be medically examined by one of the institution’s medical officers in order that the institution may be satisfied that he fulfils the requirements of Article 12 (2)(d) of the Conditions of Employment of Other Servants of the European Communities.

[4] The basic salary is to be weighted by the current correction coefficient for Germany.

[5] An estimation of net salary, including the deduction for tax and social security and adding the allowances (this estimation has been calculated with expatriation allowance, household allowance and with one dependent child allowance). Allowances depend in any case on the personal situation of the candidate.