Business Intelligence Team Manager

Dentons Canada; Greater London; Hybrid; GBP 80,000 - 140,000; Full time

Job summary

Dentons is seeking a Business Intelligence Team Manager within the Finance Systems function in London. The role leads a Power BI and reporting team, guiding technical direction, delivery, and governance for the firm’s modern analytics platform built on Microsoft Fabric and Power BI.

You will collaborate with Finance, HR, Risk and Practice Groups to translate requirements into scalable BI solutions, overseeing development, security, and the migration from legacy reporting to a governed,

Qualifications

• Significant experience in Finance, IT or professional-services BI/reporting environments.
• Strong hands-on Power BI expertise including data modelling, DAX and Power Query.
• Practical experience with Microsoft Fabric or a comparable modern Microsoft data platform with credible technical leadership.
• Experience leading or mentoring BI/reporting professionals.
• Solid understanding of data warehousing, ETL/ELT, semantic modelling and enterprise reporting concepts.
• Proven ability to deliver enterprise-level reporting solutions and manage priorities with senior stakeholders.

Responsibilities

• Lead, mentor and develop a team of Power BI developers and reporting analysts.
• Manage team workload, priorities and resources across project delivery and reporting support.
• Provide technical leadership and act as the senior escalation point for Power BI issues.
• Translate requirements into practical BI solutions with stakeholders across Finance, HR, Risk and Practice Groups.
• Own and deliver the BI roadmap, shaping Fabric/Power BI architecture with data architects and platform teams.
• Promote governance, standards, documentation and change-control in BI development.
• Oversee reporting development and delivery of high-quality financial, operational and client reports.
• Ensure security controls and data protection across BI outputs.
• Support migration from legacy reporting including SSRS and Excel-based solutions.

Skills

Power BI

Data modelling

DAX

Power Query

SQL

Azure data services

Synapse

Microsoft Fabric

BI governance

Leadership

Stakeholder management

ETL/ELT

Data warehousing

Tools

SSRS

Excel

Job description

The Role

The Business Intelligence Team Manager is a hands-on leadership role within Finance Systems, responsible for leading the Business Intelligence team and helping modernise the firm’s reporting and analytics capability. The role combines people leadership, technical direction, business analysis and service ownership, while championing reporting best practice across the firm’s financial data and wider reporting estate.

Following the implementation of the firm’s new Practice Management System, the successful candidate will help maximise the value of that investment by providing timely, accurate and trusted information. It will also play a key role in the transition from legacy reporting towards a governed, modern Microsoft Fabric and Power BI analytics platform.

Role Responsibilities

Leadership and Team Management

• Lead, mentor and develop a team of Power BI developers and reporting analysts, creating clear accountability for delivery and quality.
• Manage team workload, priorities and resources across project delivery, continuous improvement and business-critical reporting support.
• Provide technical leadership and act as the senior escalation point for Power BI, reporting and analytics issues.
• Build strong relationships with Finance, HR, Risk, Practice Groups and other business stakeholders, translating requirements into practical BI solutions.
• Work effectively with data architects, technology teams, vendors and other specialists across the firm.

Data Platform & Integration

• Own and maintain the BI delivery roadmap, working with the Head of Finance Systems and key stakeholders to prioritise initiatives the roadmap and shape and implement the BI elements of the firm’s modern Microsoft Fabric and Power BI architecture in collaboration with data architects and platform teams.
• Provide technical direction for scalable Fabric/SQL-based data models and integration of data from Elite 3E, global EDB and other firmwide applications.
• Promote robust development lifecycle practices across Development, UAT and Production environments, including source control, deployment, testing and change management.
• Improve monitoring, performance and reliability across the BI platform and reporting estate.
• Identify appropriate opportunities for automation, self-service analytics, AI-assisted analytics and conversational BI.

Reporting Development & Delivery

• Provide technical ownership and assurance for the firm’s Power BI reporting estate, including dashboards, reports, semantic models and supporting data products.
• Oversee the design, development and deployment of high-quality financial, operational and client reporting, remaining hands-on where appropriate.
• Ensure reporting outputs are accurate, consistent, performant and easy to use.
• Establish clear ownership of business measures, KPI definitions and reusable semantic models to promote a consistent version of the truth.
• Oversee appropriate reporting and data security, including row-level security, object-level security and associated access controls.
• Support the controlled migration and rationalisation of legacy reporting, including SSRS and Excel-based solutions.

Governance & Continuous Improvemen t

• Champion BI governance and standardisation, working with data architects and business owners to ensure clear responsibilities for data, models, measures and reports.
• Define and maintain BI development standards, naming conventions, documentation requirements, report UX standards, security standards and change-control processes.
• Define and maintain agreed data definitions and reporting measures in partnership with relevant business owners.
• Promote documentation, version control, testing, reconciliation and quality assurance as standard development practices.
• Ensure BI investment delivers measurable business value by reducing manual reporting and improved data quality and self-service capabilities helping users understand and make effective use of the information available to them.
• Stay current with developments in Power BI and Microsoft Fabric and assess where new capabilities can add practical value to the firm.

