Duo Security Case Study: Financial Reporting in the Cloud

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.

Their success

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.


Cut financial closure process down from 5-6 days to only minutes


Replaced a massive manual process to automate the ARR calculation process


Daily ARR forecasts (as opposed to monthly) provided to the entire company


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

Employees: 500+

Product: Matillion ETL for Snowflake

Use Case: Data Analytics and Reporting

Website: www.duo.com

The challenge

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.

The solution

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.

The benefits

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.

The results

  • Replaced a massive manual process to automate the ARR calculation process.

  • Cut financial closure process down from 5-6 days to only minutes which was essential.

  • Can now explore data, testing models on the fly with the flexibility provided by Matillion.

  • Daily ARR forecasts (as opposed to monthly) provided to the entire company.

  • Sales better understand the health of their individual customer pipelines and how those relate to the business’ overall financial health.

  • Account and data alignment with Cisco on a daily basis.

  • Following Cisco acquisition, Duo Security quickly met new reporting compliance requirements with Matillion’s shortened development time.

  • Works with data visualization tools including Looker and Tableau.

What’s next?

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.

Begin your data journey

Matillion provides simple, powerful, easy to use data integration and ETL products that enable your company's data journey.