Data Analyst

Data Analysis & Modelling

• Maintain and query large residential property datasets using advanced SQL techniques.
• Design and develop complex relational SQL data models to support valuation processes.
• Perform comprehensive data analysis to identify trends and insights in residential markets.

Data visualisation & Reporting

• Build and deploy interactive Power BI dashboards providing real-time insights to stakeholders.
• Design compelling data visualisations that translate complex datasets into actionable intelligence
• Develop executive-level reporting solutions for internal teams and client presentations.

Development & Automation

• Develop sophisticated automation scripts using Python and VBA to streamline valuation workflows.
• Write API code to query AI systems at scale, enhancing our analytical capabilities.
• Create and maintain robust data pipelines for continuous data processing.

Client & Stakeholder Engagement

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

We need a skilled data analyst to join our specialist data team that sits within JLL's UK residential valuation business, and is based in our head office at 30 Warwick Street, London W1B 5NH.

You will become part of a dynamic team of data analysts supporting a large group of residential and affordable housing experts, while contributing to a diverse range of complex and engaging instructions across the UK.

This role is ideal for an individual with 2-3 years' experience as a Data Analyst in a corporate environment, possessing strong technical, analytical and communication skills, paired with an interest in the residential sector. Adaptability and enthusiasm for achieving optimal client outcomes are essential., * 2-3 years of experience as a Data Analyst in a corporate environment

• Property industry experience highly preferred
• Proven track record of working with large, complex datasets.

Technical Skills

• SQL: Advanced querying capabilities, complex joins, stored procedures, performance optimisation
• Python: Strong programming skills including pandas, data manipulation libraries
• VBA: Proficient in Excel automation and macro development
• Power BI: Expert-level skills including:

• Advanced DAX formula writing and optimisation.
• Complex data modelling and relationships
• Custom visualisations and dashboard design
• Row-level security implementation.
• Power Query for data transformation
• Calculated columns and measures
• Performance tuning and optimisation

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.

Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you've got deep experience in commercial real estate, skilled trades or technology, or you're looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward., Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL's recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely.