Research Analysts, Frankfurt
Organization: European Central Bank (ECB)
City: Frankfurt, Germany
Office: ECB Frankfurt
Closing date: Tuesday, 27 October 2020
You will be part of the Directorate General Statistics, working in one of three teams in either the Master and Metadata Section of the Analytical Credit and Master Data Division or the Securities Data Section of the Securities and Financial Markets Data Division. I. The Master and Metadata Section has 16 members of staff working in two teams: The RIAD team uses entity master data management to provide the European Central Bank (ECB) and the European System of Central Banks (ESCB) with master data and reference information about all of the counterparties involved in financial transactions via the Register of Institutions and Affiliates Data (RIAD). The SDD/BIRD team uses a harmonised metadata model and taxonomy to support (a) the integration of various ECB data sources throughout the ECB and ESCB and (b) the harmonisation and reduction of the reporting burden on banks. To achieve these objectives, the team develops and maintains the ECB’s Single Data Dictionary (SDD), which provides a comprehensive description of the various datasets available at the ECB, the Banks‘ Integrated Reporting Dictionary (BIRD), which was created to offer reporting banks a harmonised data model for extracting the data necessary for reporting statistical and supervisory information, and the ESCB’s Integrated Reporting Framework (IReF), which is intended to integrate, as far as possible, existing ESCB statistical data requirements for banks into a single framework. II. The Securities Data Section has 18 members of staff working in a single team: The Securities Data Section is responsible for maintaining the Centralised Securities Database (CSDB) and the Securities Holdings Statistics Database (SHS), which are large and complex micro data databases containing reference and price data on individual securities from issuance and holding perspectives, respectively, as well as ratings data on securities and issuers. You will work on scoping, developing and testing the development of the two databases. These databases are operated across several countries together with national central banks (NCBs). Hence working with these databases involves cooperating with other authorities and with organisations that provide and use the micro data. Key challenges include standardising underlying methodologies and automating data processing, including statistical analysis and quality assurance. The ECB is an inclusive employer and we strive to reflect the diversity of the population we serve. We encourage you to apply, irrespective of your gender, gender identity, ethnicity, sexual orientation, age, religion, disability or other characteristics.
As a Research Analyst in the RIAD team you will:
coordinate the RIAD operational tasks to ensure the smooth support of users and connected client systems;
maintain existing databases and information sources by gathering entity master data and relationships, also ensuring that international standards are properly reflected in RIAD;
contribute to RIAD data quality by identifying areas for improvement and following them up with NCBs and other stakeholders;
perform data analyses, draft documents, and provide presentations to the RIAD Hub Network, other ESCB committees and external stakeholders;
support users to facilitate effective data retrieval and knowledge-sharing within the ECB, NCBs and other institutions providing master data;
improve the master dataset and applications by developing and testing system capabilities and analytical tools, as well as identifying and resolving issues;
establish and maintain effective relationships with RIAD system providers to improve the stability of the system and contribute to the prompt resolution of incidents and to the identification of their root causes;
support methodological developments in coordination with NCBs and other RIAD stakeholders;
prepare notes and presentations and contribute to external dossiers.
The position offers you excellent opportunities to contribute to the operation and maintenance of RIAD and to shape its future development, designing new tools to verify and enhance data quality and employing machine learning techniques. As a Research Analyst in the SDD/BIRD team you will:
develop and maintain the SDD by providing thorough assessments of new metadata requirements, by supporting ECB business areas engaged with production of statistical data and by contributing to data quality assessment processes;
develop and maintain BIRD together with the banking industry by providing technical support and business inputs;
collaborate with NCBs, other European authorities and commercial banks on the development of activities related to BIRD;
contribute from the business side to the development of in-house IT solutions and/or develop and maintain internal IT tools for the maintenance of the above-mentioned dictionaries;
contribute to the preparation of the material for internal and external meetings on, for example, data management integration and banks‘ integrated reporting;
support the activities and projects of the Division aimed at promoting data management integration within the ECB and establish effective relationships with internal stakeholders.
The position offers you excellent opportunities to contribute to ongoing activities at European level aimed at the integration of datasets and the harmonisation of banks‘ reporting and to cooperate closely with European authorities and the banking industry. As a Research Analyst in the Securities Data Section you will:
contribute to the management of large-scale data and the development of related IT systems;
work on scoping, developing, testing and operating the CSDB and the SHS;
contribute to other work, mostly related to managing large-scale data and developing related IT systems;
support the development and maintenance of the respective statistical data systems to increase capacity, improve performance and enhance automation, which includes scoping, prototyping and testing new application releases;
document database algorithms and dataflows end-to-end and from a business perspective;
take care of the day-to-day management, receipt, processing and quality checking of statistical micro data, and compile and disseminate the results;
Tags banking central banks data collection data management data modelling data processing data quality hadoop monetary policy press releases python risk management statistical data
mine existing data and foster the efficient generation of new statistical output products by linking, filtering and enriching existing data to serve user needs at short notice, including using quantitative statistical methods to exploit, for example, less structured ad hoc data;
participate in the regular production and compilation of the daily, monthly and quarterly products of the Centralised Securities Database (CSDB), Securities Holdings Statistics (SHS) and Securities Issues Statistics (SEC) including the preparation of press releases when publishing data to the public;
support the further standardisation and integration of different statistical systems;
design and develop new statistical frameworks and datasets with other members of the Directorate General and other ECB business areas, ECB users, NCBs, national competent authorities (e.g. banking supervisors), Eurostat and other stakeholders;
prepare notes for the meetings of the ESCB Statistics Committee and its working groups, and support other members of the Directorate General in the preparation of press releases and briefing material for members of the Executive Board, the Supervisory Board and the Governing Council.
The position offers you excellent opportunities to contribute to the on-going operation and development of the CSDB and SHSDB systems. You will also be involved in pioneering the compilation of macro statistics using granular micro data -‘ a new type of statistical product that will pave the way for the future of statistics in technical, operational and methodological terms. Given the broad range of users, you will also have multiple interactions with several business areas within the ECB, including market operations, risk management, monetary policy or the banking supervision areas. You will be part of a multicultural team that strives for continuous innovation to make a positive impact on the lives of European citizens.
Please note that as part of a system change over process we tentatively expect to take the recruitment system offline as of Friday morning 16 October until early on Tuesday 20 October. Please therefore use the time available prior to this system downtime (or if applicable, thereafter too, depending on the publication close date) to complete your application. Some of the contracts will be convertible into permanent contracts after three years subject to individual performance and organisational needs. For additional information on these specific vacancies, you can speak to the hiring manager, Hansjakob Schlaich, on +49 (0)69 1344 8747. The recruitment process for this position may include a pre-recorded video interview in the pre-selection phase and -‘ if you are invited to participate in the subsequent selection phase -‘ a written exercise and interviews.
a bachelor’s degree or equivalent in statistics, economics, mathematics, physics, engineering or another relevant field (for details on degree equivalences, https://www.ecb.europa.eu/careers/before-you-apply/html/index.en.html);
sound analytical and quantitative skills and the ability to define, apply and automate data concepts, procedures and methodologies;
an ability to explain complex technical issues in simple, non-technical language to different stakeholders, and draft appropriate documentation, also with the aim of encouraging and motivating less technical colleagues to get involved in the world of large-scale micro data;
strong programming skills and knowledge of SQL;
an advanced (C1) command of English and an intermediate (B1) command of at least one other official language of the EU, according to the Common European Framework of Reference for Languages, https://www.coe.int/en/web/common-european-framework-reference-languages/table-1-cefr-3.3-common-reference-levels-global-scale.
Desired for the RIAD and SDD/BIRD teams and Securities Data Section:
skills in one or several of the following programming languages: R, RShiny, Python, SAS language;
experience in using statistical or econometric tools for micro data, preferably RStudio, RConnect, Anaconda, and Business Objects;
experience with relational databases.
Desired for the RIAD team and Securities Data Section:
knowledge of international and European statistical standards (e.g. ESA 2010 and LEI);
experience of working with large-scale and complex granular datasets;
experience in the areas of developing data quality assessment tools or processing and analysing reference data and/or financial data;
a good understanding of the different institutions and other data sources involved in the compilation of RIAD, CSDB and SHS datasets and their respective main responsibilities;
an understanding of the institutional and legal framework governing the collection, production and dissemination of master data;
a broad understanding of database technologies (i.e. classical RDBMS, Hadoop ecosystem) and data modelling strategies to contribute to discussions with the IT function with the aim of enhancing the operation of the large micro data systems.
Desired for the SDD/BIRD team:
knowledge of data collection, preparation and processing and/or metadata management for statistical or supervisory purposes;
experience with information models, data modelling (e.g. entity relationship models), and data dictionary definitions and methodologies, such as SDMX, DPM and/or XBRL;
a strong conceptual and theoretical background in developing new metadata concepts;
good communication and drafting skills (for technical documentation) and experience in collaborating with multiple parties, e.g. IT counterparts on development work, and other international organisations.
You engage collaboratively with others. You pursue team goals and learn willingly from other people’s diverse perspectives. You signal any need for change by explaining it and proposing alternative solutions. You analyse complex information effectively and can evaluate different views to arrive at solutions. You know and anticipate stakeholder needs.
We are willing to discuss part-time arrangements.
Applications are to be made in English and submitted using our online application form. An ‚Applicants‘ Guide‘ can be downloaded from our recruitment pages.
The recruitment process may include a pre-screening exercise, a written exercise, a presentation and interviews.
Further information on the ECB’s conditions of employment for fixed-term positions can be found at https://www.ecb.europa.eu/careers/what-we-offer/contract/fixed/html/index.en.html
Applications are accepted from nationals of Member States of the European Union.
The requirements laid down in the vacancy notice must be met by the closing date for applications.
This vacancy notice may be used to fill the same position again, or similar positions, within 12 months of the selection decision.