Senior Analyst, Executive Underwriting Priorities

CVS Health; Illinois; Hybrid; USD 65,000 - 173,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Paid time off

Retirement plan

Job summary

CVS Health is seeking a Senior Analyst, Executive Underwriting Priorities to support Caremark Underwriting leadership. The role involves researching drivers of changes in pricing and forecasting, validating data sources, and delivering concise readouts to leadership and partners.

You will work with large datasets, leverage Excel, and coordinate across finance, data teams and stakeholders. The position emphasizes analytical rigor, structured problem solving, and the ability to translate complex

Qualifications

• 2+ years of analytics, finance, underwriting, forecasting, or related quantitative work.
• Experience with Microsoft Excel including complex formulas and structured modeling (INDEX/MATCH, XLOOKUP, SUMIFS, pivot tables).
• Familiarity with relational databases and SQL concepts for data extraction, validation, and analysis.

Responsibilities

• Research and issue resolution support for ad hoc requests with clear readouts.
• Model output investigation and variance analysis for pricing and forecasting.
• Coordinate across underwriting stakeholders to obtain data sources and interpretations.
• Build and maintain side analyses in Excel to validate assumptions and quantify impacts.
• Document assumptions and decisions to reduce rework and improve repeatability.

Skills

Excel

SQL

Analytical thinking

Communication

Education

Bachelor’s degree in quantitative field

Tools

SQL

Excel

Job description

We’re building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you’ll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time.

Position Summary

The Senior Analyst, Executive Underwriting Priorities will provide analytical and operational support to Caremark Underwriting leadership by researching, validating, and synthesizing information needed to resolve time‑sensitive questions and enable informed decision‑making. This role is responsible for investigating drivers of change in pricing and forecasting outputs, identifying root causes of anomalies, and coordinating across internal stakeholders to obtain clarifications, data sources, and supporting documentation. The successful candidate is highly analytical, Excel‑savvy, comfortable working with large datasets, and able to “figure things out” in a complex, fast‑paced environment with minimal supervision.

Key Responsibilities

• Research & issue resolution support: Respond to a broad range of ad hoc requests by gathering facts, performing targeted analyses, and producing clear, concise readouts for leadership and business partners.
• Model output investigation & variance analysis: Perform 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, improve repeatability, and ensure questions are not re‑opened without new information.
• Meeting support: Prepare meeting briefs (what changed, why it matters, what decisions are needed), capture action items, and—when needed—represent leadership in lower‑priority meetings 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 practices.

Core Competencies

• Analytical rigor
• Structured problem solving
• Attention to detail
• Intellectual curiosity and persistence ("runs things down")
• Strong organization and documentation habits
• Stakeholder engagement and professional communication
• Sound judgment with sensitive/confidential information

Required Qualifications

• 2 years of relevant professional experience in analytics, finance, underwriting, actuarial, forecasting, or a related quantitative discipline.
• Experience with Microsoft Excel, including complex formulas and structured modeling (e.g., INDEX/MATCH or XLOOKUP, SUMIFS, pivot tables, error checking, reconciliation techniques).
• 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 the ability to summarize complex findings for non‑technical audiences and document 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).

Anticipated Weekly Hours

40

Time Type

Full time

Pay Range

The typical pay range for this role is: $64,890.00 - $173,040.00 This pay range represents the base hourly rate or base annual full‑time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short‑term incentive program in addition to the base pay range listed above.

Great benefits for great people

We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families. This full‑time position is eligible for a comprehensive benefits package designed to support the physical, emotional, and financial well‑being of colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility. Additional details about available benefits are provided during the application process and on Benefits Moments.

We anticipate the application window for this opening will close on: 10/30/2026

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

Our Work Experience is the combination of everything that's unique about us: our culture, our core values, our company meetings, our commitment to sustainability, our recognition programs, but most importantly, it's our people. Our employees are self‑disciplined, hard working, curious, trustworthy, humble, and truthful. They make choices according to what is best for the team, they live for opportunities to collaborate and make a difference, and they make us the #1 Top Workplace in the area.