Executive Underwriting Analytics Lead

CVS Health; Portland (ME); On-site; USD 65,000 - 173,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Paid time off

Retirement savings options

Wellness programs

Job summary

CVS Health in Portland, ME is hiring a Senior Analyst, Executive Underwriting Priorities to support Caremark Underwriting leadership by researching, validating, and synthesizing information for time-sensitive decisions.

The role investigates pricing drivers, forecasts, and root causes of anomalies, coordinating with stakeholders to obtain data and documentation. Proficiency in Excel and SQL, and comfort with large datasets in a fast-paced environment are essential.

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

• 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.
• 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.
• Partner with stakeholders across the underwriting ecosystem to obtain answers, trace data lineage, and confirm interpretation of results.
• Build and maintain side analyses (primarily in Excel) to validate assumptions, reconcile outputs, quantify impacts, and support leadership decision needs.
• Work with structured datasets and support extraction/validation of inputs and outputs using relational data concepts and SQL.
• Maintain organized notes, assumptions, and reference materials to reduce rework and ensure questions are not re-opened without new information.
• Prepare meeting briefs (what changed, why it matters, what decisions are needed) and represent leadership in lower-priority meetings as needed.
• Identify opportunities to streamline recurring requests and improve reliability of analysis through better templates, tracking, and documentation.

Skills

Analytics experience

Cross-functional collaboration

Education

Bachelor's degree in a quantitative field

Tools

Excel

SQL

Job description

CVS Health in Portland, ME is hiring a Senior Analyst, Executive Underwriting Priorities to support Caremark Underwriting leadership by researching, validating, and synthesizing information for time-sensitive decisions.

The role investigates pricing drivers, forecasts, and root causes of anomalies, coordinating with stakeholders to obtain data and documentation. Proficiency in Excel and SQL, and comfort with large datasets in a fast-paced environment are essential.