Snowflake: the engine powering Optio’s Data Warehouse (ODIN)

Creating a platform agnostic Data Warehouse has been an important project for Optio.  Partnering with sector experts, and forming our own Business Intelligence team has been instrumental in the design and execution of our data warehouse.  In order to create the data lake, we needed to partner with a best-in-class provider and we chose Snowflake.  That decision underpins the architecture and build of our data warehouse, something that is already providing valuable insight as well as automating inefficient processes.

The Snowflake Cloud Data Platform shatters the barriers that prevent organisations from unleashing the true value from their data. Thousands of customers deploy Snowflake to advance their businesses beyond what was once possible by deriving all the insights from all their data by all their business users. Snowflake equips organisations with a single, integrated platform that offers the only data warehouse built for any cloud; instant, secure, and governed access to their entire network of data; and a core architecture to enable many other types of data workloads, including a single platform for developing modern data applications.

Snowflake is a single platform comprised of storage, compute, and services layers that are logically integrated but scale infinitely and independent from one another.

Snowflake combines and stores data from multiple sources. Combining this data, in conjunction with a business-defined glossary, allows the data-warehouse to deliver a “single source of the truth”, ensuring that business teams have clear and consistent reporting.

At Optio, we used the cloud-hosted product, Matillion, for ingesting and transforming data from their in-house underwriting platform and external 3rd party platforms. Snowflake underpins the Tableau reporting suite and in conjunction with Matillion, supporting external intra-day SharePoint reporting schedules.

Working with industry experts is always key to success and last year we collaborated with Interworks, to drive forward the design and build of the data-warehouse architecture.

"By introducing the combination and storage of data from multiple sources via Snowflake and cloud hosting capabilities by Matillion, we were able to create our vision of a group-wide, real-time, and innovative data warehouse"