Business Intelligence Consultant

Join OneAdvanced

The BI Consultant will design and deliver high quality BI reporting to support key reporting and management information requirements for our clients across the Legal Sector. The role will work closely with Legal, Legal Operations and Technology teams to improve data insight, efficiency and decision making across the Legal function.

What You Will Do

• Develop and maintain Power BI dashboards and reports as scoped for client delivery
• Design semantic models, DAX measures, and data transformations to support accurate and scalable analytics
• Build and support Power Automate workflows to automate Legal processes and approvals for our clients that drive efficiencies
• Translate Legal business requirements into effective BI and workflow solutions
• Ensure solutions comply with data governance, security, confidentiality and regulatory requirements
• Produce clear documentation and support ongoing enhancements and change requests

What You Will Have

Essential

• Demonstrable experience as a BI Developer
• Advanced expertise in Power BI (data modelling, DAX, Power Query)
• Strong hands on experience with Power Automate and workflow design
• Experience in the Legal sector or a similarly regulated environment
• Strong stakeholder engagement and requirements gathering skills

Desirable

• Experience integrating reporting with Legal systems and Microsoft 365
• SQL and relational database experience
• Familiarity with Legal Operations or Legal MI frameworks

What We Do For You

Wellbeing that means something

• 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

Financial benefits that have your back

• 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

Grow your career with us

• SkillsHub learning platform with leadership pathways, future-manager training, and a huge online library
• Access to external training and apprenticeships

Making a Difference

• MatchIt!Fundraise for a cause close to your heart and OneAdvanced will match part of the funding
• Pennies from Heavendonate the pennies from your pay check to help make a difference without lifting a finger

Plus plenty other flexible benefits to suit your lifestyle on our RewardHub, including:

• ULEV car scheme with 1,000+ models
• Dental insurance, Health Cash Plan, Critical Illness Cover, Partner Life Cover