Data Analyst

CarMoney
Motherwell, United Kingdom
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
£ 40K

Job location

Remote
Motherwell, United Kingdom

Tech stack

Microsoft Excel
A/B testing
API
Azure
Big Data
Databases
Microsoft SQL Server
SQL Azure
Pivot Tables
Power BI
SQL Databases
Data Streaming
Performance Monitor
Data Management
Tools for Reporting
Data Pipelines

Job description

We are currently looking for a highly motivated Data Analyst to join the Systems & Data team. This role is critical to supporting our operational performance, lender relationships, and commercial reporting. You will work with large volumes of automotive finance data coming from multiple online platforms and internal systems such as AutoConvert and our in-house databases. You will help the business understand performance, maximise lender targets and commission outcomes, automate reporting, and solve data-driven problems across the organisation., 1. Reporting & Insights

  • Build, maintain, and automate daily, weekly, and monthly performance reports for Directors and senior stakeholders.
  • Produce insights on lender performance, conversion funnels, commissions, and commercial targets.
  • Carry out monthly profitability reviews and highlight actions to maximise revenue.
  • Provide clear summaries of trends, issues, and opportunities based on multi-source data sets.
  1. Data Management & Data Flows
  • Manage and quality-check large datasets from internal systems and external platforms.
  • Understand end-to-end data flows across systems (AutoConvert, SQL Server, Power BI, Excel, Azure).
  • Ensure data accuracy, completeness, and consistency across reporting tools.
  • Support the automation of manual processes by creating more efficient, scalable data pipelines.
  1. Problem Solving & Investigation
  • Investigate data anomalies, broken processes, unexpected performance changes, or lender issues.
  • Work with Analysts, Lender Managers, Sales, and external vendors to identify root causes.
  • Review lender filters, target changes, and decisioning rules to ensure alignment with business strategies.
  • Analyse operational bottlenecks and provide actionable solutions.
  1. Data Science & Advanced Analytics (If applicable to candidate)
  • Build predictive insights and statistical models to support performance forecasting and optimisation.
  • Assist in experimentation, A/B testing and analysis of pricing, lender strategies, or process improvements.
  • Support development of decisioning tools, such as credit and risk modelling frameworks.
  1. Cross-Department Collaboration
  • Work closely with Sales, Lender Management, Marketing, Operations, and Leadership teams.
  • Provide analytical support for new integrations, lender changes, or commercial initiatives.
  • Communicate findings in a clear, structured manner-verbal and written.

Daily Tasks

  • Extracting and cleaning data from internal tables and external systems.
  • Updating and automating daily/weekly lender and performance reports.
  • Monitoring lender acceptance and payout performance.
  • Reviewing data to maximise commission, revenue, and lender success rates.
  • Identifying data issues, duplicates, mismatches, or operational errors.
  • Supporting system changes with testing and validation of new data flows.
  • Working with the Data Manager on strategic analytics projects and automation.

Requirements

Do you have experience in SQL?, * Advanced Excel: Lookups, pivot tables, power queries, formulas, dashboards.

  • Azure (preferably): Familiarity with Azure SQL, pipelines, Data Factory, or storage services.
  • Strong SQL: Ability to query, manipulate, join, cleanse, and analyse large tables.
  • Understanding of Data Flows: How data moves through systems, APIs, tables, and reporting layers.
  • Power BI (bonus): Ability to build or update dashboards, measures, and visual reports.

Analytical Skills

  • Ability to review large and complex data sets quickly and accurately.
  • Strong problem-solving and troubleshooting ability.
  • Comfort working with operational, financial, and commercial datasets.

Behavioural Skills

  • Highly organised, with the ability to manage multiple tasks and deadlines.
  • Strong attention to detail and a desire to improve processes.
  • Good communication skills, able to translate data into simple business language.
  • Proactive, curious mindset with a drive for continuous improvement.

Desirable Experience

  • Experience in a finance, automotive, or insurance environment.
  • Exposure to commercial performance reporting (e.g., funnels, conversion rates, revenue).
  • Experience with API-driven platforms or lead-generation data flows.
  • A background in data science, mathematics, economics, or similar analytical field.

Benefits & conditions

  • 30 days holiday rising with length of service
  • World class training delivered by the Ninja Academy
  • Internal development opportunities - climb the Ninja ladder!
  • Onsite parking
  • Free tea & coffee and breakfast on a weekend is on us!
  • Daily, weekly, and monthly incentives and the big one…. Win a trip abroad!
  • Employee discounts
  • Generous Ninja Referral Scheme
  • Pension & Life Assurance
  • Enhanced maternity & paternity leave
  • Regular giving back days and charity events
  • Access to the Wellbeing Centre - MOT & In house counselling services
  • Colleague events - Family Fun Day, Annual ball, Christmas party - yes we like to have fun!

If you would love to be part of our CarMoney family, please APPLY now with an up to date copy of your CV. We look forward to hearing from you soon.

CarMoney is an equal opportunities employer. Everyone is welcome here, as long as you have the drive and passion to succeed, then we would love to hear from you

Job Types: Full-time, Permanent

Pay: £30,000.00-£40,000.00 per year

About the company

CarMoney has become one of the UKs fastest growing finance brokers - and we're still growing. Over the years we've come to work with a large panel of lenders and partners, with some big names like Gumtree, Compare the Market, and Motors joining us for the journey. But we're not done growing yet, we're constantly evolving and looking for new people to join our team.

Apply for this position