Data Scientist

£33,000 - 73,000 per year

• Advanced Excel: Lookups, pivot tables, power queries, formulas, dashboards.
• Familiarity with Azure (preferably Azure SQL, pipelines, Data Factory, or storage services).
• Strong SQL: Ability to query, manipulate, join, cleanse, and analyse large tables.
• Understanding of Data Flows: Knowledge on how data moves through systems, APIs, tables, and reporting layers.
• Ability to build or update dashboards, measures, and visual reports in Power BI (bonus).
• Strong analytical skills with the ability to review large and complex data sets quickly and accurately.
• Strong problem solving and troubleshooting ability.
• Experience working with operational, financial, and commercial datasets.
• Highly organised, able to manage multiple tasks and deadlines.
• Strong attention to detail with a desire to improve processes.
• Good communication skills, able to translate data into simple business language.
• Proactive and curious mindset with a drive for continuous improvement.
• Experience in a finance, automotive, or insurance environment (desirable).
• Exposure to commercial performance reporting (e.g., funnels, conversion rates, revenue) (desirable).
• Experience with API driven platforms or lead generation data flows (desirable).
• Background in data science, mathematics, economics, or similar analytical field (desirable).

• 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.
• 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.
• 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.
• Build predictive insights and statistical models to support performance forecasting and optimisation (if applicable).
• Assist in experimentation, A/B testing and analysis of pricing, lender strategies or process improvements.
• Support the development of decisioning tools, such as credit and risk modelling frameworks.
• 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.
• Extract and clean data from internal tables and external systems.
• Update and automate daily/weekly lender and performance reports.
• Monitor lender acceptance and payout performance.
• Review data to maximise commission, revenue and lender success rates.
• Identify data issues, duplicates, mismatches or operational errors.
• Support system changes with testing and validation of new data flows.
• Work with the Data Manager on strategic analytics projects and automation.

• API
• Azure
• Excel
• Support
• Marketing
• Power BI
• SQL
• Cloud

This hybrid role is based in Motherwell (ML1 4UF). We offer competitive salary, internal development opportunities and generous benefits including 30 days holiday, pension, life assurance and regular colleague events.