Long-Range Forecasting Consultant - Pharmacy (Business Consultant Senior)

Elevance Health•St. Louis, MO

1d•Hybrid

About The Position

The Long-Range Forecasting Consultant - Pharmacy (Business Consultant Senior) is responsible for developing and maintaining a 6–36 month demand and workforce forecasts for our specialty and infusion pharmacy operations. This role partners closely with Pharmacy Operations, Workforce Management (WFM), Finance, Human Resources, Sales and Analytics to provide forward-looking insights that enable proactive staffing, budgeting, and capacity planning. Also responsible for translating most highly complex and varied business needs into application software requirements. These needs typically involve significant expenditure or cost savings and impact a wide range of functions.

Requirements

Requires a BA/BS and minimum of 10 years business analysis experience, which should include analysis, project management, working knowledge of mainframe computer, hardware and operating systems; minimum of 3 years of experience as a Business Consultant with project management skills; or any combination of education and experience, which would provide an equivalent background.

Nice To Haves

10+ years of experience in workforce forecasting, capacity planning, demand forecasting (Healthcare, PBM, pharmacy, call center, or high-volume operations) highly preferred.
Advanced proficiency in Excel (complex models, Power Query, pivoting) and Forecasting and statistical techniques (trend analysis, seasonality, regression) 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.

Responsibilities

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.
Translates volume forecasts into headcount, FTE, and skill-mix requirements.
Partners with WFM to align long-range forecasts with short-term scheduling and intraday management.
Supports hiring, backfill, cross-training, and redeployment strategies.
Collaborates with Finance on labor budgeting, reforecasting, and cost optimization.
Provides data-driven insights to inform strategic initiatives, growth planning, and operational changes.
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.
Serves as the single source of truth for forward-looking pharmacy demand planning.
Creates clear, executive-level summaries and dashboards.
Provides expertise to lower-level consultants on the analysis of business needs to determine optimal means of meeting those needs.
Determines specific business application software requirements to address the most highly complex and varied business needs.
Leads teams of analysts assigned to the most complex projects, typically those of highest importance and impact to the way in which we do business.
Analyzes and designs solutions to address varied and highly complex business needs.