Remote Data Analyst - KPI Dashboards & SQL

Mears Group PLC; Gloucester; Ibrido; GBP 41.000 - 50.000; Tempo pieno

Vantaggi offerti da questo lavoro

25 days annual leave plus bank holiday

Annual Mears Fun Day

Volunteering Leave

Staff perks with Mears Rewards

Family friendly policies

Company Vehicle and Fuel Card

Access to EAP Counselling sessions

Descrizione del lavoro

Mears Group PLC is seeking a Data Analyst to support the PMP transformation for the AASC contract. You will turn PMP data into clear insights, enhance data quality, and improve reporting to enable confident operational decisions.

The role involves analysing complex data, building dashboards, and delivering KPI information across national sites with remote work options. Strong SQL, Excel, and PowerBI skills are essential.

Competenze

• Experience analysing, validating and reporting on complex, multi-layered operational or project data.
• Strong SQL skills 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.
• 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.

Mansioni

• 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.

Conoscenze

SQL

Advanced Excel

PowerBI

VBA

Data analysis

Communication

Attention to detail

Security clearance

Strumenti

SQL

PowerBI

Excel

VBA

Descrizione del lavoro

Mears Group PLC is seeking a Data Analyst to support the PMP transformation for the AASC contract. You will turn PMP data into clear insights, enhance data quality, and improve reporting to enable confident operational decisions.

The role involves analysing complex data, building dashboards, and delivering KPI information across national sites with remote work options. Strong SQL, Excel, and PowerBI skills are essential.