Medical economics and VBC analytics
PMPM trend, capitation and shared-savings modeling, risk stratification, attribution, bundled-payment analysis, HEDIS and quality reporting.
Healthcare analytics · Phoenix, AZ
I turn messy healthcare data into numbers people can act on.
Medical economics analyst at HOPCo, founder of Data Hound Technologies, adjunct in health informatics at GCU.
What I do
Four things, done carefully.
Most engagements are some mix of these. The common thread is claims data, real money, and an audience that needs a straight answer.
Data engineering for analysts
SQL Server and Snowflake ETL, DuckDB and Parquet pipelines, Python automation, Power BI and Tableau delivery.
Automation and small software
n8n workflows, Flask and FastAPI services, Raspberry Pi and Docker deployments, digital signage.
Teaching and translation
Graduate health informatics instruction, and explaining analytics to clinical, operations, and finance audiences.
Selected work
Real projects, described plainly.
Public tools and consulting work I can talk about. Employer analytics stay at the employer.
Healthcare Price Transparency
Public hospital rate lookup · healthcare.traqqit.com
- Problem
- Hospital negotiated-rate files (machine-readable MRF data) are huge and unusable for a patient or a small practice trying to compare prices.
- Built
- A DuckDB and Parquet pipeline that ingests and normalizes negotiated rates, with a FastAPI backend and a web front end for looking up rates by procedure and payer (initial focus: Anthem PPO).
- Outcome
- A working public lookup tool, and the groundwork for an orthopedics-focused variant.
- Python
- DuckDB
- Parquet
- FastAPI
- Hostinger
Medical bill review automation
Data Hound Technologies · intake pipeline
- Problem
- Reviewing and negotiating medical bills is manual: read the bill, pull the codes, check them against expected rates, draft the dispute.
- Built
- n8n workflows with OCR that extract line items from uploaded bills and stage them for review and negotiation.
- Outcome
- A repeatable intake-to-review pipeline for the bill negotiation service.
- n8n
- OCR
- Python
Digital signage for pickleball clubs
Data Hound Technologies · managed service
- Problem
- Franchise locations need court schedules, league flyers, and hours on screens without staff managing content by hand.
- Built
- A Yodeck-based managed signage service: configured players, content templates, remote updates, annual contract.
- Outcome
- Live at franchise locations under a managed annual agreement.
- Yodeck
- Managed service
About
Analyst first, builder second, teacher on Tuesdays.
I'm a healthcare data analyst in Phoenix. By day I do medical economics at HOPCo, a musculoskeletal value-based care company. Before that I worked on ACO performance and population health at OnBelay Health Solutions, Equality Health, and ACO Partner, mostly in SQL, Python, and Power BI, mostly on claims.
On the side I run Data Hound Technologies, teach graduate health informatics at Grand Canyon University, and build small tools that live at traqqit.com. I like problems where the data is messy, the money is real, and someone has to explain the answer to a non-technical room.
- 2026 – presentHOPCo Medical Economics Analyst
- Apr 2025 – presentGrand Canyon University Adjunct Graduate Faculty, Health Informatics (HIM-650, HCI-690; previously HIM-615)
- Oct 2024 – presentData Hound Technologies Founder and business solution architect. Platform data migrations for small businesses, inventory and membership systems, and website projects for the New York Auto Show, Persian Carpet, Bright's Nutrition, and A&M Roofing.
- Feb 2023 – Oct 2024OnBelay Health Solutions Senior Business Analyst. Actuarial dashboards, capitation modeling, risk stratification with claims and ADT data, on an MS SQL warehouse I built and maintained.
- Dec 2021 – presentPickleball Kingdom Technology Director. POS, member management, tournament administration, court reservations, KPI reporting, franchise tech support, and geographic analysis for franchise development.
- Jan 2020 – Jan 2023Equality Health Population Health Analyst. HEDIS automation, value-based payment modeling, and geographic opportunity analysis in Tableau and SQL.
- Jun 2016 – Dec 2019ACO Partner Business Intelligence Analyst III. Shared-savings financial modeling, a referral network built on longitudinal claims analysis, and real-time ED and inpatient alerting through HealthCurrent.
- Aug 2015 – Dec 2016Arizona State University MS, Biomedical Informatics
- Aug 2011 – May 2015Southern Illinois University Edwardsville BS, Biological Sciences. Minors in chemistry, forensic science, and business administration.
Skills
The stack I actually use.
Data
- SQL (T-SQL, PostgreSQL, MySQL)
- Python
- R
- DAX
- DuckDB
- Parquet
- Data warehouse design
Platforms
- SQL Server
- Snowflake
- Databricks
- Epic Clarity / Caboodle
- Power BI
- Tableau
Build
- Flask
- FastAPI
- n8n
- Docker
- GitHub Actions
- Raspberry Pi
- Grafana
- InfluxDB
- ESPHome / MQTT
- Tailscale
- Cloudflare Tunnels
Domain
- ACO / MSSP
- Medicare Advantage
- HEDIS
- Risk adjustment
- Capitation
- Bundled payments
- Price transparency (MRF data)
- Actuarial modeling
- Trend analysis
Writing
Notes on luck, habits, and expensive lessons.
I write an occasional newsletter on Substack. Serendipity Sundays was the weekly version. These are the longer pieces.
May 2025
Serendipity is what you do with luck
Luck is finding a $100 bill on the sidewalk. Serendipity is what happens next.
Mar 2025Greasing the Groove
Mastering pull-ups programmatically: frequent, easy sets instead of rare, hard ones.
Apr 2024From Casual Networking to Crypto Theft: My $187K Lesson
The Spectra job interview scam, how it worked, and what I would do differently.
Jan 20252024 Year in Review
Career changes, Spanish learning, art, and Bitcoin.
Contact
The fastest way to reach me is email.
LinkedIn · GitHub · YouTube · Substack · datahoundtech.com