I will debug and optimise your google bigquery sql queries
About this Gig
Are you struggling with slow SQL queries, BigQuery errors, incorrect results, or inefficient data transformations?
I'm a Data Engineer and Business Intelligence specialist with hands-on experience building and maintaining production-grade data pipelines, data marts, and reporting solutions.
I can help you with:
- Debugging and fixing SQL and BigQuery errors
- Optimising queries for faster execution and lower costs
- Troubleshooting joins, aggregations, duplicates, and incorrect results
- Developing and improving complex SQL queries
- Building and maintaining BigQuery data transformations
- Investigating data quality and reporting discrepancies
- Improving SQL readability, structure, and maintainability
Why work with me?
I have practical experience working with Google Cloud Platform (GCP), BigQuery, Dataform, Looker, and complex financial and e-commerce datasets.
I focus on delivering accurate, efficient, and maintainable solutions with clear communication throughout the project.
Please contact me before ordering so we can discuss your requirements and agree on the scope of work.
Platform:
BigQuery
•
MySQL
•
PostgreSQL
•
SQL Server
Expertise:
Design
•
SQL
•
Performance
•
Query optimization
FAQ
What types of SQL and BigQuery issues can you help with?
I can troubleshoot SQL errors, optimise slow BigQuery queries, fix incorrect joins and aggregations, investigate duplicate records, improve query performance, and resolve data transformation issues. I also work with complex SQL queries used in analytics, reporting, and financial data reconciliation.
What information do you need to get started?
Please provide the SQL query, a description of the issue, any relevant error messages, and your expected results. Sample data or table schemas may also be helpful. For sensitive datasets, anonymised examples are perfectly acceptable.
Do you need access to my Google Cloud or BigQuery environment?
Not necessarily. Many SQL issues can be diagnosed using the query, table schemas, and sample data. For performance investigations or environment-specific problems, limited read-only access may be helpful. We can discuss the safest approach before starting, and I will never need your personal logins.
Can you help reduce my BigQuery query execution costs?
Yes. I can review your SQL for inefficient joins, unnecessary data scans, poor filtering, and opportunities to improve query structure. Where appropriate, I can recommend partitioning and clustering improvements. Actual savings depend on your data, query patterns, and BigQuery configuration.
Do you also work with Looker, Dataform, and data pipelines?
Yes. I have hands-on experience with Google Cloud Platform, BigQuery, Dataform, Looker, ETL processes, data modelling, and business intelligence reporting. If your project involves multiple tools, please contact me to discuss a custom offer.
What if my project requires more work than your Gig packages cover?
No problem! I can review your requirements and provide a custom offer based on the complexity, scope, and estimated effort. Please message me with a brief description of your project before placing an order.

