You will get Fix, Debug & Optimize Your SQL Query (Fast, Correct, Production-Ready)
Project details
You will get a correct, optimized, production-ready SQL query.
This project is for teams that already have SQL in place but suffer from silent issues: incorrect aggregations, duplicated rows, broken joins, slow execution, or logic that’s hard to maintain. I specialize in debugging and refactoring real analytics SQL, where correctness and trust matter more than cosmetics.
My background is in owning mission-critical data systems, not ad-hoc analysis. At LATAM Airlines, I was the technical owner of complex BigQuery SQL powering pricing, revenue, and operational workflows at scale. I’ve dealt extensively with grain mismatches, join explosions, faulty window logic, and performance bottlenecks.
My approach is systematic:
• Fix data grain and logic first
• Validate correctness before optimizing
• Refactor into clean, well-named CTEs
• Optimize only where it creates measurable impact
You’ll receive a clear before/after refactor, with professional inline comments explaining what was wrong, what was fixed, and why.
This project is for teams that already have SQL in place but suffer from silent issues: incorrect aggregations, duplicated rows, broken joins, slow execution, or logic that’s hard to maintain. I specialize in debugging and refactoring real analytics SQL, where correctness and trust matter more than cosmetics.
My background is in owning mission-critical data systems, not ad-hoc analysis. At LATAM Airlines, I was the technical owner of complex BigQuery SQL powering pricing, revenue, and operational workflows at scale. I’ve dealt extensively with grain mismatches, join explosions, faulty window logic, and performance bottlenecks.
My approach is systematic:
• Fix data grain and logic first
• Validate correctness before optimizing
• Refactor into clean, well-named CTEs
• Optimize only where it creates measurable impact
You’ll receive a clear before/after refactor, with professional inline comments explaining what was wrong, what was fixed, and why.
Database Type
MySQL, MS SQL, SQLite, PostgreSQLWhat's included
| Service Tiers |
Starter
$49
|
Standard
$99
|
Advanced
$169
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 1 | 1 | 2 |
Number of Tables Added | 0 | 0 | 0 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | - | - | - |
Admin Panel Setup | - | - | - |
Frequently asked questions
About Manuel
Revenue & Data Engineer | BigQuery, Python, Looker | Ex-LATAM RM
Santiago, Chile - 6:43 am local time
I’m a Senior Analytics Engineer specialized in production-grade data stacks, revenue analytics, and operational BI — not just dashboards.
At LATAM Airlines, I owned the full analytics stack for the Groups revenue channel, including:
Complex BigQuery business logic powering pricing and operations
Automated re-accommodation and quotation systems with near-zero error rates
Executive-level Looker Studio reporting used for real commercial decisions
Python ETL pipelines connecting multiple production systems
My work supported mission-critical, high-volume airline operations where data accuracy directly impacted revenue and customer experience.
In parallel, as Co-Founder & Data Systems Lead, I built a full end-to-end data platform for a consumer brand:
Automated ingestion across sales, marketing, operations, and finance
Demand forecasting, unit economics, and margin modeling
Full-funnel attribution (Shopify, Google Ads, Meta Ads)
Scalable reporting and decision systems used daily by the business
What I can help you with
BigQuery architecture, SQL modeling, and performance optimization
Python ETL pipelines and automated data workflows
Revenue, pricing, cohort, and unit-economics analytics
Executive dashboards that actually drive decisions
Fixing unreliable or slow analytics stacks
If you need someone who can own your data end-to-end, understand the business, and deliver clean, decision-ready analytics, I’m a strong fit.
Available for fixed-price projects and short consulting engagements.
Steps for completing your project
After purchasing the project, send requirements so Manuel can start the project.
Delivery time starts when Manuel receives requirements from you.
Manuel works on your project following the steps below.
Revisions may occur after the delivery date.
Understand intent and lock the expected grain
I review the query and expected output, confirm the “row contract” (grain), and identify likely failure modes (join explosion, wrong grouping, filter drift, NULL/duplicate behavior).
Debug correctness and fix logic
I fix joins, filters, aggregations, window logic, and edge cases to ensure correct results. Output becomes stable, explainable, and aligned with the requested grain.