Data Analyst

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

Overview

We need a skilled data analyst to join our specialist data team within JLL's UK residential valuation business, based at 30 Warwick Street, London W1B 5NH. You will contribute to a diverse range of complex, engaging projects across the UK.

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 at scale, 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 and deliver tailored solutions.
• Support business development activities through data‑driven insights and market analysis.

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.

Technical Skills

• SQL: Advanced querying, complex joins, stored procedures, performance optimisation.
• Python: Strong programming skills including 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, Power Query, calculated columns and performance tuning.

Database & Development

• Experience designing and implementing relational data models.
• API development and integration experience.
• Understanding of data governance principles.

Analytical & Communication

• Strong analytical thinking and problem‑solving abilities.
• Excellent presentation and communication skills.
• Ability to translate technical concepts for non‑technical stakeholders.
• Detail‑oriented with strong quality assurance practices.

Location

30 Warwick Street, London W1B 5NH.