Skip to content

Aakash Madabhushi

Data Engineering

I build the pipelines that feed dashboards and models, and the checks that keep bad data from reaching either.

A year at Sapaad building production pipelines on Databricks and PySpark: more than five million rows a day across a multi-tenant SaaS platform, feeding recommendation features and over 75 tenant dashboards. That included tuning ten or more Spark jobs for a 43% cut in p95 dashboard query latency, and a Delta Lake data quality framework whose schema and freshness checks caught 14 anomalies automatically, because those pipelines fed production ML.

The same discipline runs through my own work: an Airflow, dbt, and Snowflake medallion pipeline that reduced 27.1 million Zeek network flows into a graph a model could train on; a taxi platform built twice, once as a batch warehouse and once as a streaming pipeline with a dead-letter topic; and pre-training quality gates in my research that refuse to hand a corrupted tensor to a training run.

5M+
rows a day through multi-tenant ETL at Sapaad
75+
tenant dashboards served by the Spark jobs I tuned
43%
p95 dashboard query latency cut, 12.4 s to 7.1 s
27.1M
Zeek network flows aggregated by the capstone pipeline

8 projects in this area

Every link goes to code or data you can inspect yourself.

  • System diagram of the taxi platform: data sources feeding Airflow-orchestrated jobs into a Snowflake warehouse, then out to BI dashboards.

    Served the same taxi data to dashboards and to live monitoring, by building it twice: a scheduled Airflow, dbt and Snowflake warehouse joined with weather, and a Kafka path that validates trips on arrival and publishes rolling metrics.

    Data Engineering

    Personal project · Nov to Dec 2025

  • Two charts from the report: a bar chart ranking which features predict delay, and a pie chart showing the top five predictors against all other factors.

    Reached 0.711 F1 predicting flight delays across 9.5 million U.S. flights, by training a Spark MLlib random forest on 15 monthly BTS files and running it inside a Kafka stream so each incoming flight gets a probability within seconds.

    Data EngineeringML Engineering

    SJSU big data course, team project · Dec 2025

  • Surfaces Wikipedia pages turning contentious in real time, by streaming every English edit through Kafka as it happens and scoring the tone of each edit summary with RoBERTa.

    Data EngineeringML Engineering

    Personal project · Nov 2025

  • System architecture diagram of the stock analytics pipeline, tracing ingestion through Airflow and Snowflake to dbt models and the BI layer.

    Keeps a full history of every revision to the data, by loading daily stock prices into Snowflake on an Airflow schedule and computing the indicators traders actually use as dbt models with snapshots.

    Data Engineering

    Personal project · Oct to Nov 2025

  • Makes articles searchable by meaning rather than exact keywords, by embedding them with Sentence Transformers on an Airflow schedule and serving nearest-neighbour lookups from a Pinecone index.

    Data EngineeringAI Engineering

    Personal project · Nov 2025

  • Let each part of the system fail and recover independently, by rebuilding a Yelp-style application so services communicate through Kafka events instead of calling each other directly.

    Software EngineeringData Engineering

    SJSU DATA 236, Distributed Systems · Spring 2026

  • Benchmark chart comparing single-instance against multi-replica deployment at 500 concurrent threads, plotting response time beside requests served.

    Kept résumé parsing and embedding matching off the request path across 17 containers, by routing them through Kafka and caching profile reads in Redis for 6× faster repeat lookups, with an AI assistant that pauses for human approval.

    Software EngineeringAI EngineeringData Engineering

    SJSU DATA 236, Distributed Systems · Spring 2026

  • Reached 0.90 F1 flagging suspicious host pairs in 27.1 million Zeek flows, by condensing them into a connection graph with Airflow, dbt and Snowflake, classifying links with a graph neural network, and having Llama 3.3 explain each alert.

    ML EngineeringAI EngineeringData Engineering

    SJSU capstone, team project · Feb to May 2026

Select a project for the full detail and links.

Data Engineering

NYC Taxi Data Platform: Batch and Streaming

Served the same taxi data to dashboards and to live monitoring, by building it twice: a scheduled Airflow, dbt and Snowflake warehouse joined with weather, and a Kafka path that validates trips on arrival and publishes rolling metrics.

Personal project · Nov to Dec 2025

