Offshore team · Backend, Data & DevOps

Social Media Analytics Platform

Backend, data, and DevOps for a large-scale analytics platform ingesting billions of events a day.

Marketing analytics · SaaS

  • 120s → <35s

    Dashboard query response time

  • 280+ TB

    Data under management in S3

  • 8–16B

    Events ingested per day

  • 93%

    TypeScript coverage across 25+ pages

How it fits together

  1. Event sources

    8–16B events a day

  2. S3 data lake

    280+ TB

  3. ETL pipelines

    100+ GB a day · 690+ tables

  4. Redshift warehouse

    47 TB · tuned queries

  5. Dashboards

    TypeScript frontend · <35s queries

The challenge

The platform ingested 100+ GB and 8–16 billion events every day across 690+ tables, with 280+ TB in S3 and 47 TB in Redshift. Dashboard queries took up to two minutes, and a growing JavaScript frontend was getting harder to change safely.

What we did

  • Worked as part of the offshore engineering team owning backend, data pipelines, and DevOps.
  • Profiled the slowest Redshift queries and reworked table design, sort/dist keys, and query shape.
  • Hardened the ETL that moves daily event volume from S3 into the warehouse.
  • Led an incremental TypeScript migration of the frontend, page by page, without freezing feature work.

Get in Touch

Let's See If We're a Fit.

Whether you have a fully scoped project or just an early idea, book a free 30-minute call. You'll talk to the founder, not a salesperson — and leave with honest advice even if we're not the right team.

Book a Free Discovery Call (opens in new tab)Send a Project Brief

Prefer email? [email protected]

No commitment required. Happy to sign your NDA before the call. We reply to every brief within one business day.