Insurance Program Analyst

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

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

Insurance Program Analyst

Seeking a highly analytical and detail-oriented individual to support our client’s Risk Management Department. This position is responsible for data reporting, validation, reconciliation, and analysis, as well as insurance program administration, property onboarding and offboarding, and support of various insurance and financial processes!

Success in this role depends heavily on strong Excel and data analysis skills. The ideal candidate will be comfortable working with large datasets, identifying discrepancies, creating reports, maintaining data integrity, and communicating findings effectively through Excel and PowerPoint.

Responsibilities

The Insurance Program Analyst will support the insurance, finance, and technology functions within the Risk Management Department. Responsibilities include, but are not limited to:

• 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

Experience

• 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

Computer Skills Needed to Perform this Job

Required

• Advanced Microsoft Excel skills, including experience working with large datasets
• Experience using Pivot Tables, lookup functions (XLOOKUP/VLOOKUP), filtering, sorting, and data validation
• Microsoft Word, Outlook, and PowerPoint proficiency
• Ability to create reports, reconcile data, and identify trends or inconsistencies

Preferred

• Power BI, Tableau, or other data visualization tools
• ServiceNow, Jira, or other ticket management platforms
• Calendar, scheduling, or project management software

Education

• Bachelor's degree or comparable on-the-job experience

Success in This Role

The successful candidate will be someone who enjoys working with data, can quickly identify errors or inconsistencies, and is comfortable using Excel to analyze information, solve problems, and produce accurate reporting. Insurance experience is helpful, but strong analytical capabilities and advanced Excel skills are the most critical qualifications for success in this position.

For positions in San Francisco and Los Angeles, we will consider for employment qualified applicants with arrest and conviction record in accordance with local Fair Chance ordinances.

The salary range for this position (intended for U.S. applicants) is $60,000 - $80,000 annually. The actual salary will vary based on applicant’s education, experience, skills, and abilities, as well as internal equity and alignment with market data. The salary may also be adjusted based on applicant’s geographic location.

Aon offers a comprehensive package of benefits for full-time and regular part-time colleagues, including, but not limited to: a 401(k) savings plan with employer contributions; an employee stock purchase plan; consideration for long-term incentive awards at Aon’s discretion; medical, dental and vision insurance, various types of leaves of absence, paid time off, including 12 paid holidays throughout the calendar year, 15 days of paid vacation per year, paid sick leave as provided under state and local paid sick leave laws, short-term disability and optional long-term disability, health savings account, health care and dependent care reimbursement accounts, employee and dependent life insurance and supplemental life and AD&D insurance; optional personal insurance policies, adoption assistance, tuition assistance, commuter benefits, and an employee assistance program that includes free counseling sessions. Eligibility for benefits is governed by the applicable plan documents and policies.

This position is eligible to participate in one of Aon’s annual incentive plans to receive an annual discretionary bonus in addition to base salary. The amount of any bonus varies and is subject to the terms and conditions of the applicable incentive plan.