Data Analyst (Exposure Management)

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

Job summary

Une entreprise majeure dans le secteur de l'assurance recherche un analyste pour renforcer son équipe de Gestion des Expositions. Le rôle consiste à améliorer les processus et les rapports via l'analyse des données. L'opportunité est idéale pour un professionnel avec une solide expérience en assurance et des compétences en analyse de données, qui souhaite travailler dans un cadre collaborative et dynamique.

Qualifications

• Expérience préalable dans l'assurance spécialisée, compréhension des processus métier.
• Compétences avancées en analyse de données et utilisation de SQL, Power BI.
• Capacité à travailler de manière autonome et à communiquer des idées complexes.

Responsibilities

• Supporter la gestion des données avec l'analyse et les exigences des processus métier.
• Développer une compréhension des stockages de données existants pour répondre aux besoins.
• Collaborer avec les équipes de livraison pour définir le périmètre et tester les besoins.

Skills

Analyse de données

SQL

Power BI

ETL/ELT

Résolution de problèmes

Communication efficace

Education

Baccalauréat en technologie ou domaine lié aux données

Tools

SSIS

Azure Synapse

Job description

Application Deadline: 30 June 2025

Department: IT

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.