We recently partnered with a financial sector client in Australia and New Zealand to transform their outdated, on-premises SQL Server VM-based analytics platform into a scalable, cloud-based solution. Built on Snowflake and Data Vault 2.0, the new platform enhanced scalability, improved data quality, and unlocked greater business value, setting the client up for future growth and seamless integration. 

In this video, our Practice Manager Steve Rose discusses this case study in detail. Watch the video or scroll down for a summary of the key points.

The objectives 

Our primary objectives for this project were: 

• Modernise the outdated, on-premises analytics platform. 

• Simplify the data architecture to eliminate unnecessary complexity. 

• Enhance data quality and scalability to meet evolving business needs. 

• Establish a cloud-based, future-proofed platform with Snowflake and Data Vault 2.0. 
  

The challenge 

The client's existing platform was bogged down by complexity and legacy architecture. Over the years, it had grown tactically rather than strategically, resulting in low data quality, limited scalability, and a platform that could no longer meet the business's evolving needs. 

The solution 

We took a structured, phased approach: 

1. Core Infrastructure Setup – Establishing a solid foundation in the cloud.  
2. Data Migration – Moving existing data from on-premises to the new Snowflake-powered environment. 
3. Value Driven Delivery – Implement a value driven approach to deliver business use cases and demonstrate immediate value. 

To optimise the platform, we leveraged our Launchpad solution—a templated, metadata-driven framework that accelerates data ingestion and automation. Key technologies included:  

• Data Lake and Lakehouse architectures for both rapid access to raw data and high-warranty, curated business insights.  

• Continuous Integration and Deployment (CI/CD) for seamless updates.  

• Data Quality Framework to ensure integrity and reliability.  

• Data Vault 2.0 for scalable and adaptable data modelling.  

• IRiS for automated Data Vault code generation (Learn more). 

The impact 

The revamped platform not only addressed the client's legacy issues but also set the stage for future growth. Launchpad enabled faster time-to-value, improved data governance, and the flexibility to scale as business demands evolve. Additionally, the new architecture supported a seamless migration when the client acquired another financial book, demonstrating its versatility and reusability. 

Want to explore how we can help modernise your data platform? Contact us today to learn more.