A-Line Staffing Solutions · 10 hours ago
Forecasting Analyst
A-Line Staffing Solutions is seeking a strategic and detail-oriented PBM Forecasting professional to join a high-impact forecasting team. This role focuses on supporting pharmaceutical rebate analysis and financial modeling, while maintaining and enhancing legacy forecasting tools and guiding the transition to a modern forecasting platform.
Responsibilities
Ensure accurate and timely updates to rebate and financial forecasting models
Interpret rebate contracts and update forecasting model assumptions accordingly
Provide ongoing business support for speculative rates used in forecasts
Extract, analyze, and interpret large datasets to support forecasting accuracy and decision-making
Maintain and enhance legacy forecasting tools using Excel, VBA, and SQL
Perform quality control, testing, and validation of existing tools and resources
Translate evolving business needs into technical solutions and implement new assumptions as required
Consult on the development and implementation of the Integrated Rebate Forecast (IRF), a new cloud-based forecasting solution supporting legacy tool decommissioning
Collaborate closely with Trade Finance, Underwriting, Data Science, iTools, and PUMA support teams
Communicate complex financial and analytical findings clearly to technical and non-technical stakeholders
Support forecasting initiatives with strong documentation and stakeholder alignment
Qualification
Required
5+ years of experience in financial analysis, analytics, underwriting, or forecasting
2+ years of experience using SQL to analyze and manipulate large datasets
2+ years of advanced Excel modeling experience, including VBA proficiency
Strong proficiency with advanced Excel functions such as: INDEX/MATCH, Nested IF statements, Array formulas
Proven ability to extract, manipulate, and analyze large data sets to deliver actionable insights
Strong analytical, problem-solving, and attention-to-detail skills
Preferred
Experience in PBM underwriting or healthcare contracting
Familiarity with rebate modeling and pharmaceutical pricing structures
Strong presentation and communication skills
Ability to manage multiple priorities and meet tight deadlines in a fast-paced environment
Company
A-Line Staffing Solutions
A-Line Staffing Solutions is a staffing and recruiting company specializing in pharmaceutical, medical, and IT staffing services.
H1B Sponsorship
A-Line Staffing Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (3)
2021 (4)
2020 (8)
Funding
Current Stage
Late StageCompany data provided by crunchbase