I will build dbt data models with tests and documentation
About this Gig
I will build clear, tested dbt models for your analytics warehouse. This gig is for a focused first slice of an existing data pipeline: up to two models from one source, schema and data-quality tests, documentation, and instructions to run the project locally.
I start by confirming the source schema, grain and business rules. I then implement the transformations, add tests for the important contracts, generate documentation, and hand over the SQL/YAML plus run notes. Snowflake is supported; I can also use DuckDB locally for a reproducible build.
My public biometric-warehouse-dbt project shows the approach: staged synthetic data, consent-aware transformations, a daily quality mart, documented lineage and 57 tests. The example is a proof of concept, not a claim about a client deployment.
The $300 package covers one source and two models within seven days, with one revision. New sources, more models, production deployment or migration need a custom scope. Message me with your schema, target warehouse and desired output before ordering.
Warehouse Platform:
Snowflake
Project Type:
New Build
My Portfolio
Other Data Engineering Services I Offer
FAQ
What do you need from me to start?
Please provide the source schema or sample data, your target warehouse, expected output grain, and any business rules. Sanitised or synthetic samples are fine for an initial build.
Does this include a production Snowflake deployment?
No. This package delivers tested dbt models and run instructions for the agreed source. Snowflake account setup, credentials, production orchestration and deployment are separate work that I can quote after reviewing your environment.
