The Last Degree – Graduate ROI Intelligence
An end-to-end intelligence platform that bridges the gap between educational investment and job market reality. By unifying university data, live job listings, and layoff trends, the platform provides data-driven career insights via a modern web interface and an AI-powered SQL agent.
Technical Overview:
Backend & Data Engineering: Orchestrated complex ETL/ELT pipelines using Apache Airflow to ingest and unify disparate university, Adzuna job market, and BLS datasets into Snowflake. Resolved data fragmentation by implementing fuzzy-joins and lookup tables for missing primary keys.
AI & Analytics: Architected an LLM-based SQL Agent to allow natural language querying of complex ROI datasets. Integrated an Apache Superset dashboard for enterprise-level visualization of layoff trends and market volatility.
Frontend & UI/UX: Developed a high-performance, responsive interface (https://thelastdegree.dev/) to visualize Graduate ROI ratios, active job distributions, and real-time WARN notice trends.
Key Achievement: Created a unified data model across 6,400+ institutions and 21k+ active job listings to calculate real-time career "Return on Investment."