Overview
This role provides analytical and operational support to underwriting leadership by researching, validating, and synthesizing information needed to resolve time-sensitive questions and enable informed decision-making. Responsibilities include 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.
Responsibilities
- Research & issue resolution support: Respond to 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 represent leadership in lower-priority meetings when needed 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.
Requirements
- 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 summarizing complex findings for non-technical audiences and documenting 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).
Compensation & Benefits
- Anticipated weekly hours: 40
- Time type: Full time
- Pay range (typical): $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 bonus, commission, or short-term incentive program in addition to the base pay range listed above.
- Benefits: Medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility.
Location
Not specified.
Additional Information
- Application window anticipated to 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.