Data Warehouse Officer

The EIB, the European Union's bank, is seeking to recruit for its Corporate Services Directorate (CS) – Information Technology Department (IT) – Risk, Data and Integration Division (RDI) - Data Warehouse and Reporting Unit at its headquarters in Luxembourg, a:

Data Warehouse Officer

Appointment will be made on the basis of a fixed term contract of 4 years   

The EIB offers fixed-term contracts of up to a maximum of 6 years, according to business needs, with a possibility to convert to a permanent contract subject to organisational requirements and individual performance

Purpose

The Data Warehouse Officer will design, develop, and optimise the Enterprise Data Warehouse to assist business users in their reporting needs. Additionally, s/he will monitor the Data Warehouse environments and provide end-user support to deliver reliable and accurate information.

The Data Warehouse Officer has responsibility for managing IT projects with a broad impact on business activities.

 

Specific Post Environment and Operating Network

The Data Warehouse Officer provides expert level analysis to model the databases, develop the ETL (Extract, Transform, Load) jobs and build the end-user reports according to standards and industry best practices.

The job holder will report directly to the Head of Data Warehouse & Reporting Unit and work in close cooperation with all IT Units. Internally, h/she will deal with Management and representatives of the Directorates using the Data Warehouse and other IT Units. Externally, h/she will deal with external suppliers of software and/or software-related services and external consultants.

Accountabilities

The Data Warehouse Officer will be responsible for:

  • Ensuring that IT policies and initiatives in the Data Warehouse fields are implemented and key reporting needs are handled in the most effective and efficient way, this may include:
  • Defining a unified approach for organising and representing data within the Enterprise Data Warehouse
  • Participating in the global definition of information architecture principles, policies, and the application of industry best practices
  • Supporting the Data Governance Office in implementing policies and documenting process flows
  • Taking project management responsibilities for assigned Data Warehouse projects; ensuring the completion of projects within set time, budget and quality objectives
  • Ensuring the maintenance of the Enterprise Data Warehouse platform, either directly or through the assistance of consultants
  • Coordinating and supervising an external IT team so as to ensure the delivery of expected Business Intelligence solutions to internal business customers
  • Providing specific advice and recommendations in the Data Warehouse field in order to ensure that reporting solutions are conceived, built and managed in line with EIB requirements and EIB/IT standards and methodologies

Qualifications

  • University degree preferably in computer science or related disciplines
  • At least 3 years of experience in the design, development, and maintenance of a data warehouse in  a financial environment
  • Strong technical knowledge of parallel development using IBM Infosphere Datastage Enterprise (8.7 and higher versions)
  • Strong technical knowledge of SAP Business Objects Suite (XI 4.x)
  • Good knowledge of database management systems (Sybase ASE & IQ, Oracle)
  • Good understanding of the Bank’s business activities including operational processes and procedures in place in the various services of the EIB
  • Significant experience in Data Warehouse modelling and methodologies
  • Very good knowledge of project management principles, methods and practices
  • Fluent in English or French (*) and a solid understanding of the other

Competencies

  • Excellent oral and written communication skills at all levels in a multicultural environment
  • Strong capacity to think in technical and business terms with a focus on both technical issues and business processes
  • Sense of responsibility with regard to taking ownership of initiatives and following them through to completion
  • Strong capacity to plan and to anticipate potential issues
  • Strong capacity to analyse and synthesize complex problems
  • Pragmatic approach to problem solving

 

 (*) There may be certain flexibility on this requirement, but limited to particularly suitable candidates who may not yet be proficient in French. If selected, such candidates will be hired on the condition that they build up rapidly knowledge of French and accept that their future career in the EIB may be subject to the attainment of sufficient proficiency in both of the Bank's working languages

We believe that Diversity is good for our people and our business. We promote and value diversity and inclusion among our staff and candidates; irrespective of their gender, age, nationality, race, culture, education and experience, religious beliefs, sexual orientation or disability.

Deadline for applications: 19th May 2015

 

 (NB. Applicants, please note that you will receive an email acknowledgement confirming reception of your application, once duly submitted)