Customer Stories / Software & Internet

2024
Deputy

Deputy offers Enterprise-Grade Data Analytics and Increases Reporting Responsiveness by 99% Using Amazon Redshift

Discover how the Australia-based software vendor enhanced its workforce management platform with advanced data analytics, improving performance and data governance to boost customer experience.

99%

faster report generation times from up to 10 minutes, down to 6 seconds

30%

boosted query speed and latency

20x

enhanced performance for largest customers

Enables Self-service enterprise-grade reporting warehouse

allows businesses to generate own reports from a centralized data source

Enhanced data governance

with improved data security using AWS architecture

Overview

Deputy, the global people platform for hourly work, helps businesses automate complex shift work scheduling and attendance tracking. It supports over 355,000 workplaces and 1.4 million shift workers across more than 100 countries.

In 2023, the company embarked on a strategic initiative to modernize its data analytics platform. Working with Amazon Web Services (AWS), Deputy addressed challenges in performance, scalability, and data governance. This transformation provides real-time business insights, optimizing shift scheduling and resource allocation for its customers.

Deputy

Opportunity | Consolidating Databases to Enhance Performance and Data Governance

Deputy aimed to improve and enhance the data analytics capabilities of its platform. Since Deputy serves as the system of record for labor costs, which are the largest controllable expense in hourly workplaces, these enhancements were especially crucial for its customers.

However, as a multi-tenant, micro-service architecture SaaS platform, Deputy’s customer data was spread across multiple siloed databases. This led to inefficiencies in data analytics, slow report generation of up to 10 minutes, and untapped new revenue streams through advanced reporting.

As Deputy had begun to focus on medium- to enterprise-sized businesses (beyond 100,000 employees), the data volume grew by an order of magnitude. This increase required a more scalable and cost-efficient solution. Additionally, the company had to handle large amounts of Personal Identifiable Information (PII) across multiple databases. This posed challenges in maintaining consistent access controls and governance policies.

To address these issues, Deputy turned to AWS in 2023 to create a hub-and-spoke architecture with a unified data ingestion, governance, and query framework.

kr_quotemark

Building on AWS has revolutionized our data architecture, reduced report generation times, and provided near real-time insights. This transformation has enhanced our operational efficiency and empowered our teams to innovate rapidly. With Amazon Redshift and our ongoing AI initiatives, we are well-positioned to continuously deliver smarter, data-driven solutions that elevate our customer experience and drive business growth.”

Qamal Kosim-Satyaputra
Senior Director of Engineering, Deputy

Solution | Achieving Real-Time Insights and Efficiency Using AWS

Deputy built a modern data architecture on AWS using Amazon Redshift, a fully managed cloud data warehousing service, as the central component of a hub-and-spoke data platform. By using Amazon Redshift, the company can now generate sophisticated reports in 6 seconds, a 99 percent improvement in speed. With faster reporting, Deputy gains access to deeper, data-driven insights, leading to reduced operational inefficiencies and enhanced agility and performance. 

The company also implemented Amazon Managed Streaming for Apache Kafka (Amazon MSK), a fully managed streaming data service for Apache Kafka. This was deployed to consolidate, stream, and ingest data from multiple sources in real time.

Meanwhile, Amazon Simple Storage Service (Amazon S3), an object storage service, served as an intermediary staging layer for future artificial intelligence and machine learning use cases.

By consolidating multiple siloed databases into a single, scalable data warehouse, the company optimized IT costs and maintained a predictable cost structure. Amazon Redshift's multi-tenancy support ensured multiple enterprises can now use Deputy’s platform without data interference, enhancing scalability. Additionally, Amazon Redshift’s data sharing and federated query features improved data governance and security.

Additionally, Deputy employed RA3 clusters to separate storage from compute. This increased flexibility for the company's "hub", added several serverless cluster endpoints as "spokes" for specific use cases, and unlocked a distributed, self-service consumption architecture for serving insights.

Deputy also consolidated and replicated 80 terabytes of workforce management data from the previous infrastructure to Amazon Aurora, a fully managed relational database, for analytical workloads. With Amazon Aurora’s high throughput rate, Deputy maintains over 200,000 MySQL databases distributed across 20 clusters, each containing over 2 million tables, with minimal lag and disruptions. With this migration, the company improved query speed and latency by 30 percent.

The new platform allows Deputy’s platform team to focus on developing features that enhance customer experience and improve internal efficiency. This setup fosters innovation, allowing the company to create new products using AWS data services such as Amazon OpenSearch Service. The company now accesses real-time insights, eliminating data silos and empowering teams to make decisions based on data.

