I will write optimised sql queries and dbt models
Data Professional
Informazioni su questo servizio
Slow queries, untested transformations, and pipelines only one person understands these are the problems I fix.
With 10+ years in data analytics and hands-on experience building production dbt pipelines at a NASDAQ-listed B2B commerce platform across 5 markets, I write SQL and dbt models that are fast, tested, and built to be maintained by a team not just the person who wrote them.
What I can help with:
· Writing complex SQL: window functions, CTEs, recursive queries, performance tuning
· Building dbt models across staging, intermediate, and mart layers
· Adding dbt tests, documentation, and schema.yml coverage
· Refactoring spaghetti SQL into clean, modular transformations
· Incremental models and source freshness monitoring
· Adapting pipelines for BigQuery, Snowflake, PostgreSQL, or Redshift
Every delivery comes with inline comments, a brief logic summary, and for dbt work a schema.yml file so the next person who touches it knows exactly what it does. Message me before ordering if your pipeline is complex or you're unsure which tier fits.
Warehouse Platform:
Snowflake
•
Databricks
•
Altro
Tipo di progetto:
Ottimizzazione
FAQ
Do you work with all SQL dialects?
Yes — BigQuery, Snowflake, PostgreSQL, Redshift, and SQL Server. Let me know your stack when ordering and I'll tailor syntax accordingly.
Can you help fix an existing broken or slow pipeline?
Absolutely. Pipeline debugging and refactoring is a common request. Share what you have and describe the issue — slow query, incorrect output, failing dbt run — and I'll diagnose and fix it.
Will the dbt models work with my existing project structure?
Yes, I'll adapt to your existing folder structure, naming conventions, and dbt version. Share your project setup when ordering so I can match your patterns.
What do I receive at the end?
SQL files or .sql dbt model files with full inline comments, a schema.yml for dbt work, a short logic summary document, and test definitions. Everything is ready to drop into your repo.