Experience, Skills & Knowledge

• Significant experience within a Finance, IT or professional-services BI, analytics or reporting environment.
• Strong hands-on Power BI expertise, including data modelling, DAX and Power Query.
• Practical experience with Microsoft Fabric or a comparable modern Microsoft data platform, with the ability to provide credible technical leadership.
• Experience leading, mentoring or providing technical direction to BI/reporting professionals.
• Solid understanding of data warehousing, ETL/ELT, semantic modelling and enterprise reporting concepts.
• Proven experience delivering and supporting business-critical, enterprise-level reporting solutions.
• Ability to manage competing priorities, translate business requirements into effective solutions and work with senior stakeholders and vendors.
• Strong analytical, organisational, documentation and communication skills, with meticulous attention to detail.
• A collaborative, customer-focused approach and the ability to operate effectively through periods of change.
• Experience in a law firm or other professional-services environment.
• Knowledge of Elite 3E, Aderant or a comparable practice management system.
• Experience with SQL, Azure data services, Synapse or related Microsoft data technologies.
• Understanding of legal-sector financial and performance measures such as WIP, billing, collections, utilisation and matter profitability.
• Experience establishing BI governance, reporting standards, deployment processes or semantic model standards.
• Exposure to AI-assisted analytics, conversational BI or other emerging analytics capabilities.

What success looks like

• A well-led BI team with clear priorities, strong technical standards and reliable delivery.
• A trusted, consistent reporting estate built around governed measures and reusable semantic models.
• A controlled transition from legacy reporting towards modern Fabric and Power BI capabilities.
• Improved reporting performance, security, usability and confidence in the data.
• Greater adoption of trusted analytics and self-service reporting across the business.

Why Dentons is different

The legal profession is changing rapidly and Dentons is leading the way in advancing change for the benefit of clients. We are driven to challenge the status quo, delivering consistent and uncompromising quality and value to our clients in new and innovative ways. With over 12,000 individuals in more than 179 offices the opportunity is huge.

Dentons continues to receive external awards and recognition, including for our continued international expansion over the last 12 months; for ground-breaking innovation through the development of Nextlaw Labs and Nextlaw Global Referral Network; and for success in advising clients across multiple regions. Dentons is also a leader on the Acritas Global Elite Brand Index and a BTI Client Service 30 Award winner.

Against such rapid growth and change, this role offers the successful individual the chance to play a lead role and make their mark in driving the successful implementation of this global program.

Applications from current residents in the following locations will be considered:

London

Disclaimer: Please ensure when applying for this role you are legally eligible to work/live in your location. Visa sponsorship or relocation costs will not be provided.

Diversity & Inclusion

Essential to our success as a law firm is our ability to attract and retain the best talent from a diverse range of backgrounds. We want a work environment where everyone can reach their potential and we have an inclusive culture which respects individual differences.

We undertake and support a number of internal and external initiatives aimed at increasing diversity within the profession and we encourage all our partners and staff to get involved.

• Dentons is committed to providing equal opportunities for all.

Reward and Recognition

• Remuneration and benefits package will reflect the successful candidate’s experience and country where hired.

Firm Profile

Across more than 80 countries, Dentons helps you grow, protect, operate and finance your organisation by providing uniquely global and deeply local legal solutions. Polycentric, purpose-driven and committed to inclusion, diversity, equity and sustainability, we focus on what matters most to you. www.dentons.com

Inclusion and Diversity

We are committed to building an inclusive culture here at Dentons where our people can thrive, regardless of their background or circumstance. As well as being the right thing to do, it makes good business sense too. A richness of backgrounds, experiences and perspectives helps us best serve our clients and the communities in which we operate. You can find out more about inclusion and diversity at Dentons here: Inclusion and Diversity

Dentons is committed to providing equal opportunities for all. We welcome applications from everyone including of any age, ethnicity, religion, sex, sexual orientation, gender identity, nationality, neurotype, disability, or with parental or caring responsibilities. We are also "Happy to Talk Flexible Working" and welcome conversations about flexible working arrangements.

Dentons is a Disability Confident employer. Candidates with a disability may choose to apply under the Disability Confident Scheme. We will offer an interview to disabled applicants who meet the minimum criteria for the role. Where application volumes are high, we may offer interviews to those who best meet the minimum criteria, consistent with our approach for all candidates.

During the application process, all applicants have the opportunity to tell us about any adjustments or support they require so they are able to perform at their best. Any information you share with us during the application process is treated in confidence.