By leveraging AWS data analytics services, we rapidly ingested millions of tables into Amazon Redshift and created reusable templates for data pipelines. This democratized data access and simplified governance by empowering domain owners and feature squads to create their own pipelines, significantly reducing the time needed for data replication.” said Kevin Tenggara, Senior Manager of Engineering, Deputy.

Outcome | Exploring Gen AI, Elevating Customer Experience

Deputy is currently working with AWS on several generative artificial intelligence (AI) proof of concepts. The company has established an intermediary staging layer within Amazon S3 to support AI, machine learning, and other data-related use cases in the future. These efforts aim to implement more intelligent features that can automate mundane tasks and provide quicker access to information, further improving customer experiences and operational efficiency. Eventually, Deputy plans to integrate generative AI with its platform to make quality-of-life improvements for customers.

“Building on AWS has revolutionized our data architecture, reduced report generation times, and provided near real-time insights. This transformation has enhanced our operational efficiency and empowered our teams to innovate rapidly. With Amazon Redshift and our ongoing AI initiatives, we are well-positioned to continuously deliver smarter, data-driven solutions that elevate our customer experience and drive business growth,” said Qamal Kosim-Satyaputra, Senior Director of Engineering, Deputy.

About Deputy

Deputy is the global people platform for hourly work. Its intuitive software strengthens employer-employee connections, streamlines compliance obligations, and revolutionizes how hourly workers and businesses operate together, creating workplaces that thrive. Over 350,000 workplaces use Deputy to create better work-life experiences for 1.4 million hourly workers globally. 

AWS Services Used

Amazon Redshift

Tens of thousands of customers use Amazon Redshift every day to modernize their data analytics workloads and deliver insights for their businesses. With a fully managed, AI powered, massively parallel processing (MPP) architecture, Amazon Redshift drives business decision making  quickly and cost effectively. 

Learn more »

Amazon Managed Streaming for Apache Kafka

Amazon Managed Streaming for Apache Kafka (Amazon MSK) makes it easy to ingest and process streaming data in real time with fully managed Apache Kafka.

Learn more »

Amazon S3

Amazon Simple Storage Service (Amazon S3) is an object storage service offering industry-leading scalability, data availability, security, and performance. 

Learn more »

Amazon QuickSight

Amazon QuickSight powers data-driven organizations with unified business intelligence (BI) at hyperscale. With QuickSight, all users can meet varying analytic needs from the same source of truth through modern interactive dashboards, pixel-perfect reports, natural language queries and embedded analytics. 

Learn more »

More Software & Internet Customer Stories

Showing results: 1-4
Total results: 369

no items found 

  • Swimming Australia Uses Data and Machine…

    Swimming Australia, the national governing body for competitive swimming, is at the heart of a sport that is part of Australia’s DNA. With over 100,000 registered members across 1,100 clubs nationwide, the organization has built a legacy of creating world champions and driving Australia's Olympic success—amassing 239 medals, including 78 golds. Today, it remains committed to pushing the boundaries of athletic performance.
    2024
  • India

    Helping the Next Generation of Creators…

    Invideo is a gen AI powered video creation tool that makes video production easy and accessible for everyone, regardless of technical skills, creative expertise or budget.
    2024
  • India

    Dream11 on AWS

    Dream11 is the world’s largest fantasy sports platform with more than 220 million users playing fantasy sports ranging from cricket and football to kabaddi and basketball. The flagship brand of Dream Sports, India’s leading sports technology company, it has partnerships with several national and international sports bodies and cricketers. Using Amazon Web Services (AWS), Dream11 has supported its expansion, developing new features and services fast and protecting users from disruption. Its Scaler tool combined with AWS technologies help it scale dynamically and cost-effectively to handle millions of requests a minute and hundreds of sporting events a day.

    2024
  • India

    Arré Voice Enhances User Engagement and…

    Arré Voice wanted to enhance user engagement on its digital media platform with personalized content recommendations. The company needed a scalable solution capable of processing large volumes of user data while supporting artificial intelligence (AI)-driven algorithms for content personalization. By transitioning to a microservices architecture, using Amazon Web Services (AWS), and implementing Astra DB, a vector database from AWS Partner DataStax, Arré Voice enabled real-time data handling and improved operational efficiency. Astra DB’s query capabilities and developer tools facilitated the rapid development of its recommendation engine, which now generates over 30 million personalized suggestions per month with a 90-percent reduction in latency.

    2025
1 93

Get Started

Organizations of all sizes across all industries are transforming their businesses and delivering on their missions every day using AWS. Contact our experts and start your own AWS journey today.