Driving compliance and operational excellence at Bank Millennium

The client

Our client was Bank Millennium SA, part of a global Millennium group and modern bank, offering its services to all market segments through a network of branches, networks of individual advisors and electronic banking, with 7000+ employees and 3+ million individual clients.  

The company aims to be a modern, digitalized bank, striving to become the most personalized bank in Poland thanks to advanced data solutions and prioritizing making customers’ daily lives more accessible by offering them convenient and intuitive access to financial and non-financial services. 

The challenge

The project was initiated in response to the bank’s growing need for a consistent, centrally managed Data Strategy policy, especially in metadata management. Additionally, there was a need to ensure the highest security standards to fulfil regulatory obligations and that KNF – the body controlling all financial markets in Poland – accepted the project. 

• Distributed information without a common business glossary 

• Ad-hoc reporting of data quality issues without adequate policies 

• Risk of mismatch with banking market regulatory requirements 

The solution

To support bank’s data strategy, we implemented Microsoft Purview as the cornerstone for metadata management, security, and governance. Purview was utilized to catalog data, track lineages, provide a comprehensive data map, enable robust access control, and facilitate automated data discovery and classification. 

The project began with the construction of a metamodel aligned with the physical model. This included the business configuration of vocabulary, defining access levels, and assigning permissions. Leveraging the Workflows feature, we configured processes to:

• Add, edit, or withdraw business concepts.
• Manage timeliness and consistency through concept reviews.
• Synchronize the global and local dictionaries for seamless integration. 

Data integration followed strict compliance with internal and external regulatory standards. Initial data ingestion, provided in XLS/CSV formats, was loaded into the Purview system to ensure a seamless start. 

To empower data stewards, a Power BI dashboard was developed, integrating information from Jira, Purview, and an SQL database. This dashboard offered insights into KPIs such as data ownership, definitions of business concepts, and data quality metrics across various columns, bases, and areas. Users could visualize data lineages, usage, and dependencies, providing a holistic view of the entire data ecosystem. 

Furthermore, the dashboard enabled direct ticket creation in Jira, assigned to relevant business groups, ensuring streamlined communication and issue resolution. 

The final result was a comprehensive reporting tool, allowing users to explore business definitions, track data hierarchies from board members to data owners, and pinpoint low-quality data and the individuals accountable. This significantly enhanced the bank’s ability to manage data quality and governance effectively. 

To reach our goal, we used the following tech stack:   

• Microsoft Purview: main platform for data management and governance, used for classification, metadata management
• Python: automatization and data integration scripts
• Microsoft Azure: a cloud environment that hosts all applications and services related to the project.
• Azure DevOps: continuous integration and Continuous deployment (CI/CD), source code management, and project progress monitoring.
• Terraform: IaC management tool used to create and manage the configuration of the Azure environment.
• Power BI: data visualization