I will fix and optimize sql and dbt models in snowflake and bq
B2B Lead Generation and Data Research Specialist
About this Gig
Your SQL already works. The problem is that it lives in twelve saved queries, nobody remembers which runs first, and two dashboards using "the same" metric quietly disagree.
dbt fixes that, and the SQL inside stays the SQL you already have.
What I do:
- Turn existing queries into dbt models across staging and marts, so a metric is defined once and reused everywhere
- Fix models that are slow, wrong, or silently broken
- Add tests: uniqueness, not-null, referential integrity, row-count and revenue reconciliation
- Write the documentation, so the next person does not have to guess what a column means
I work daily in Snowflake with dbt, Fivetran and Metabase, for a US product company, from Germany. Most of my time goes to subscription data: MRR, churn, retention, funnels.
Scope, honestly: I work inside your existing dbt project, or set up a simple one from scratch. I do not take on CI/CD pipelines, custom macro libraries or orchestration platforms if that is what you need, I will say so before you order rather than after.
Send me your repo or your current queries, tell me what the final tables should answer, and I will tell you what is realistic.
Platform:
BigQuery
•
MongoDB
•
MySQL
•
PostgreSQL
Expertise:
SQL
•
NoSQL
My Portfolio
FAQ
Do I need an existing dbt project?
No. If you have one, I work inside it. If you don't, I can set up a simple project - sources, staging and marts - and hand it over with a README so your team can run it themselves.
Which warehouses do you work with?
Snowflake, BigQuery, PostgreSQL and Redshift. The dbt logic transfers between them; only a handful of functions differ, and I handle that as part of the work.
What do you need from me to start?
Read access to the source tables, a dev schema dbt can write to, and - most important - what one row means in each table and which rows to exclude. Only you know that part.
Can you just fix the SQL without dbt?
Yes. If dbt is more than you need right now, I will write plain SQL and say so, rather than selling you a setup nobody on your team will maintain.