System diagram of the taxi platform: data sources feeding Airflow-orchestrated jobs into a Snowflake warehouse, then out to BI dashboards.

Built with

  • Airflow
  • PySpark
  • dbt
  • Snowflake
  • Kafka
  • Docker
Data EngineeringML Engineering

U.S. Flight Delays: Batch Analytics to Real-Time Prediction

Reached 0.711 F1 predicting flight delays across 9.5 million U.S. flights, by training a Spark MLlib random forest on 15 monthly BTS files and running it inside a Kafka stream so each incoming flight gets a probability within seconds.

SJSU big data course, team project · Dec 2025

Two charts from the report: a bar chart ranking which features predict delay, and a pie chart showing the top five predictors against all other factors.

Results

9.5M
flight records processed, 15 monthly BTS files totalling 3.1 GB
0.711
F1 for the random forest on a stratified 20% test split, 79.1% accuracy
0.3%
train-minus-test accuracy gap, against 1.6% for a single decision tree
78%
of random-forest importance mass held by the top five features

Built with

  • Python
  • PySpark
  • Spark MLlib
  • Spark SQL
  • Kafka
  • Structured Streaming
  • Streamlit
  • Docker
Data EngineeringML Engineering

Live Wikipedia Edit Sentiment

Surfaces Wikipedia pages turning contentious in real time, by streaming every English edit through Kafka as it happens and scoring the tone of each edit summary with RoBERTa.

Personal project · Nov 2025

Built with

  • Python
  • Kafka
  • RoBERTa
  • Hugging Face
Data Engineering

Stock Market Analytics Pipeline

Keeps a full history of every revision to the data, by loading daily stock prices into Snowflake on an Airflow schedule and computing the indicators traders actually use as dbt models with snapshots.

Personal project · Oct to Nov 2025

System architecture diagram of the stock analytics pipeline, tracing ingestion through Airflow and Snowflake to dbt models and the BI layer.

Built with

  • Airflow
  • dbt
  • Snowflake
  • Docker
Data EngineeringAI Engineering

Semantic Article Search Pipeline

Makes articles searchable by meaning rather than exact keywords, by embedding them with Sentence Transformers on an Airflow schedule and serving nearest-neighbour lookups from a Pinecone index.

Personal project · Nov 2025

Built with

  • Airflow
  • Sentence Transformers
  • Pinecone
  • Docker
Software EngineeringData Engineering

Event-Driven Yelp Clone

Let each part of the system fail and recover independently, by rebuilding a Yelp-style application so services communicate through Kafka events instead of calling each other directly.

SJSU DATA 236, Distributed Systems · Spring 2026

Built with

  • JavaScript
  • Kafka
  • Docker
Software EngineeringAI EngineeringData Engineering

LinkedIn Simulation with an AI Recruiting Assistant

Kept résumé parsing and embedding matching off the request path across 17 containers, by routing them through Kafka and caching profile reads in Redis for 6× faster repeat lookups, with an AI assistant that pauses for human approval.

SJSU DATA 236, Distributed Systems · Spring 2026

Benchmark chart comparing single-instance against multi-replica deployment at 500 concurrent threads, plotting response time beside requests served.

Results

17
containers across 5 service groups
faster repeat profile lookups, under 100 concurrent users

Built with

  • FastAPI
  • Kafka
  • LangGraph
  • React
  • MySQL
  • MongoDB
  • Redis
  • Docker
ML EngineeringAI EngineeringData Engineering

Explainable Network Threat Detection

Reached 0.90 F1 flagging suspicious host pairs in 27.1 million Zeek flows, by condensing them into a connection graph with Airflow, dbt and Snowflake, classifying links with a graph neural network, and having Llama 3.3 explain each alert.

SJSU capstone, team project · Feb to May 2026

Results

27.1M
Zeek network flows aggregated into the graph
0.90
F1 on 329 held-out host-pair links, 0.94 precision and 0.87 recall
0.87 s
median end-to-end latency per generated explanation

Built with

  • PyTorch Geometric
  • Airflow
  • dbt
  • Snowflake
  • Pinecone
  • Llama 3.3

Hiring for data engineering?

I'm available from December 2026 and open to relocating. Email me and I'll reply within a day.

Hiring for something else?