Strategic Underwriting Analytics Lead (Excel/SQL)

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Paid time off

Retirement savings

Wellness programs

Job summary

CVS Health is seeking a Senior Analyst for Executive Underwriting Priorities to support Caremark Underwriting leadership through rigorous analytics and data-driven insights. The role emphasizes Excel-based modeling, data validation, and strong stakeholder communication in a fast-paced environment.

You will investigate pricing drivers, perform variance analyses, coordinate across teams, and build side analyses to validate assumptions.

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.

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.

Skills

Analytical thinking

Structured problem solving

Attention to detail

Intellectual curiosity

Stakeholder communication

Documentation habits

Education

Bachelor's degree in quantitative field

Tools

Excel

SQL

Relational databases

Job description

CVS Health is seeking a Senior Analyst for Executive Underwriting Priorities to support Caremark Underwriting leadership through rigorous analytics and data-driven insights. The role emphasizes Excel-based modeling, data validation, and strong stakeholder communication in a fast-paced environment.

You will investigate pricing drivers, perform variance analyses, coordinate across teams, and build side analyses to validate assumptions.