Your Senior Data Engineer posting describes moving legacy SQL Server and SSIS reporting into dbt on Snowflake while keeping the lights on for the teams who depend on it. I finished that same move for claims reporting at Highmark last year, and I would like to do it again with what I learned the first time.
At Highmark we had 140 nightly SSIS jobs that took six and a half hours and failed often enough that actuarial analysts checked their numbers by hand. I rebuilt them as dbt models scheduled in Airflow, migrating one subject area at a time with parallel runs and row-count reconciliation before each cutover. The nightly run now finishes in under two hours. Adding dbt tests and Monte Carlo monitors across the 320 models brought analyst tickets about bad data from about a dozen a month to three.
I also own warehouse cost for our domain. Right-sizing warehouses, tightening auto-suspend and clustering our two largest tables saved about $18,000 a month without missing a refresh. Before Highmark I spent three years at UPMC Health Plan working with pharmacy prior-authorization data, so I am used to the access controls and audit trails that regulated data requires.
I would be glad to talk through how I sequenced the migration and handled the cutover weeks. I am in Pittsburgh and can come downtown whenever suits your team.