Customer Stories / Software & Internet
![Deputy Deputy](https://d1.awsstatic.com/apac/customer-references-logos-(%401x---%402x)/DEPUTY_logo%402x.de0dc42bc4af401ef18a3b7bf3c4ea52cb612b30.png)
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 Deputy](https://d1.awsstatic.com/apac/events/2024/case-study/case-study-deputy2024-img.8dd6c45d325ae7d54bbb1fe603bbc12a0d2154c7.jpg)
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 kr_quotemark](https://d1.awsstatic.com/case-studies/CustomerReferences_QuoteMark.16fc612d9e480eaec3e716161a76c4a71428c86a.png)
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.
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.
Amazon S3
Amazon Simple Storage Service (Amazon S3) is an object storage service offering industry-leading scalability, data availability, security, and performance.
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.
More Software & Internet Customer Stories
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. -
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.
-
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.
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.