AARON KNAACK
Iowa City,IA
Summary
Analytical professional with 7+ years of management and data analysis experience in healthcare. Skilled in utilizing organizational and analytical strengths to inform decision-making and enhance business operations. A proven problem-solver with a strong track record of independently tackling complex challenges to achieve organizational goals.
Overview
9
9
years of professional experience
Work History
Financial Analyst
University of Iowa Hospital
Iowa City, IA
04.2023 - Current
- Collaborate with internal stakeholders across multiple divisions to define and develop customized data reports and performance analytics
- Design and generate key departmental Tableau Dashboards on RVU metrics, coding and billing patterns, clinic utilization, claim denial, and other miscellaneous requests to drive strategic decision-making using Epic, SQL, METS and Tableau data sources
- Support grant management efforts, contributing to the successful submission of four grants totaling $280K in Rheumatology Fellow Salary and research funding.
- Develop reports to project RVUs and expenses for yearly department budgeting in STRATA.
- Improve operational efficiency by integrating QGenda scheduling data with various Internal Medicine systems, streamlining workflows and enhancing accessibility.
Division Coordinator
University of Iowa Hospital
Iowa City, IA
09.2015 - 03.2023
- Supplied statistical analysis of clinical data for faculty research projects.
- Provided supervision and mentorship in compiling reports, responding to data requests, and organizing recruitment/graduation for the coordinator of Allergy and Rheumatology fellowships.
- Managed divisional accounts and expenditures; reconciled statements; prepared monthly financial reports; and provided recommendations on the best use of division funds.
Education
MS - Business Analytics
University of Iowa
Iowa City, IA05.2021
MBA -
University of Iowa
Iowa City, IA12.2019
BA - Business Economics
University of Northern Iowa
Cedar Falls, IA05.2014
Skills
- Microsoft Office
- Tableau/Tableau Prep Builder
- Power BI
- Excel Power Query
- SQL
- Python
- R
- Epic
Accomplishments
- Epic: Clarity Data Model, Caboodle Data Model, Cogito
- Tableau 2022 Advanced Training
- Tableau Prep for Business Intelligence
Additional Information
- https://www.linkedin.com/in/aaron-knaack- bb272151/
Timeline
Financial Analyst
University of Iowa Hospital
04.2023 - Current
Division Coordinator
University of Iowa Hospital
09.2015 - 03.2023
MS - Business Analytics
University of Iowa
MBA -
University of Iowa
BA - Business Economics
University of Northern Iowa
Similar Profiles
Timothy HoffmannTimothy Hoffmann
Psychiatric Registered Nurse at University of Iowa HospitalPsychiatric Registered Nurse at University of Iowa Hospital
Joe FarrellJoe Farrell
Clinical Research Assistant at University of Iowa HospitalClinical Research Assistant at University of Iowa Hospital
Alexis WatsonAlexis Watson
Psychiatric Nursing Assistant at University of Iowa HospitalPsychiatric Nursing Assistant at University of Iowa Hospital