Provide analytical and operational support to Caremark Underwriting leadership
Investigate drivers of change in pricing and forecasting outputs
Identify root causes of anomalies
Coordinate with internal stakeholders to obtain clarifications, data sources, and supporting documentation
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
Partner with stakeholders across the underwriting ecosystem
Build and maintain “side” analyses (primarily in Excel)
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

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.
Experience in PBM, healthcare, health plan, or underwriting/pricing environments preferred.
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.

Senior Analyst, Executive Underwriting Priorities

Key skills