Data Analyst

Ridge & Partners LLP; Winchester; On-site; GBP 28,000 - 38,000; Full time

Job summary

A leading property consultancy is seeking a Data Analyst to join their team in Winchester. The role involves managing data collection, analysis, and producing reports with a focus on asset management strategies. Candidates should possess strong analytical skills, proficiency in MS Excel, and experience with relevant data management tools. This is an opportunity to contribute significantly within the affordable housing sector.

Qualifications

• Demonstrated experience with data analysis and reporting.
• Strong written communication skills for clarity in documentation.
• Knowledge of systems used in housing management is advantageous.

Responsibilities

• Assist with management of surveys and coordinate with fieldwork managers.
• Setup new surveys, including data configuration.
• Perform data QA checks and generate monthly reports.

Skills

Analytical skills

Communication skills

Data management

Excel proficiency

PowerBi

Tools

MS Excel

PowerBi

Python

Civica

Keystone

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

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 co-ordination 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 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.