Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse data and create insights to support residential valuations.
- Company: Join JLL, a leading global real estate firm shaping the future.
- Benefits: Competitive salary, career growth, and a supportive work environment.
- Why this job: Make an impact in the residential sector with your analytical skills.
- Qualifications: 2-3 years as a Data Analyst with strong SQL and Python skills.
- Other info: Dynamic team atmosphere with opportunities for professional development.
The predicted salary is between 30000 - 42000 £ per year.
JLL empowers you to shape a brighter way. 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.
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.
Key Responsibilities- 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.
- Experience
- 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.
If this job description resonates with you, we encourage you to apply even if you don't meet all of the requirements. We're interested in getting to know you and what you bring to the table!
Data Analyst in London employer: Jones Lang LaSalle Incorporated
Contact Detail:
Jones Lang LaSalle Incorporated Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with current employees at JLL. A friendly chat can sometimes lead to opportunities that aren’t even advertised!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those using SQL, Python, and Power BI. This gives you a chance to demonstrate your expertise beyond just a CV.
✨Tip Number 3
Prepare for interviews by practising common data analyst questions and scenarios. Think about how you can explain complex concepts in simple terms, as communication is key in this role.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Data Analyst in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Analyst role. Highlight your experience with SQL, Python, and Power BI, and don’t forget to mention any relevant projects or achievements that showcase your skills.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about the residential sector and how your analytical skills can contribute to JLL’s mission. Keep it concise but impactful!
Showcase Your Technical Skills: Be specific about your technical abilities in your application. Mention your experience with data modelling, automation scripts, and any complex datasets you've worked with. This will help us see your fit for the role.
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s straightforward and ensures your application goes directly to us. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Jones Lang LaSalle Incorporated
✨Know Your SQL Inside Out
Since the role requires advanced SQL skills, make sure you brush up on complex joins, stored procedures, and performance optimisation. Prepare to discuss specific projects where you've used these techniques, as it shows your practical experience.
✨Showcase Your Data Visualisation Skills
Be ready to talk about your experience with Power BI and how you've created interactive dashboards. Bring examples of your work that demonstrate your ability to turn complex data into clear, actionable insights for stakeholders.
✨Prepare for Technical Questions
Expect questions that test your knowledge of Python and VBA, especially in relation to automation and data manipulation. Practise explaining your thought process when solving technical problems, as this will highlight your analytical thinking.
✨Engage with Stakeholder Scenarios
Think of examples where you've presented findings to clients or collaborated with cross-functional teams. Being able to communicate technical concepts to non-technical stakeholders is crucial, so prepare to demonstrate your communication skills.
