Transparent Utah.

Every Utah taxpayer technically has the right to see exactly where their money goes — every contract, every salary, every coffee bought on a state P-card. In practice, that data sat in spreadsheets nobody could query and dashboards nobody could read.

My job: rebuild the platform so a school-board parent, an investigative journalist, and a state auditor can all answer their actual question in under a minute — without anyone needing to learn SQL.

Designed the Entity Overview Dashboard from scratch — KPI cards, grouped tabs, deep-linkable URLs for every drill-down. Built it in React + TypeScript with strict accessibility (WCAG AA, keyboard-first navigation, screen-reader tested).

Wrote the data layer in Python + Flask against BigQuery, with custom ETL pipelines that pull from the state's general ledger systems. Schema designed to handle billions of records with sub-second drill-downs.

Built the visualizations in D3.js — Days Cash on Hand chart, unrestricted cash trends, revenue trend with YoY/6-Year comparison toggle, all themed to the Transparent Utah brand (teal `#2E8B8B` for chrome, sky blue reserved as a functional health indicator).

Established the codebase conventions on the way in: BEM `tu-` namespace, Outfit + Barlow Condensed type, one CSS property per line, pre-computed conditionals before JSX. The kind of standards that make a 79-commit PR reviewable instead of catastrophic.

Used by all 41 Utah school districts. Auditors trust it. Journalists cite it. Parents understand it. Behind the dashboard: billions of records, served fast, audited every quarter.