Business Intelligence Analyst

We have an exciting new opportunity within the fast-paced environment of Capita Pensions Solutions. As a Business Intelligence Analyst, you will enable the business to drive and improve its overall performance and help deliver its business plan objectives through the development and delivery of standardised management information.

This role involves a combination of home and office-based working. You will need to be flexible and able to attend your nearest office—either Liverpool or Cheadle—as required. Office attendance may vary from 1 to 5 days per week, depending on business needs.

• Design, develop, and deploy operational BI solutions.
• Produce regular and ad‑hoc BI reports for business areas.
• Create daily, weekly, and monthly report packages and supplemental reports.
• Provide root‑cause analysis results to management.
• Review reporting suites to ensure reports are fit for purpose.
• Collaborate with other business areas from a data gathering/analysis perspective and support the Operations Management team.

• Advanced Power BI skills, including building Power BI datasets from specific data sources (mainly SQL, DAX, MDX), configuring Power BI Gateways and Dataflows, using Power Query, and standardising reports across a business.
• Experience utilising Power BI Apps to present dashboards and reports and working with Power BI Premium features such as pipelines and lifecycle management.
• Advanced Excel skills, including linking to SQL data sources, Pivot Tables, Charts, VLOOKUP, advanced formulas, and ability to write macros/VBA.
• Azure skills, including query writing with Common Table Expressions, Union Queries, and writing and maintaining stored procedures.
• Excellent communication, interpersonal skills, and confidence to present information to all levels of management.
• Strong analytical ability to interpret data, draw conclusions, and present insights.
• Proficiency in gathering and interpreting stakeholder requirements, with strong problem‑solving skills and high attention to detail.
• Experience maintaining current business reports and providing ad‑hoc reporting for business managers.

This role requires enhanced security clearance. One of the main factors is a minimum of 5 years UK residency. Detailed guidance can be found at Security Vetting Guidance.

Capita Pension Solutions is one of the UK’s leading pension firms, providing an unrivalled breadth of services to over 600 schemes covering more than 6 million members. Our team uses experience, insight, expertise, and the latest technology to deliver personalised, end‑to‑end solutions that meet all of our clients’ pension needs, including pensions administration, data & remediation solutions, software, actuarial services, investment, scheme management, and member communications.

• Company‑matched pension plan.
• Life assurance.
• 15 weeks of fully paid maternity, adoption, and shared parental leave.
• Two weeks of paternity pay.
• Flexible working solutions, including home and office options.
• And plenty more benefits.

At Capita, we’re committed to providing an inclusive, barrier‑free recruitment process and working environment for everyone. We are an equal opportunity and Disability Confident employer. If you would like to discuss adjustments you might need during your recruitment process, please email rea or call  For more information about equal opportunities and the types of adjustments we can offer, visit the Capita Careers website.

Access to Work can help candidates with a physical or mental health condition or disability to get support in the hiring process, including communication support at interviews such as a British Sign Language interpreter.

Choose “Apply now” to fill out our short application so that we can learn more about you.

Liverpool, United Kingdom

Full time

Permanent