PURPOSE: - The Data Warehouse Officer will design, develop, and optimise the Enterprise Data Warehouse to assist business users in their reporting needs related to the European Fund for Strategic Investments (EFSI) implementation. 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. OPERATING NETWORK AND SPECIFIC POST ENVIRONMENT: 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 the Data Warehouse & Reporting Unit and work in close cooperation with all IT Units. Internally, s/he will deal with Management and representatives of the Directorates using the Data Warehouse, particularly the ones in charge of EFSI/Mandate Monitoring and Reporting and other IT Units. Externally, s/he 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 EFSI /Mandate data within the Enterprise Data Warehouse; . Participating in the global definition of information architecture principles, policies, and the application of industry best practices; . Assisting 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 with the assistance of consultants. - Functioning, where required, as a central coordination to ensure the delivery of expected Business Intelligence solutions on EFSI/Mandate obligations. - 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 EFSI/Mandate requirements and EIB/IT standards and methodologies.