01
- Cost audit
- A deep look at INFORMATION_SCHEMA, the jobs that scanned the most bytes, and the reservations that cost the most slots. You get a ranked list of fixes with dollar amounts attached.
02
- Query and schema tuning
- Partitioning, clustering, materialized views and shuffle-aware rewrites applied to the queries that matter most, with measured before and after.
03
- Reservations and editions
- On-demand versus Standard, Enterprise or Enterprise Plus editions chosen against actual workload shape, with autoscaling policies set deliberately.
04
- dbt and pipelines
- dbt and Dataflow pipelines that are slow, fragile or overpriced, rebuilt around incremental models and sensible partitions.
05
- BI cleanup
- Looker, Tableau and Mode projects that generate expensive SQL, tidied so the warehouse does the filtering rather than the dashboard.
06
- Managed Tech
- Monthly review of slot usage and bytes scanned, alerts set against reality, and a team to call when a quota or a reservation decision needs making.