Systems online · Data Engineer

Built for reliability.
Tuned for speed.

I ship production ELT on Snowflake, dbt, and Airflow — where pipelines behave like well-sorted engines: idempotent, observable, and ready for the long haul. By day I keep data platforms green. By night I obsess over cars.

Snowflake dbt Airflow / MWAA Python SQL AWS Cars 🏎️

Easter egg: press or hit Boost in the garage.

Muhammad Omar Farooq
Scale
4M+
Contacts in HubSpot ↔ Snowflake sync
Fleet
5+
Production systems on Snowflake + dbt
OSS
PyPI
Trustline published & versioned
Upstream
dbt
dbt-core contributor

Flagship build

// open-source garage
Active · CLI + API + Web

Deckflow

Spaced repetition for engineers who learn in git. Git-native decks, FSRS scheduling, review telemetry.

Early alpha

Flowpact

Workflow + success contracts for AI products — lock the definition of done before the build starts.

v0.1 kernel

Agent Dynamite

Governed SQL query gateway: policy, caps, and audit — the safe throttle for agents touching warehouses.

Portfolio case study

Fintech Lakehouse

Synthetic fintech ELT: Airflow, Parquet lake, DuckDB + dbt marts for payments and fraud.

Off the clock

// cars & craft

Why cars?

Same instincts as data engineering: systems under load, clear failure modes, and respect for the parts that keep everything running. I love the craft — chassis feel, instrument design, the quiet confidence of a well-tuned engine.

  • DAY JOBProduction ELT · reliability
  • NIGHT MODECars · design · telemetry vibes
  • SHARED DNAObservability · iteration · taste
Closed circuit · demo only

Upstream

// contributing

I contribute to dbt-core from production pain — not drive-by typos. Open PRs span:

catalog generation · fail-fast test validation · incremental backfill semantics

Explore my dbt-core pull requests →

What I ship

// engineering focus
  • Incremental ingestion — idempotent pipelines, cursor pagination, dedup-safe merges
  • Data modeling — dimensional models, SCD Type-2, analytics marts
  • Orchestration & CI/CD — Airflow on MWAA, Git-based deploys
  • Reliability — data quality & freshness frameworks, dbt tests
  • Observability — Snowflake procedures → Slack alerting
  • Data contracts — versioned, testable, reviewable boundaries

Track record

// experience

Software Engineer — Devsinc

Jan 2026 — Present

Own Snowflake + dbt ELT across 5+ production systems, including bidirectional HubSpot ↔ Snowflake sync over 4M+ contacts. Observability, alerting, CI/CD on MWAA.

Associate Software Engineer — Devsinc

Jan 2025 — Jan 2026

ETL/ELT with Airflow, Airbyte, dbt, SQL, Python. Dimensional models, SCD Type-2, automated validation.

AI Research Engineer — GrowthRune

Aug 2024 — Dec 2024

LLM retrieval (LlamaIndex, MongoDB Atlas, GPT-4) and multi-agent workflows with CrewAI.

B.Sc. Computer Engineering — UET Taxila

2020 — 2024

Bachelor's in Computer Engineering.