Case study
Dashboards Refresh in Ten Seconds, Not Hours, for a Recruiting Platform
How SquareShift moved a recruiting platform's 70TB analytics workload from Snowflake to BigQuery, cutting dashboard refresh times from hours of lag to under 10 seconds.
Book a session →
Client
A SaaS-based applicant tracking and recruiting platform that helps thousands of companies source, hire, and onboard staff.
Industry
Technology
Services
Stack
Snowflake · BigQuery · Looker
How SquareShift delivered it.
The challenge
The client runs a SaaS recruiting platform that helps thousands of companies source, hire, and onboard staff. Its analytics ran on Snowflake and Looker, processing 4B–5B events a week across more than 70TB of data, but query performance had slipped, ETL runs lagged 4–6 hours behind, and storage costs kept climbing.
What we delivered
SquareShift migrated the full analytics workload from Snowflake to BigQuery, more than 70TB of data, and rebuilt the pipelines carrying it, simplifying the data architecture end to end. The existing Looker dashboards were re-pointed to the new backend, so reporting kept working through the cutover.
See the data engineering services behind projects like this.
The outcome
Dashboard refreshes now complete in under 10 seconds instead of lagging hours behind, and data arrives fresher from every source. The simplified BigQuery architecture also costs less to run than the Snowflake setup it replaced.
An ETL pipeline that lags hours behind isn't a performance problem, it's a trust problem — nobody plans hiring decisions off numbers they know are stale. Fixing that meant rebuilding the pipeline, not just tuning the warehouse.
Data & Analytics Practice Lead, SquareShift
Related reading: cutting analytics costs for a global learning and talent software provider and rebuilding an EdTech platform's analytics on Google Cloud.
