EPIC Insurance Brokers & Consultants

Senior Actuarial, Analytics Consultant

EPIC Insurance Brokers & Consultants

full-time

Posted on:

Location Type: Hybrid

Location: 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

SQLVBA

About the role

  • Responsible for developing accurate and timely financial analyses for clients.
  • Prepare various financial and quantitative analysis in support of client teams.
  • Prepare IBNR analyses; calculate and validate claim reserves and ensure accuracy and compliance.
  • Produce underwriting analyses for client renewals and projections (self-funded and insured programs as applicable).
  • Monitor and report on stop-loss coverage, claims experience, reimbursements, and contract terms; escalate variances and opportunities.
  • Develop pharmacy rebate reconciliations and track actuals vs. expected performance.
  • Validate and reconcile invoicing related to actuarial services, stop-loss premiums, and other program costs; ensure timely and accurate billing.
  • Ensure compliance with applicable regulatory requirements and actuarial standards for financial and management reporting.
  • Develop and present financial reviews to client leadership, including plan performance, cost trends, funding status, variance analysis, and projections.
  • Deliver periodic reporting (monthly/quarterly) and dashboards; synthesize results and recommendations for clients and client teams.
  • Coordinate with carriers, PBMs, TPAs, and other vendors to obtain, validate, and reconcile data required for analysis and reporting. Support client team strategy with evaluation of plan design alternatives, contribution/rate strategies, risk profiles, benchmarking, data analytics, and vendor change analyses; quantify the financial impact of options.
  • Collaborate with cross-functional teams to integrate actuarial insights into broader client and business strategies.
  • Requires effective communication skills for clearly explaining detailed analysis and the ability to understand client perspectives to be reflected in the development of deliverables.
  • Employ effective project management skills for balancing requests from multiple client teams, and for efficient delivery of results.
  • Mentor and guide analysts; provide peer review and foster a culture of quality, process improvement, and knowledge sharing

Requirements

  • Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Finance, or a related field.
  • Associateship in the Society of Actuaries (ASA) or comparable designation
  • 7+ years of experience in actuarial consulting or financial analysis, preferably in the insurance/employee benefits/HR area
  • Expertise with actuarial modeling tools and financial analysis software (e.g., Claros) and advanced proficiency with Excel; experience with VBA and SQL is a plus.
  • Strong understanding of benefit plan design, risk management, funding methodologies, and applicable regulatory frameworks.
  • Exceptional analytical, problem-solving, and communication skills with the ability to clearly convey technical concepts to non-technical audiences.
Benefits
  • Generous Paid Time off
  • Generous leave time options: Paid parental leave, pregnancy disability and bonding leave, and organ donor/bone marrow donor leave
  • Generous employee referral bonus program of $1,500 per hired referral
  • Employee recognition programs for demonstrating EPIC’s values plus additional employee recognition awards and programs (and trips!)
  • Employee Resource Groups: Women’s Coalition, EPIC Veterans Group
  • Professional growth & development: Mentorship Program, Tuition Reimbursement Program, Leadership Development
  • Unique benefits such as Pet Insurance, Identity Theft & Fraud Protection Coverage, Legal Planning, Family Planning, and Menopause & Midlife Support
  • Additional benefits include (but are not limited to): 401(k) matching, medical insurance, dental insurance, vision insurance, and wellness & employee assistance programs
  • 50/50 Work Culture: EPIC fosters a 50/50 culture between producers and the rest of the business, supporting collaboration, teamwork, and an inclusive work environment. It takes both production and service to be EPIC!
  • EPIC Gives Back – Some of our charitable efforts include Donation Connection, Employee Assistance Fund, and People First Foundation
  • We’re in the top 10 of property/casualty agencies according to “Insurance Journal”

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
financial analysisIBNR analysisclaim reserves calculationunderwriting analysispharmacy rebate reconciliationinvoicing validationactuarial modelingdata analyticsVBASQL
Soft skills
effective communicationproject managementanalytical skillsproblem-solvingmentoringcollaborationprocess improvementknowledge sharing
Certifications
Bachelor’s degree in Actuarial ScienceAssociateship in the Society of Actuaries (ASA)