CareerPlan

Operations Specialist II

Bannockburn, IL, USFull-time2026-10-10 → 2026-11-09
Hybrid

Core

Business partner supporting Aon Business Services and ACS Operations by providing analysis, data, and automation to achieve business plans.

Role type

Operations Specialist

Builds

Operational and financial reports, automated processes, and data-driven action plans.

Domain

Insurance broking and risk management

Deliverable

dashboards & analysis

Required skills

SQL, Excel (pivot tables, V-lookups, functions), Access, database analytics, financial analysis, data aggregation

Preferred skills

Visual Basic for Applications (VBA), UiPath, complex discrepancy resolution, trend identification

Technologies

SQL, Excel, Access, VBA, UiPath, Aon systems and databases

Responsibilities

Clear open accounts receivable, oversee resolution of outstanding financial transactions, support cash management initiatives, create and analyze complex operational reports, collaborate with finance and account teams for ad-hoc reports, perform research to resolve complex discrepancies, ensure requests are processed within service level agreements, aggregate and consolidate operational and financial reports, develop action plans based on identified trends

Seniority

Mid-level, 3+ years experience