Complaints Data Analyst - Automation & Dashboards

vavemga

Manchester

Hybrid

GBP 35,000 - 55,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

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

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.

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
Complaints Data Analyst

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
Business Analyst, Complaints Data & MI (Hybrid UK)
Business Analyst, Complaints Data & MI (Hybrid UK)

Tenth Revolution Group • City Of London

Hybrid
GBP 42,000 - 60,000
Data-Driven Complaints Insight Analyst
Data-Driven Complaints Insight Analyst

OVO • United Kingdom

On-site
GBP 31,000 - 36,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
Complaints Team Leader — Data‑Driven & Hybrid Role
Complaints Team Leader — Data‑Driven & Hybrid Role

Lendable • England

Hybrid
GBP 50,000 - 70,000
Flexible working
Private health cover
Pension plan
+1
Complaints Risk & Data Analyst (Hybrid)
Complaints Risk & Data Analyst (Hybrid)

Santander • Glasgow

On-site
GBP 38,000 - 57,000
Competitive rewards
Wellbeing programs
Family leave & childcare options
+2
Business Analyst - Complaints Data & MI
Business Analyst - Complaints Data & MI

Tenth Revolution Group • City Of London

Hybrid
GBP 42,000 - 60,000