Business Analyst

📌 Job Opportunity: Business Analyst II – Rebate Forecast Tools (Contract)
📍 Remote | 6+ months
🕒 Mon–Fri 8:30 AM – 5:00 PM

We are hiring for a Business Analyst II – Rebate Forecast Tools to join a dynamic PBM Forecasting team. This is a high-impact role focused on pharmaceutical rebate forecasting, tool development, contract interpretation, and collaboration across multiple teams.

🔹 Key Responsibilities
• Maintain and update forecasting models for accurate results
• Support legacy forecasting tools using VBA, SQL, and Excel
• Interpret rebate contracts and update forecast inputs
• Perform quality control and testing of forecasting tools
• Work with Trade Finance, iTools, Underwriting, Data Science, and PUMA
• Translate business requirements into technical solutions
• Support implementation of new cloud-based forecasting tool (IRF)
• Provide ongoing support for speculative rate forecasts

🔹 Required Skills
• 5+ years in financial analysis, analytics, underwriting, or forecasting
• 2+ years SQL experience
• 2+ years advanced Excel + VBA
• Strong Excel modeling (INDEX/MATCH, nested IF, array formulas)
• Strong analytical skills with large datasets

🔹 Preferred Qualifications
• PBM underwriting or healthcare contracting experience
• Strong communication and presentation skills
• Ability to manage priorities and meet deadlines

📚 Education: Bachelor’s degree in Finance, Economics, Data Analytics, Business Admin, or related field