I will optimize slow bigquery and snowflake sql queries to cut costs

Canada

I speak English, Hindi, Gujarati

3 orders completed

Snowflake and BigQuery SQL, dbt pipelines, Power BI and Looker dashboards

I’m your all-in-one data expert — I design dashboards, build semantic models, and create complete data solutions. With experience across retail, e-commerce, and insurance, I specialize in Power BI, Ta...
About this Gig

Slow dashboards and a growing warehouse bill usually come down to a handful of queries. I'll find them and fix them.


We're Dedolytics, a data and analytics consultancy. We write and tune SQL on Snowflake and BigQuery. Recent work (anonymized): we fixed broken Snowflake pipelines and sped up the slow queries behind a Florida fire rescue department's reporting.


What I do: review your slowest or most expensive queries, rewrite them, and recommend partitioning, clustering and materialization changes. You get the optimized SQL, a short note on each change, and before/after runtime and bytes scanned measured on your own data.


Basic: 1 query tuned. Standard: up to 10 queries plus a cost report. Premium: up to 20 queries, dbt model refactor, cost alerts and a handover call.


Results depend on your data and setup, so I don't promise a fixed % saving. I'll show you exactly what changed.


Please message me before ordering with your warehouse (Snowflake or BigQuery) and roughly how many queries, so I can confirm the right package.

Database type:

Distributed database

•

Relational database

Platform:

BigQuery

•

PostgreSQL

•

Redshift

Expertise:

SQL

•

Big data

•

Performance

•

Query optimization

My Portfolio