Business Intelligence Lead
Job description
Lead BI Engineer / Business Intelligence Lead
Location: Remote (UK) with frequent travel
Salary: £75,000 – £95,000 + 15% annual bonus
The Opportunity
We are looking for an experienced Lead BI Engineer to take ownership of technical delivery within our growing Business Intelligence practice.
This is an exciting opportunity for a technically strong BI professional who enjoys combining hands-on engineering expertise with technical leadership, consultancy and team development.
You will play a pivotal role in delivering high-quality, enterprise-scale Business Intelligence solutions, translating architectural strategy into practical, scalable and commercially effective outcomes. Working closely with Principal-level engineers, you will lead the day-to-day technical delivery of BI projects, ensuring solutions meet the highest standards of performance, quality and maintainability.
The role offers the opportunity to work across modern data platforms, including Microsoft Fabric, Azure Synapse, Databricks and Lakehouse architectures, while helping shape the future of our BI capability, including AI and Copilot-ready analytics.
If you enjoy solving complex technical challenges, developing talented engineers and building strong client relationships, this could be the ideal next step in your career.
What You’ll Be Doing
Technical Leadership & BI Delivery
- Lead the technical delivery of BI projects, taking ownership of solution quality, performance and delivery outcomes.
- Design, develop and optimise enterprise-scale BI solutions using Power BI, Microsoft Fabric, Azure Synapse, Databricks and Lakehouse technologies.
- Provide expert guidance on data modelling, tabular models, DAX development and reporting architecture.
- Remain hands-on with complex BI builds, model refactoring and performance optimisation.
- Translate business requirements into robust, scalable and maintainable BI solutions.
- Develop datasets and reporting solutions that support advanced analytics and AI/Copilot integration.
Engineering Standards & Best Practice
- Champion BI engineering standards, including coding conventions, data modelling principles, testing and deployment practices.
- Drive continuous integration and deployment (CI/CD) across BI solutions using Azure DevOps, Git, Tabular Editor and Power BI Deployment Pipelines.
- Implement performance monitoring, optimisation and cost-management practices.
- Develop reusable patterns, templates and accelerators to improve consistency and delivery efficiency.
- Ensure security, governance and cost-efficiency are embedded throughout the BI development lifecycle.
Client & Consultancy Leadership
- Act as the primary technical point of contact for clients on BI-related engagements.
- Lead technical workshops, solution design sessions and performance reviews.
- Communicate complex technical concepts clearly to both technical and non-technical stakeholders.
- Provide confident technical recommendations, constructively challenge approaches where necessary and build trusted client relationships.
- Advise clients on BI best practice, emerging technologies and AI/Copilot adoption.
Delivery & Commercial Ownership
- Take responsibility for day-to-day technical delivery, including milestones, technical risks and solution quality.
- Contribute to project planning, estimation and resource allocation.
- Identify and resolve delivery challenges, escalating risks where appropriate.
- Ensure solutions are commercially viable, technically robust and delivered to agreed timescales.
Leadership & Mentorship
- Coach and mentor BI Engineers and Senior BI Engineers.
- Support the development of technical skills across DAX, SQL, data modelling, performance tuning and CI/CD.
- Encourage a culture of technical excellence, continuous learning and accountability.
- Support individual development plans, certification pathways and career progression.
- Act as the technical authority within the BI squad, supporting engineers to deliver their best work.
What We’re Looking For
Technical Experience
You’ll bring strong hands-on experience and technical expertise across:
- Expert-level Power BI, DAX, SQL and tabular modelling.
- Enterprise BI solution design and delivery.
- Microsoft Fabric, Azure Synapse, Databricks and Lakehouse architectures.
- DAX, SQL and data model performance optimisation.
- BI deployment and CI/CD practices.
- Tabular Editor, Azure DevOps, Git and Power BI Deployment Pipelines.
- BI monitoring, performance management and cloud cost optimisation.
- Data governance, security and enterprise reporting architecture.
- Building datasets and semantic models suitable for AI and Copilot integration.
Leadership & Consultancy Experience
You’ll also have:
- Experience leading BI projects, technical teams or delivery squads.
- A background in consultancy or client-facing technical delivery.
- The ability to translate architectural direction into practical engineering solutions.
- Strong stakeholder management and client engagement skills.
- Confidence leading workshops, design discussions and technical problem-solving sessions.
- A genuine passion for coaching, mentoring and developing other engineers.
Qualifications & Certifications
Relevant Microsoft or Databricks certifications are desirable, including:
- Microsoft Certified: Fabric Analytics Engineer Associate.
- Microsoft Certified: Power BI Data Analyst Associate.
- Microsoft Certified: Fabric Data Engineer Associate.
- Databricks Certified: Data Engineer Professional.
What’s on Offer?
- Competitive salary of £75,000 – £95,000.
- 15% annual bonus.
- Remote working with frequent travel across the UK.
- The opportunity to work with modern Microsoft and Databricks data technologies.
- A senior technical leadership position with genuine influence over BI delivery and engineering standards.
- The opportunity to mentor and develop a talented BI engineering team.
- Exposure to enterprise-scale data, analytics and AI-driven solutions.
Diversity, Equity & Inclusion
We are committed to building an inclusive workplace where everyone feels valued, respected and able to thrive. We welcome applications from people of all backgrounds, identities, experiences and abilities. We believe diverse perspectives make our teams stronger and encourage applications from anyone who feels they have the skills and experience to make an impact.
We are committed to providing a fair and accessible recruitment process and will consider all applicants on the basis of their skills, experience and potential, without discrimination.