Solving Privacy, Security and Auditability Issues for a Ban…

INTRODUCTION One of our clients, who mainly had problems with the implementation of privacy, security and auditability in the data warehouse, is a large financial service provider from Germany. As a bank, they are diversified and offer both b2b and b2c products. CASE DESCRIPTION As a financial services provider, the company collects and processes a large volume of data and must protect it properly, given compliance requirements in this sector. However, the existing data warehouse did not allow the company to comply with today’s standards in Data Warehousing. In particular, the implementation of privacy, security, auditability and the new master data manage- ment caused the customer major problems in the existing data warehouse. This led to major challenges for the management to solve, which could have led to a cost explosions and worse if ignored:

● Privacy (GDPR, AML etc.) - legal consequences and loss of customer trust ● Security - high costs after disaster and loss of customer trust ● Auditability - lack of traceability and data quality problems ● Lack of master data management - data quality issues

Due to this, the client wanted to build a new data warehouse and needed a suitable solution to these problems. After extensive research and comparison of the possible solutions on the market, it be- came clear to the customer that Data Vault 2.0 provides solutions for these typical problems and can be implemented through Data Warehouse Automation. Therefore, the customer decided to rebuild their BI landscape using Data Vault 2.0 and WhereScape. A rough overview of the architecture can be seen in Figure 1. In addition, the customer uses the following TechStack for implementat

● Microsoft SQL Server ● WhereScape 3D & RED

● Azure DevOps ● Microsoft Power BI

2/3