Broking Insights - Senior Data Analyst

Aon Corporation; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A global insurance firm in the City of London is seeking a Senior Data Analyst to enhance their analytics capabilities. This role requires a blend of SQL, Power BI expertise, and strong communication skills to deliver actionable insights. The successful candidate will contribute to data solutions in a hybrid working environment, leveraging their knowledge of the Lloyd's market. A diverse and inclusive workplace is a priority, encouraging applications from all backgrounds.

Benefits

Global Wellbeing Days

Comprehensive benefits package

Learning and growth opportunities

Qualifications

• Proven experience in insurance analytics within the Lloyd's or London Market.
• Strong stakeholder management and influencing skills.
• High commercial awareness and strategic thinking.

Responsibilities

• Build scalable data models and optimize performance.
• Collaborate with brokers and carriers for actionable insights.
• Deliver innovative insights using insurance market expertise.

Skills

SQL

Power BI - Advanced modelling

Power Automate

Excellent communication

Data storytelling

Stakeholder management

Insurance analytics

Data governance

Regulatory compliance

Understanding of underwriting principles

Tools

Power Automate

Power Apps

ETL processes using SQL

Python

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Broking Insights - Senior Data Analyst

Would you like to be part of a growing analytics team looking to drive forward advanced data-driven decision making at the heart of Lloyd's insurance market?

Do you have a passion for analytics, visualization and generating real business impact through communicating value insights?

We are seeking a highly skilled Senior Data Analyst to join our forward-thinking broking analytics team. This role combines commercial acumen, deep insurance expertise, and analytical capabilities to deliver actionable insights and optimize decision-making across the organization. The successful candidate will deliver data solutions, standardize reporting practices, scale our Power BI capabilities and enhance analytical capability across departments.

Based from our flagship London office, this role comes with Hybrid working.

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 organisation, 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

• Power BI Development: Build scalable data models, optimize performance, and standardize reporting frameworks.
• Collaborate with brokers, operations, and carriers to assess analytics requirements and translate business needs into actionable insights.
• Insurance Market Expertise: Leverage Lloyd's market knowledge to inform analytics solutions and reporting.
• Utilize deep insurance knowledge to deliver innovative insights
• Data Governance - embed standards and practices to improve data quality
• Liaise with analytics capabilities across departments and co-ordinate to deliver business-centric solutions
• Engage in strategic data transformation projects to provide technical guidance
• Data Engineering & Automation: Develop ETL processes using SQL and Python;
• Implement Power Automate and Power Apps for workflow automation.
• AI & Emerging Technologies: understand how to leverage emerging capabilities

How this opportunity is different

This is an outstanding opportunity to utilise your data, reporting and technical skills in the Corporate/Commercial world. You'll be joining a welcoming, collaborative and supporting team that is highly valued and respected throughout our firm and your work and output will make a positive impact on the continued success of our London Market broking teams. Aon is a proud advocate of internal mobility and this role will give you the foundations of a flourishing and rewarding career here.

Skills and experience that will lead to success

• Mandatory: SQL, Power BI - Advanced modelling, optimization, and governance.
• Power Automate / Power Apps - Workflow and app development.
• Excellent communication and data storytelling.
• Strong stakeholder management and influencing skills.
• High commercial awareness and strategic thinking.
• Collaborative and adaptable in a fast-paced environment.
• Proven experience in insurance analytics within the Lloyd's or London Market.
• Expertise in standardising reporting practices and scalable BI solutions.
• Experience with Microsoft Co-Pilot Studio or similar Agentic AI tooling.
• Familiarity with regulatory compliance and data governance practices.
• Understanding of underwriting principles and performance analytics.

How we support our colleagues

In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two "Global Wellbeing Days" each year, encouraging you to take time to focus on yourself. We offer 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. As a result, at Aon, you are more connected, more relevant, and more valued.

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.

Aon welcomes applications from all and provides individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email [e-mail]