MI Analyst

LendInvest; Glasgow; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Hybrid working

Company bonus

Private healthcare

25 days holiday

Matched pension 4%

Life assurance

Mental health support

Conferences & development

Discounts via Perkbox

Cycle to work

Job summary

LendInvest is seeking a data-driven Finance Analyst to join our hybrid team in the UK. You will combine finance, data, and technology to deliver insights, automate processes, and stress-test financial models.

You'll own inputs for models, produce reliable MI, and present findings to senior stakeholders. Advanced Excel, VBA/macros, SQL, and Python skills are highly valued in a fast-paced FinTech environment.

Qualifications

• Numerate with strong analytical reasoning and a finance/treasury background.
• Experience in financial services, banking or property lending.
• Hands-on with large, complex datasets.
• Proficient in Excel, VBA/macros, and automation.

Responsibilities

• Clean and prepare large datasets to produce reliable MI.
• Provide actionable insights and finance reporting.
• Own inputs and assumptions for rolling financial models.
• Test outputs, identify trends, and implement improvements.
• Run stress scenarios and assess financial impacts.
• Automate finance processes to improve reliability.
• Research and apply new modelling techniques and AI tools.

Skills

Advanced Excel

Data manipulation

VBA/macros

Process automation

SQL

Python

Analytical skills

Communication

Time management

Collaboration

Tools

Power Query

SQL

Python

Job description

LendInvest is the UK's leading FinTech platform for property finance. Over the past 18 years, we have grown from just our two founders to a team of over 200 working to make property finance simple for everyone.

A workplace culture built around trying new things, getting things done, and having fun while we do it has helped us lend more than £9 billion of mortgages, put thousands of new or improved homes into the UK housing market, and successfully launch on the London Stock Exchange. We have big plans to continue growing the business, our products, our technology, and our people.

We operate a hybrid working policy across our business to ensure we offer flexibility that is balanced with in-person collaboration. Our teams spend three days per week in the office and two days working remotely.

About your work

You are a data-driven problem solver who thrives at the intersection of finance, data, and technology. You don’t just process numbers; you look beyond the spreadsheet to find the commercial story hiding within complex datasets. Whether you are automating a legacy process, stress-testing a financial model, or presenting insights to senior stakeholders, you bring logical rigour and an agile mindset.

If you are passionate about leveraging advanced Excel, coding, and emerging AI tools to drive smarter business decisions in a fast-paced environment, we want you on our team.

Key Responsibilities:

• Clean, collate, and manipulate large, non-conventional datasets from multiple sources to produce reliable MI.

• Provide actionable insights and reporting for the Finance team and the wider business.

• Take ownership of the inputs and assumptions required to roll financial models forward.

• Test model outputs, analyse trends to identify areas for improvement, and implement proposed changes.

• Run stress scenarios and analyse the commercial and financial impacts of various outcomes.

• Champion a culture of improving existing finance processes through automation and enhanced reliability.

• Actively research and stay up-to-date with the latest financial modelling techniques, advanced Excel features, and practical AI implementations.

About you

• Previous experience within Financial Services (ideally gained in banking, property lending, or similar environments).

• Previous analytical experience within treasury / finance operations.

• A highly numerate background with a natural aptitude for logical problem-solving.

• Hands-on experience working with large, complex, and non-conventional datasets.

• Advanced MS Excel: Exceptional skills including the use of VBA, macros, and process automation.

• Data Manipulation: Highly competent and efficient at extracting, transforming, and loading data from varied sources.

• Experience using SQL, Python or Power Query would be beneficial.

• Commercial Acumen: A clear and logical approach to problem-solving, with the ability to interpret both the financial and non-financial impacts of commercial decisions.

• Communication: Outstanding influencing, verbal, and written communication skills. You must be confident presenting to and conversing with all levels of seniority, as well as external stakeholders.

• Adaptability: An agile working style, comfortable navigating a dynamic business environment while maintaining solid attention to detail.

• Time Management: The ability to independently manage a variety of responsibilities, prioritise effectively, and meet strict deadlines.

• Collaboration: Working closely and developing strong relationships with the business (Finance, Treasury, IT and Capital Markets).

Benefits & perks

• Competitive salary + company bonus scheme

• Hybrid working policy

• 25 days holiday (increasing with the length of service)

• Private healthcare

• Enhanced parental leave

• Matched pension contributions up to 4%

• Critical illness cover

• Employee Assistance Programme & Mental Health support

• Life assurance

• Regular performance reviews to promote a culture of growth and development

• Leadership training for managers

• Give as you earn scheme for charitable donations

• Support for attending conferences and professional learning & development

• Discounts via Perkbox

• Cycle to work scheme

• YellowNest Childcare

• Electric car loan scheme

• Monthly socials & annual offsite

Diversity, Inclusion & Belonging at LendInvest

At LI we believe in bringing your whole selves to work, we are committed to a culture of belonging where individuals can form a genuine community. We are proud to be an equal opportunities employer and are committed to building a team that represents a variety of backgrounds, perspectives and skills.

We are happy to discuss and implement reasonable adjustments to support candidates throughout the recruitment process.