Data Analyst

Student Castle

London

On-site

GBP 30,000 - 45,000

Full time

14 days+

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

33 days of annual leave

Life Insurance (4x salary)

Discretionary bonus scheme

Health and wellbeing initiatives

Virtual GP access

Job summary

A leading student accommodation provider in London is seeking a Data Analyst to support revenue management and marketing initiatives. The ideal candidate will have strong analytical skills, proficiency in Excel and SQL, and experience with data visualization tools. This role involves collecting market intelligence, supporting pricing strategies, and developing insightful reports. A comprehensive benefits package is offered, including 33 days of annual leave and health support initiatives.

Qualifications

1-2 years of experience in data analysis or relevant field.
Experience using data visualization tools and techniques.
Familiarity with revenue management principles.

Responsibilities

Collect and analyze market intelligence data.
Support pricing strategies with demand modeling.
Develop reports and dashboards for various stakeholders.

Skills

Strong proficiency in Excel

Proficiency in SQL

Solid analytical skills

Strong communication skills

Proficiency in Python or R

Education

Degree in a quantitative field (e.g. Mathematics, Data Science)

Tools

Power BI

Tableau

CRM systems (e.g., Entrata, Salesforce)

Job description

Overview

Join the dynamic team at Student Castle Property Management Services Ltd (SCPMS), a leader in purpose-built student accommodation. We operate under two flagship brands – Student Castle and Capitol Students – with a focus on creating a warm and welcoming home away from home experience for student residents.

We are seeking a dynamic and motivated Data Analyst to join our growing team, supporting functions across revenue management, marketing, sales, and commercial strategy. The Data Analyst will collaborate closely with multiple departments, delivering data-driven insights to inform strategic decisions and drive business performance. The ideal candidate will thrive in a fast-paced environment, bring a strong analytical mindset, and demonstrate a solid understanding of the PBSA market.

Key Responsibilities

Collect marketing intelligence on rental levels, occupancy rates, and market trends across PBSA sector and other relevant sectors such as BTR and HMO.
Conduct marketing and competitor analyses to shape pricing decisions and revenue plans.

Analysis

Support pricing strategies by modelling demand scenarios, competitor benchmarks and seasonal trends.
Analyse and forecast rental revenue streams, identify opportunities for growth, and inform leasing strategies.
Collaborate with the sales team to refine rental proposals and optimize market rent strategies.
Monitor KPIs, identify anomalies, and suggest corrective actions based on data findings.
Analyse data for migration between legacy and new property management systems.

Reporting

Develop accommodation schedules using floor plans, operational data, and client specifications.
Support budgeting, forecasting, and scenario modelling activities using Excel and financial models.
Develop and maintain reports, dashboards and data visualizations using Power BI, Tableau, or equivalent tools.
Monitor and analyse system performance post-system migration to ensure ongoing data quality.

Data Management

Manage internal and external data sources, ensuring integrity and accessibility for business users.
Partner with other departments to ensure alignment between data insights and business goals.
Utilise SQL, Python, or R to extract, manipulate, and analyse data from various databases and systems.
Assist in data mapping, cleansing, validation, and migration between legacy systems and new platforms.
Develop and execute test plans to ensure data accuracy, system functionality, and reporting capabilities.
Work closely with IT, project managers, finance, operations, and other business units to resolve data issues and improve processes.
Document data flows, transformation rules, and implementation outcomes.

Other Responsibilities

Conduct ad-hoc analyses to support business expansion initiatives and strategic planning.
Undertake additional tasks and ad hoc projects as required to support the overall business objectives and sales strategy.
Be flexible and responsive to evolving business needs and priorities.

What We're Looking For

Experience & Skills

Degree in a quantitative field (e.g., Mathematics, Economics, Data Science, Statistics, or related).
Strong proficiency in Excel and SQL.
Experience using data visualisation tools such as Power BI or Tableau.
Solid analytical and problem-solving skills, with a keen attention to detail.
Strong communication skills to convey insights clearly to non-technical stakeholders.
Ability to manage multiple priorities and work to tight deadlines.
Experience in the property, hospitality, or student accommodation sectors.
Familiarity with revenue management or dynamic pricing principles.
Proficiency in Python or R for advanced analysis or automation.
Experience with CRM or property management systems (e.g., Entrata, StarRez, Salesforce, Hubspot).

Personal Qualities

A self-starter who thrives in a fast-paced environment and can hit the ground running.
Reliable, trustworthy, and able to manage multiple priorities.
A keen eye for detail, with a passion for sophisticated and professional branding.

Why Join Our Team

At SCPMS, we believe in fostering a work environment where our team not only excels professionally but also thrives personally. When you join our dynamic team, you'll enjoy a comprehensive benefits package designed to support your wellbeing and celebrate milestones.

Benefits