Data Analyst

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., 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), * The role will require hybrid attendance at our Reading office in Green Park. Are you comfortable with this arrangement?
• Have you been employed in a similar position?
• What is your notice period?
• What is your salary expectation for this role?
• We are commited to ensuring an inclusive recruitment process for all applicants. If you require any reasonable adjustments to support your application or participation in the recruitment process, please let us know.

Do you have experience in SQL?, * 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)
• Exposure to AWS data ecosystem (e.g. S3, Redshift, Athena)
• Familiarity with analytics engineering patterns (e.g. modular SQL, layered models)
• Experience with marketplace or two-sided platform data
• Exposure to finance or revenue reporting

Pulled from the full job description

• Employee assistance programme
• Company pension
• Private medical insurance
• Free flu jabs, * 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

Pay: From £50,000.00 per year

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.