[Hiring] Data Analyst @Mears Group

Role Description

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.

Qualifications

• 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

• 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