John Houghton
Senior data and AI engineer in San Diego. Economist by training, builder by habit. Available for consulting engagements and select full-time roles.
Things I've built
SD Open Data Pipeline
End-to-end pipeline for San Diego open data: Dagster orchestration, dbt models, DuckDB spatial joins to council districts, and CI with full test coverage.
DagsterdbtDuckDB spatialCIRepository →
LLM Dataset Curation
Tooling for building, filtering and auditing training and evaluation datasets for language models. TODO link + one-line result
LLMsdata qualityVision Lab · Local AI Showcase
Real-time camera vision and voice agents running fully on-device on a Mac Studio M3 Ultra, with event recording, data-quality checks and privacy redaction.
on-devicevisionvoiceFinance Wizard
An agent-first personal finance app: FastAPI and React with interactive ECharts models, scenarios and dashboards.
FastAPIReactagentsPersonal Finance Lake
A local lakehouse on DuckDB and dbt that ingests bank feeds, enriches transactions and reconciles them nightly.
DuckDBdbtlaunchdMulti-Agent Assistant
A team of cooperating AI agents for research, scheduling, note-keeping and security review, with human approval on every outbound action.
agentsorchestrationWhere I've worked
Education & training
B.A. Economics
San Diego State University, 2011
Machine Learning Specialization
University of Washington, 2017
Data Mining Certificate
UC San Diego Extension, 2017
Outside the terminal
Local-first and private AI, economics and markets, civic open data, and rare books. TODO confirm / add interests (e.g. endurance sports)