I will build automated etl pipelines with python and sql
Business Intelligence Engineer
About this Gig
Organisations can struggle with messy data siloed across diferent systems. In my day to day job I am in charge of bridging that gap, designing the company's analytical layer and owning it end to end. I am hoping to help smaller companies or independent folks accomplish the same.
What I offer:
- Pull your data from APIs, databases, spreadsheets or files REST, JSON, SQL Server, Postgres, MySQL, BigQuery, Redshift
- Clean it, resolve entities across systems where identifiers differ, and validate it
- Model it properly so the numbers hold up under questions
- Automate it: daily incremental loads, idempotent upserts, rollback on every write
- Build the Power BI dashboard on top if you want one
Stack: Python, advanced SQL, PySpark, dbt, Databricks, Microsoft Fabric, AWS, Power BI.
Tell me what you're trying to accomplish and we can work from there!
Technology:
Python
•
SQL
FAQ
What do you need from me to start?
Access or sample files from your sources, and a description of what you want to see at the end. If it's an API, credentials or docs. I'll confirm scope before you order.
Will this run automatically after you deliver?
On Standard and Premium, yes — you get a scheduled refresh script and setup documentation. Basic is a one-time clean extract.
Do I get the source code?
Included on Standard and Premium. Available as an extra on Basic.
My data is messy and inconsistent across systems. Is that a problem?
No, that's the normal case. Cross-system entity resolution where identifiers don't match is a routine part of the work.
