We had a very similar scenario except with Snowplow (I think - this was many years ago) that used to cost silly money per month.
Replace most of it with GCP BQ Schedule Queries.
A few years we hired a "data" team, they came in and prompt introduced the cluster fire that was DBT. Costs exploded, data was a mess. The few bits of data that we owned, we ring fenced and just kept chugging along on GCP BQ Schedule Queries.
We had a very similar scenario except with Snowplow (I think - this was many years ago) that used to cost silly money per month.
Replace most of it with GCP BQ Schedule Queries.
A few years we hired a "data" team, they came in and prompt introduced the cluster fire that was DBT. Costs exploded, data was a mess. The few bits of data that we owned, we ring fenced and just kept chugging along on GCP BQ Schedule Queries.
KISS.