Bacancy Technology
32 Case Studies
A Bacancy Technology Case Study
A US retail and commercial bank faced significant data challenges, including fraud teams relying on day-old transaction data due to a slow overnight ETL process on SQL Server, undocumented pipelines, and an inability to trace regulatory figures to their source. To overcome these issues, the bank partnered with Bacancy Technology for a modernization project involving a migration to the Snowflake data platform.
Bacancy Technology implemented a solution that migrated the bank's data warehouse to Snowflake, introduced streaming ingestion for real-time data, and rebuilt the ETL processes using dbt for transformation and Snowpark for in-database fraud model scoring. The results were transformative: transaction data was delivered to fraud teams within seconds instead of 24 hours, ETL running costs were reduced by 75%, fraud model scoring became 60% faster, and regulatory figures became 100% traceable to source data.
a US retail and commercial bank