Omar Farooq Omar Farooq
Available for data engineering roles

Muhammad Omar Farooq
Data Engineer

I build production ELT on Snowflake, dbt, and Airflow — where reliability beats demos. I open-source the hard parts: data contracts, governed query gateways, and developer tooling.

View Trustline on PyPI LinkedIn Email me
Snowflake dbt Airflow / MWAA Python SQL AWS DuckDB
Muhammad Omar Farooq
4M+
Contacts in a bidirectional HubSpot ↔ Snowflake sync
5+
Production systems on Snowflake + dbt
PyPI
Published open-source package (Trustline)
dbt-core
Upstream contributor

Flagship project

// what I'm building
Open source · Apache-2.0 · on PyPI

Trustline

An open-source trust layer for data products. Trustline compiles human-writable YAML contracts into SQL checks and produces a measurable integrity scorecard across ETL, ML, and delivery seams — because business systems fail at the boundaries. 

$ pip install trustline
$ trustline audit --demo
Python DuckDB + Snowflake executors YAML → SQL compiler CI · releases · docs Slack integration
Active · CLI + API + Web

Deckflow

Spaced repetition for engineers who learn in git. Git-native deck projects, FSRS scheduling, rich review telemetry. Python, FastAPI, React.

Early alpha

Flowpact

Human-writable workflow + success contracts for AI products. A CLI that derives client ask-lists and no-claim gates from one pact.yaml.

v0.1 kernel

Agent Dynamite

A governed SQL query gateway with policy enforcement, result caps, and audit logging over DuckDB and Postgres — the safe path for agents to touch data.

Portfolio case study

Fintech Lakehouse

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

Open source & community

// contributing upstream

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

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

Explore my dbt-core pull requests →

What I do

// core focus
  • Incremental ingestion — idempotent pipelines, cursor pagination, dedup-safe merges, timestamp-resume on failure
  • Data modeling — dimensional models, SCD Type-2 history, marts for BI and product analytics
  • Orchestration & CI/CD — Airflow on Amazon MWAA, Git-based deploys for data pipelines
  • Reliability — data quality & freshness frameworks, dbt tests, validation rules
  • Observability — failure detection via Snowflake procedures with Slack alerting
  • Data contracts — treat contracts like APIs: versioned, testable, reviewable

Experience

// track record

Software Engineer — Devsinc

Jan 2026 — Present

Own Snowflake + dbt ELT across 5+ production systems, including a bidirectional HubSpot ↔ Snowflake sync over 4M+ contacts. Built observability/alerting and CI/CD on MWAA. Promoted from Associate Engineer.

Associate Software Engineer — Devsinc

Jan 2025 — Jan 2026

Built ETL/ELT pipelines with Airflow, Airbyte, dbt, SQL, and Python. Designed dimensional models with SCD Type-2 tracking and automated data validation frameworks.

AI Research Engineer — GrowthRune

Aug 2024 — Dec 2024

Built LLM retrieval systems (LlamaIndex, MongoDB Atlas, vector search, GPT-4) and multi-agent workflow automation with CrewAI.

B.Sc. Computer Engineering — UET Taxila

2020 — 2024

Bachelor's in Computer Engineering.