Employee Benefits Analytics & Financial Modeling Analyst

Aon plc

Charlotte (NC)

On-site

USD 70,000 - 90,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

NFP, an Aon Company, seeks a data and analytics professional in Charlotte, NC to support the Employee Benefits team with daily data analysis and reporting. You will review vendor reports, craft client‑specific insights, and participate in strategy discussions to optimize renewals and plan design decisions.

Responsibilities include building financial models, preparing renewal analyses, and presenting findings to clients and carriers.

Qualifications

  • Four‑year college or university degree; Finance/Statistics/Mathematics, Risk Management, Actuarial Science, or related fields highly preferred.
  • 3+ years of experience in an Analytics or Financial role preferred.

Responsibilities

  • Build new financial models to improve financial analysis reporting and renewal process.
  • Collaborate with Unit Leader to develop and implement processes for maximum value and efficiency.
  • Quality review exhibits for mathematics, spelling, grammar and branding to ensure client readiness.
  • Lead financial analysis and develop multi-year strategies for clients.
  • Make recommendations on renewal rating, cost drivers, and plan design changes.
  • Prepare and lead client discussions around weekly, monthly, and quarterly financial reports including claims, budget/premium, payroll contributions, and network utilization.
  • Develop and present renewal projections for medical, dental, and vision coverage.
  • Complete renewal analysis and support carrier negotiations.
  • Prepare renewal financial summaries.
  • Model plan designs, employee contributions, stop loss, and financial impact of mergers/divestitures.
  • Perform IBNR reserve analysis.
  • Prepare stop loss sensitivity analysis for self‑insured clients.
  • Facilitate special projects for the Data Analytics and Reporting Unit.
  • Support the sales process with financial analysis and client presentations.
  • Attend seminars and meetings to stay updated on market developments and regulations.
  • Build and maintain relationships with clients, carriers, and consultants.

Skills

Analytical skills
Client communication
Relationship building
Strong work ethic
Organizational skills
Group insurance knowledge
Carriers knowledge
Excel proficiency
Power BI
Visual Basic
Travel readiness

Education

Bachelor’s degree in Finance/Statistics/Mathematics
3+ years analytics experience

Tools

Excel
Power BI
Visual Basic

Job description

NFP, an Aon Company, seeks a data and analytics professional in Charlotte, NC to support the Employee Benefits team with daily data analysis and reporting. You will review vendor reports, craft client‑specific insights, and participate in strategy discussions to optimize renewals and plan design decisions.

Responsibilities include building financial models, preparing renewal analyses, and presenting findings to clients and carriers.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Employee Benefits Financial Analyst — Data-Driven Advisor
Employee Benefits Financial Analyst — Data-Driven Advisor

NFP, an Aon company • Charlotte (NC)

On-site
USD 70,000 - 90,000
Competitive salary
PTO & paid holidays
401(k) with match
+1
Employee Benefits Analytics & Vendor Negotiation Specialist
Employee Benefits Analytics & Vendor Negotiation Specialist

Aon plc • Virginia (MN)

On-site
USD 62,000 - 77,000
PTO & paid holidays
401(k) with match
Health & wellness programs
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

NFP, an Aon company • Charlotte (NC)

On-site
USD 70,000 - 90,000
Competitive salary
PTO & paid holidays
401(k) with match
+1
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

NFP • Charlotte (NC)

On-site
USD 70,000 - 90,000
PTO and paid holidays
401(k) with match
Health & wellness programs
Employee Benefits Analyst | Data, Contracts & Negotiation
Employee Benefits Analyst | Data, Contracts & Negotiation

NFP, an Aon company • Virginia

On-site
USD 62,000 - 77,000
PTO & paid holidays
401(k) with match
Exclusive discount programs
+1
Financial Analyst - Employee Benefits (Hybrid)
Financial Analyst - Employee Benefits (Hybrid)

Aon plc • Charlotte (NC)

On-site
USD 70,000 - 90,000
Employee Benefits Financial Analyst - Client-Focused
Employee Benefits Financial Analyst - Client-Focused

NFP • Charlotte (NC)

On-site
USD 70,000 - 90,000
PTO and paid holidays
401(k) with match
Health & wellness programs
Employee Benefits Analyst — Data, Vendors & Negotiations
Employee Benefits Analyst — Data, Vendors & Negotiations

NFP Corp • Virginia (MN)

Hybrid
USD 62,000 - 77,000
PTO & paid holidays
401(k) with match
Health & wellness programs
+1
Employee Benefits Consultant & Strategy Advisor
Employee Benefits Consultant & Strategy Advisor

NFP • Norwell (MA)

On-site
USD 77,000 - 123,000
PTO & paid holidays
401(k) with match
Exclusive discount programs
+1
Senior Employee Benefits & Renewal Lead
Senior Employee Benefits & Renewal Lead

NFP, an Aon company • Oklahoma

On-site
USD 53,000 - 65,000
PTO & paid holidays
401(k) with match
Health & wellness programs