Insurance Program Data Analyst

Aon Corporation

Chicago (IL)

On-site

USD 60,000 - 80,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Aon Corporation in Chicago is seeking an Insurance Program Analyst to support the Risk Management Department with data reporting, validation, reconciliation, and analysis, plus insurance program administration for properties.

You will work with large datasets, create Excel-based reports and PowerPoint materials, and communicate findings effectively. Ideal candidates have 1–3 years in accounting/finance or data analytics and a bachelor’s degree.

Qualifications

  • 1–3 years of experience in accounting, finance, data analytics, business analysis, or a related field preferred.
  • Exceptional attention to detail and commitment to accuracy.
  • Strong analytical, problem‑solving, and organizational skills.
  • Strong written and verbal communication skills.
  • Ability to manage multiple priorities and deadlines.
  • Familiarity with hospitality, insurance, or risk management preferred.

Responsibilities

  • Data reporting, validation, reconciliation, and analysis.
  • Maintaining and updating risk management information systems.
  • Preparing communications and support materials related to insurance programs.
  • Onboarding and offboarding properties and managing insurance program enrollment.
  • Creating, maintaining, and enhancing Excel-based reports and tracking tools.
  • Identifying and resolving data discrepancies across multiple systems and reports.
  • Supporting insurance renewal activities through data collection and validation.
  • Assisting with insurance billing, claims reconciliation, captive reporting, and risk accrual processes.
  • Creating insurance quotations for new properties.
  • Validating exposure and financial data used for reporting and renewal purposes.
  • Providing front-line support to insurance program participants and advancing issues when appropriate.
  • Preparing PowerPoint presentations and reporting materials for internal and client partners.

Skills

Advanced Excel
Pivot Tables
XLOOKUP/VLOOKUP
Data Validation
PowerPoint
Word
Outlook
Large datasets
Data analysis

Education

Bachelor's degree

Tools

Power BI
Tableau
ServiceNow
Jira
Calendar software

Job description

Aon Corporation in Chicago is seeking an Insurance Program Analyst to support the Risk Management Department with data reporting, validation, reconciliation, and analysis, plus insurance program administration for properties.

You will work with large datasets, create Excel-based reports and PowerPoint materials, and communicate findings effectively. Ideal candidates have 1–3 years in accounting/finance or data analytics and a bachelor’s degree.

Get your free, confidential resume review.
or drag and drop your file here.
Similar jobs

Similar jobs worth comparing

Insurance Program Data Analyst (Excel Expert)
Insurance Program Data Analyst (Excel Expert)

Aon • Chicago (IL)

On-site
USD 60,000 - 80,000
401(k) with employer contributions
Health insurance
Paid time off
Insurance Program Analyst
Insurance Program Analyst

Aon Corporation • Chicago (IL)

On-site
USD 60,000 - 80,000
Insurance Program Analyst
Insurance Program Analyst

Aon • Chicago (IL)

On-site
USD 60,000 - 80,000
401(k) with employer contributions
Health insurance
Paid time off
Global Claims Ops Analyst: Data & Insights
Global Claims Ops Analyst: Data & Insights

Aon • Chicago (IL)

Hybrid
USD 65,000 - 83,000
401(k) plan
Employee stock purchase plan
Medical, dental and vision insurance
+1
Senior Analytics Program Lead (Insurance) - AI & Data
Senior Analytics Program Lead (Insurance) - AI & Data

Tiger Analytics • Chicago (IL)

On-site
USD 120,000 - 150,000
Significant career development opportunities
Equal employment opportunities
Remote Property Underwriting & Analytics Analyst
Remote Property Underwriting & Analytics Analyst

Vantage Risk Companies • Chicago (IL)

Remote
USD 80,000 - 100,000
Account Specialist I
Account Specialist I

Aon • Jacksonville (FL)

Hybrid
USD 50,000 - 60,000
401(k) savings plan
Employee stock purchase plan
Medical, dental, and vision insurance
+1
Senior Financial Analyst
Senior Financial Analyst

Aon • Dallas (TX)

On-site
USD 78,000 - 90,000
401(k) plan
Employee stock purchase plan
Medical, dental and vision insurance
+4
Health Analytics Product Analyst
Health Analytics Product Analyst

Aon Corporation • Chicago (IL)

Hybrid
USD 74,000 - 118,000
401(k) savings plan
Employee stock purchase plan
Medical, dental and vision insurance
+1
Senior Financial Analyst
Senior Financial Analyst

Aon Corporation • Dallas (TX), Miami (FL), Houston (TX)

On-site
USD 78,000 - 90,000
401(k) matching
Employee stock purchase plan
Medical, dental and vision insurance
+1