Data Analyst

Data Analyst – Aon Affinity

Do you enjoy turning complex data into clear, actionable insights for the business?

Are you excited by the challenge of solving real-world problems on a global scale?

Join Aon Affinity as a Data Analyst and help build the future of our data and analytics program!

This is an in‑office role based in Aon’s Bloomington, Illinois office.

Aon is in the business of better decisions

At Aon, we build 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.

What the day will look like

This role involves supporting data and analytics for a blend of legacy and modern systems at Aon Affinity. You will engage directly with business units to provide data solutions and insights. Leading small project teams to build practical analytics solutions will be part of your responsibilities. On any day, you may meet with business leaders to understand their analytics needs, define solutions to analytics problems, or build algorithms, data pipelines, and dashboards using tools like Databricks and Power BI. You will also assist other analysts by reviewing and contributing to their projects.

• Partner with business, marketing, IT, and other collaborators to understand business needs, build analytics strategies, and develop high-value analytics solutions. Perform business analysis to define requirements, prioritize work, and translate business questions into actionable analytics and reporting.
• Compose and build Python-based algorithms and data pipelines. Build interactive dashboards so that your results reach decision makers.
• Provide thought leadership to business units by educating them about advances in analytics and helping them apply those advances to practical business problems. Serve as a subject-matter guide for the rest of the analytics team in an analytics field such as Python, machine learning, Databricks, or solution pattern development.

How this opportunity is different

• Work on projects across various analytics, technical, and business domains—expect to tackle a significantly different project every year or two.
• Work on full-stack problems: analysts usually capture requirements, develop the solution, implement data and analytics components, and ensure results meet internal partner needs.
• Aon is a leading company in assisting clients worldwide to handle their most significant risks. Whatever drives you—be it a location, a technology, or a social issue—Aon is likely a front runner in that area.

Skills and experience that will lead to success

• Intermediate Python and SQL skills are required, with a minimum of 5+ years of experience preferred, including hands-on work modifying and maintaining Python‑based ETL pipelines. You will be expected to write queries in real time to support stakeholder discussions and use tools such as Databricks and Power BI to deliver data and analytics outputs.
• Experience applying machine learning and other sophisticated analytics techniques, and presenting findings in a clear, compelling way that develops real-world value for internal clients.
• Strong business analysis skills, able to work independently with business units to develop analytics strategy, identify high-value opportunities, and build effective solutions. Foundational project and product ownership skills include managing tasks and timelines for small projects and acting as Product Owner for data-focused work in an agile, distributed, and matrixed setting.
• Preferred qualifications include experience in the insurance sector, particularly small business P&C brokerage. Familiarity with GraphQL and D&B Hoovers or comparable small business data is valued. Expert knowledge in areas like Databricks, Python, generative AI, DevOps for analytics, business analysis, P&C analytics, or third-party data sources such as D&B is also desirable.

Education

Bachelor’s degree or equivalent experience in a quantitative field (such as Data Science, Computer Science, Mathematics, Statistics, or similar).

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.

The salary range for this position (intended for U.S. applicants) is $93,500 - $120,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.

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.

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. This role does not accrue vacation. Rather, this role is eligible to take paid time off at the discretion of the employee and management in accordance with company policy and practices. Various other types of leaves of absence; 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.

#LI-NS1

#LI-HYBRID