Senior Analyst, Executive Underwriting Priorities

Overview

The Senior Analyst, Executive Underwriting Priorities provides analytical and operational support to Caremark Underwriting leadership. This role researches, validates, and synthesizes information to resolve time-sensitive questions and enable informed decision-making. Responsibilities include investigating drivers of change in pricing and forecasting outputs, identifying root causes of anomalies, and coordinating with internal stakeholders to obtain clarifications, data sources, and supporting documentation.

The ideal candidate is highly analytical, proficient in Excel, comfortable working with large datasets, and able to independently resolve complex issues in a fast-paced environment.

Responsibilities

• Research & issue resolution support: Respond to ad hoc requests by gathering facts, performing targeted analyses, and delivering clear, concise readouts for leadership and business partners.
• Model output investigation & variance analysis: Conduct diagnostic reviews to explain changes in results across pricing and forecasting tools/models, including identification of key drivers, input changes, data shifts, and methodology impacts.
• Cross-functional coordination: Partner with stakeholders across the underwriting ecosystem (e.g., modeling/tool owners, data teams, finance partners, and subject matter experts) to obtain answers, trace data lineage, and confirm appropriate interpretation of results.
• Side analyses and supporting models: Build and maintain “side” analyses (primarily in Excel) to validate assumptions, reconcile outputs, quantify impacts, and support leadership decision needs.
• Data handling & querying: Work with structured datasets and support extraction/validation of inputs and outputs using relational data concepts and SQL (hands-on query writing and/or leveraging standard tools and resources).
• Documentation & knowledge management: Maintain organized notes, assumptions, and reference materials to reduce rework and improve repeatability.
• Meeting support: Prepare meeting briefs (what changed, why it matters, what decisions are needed), capture action items, and represent leadership in lower-priority meetings as needed to capture key takeaways and follow-ups.
• Continuous improvement: Identify opportunities to streamline recurring requests, improve clarity of outputs, and enhance reliability of analysis through better templates, tracking, and documentation.

Requirements

• Experience: 2 years of relevant professional experience in analytics, finance, underwriting, actuarial, forecasting, or a related quantitative discipline.
• Excel: Experience with Microsoft Excel, including complex formulas and structured modeling (e.g., INDEX/MATCH or XLOOKUP, SUMIFS, pivot tables, error checking, reconciliation techniques).
• Databases & SQL: Familiarity with relational databases and SQL concepts for data extraction, validation, and analysis.

Preferred Qualifications

• Experience in PBM, healthcare, health plan, or underwriting/pricing environments.
• Experience working with large datasets and performing reconciliations across multiple sources/systems.
• Ability to work effectively in a cross-matrix environment and build productive relationships across functions.
• Comfort learning new tools/systems quickly and operating in environments with evolving processes and requirements.
• Actuarial student status preferred, actively pursuing actuarial credentials with 3+ exams passed.
• Demonstrated ability to investigate ambiguous problems, ask strong clarifying questions, and drive issues to resolution through structured analysis and stakeholder follow-up.
• Strong written and verbal communication skills, including summarizing complex findings for non-technical audiences and documenting decisions and next steps.
• Ability to manage multiple priorities, operate with urgency, and deliver accurate work under tight timelines.

Education

Bachelor’s degree in actuarial science, mathematics, statistics, economics, finance, business, data analytics, or a related quantitative field preferred (or equivalent experience).

Compensation & Benefits

• Pay Range: $64,890.00 - $173,040.00
• This pay range represents the base hourly rate or base annual full-time salary for positions in the job grade.
• Actual base salary offer depends on factors including experience, education, geography, and other relevant factors.
• Incentives: This position is eligible for a bonus, commission, or short-term incentive program in addition to the base pay range.
• Benefits: Full-time roles are eligible for a comprehensive benefits package based on eligibility, including medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources.

Work Schedule

• Anticipated Weekly Hours: 40
• Time Type: Full time

Application Window

• Anticipated application window closes on 10/30/2026.

Equal Opportunity

Qualified applicants with arrest or conviction records will be considered for employment in accordance with all federal, state and local laws.