Lead Analyst

About The Role

Foxtons is looking for a Lead Analyst to join a small, highly technical and highly efficient Business Analytics team. This is a hands-on role with significant autonomy and visibility. You will own and evolve our reporting suite, answer important business intelligence questions, and help colleagues across marketing, sales and technology make better decisions from data.

This is a role for someone who enjoys getting things done themselves. You will manage, update, build and develop Power BI reports and semantic models in Fabric, train users, solve technical problems independently, and work directly with stakeholders to scope and design practical solutions. You will also help Foxtons make the most of Microsoft Fabric, Data Agents and AI-enabled ways of working.

The successful candidate will be able to move comfortably between technical delivery and commercial insight: understanding the architecture behind the data, while keeping an eye on the numbers and calling out meaningful trends, opportunities and areas for improvement. With at least five years' experience of making a measurable impact, you will have the opportunity to become a highly visible partner to senior leaders and the executive team quickly.

• Own the day-to-day management, maintenance and development of Foxtons Fabric and Power BI reporting suite
• Build trusted, usable and performant reports, dashboards and self-service experiences for a range of audiences, including senior executives.
• Design, develop and maintain robust semantic models using best-practice modelling principles, with a particular focus on models that support Data Agents and natural-language access to trusted data
• Translate business intelligence questions into clear requirements, analytical approaches and practical technical solutions
• Embed ethical AI and responsible data practices, ensuring transparency, fairness, and explainability in AI models.
• Work with stakeholders across marketing, sales, technology and the wider business to scope, design and deliver reporting and insight products.
• Investigate data issues, explain the root cause clearly, and implement sustainable fixes.
• Train and enable report users, improving confidence, adoption and data literacy across the business.
• Use Microsoft Fabric effectively, including understanding capacity units, consumption, workload performance and optimisation.
• Contribute to the design and evolution of data warehouse and data lake architectures, understanding when each approach is appropriate and how they work together.
• Build and improve queries, data transformations and pipelines, using SQL and other appropriate tools.
• Use AI to work significantly more productively and efficiently for example, using Codex and Visual Studio to update queries, develop pipelines, connect to Fabric APIs and automate repeatable tasks.
• Monitor data quality, report performance, refresh reliability and platform usage, taking action before issues affect users.
• Explore data proactively and communicate meaningful trends, risks and opportunities, together with recommended actions and potential solutions.
• Establish and promote consistent standards for report design, definitions, documentation, governance and development practices.
• Stay at the forefront of AI/BI technology trends, evaluating and deploying emerging tools that add measurable value.

• £80k-£85k salary
• Flexible working (3 days in the office)
• 25 days holiday + bank holidays
• Salary sacrifice pension scheme
• Comprehensive, ongoing training programme
• Vibrant company culture including paid-for social events
• Diversity and inclusion networks
• One paid work day a year to volunteer for a charity of your choice
• Wellbeing package including enhanced sick pay, free confidential counselling helpline, Mental Health
• First Aiders, and subsidised gym membership
• Enhanced parental policies, including generous shared parental leave
• Subsidised staff canteen and bar

• Initial conversation about your experience, approach and motivation.
• Technical assessment, including an in-person session showcasing practical technical skills and problem solving.
• Stak…