Data Analyst: Real Estate Analytics & Dashboards

Jll; City of Westminster; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading real estate firm in the UK is seeking a skilled data analyst to join their residential valuation team. The role involves maintaining and analyzing large datasets, developing SQL data models, and creating Power BI dashboards for stakeholders. Candidates should have 2-3 years of data analyst experience, strong analytical skills, and a preference for property industry expertise. This position offers a dynamic work environment focused on complex projects across the UK.

Qualifications

• 2-3 years of experience as a Data Analyst in a corporate environment.
• Strong technical, analytical and communication skills.
• Proven track record of working with large, complex datasets.
• Property industry experience highly preferred.

Responsibilities

• Maintain and query large residential property datasets using advanced SQL.
• Design and develop complex relational SQL data models to support valuation processes.
• Perform data analysis to identify trends and insights in residential markets.
• Build and deploy interactive Power BI dashboards providing real‑time insights to stakeholders.
• Develop executive‑level reporting solutions for internal teams and client presentations.
• Develop sophisticated automation scripts using Python and VBA to streamline valuation workflows.
• Write API code to query AI systems, enhancing analytical capabilities.
• Create and maintain robust data pipelines for continuous data processing.
• Present analytical findings and recommendations to clients and senior leadership.
• Collaborate with cross‑functional teams to understand business requirements.
• Support business development activities through data‑driven insights.

Skills

SQL: Advanced querying, complex joins, stored procedures, performance optimisation

Python: Strong programming skills (pandas and manipulation libraries)

VBA: Proficient in Excel automation and macro development

Power BI: Expert-level skills in DAX, data modelling, custom visualisations, Row-level security

Analytical thinking and problem‑solving abilities

Excellent presentation and communication skills

Job description

A leading real estate firm in the UK is seeking a skilled data analyst to join their residential valuation team. The role involves maintaining and analyzing large datasets, developing SQL data models, and creating Power BI dashboards for stakeholders. Candidates should have 2-3 years of data analyst experience, strong analytical skills, and a preference for property industry expertise. This position offers a dynamic work environment focused on complex projects across the UK.