What is done by the jobholder + to what or whom + with what expected outcome / results
Ensure that the enterprise data warehouse is in line with the IT policies and that qualitative and quantitative objectives are achieved and define a unified approach for developing ETL data quality jobs within the enterprise data warehouse;
Participate in the EIB Group definition of data quality principles, policies, and the application of industry best practices;
Assist the Data Governance unit in implementing policies and documenting process flows using data quality functionalities of IBM Infosphere Datastage and quality stage;
Organise, structure and lead complex business requirement analysis; producing business cases to propose the best possible IT solution while remaining cost effective for the EIB;
Lead IT projects under own responsibility and ensuring their delivery within the planned time, scope and budget by anticipating issues and taking mitigation actions;
Write up the project documentation such as project charter, functional design, test scripts, progress report, reviewing all technical deliverables to meet data warehouse objectives;
Build and maintain ETL jobs according to best practices and establish metrics to monitor data extraction improvements;
Apply technical knowledge and expertise to define, test, implement and maintain data extractions in line with requirements and in cooperation with reporting officers, data officers, data owners, source system and data warehouse IT custodians;
Provide timely support services to end-users, which includes issues resolution, root cause analysis, propose and development improvements;
Provide expert advice and recommendations and participate on issues related to data warehouse activities with focus on data extraction improvements and associated processes in order to align the EIB Group with best practice;
Participate in special initiatives that can go beyond the strict boundaries of own domain and that have a specific scope and timing, in order to ensure the realisation of the initiative within the set scope, time and budget.
Nature and scope
Structure and reporting of the post, important features of the job in terms of challenges and complexity S / he will design, develop and optimise data extractions based on the input from reporting officers, Data Governance Unit and business stakeholders.
Additionally, s / he will monitor and communicate on the performance of the Data Warehouse, and provide end-user support to deliver reliable and accurate information.
Minimum qualifications, experience, knowledge & skills
University degree in Information Technology, Mathematics, Finance or related fields
Minimum of five years’ professional experience covering data extraction management, ideally gained within the data warehouse field in the financial services sector and in an international context.
Key technical / professional knowledge and skills
Excellent knowledge of project management principles, methods and practices.
Strong technical knowledge of ETL tools (such as IBM Infosphere Datastage and quality stage, Talend, Informatica) and SAP Business Objects Suite or equivalent reporting tools
Experience with creating, testing and implementing business rules for feeding an enterprise data warehouse
Experience with establishing data extraction performance metrics and preventative controls for continuous improvement
Proven track record of data extraction improvement and result orientation
Good knowledge of database management systems (Sybase ASE & IQ, Oracle)
Fluent in English or French, and a good working knowledge of the other
Working relationships that the job has with other parties inside and outside the Bank
Internal contacts : S / he reports to the Head of Data Warehouse & Reporting Unit and works in close cooperation with IT and the Data Governance Unit.
S / he will cooperate with counterparties from all directorates using the data warehouse.
External contacts : S / he deals on a daily basis with key external parties (software vendors, providers of outsourced services, peer groups) in order to optimise service levels and to stay abreast of best practice
Achievement Drive 3. Sets challenging goals
Change Orientation 3. Tries new ways to do things
Collaboration 3. Values others' input
Organisational Commitment 3. Supports the organisation