01 / Public Data Engineering
OpenTheBooks Public Data & Housing Analytics
Built Streamlit analytics for IRS migration and public-data research, then extended the work into housing affordability analysis across all 50 states using FHFA House Price Index and Census ACS income data.
- Problem
- Public datasets were spread across sources and needed cleaning, validation, reconciliation, and recruiter-readable analysis.
- Built
- Interactive analytics surfaces for county-level migration, AGI flows, trend comparison, and affordability research workflows.
- Technical decisions
- Python, Streamlit, Pandas, SQL-style transformations, validation checks, and clear public-policy visualizations.
- Result
- Supported published OpenTheBooks analysis and made complex migration/housing data easier to inspect.