At a Glance
- Tasks: Analyse data and create insights to support residential valuations.
- Company: Join JLL, a global leader in real estate and investment management.
- 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, strong SQL and Python skills required.
- Other info: Dynamic team atmosphere with opportunities for professional development.
The predicted salary is between 28800 - 43200 £ 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 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
✨Tip Number 1
Network like a pro! Reach out to current employees at JLL on LinkedIn or attend industry events. A friendly chat can give you insider info and maybe even a referral!
✨Tip Number 2
Prepare for the interview by brushing up on your SQL and Power BI skills. Be ready to showcase your analytical prowess with real-life examples from your past work.
✨Tip Number 3
Don’t just talk about your technical skills; show your passion for the residential sector! Share insights on market trends or recent developments that excite you during interviews.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in joining the JLL team.
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 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 background makes you a great fit for our team at JLL. Keep it engaging and personal!
Showcase Your Analytical Skills: In your application, be sure to include examples of how you've used data analysis to drive decisions or improve processes in previous roles. We love seeing how you’ve made an impact through your analytical prowess!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to see your application and get to know you better. Plus, it shows you’re serious about joining our team!
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 this will show your practical experience.
✨Show Off Your Data Visualisation Skills
Be ready to talk about your experience with Power BI. Bring examples of dashboards you've created and be prepared to explain how they provided actionable insights. This will demonstrate your ability to translate data into meaningful information for stakeholders.
✨Demonstrate Your Analytical Thinking
Prepare to tackle some analytical problems during the interview. Practice explaining your thought process clearly and concisely, as strong problem-solving abilities are crucial for this role. Use real-life examples to illustrate your approach.
✨Engage with Stakeholders
Since client engagement is key, think of instances where you've presented findings to non-technical audiences. Highlight your communication skills and adaptability in these situations, as this will show that you can bridge the gap between technical data and business needs.