Stealth Data Warehouse

Led product and royalty-domain architecture for a confidential music investment company's finance data platform, replacing manual, spreadsheet-built executive and board reporting across a 15+ label portfolio with a governed, automated system. I defined the royalty domain logic and dimensional model, recoupment, cross-collateralization, advances and reserves, attribution rules, metric definitions, and dual-temporal cash/accrual revenue, that the engineering team built into a three-layer dbt pipeline (staging → intermediate → marts) on Google BigQuery, reconciling 50M+ normalized, multi-currency royalty records to source with automated orchestration, monitoring, and a reconciliation framework running underneath a self-service BI layer. Scoped and sized the delivery team and set the acceptance gates the platform had to clear end to end.