Customers
Request a part by car or VIN, compare graded offers, and earn points that come off the delivery fee.
Yahya Zobi
Analytics engineer and BI developer
Tripoli, Libya
Analytics Engineer, Presto
Data & Digital Products Lead
Co-founder, Tarfi
I build the data layer companies run on: pipelines, warehouses, and the Power BI dashboards executives open every morning.
Five years building the systems people decide with: refugee data for UNHCR, program monitoring for UNFPA, SPARK and the EU, executive reporting for Libya’s oil sector, and now the first data warehouse at Presto. I care about the pipeline and the pixels in equal measure.
- 5+
- years in data and analytics
- 6
- organizations, UN to private sector
- 150+
- dashboards designed
- 690+
- students across three Udemy courses
EUBAM Libya
Presto’s first data warehouse
For six years every report at Presto queried the production database directly. Numbers disagreed and the app paid for every query. I designed and built the platform that replaced that, on AWS, from the first Terraform file up.
-
Overview
One copy of the truth
The whole app database now lives in a warehouse built for questions, with every change kept, every layer tested, and production left alone.
336source tables copied into the warehouse -
01 Extract
Copy it exactly as it is
AWS DMS copies the MySQL app database exactly as it is: one full load, then every insert, update and delete, with the bulk copy taken from a read replica so production is never asked twice. AWS Glue jobs bring in MongoDB, BigQuery and Odoo.
4 h 32 minto copy all 336 tables, with zero errors -
02 Load
Land it twice
Every source lands in S3 as Parquet, the permanent, encrypted archive. A Python loader copies it into append-only raw tables in Redshift and checks every batch against the source.
1,150,383,060rows reconciled by row count and hash -
03 Transform
Clean, then model
dbt builds every layer inside Redshift. Silver types and cleans each source and keeps its current state. Gold models facts and dimensions around business questions, with every metric defined once.
20 + 13Silver and Gold models, with tests and contracts -
04 Serve
Everyone reads Gold
Gold is the only layer analysts and dashboards read. Power BI and Metabase run on Gold, refreshed by the pipeline, so every number traces back to one model.
5Gold marts built and tested -
05 Platform
Everything is code
Terraform for infrastructure, reviewed pull requests with CI on every change, least-privilege roles behind MFA, and a customer-managed key on the archive.
0long-lived access keys -
06 Automated
Running on its own
All four sources, MySQL, MongoDB, BigQuery and Odoo, now run on automated pipelines that keep the Power BI and Metabase dashboards fresh. Next up is machine learning on Gold.
4 / 4sources on automated pipelines
Car parts, found and delivered.
- 3apps in one: customer, vendor, driver
- Approved on the App Store and Google Play
- عArabic-first, Libyan dialect
Finding a spare part in Tripoli means calling shop after shop. With Tarfi you ask once: new-parts shops and salvage yards send competing offers, you pick one, and a Tarfi driver brings it to your door. The slogan says it: طرفك. لعندك, your part, brought to you.
I co-founded Tarfi and built the whole product myself: one app with three sides, for customers, vendors and drivers.
- Role
- Co-founder, sole technical builder
- Platforms
- Approved on the App Store and Google Play
- Language
- Arabic-first, written in Libyan dialect
- Stack
- Next.js, TypeScript, Supabase, Capacitor
- 01
The promise, first
The opening screen says it all: طرفك. لعندك. New and used parts, from Tripoli’s shops and salvage yards.
- 02
Ask for a part
Save your car once, then ask for a new part from shops or a used one from salvage yards (رابش).
- 03
Compare offers, not shops
Offers arrive graded A to C with price and donor car. The vendor stays anonymous until you buy, which keeps the marketplace fair.
- 04
Track it to your door
A Tarfi driver collects the part and brings it to you, with every step visible in the app.
- 05
The vendor side
Shops see live requests that match the brands they stock and send an offer in seconds.
9:41
9:41
9:41
9:41
9:41
App StoreGoogle Play
Vendors
Parts shops and salvage yards quote on live requests. Their identity stays hidden until the sale.
Drivers
Claim deliveries, photograph pickup and drop-off, and confirm cash collected, all in the same app.
subevoESP lifecycle platform
One platform for the life of every ESP.
When a well can’t flow on its own, an electric submersible pump lowered into it lifts the fluid to the surface. I designed and built Sublevo to handle that pump’s whole life in one place.
Loading the 3D model
Drag to turn it. Schematic geometry, representative internals. Built at 
subevo
One platform for the life of every ESP.
A working product preparing for its first pilot. Built at 
VANTAGE
Built for
Finance and people for the whole group, in one place.
Vantage is the finance and HR app I designed and built for PETGO: consolidated figures across its entities, budgets, cash and payroll, in Libyan dinars, dollars or euros.
P4 ANALYTICS
Built for
Every Presto partner, read in one place.
P4 Analytics is the partner performance tool I designed and built for Presto Libya: who needs attention first, who leads each vertical, and where and when the orders come in.
Figures shown are altered for confidentiality.
Dashboards
Power BI and Figma work for oil and gas, food delivery, automotive and music streaming. Built for executives who want the answer first and the detail one click away.
Power BIFigma
All figures shown are sample data.
Keep scrolling
NOC Operations Overview
Built at PETGOExecutive view of budget use, production and operational efficiency, unplanned downtime and milestones across four operating companies.
NOC Strategic Report
Built at PETGOBoard-level report on remaining budget, oil and gas production trends, net profit, milestones and where products ship.
Presto 2025 Overview
Built at PrestoRevenue, orders, active users and drivers, split by city across Tripoli, Benghazi, Misrata and Sabha.
BMW Insights
Personal projectFive years of sales by model, region and channel, with top sellers anchored by model imagery.
Spotify Streaming
Personal projectStreams by artist, track and release decade, with a weekly listening heatmap.
Experience
From UN field programs to a food delivery platform. The constant is building the data systems people decide with.
-
2026 – now, Tripoli
Analytics Engineer
Presto Food delivery, Libya and Tunisia- Built the first data warehouse in Presto’s history: DMS, S3, a Python loader and Redshift Serverless, modeled in dbt across Bronze, Silver and Gold.
- Copied 336 tables and reconciled 1.15 billion rows against the source; 20 Silver and 13 Gold models with tests and contracts.
- Designed and built P4 Analytics, the partner performance tool for Presto Libya: attention flags, fair rankings, a revenue map and peak times.
- Connected MySQL, MongoDB, BigQuery and Odoo to automated pipelines that feed the Power BI and Metabase dashboards.
- Designed 21+ production KPIs and a company-wide KPI dictionary agreed with Product, AI and Customer Experience.
- Built driver-utilization and SLA reporting that surfaced redispatch and idle-time patterns operations could act on.
AWS, Redshift, dbt, Terraform, Python, SQL, Power BI, Metabase
-
Apr 2024 – now, Tripoli
Data & Digital Products Lead
Oil and gas services and software, Libya, Oman and CanadaOwns everything data at PETGO, from pipelines and engineering to reporting and KPIs, and designs and builds the company’s digital products.
- Runs analytics end to end: data pipelines, data engineering, reporting and KPI frameworks, including the NOC Operations and Strategic Report dashboards across four oil companies.
- Built Vantage, PETGO’s internal finance and HR ERP.
- Built Sublevo, PETGO’s ESP (electric submersible pump) software platform.
- Designed PETGO’s new brand identity, logo and website.
- Built a sectional performance radar and an annual financial reporting pipeline for Waha Oil Company.
Power BI, DAX, SQL, Python, Microsoft Fabric, Next.js, Figma
-
Oct 2023 – Jun 2025, remote
Monitoring and Evaluation Officer
International NGO- Owned the M&E frameworks, data collection tools and dashboards behind donor reporting across several Libyan cities.
-
Mar – Oct 2023
Project Admin and M&E Officer
EUBAM Libya EU Border Assistance Mission- Ran data flows and reporting for the mission, with operational dashboards for mission leadership.
-
Oct 2021 – Jun 2022, Tripoli
Information Management Associate
- Managed refugee registration and reporting systems, and produced data summaries for operational planning and donors.
-
Feb 2020 – Oct 2021, Tripoli
Monitoring and Evaluation Consultant
UN Population Fund- Built results-based monitoring systems to UNFPA standards and turned survey and field data into evidence for donor reports.
Toolkit
Data engineering
AWS DMS
AWS Glue
dbt Core- Apache Airflow
- Databricks
- PySpark
- Terraform
Warehousing
Amazon Redshift
Amazon S3- BigQuery
- PostgreSQL
- MySQL
- MongoDB
Analytics and BI
- Power BI and DAX
Metabase- Tableau
- Excel
- Figma
Build
- SQLSQL
- Python
- TypeScript
- Next.js
- Supabase
- Git
Instructor on
Teaching
I teach what I practice. Three Udemy courses on dashboard design and Power BI certification, taken by more than 690 students.
- Students
- 692
- Courses
- 3
- Topics
- Power BI, Excel, PL-300
Power BI Design Mastery
Visual hierarchy, color, typography and layout for clear, executive-ready Power BI dashboards.
240 studentsView on
PL-300 Power BI Exam Mastery
A fast track to the Microsoft Power BI Data Analyst certification, with practice questions and exam strategy.
331 studentsView on
Excel Dashboard Design Mastery
Interactive, executive-level Excel dashboards with PivotTables, slicers and clear design rules.
121 studentsView on
Certifications
- PL-300 Power BI Data AnalystMicrosoft Certified
- AWS Cloud PractitionerAmazon Web Services
- Databricks Data EngineerDatabricks Academy
Have a role or a project in mind?
Every message comes straight to me.
Email is fastest, WhatsApp works too.
Fastest way to reach me
Email
yahya.zoubi94@gmail.com
Based inGMT+2
Tripoli, Libya
--:--:00
Tripoli time
Email address copied
Yahya ZobiAnalytics engineer and product builder, Tripoli
Back to top
Designed and built by Yahya Zobi, 2026.