← All projects
Production 2024 — Present

ClickHouse Cloud Migration

Migrated a marketing-analytics warehouse from Google Cloud to ClickHouse Cloud — ~40% lower cost, with rebuilt ingestion, dbt transformations and failure alerting.

Lead Data Engineer · NDA, Marketing domain

ClickHouse ClouddbtAWSGCPPython

The analytics platform ran on Google Cloud — expensive and awkward to scale. I led the move to ClickHouse Cloud and rebuilt the pipelines around it.

What I did

  • Migrated GCP → ClickHouse Cloud, cutting platform cost by ~40%.
  • Rebuilt extraction pipelines from Postgres, Appsflyer, Amplitude and AWS S3 into ClickHouse Cloud — for reliability and scale.
  • Moved transformations to dbt — modular, testable models replacing ad-hoc tasks; pipeline execution ~40% faster.
  • Optimized storage & compute on AWS + ClickHouse with incremental models — a further ~35% off the bill.
  • Added DWH failure alerting so broken pipelines surface before broken dashboards do.

Impact

A faster, far cheaper warehouse the marketing org could scale on — without the Google Cloud bill.