Data Analyst, Built Environment

Ridge & Partners LLP; Winchester; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading property consultancy is seeking a Data Analyst to join their team in Winchester. This role involves assisting with surveys, data validation, and asset performance modeling, focusing on the affordable housing sector. Candidates should have strong analytical skills and a good command of MS Excel and PowerBi. Experience with housing-related systems is preferred. This position provides an excellent opportunity to support the development of asset management strategies and contribute to sustainability efforts.

Qualifications

• Strong analytical skills to create robust outputs.
• Experience with databases related to housing preferred.
• Proficient in using MS Excel and PowerBi.

Responsibilities

• Assist with management of surveys and coordination.
• Setup new surveys and configure data.
• Perform data QA checks and validation.
• Prepare monthly progress reports and updates.
• Manage energy data for net zero carbon strategies.

Skills

Analytical skills

Excellent written and communication skills

Experience with housing related systems

Good working knowledge of MS Excel

Familiarity with PowerBi

Knowledge of data analytical tools

Tools

PowerBi

MS Excel

Python

Civica

Keystone

ActiveH

Job description

What’s the Opportunity

Our Property Consultancy team provide strategic advice and guide clients through a full spectrum of property consultancy, housing asset management and compliance related activities within the affordable housing sector.

We are recruiting a Data Analyst to join our team. This role will particularly suit an individual with an interest in data collection, analysis and formation of related asset management strategies ideally with experience in related databases (not necessarily within the housing sector). Please note that due to the nature of this role, the requirement is for the successful applicant to be based in the Winchester office.

What you need to do to be effective in this role

The role will be varied and include the following :

• Assisting with the management of surveys and coordination with Fieldwork Managers
• Setting up of new surveys including data configuration
• Setting up of mobile devices for surveyors to collect data
• Data QA checks and validation (PowerBi and MS Excel)
• Providing monthly progress reports and updates (PowerBi and MS Excel)
• Dealing with confidential data
• Assisting with the preparation of monthly fee accounts
• Preparation of survey outputs including cost tables for reporting
• Providing input into asset management advice and support
• Undertaking asset performance modelling
• Decent Homes and HHSRS assessments and validations
• Managing energy data to inform net zero carbon and sustainability strategies
• Developing inhouse best practice data management
• Supporting and reporting to the Team Leader

The skills and experience you need to have for this role

• You will have an analytical mind combining excellent written and communication skills to produce considered and robust outputs for the team and clients.
• Experience of working with housing related systems such as Civica / Keystone, NEC, PIMSS, ActiveH, Open Housing, ProMaster, TechForge etc. would be advantageous.
• A good working knowledge of MS Excel is required.
• Any related data analytical tools and reporting such as PowerBi, AirTable, Python etc would be beneficial.
• Any knowledge of construction technology relating to residential accommodation would be beneficial.