Simple and modern data management for risk reports
As a specialist in commercial real estate financing, Deutsche Hypo is one of the most traditional and renowned Pfandbrief banks in Germany. In 1872, the company was founded by Berlin merchants and bankers as Deutsche Hypothekenbank.
Due to new requirements of the banking supervisory authority with regard to risk reporting (BCBS 239), banks have to optimise some of their processes. The Basel Committee on Banking Supervision (BCBS) Rule 239 requires “principles for the effective aggregation of risk data and risk reporting”. With this new implementation, banks should be able to evaluate risk data in a high quality, timely and flexible manner.
Data Vault 2.0
With Data Vault 2.0 as a modern data modelling procedure, Deutsche Hypo set itself the goal of achieving stable, high-performance data management processes, data control and evaluability. The first step towards this goal was the expansion of the integrated data warehouse according to Data Vault 2.0. In addition, the evaluation layer was realised with the integration tool Talend DI and database know-how. The implementation was carried out according to modern agile project management procedures based on SCRUM.
By combining the mechanisms according to Data Vault 2.0 and the bank-specific requirements for process automation, a well-integrated BI solution was created. The continuous expansion of the data warehouse and the automation of data quality checks become a challenge and a solution at the same time.
Why cimt ag?
In addition to the core task of expanding the DWH, automations of data quality checks could also be implemented. “cimt ag supports our data warehouse strategy with ETL best practices, in-depth Data Vault knowledge, with pragmatic SQL solutions and, most recently, with Tableau expertise,” continues Dr Carsten Steinhoff.
OIiver Fromm, Partner & Authorised Signatory of cimt ag adds: “Deutsche Hypothekenbank is a customer with exciting challenges, modern and therefore very attractive toolstack in the area of Business Intelligence & Data Warehouse and a great team spirit”.
The flexible adaptability and maintenance through the graphic-oriented ETL job design played the decisive role for the use of Talend DI. “As the data history grew, we were also confronted with new challenges in terms of performant evaluability, which we successfully met with the combination of Talend DI and modern architecture patterns,” says Steinhoff.
You would like to learn more?