Lead Analyst

Location: London, Chiswick Business Park (up to two days a week working from home)

Reports to: Director of Business Analytics

Salary: £80k–£85k annual salary

Role Overview

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.

Key Responsibilities

Data Strategy, Platform & Governance

• 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 optimization
• 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