I will fix and optimize your python and sql data workflows
Data Warehousing, Data Modeling and ETL Engineer
Informazioni su questo servizio
When a Python job fails, a SQL query slows down or report totals stop matching, I help you find the cause and get the data workflow back into a usable state.
I have 7+ years of data engineering and analytics experience, including reconciliation, workflow recovery and SQL optimization.
Diagnosis gives you reproducible findings and a repair plan. Repair includes a fix for one agreed issue, regression checks and handover notes. The improvement package addresses one agreed performance or reliability goal, with before-and-after checks and documented changes. Specific speed or cost reductions depend on the system and are not guaranteed.
The FAQ defines the code and workflow limits. I work on copies or in a staging environment and preserve original inputs. New features, full rewrites, data-entry work, scraping and production changes need a separate scope.
Send the error or slow query, a sanitized example and the expected output before ordering. We will confirm the issue, access and acceptance criteria. Revisions cover the agreed task.
Tecnologia:
Excel
•
Python
•
Altro
Il mio portfolio
FAQ
What does each package include?
Diagnosis reviews one issue in a script or query up to 300 lines and provides findings, without implementation. Repair fixes one agreed issue within that limit. Premium covers one workflow, up to 3 related scripts/queries and 600 lines, with one agreed improvement goal.
How will you verify the fix or improvement?
We agree on the expected output and a reproducible test. I compare results before and after the change, check relevant edge cases and provide the code and run notes. For performance work, we agree on the dataset and runtime; a particular speedup is not guaranteed.
Can you work on a live system or a larger codebase?
Fixed packages use copies or an agreed staging setup. I preserve source files and flag uncertain data. Larger codebases, new features and production changes need a separate scope. Please send sanitized samples and logs, never passwords or API keys.
