Built a production-grade DeFi analytics pipeline that powers the exact same KPIs top-20 protocols publish:
- Protocol ARR, Net Revenue after gas, Gross Margin %, TVL, Cross-chain DAU, 24h Swap Volume
- Full ELT stack: raw on-chain CSVs → dbt (staging → intermediate → marts) → BigQuery → dashboard-ready tables
- Modeled with senior-level best practices: dimensional modeling, data tests, documentation, lineage