Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join a dynamic team to analyse and model residential property data.
- Company: JLL, a leading firm in residential valuations with a collaborative culture.
- Benefits: Competitive salary, professional development, and opportunities for impactful work.
- Why this job: Make a difference in the residential sector while honing your analytical skills.
- Qualifications: 2-3 years as a Data Analyst with strong SQL and Python skills.
- Other info: Engage with cross-functional teams and present insights to senior leadership.
The predicted salary is between 28800 - 48000 £ per year.
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.
Requirements
- 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.
Data Analyst employer: JLL
Contact Detail:
JLL Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Analyst
✨Tip Number 1
Network like a pro! Reach out to your connections in the property and data analysis sectors. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have a lead on that perfect Data Analyst role!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best data visualisations and projects. Use platforms like GitHub or personal websites to display your SQL queries, Power BI dashboards, and any automation scripts you've developed. This will give potential employers a taste of what you can do!
✨Tip Number 3
Prepare for interviews by brushing up on your technical skills. Be ready to discuss your experience with SQL, Python, and Power BI in detail. Practice explaining complex concepts in simple terms, as you'll need to communicate effectively with both technical and non-technical stakeholders.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got a range of exciting opportunities waiting for talented data analysts like you. Keep an eye on our job listings and make sure your application stands out by tailoring it to the specific role and company culture.
We think you need these skills to ace Data Analyst
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 property industry experience you have. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data analysis and the residential sector. Share specific examples of your past work that demonstrate your analytical and communication skills. We love a good story!
Show Off Your Technical Skills: When filling out your application, be sure to showcase your technical skills clearly. Mention your experience with advanced SQL techniques, data visualisation in Power BI, and any automation scripts you've developed. We’re keen to see your technical prowess!
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re serious about joining our team at StudySmarter!
How to prepare for a job interview at JLL
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss advanced querying techniques, complex joins, and performance optimisation. Practising some real-world scenarios can help you articulate your thought process during the interview.
✨Showcase Your Data Visualisation Skills
Since Power BI is a key part of the role, be ready to talk about your experience with it. Bring examples of dashboards you've created and be prepared to explain how you turned complex data into actionable insights. This will demonstrate your ability to communicate effectively with stakeholders.
✨Demonstrate Your Analytical Thinking
Prepare to discuss specific instances where you've identified trends or insights from large datasets. Use the STAR method (Situation, Task, Action, Result) to structure your answers, showcasing your problem-solving abilities and attention to detail.
✨Engage with the Team's Goals
Research JLL’s residential valuation business and understand their objectives. During the interview, express your enthusiasm for contributing to their goals and how your skills align with their needs. This shows that you're not just looking for a job, but are genuinely interested in being part of their team.
