01
2025
12 weeks · fixed scope
Series B fintech · 80 staff
Replatformed analytics off a read-replica onto a modelled warehouse.
- The executive dashboard was choking a Postgres read-replica; a 30-minute morning ritual to refresh, $14k a month in unnecessary spend, and three analysts spending half their week firefighting broken queries.
- Sketched a target warehouse, picked BigQuery for the team's existing GCP footprint, modelled the revenue, retention and finance marts in dbt, and migrated reporting one dashboard at a time so nothing went dark.
- → P95 query latency 18s → 400ms. $14k/mo read-replica spend retired. Analyst time on firefighting down ~70%.
- BigQuery
- dbt
- Fivetran
- Metabase