August
Turner.
Business intelligence analyst with seven years building reliable analytics on healthcare and operational data — Snowflake, Power BI, Oracle Analytics Cloud, and the SQL that holds them together.
Open to roles · BI Analytics / EngineeringWhat I do.
I build the data infrastructure behind clinical and operational reporting — ETL pipelines, semantic models, & performance-tuned warehouses. My current work migrates large SQL Server reporting workloads onto Snowflake and OCI, rebuilding the BI layer for accuracy and speed. Background: BS in Ecology & Evolutionary Biology, self-taught into data, currently looking for my next BI analytics / engineering role.
Stack.
Selected work.
Kansas City blight lifecycle
15-year property-blight pipeline across KCMO open data — Socrata extract-load → BigQuery → dbt → Looker, with a scheduled refresh.
CMS Medicare claims analytics
Spending and utilization patterns across CMS public datasets. SQL transformations, partitioning strategy, Looker Studio dashboard.
NYC TLC trip records
Billion-row dataset — partitioning, clustering, and query-cost optimization study.
GitHub Archive trends
Open-source ecosystem trends. BQ ML forecasting on language adoption.
Gmail → PDF receipt pipeline
Python automation: Gmail API → parse receipt metadata → generate PDFs → structured archive. End-to-end ETL on personal data.
CB Trading Journal
Python pipeline: Coinbase + Robinhood APIs → PostgreSQL → trade analytics. Personal trading data ETL.
Live BigQuery boards.
Real Looker Studio dashboards powered by the case-study models — embedded, refreshing from BigQuery.