Foxtons is London’s leading estate agency, known for our innovative approach to property sales and lettings. We use data, technology and analytics to support better decision-making across the business and help our teams operate more effectively.
Our Business Analytics team plays a key role in this, delivering reporting, insights and analytical tools that support commercial performance, customer experience and operational efficiency.
We are looking for a Junior Data Analyst to join the team. This is an entry-level role and would suit a graduate or early-career analyst with some hands-on Power BI experience, either through work experience, an internship, a placement, a personal project or an online course.
The role will be predominantly focused on Power BI development, maintaining and improving existing reporting, owning report changes, and helping users across the business understand and act on the data available to them. There will also be opportunities to use SQL and Python where applicable.
What You’ll Be Doing
As a Junior Data Analyst, you will support the delivery, maintenance and improvement of reporting across the business.
Your day-to-day responsibilities will include:
- Power BI dashboard development – Building, maintaining and improving Power BI reports and dashboards used by teams across the business.
- Owning reporting changes – Managing updates to existing reports, gathering requirements, making changes, testing outputs and ensuring updates are clearly documented.
- Presenting reports to users – Supporting stakeholders in understanding reports, explaining key metrics and presenting data in a clear, practical way.
- Improving reporting quality – Helping ensure reports are accurate, user-friendly, visually clear and aligned with business needs.
- Working with SQL – Using SQL to query, extract and check data from our databases, with support from more experienced members of the team.
- Using Python where applicable – Applying Python for analysis, automation or data preparation where it adds value.
- Collaborating with the wider team – Working with analysts and stakeholders to understand reporting requirements, define KPIs and improve how data is used across the business.
Supporting data quality and governance – Helping to identify issues, validate outputs and maintain confidence in the data used for reporting.
-
This is an entry-level role, so we do not expect you to know everything. We are looking for someone with strong potential, curiosity and a genuine interest in data and reporting.
To succeed in this role, you should be able to demonstrate:
- Hands-on Power BI experience, including building dashboards and using basic DAX
- Strong analytical or numerate background (degree or equivalent practical experience)
- Working knowledge of SQL (joins, filtering and aggregations)
- Evidence of applying these skills in practice (e.g. portfolio, projects, internships or work experience)
Exposure to Python is beneficial but not required.
This is a hybrid role, offering flexibility to work from home for part of the week. However, we believe this role will suit someone who enjoys being in the office, learning from others face-to-face and building strong relationships with stakeholders across the business.
As an entry-level position, time in the office will be valuable for training, collaboration and developing a strong understanding of how the business uses data.
Why Join Us?
- Competitive Salary – £35,000 depending on experience.
- Hybrid Working – Flexibility to work from home part of the week, with regular office collaboration.
- Holidays & Time Off – 25 days annual leave, plus one fully paid day each year to volunteer for a charity of your choice.
- Career Growth – Access to mentorship, training and opportunities to develop your skills in Power BI, SQL, Python and business analytics.
- Impactful Work – Your reporting will help shape decisions across one of London’s most recognised property brands.
- Innovative Culture – Be part of a forward-thinking analytics team using modern tools and technologies.
- Modern Data Platform – Work with an Azure-based data architecture, cloud technologies and scalable reporting solutions.
- Diversity & Inclusion – Be part of our employee-led D&I networks and initiatives that support an inclusive workplace.
- Wellbeing Package – Enjoy enhanced sick pay, a confidential counselling helpline, access to Mental Health First Aiders and a subsidised gym membership.
- Parental Benefits – Benefit from enhanced parental leave policies, including generous shared parental leave.
- Great Perks – Regular company events, discounts on property services and a vibrant team culture
As London’s number 1 estate agency brand,* our customers choose us because we get it done. And we know it’s our people that make us so successful. In over 40 years serving London and the Home Counties, we have discovered a winning formula for creating driven and ambitious professionals. This includes the best training at every stage, market-leading technology and the opportunity to work alongside some of the industry’s most influential professionals.
Is it important for you to know our Corporate Social Responsibility before you apply? Great, it’s important to us too. Whether we’re providing LGBTQ+ safe spaces, stocking our offices from charitable water suppliers or engaging in fabulous local events, our 50+ offices across London play a key part in our communities. We also offer annual paid time off for employees to volunteer at a charity of their choice. Many choose to support our partner, Single Homeless Project. This is London's largest homelessness charity, making a difference in 10,000 Londoners’ lives across all 32 boroughs.
* TwentyCI data, 2023 v 2022 market share and market share growth of new instructions at a brand level
