Hybrid Data Analyst & Engineer – Casualty Analytics

Gallagher; City Of London; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Career development opportunities

Collaborative culture

Global reach with local impact

Job summary

Gallagher Re is seeking a talented Data Analyst/Engineer to join the Casualty Analytics team in London. You’ll specialize in data solutions supporting complex reinsurance placements and work with actuaries to deliver scalable processes and high-quality data products.

You will build pipelines, implement data quality controls, and create dashboards to compare portfolios across clients and time periods. The role is hybrid with three days in the office.

Qualifications

• Bachelor’s degree in data science, computer science, statistics, mathematics or a similarly quantitative, technical subject.
• Proven experience in a data analyst/engineering role, focusing on technical data pipelining and analysis in the insurance industry.
• Exposure to reinsurance, in particular casualty lines, is advantageous.
• Excellent Python skills with production-quality experience using pandas and related libraries for data cleansing, transformation and automation.
• Experience with Git and collaborative development workflows.
• Strong SQL with designing relational database schemas and building data stores.
• Proven ability to work with large, messy, inconsistently structured datasets and make them analysis-ready.
• Experience designing automated data quality checks and controls.
• Advanced Excel and Power Query skills, with data visualization in Power BI.
• Excellent problem-solving and communication skills.
• Knowledge of data governance frameworks and GDPR compliance.
• Must have the right to work in the UK.

Responsibilities

• Collaborate with brokers and clients to understand data requirements and provide data-driven insights for reinsurance placements.
• Utilize advanced data analysis techniques and visualization tools to analyze large datasets and provide insights on market trends, claims experience, loss ratios, and KPIs.
• Design, build and optimize Python data pipelines to ingest, cleanse, transform and standardize datasets from multiple sources using VS Code and GitHub.
• Develop and implement robust data quality checks and controls to ensure data accuracy and completeness.
• Lead the development of a central casualty exposure and claims database, including schema design.
• Design and implement analytical tools, dashboards and benchmarking datasets that compare portfolios across clients, classes and time periods.
• Stay at the forefront of industry trends in data analysis, visualization, data engineering and AI.
• Identify and deliver opportunities to automate and streamline existing manual processes.

Skills

Python

SQL

Excel

Power BI

Power Query

Data governance

GDPR

Communication

Problem solving

Data pipelines

Education

Bachelor’s degree in data science / computer science / statistics / mathematics or similar

Tools

Git

GitHub

VS Code

Job description

Gallagher Re is seeking a talented Data Analyst/Engineer to join the Casualty Analytics team in London. You’ll specialize in data solutions supporting complex reinsurance placements and work with actuaries to deliver scalable processes and high-quality data products.

You will build pipelines, implement data quality controls, and create dashboards to compare portfolios across clients and time periods. The role is hybrid with three days in the office.