> Markdown version of [/jobs/ext/4046482-lead-analytics-engineer](https://www.wearedevelopers.com/jobs/ext/4046482-lead-analytics-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Analytics Engineer

- **Company:** Dexters
- **Location:** London, United Kingdom
- **Experience:** Expert
- **Salary:** £80,000 - £90,000
- **Contract:** Permanent contract
- **Skills:** Business Analytics Applications, Data Analysis, Business Logic, Data Validation, Database Queries, Dimensional Modeling, Power BI, SQL Databases, Snowflake
- **Published:** October 21, 2026
- **Apply:** https://www.totaljobs.com/job/lead-analytics-engineer/dexters-job108221074

## About the Role

This is a senior, hands-on role combining strong BI expertise with the ability to structure data around meaningful commercial questions., * 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.

## Description

* 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.