Lead Business Intelligence Engineer

Permanent, Full-Time | Remote (UK) | Frequent Travel

Are you passionate about leading technically outstanding BI delivery that blends deep data‑modelling expertise with hands‑on ownership of scalable, high‑impact reporting solutions?

Who we are

Arreoblue is a Data Analytics Consultancy, specialising in fast execution of data projects from concept to delivery. Focusing on Retail, Manufacturing & Financial Services, we help our clients become data driven and make more effective decisions through data. We focus and measure ourselves on delivering fast Time to Value. We work with our clients to ensure that value is clear, and everything is understood leaving our clients with a platform for success that they can continue to build on.

At Arreoblue we value humility, collaboration, excellence, innovation and trust. We seek individuals who want to grow and share their knowledge with our teams and customers. If you are someone who enjoys collaborating with others, learning new things, and contributing to both internal and public communities, we’d love to hear from you.

What you will do

The Lead BI Engineer owns the technical delivery within the BI practice, focusing on data modelling, reporting, and analytical solution delivery. They translate Principal-level standards and architecture into high-quality, performant BI solutions while coaching and developing BI Engineers.

They are accountable for day-to-day delivery, quality, performance, and client confidence in the BI domain, ensuring all BI solutions are scalable, maintainable, and aligned to best practice. This includes owning platform migrations, capacity management, and commercial justification for platform investments - not just the technical build.

This role blends:

• Deep technical expertise in BI solution design, data modelling, and DAX development
• Delivery leadership and squad/project ownership
• Mentorship and development of BI Engineers
• Consultancy and client-facing capability
• Platform migration leadership and end-to-end delivery lifecycle ownership
• Capacity management and commercial accountability for platform investments
• Internal tooling development and adoption framework design

The Lead BI Engineer ensures BI projects are delivered efficiently, with high technical quality, and aligned to broader engineering standards and strategic direction.

Key Responsibilities

BI Solution Delivery & Architecture

• Own technical delivery for BI projects, ensuring high-quality, performant, and maintainable solutions.
• Lead the design, development, and optimisation of enterprise-scale BI solutions across Azure Fabric, Synapse, Databricks, and Lakehouse environments.
• Lead end-to-end platform migrations (e.g. Power BI Premium to Microsoft Fabric), covering the full delivery lifecycle from planning through to go-live and post-migration stabilisation.
• Provide technical guidance on data modelling, DAX optimisation, tabular modelling, and reporting performance.
• Ensure solutions support advanced analytics, including AI/Co-Pilot-ready datasets and reporting.
• Conduct performance tuning and optimisation across DAX, SQL, and data models to deliver responsive reporting solutions.
• Design and execute pre-production load testing to validate solution performance and resilience under realistic concurrent user conditions.
• Remain hands-on with complex BI builds, model refactoring, and performance problem solving.
• Translate business requirements into pragmatic, high-quality BI solutions aligned with Principal-defined architecture.

Engineering Standards & Best Practice

• Implement and enforce BI engineering standards, including coding standards, modelling best practices, CI/CD, and testing strategies.
• Apply and improve continuous integration and deployment processes for BI content using tools such as: Azure DevOps / Git, Tabular Editor, Power BI Deployment Pipelines, Capacity Metrics app and performance monitoring dashboards
• Own Fabric capacity management across client environments, including capacity sizing, procurement, cost-benefit modelling, utilisation monitoring, and right-sizing recommendations.
• Build and maintain internal tooling, accelerators, and automation scripts to improve delivery consistency and reduce manual overhead.
• Contribute reusable BI patterns, templates, and accelerator content to improve delivery consistency.

Interested in remote work opportunities in Devops? Discover Devops Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.

• Ensure security, governance, and cost-efficiency are embedded into all BI solutions.

Consultancy & Client Leadership

• Act as the primary technical contact for clients on BI solutions.
• Lead BI-focused workshops, solution design sessions, and performance reviews.
• Translate complex BI concepts into clear guidance for clients, stakeholders, and delivery teams.
• Confidently challenge inefficient approaches or unsafe delivery practices while maintaining strong client relationships.
• Promote BI best practice internally and externally, including AI/Co-Pilot adoption and modern analytics trends.

