Insurance Program Data Analyst (Excel Expert)

Aon; Chicago (IL); On-site; USD 60,000 - 80,000; Full time

Benefits offered by this job

401(k) with employer contributions

Health insurance

Paid time off

Job summary

Aon is seeking an Insurance Program Analyst to support the Risk Management Department. The role focuses on data reporting, validation, reconciliation, and analysis, plus insurance program administration and property onboarding/offboarding.

Strong Excel and data analysis skills are essential to identify discrepancies and produce accurate reporting for internal and client partners. The candidate will create Excel-based reports, assist with renewal activities, and prepare PowerPoint presentations.

Qualifications

• Advanced Microsoft Excel skills and experience with large datasets.
• Strong data analysis, validation, and reconciliation capabilities.
• Excellent written and verbal communication, with ability to present findings clearly.

Responsibilities

• Data reporting, validation, reconciliation, and analysis.
• Maintain and update risk management information systems.
• Prepare communications and materials related to insurance programs.

Skills

Excel

Data analysis

Pivot Tables

XLOOKUP/VLOOKUP

PowerPoint

Communication

Education

Bachelor's degree

Tools

Power BI

Tableau

ServiceNow

Jira

Job description

Aon is seeking an Insurance Program Analyst to support the Risk Management Department. The role focuses on data reporting, validation, reconciliation, and analysis, plus insurance program administration and property onboarding/offboarding.

Strong Excel and data analysis skills are essential to identify discrepancies and produce accurate reporting for internal and client partners. The candidate will create Excel-based reports, assist with renewal activities, and prepare PowerPoint presentations.