I will build dbt models dbt tests data pipeline snowflake data warehouse
About this Gig
Is your Snowflake warehouse hard to trust? Dashboards disagree and every change feels risky.
I build dbt models on Snowflake that turn that mess into a tested, documented data pipeline. Models are layered, so every metric is defined once. Schema tests (not_null, unique, relationships, accepted_values) catch bad data early, and schema.yml documents every model and column.
You will get:
- Staging, intermediate and marts layers
- Schema tests and quality checks
- YAML docs for every column
- Handover note for dbt build
Works with dbt Core or dbt Cloud, Snowflake, and BI tools like Power BI, Tableau or Looker.
After delivery: one agreed definition per metric, and fewer mismatched numbers.
I need read access to the source schema (sensitive fields removed is fine) and a dev environment.
Not included unless quoted: orchestration, migrations, production deployment.
Ready to stop guessing?
Message me with your Snowflake setup and models needed, and Ill reply with next steps and a price.
Warehouse Platform:
Snowflake
•
BigQuery
•
Redshift
Project Type:
New Build
FAQ
Do you work with dbt Core or dbt Cloud?
Both. I build to whichever you run.
Do I need to give you production access?
No. I need read access to the source schema and a dev environment. You run dbt build yourself.
Do the packages include tests and documentation?
Yes. Basic includes schema tests and basic documentation. Standard and Premium add the full YAML documentation for every model and column.
Can you add incremental models or snapshots?
Incremental models are included in Premium. Snapshots (SCD Type 2) can be quoted separately.
Can you fix or extend an existing dbt project?
Yes. I review the repository first, then quote the work so you know the scope before you pay.
Can you help with a migration from stored procedures?
That’s covered in my migration gig. This gig covers building new dbt models.

