Unify Warehouse via dbt

via Freelancer ·

Budget / Salary€250–750
TypeFreelance project
LocationRemote
Posted13 minutes ago
I need an analytics engineer who can take our scattered Snowflake warehouse—more than 60 models at last count—and rebuild it into a clean, tested, and documented dbt project. Right now two analysts are maintaining conflicting revenue definitions, ownership is unclear, and only a handful of models are genuinely useful. Your work will give us a single source of truth and the confidence to trust every metric that comes out of it.

The core of the engagement is to:
• Refactor each useful model into a dbt model, add appropriate tests, and assign an owner.
• Retire anything redundant or unused by moving it into a dbt archive folder.
• Produce reliable, non-conflicting revenue metrics in the new layer.
• Commit everything through Git so we have a transparent history.

Our stack is Snowflake, SQL, dbt, and Git; three-plus years working with them is a must. We overlap with Central European Time, so you’ll need at least a few shared hours each day. Clear written and spoken English at B2 level or higher is important because you’ll be naming owners, writing model descriptions, and documenting the final structure.

Deliverables will be accepted once all retained models compile cleanly, pass the agreed tests, and the documentation portal shows owner, purpose, and usage examples for each of them.
sql statistics database administration statistical analysis data warehousing spss statistics git data analysis data modeling snowflake
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.