Create and maintain custom data-mining queries to produce actionable insights for pricing and business strategy.
Analyze pharmacy claims, drug pricing, rebate models, and utilization trends for internal teams and client reporting.
Interpret complex pharmacy benefit structures and clearly communicate findings to varied audiences.
Provide forecasting, reporting, and analytical support to senior management for strategic planning.
Automate and streamline reporting to increase efficiency and reduce manual processes within PBM pricing operations.
Contribute to Pricing operations by: Managing pricing appeals, coordinating with Maxor Specialty, and compiling data for automated processing.
Executing weekly pricing tasks to ensure accuracy and implementation consistency.
Gathering and preparing input data from pricing resources to support core processes.
Documenting procedures to meet audit and compliance requirements.
Execute dynamic pricing strategies in response to market changes to ensure competitive positioning and profitability.
Collaborate with Pricing, Underwriting, Sales, and Account Management teams to evaluate and support new/existing client opportunities.
Enhance financial models and streamline operational processes for greater accuracy and efficiency.
Create and distribute ad hoc reports and financial models tailored to business needs.
Develop tools for performance monitoring and key metric tracking across business units.
Author and manage Standard Operating Procedures (SOPs) for custom and standardized tasks.
Foster continuous improvement with a strong focus on operational excellence and process optimization.
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.
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.