Browse categories
Explore
Fiverr Pro
English
$
USD
I will review your bigquery data warehouse and fix costs, performance and architecture
About this Gig
Is your BigQuery bill climbing every month? Are your dashboards slow and your dbt models a tangle of tech debt? I will do a deep review of your entire data warehouse and give you a concrete, prioritised action plan to cut costs and speed everything up.
I work with BigQuery daily designing incremental pipelines, tuning partitioning and clustering strategies, untangling Airflow DAGs and making sure Looker and Metabase never hit a full table scan. You get the same expertise, applied directly to your stack.
What I audit?
- Query cost analysis. Top spend queries, full scans, slot usage
- Table storage design. Partitioning, clustering, expiry policies
- dbt model review. Incremental strategy, redundancy, tests
- Orchestration/DBT DAG audit. Scheduling, retries, backfill issues
- BI layer performance. Looker / Metabase slow queries & caching
- Architecture roadmap. Prioritised fixes with estimated savings
Warehouse Platform:
BigQuery
Project Type:
Optimization
FAQ
What access do you need?
Read-only access to BigQuery (INFORMATION_SCHEMA + query history), your dbt repo on GitHub/GitLab, and view access to your DBT or DAG files. No write access required for the audit.
How much can I realistically save?
It depends on your setup, but most teams see 30–60% cost reductions after fixing table scans, switching to incremental models and adding proper partitioning. I will give you an estimate before we start.
We already use dbt — can you still help?
Absolutely. Most of my work is on existing dbt projects — reviewing model materialisation strategies, incremental logic, test coverage and how models interact with your BigQuery storage.
Do you sign an NDA?
Yes, happy to sign one before any access is shared. Data confidentiality is taken seriously on every engagement.
