Retour à la liste

Data Warehouse Analysts and (Senior) Officers H/F

Le 26 avril

Critères de l'offre

  • Basse-Normandie
  • CDD
  • Temps Plein
  • Domaines d'expertise : Microsoft network , Scope , Structuring , Financial , Data Governance Voir plus , Support , Quantitative , Sybase Ase , Informatica , Datawarehousing , IT solutions , Budget , Deliverables , Maintenance , Data Models , CRD IV , Business reporting , Orientation , Documentation , CRR , Design , Supervision , Parts , Procurement , Compliance , Delivery , Information Technology , Ibm , PROGRESS , Functional design , Business case , Conduite de projet , Risk management , Approach , Industry , Determination , Writing , Cooperation , Software , Requirement Analysis , Flexible , REACh , Database management , Changes , Operational Processes , ETL , Datastage Voir moins
  • Niveau d'études : > BAC+5 , Bac+5 , Bac+5, Master - Magistère , Bac. Général

Description du poste

Purpose

The Data Warehouse Officers will maintain and further develop the Enterprise Data Warehouse. They will work on the redesign of the existing solution in order for it to become fully aligned with the latest industry standards .

Position #1: As a Data Warehouse Technical Coordinator (senior position, internally referred as "(Senior) Officer IT Applications") you will be responsible for maintaining and further developing the Enterprise Data Warehouse. You will also align the Data Warehouse architecture, governance and developments to the latest banking regulations standards: BCBS239, CRD IV and CRR. The position entails mentoring and providing technical expertise advice to project team members
Position #2: As a Data Warehouse Solution Designer (associate position, internally referred as "Analyst/Officer IT Applications") you will be defining and organizing EIB data within the Enterprise Data Warehouse. You will be accountable for the alignment of the model with the highest banking standards and will ensure its implementation in cooperation with the development team.
Position #3: As an ETL Specialist (associate position, internally referred as "Analyst/Officer IT Applications") you will be designing, developing, optimizing and maintaining the ETL extractions. You will work on the redesign of the existing solution and be accountable of the alignment between ETL developments, latest industry and banking regulation standards.

Operating network

You will report directly to the Head of the Data Warehouse & Reporting Unit and whenever required directly to the Head of the Risk Management and Best Banking Practice Division.

Externally, you will deal regularly with key external parties (software vendors, providers of outsourced services, peer groups) in order to optimise service levels and to stay abreast of industry standards - Internally, you will cooperate with counterparties from all directorates using the Data Warehouse.

Accountabilities

The Data Warehouse Analysts / (Senior) Officers will be responsible for:

Organising, structuring and leading complex business requirement analysis; producing business cases to propose the best possible IT solution while remaining cost effective for the Bank
Leading IT projects under own responsibility and ensuring their delivery within the planned time, scope and budget by anticipating issues and taking mitigation actions
Building and maintaining ETL jobs / data models according to industry standards. Providing timely support services to end-users, which includes issues resolution, system performance improvements and qualified advice
Writing up the project documentation such as project charter, functional design, test scripts, progress report; reviewing all technical deliverables to meet qualitative objectives
Coordinating internal and external resources and handling the related procurement aspects
Reporting accurate, meaningful and timely project status to all involved parties, raising issues as necessary
Ensuring that the Enterprise Data Warehouse is in line with the IT policies and that qualitative and quantitative objectives are achieved

Specific for post #1

Evaluating the effectiveness of the Data Warehouse designs and developments with regards to banking regulation standards and taking the necessary corrective actions.

Specific for post #2

Maintaining the documentation of the Data Warehouse physical data model
Building and maintaining KPI's to measure our degree of compliance with regards to banking regulation standards.

Qualifications

University degree in Information Technology or related fields
At least 3 years of experience in the design, development and maintenance of a Data Warehouse in a financial environment
Excellent knowledge of project management principles, methods and practices
Good technical knowledge of ETL tools (such as IBM Infosphere Datastage, Oracle ODB, Informatica) and SAP Business Objects Suite or equivalent reporting tools
Good knowledge of database management systems (Sybase ASE & IQ, Oracle)
Knowledge of the Bank's business activities including operational processes and procedures in place in the various services of the EIB would be beneficial.
Excellent knowledge of English and French(*), with a good knowledge of the other.

Specific for position #1

At least 5 years of experience in the design, development, and maintenance of a data warehouse in a financial environment
Demonstrable experience in implementing data governance policies and banking regulation standards.
Experience in the supervision of development teams

Specific for position #2

Demonstrable experience in the design of financial data models
Deep understanding of financial instruments

EIB core competencies

Achievement Drive: Continually keeps an eye on performance, focusing on improving it, showing drive and determination to meet short and long-term goals
Change Orientation: Adapts to differences and changes in the environment; takes a flexible approach to reach outcomes
Collaboration: Works cooperatively as part of a team; works collaboratively with peers across organisational boundaries based on a genuine interest in and an accurate understanding of others and their individual perspectives and concerns
Organisational Commitment: Is willing to commit to an organisation whose mission is to support Europe and is open to diversity, and to align her/his own behaviour with the organisation's needs and intrinsic values, acting with integrity in ways that promote the organisation's mission, policies and rules.

Référence : 6336