Complaints Data Analyst

Canopius • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Hours Required: Full-time, Hybrid working

Job Description

The Role:

To support the Complaints Function with all Group data analysis & reporting requirements, including regulatory returns, Board level updates, Fair Value Assessments and generating data triggers which initiate our root cause analysis programme of work.

Responsibilities will include:

Generation of analysis and reports which drive business decisions in regards to Complaint handling.
Work with relevant areas of the business to understand and resolve data source and quality challenges.
Deliver improvements such as automation, to our current process to improve workflow and data quality
Create dashboards to provide insight to internal stakeholders re Complaints performance .
Complete Fair Value Assessments to ensure our products have the relevant Complaints information available
Assist with the production of all reporting requirements for the Complaints function e.g. UK ExCo packs, APAC Board, GIVM and FCA Returns
Contribute to process improvement initiatives to enhance complaints performance

Skills:

Advanced Microsoft Excel skills, including formulas and functions
Excellent working knowledge of XLOOKUP/VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IF/IFS and nested formulas
Knowledge of Power Query for importing, combining, cleansing and transforming data
Ability to automate repetitive reporting processes, ideally using macros/VBA where appropriate
Excellent analytical and problem-solving skills
Good communication skills and ability to work independently
Some understanding and experience of the Insurance market would be beneficial
Experience using Power BI is desirable but not essential

Related Jobs

Solution Data Architect

Intact Insurance (previously RSA) • Permanent • Manchester, Greater Manchester, England, United Kingdom • 1d ago

Data & Analytics Insurance Jobs

1d ago

Apply

Senior Data Engineer

Canopius • Permanent • Manchester, Greater Manchester, England, United Kingdom • 1m ago

Data & Analytics Insurance Jobs

1m ago

Apply

Data Governance & Quality Manager

Canopius • Permanent • Manchester, Greater Manchester, England, United Kingdom • 2m ago

Data & Analytics Insurance Jobs

2m ago

Apply

Claims Relationship Lead

Aviva • Permanent • Manchester, Greater Manchester, England, United Kingdom • from £45k / year • 4h ago

Claims Insurance Jobs

4h ago

Apply

Claim Professional, Solicitor

Travelers • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Legal & Company Secretarial Insurance Jobs

4h ago

Apply

Litigation Assistant, Volume: Employer Liability & Public Liability

Kennedys • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Legal & Company Secretarial Insurance Jobs

4h ago

Apply

Senior Associate, Employer Liability, Public Liability, Fraud

Kennedys • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Legal & Company Secretarial Insurance Jobs

4h ago

Apply

Technical Underwriting Specialist – Casualty

Travelers • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Underwriting Insurance Jobs

4h ago

Apply

Recruitment Assistant

Kennedys • Permanent • Manchester, Greater Manchester, England, United Kingdom • 4h ago

Recruitment & Talent Acquisition Insurance Jobs

4h ago

Apply