Using Snowflake and Matillion ETL, Duo Security created a single, easily replicable data model for data transformation jobs and reduced its financial reporting process from 5-6 days to only minutes.
With the help of the cloud and Matillion ETL for Snowflake, Duo Security can now develop faster than they ever thought possible in a data warehouse application.
Duo Security combines security expertise with a user-centered philosophy to provide a Unified Access Solution that comprises two-factor authentication, endpoint remediation and secure single sign-on tools for the modern era. It’s so simple and effective; you get the freedom to focus on your mission and leave protecting it to Duo.
Company: Duo Security (part of Cisco)
Location: Michigan, USA
Industry: Computer and Network Security
Product: Matillion ETL for Snowflake
Use Case: Data Analytics and Reporting
Duo Security experienced challenges all companies wish for! They were growing rapidly, quickly outgrowing their infrastructure and making (too much) money which left their finance team overworked and unable to keep up with company financial requirements. With no signs of slowing down, Duo Security needed a scalable financial reporting solution to keep pace with their growth and success. A new ERP would have taken months. A new revenue tool would have been costly and timely to implement. Recruiting and training new accountants may have helped but it would have been a short-term solution to a long-term problem. After weighing options, Duo Security chose to move its financial reporting infrastructure to the cloud, selecting Snowflake and Matillion ETL for Snowflake.
Already a Snowflake customer, Duo Security was able to easily bring its financial data into its existing cloud data warehouse. Selected due to its near-infinite storage and advanced compute capabilities, Snowflake had already become scalable solution helping to support Duo’s data journey. Duo Security, however, still needed a way of taking the pressure off its finance team. In order to relieve pressure here, Matillion ETL for Snowflake helped Duo Security’s finance team transform its financial data into new, cleaner reports. In addition, Matillion ETL for Snowflake helped Duo Security to create a single data model that was easily replicable, enabling Duo to build a number of data transformation jobs to handle different data sources for different business channels.
Snowflake and Matillion ETL together, have enabled every analyst across the organization with a common data platform rather than having to rely on individual system reporting capabilities and having to learn the nuances of each system.Christopher James Data Warehouse Lead (Duo Security)
When Duo Security started this project, they looked to initially serve the Finance and Accounting and Sales teams. With their simple and scalable cloud solutions, they are now able to service Customer Success, Engineering, Security, and Marketing as well, with near real-time financial reporting. This democratizes data and empowers departments across the organization to self-serve and make better decisions based on facts.
Calculating SaaS financials is just one area of the business where Duo Security is leveraging and benefiting from its cloud data solution. Their first project was to analyze recruitment data to streamline their hiring process by understanding which recruiters they should engage for what roles and when so that they could respond to growth patterns. This allowed Duo Security to grow its team in a sustainable and highly-efficient manner. In the future, Duo Security will continue to optimize its operating procedures and reporting across its growing organization to support scalability and efficiency.