M&A Insurance Data Analyst

Join a role at the intersection of data, underwriting, and broking with a focus on Warranty & Indemnity (W&I) / Representations & Warranties (R&W) and Tax Contingent insurance. Be part of a team that ensures the accuracy, quality, and insightfulness of data to support senior colleagues, insurers, and internal collaborators. This is a brand-new role in the AMATS team, offering flexibility to work virtually and from the flagship London office.

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

• Manage, cleanse, and validate data associated with M&A insurance, investigating anomalies and maintaining high data-quality standards across systems.
• Build and maintain insightful dashboards and reports, giving senior broking leaders visibility on performance, pipeline, trends, and key trading metrics.
• Apply insurance knowledge to correctly structure, classify, and interpret deal data, ensuring accurate reflection of coverage and insurer requirements.
• Support the design and optimisation of facilities/lineslips, using data to shape pricing bands, participation structures, and reporting packs for insurers.
• Act as the bridge between data teams and brokers, translating raw data into meaningful insurance language, defining business rules, and guiding enhancements to data models and reporting pipelines.

How this opportunity is different

This role uses your data expertise to shape decisions. You’ll work with rich, complex datasets to uncover insights that directly influence senior leaders, helping steer strategy across high-profile M&A and specialty insurance lines. If you love solving problems, elevating data integrity, and making a tangible impact in a fast-growing part of the business, this role provides that platform.

Skills and experience that will lead to success

• Advanced data capability — strong Excel (complex formulas, pivots, lookups, Power Query/Pivot) plus experience with tools like Power BI, Tableau, or SQL for high-quality analysis.
• Data integrity & analytical rigour — comfortable handling large, complex datasets, interrogating data, spotting inconsistencies, and performing thorough sense-checks.
• Insightful reporting — ability to build dashboards and MI that tell a clear story for senior collaborators, ensuring outputs are meaningful and commercially relevant.
• Insurance & facilities exposure — ideally experience in M&A insurance, specialty lines, or managing facilities/binders/lineslips.
• Clear communication & collaboration — able to translate technical data into accessible insurance language, and work effectively with offshore/centralised data teams.

How we support our colleagues

In addition to our comprehensive benefits package, we encourage an inclusive workforce. Our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. We offer two “Global Wellbeing Days” each year to focus on yourself. We provide a variety of working style solutions for our colleagues as well.

Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, colour, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

We are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know by emailing us at ReasonableAccommodations@Aon.com or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience.