Do y'all have a reference architecture or templates for local development with CICD pipelines?

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.