Data Analyst (Exposure Management)

Lancashire Group; London; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading insurance company seeks a Data Analyst for its Exposure Management team, where you will enhance processes through data analysis and reporting. The position demands proficiency in tools like SQL and Power BI, along with strong analytical skills and a solid understanding of insurance business processes.

Qualifications

• Experience in Specialty Insurance and Exposure Management.
• Proficiency in SQL, Power BI, advanced analytics.
• Ability to work independently and effectively communicate.

Responsibilities

• Perform data analysis to support business processes.
• Develop understanding of data stores and reporting capabilities.
• Collaborate with stakeholders to define data requirements.

Skills

Data analysis

Problem-solving

Communication

Advanced SQL

Power BI

ETL/ELT processes

Education

Bachelor’s degree in Technology or Data related field

Tools

SQL Management Studio

Power BI

SSIS

Azure Synapse

Job description

Data Analyst (Exposure Management)

Application Deadline: 30 June 2025

Department: IT

Employment Type: Permanent - Full Time

Location: London

Description

The primary purpose of this role is to support the Exposure Management function with enhancing their processes and reporting capabilities through technology, automation, and data analysis principles.

Specific Responsibilities

• Work closely with the business stakeholders to understand the requirements, perform data analysis to assess quality, meaning and usage of data
• Support the business processes with their data requirements: ad-hoc data queries and extracts
• Develop an understanding of the existing data stores and data availability within the application landscape to support the business needs
• Requirement analysis and provide input on proposed delivery options
• Support delivery and testing teams in defining scope, reviewing output, testing coverage, validation of test scenarios, etc.

Note – This job description is not intended to be all encompassing and other related duties may be required to meet the ongoing needs of the organisation

Essential Skills & Requirements

• Previous Specialty Insurance experience with a good understanding of business processes, especially in Exposure Management
• Experience in data analysis and proficiency in using tools like SQL (management studio, stored procedures), excel, Power BI, etc. to support data analysis
• Experience in building reusable data extracts using ETL/ELT processes
• Advanced analytical and problem-solving skills
• Ability to work independently and communicate effectively (complex ideas, recommendations, solution approaches, etc.) with a diverse set of business and technical stakeholder groups
• Bachelor’s degree in Technology or Data related field is preferred
• Understanding of actuarial practices
• Experience in data visualisation and report building using tools like Power BI
• Experience in working on software development and delivery projects using tools like SSIS, Azure Synapse, etc.
• Demonstratable interest and awareness in emerging technologies

The Lancashire Way

At Lancashire, we believe our culture sets us apart. The way we behave and approach our work day-to-day is what makes us unique and creates a positive experience for our people, business partners and other stakeholders. Honesty and integrity in all we do is a given and The Lancashire Way reflects our true character and spirit.

Straight-talking

We feel empowered to share thoughts and ideas, because everyone’s voice matters.

Collaborative

We work together towards common goals, share knowledge and support each other.

Hard-working

We all have a stake in the company’s success and are proactive in contributing to our goals and vision.

Responsible

We focus on achieving tangible results with consistent standards across the Group.

Positive

We engage with brokers, clients, communities, stakeholders and colleagues professionally and passionately as proud ambassadors of Lancashire.