Home · Work · Case study
Case Study

Six Hours to Thirty Minutes

A nightly pipeline processing billions of records had grown to own the entire night — six hours on a good night, with failures discovered at breakfast and the business starting its day on yesterday’s data, or none.

IndustryData platform client
ServicesData Engineering
EngagementProfile, redesign, staged rollout
6h → 30minnightly runtime
Billionsof records per run
Same windowfailures now alert at night, not morning
Overview

The situation.

The pipeline fed the reporting the business ran on. Volumes had grown into the billions of records; the design hadn’t grown with them — stages ran sequentially that had no dependency, data was processed in shapes that forced expensive shuffles, and a single stage’s failure restarted hours of work. The team’s ask was simple: make it fit the night again, with room to grow.

Result

Where it landed.

The pipeline now finishes before the team’s evening ends, failures surface while someone can still fix them the same night, and the business starts every day on current data. The profiling discipline stayed behind: per-stage timing is now a permanent dashboard, so the next slow-down gets caught at twenty minutes, not six hours.

Our Solution

What we built.

  1. Profile before redesign

    Per-stage instrumentation first: where the six hours actually went, in data, before a single design decision.

  2. Parallel workload design

    Independent stages restructured to run concurrently, with the dependency graph made explicit and enforced by the orchestrator.

  3. Data layout for the access pattern

    Partitioning and clustering matched to how stages actually read — cutting the shuffle and scan volume that dominated runtime.

  4. Checkpointing & alerts

    Stage-level checkpoints so failures resume instead of restart; alerts at night, to the team, with the failing stage named.

Key Achievements

The numbers.

30 minend-to-end nightly runtime
12xfaster, on the same data volumes
Minutesfailure detection, down from hours
Headroomcapacity for continued volume growth

Start with a fit call.

Thirty minutes. Bring the problem as it actually is — the stalled pilot, the bill, the spreadsheet everyone quietly maintains. We’ll tell you honestly whether we’re the right builder for it.

You leave with a straight answer on fit — and if it fits, a free Blueprint to follow.