Data Analyst
Location: Remote role but travel across national sites
Salary up to £45,000 per annum plus £4,000 company car allowance
Contract: Full time – 2-year fixed term contracts, Monday to Friday
About the Role:
Mears Housing Management is looking for a Data Analyst to help deliver the Property Management Platform (PMP), a transformation programme for the Asylum Accommodation & Support Services Contract (AASC). The Data Analyst will help turn PMP data into clear insight, support better data quality, stronger reporting, benefits tracking and more confident operational decision-making.
PMP is being introduced to provide a single, more reliable way to manage property, occupancy and operational information across AASC. It will improve data quality, strengthen reporting and support more consistent ways of working across teams.
Key Responsibilities
- Collect, organise, analyse and interpret programme data.
- Identify issues, trends, risks and insights to support decision-making.
- Develop reports, dashboards and KPI information.
- Support data validation, reconciliation and quality assurance.
- Recommend improvements to data, processes, controls and reporting.
Role Criteria:
- Experience analysing, validating and reporting on complex, multi-layered operational or project data.
- Strong SQL skills are essential, with practical experience writing queries and working across multiple SQL views to: Extract and filter data, Join data from multiple tables, Summarise data, Investigate discrepancies and validate data quality
- Advanced Excel and data analysis skills; including: XLOOKUP / VLOOKUP, PivotTables, Complex formulas and conditional logic, Data cleansing, validation and reconciliation, Manipulating and analysing large datasets
- Skilled in the use of VBA & PowerBI and experience working with programme, project or operational performance data.
- Ability to identify trends, data quality issues and root causes, and translate into concise, meaningful insight and recommendations.
- Experience developing management information, KPI reporting or dashboards that clearly communicate performance and areas requiring attention.
- Clear communication skills, and confidence presenting insight.
- High attention to detail and commitment to accuracy.
- Existing Security Clearance is a preference.
- Central government or repairs and maintenance experience.
- Operational exposure and understanding.
Benefits we can offer you
- 25 days annual leave plus bank holidays
- Annual Mears Fun Day - Our annual Fun Day is organised as a massive thank you from the Executive team for all the hard work!
- Volunteering Leave - Mears supports employees to undertake paid volunteering in the community, in support of our social value commitment.
- Staff perks with Mears Rewards - discounts of up to 10% weekly groceries, holidays, eye test vouchers, Share save scheme, plus much more
- Family friendly policies
- Company Vehicle and Fuel Card
- Access to EAP Counselling sessions
To drive a Mears vehicle, you must be aged over 21 have held your licence over 3 months and have less than 9 points.
All our roles require candidates to have the entitlement to work within the UK, Mears does not currently offer visa sponsorship.
As part of the recruitment process for this role, we will carry out a Background, Identity, Security clearance & BPSS check. For these checks to be completed, we will require from you the relevant identification, including Proof of Address, References, a valid passport and proof that you have lived in the UK for the last 5 years.
Apply below or to discuss your application further; contact:
Beth Dunford ([email protected])If you need any help with your application process, we are here to support you. We will be accessible every step of the way.
At Mears Group, we are committed to fostering a diverse and inclusive environment where everyone can thrive, we are a Disability Confident employer, valuing individuality and ensuring equal opportunities for all.
We proudly support the Armed Forces Covenant and are honoured to have achieved the Gold Award in the Defence Employer Recognition Scheme (ERS) to coincide with this, we hold an Endorser Award for the Career Transition Partnership, recognising our commitment to veterans transitioning into civilian careers.
In our continued effort to promote social mobility, we invite applicants to voluntarily share their background information during the application stages to help us better understand the diverse experiences of our candidates. This is to ensure we are committed to improving social mobility. We use the Social Mobility Index to assess and enhance opportunities for individuals from diverse backgrounds. These questions are optional and will not impact your ability to apply.
Skills Required
- Experience analyzing, validating, and reporting on complex, multi-layered operational or project data
- Strong SQL skills, including querying multiple views, joining tables, summarizing data, investigating discrepancies, and validating data quality
- Advanced Microsoft Excel skills, including XLOOKUP or VLOOKUP, PivotTables, complex formulas, conditional logic, data cleansing, validation, reconciliation, and large dataset analysis
- Proficiency in VBA and Power BI
- Experience working with program, project, or operational performance data
- Ability to identify trends, data quality issues, and root causes and translate them into meaningful insights and recommendations
- Experience developing management information, KPI reporting, or dashboards
- Clear communication skills and confidence presenting insights
- High attention to detail and commitment to accuracy
- Existing security clearance
- Central government or repairs and maintenance experience
- Operational exposure and understanding
- Entitlement to work in the UK
- Ability to pass background, identity, security clearance, and BPSS checks
- For driving a Mears vehicle: aged over 21, held a driving licence for more than three months, and fewer than nine penalty points
Mears Group Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Mears Group and has not been reviewed or approved by Mears Group.
-
Leave & Time Off Breadth — 25 days’ holiday with the option to buy additional days, plus paid volunteering time, signal a comparatively generous time-off offering. Flexible working available in many roles further supports practical time-off and balance.
-
Wellbeing & Lifestyle Benefits — Retail discounts, Cycle to Work, an employee assistance line, volunteering days, and company family events add tangible non-cash value. Access to training and UK‑recognised qualifications reinforces the broader wellbeing and development offering.
-
Fair & Transparent Compensation — A stated commitment to pay at or above the Real Living Wage and the publication of pay-related reports indicate governance and baseline fairness focus. Independent snapshots also suggest many roles meet living‑wage thresholds.
Mears Group Insights
What We Do
Mears Group is a market-leading housing and care company that provides bespoke services to our clients. We provide and manage 11,000 homes for local and central Government and are also responsible for keeping 750,000 of all social housing in the UK in good repair. Mears has 6,500 employees and a footprint across the country
