Data Analyst

This is a fully remote position, open to applicants in United Kingdom.

📋 Description

• Gather, structure, analyze, and interpret program data.

• Recognize issues, trends, risks, and insights to aid in decision-making.

• Create reports, dashboards, and Key Performance Indicator (KPI) information.

• Assist with data validation, reconciliation, and quality assurance.

• Suggest enhancements to data, processes, controls, and reporting.

• Contribute to the transformation program of the Property Management Platform for the Asylum Accommodation & Support Services Contract.

• Convert PMP data into actionable insights, enhance data quality, improve reporting, track benefits, and support operational decision-making.

⛳️ Requirements

• Proven experience in analyzing, validating, and reporting on complex, multi-layered operational or project data.

• Exceptional SQL skills, with the ability to write queries across multiple SQL views.

• Proficient in extracting and filtering data, merging multiple tables, summarizing information, investigating discrepancies, and validating data quality.

• Advanced skills in Excel and data analysis, including XLOOKUP/VLOOKUP, PivotTables, complex formulas, conditional logic, data cleansing, validation, reconciliation, and analysis of large datasets.

• Proficient in VBA and Power BI.

• Experience with program, project, or operational performance data.

• Ability to identify trends, data quality issues, and root causes, and translate them into clear insights and recommendations.

• Background in developing management information, KPI reporting, or dashboards.

• Strong communication skills and confidence in presenting insights.

• High attention to detail and a commitment to accuracy.

• Experience in central government or repairs and maintenance.

• Operational exposure and understanding are advantageous.

• Existing Security Clearance is preferred.

• Must have the right to work in the UK; Mears does not currently provide visa sponsorship.

• Completion of background, identity, security clearance, and BPSS checks is required.

• Required identification includes proof of address, references, a valid passport, and evidence of residence in the UK for the past 5 years.

• To operate a Mears vehicle, candidates must be over 21 years old, have held a driving license for over 3 months, and have fewer than 9 penalty points.

🏝️ Benefits

• 25 days of annual leave plus bank holidays.

• Annual Mears Fun Day.

• Paid volunteering leave.

• Mears Rewards staff discounts, including up to 10% off weekly groceries and holidays.

• Eye test vouchers.

• Share save scheme.

• Family-friendly policies.

• Company vehicle and fuel card.

• EAP counselling sessions.