Hybrid Operations & Data Analyst II

Aon plc; Illinois; Hybrid; USD 55,000 - 61,000; Full time

Benefits offered by this job

401(k) plan with employer contribution

Employee stock purchase plan

Health insurance

Paid time off

Job summary

Aon plc is seeking an Operations Specialist II in Bannockburn, IL. This role partners with multiple business units to analyze data, generate operational reports, and drive process improvements through automation.

Ideal candidates have 3+ years of relevant experience, strong SQL skills, and proficiency with Excel, VBA, and Access. This is a hybrid in-office/remote position based in Bannockburn, IL.

Qualifications

• Bachelor’s degree in Accounting/Finance or equivalent with 3+ years’ related experience.
• Strong SQL experience and data analysis skills are required or preferred.
• Experience with Excel, Access, pivot tables and VBA is highly desirable.

Responsibilities

• Produce and analyze complex operational reports across business units.
• Pull data via queries and support automation and process efficiencies.
• Support cash management initiatives and oversee unresolved financial transactions.

Skills

SQL

VBA

Excel

Access

Pivot tables

VLOOKUPs

Education

Bachelor's degree in Accounting/Finance

Tools

UiPath

Job description

Aon plc is seeking an Operations Specialist II in Bannockburn, IL. This role partners with multiple business units to analyze data, generate operational reports, and drive process improvements through automation.

Ideal candidates have 3+ years of relevant experience, strong SQL skills, and proficiency with Excel, VBA, and Access. This is a hybrid in-office/remote position based in Bannockburn, IL.