Data Analyst

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

• 33 days of annual leave
• Life Insurance (4x salary)
• Discretionary bonus scheme
• Health and wellbeing initiatives
• Virtual GP access
• Health cash plan
• Company-paid sick leave
• Enhanced maternity/paternity pay
• Maternity wardrobe support
• A gift at the birth of your baby
• Entire day off for your child's first day at school
• Me Day
• Access to deals and discounts
• Career celebration awards
• And more

More details and eligibility criteria will be shared with the successful candidate!