Operations Specialist II

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 is looking for an Operations Specialist II in Bannockburn, IL !!

Aon Risk Solutions, the global risk management business of Aon plc (NYSE: AON), is the worldwide leader in risk advice and insurance broking. Guided by the Aon Client Promise, our teams help clients achieve profit, growth and continuity by delivering the best tailored and innovative risk solutions. We empower results through unmatched tools and capabilities, including the award-winning Aon Global Risk Insight Platform. For more information, visit aon.com/empower results.

As the Operations Specialist, you will support Aon Business Services and ACS Operations, Metrics and Automation Team. This opportunity is viewed as a business partner & advisor who assist varying levels of business unit and corporate personnel in providing analysis, information and data to support achievement of business plans. Additionally, responsible for pulling data via queries and implementing automation and process efficiencies. This role is located in Bannockburn, IL and will be hybrid (In office & remote)

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed.

Job Duties and Responsibilities:

• Works across business units to provide direction on actions needed 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 team to produce ad-hoc reports
• Collaborate with colleagues from other locations and departments to facilitate data requirements
• Follow standard practices in technology development within the department
• Assist with proactive management of team deliverables
• Policy Management System conversion testing and support
• Perform research to resolve complex discrepancies or client servicing challenges
• Ensures requests received are processed within applicable service level agreement
• Ad hoc analysis utilizing Aon systems and databases
• Identify trends and work with leadership to develop action plans
• Business decision support
• Aggregate and consolidate Operational and Financial reports
• Ensure company and division policies are practiced and supported
• Other responsibilities and enterprise duties as assigned
• Create operational reports for daily business processes
• Create ad-hoc reporting on an as needed basis
• Collaborate with colleagues from other locations to facilitate data requirements
• Relies on experience, judgment and best practices to plan and accomplish goals
• Perform other duties as assigned.

Education Requirements:

• Bachelor's degree in Accounting/Finance and/or equivalent from an accredited college or technical school; 3 or more years related experience and/or training; or equivalent combination of education and experience.

What we're looking for:

• 3+ years of related work experience
• SQL experience preferred
• Visual Basic for Applications (VBA) experience preferred
• Excel, Access and database analytics
• Hands-on experience using Excel, including pivot tables, V-lookups, graphs, functions, links as well as working with external Client/System data preferred
• Strong analytical and financial skills with a customer service focus preferred
• a self-starter and independent individual who is able to work in a deadline driven environment

Competency we are looking for:

• Fosters teamwork: Works well with others in a group, cooperates with others, offers to help when needed, and fosters a team climate within the project group.
• Communicates effectively with others: Speaks and writes in a clear and concise manner to coworkers, supervisors and customers.
• Suggests and embraces improvement and drives for results: Makes suggestions to improve quality in processes, site work flow and functionality; driving above and beyond the status quo.
• Plans & organizes: Sets priorities, plans and coordinates work activities so that work objectives are accomplished on time.
• Acts with integrity: Demonstrates consistency between words and behavior; consistently behaves in a manner that maintains and enhances Aon's reputation for ethical dealings; commits to and accepts accountability for results, obligations and standards of conduct; and has the courage to speak up for clients, employees, and shareholders' interests.
• Commitment to client service: Proactively assesses, identifies, and responds to the needs of internal clients, ensures they are addressed quickly and accurately. Consistently meets or exceeds service expectations. Establishes and achieves agreed upon measures of client satisfaction. Places the needs of the business and clients above personal needs when necessary.

Preferred:

• Manages conflict: Develops and maintains positive working relationships with coworkers, supervisors, and customers, and effectively handles conflict situations.
• Establishes effective relationships: Builds rapport with managers & other Aon colleagues, external clients and vendors; utilized appropriate resources to be successful.
• Applies job and technical knowledge: Applies specialized knowledge, tools and methodologies within the UiPath and SQL development discipline to enhance organizational performance. Stays abreast of technical developments within the discipline, as well as within the broader business arena.

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.

Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate.

Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

Pay Transparency Laws

The salary range for this position (intended for U.S. applicants) is $55,000 to $61,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.

A summary of all the benefits offered for this position:

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.