Complaints Data Analyst

Canopius; Manchester; On-site; GBP 42,000 - 62,000; Full time

Job summary

Canopius in Manchester is seeking a data analyst to support the Complaints Function with data analysis, reporting and regulatory returns.

You will create dashboards, automate reporting, and collaborate across teams to improve data quality and drive decision-making. Strong Excel and Power BI skills are essential; Power Query experience is valued.

Excellent analytical and communication skills are required, with an understanding of the Insurance market being beneficial.

Qualifications

• Advanced Excel skills including formulas like XLOOKUP, VLOOKUP, INDEX/MATCH
• Strong Power BI experience for dashboards and insights
• Power Query for data importing, cleansing and transforming data
• Ability to automate reporting processes using macros/VBA where appropriate
• Analytical and problem-solving capabilities
• Good communication skills and ability to work independently
• Some understanding of the Insurance market is beneficial
• Experience with Power BI is desirable but not essential

Responsibilities

• Generate analysis and reports to support complaint handling decisions.
• Collaborate with business units to resolve data source and quality issues.
• Deliver process improvements and automation to enhance workflow and data quality.
• Create dashboards to provide insight on complaints performance for stakeholders.
• Assist with regulatory returns and internal reporting for the complaints function.
• Contribute to continuous improvement initiatives in complaint handling.

Skills

Excel advanced functions

Power BI

Data analysis

Problem solving

Communication

Independent work

Insurance market knowledge

Automation

Tools

Power Query

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