Senior BI & Automation Consultant

Join One Advanced

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 the 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.

You will work end-to-end with clients, shaping requirements and delivering impactful BI and automation solutions.

• 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

Please note, applicants must have the legal right to work in the UK at the time of application.

You are confident working with stakeholders and delivering solutions, not just building reports.

• 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

Nice to have

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

#LI-RL1

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

• Skills Hub learning platform with leadership pathways, future‑manager training, and a huge online library
• Access to external training and apprenticeships

Making a Difference

• 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

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

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

At One Advanced, we are at the forefront of delivering sector-focused technology solutions that simplify complexity, drive meaningful progress, and help build a fairer, more inclusive society.

We’re much more than a software company. We deliver SaaS workflow applications and IT services that power organisations across Education, Government, Healthcare, Legal, Manufacturing, Housing, Retail, and more.

One Advanced is one of the UK’s largest business software and services…