Data Analyst - Lloyds Living

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.

About working for us

Our ambition is to be the leading UK business for diversity, equity and inclusion supporting our customers, colleagues and communities, and we're committed to creating an environment in which everyone can thrive, learn and develop.

We were one of the first major organisations to set goals on diversity in senior roles, create a menopause health package, and a dedicated Working with Cancer Initiative.

We offer reasonable workplace adjustments for colleagues with disabilities, including flexibility in office attendance, location and working patterns. We provide reasonable adjustments throughout the recruitment process to reduce or remove barriers. Just let us know what you need.

We offer a wide-ranging benefits package, which includes:

·       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

If you're excited by the thought of becoming part of our team, get in touch. We'd love to hear from you!