The only data hire at a ~15-person global edtech (online courses sold worldwide). The legacy setup was a PostgreSQL stuck on a small VM ("DataFy"), wired to the production databases, and it couldn't take on more data or support complex analysis. I built a platform from scratch in its place: BigQuery as the warehouse, Cloud Run services ingesting every service database, and the marketing sources (Google Analytics, Search Console, Ads) unified alongside. Scalable and manageable, with every data source in one place, built end to end and solo in under a month.
- Replaced the legacy "DataFy" (Postgres on a VM that couldn't scale) with a BigQuery warehouse, fed by Cloud Run ingestion services pulling every service database
- Unified the marketing sources in the warehouse (Google Analytics, Search Console and Google Ads), with Metabase dashboards and Slack monitoring alerts
- Mapped market penetration across all 227 countries: where Elevify already sells, where penetration is strong, and how much of the market is still open · 227 countries
- Built B2B lead scoring: flagged corporate accounts in the base (by email and professional course usage) so Elevify could offer its Exclusive B2B plan to companies certifying their staff
- Lifted the pay rate by 18% by finding the best payment option per country and switching to it, so more attempted payments actually go through · +18% pay rate
- Ran seasonality analysis tracking growth against global demand for education; the platform now sits behind ~300k course enrollments a month · ~300k enrollments/mo