Jacob Hirtz

Experience

1. Junior Data Analyst

   Andrew Morgan

   Oct 2023 — Present

   Analyze high-volume, high-variability patient experience data for a large healthcare provider, servicing 9M+ patients across 1,200+ sites of care nationwide; developed metrics to enable 2% national reduction to complaint resolution times Work with minimally processed large datasets (20M+ rows) in Azure Synapse Analytics, transforming and cleaning data using intermediate SQL techniques; decreased query times by 96% from prior queries Designed 16 bespoke KPIs in Power BI using intermediate DAX analysis; implemented a phased pilot program for high-priority network directors, enabling clients to track previously inaccessible performance metrics to enhance data-driven decision-making Standardize client enterprise data architecture by creating data ecosystem maps, process and data flows, entity-relationship diagrams, and data dictionaries to improve governance and consistency Develop comprehensive enterprise data strategy to transform low-maturity organizational data usage into structured data-driven decision-making framework; deployed strategy across a 900+ person network of patient experience coordinators

Education

• Virginia Military Institute

  Bachelor’s Degree, History

  2012 — 2017