Asset Information Analyst

CPR; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A London Local Authority is looking for an Asset Information Analyst to validate property data and produce asset intelligence. The role involves using advanced IT tools such as Power Query and SQL to support decision-making and ensure data quality. Candidates should have a higher education qualification in IT/Computer Science and experience in data manipulation and reporting.

Qualifications

• Higher Education qualification in IT/Computer Science or equivalent experience.
• Experience in data retrieval, manipulation, and reporting.
• Advanced knowledge of Power Query, SQL, Excel, Access, and VBA.

Responsibilities

• Maintain, analyse, and validate property and asset data to support decision-making.
• Use advanced IT tools for reporting and analysis.
• Ensure accuracy and quality assurance across multiple systems.

Skills

Analytical skills

Problem-solving skills

Attention to detail

Communication skills

Education

Higher Education qualification in IT/Computer Science

Tools

Power Query

SQL

Excel

MS Access

VBA

Job description

Overview

Asset Information Analyst (Property Data Validation Officer)
London 29.07 per hour (umbrella) Interim Contract

A London Local Authority is seeking an Asset Information Analyst to support its Asset Management Team. This role will focus on validating property data and producing high-quality asset intelligence to inform key decisions affecting council officers, service providers, central government, and residents.

Responsibilities

• Maintain, analyse, and validate property and asset data to support decision-making.
• Use advanced IT tools (Power Query, SQL, MS Access, Excel, VBA) for reporting and analysis.
• Assist the Asset Information Manager with technical and administrative solutions for database and records management.
• Ensure accuracy, consistency, and quality assurance across multiple systems.
• Work with internal and external stakeholders to deliver timely, reliable asset information.

Requirements

• Higher Education qualification in IT/Computer Science (or equivalent experience).
• Strong analytical and problem-solving skills with excellent attention to detail.
• Advanced knowledge of Power Query, SQL, Excel, Access, and VBA.
• Experience in data retrieval, manipulation, and reporting.
• Flexible, proactive, and able to meet tight deadlines.
• Strong communication skills and commitment to providing a professional service.