Recurring research and reporting need data that holds up to scrutiny. My work includes the pipelines that move it and the checks that catch problems along the way.
CONFIGCONFIGCONFIGCONFIGCONFIGCONFIGCONFIGCONFIG
VALIDATE shared engine
8research practices
Data engineering / Analytics
Maintaining a shared validation engine
The research practices had nearly identical validation scripts that were getting hard to maintain. I replaced them with a shared engine. Adding a practice now means updating its configuration.
The engine surfaces roughly 200 data-quality flags per full refresh cycle, based on my own estimate.
How I approached it +
I kept member data out of the AI coding workflow. The model saw only structure and aggregate diagnostics, and I used synthetic data to check the code. Comparing the results with a colleague’s manual count uncovered a join bug.
Python · Data validation · Synthetic fixtures
APIAlteryxBigQuery
Quarterlyrefresh ownership
Data engineering / Analytics
Owning a quarterly financial-data pipeline
I took over a recurring financial-index refresh and moved it from manual CalcBench entry into an API-driven Alteryx pipeline feeding BigQuery.
The work included the refresh itself, data-quality checks, documentation, and outlier detection in Tableau.
How I approached it +
The pipeline still needed someone to check the data each quarter. I owned that process alongside the migration, so the automation and the checks were maintained together.
Alteryx · BigQuery · Tableau · APIs
Data access / Research tools
A read-only research instrument browser
Part of the benchmark platform
I built a tool for browsing published benchmark instruments, filtering questions, and exporting modules to Excel.
How I approached it +
I used a read-only API so a colleague could explore the instrument without the tool being able to change the source content.
Python · Contentful · Excel
Data loading / Content operations
Loading research instruments from spreadsheets
Part of the benchmark platform
I built a loader that moves question, practice, and metric definitions from Excel into the CMS, with a result log for each row.
Python · Excel · Contentful
Reporting / Survey tools
Poll reports and survey dashboards
Part of the poll lifecycle
I created skills for preparing poll results reports and survey dashboards as part of the survey workflow.