Data Analyst (Pricing)

This is a role within the Actuarial pricing team of a leading Lloyd’s insurance company and will suit a graduate with a numerate degree. Prior experience of data modelling, data analytics, data visualisation or programming languages such as Python or SQL (e.g. on coursework) is strongly desirable. The Pricing team works closely with underwriting teams to build pricing models that allow underwriters to price, compare and monitor accounts. Subsequently, data captured in these models and in wider Chaucer systems will be used in building pricing Management Information (MI) dashboards. The Data Analyst role was created to accelerate growth in developing this MI.

The incumbent will support the pricing team in the development of management information and pricing analytics to visualise data in a way that stakeholders find useful, as well as support on relevant data manipulation, documentation, and quality/accuracy testing. This will support sustainable profitable growth and to support strategic initiatives. This role will involve working with key members within Pricing and the wider business, and supporting and developing knowledge across Chaucer’s many lines of business (e.g. scope may include Casualty, Property, Energy, Marine, Credit Lines). There is no actuarial study support provided as part of the contract.

Main duties

• Design, build and enhance data visualisation dashboards (in Power BI) that meet business requirements and incorporate improved insights (in line with relevant frameworks and technological requirements).
• Support on relevant data manipulation, documentation, and quality/accuracy testing.
• Work collaboratively with underwriters, the pricing team and management across the pricing MI planning and development process, in coordination of best practices, and sharing knowledge.
• Research and develop techniques and approaches to deliver improvements in MI capabilities, data quality and operational efficiency through model design and use of technology.
• Document new dashboards and provide training.
• Communicate and present pricing MI dashboards to business stakeholders.
• Assistance for other pricing team activities as required, for example in building Excel based pricing models with VBA.

Our requirements

Technical skills

• Understanding of data warehouses, data transformation and relational databases, for example in SQL, Power Query, DAX or other software.
• Ability using Excel to manipulate, analyse and validate data effectively to derive actionable insights from complex datasets.
• Experience in coding like Python or R for data analysis, automation, and problem-solving.
• Experience in presenting complex data to non-technical audiences; using tools like Excel, Tableau, or Power BI to create clear, visually engaging reports and dashboards.

Personal skills

• Succinct and clear verbal and written skills.
• Capable analytical skills – logical, methodical and rational approach to problem solving.
• Comfortable with interpreting and producing numerical data.
• Able to present findings to key stakeholders.
• Attention to detail related to both mathematical calculations and clarity of narrative.
• Self-motivated, hard-working and takes initiative.
• Organised and clear thinking.
• Ability to plan and organise work to meet targets and deadlines.
• Able to collaborate, work as a team and communicate with staff at all levels.

Education & Experience

• 2.1 or 1st degree (or equivalent) in a numerate subject (Maths, Engineering or Computer Science) would be desirable.
• 3 or more ‘A’ levels or equivalent (B or higher), including Mathematics would be desirable.

Chaucer is a leading insurance group at Lloyd’s, the world’s specialist insurance market. We help protect industries around the world from the risks they face. Our customers include major airlines, energy companies, shipping groups, global manufacturers and property groups. Our headquarters are in London, and we have international offices in Bermuda, Copenhagen, Dubai and Singapore to be closer to our clients across the world. To learn more about us please visit our website. Chaucer is committed to diversity, actively values difference and respects people regardless of the protected characteristics which are outlined in the Equality Act 2010 (UK legislation) as a result of the Equal Treatment Directive 2006 (EU legislation). A diverse workforce and an inclusive workplace are core to our success as a business and integral to our winning strategy and culture. We recruit from the widest available pool of talent, and our hiring, assessment and selection process is fair, free from bias and one which ensures we select the right person for the job, based on merit. We are committed to promoting a culture that actively values difference, and recognises that everyone has the right to be treated with dignity and respect throughout their employment. We are open to considering flexible working arrangements for all roles and encourage you to outline your needs during the interview process.