You can replace local postgres with DuckDB and it should be even faster for data analysis.
(head of produck at MotherDuck)
My last data engineering team struggled to get something like that working with BigQuery, so I'm super excited about the possibility of better data warehouse developer tooling.