Lead Analyst in Brentford

Title

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 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.
• Required Skills & Experience
• At least five years’ experience in data analysis, business intelligence, analytics engineering or a closely related role, with evidence of making a measurable business impact.
• Practical experience with Microsoft Fabric and a good understanding of capacity units, consumption, performance and workload optimisation.
• Strong hands-on experience building, managing and developing Power BI reports and dashboards.
• Strong understanding of dimensional modelling, semantic models, relationships, measures, reusable metrics and best-practice Power BI architecture.
• Experience designing models for self-service analytics, governed reporting and/or AI-enabled data experiences such as Data Agents.
• Clear understanding of the differences between data warehouses and data lakes, their respective strengths and limitations, and how to use them within a modern data platform.
• Strong SQL skills and the ability to write, understand and improve complex queries.
• Experience working with data pipelines, transformations, APIs or automation.
• A self-sufficient and methodical approach to troubleshooting and problem solving.
• Ability to turn ambiguous stakeholder questions into well-defined, deliverable solutions.
• Ability to identify trends and translate analysis into clear commercial insight and action.
• Excellent written and verbal communication skills, including the confidence to work with senior stakeholders.
• Experience with Fabric Data Agents, Copilot or other natural-language analytics solutions.
• Experience using Fabric APIs, Power BI APIs or scripting to automate administration and development tasks.
• Experience with Visual Studio, Git, deployment workflows or software-engineering practices applied to analytics.
• Experience working in a property, sales, marketing or technology environment.
• Experience defining data governance, report certification, metric ownership or data quality processes.

Benefits

• Flexible working
• 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

The interview process will be multi-step and is expected to include

• Initial conversation about your experience, approach and motivation.
• Technical assessment, including an in-person session showcasing practical technical skills and problem solving.
• Stakeholder and analytical discussion focused on turning business questions into insight and action.
• Executive-level interview.