Then I build the dashboards and alerts that tell you what to scale, fix or stop.
How your data becomes decisions
If any of these sound familiar, they're all fixable.
Your numbers don't match across platforms
Your reporting lives in exports and spreadsheets that break silently
You don't know which ads to scale or switch off
Your CRM, accounting and ad data never meet
Nobody notices when a dashboard shows stale data
Three steps from scattered data to clear decisions.
We map your tools, data sources and the decisions you're trying to make. I tell you honestly whether a warehouse is worth it or a simpler setup will do.
Scheduled, incremental pipelines into BigQuery, modelled in dbt with tests. Code in Git, dev and prod kept apart.
Looker Studio on the modelled layer, Slack or email alerts. I check the numbers against your source before you see them, and document what I build.
Data Engineer · ads, CRM and accounting data
Most of my clients have the same problem: the data exists (Meta, Google Ads, TikTok, Pipedrive, bexio, booking tools, spreadsheets) but it lives in separate exports, breaks silently and nobody agrees on the numbers. I fix that end to end, from the API pull to the report people open every morning.
Based in Germany (CET), working in English and German.
Platforms I work with
Built with
Problem
Reports built from manual exports that go stale.
What you get
Python and n8n pulls from APIs (ad platforms, CRMs, accounting, Google Drive): scheduled, incremental, deduplicated, re-runnable.
Data engineering projectsProblem
Every dashboard re-stitches the same messy tables.
What you get
BigQuery with layered dbt (staging → intermediate → marts), business rules as code, tests on the tables that matter.
Data engineering projectsProblem
Dashboards show what happened, not what to do.
What you get
Looker Studio on the modelled layer, metrics defined once; Slack or email alerts when something needs action or data goes stale.
Dashboard & alert projectsFixed-scope offer
Your spend and ROAS rules as code, on Meta and TikTok data in BigQuery. A Slack message every morning with the ads to switch off, and an email to me if the data is stale.
Also: internal tools with AppSheet and Apps Script → recruitment app case study
100% Job Success · Top Rated on Upwork · 20 jobs · 429 hours
"Yassin was exceptional. My projects were completed on time and to the level expected. He was able to quickly understand what was needed and complete the work to a very high standard…"
"We can recommend Yassin 100%. Firstly, he is a great person to work with and showed very nice work ethic. He is very responsive and manages to turn around tasks quickly."
"I recently worked with Yassin on creating a profit calculator tailored to my business numbers, and I couldn't be happier with the result. He was professional, efficient, and really took the time to understand my needs."
Real projects, client names left out.
Problem
Two brands, Meta and TikTok, EU and US accounts. A Google Sheets setup timed out silently, and a purchase double count inflated ROAS.
Built
Meta + TikTok data in BigQuery and dbt, the client's spend and ROAS rules in one CSV, a Slack message every morning with the ads to switch off, freshness checks before every run.
Result
106 losing ads flagged in the first 13 days. Spend on them dropped by about half.
Problem
CRM, accounting and booking data in three tools, one of them with no API. Reporting meant manual exports.
Built
Pipedrive, the accounting system and the booking tool automated into BigQuery with n8n, Apps Script and dbt.
Result
The full path from inquiry → quotation → revenue → returning patient, across 7 years of data.
Problem
1,000+ client accounts, Google Ads, Meta and GA4 data in many inconsistent tables, no way to check whether Meta's leads reached the landing page.
Built
A BigQuery star schema, daily to 30-day alerts on spend, CPA, CTR and ROAS per ad group, a Meta vs landing-page lead check.
Result
One model for 1,000+ accounts. The lead check caught alignment dropping from 97% to ~57%.
Pipelines, warehouses, dashboards and internal tools.
See all 8 projectsSend me what you're trying to decide. I'll tell you honestly whether a warehouse is worth it or a simpler setup will do.
yassin-abouzeid@ydalabs.com · or hire me on Upwork, Malt or Contra