Business Analyst - Pricing and Underwriting
- Description:
- The Business Analyst, Pricing and Underwriting, is responsible for the compilation, analysis, and reporting of data to support pricing contracts for Specialty services within a Pharmacy Benefit Manager (PBM) setting.
- Partner cross-functionally with Underwriting, Finance, Clinical, and Account Management teams to develop custom reports, assess the impact of client-driven changes, and perform data-driven analyses.
- Utilize SQL, Excel, and data visualization tools to maintain and monitor Specialty pricing models, support financial forecasting, and contribute to strategic economic modeling.
- Design and generate reports to inform daily operations and executive decision-making.
- Collaborate within the Pricing & Underwriting department to develop queries across multiple systems, offering robust analytical support to key business units.
- Requirements:
- Education: Bachelor’s Degree in Finance, Business Analytics, Computer Information Systems, Data Science, or Economics. Or similarly related degree preferred.
- Experience: Minimum of 2 years’ experience completing complex analytical, financial analysis for PBM services.
- Minimum of 1 year experience using SQL or other applicable programming language (Python/VBA/C++/etc).
- Knowledge, Skills, and Abilities: Knowledge of pricing components and service mix, including plan design, prescription utilization, retail networks, rebates, Specialty/Mail pharmacy services, and brand/generic dynamics.
- Advanced Excel and Word expertise, with experience in building complex financial models and reports.
- Proficient in SQL, using SELECT, CASE, JOIN, and conditional logic to extract and analyze large datasets.
- Strong analytical skills to assess client-specific data within the broader context of business strategy, delivering actionable pricing recommendations.
- Experience working with complex, unstructured datasets to drive insights and decisions.
- Proven ability to manage multiple priorities, coordinate deliverables, and meet critical deadlines.
- Effective cross-functional collaborator in fast-paced environments involving Operations, Sales, Account Management, and Finance.
- Skilled communicator with experience presenting findings to senior leadership.
- Self-motivated project manager with excellent follow-through and organizational discipline.
- Detail-oriented with exceptional time management and process documentation skills.
- Benefits:
- Comprehensive mental health and wellbeing resources
- Nationwide Blue Cross Blue Shield PPO with employee-friendly plan design, including a $850 individual annual medical deductible and $25 office visit copays, with low biweekly premiums
- Company-paid basic life/AD&D, short-term and long-term disability insurance
- Rx, dental, vision, other voluntary benefits, and FSA
- Employer-matched 401k Plan
- Industry-leading PTO plan
- And more!
Apply Job!
Apply to this Job