Custom dbt Transformation Macro
Budget: ₹600 – ₹1,500 INR
I need a reusable dbt macro that performs a data-transformation step and plugs neatly into the models already living in my project repo. The macro must follow dbt’s best-practice conventions (Jinja style guide, ref/var usage, proper error handling) and run flawlessly when I execute dbt run + dbt test.
Context
• Primary purpose: data transformation (not validation or aggregation).
• Existing landscape: several models and tests are in place; the macro should slot in without breaking current materializations or naming standards.
What I will hand over
– Read-only access to the repo and an example model where the macro should be called.
– A brief schema description plus sample data so you can reproduce my environment locally.
Deliverables
• The fully documented macro in its own .sql file.
• A sample model illustrating the call signature.
• Unit tests that prove the macro behaves as intended across at least two edge cases.
• An update to the README explaining setup, invocation, and expected inputs/outputs.
Acceptance criteria
1. dbt run completes with zero errors or warnings.
2. All new tests pass on my end.
3. Code adheres to dbt style guidelines and lints cleanly.
4. Macro logic is clear enough that I can tweak parameters without further guidance.
I’m happy to answer detailed questions about the transformation logic once you’ve reviewed the repo.
Context
• Primary purpose: data transformation (not validation or aggregation).
• Existing landscape: several models and tests are in place; the macro should slot in without breaking current materializations or naming standards.
What I will hand over
– Read-only access to the repo and an example model where the macro should be called.
– A brief schema description plus sample data so you can reproduce my environment locally.
Deliverables
• The fully documented macro in its own .sql file.
• A sample model illustrating the call signature.
• Unit tests that prove the macro behaves as intended across at least two edge cases.
• An update to the README explaining setup, invocation, and expected inputs/outputs.
Acceptance criteria
1. dbt run completes with zero errors or warnings.
2. All new tests pass on my end.
3. Code adheres to dbt style guidelines and lints cleanly.
4. Macro logic is clear enough that I can tweak parameters without further guidance.
I’m happy to answer detailed questions about the transformation logic once you’ve reviewed the repo.