Operations Specialist II: Data Analytics & Automation

Aon; Bannockburn (IL); Hybrid; USD 55,000 - 61,000; Full time

Benefits offered by this job

401(k) plan

Employee stock purchase plan

Medical, dental, vision insurance

Paid time off

Job summary

Aon Risk Solutions in Bannockburn, IL is seeking an Operations Specialist II to support the ACS Operations, Metrics and Automation Team. You will analyze data, run queries and help implement automation to improve processes while partnering with business units across the organization.

The role requires 3+ years of experience, proficiency in SQL and Excel, and strong analytical skills. This is a hybrid role with in-office and remote work in Bannockburn, IL, and a Bachelor's degree in

Qualifications

• Bachelor’s degree in Accounting/Finance or equivalent with 3+ years of related experience.
• SQL experience preferred.
• Excel, Access and database analytics experience.

Responsibilities

• Provide direction on actions to clear open accounts receivable.
• Oversee the review and resolution of outstanding financial transactions.
• Support cash management initiatives.
• Create and analyze complex operational reports.
• Work with finance and account teams to produce ad-hoc reports.

Skills

Analytical skills

Financial skills

Customer service focus

Education

Bachelor's degree in Accounting/Finance

Tools

SQL

VBA

Excel

Access

Pivot tables

VLOOKUP

Job description

Aon Risk Solutions in Bannockburn, IL is seeking an Operations Specialist II to support the ACS Operations, Metrics and Automation Team. You will analyze data, run queries and help implement automation to improve processes while partnering with business units across the organization.

The role requires 3+ years of experience, proficiency in SQL and Excel, and strong analytical skills. This is a hybrid role with in-office and remote work in Bannockburn, IL, and a Bachelor's degree in