I will add dbt data quality tests and ci checks
AI powered automation for seamless efficiency
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
About this Gig
Does your dbt pipeline finish successfully while still producing duplicates, null keys, broken relationships, stale sources, or incorrect business logic?
I will add focused dbt data-quality tests, documentation, and an optional CI quality gate to your existing project.
Depending on your package, I can implement:
- not_null, unique, accepted_values, and relationships tests
- reusable generic tests
- singular SQL business-rule tests
- source freshness checks
- dbt unit tests for model logic
- model, column, source, and test documentation
- stored failures and practical severity settings
- selectors and one agreed CI workflow
- clear local and CI run instructions
You receive reviewed project changes, reproducible commands, sample failing evidence, and a concise quality report.
This service validates rules that we define together. It cannot guarantee the correctness of upstream systems or business definitions that were not supplied.
Please message me before ordering if the project has more than 30 models, multiple warehouses, custom materializations, regulated data, or a complex monorepo.
My Portfolio
FAQ
Which dbt versions and warehouses do you support?
The exact dbt Core or dbt Cloud version and adapter must be reviewed first. Common targets include Snowflake, BigQuery, Redshift, Databricks, and PostgreSQL.
Can you work in an existing dbt project?
Yes. The Gig is designed for existing projects. I will follow the repository's style, naming, and branch workflow where documented.
Do you write business-specific tests?
Yes. Standard and Premium include bounded custom tests when the buyer provides the rule, expected behavior, and representative safe data.
Can you add source freshness checks?
Yes. The buyer must define the expected update cadence, acceptable warning threshold, and failure threshold for each included source.
Is fixing every failing record included?
No. The Gig implements tests and can repair agreed dbt logic. Correcting upstream source systems or manually cleaning unlimited records is separate work.
Can you add dbt tests to CI?
Premium includes one agreed CI quality gate when repository access, credentials strategy, and runner details are available.
Do you need production warehouse access?
Prefer a development target with restricted credentials and safe sample data. Access should follow least privilege.
What is a revision?
A revision corrects the agreed tests or documentation. New models, new rules, a second warehouse, or a different CI platform are additional scope.

