Title: Power BI Developer
Location: London, Chiswick Business Park (up to two days a week working from home)
Reports to: Director of Business Analytics
Salary: £60-65,000k annual salary
About the role
Foxtons is looking for a technically strong Data Analyst to become the go-to Power BI developer within a small, highly technical and highly efficient Business Analytics team. Power BI development will form a large part of the role as we migrate our reporting and analytical models towards Microsoft Fabric.
This is a hands-on role for someone who understands both the technology and the business purpose behind a report. You will scope and design solutions, build trusted semantic models, create polished reports, release them safely, train users and remain accountable for their usability and accuracy. You will be expected to move quickly, respond well to changing priorities and explain the data clearly to both technical and non-technical audiences.
You will also help create the data foundation for AI-enabled and agentic ways of working. This means making semantic models genuinely usable by AI through strong metadata, clear table, column and measure descriptions, well-defined relationships, reusable measures and governed business definitions. You will have the opportunity to use the wider Fabric ecosystem where it improves the quality, performance or maintainability of the solution.
What you will do
Power BI development and reporting
- Own the development, maintenance and continuous improvement of a significant Power BI reporting estate.
- Scope requirements with stakeholders and translate business questions into clear analytical and technical solutions.
- Design and build attractive, intuitive and performant reports for executives, managers and operational users.
- Develop robust semantic models using dimensional modelling, clear relationships, reusable measures and appropriate calculation groups.
- Use DAX and Power Query confidently, applying sound modelling and performance principles.
- Understand the data and business purpose behind every report you own, and explain its outputs and limitations to end users.
- Release changes safely, manage feedback and make fast, controlled updates as business needs evolve.
Fabric and AI-ready semantic models
- Contribute to the migration of existing reporting and analytical models into Microsoft Fabric.
- Use relevant Fabric capabilities to create reliable, maintainable and analyst-friendly data products.
- Make semantic models ready for AI and natural-language experiences through high-quality metadata and documentation.
- Write and maintain clear descriptions for tables, columns, measures, calculation groups and business definitions.
- Design models that can support governed Data Agents and other agentic systems without compromising trust, security or performance.
- Keep up to date with the latest Power BI and Fabric features, assessing where new capabilities can improve the team’s work.
- Help identify and deliver practical AI and automation opportunities that reduce manual effort or improve decision-making.
Delivery, adoption and quality
- Work directly with marketing, sales, lettings, finance, technology and other business teams to understand needs and priorities.
- Train users and improve confidence, adoption and data literacy across the business.
- Investigate data issues, explain root causes and implement sustainable fixes.
- Monitor report performance, refresh reliability, data quality and platform usage.
- Apply consistent standards for report design, KPI definitions, documentation, governance and development practices.
- Use Git, source control and CI/CD or deployment workflows to support safe and repeatable development across environments.
SQL, automation and AI-assisted development
- Write, understand and improve SQL used to prepare, validate and analyse data.
- Use AI development tools such as Codex as part of daily development practice to improve speed, quality and repeatability.
- Use AI tools responsibly to update queries, develop transformations, investigate errors, create documentation and automate repeatable tasks.
- Validate AI-generated code and outputs rather than accepting them without review.
- Use Python for data analysis, automation or integration where it adds value; Python is beneficial but not essential.
What we are looking for
Essential experience and technical capability
- Three to five years of professional experience in data analysis, business intelligence, analytics engineering or a closely related role in an enterprise environment.
- Strong hands-on Power BI development experience, including report design, DAX, Power Query, semantic models and performance-aware modelling.
- Experience designing reports that are visually clear, useful and appropriate for the audience, rather than simply technically correct.
- Strong SQL skills and the ability to investigate data, validate results and identify data-quality issues.
- Practical experience with Microsoft Fabric, or demonstrable experience with modern Microsoft data platforms and a strong appetite to develop deeper Fabric expertise.
- Understanding of metadata, documentation, reusable measures, calculation groups and the requirements for AI-ready semantic models.
- Experience with Git, source control and CI/CD, deployment pipelines or equivalent release-management practices.
- Experience gathering requirements, scoping work, managing change and explaining analytical outputs to business users.
- Evidence of using AI development tools regularly and responsibly to improve personal productivity and delivery quality.
Desirable experience
- Experience with Fabric lakehouses, warehouses, pipelines, Dataflows Gen2, Direct Lake or Fabric semantic models.
- Experience with calculation groups, Tabular Editor, deployment pipelines or Power BI APIs.
- Experience designing models for Power BI Copilot, Fabric Data Agents or other natural-language analytics solutions.
- Experience with Microsoft Purview, data lineage, certification, metric ownership or data-quality frameworks.
- Python experience for analysis, automation, API integration or data engineering.
- Experience using Visual Studio Code, GitHub or Azure DevOps in an analytics development workflow.
- Experience in property, sales, marketing, finance or another operationally complex environment.
How you work
- You take ownership and can work independently while knowing when to seek input.
- You care about the purpose behind the report and the decision it is intended to support.
- You combine speed with disciplined testing, documentation and release practices.
- You communicate simply and directly with technical and non-technical audiences.
- You are curious about new Power BI, Fabric and AI capabilities and test them pragmatically.
- You are comfortable receiving feedback, iterating quickly and improving your work.
- You treat data quality, metadata and governance as part of development rather than as an afterthought.
Why join Foxtons
This is an opportunity to join a small team where your work will be visible and directly connected to business outcomes. Foxtons is investing in modern BI, Microsoft Fabric, high-quality semantic models and practical AI-enabled ways of working. You will have meaningful ownership, access to a broad range of business data and the opportunity to shape how Power BI and Fabric are used across the organisation.
Benefits
- £60k-£65k salary
- 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
Diversity and inclusion
Foxtons is committed to building an inclusive workplace and welcomes applications from people with diverse backgrounds, experiences and perspectives. We are interested in what you can bring to the role and will consider transferable skills alongside direct experience.