Healthcare Trend Analyst
CurrentStudies forecasting models and consults various department stakeholders to develop a holistic picture of how the company is performing on a monthly and quarterly basis. Provides executive leadership with actionable information based on data trends and researched insights. Analyzes company’s revenue cycle and pin points areas causing revenue leakage. Creates financial benchmarks dashboard by querying data from databases and displaying it in Power BI.• Provides quarterly financial benchmarks to company: revenue, cost and margin by product, dispensing location, payer, patient, and delivery for the trailing 2 years, trended by quarter, half or calendar year. Queries data from different databases using SQL, ensures data consistency and accuracy by diligently cleaning up data, and displays the output in Power BI. Compiles insights found by studying benchmarks’ trends and presents to leadership the top drivers in revenue, cost and margin. Created supplemental PowerPoint deck explaining the calculations, how to effectively navigate the dashboard and a glossary of terms to ensure easy consumption.• Regularly studies revenue forecasting models and historical sales trends such as, what product and payer mixes are contributing to the overall sales rep’s performance, what referral sources are providing us with the most patients by quarter, and why territories are performing above or below expectations. Meets with department stakeholders to gain additional insights to explain trends the data does not display, such as drug formulary changes, purchasing patterns, and preferred provider agreements with new referral sources. Compiles insights into concise PowerPoint slides to be presented to Executive Leadership so they understand the inner-workings of the company’s performance at any given time.