Lead Analytics Engineer

Dexters is London’s leading independent estate agency. We rely on accurate, timely and well-designed management information to understand performance across a large and growing business.

We are looking for a Lead Analytics Engineer to take technical ownership of our BI and analytics capability, with particular responsibility for reliable semantic models, consistent business metrics and high-quality Power BI solutions.

This is a senior, hands-on role combining strong BI expertise with the ability to structure data around meaningful commercial questions.

Location: Clapham Junction

Salary: £80,000-£90,000

Key responsibilities:

- Lead the technical design of Dexters’ BI and analytics solutions.
- Own the definition and implementation of core business metrics, ensuring they are consistent, traceable and reconciled across models and reports.
- Design scalable dimensional and semantic models for reliable, consistent reporting.
- Establish validation and reconciliation controls to ensure reporting outputs are complete and accurate.
- Own Power BI standards across development, deployment, performance and governance.
- Build complex analytical solutions using DAX, SQL and appropriate transformation tools.
- Translate complex business requirements into well-structured analytical solutions.
- Improve the performance and maintainability of existing Power BI datasets and reports.
- Design and maintain appropriate row-level security and access models.
- Work with Data Engineers to ensure analytical requirements are reflected correctly in the underlying data platform.
- Reduce duplicated business logic through reusable metrics and shared models.
- Provide technical review and mentoring for colleagues developing BI solutions.
- Work directly with senior stakeholders to understand business questions and challenge requirements where appropriate.
- Communicate assumptions, risks and delivery timescales clearly.

What we are looking for:

- Deep practical experience with Power BI in a complex business environment.
- Advanced DAX and strong SQL skills.
- Excellent understanding of dimensional modelling, star schemas and semantic model design.
- Experience creating shared or enterprise analytical models rather than isolated dashboards.
- Strong understanding of Power BI performance, RLS and governance.
- Strong approach to data validation, reconciliation and quality assurance.
- Ability to turn ambiguous business questions into robust analytical solutions.
- Strong commercial judgement and attention to detail.
- Excellent communication skills and confidence working directly with senior stakeholders.
- A track record of raising standards and developing the capability of others.

Experience with Snowflake and dbt would be highly advantageous.