Browse categories
Explore
Fiverr Pro
English
$
USD
I will build robust dbt models, custom macros, and tests
Python, TypeScript, DevOps and Snowflake Expert
Software Engineer with 5+ years of experience working for big enterprises, specializing in Python, TypeScript, and cloud automation. From building robust APIs with FastAPI/Django to setting up seamles...
About this Gig
Clean, Production-Ready dbt Data Modeling - No AI Slop.
I am a professional software and data engineer specializing in building robust, version-controlled dbt projects entirely by hand.
What I Will Do for Your Pipeline:
- Build modular dbt models with clean lineage.
- Configure automated data tests (unique, not_null, accepted_values and referential integrity).
- Write custom data quality tests for complex business logic (Standard/Premium).
- Create reusable Jinja macros to eliminate redundant, hard-coded SQL (Premium).
- Provide documentation layout using dbt docs.
Scope Limits (To Protect Your Project & My Schedule):
- 1 Model means 1 .sql file + 1 .yml file.
- Standard Custom Test Limit: Maximum of 2 custom tests.
- Premium Custom Test Limit: Maximum of 4 custom tests.
- Premium Macro Limit: Maximum of 2 custom Jinja macros.
- Infrastructure hosting, cloud deployment (CI/CD), and Docker setup are not offered.
Please message me first with your schema layout before placing an order!
FAQ
What exactly counts as "one dbt model" for this gig?
One model is strictly defined as one .sql file and its corresponding .yml properties file. If your project requires mapping out complex DAGs with dozens of multi-layered table dependencies, please message me first so I can look over your schema and provide a fair custom quote.
Do you handle dbt Cloud hosting, Docker containerization, or CI/CD deployment?
No. This specific gig is focused entirely on core data engineering, SQL modeling, Jinja macros, and test writing. I do not handle cloud hosting, Docker setups, or infrastructure pipelines as part of these base packages.
How do we handle database access and credentials safely?
Security is a priority. Please do not send raw passwords. Once the order starts, we will configure your connections using secure environment variables, or you can grant specific service account permissions directly within your data warehouse (like Snowflake or BigQuery).
