Business Intelligence Consultant

One Advanced is seeking a client‑facing Business Intelligence role focused on delivering solutions to legal teams and other stakeholders. You will take requirements, build and maintain Power BI dashboards, design data models and DAX measures, develop Power Automate workflows, translate business needs into practical solutions, and ensure data security and compliance.

• 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 every 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