FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.

Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in financial modeling, data analysis, and reporting within the health insurance and pharmaceutical sectors. Proficient in SQL and Excel, with a strong ability to collaborate across departments to drive strategic business decisions.
Highest-signal resume keywords
Financial ModelingSQL/Google Cloud BigQueryExcel ProficiencyPBM ExperienceData Analysis
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Financial ModelingData AnalysisReportingLookback AnalysisContract ReviewPricing StrategyProject ManagementData PullsUtilization ReviewPerformance Reporting
Soft Skills
CollaborationCommunicationProblem-SolvingCritical ThinkingTime Management
Industry Keywords
Health InsuranceManaged CarePharmaceutical IndustryPBMFinancial Risk Mitigation
Tech Stack
Tools & technologiesBigQueryCloudSQL
About the role
Key responsibilities & impact- Review guarantee performance by client monthly
- Prepare financial performance reporting
- Provide reporting and information for audit requests
- Partner with Underwriting, Networks, Sales/Account Management, Audit, and Legal to review contract terms and recommend pricing strategy
- Perform monthly data pulls for assigned guarantee clients
- Review performance results, drug mix, and utilization to identify opportunities to mitigate financial risk
- Collaborate with underwriting, finance, and accounting partners to improve process gaps and overlaps
- Perform lookback analysis comparing underwriting assumptions, contract language, and actual results
- Develop reporting packages and presentations for management
- Create best practices and draw conclusions to inform critical business decisions
Requirements
What you’ll need- 3+ years of experience creating financial models and working with large data sets in a database environment
- 3+ years of experience managing multiple projects and delivering results timely
- 2+ years of SQL/Google Cloud BigQuery experience
- Must be proficient in Excel
- Bachelor's Degree or equivalent work experience
- Knowledge of health insurance, managed care, or pharmaceutical industry preferred
- 2+ years of PBM experience, preferably in drug pricing and analytics
Benefits
Comp & perks- Medical coverage
- Dental coverage
- Vision coverage
- Paid time off
- Retirement savings options
- Wellness programs
- Other resources supporting physical, emotional, and financial well-being
- CVS Health bonus, commission or short-term incentive program in addition to base pay