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.

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.

• 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.

• 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 Graph
  
  QL and D&B Hoovers or comparable small business data is valued. Expert knowledge in areas like Databricks, Python, generative AI, Dev Ops for analytics, business analysis, P&C analytics, or third‑party data sources such as D&B is also desirable.

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…