Snowflake + dbt Migration Framework

I’m standing up a brand-new business-intelligence stack in Snowflake and need a reusable migration framework built with dbt and solid SQL. The framework has to pull from two kinds of sources—existing relational databases and the steady stream of CSV/Excel flat files our teams export—then land, cleanse, validate, and automate each load all the way into analytics-ready tables.

Here’s what I’m after:

• A dbt project structured for easy extension, complete with models, seeds, macros, and tests that enforce data-quality rules at every stage.
• Parameterised SQL and Snowflake tasks/procedures that orchestrate fully automated loads, from raw landing zones through staging to final marts.
• Built-in monitoring and reporting—leveraging dbt tests, Snowflake query history, or a lightweight dashboard—so I can track load status, row counts, and any data-quality exceptions in near real time.

If you’ve already solved similar migration challenges in Snowflake with dbt, let’s talk and get this framework in place.

This is more of remote connect project