Senior Data Analyst

Senior Data Analyst – SQL, Python & Power BI

Location: Remote or Hybrid (Cardiff), UK

Salary: Up to £48,000 per year

Employment type: Permanent

Job Overview

A Senior Data Analyst is required to support data quality, analysis and client migration projects within financial services. The role combines hands-on SQL and Python analysis with data validation, reconciliation, automation and stakeholder engagement.

Working across business and technical teams, you will investigate complex data issues, support migration activities and develop solutions that improve data accuracy, reporting and operational efficiency.

Key Responsibilities

• Lead day-to-day data management activities, maintaining data integrity and managing risks and issues.
• Analyse and resolve complex data queries across existing portfolios and new client migrations.
• Profile, reconcile and validate data from multiple sources throughout the migration lifecycle.
• Support migration planning, requirements gathering, implementation, testing and go-live activities.
• Communicate technical findings and data-quality issues to business stakeholders, clients and project teams.
• Act as a data subject matter expert in client meetings, workshops and project discussions.
• Improve data-quality tools, reporting processes and controls.
• Develop automated solutions to reduce manual work, processing time, errors and operational risk.

Requirements

• Strong practical SQL skills, including data analysis, profiling, reconciliation and validation.
• Experience using Python for data analysis, process automation and reusable data-quality solutions.
• Experience with Microsoft Fabric or an equivalent cloud data platform, including data pipelines, analytical datasets and notebooks.
• Power BI experience, including Power Query, data modelling, DAX and KPI development.
• Strong analytical and problem-solving skills, including trend, variance, anomaly and root-cause analysis.
• Ability to translate business requirements into scalable analytical solutions.
• Confident communicating complex technical findings to business, technical and senior stakeholders.
• Knowledge of Centrac is advantageous.

Benefits

• 30 days' annual leave plus bank holidays
• Employer-matched pension contributions of up to 6%
• Private medical insurance
• Group life assurance and income protection
• Discretionary annual bonus and salary review
• Employee discounts and cashback offers
• Enhanced parental leave
• Employee Assistance Programme and wellbeing support
• 24/7 GP access
• Learning and career development opportunities
• Additional benefits, including discounted gym memberships and a cycle-to-work scheme