Role Title: Data Analyst
Location: Manchester
Contract Type: Permanent
Hours: Full-time
Working Pattern: We observe Hybrid Working requirements including attendance of 40% (circa two days a week) at our hub
Salary Range: £48,987 - £54,430
Lloyds Living is an exciting venture for Lloyds Banking Group. Lloyds Living builds on the Group's existing support for the housing market as one of the biggest mortgage lenders to first-time buyers, home movers and private landlords. Since 2018, Lloyds Banking Group has provided almost £40bn of mortgages in the UK and helped one in four first time buyers to get onto the housing ladder. Also, to play to the Group's Strategy of 'helping Britain prosper' through the provisions of quality homes.
Join us at Lloyds Living as we redefine what it means to manage property in the UK. We're on an ambitious journey to become one of the country's largest and most trusted landlords, creating vibrant communities and delivering exceptional living experiences. As we scale at pace, you'll be part of a dynamic team shaping the future of PRS, Shared Ownership and property management – where innovation, customer focus, and growth go hand in hand.
About the team and growth agenda
You will be joining a nascent technology team being established to deliver a best in class technology capability to underpin the Lloyds Living ambitious growth strategy. You will be part of an exceptional technology team surrounded by peers who will inspire and motivate you to deliver your very best work.
Role Purpose
The Data Analyst role will play a key part in developing and supporting Lloyds Living's data and reporting capability, with a particular focus on information held within our core residential property management platforms.
The role is part of Lloyds Living's Data & Insights Team under our Enterprise Technology function. It requires working closely with property management, operational and finance teams, and will be responsible for extracting, transforming and presenting data primarily from MRI Qube PM and MRI Engage CRM (previously known as MRI Sales & Lettings) to provide reliable, timely and actionable reporting. The role will work alongside Data & Insight colleagues developing robust strategic data platforms, and be the interface to that function for operational property management colleagues.
The successful candidate will combine strong technical reporting and data skills with an understanding of residential property management. They will be comfortable working directly with business stakeholders to understand reporting requirements, investigate data issues and turn complex operational data into clear and useful information.
The role is based in Manchester to support a deep integration with the operational property management teams located in that office. The ideal candidate is expected to pro-actively suggest opportunities for data and reporting to add value and efficiency to the operational team and will be embedded in the management team of the Lloyds Living Property Management function.
Key Responsibilities
Data Analysis, Engineering & Reporting
•Design, develop and maintain tactical reporting solutions using data from MRI Qube PM and MRI Sales & Lettings (SLM).
•Proactively suggest data and reporting solutions to add value to operational business challenges.
•Extract, transform and combine data from multiple operational systems to create robust and reusable reporting datasets, utilising both ad hoc tactical approach where relevant and longer term strategic approach aligned to core Microsoft Fabric data platform.
•Develop automated and repeatable reporting processes, reducing reliance on manual data manipulation.
•Translate business reporting requirements into effective data models, reports and dashboards.
•Optimise existing reports and data processes for performance, reliability and maintainability.
•Support the integration of property management data into Lloyds Living's wider data and reporting environment.
MRI Property Systems
•Develop a strong understanding of the data structures, processes and reporting capabilities within MRI Qube PM and MRI Engage CRM (previously known as MRI Sales & Lettings).
•Work with operational and technology colleagues to understand how business processes are represented within the underlying data.
•Investigate reporting and data issues and support root-cause analysis.
•Identify opportunities to improve the availability, usability and consistency of data held within the MRI product estate.
•Work effectively with MRI and other third-party suppliers where specialist product knowledge or technical support is required.
Data Quality & Governance
•Monitor and improve the accuracy, completeness and consistency of reporting data.
•Develop appropriate validation and reconciliation controls for key datasets and reports.
•Maintain clear documentation covering data sources, transformations, definitions and reporting logic.
•Ensure reporting solutions operate in line with appropriate governance, security and control requirements.
Essential Experience & Skills
•Strong practical experience of reporting from MRI Qube PM.
•Strong practical experience of reporting from MRI Engage CRM (previously known as MRI Sales & Lettings).
•Experience developing dashboards and reports in Microsoft Power BI.
•Experience developing reporting and analytical solutions from complex operational datasets.
•Experience of working closely with leadership teams as a trusted partner, proactively proposing data and reporting solutions that address business challenges.
•Strong SQL skills and experience querying relational databases.
•Experience of data extraction, transformation, reconciliation and validation.
•Good understanding of data modelling and reporting principles.
•Experience gathering reporting requirements directly from business stakeholders.
•Strong analytical and problem-solving skills.
•Ability to communicate technical and data concepts clearly to non-technical stakeholders.
Property Sector Experience
The ideal candidate will have previous experience within residential property management, giving them an understanding of the business processes and data associated with managing residential portfolios.
Desirable Skills & Experience
•Experience reporting from FixFlo.
•Experience working with Microsoft Fabric.
•Experience integrating data from property management and other SaaS platforms.
•Familiarity with APIs and automated data extraction.
Benefits
•A generous pension contribution of up to 15%
•An annual performance-related bonus
•Share schemes including free shares
•Benefits you can adapt to your lifestyle, such as discounted shopping
•Up to 28 days' holiday, with bank holidays on top
•A range of wellbeing initiatives and generous parental leave policies
