Long-Range Forecasting Consultant - Pharmacy; Business Consultant Senior

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

Location:

This role requires associates to be in-office 1 day per week, fostering collaboration and connectivity, while providing flexibility to support productivity and work-life balance. This approach combines structured office engagement with the autonomy of virtual work, promoting a dynamic and adaptable workplace. Ideal candidates will be able to report to our Pulse Point locations in St. Louis, MO, Indianapolis, IN, Plano, TX or Lake Mary, FL.

Alternate locations may be considered if candidates reside within a commuting distance from an office.

Note that per our policy on hybrid/virtual work, candidates not within a reasonable commuting distance from the posting location(s) will not be considered for employment, unless an accommodation is granted as required by law.

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.

• 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.

Requires a BA/BS and minimum of 10 years of 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.

• 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…