Case Study: an EU-based insurer cuts overnight batch time by 55% with Bacancy Technology's Microsoft Fabric migration

A Bacancy Technology Case Study

Legacy SSIS to Microsoft Fabric Data Migration for an EU Insurer

The client, an EU-based insurer, faced significant reporting delays due to an overburdened legacy system. Their overnight SSIS packages running on an on-premises SQL Server could not keep up with growing data volumes, causing reports to arrive a day late and lacking the lineage required for GDPR compliance. Bacancy Technology was engaged to perform a data migration and modernization.

Bacancy Technology rebuilt 94 legacy SSIS packages as pipelines in Microsoft Fabric Data Factory, consolidating five source types into OneLake. The solution included implementing medallion architecture for data validation and Microsoft Purview for governance and lineage. This migration cut overnight processing time by approximately 55%, reduced manual reconciliation effort by 70%, and slashed report refresh latency from 1 second to 200 milliseconds.


View this case study…

Bacancy Technology

32 Case Studies