Dr. Wechsler & Partner is a specialist firm for occupational pensions, pension fund administration and expert mandates. To analyse and evaluate pension-fund-relevant data, the company needed a modern data platform that makes information from the SwissPension 6 core system available in a structured form.
CONSENSO TECH developed a data warehouse based on an open source stack. Apache NiFi handles data extraction and processing from SwissPension 6. The data is structured in a central Postgres database and complemented by MinIO as S3-compatible storage. Power BI serves as the reporting and visualisation layer.
The focus is on pension-fund-relevant data such as people, contracts, pension information and financial metrics. The new platform allows this data to be analysed more consistently and used for both operational and management-oriented reports.