Complaints Data Analyst

Canopius Group; Manchester; On-site; GBP 55,000 - 75,000; Full time

Job summary

Canopius Group in Manchester is seeking a data analyst to support the Complaints Function with group data analysis, regulatory returns, board updates, and root-cause analysis triggers.

The role involves building dashboards, automating reporting, and ensuring data quality to drive informed decisions on complaint handling across the organization.

Qualifications

• Advanced Excel skills: formulas and functions.
• Proficient with XLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IF/IFS.
• Experience with Power Query for data cleansing and transformation.
• Ability to automate reporting using macros/VBA where appropriate.
• Strong analytical and problem-solving abilities.
• Good communication and ability to work independently.
• Some understanding of the Insurance market is beneficial.
• Experience with Power BI is desirable.

Responsibilities

• Generation of analysis and reports to drive complaints handling decisions.
• Collaborate with business areas to resolve data quality challenges.
• Deliver improvements and automation to current processes.
• Create dashboards to provide insight to internal stakeholders on complaints performance.
• Complete Fair Value Assessments to ensure relevant complaints information is available.
• Assist with production of reporting for the Complaints function (UK ExCo, APAC Board, FCA returns).
• Contribute to process improvement initiatives to enhance complaints performance.

Skills

Excel formulas

XLOOKUP

INDEX/MATCH

SUMIFS

COUNTIFS

IF/IFS

Nested formulas

Data analysis

Analytical thinking

Communication skills

Tools

Power Query

Power BI

Macros/VBA

Job description

JOB DESCRIPTION

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.

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