Broking Insights - Senior Data Analyst
Role details
Job location
Tech stack
Job description
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 model performance, and standardize reporting frameworks to deliver
- Deliver engineering pipelines in Databricks to create structured scalable assets to meet the evolving needs of the reporting requirements
- Assess AI for BI opportunities, leveraging LLMs and
- Develop reporting frameworks from critical source systems to enable deeper insights into operational and broking performance
- 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
- Deep of Data Modelling and architecture is
- 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
Requirements
Do you have experience in Underwriting?, 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, Python scripting - Advanced modelling, optimization, and governance.
- Expertise in standardising reporting practices and scalable BI solutions.
- Excellent communication and data storytelling.
- Passion for AI and experience leveraging it in a commercial context
- 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 / broking principles and performance analytics (loss ratios)