SQL all transformation, 599 dbt models in the warehouse
dbt the modeling layer, run from CI
BigQuery 2.7 TB stored, 3.5 TB scanned a day
Airflow 21 hourly pipelines, self-hosted on Kubernetes
Looker Studio primary BI surface for the business
Google Sheets analyst extracts and finance reporting
Metabase dedicated dataset and its own refresh job, secondary to Looker Studio
Dataplex catalogue and data quality
Cloud Storage file staging for ingestion and outbound delivery
GitHub Actions 6 workflows: PR checks, hourly, daily, on-demand, docs
Python third-party API pulls and data jobs
Google Apps Script clinic and incentive reporting dashboards
Streamlit Dataverse, a public build
Zoho Analytics hourly incentive sync into a reporting workbook