Delivery & Commercial Accountability

• Own day-to-day technical delivery of BI projects, including milestone management, technical risk, and solution quality.
• Author business cases and commercial justifications for platform investments, articulating financial impact and strategic value to client stakeholders.
• Assess client BI maturity using structured adoption frameworks, and define adoption roadmaps aligned to business goals and platform capability.
• Support project planning, estimation, and resourcing with accurate technical input.
• Escalate issues appropriately and intervene in problem resolution when required.
• Ensure solutions are commercially viable, technically sound, and delivered on time.

Leadership & Mentorship

• Coach and mentor BI Engineers and Senior BI Engineers in:
• Data modelling best practices
• DAX and SQL optimisation
• Performance tuning
• Deployment pipelines and CI/CD
• Promote a culture of technical excellence, learning, and accountability.
• Act as the go-to technical authority within the BI squad or project.
• Support progression and development plans for BI practice members, including certification paths and skills growth.

How you will do it

Technical Expertise

• Expert-level proficiency in DAX, Power BI, SQL, and tabular model design.
• Strong experience with Azure Fabric, Synapse, Databricks, and Lakehouse data architectures.
• Performance tuning expertise for both data models and DAX measures.
• Hands-on experience with BI CI/CD tools, including: Tabular Editor, Azure DevOps / Git integration for BI, Power BI Deployment Pipelines, Capacity Metrics app and utilisation monitoring
• Capacity management expertise: Fabric capacity sizing, cost-benefit analysis, procurement advisory, and utilisation optimisation across client environments.
• Ability to design and implement comprehensive BI security frameworks covering data access, information protection, and governance controls.
• Experience building internal tooling and accelerators to automate BI operations and improve delivery efficiency.
• Experience building datasets and models designed for AI/Co-Pilot integration.
• Strong understanding of data governance, security, and best practice reporting architecture.

Leadership & Consultancy Skills

• Proven experience leading BI delivery in consultancy or client-facing environments.
• Ability to translate Principal strategy into practical BI delivery.

Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.

• Strong stakeholder management skills with confidence engaging senior client teams.
• Excellent communication skills, capable of explaining technical BI concepts to non-technical audiences.
• Comfortable leading design sessions, workshops, and problem-solving discussions.

Experience & Background

• Demonstrable experience delivering enterprise BI solutions, dashboards, and analytics platforms.
• Experience leading BI projects or squads, owning technical delivery and team guidance.
• Track record of optimising complex BI models for performance and scalability.
• Experience with Azure, Fabric, Synapse, Databricks, and Lakehouse integration.
• Experience leading platform migrations end-to-end, including planning, phased delivery, and post-migration stabilisation.
• Experience owning capacity planning and procurement, and authoring commercial justifications for platform investments.

Certifications

• Microsoft Certified: Fabric Analytics Engineer Associate
• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Certified: Fabric Data Engineer Associate
• Databricks Certified: Databricks Data Engineer Professional (optional if working in Lakehouse environments)

Why choose Arreoblue?

As partners with Microsoft, Databricks, BlakYaks and Datometry, we offer an expansive range of training, knowledge, and opportunities within the data and delivery industry. We are committed to investing in our people, and this is reflected in our team’s culture and approach to work.

We love data and are deeply engaged with the fast-evolving technologies and communities around it. We encourage our employees to blog, attend, contribute, and present at delivery and / or data events - no matter how big or small. We are fully committed to supporting your professional development.

What you will get in return

• Competitive salary up to £75,000 depending on experience (excluding bonus & benefits)
• Competitive Holidays
• Pension Contributions
• Private Healthcare (following successful probation)
• Company Discretionary Performance-Based Bonus
• Training & Development Packages
• Flexible Working
• Paid Events & Company Days

Location(s)

We are a fully remote company but love spending time with our customers so we like to be present and on site with them when we can – at least two to three days a week.

All candidates must reside and be eligible to work in the UK to be considered for this role. We cannot support VISA sponsorship at this time.

We encourage flexible working in terms of both hours and location, with the expectation that employees may get together from time to time. Any required travel to clients will be covered by us.

Arreoblue is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Apply now to become a key part of our growing team!