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.
Business Intelligence Analyst
What You’ll Be Doing
* 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.
What We’re Looking For
* 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.
Security Clearance
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.
About Capita Pensions Solutions
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.
What We Can Offer You
* 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.
Equal Opportunity and Accessibility
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 reasonableadjustments@capita.com or call 07784 237318. 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.
Location
Liverpool, United Kingdom
Time Type
Full time
Contract Type
Permanent
#J-18808-Ljbffr