Senior Analyst, Executive Underwriting Priorities

📋 Description

• Deliver analytical and operational assistance to the Caremark Underwriting leadership team

• Conduct research, validate, and synthesize necessary information to address time-sensitive inquiries

• Analyze factors influencing changes in pricing and forecasting outputs

• Identify the underlying causes of anomalies

• Collaborate with internal stakeholders to gather clarifications, data sources, and relevant documentation

• Carry out diagnostic reviews to clarify variations in results across pricing and forecasting tools/models

• Partner with stakeholders throughout the underwriting ecosystem to find solutions

• Develop and sustain supplementary analyses to confirm assumptions

• Work with structured datasets and assist in the extraction/validation of inputs and outputs using relational data concepts and SQL

• Keep well-organized notes, assumptions, and reference materials

• Prepare meeting summaries, document action items, and represent leadership in lower-priority meetings

⛳️ Requirements

• A minimum of 2 years of relevant professional experience in analytics, finance, underwriting, actuarial, forecasting, or a similar quantitative field.

• Proficiency in Microsoft Excel, including complex formulas and structured modeling (e.g., INDEX/MATCH or XLOOKUP, SUMIFS, pivot tables, error checking, reconciliation techniques).

• Knowledge of relational databases and SQL concepts for data extraction, validation, and analysis.

• Experience in PBM, healthcare, health plan, or underwriting/pricing environments is preferred.

• Proven ability to investigate unclear problems, ask insightful clarifying questions, and resolve issues through structured analysis and stakeholder follow-up.

🏝️ Benefits

• Medical, dental, and vision coverage

• Paid time off

• Retirement savings options

• Wellness programs

• Additional resources, based on eligibility