Complaints Data Analyst

vavemga

Manchester

Hybrid

GBP 35,000 - 55,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

vavemga is seeking a data analyst to support the Complaints Function with data analysis, reporting, and regulatory returns. The role involves building dashboards in Power BI, automating reports with Excel/VBA, and ensuring data quality across sources.

You will collaborate with various teams to produce UK ExCo packs and FCA returns, driving improvements in complaints performance through analytical insights.

Qualifications

  • Advanced Microsoft Excel skills with formulas and functions.
  • Proficient with XLOOKUP/VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, IF/IFS and nested formulas.
  • Knowledge of Power Query for data import, cleansing and transformation.
  • Ability to automate repetitive reporting processes using macros/VBA.
  • Excellent analytical and problem-solving skills.
  • Good communication and ability to work independently.
  • Some understanding of the Insurance market is beneficial.
  • Experience using Power BI is desirable but not essential.

Responsibilities

  • Generate analysis and reports driving decisions on complaint handling.
  • Collaborate with business areas to resolve data source quality issues.
  • Deliver improvements and automation to enhance workflow and data quality.
  • Create dashboards for internal stakeholders on complaints performance.
  • Complete Fair Value Assessments to ensure relevant information is available.
  • Assist with reporting for Complaints (UK ExCo, APAC Board, FCA Returns).
  • Contribute to process improvements to boost complaints performance.

Skills

Advanced Excel skills
XLOOKUP/VLOOKUP/INDEX-MATCH
Power Query
Macros / VBA
Analytical thinking
Communication skills
Insurance market knowledge
Power BI (desirable)

Tools

Excel
Power BI
VBA

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
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Complaints Data Analyst
Complaints Data Analyst

Canopius • Manchester

On-site
GBP 42,000 - 62,000
Complaints Data Analyst - Automation & Dashboards
Complaints Data Analyst - Automation & Dashboards

vavemga • Manchester

Hybrid
GBP 35,000 - 55,000
Complaints Data & Insights Analyst
Complaints Data & Insights Analyst

Canopius Careers • Manchester

On-site
GBP 42,000 - 62,000
Complaints Insights Specialist
Complaints Insights Specialist

Harnham • Nottingham

On-site
GBP 35,000 - 50,000
Competitive salary and benefits package
Clear development pathways
Collaborative team culture
Customer Complaints Insights Strategist
Customer Complaints Insights Strategist

Harnham • Nottingham

On-site
Confidential
Compliance Analyst
Compliance Analyst

Ips Group • England

On-site
GBP 40,000 - 60,000
Complaints Analyst
Complaints Analyst

vavemga • Manchester

Hybrid
GBP 40,000 - 60,000
Complaints Assessor
Complaints Assessor

Fintellect Recruitment • Greater London

On-site
GBP 30,000 - 45,000
Competitive salary and benefits package
Flexible working arrangements
Supportive working environment
Complaints Analyst
Complaints Analyst

Canopius • Manchester

On-site
GBP 45,000 - 75,000
Business Analyst - Complaints Data & MI
Business Analyst - Complaints Data & MI

Tenth Revolution Group • City Of London

Hybrid
GBP 42,000 - 60,000