Data Analyst

Parkinson's UK; Liverpool; Hybrid; GBP 30,000 - 40,000; Full time

Job summary

A leading company in the insurance sector is looking for a motivated Data Analyst to join their team. This role, based in Liverpool, focuses on data mapping processes and involves using advanced data tools to support the insurance services teams. The ideal candidate will possess strong analytical skills, a detail-oriented approach, and some familiarity with insurance principles. There is a hybrid working model allowing for both home and remote work.

Qualifications

• Strong technical skills and logical thinking.
• Experience with database querying (SQL, R, Python) desirable.
• Understanding of insurance and reinsurance principles.

Responsibilities

• Data collection and processing from various sources.
• Creation and management of Risk and Claims data maps.
• Identifying and correcting anomalies within the Bordereau.

Skills

Problem-solving skills

Attention to detail

Logical thinking

Technical skills

Tools

SQL

R

Python

VBA

PowerBI

Job description

Pro currently has an exciting opportunity for a motivated and detail-oriented individual to join its Insurance Services team as a Data Analyst within the Digital Services area.

The job holder will be involved in building data mapping processes for various bordereaux (both Risk and Claims) using data ingestion/analysis tools such as Intrali, Quantemplate, or Matillion. The project focuses on the extraction, transformation, and loading (ETL) of data from various sources into data warehouses and data lakes.

This is an ideal role for an aspiring Data Architect in the Insurance Industry.

Pro operates a hybrid working policy, with time split between home and our Gloucester or Liverpool office. However, this vacancy is suitable for a fully remote individual, and we support home working.

Main Duties and Responsibilities

• Data collection and processing; gathering data from various sources, pre-processing, and preparing datasets for analysis.
• Creation and management of Risk and Claims data maps (models) and reconciliation of results.
• Processing tasks accurately and efficiently, in line with client requirements.
• Identifying or correcting anomalies within the Bordereau, raising queries, and amending where necessary.
• Interacting professionally with clients via phone, Teams, or email.
• Maintaining and updating workflows and ad hoc documentation (process flows).
• Collaborating effectively with colleagues.

Skills and Experience

• Strong technical skills, logical and methodical thinking, with the ability to prioritize workload to meet deadlines independently.
• Problem-solving skills with good attention to detail.
• Experience with Microsoft packages including Excel or PowerBI is desirable.
• A logical mindset and good problem-solving capabilities.
• Database querying and/or development skills (e.g., SQL, R, Python, VBA, PowerBI) are desirable.
• Understanding of insurance and reinsurance principles is desirable.
• Conscientious, positive, and enthusiastic approach to work is essential.

The Company

Pro is a specialist outsourcing and consulting company focused solely on the insurance and reinsurance industries.

We work with clients to improve business processes, reduce operating overheads, and implement controls to meet new regulations, delivering tailored solutions.

Our UK offices are in Gloucester, Glasgow, Liverpool, Horsham, and central London. We also have offices in the United States, Cologne, Unna (Germany), and Argentina. We support a hybrid working model, allowing you to work from home and in the office.

We provide expert support in underwriting, claims management, financial and technical accounting, and risk and auditing, utilizing top technology and a proactive approach.