01
- Rescue
- A scheduler run that keeps failing, a test suite nobody trusts, or a manifest that is out of sync. We stabilize the daily run first, then clean the structure.
02
- Project structure
- Staging, intermediate and mart layering, naming conventions, shared macros and package choices worked out against your warehouse and team shape.
03
- Test and freshness strategy
- Tests at the right severity, source freshness that fires before downstream breaks, and a review of what is masked by warn thresholds.
04
- Incremental and performance work
- Incremental models with explicit unique_keys and merge strategies, warehouse sizing matched to run times, and a cost review of the heaviest models.
05
- CI and state
- A CI pipeline that uses defer and state:modified correctly, manifest storage that keeps the slim build trustworthy, and a release path from dev to prod that does not surprise anyone.
06
- Managed Tech
- Standing care for the project: run health, cost trends, package and core upgrades, documentation drift, and a line to call when a mart stops matching finance's numbers.