Data Analyst
UK Visa Sponsorship Analytics
Above analytics are generated algorithmically based on job titles and may not always be the same as the company's job classification. You can also check detailed occupation eligibility, and salary criteria on our UK Visa Eligible Occupations & Salary Thresholds page.
Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with FixMyCar. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
About FixMyCar
We are the UK’s most trusted site for car repairs and maintenance, helping millions of drivers each year compare prices on repair services from the UK’s largest network of trusted garages.
Our mission is to simplify vehicle ownership by connecting leading garages with drivers online. We strive to empower drivers with choice and convenience when comparing and booking garages, whilst keeping trust and transparency at the heart of everything we do.
The role
We are looking for a Data Analyst to own and evolve our analytics layer across operations, finance, and marketplace performance.
This self-starter role sits at the intersection of analytics and data engineering: you will work directly with production datasets, maintain canonical reporting tables, and deliver business-critical insights used across Finance, Commercial, and Operations.
You will inherit a mature but evolving data model and will be responsible for ensuring consistency, accuracy, and scalability of reporting outputs.
Key Responsibilities
Analytics and Reporting:
- Own and maintain core reporting datasets (e.g. jobs, quotes, finance, garage performance)
- Deliver dashboards and analyses in Metabase and Power BI
- Translate business questions into structured SQL queries and data models
- Ensure metric definitions are consistent across reports (e.g. acceptance rate, quote rate, refunds)
Data Modelling (Operational Analytics Layer)
- Work with denormalised “one big table” models (e.g. jobs-level datasets)
- Maintain and extend canonical tables such as jobs detailed datasets, quote activity facts, and finance daily aggregates
- Apply correct time semantics (created vs accepted vs activity-based metrics)
- Avoid double counting, duplication, and incorrect joins (especially at job/mechanic grain)
SQL Development (Core Skill)
- Write efficient, production-grade SQL in MySQL
- Build and optimise aggregation pipelines, CTE-based transformations, incremental refresh logic
- Debug discrepancies between datasets and reconcile metrics across sources
- Work with large datasets with performance in mind
Data Pipeline Ownership
- Maintain scheduled data refresh processes (MySQL events / scheduled jobs)
- Diagnose and fix data freshness or accuracy issues
- Support backfills and one-off rebuilds where required
- Ensure reporting tables remain reliable and trusted
Business Insight & Stakeholder Support
- Partner with Finance, Operations, and Commercial teams
- Provide clear, structured explanations of metrics (technical → non-technical translation)
- Support investigations into performance issues (e.g. conversion drops, leakage, pricing impact)
Skills and Competencies (Essential)
- Strong SQL skills (Joins, aggregations, window functions, CTEs; Ability to reason about grain and duplication)
- Experience working with relational databases (preferably MySQL)
- Experience with BI tools (preferably Metabase or Power BI)
- Solid understanding of data modelling concepts (fact vs dimension tables, denormalised reporting models, metric definitions and consistency)
- Strong problem-solving and debugging skills
- Ability to reconcile conflicting data sources
- Comfort working with ambiguous requirements and iterating quickly
- Ability to clearly explain data concepts to non-technical stakeholders
- Structured thinking and clear output (tables, metrics, definitions)
- Attention to detail
Skills and Competencies (Desirable)
- Experience with Python for data analysis or lightweight data processing (e.g. Pandas, ad hoc pipelines)
Benefits
- Hybrid working/flexible working (office: Reading)
- Holidays: 25 days per annum + Birthday Leave (1 day)
- Private Medical Insurance (70% Company funded)
- Life Assurance (4x basic salary)
- Salary Sacrifice Pension (If Eligible): 5.5% Employer contribution (5% Employee contribution) with NIC sharing on offer
- Employee Assistance Programme
- Flu vaccinations allowance
- Home-based allowance
- Eye test allowance
- 2 volunteering days
- Elective work location change (work from anywhere)
- Holiday Buy-Back Scheme: Buy up-to 5 days additional holiday
- 1 Duvet day a year