responsible for developing and maintaining a 6–36 month demand and workforce forecasts
partners closely with Pharmacy Operations, Workforce Management (WFM), Finance, Human Resources, Sales and Analytics
develops and maintains long-range volume forecasts using historical data, seasonality, benefit cycles, and business drivers
builds predictive and scenario-based models to assess demand variability and risk
monitors forecast accuracy and continuously refines models using variance analysis
collaborates with Finance on labor budgeting, reforecasting, and cost optimization
quantifies workforce impacts of new programs, regulatory changes, or benefit design shifts
manages ROI Analysis of pharmacy initiatives impacting workflow and productivity
presents forecasts, assumptions, and risks to operational and executive leadership
creates clear, executive-level summaries and dashboards
provides expertise to lower-level consultants on the analysis of business needs
leads teams of analysts assigned to the most complex projects

Requires a BA/BS
minimum of 10 years business analysis experience
minimum of 3 years of experience as a Business Consultant
working knowledge of mainframe computer, hardware and operating systems
10+ years of experience in workforce forecasting, capacity planning, demand forecasting highly preferred
Advanced proficiency in Excel (complex models, Power Query, pivoting) highly preferred
strong analytical capability highly preferred
Healthcare operations knowledge highly preferred
Ability to translate complex forecasts into clear, actionable recommendations for senior leaders highly preferred
Experience with Workforce management tools (e.g., NICE, Verint, Aspect, or similar), BI tools (Power BI, Tableau), SQL, Python, or R preferred
Master’s degree (MBA, MS Analytics, MS Operations Research) preferred

Long-Range Forecasting Consultant – Pharmacy, Senior

Key skills