← All case studies
Case studies · Insurance and pensions

When the data stopped working overtime

How Rebtech cut load times in the client's analytics platform by up to half.

The client's own customers could not begin analysing the month's financial data until late in the afternoon. Instead of building a new platform, the life of the existing one was extended, taking the heaviest time sinks first and using a test framework to guarantee an identical result.

About the engagement

Client
Provider of core systems and analytics solutions to the insurance and pensions sector
Industry
Insurance and pensions, software and SaaS
Period
2024 to June 2025
Roles
Project management, BI architect and data engineers
Tech stack
Data Mart, MS SQL Server, multidimensional and tabular cubes, Power BI
Geography
Sweden, with Rebtech's European delivery network
Method
Traditional development
The challenge

Data in time for regulatory reporting

The client's analytics solution delivered, but too slowly. Their customers could not begin analysing the month's financial data until late in the afternoon. On top of that, recurring incidents stopped the loads.

The need was clear: halve the load time and make data available in the morning.

The solution

Extend the life of the platform you already have

Rather than building an entirely new data platform, the client chose to work with Rebtech to extend the life of the existing one. The work was prioritised by benefit relative to effort, so the heaviest time sinks were taken first.

A test framework ensured that every improvement produced exactly the same data result as before, only faster.

Results

From just under twelve hours to a little over five

Load times were cut by up to 55 per cent on the most time-critical data. At one of the first customers, the time-critical load went from just under twelve hours to a little over five.

Customers could start using data considerably earlier at month end, and shorter load times led to fewer incidents. Rebtech led the rollout to all customers and, in June 2025, handed over a quality-assured solution to maintenance.

In brief
  1. 01

    Up to 55 per cent shorter load times on the most time-critical data

  2. 02

    At one of the first customers: from just under twelve hours to a little over five

  3. 03

    Fewer incidents, and a quality-assured solution handed over to maintenance in June 2025

Facing a similar challenge?

Are load times holding the business back?