LanceSoft Inc., · 1 day ago
Financial Analyst (Healthcare)
LanceSoft Inc. is seeking a strategic and detail-oriented Manager to join their dynamic PBM Forecasting team. In this high-impact role, you’ll serve as a subject matter expert on pharmaceutical rebates, supporting forecasting efforts through tool development and maintenance, contract interpretation, and cross-functional collaboration.
Information Technology & Services
Responsibilities
Ensuring accurate and timely updates to forecasting models
Maintain the legacy forecasting tools using VBA, SQL, and Microsoft Excel
Interpret rebate contracts and update forecast model inputs accordingly
Ensure quality control with testing of existing tools and resources
Collaborate with Trade Finance, iTools, Underwriting, Data Science and PUMA support teams
Translate business needs into technical solutions and implement new assumptions as required
Consult on the development and implementation of Integrated Rebate Forecast (IRF), a new cloud-based forecasting tool to aid in the legacy tool decommission efforts
Communicate complex findings clearly and effectively to stakeholders
Provide ongoing business product support for speculative rates used in forecasts
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 in Excel formulas (e.g., INDEX/MATCH, nested IFs, array formulas, etc.)
Proven ability to extract, manipulate, and analyze large data sets to draw actionable insights
Bachelor's degree in Finance, Economics, Data Analytics, Business Administration, or a related field required
Preferred
Experience in PBM underwriting or healthcare contracting
Strong presentation and communication skills
Ability to manage multiple priorities and meet tight deadlines
Benefits
Four options of medical Insurance
Dental and Vision Insurance
401k Contributions
Critical Illness Insurance
Voluntary Permanent Life Insurance
Accident Insurance
Other Employee Perks
Company
LanceSoft Inc.,
Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele.
H1B Sponsorship
LanceSoft Inc., 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
2025 (55)
2024 (32)
2023 (23)
2022 (25)
2021 (60)
2020 (80)
Funding
Current Stage
Late StageCompany data provided by crunchbase