Overview
This role provides advanced analytical and strategic support to the Ambulatory Pharmacy team across operational and financial functions, including:
- Financial analysis
- Proforma development
- Profit and loss analysis
- Contracting and local payer contracting
- Clinical utilization
The position involves developing reports, dashboards, data visualizations, and customized analytical solutions to identify opportunities and support informed decision-making. You will collaborate with cross-functional clients to establish performance metrics and tools aligned with organizational priorities, advising senior pharmacy leadership with actionable business insights and strategic recommendations.
Responsibilities
- Conduct advanced financial, operational, and healthcare data analyses to identify opportunities, address complex business challenges, and respond to ad hoc requests in a timely manner.
- Interpret industry trends, regulatory changes, utilization patterns, and forecasts to evaluate potential client and business impacts.
- Develop, execute, and manage project plans to meet timelines, budgets, deliverables, and expected value.
- Design reports, dashboards, charts, graphs, tables, and executive-level presentations that clearly communicate insights, performance, and opportunities for improvement.
- Present findings and strategic recommendations to leadership and support evaluation of business alternatives.
- Develop customized financial proformas, including cash flow, margin, profitability, and other financial calculations for client engagements.
- Analyze prescriber, dispensing, claims, and related pharmacy data to identify eligible 340B claims, current capture, revenue growth opportunities, and internal or external pharmacy opportunities.
- Maintain analytical tools and methodologies for identifying specialty and limited distribution drugs across large client datasets, including advanced Excel formulas and macros.
- Maintain and analyze Specialty Drug List and Limited Distribution Drug List pricing and related data.
- Collaborate with cross-functional clients to develop customized analytics solutions, tracking tools, and performance metrics that support strategic and operational priorities.
Qualifications
- Relevant degree preferred.
- 5 or more years of relevant experience required.
- Experience in healthcare data analytics, financial analytics, pharmacy analytics, or a related analytical field.
- Ability to interpret financial analyses and translate complex findings into clear, actionable business insights for clients, colleagues, and executive leadership.
- Advanced Microsoft Excel skills, including experience developing analytical models, formulas, and macros.
- Strong Microsoft PowerPoint skills, with the ability to create concise, polished presentations for leadership audiences.
- Experience managing multiple projects from data collection and analysis through final deliverables and implementation.
- Ability to work effectively independently and collaboratively with cross-functional teams and diverse clients while managing competing priorities and tight deadlines.
- Ability to travel regularly and expeditiously throughout the year to meet clients’ needs and timetables.
Preferred Qualifications
- Experience with SQL, Power BI, Microsoft Access, and dashboard development.
Compensation & Benefits
- Estimated hiring range: $88,900.00 to $155,500.00.
- This position is incentive eligible.
Location
- Travel is required regularly and expeditiously throughout the year to meet clients’ needs and timetables.
Equal Opportunity
The employer is an Equal Opportunity Employer. Females/Minorities/Veterans/Individuals with Disabilities.