Business Intelligence Consultant

Overview

This is a client‑facing BI role where you’ll take requirements, build solutions, and deliver them directly to customers. You’ll work closely with legal teams, legal operations, and technology stakeholders to understand how they operate and where data and automation can make a real difference. The focus is on turning complex or manual processes into clear, usable insights and efficient workflows. You’ll be involved from early conversations through to delivery, helping clients improve reporting, streamline approvals, and make better decisions using Power BI and Power Automate.

This is a hybrid role based from our Birmingham HQ, with flexible working in place and an expectation to be in the office when needed, typically on a weekly basis.

• Build and maintain Power BI dashboards and reports for client delivery
• Design data models, DAX measures, and transformations for scalable, accurate reporting
• Develop Power Automate workflows to streamline processes and approvals
• Translate business needs into practical BI and automation solutions
• Ensure data is secure, compliant, and aligned with governance standards
• Document solutions clearly and support ongoing improvements

• Strong experience as a BI Developer or BI Consultant
• Advanced Power BI skills including data modelling, DAX, and Power Query
• Hands‑on experience with Power Automate and workflow design
• Experience working with stakeholders and gathering requirements
• Background in a regulated environment such as legal, finance, or similar

• Experience working with legal systems or legal teams
• SQL and relational database knowledge
• Exposure to Microsoft 365 integrations

• 26 days’ holiday + bank holidays (and the option to buy more) plus 1 paid volunteering day each year
• Exceptional family leave: 26 weeks fully paid maternity/adoption, 4 weeks fully paid paternity, 22 weeks fully paid shared parental leave, plus 5 days paid bereavement leave
• Robust sick pay of up to 13 weeks full pay + 13 weeks half pay
• 24/7 Employee Assistance Programme for confidential support
• Private medical insurance for everyone, no medical‑history exclusions
• Performance‑based rewards tailored to your role, from company‑wide bonuses to OTE and commission structures
• Income protection: up to 75% salary for 5 years if you ever need it
• Skills Hub learning platform with leadership pathways, future‑manager training, and a huge online library
• Access to external training and apprenticeships
• Match It! Fundraise for a cause close to your heart and One Advanced will match part of the funding
• Pennies from Heaven donate the pennies from your pay check to help make a difference without lifting a finger
• ULEV car scheme with 1,000+ models
• Dental insurance, Health Cash Plan, Critical Illness Cover, Partner Life Cover

Applicants must have the legal right to work in the UK at the time of application.