Projects
An automated ELT pipeline on AWS that loads 40M+ federal defense contract transactions into a tested dbt star schema and a Power BI dashboard.
A dbt and DuckDB pipeline comparing wages, job concentration, and cost of living for data-engineering-adjacent roles across five U.S. metros, using BLS and Census data.
A Python pipeline that pulls the EIA's Short-Term Energy Outlook to analyze Texas shale oil production trends, outlier years, and how production responds to price.