Chicago, IL · Available

Andrew
Nguyen

01 / About

Data systems &
thoughtful design

I'm a Chicago-based data engineer who builds products at the intersection of analytics pipelines and consumer experiences. I care about the full stack — from ingestion schemas and transformation logic to the interface someone actually uses.

My passion projects live at the edge of data and culture: festival lineups, fantasy draft rooms, trivia nights, election maps. Each one is an excuse to build a real pipeline and ship something worth using.

Outside of code I collect vinyl records, tend to too many houseplants, and maintain strong opinions about Chicago neighborhoods.

Toolkit

Data

  • Python
  • dbt
  • SQL
  • Spark
  • Airflow
  • DuckDB

Web

  • Next.js
  • TypeScript
  • React
  • Tailwind

Cloud

  • Supabase
  • Vercel
  • GCP
  • Snowflake

APIs

  • Spotify
  • Sleeper
  • TMDB
  • OpenF1
  • FEC

02 / Projects

Things I'm building

Festival Analyzer

Artist intelligence for major US music festivals

Building

Autonomous data pipeline surfacing lineup analytics, artist metadata, streaming stats, and AI-generated insights for Lollapalooza and beyond.

Next.jsSupabasePythonSpotify APIClaude API

Draft Tool

Live and offline fantasy football draft intelligence

Building

Pipeline-driven web app for NFL fantasy: player intelligence, live draft assistance, trade optimizer, and waiver wire analysis.

Next.jsSupabaseSleeper APInflverse

Parlor

An after-dark house of trivia games

Building

Four trivia rooms over one daily question bank — The Board, The Clock, The Wedges, The Streak — forged from Wikipedia, Deezer, TMDB, and Sleeper.

Next.jsSupabasedbtDuckDBWikipedia API

Midterms 2026

Election analytics: PAC funding, polls, and economics

Planned

Five-tab analytics tool covering Super PAC/PAC funding flows, rolling poll averages, district-level historical results, issue polling, and economic indicators.

Next.jsFEC APIBLS APIFRED APID3.js
2026

F1 Tracker

Data storyboard for every race, driver, and team

Planned

Live telemetry, historical results, car design analysis, rivalry graphs, and budget-vs-performance correlation across the 2026 season.

Next.jsOpenF1 APIErgast APIPython
2026

CTA Analytics

Chicago transit data, staffing, and route design

Planned

GTFS-powered analysis of CTA bus and rail coverage gaps, staffing shortages, funding efficiency, and proposed route optimizations.

Next.jsGTFSChicago Data PortalD3.js
2026

Grocery

Shrinkflation, price inflation, and recipe discovery

Planned

Data journalism on food: supply chain origins, shrinkflation tracking, CPI food categories, and recipe discovery with real-time cost estimates.

Next.jsUSDA APIBLS CPISpoonacular API
2026

Kitchen

Ingredients as instruments; flavor profiles as motifs

Planned

Interactive music looper where each ingredient has a unique sound. Pair ingredients by flavor profile to build harmonic compositions.

Next.jsTone.jsWeb Audio APIFlavorDB
2026

03 / Contact

Let's talk

I'm open to interesting collaborations, data engineering roles, and side-project conversations. Drop me a note and I'll get back to you within a day.