Insurance · A leading European insurer
A governed lakehouse for an insurer's claims and pricing data
The insurer's analytics ran on an ageing warehouse and a set of unmanaged data lakes with no lineage. NuxFamily delivered a single on-premises lakehouse with a catalogue, lineage and access control that satisfied the internal audit function.
100 %
Of regulated reports with end-to-end lineage in the catalogue
6×
Faster actuarial model runs compared with the legacy warehouse
0
Reports lost or rewritten during the transition
The challenge
The challenge
Claims, policy and pricing data lived in a legacy data warehouse that could no longer scale, plus several departmental data lakes built on object storage without a catalogue. Actuarial models depended on manual extracts, and nobody could answer with confidence where a given figure had come from.
Internal audit and the data protection office required lineage, role-based access at column level and a retention policy that could actually be enforced. The insurer also wanted the platform on-premises for cost and data-residency reasons.
The migration had to preserve existing reports and models during the transition. Analysts would not accept a period without their dashboards.
The architecture
The architecture
The warehouse layer is Greenplum, later moved to Apache Cloudberry, deployed as a multi-segment cluster on bare metal with mirrored segments for availability. It holds the curated, modelled data used by actuarial and finance teams and answers the existing reporting workload with no query rewrites.
Raw and semi-structured data lands in S3-compatible object storage as Apache Iceberg tables. Iceberg gives schema evolution, time travel and snapshot isolation, and it lets the warehouse and Spark-based pipelines read the same tables without copies.
OpenMetadata provides the catalogue, column-level lineage from source systems through pipelines to dashboards, data quality tests and the ownership model the audit function asked for. Access policies are defined once in the catalogue and enforced in the query engines.
OpenSearch indexes claims documents and pipeline logs for search and operational monitoring. The whole platform runs on Kubernetes for the service components and on dedicated nodes for the database engines, with backups and disaster recovery tested quarterly.
Technologies
- Greenplum
- Apache Cloudberry
- Apache Iceberg
- OpenMetadata
- OpenSearch
- Apache Spark
- Kubernetes
“For the first time we could show the auditors where a number came from, step by step, without a spreadsheet.”
Related platform families
Related platform families
- Flagship
NuxData Intelligence
The complete data platform your regulator can audit and your data scientists actually want to use.
- Apache Iceberg
- Apache Cloudberry
- Apache Kafka
- Apache Spark
- OpenSearch
- OpenMetadata
Analytics & Data Warehouse
Enterprise-grade MPP analytics, on-prem in Nigeria, with no cost per query.
- Apache Cloudberry
- Greenplum
- Apache Spark
- Apache Iceberg
- Apache Hadoop
Search & Text Analytics
Search and observability without sending a single log outside Nigeria.
- OpenSearch
- Apache Solr
- OpenSearch Dashboards
- Data Prepper
Data Governance & Storage
Proving compliance starts with knowing where every datum lives.
- OpenMetadata
- MinIO
- Ceph
- Hadoop / HDFS
All case studies
All case studies
Banking
Moving a retail bank's core workloads from public cloud to a private cloud, without downtime
A top-5 Spanish retail bank
The bank needed to bring several hundred workloads back from a hyperscaler into its own data centres under a regulatory deadline. NuxFamily designed the target platform, ran the migration in waves and handed over operations to the bank's team.
Read the case0
Minutes of unplanned downtime across nine migration waves
−38 %
Infrastructure run cost versus the public-cloud baseline
7 months
From platform build to final cut-over, ahead of the deadline
Retail & distribution
A multi-region Kubernetes and PaaS platform for a global fashion retailer
A global fashion retailer headquartered in Spain
The retailer needed a single application platform for hundreds of development teams across regions, with on-premises control and a cloud-like developer experience. NuxFamily built it on VMware Tanzu and Cloud Foundry and operated it through peak trading seasons.
Read the case< 15 min
From code push to a routed production deployment
3
Regions served from one platform with consistent standards
99.98 %
Platform availability across peak trading periods
Your institution could be the next case
Tell us about your platform and regulatory timeline; we will show you which of these patterns applies.