Sigma Healthcare has improved its data storage consolidation, access and internal data sharing practices with Snowflake.
Snowflake, the Data Cloud company, has announced it has been chosen by Sigma Healthcare to underpin the company’s strategy to improve its data storage consolidation, access and internal data sharing practices.
As a leading Australian wholesaler and distributor of pharmaceutical products, Sigma is responsible for delivering vital medicines to consumers throughout Australia within 24 hours of orders being placed.
Founded in 1912, the company has more than 1,000 employees and annual revenue for the year ended 31 January 2022 was AU$3.4 billion.
“We had been looking for an alternative to our legacy, on-premise infrastructure that was ageing and no longer able to meet the increasing needs of the company,” said Dean Reynolds, Head of Data and Analytics, Sigma Healthcare. “We were also restricted by the fact that we actually had three data warehouses in use which meant our data was very fragmented and siloed.”
A robust data platform scalable for future growth
The Sigma IT team examined a range of replacement alternatives for its data infrastructure before selecting Snowflake. Key selection criteria included total cost of ownership, required management resources, privacy obligations and the ability to support data sharing and Sigma’s future needs, for example, in the area of advanced analytics.
“Overall, we were looking to simplify our data infrastructure and ensure it could better meet the needs of the business,” Reynolds said. “We quickly determined that Snowflake could readily meet these requirements.”
Reynolds said the fact that Snowflake was designed from the outset for the cloud was an important factor, as was the ability to separate storage from compute resources.
He said: “We could see that Snowflake could also provide us with the opportunity to work with both structured and semi-structured data within the same platform. It’s design also means there is no longer a need for us to undertake indexing, partitioning or compression as that is all handled by the platform.”
The decision to deploy Snowflake was also supported by the ability to operate under a flexible pricing model. This removed the requirement for an initial up-front capital investment as well as the pre-planning normally required and allowed costs to be dialled up and down as requirements change.
Support costs slashed, batch processing reduced to minutes, security reinforced
Working with technology partner Altis Consulting, the Sigma IT team completed the Snowflake deployment during 2021 and the company is rapidly enjoying some significant benefits.
Reynolds said: “Selecting the right implementation partner with deep Snowflake experience and accelerators was critical in us meeting our tight timelines.
“We have been able to reduce our on-going support costs by more than 30% when compared with our previous on-premise infrastructure.
“Also, our batch processing jobs, which used to take between eight and 10 hours to complete now occurs in just under three hours.”
The capability to share data will also deliver benefits to the company. Where appropriate, data can now be much more readily shared with both suppliers and customers, improving efficiency and removing costs.
Sigma is also sharing consolidated and deidentified data with its subsidiary entity company, Nostra Data, to support building better analytics for pharmacies.
The Snowflake platform has also helped Sigma to improve its level of data security. This is an important capability when the company is dealing with large volumes of critical and sensitive healthcare data.
Data access anytime, anywhere for a data-driven tomorrow
With the Snowflake Data Cloud now fully operational, Reynolds said Sigma is looking forward to enjoying additional benefits in the future. Overall, the company’s aim is to empower all internal teams through the democratization of data. This will be achieved by delivering appropriate and tailored data access anytime, anywhere across the company.
“We can see that Snowflake gives us a significant opportunity to further improve our business processes,” he said. “For example, with increased accuracy in demand forecasting, we can drive substantial savings and improvements to our operations.”
Snowflake is supporting Sigma’s strategy to ‘build a data-driven tomorrow’ that supports all staff, partners and customers. Part of this will involve the creation of a dedicated marketplace through which different data sets can be shared within the company as well as with external partners where appropriate.
Reynolds said the company can now truly view its 10 terabytes of data as a valuable asset. This means Sigma can be much more nimble in responding to changing market conditions while also differentiating itself from the competition.
“The bottom line is that we are in the business of saving lives,” Reynolds said. “We need to be able to reliably deliver critical medicine to those who need them within 24 hours regardless of where they are located in the country. Knowing, understanding and being able to access our data is an important resource that helps to make this capability a reality.”
Click below to share this article