Business Intelligence Analyst

Capita; Manchester; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading pension firm in the UK is seeking a Business Intelligence Analyst to enhance its performance through data-driven insights. The ideal candidate will possess advanced Power BI and Excel skills, along with experience in Azure and strong analytical abilities. This role offers a hybrid working model with flexible attendance and various employee benefits, aiming to support success from the onset.

Benefits

Company matched pension

Life assurance

Fully paid maternity/adoption/shared parental leave

Qualifications

• 5 years of UK residency required.
• Experience with Power BI, Azure, and SQL-related tasks.
• Ability to present analysis effectively.

Responsibilities

• Design and develop Operational BI solutions.
• Produce regular and ad-hoc BI reports.
• Conduct root cause analysis.

Skills

Advanced Power BI skills

Advanced Excel skills

Azure skills

Excellent communication skills

Analytical skills

Job description

Overview

We have an exciting new opportunity within the fast-paced environment of Pensions Solutions in the role of Business Intelligence Analyst. You will enable the business to drive and improve its overall performance and help deliver its business plan objective. You will do this with 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.

Job title

Business Intelligence Analyst

What you’ll be doing

• Design, development, and deployment of Operational BI solutions.
• Production of regular and ad-hoc BI for the business area.
• Production of daily/weekly/monthly report package and supplemental reports.
• Provision of root cause analysis results to management.
• Regular reviews of reporting suite to ensure reports are fit for purpose.
• Liaise with other business areas from a data gathering/analysis perspective and provide support to 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).
  • Experience configuring Power BI Gateways, Dataflows and Power Query
  • Utilising Power BI Apps to present dashboards and reports.
  • Standardising reports across a business
  • Power BI Premium features such as pipelines and lifecycle management.
• Advanced Excel skills, including the ability to link to SQL data sources, confidently use Pivot Tables and Charts, VLOOKUP, Advanced Formulae, and the ability to write Macros / VBA.
• Azure skills, including but not limited to, query writing, including the use of Common Table Expressions, Union Queries, and ability to write and maintain Stored Procedures.
• Excellent communication, interpersonal skills, and confidence to present information to all levels of management within the company.
• Ability to analyse and draw conclusions from the data and present the analysis in an insightful way.
• Gathering and interpreting stakeholder requirements and excellent problem solving and analytical skills with a high level of attention to detail and accuracy.
• Maintenance of the current suite of business reports and Ad-hoc reporting for business managers.

Security clearance

This role requires enhanced security clearance. The details are contained in the government guidance pack for applicants. A minimum of 5 years UK residency is required. Please only apply if you meet this requirement.

About Capita Pensions Solutions

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

What can we offer you?

In this role, you would have the opportunity to add real value from the outset and support the success of the team. We also offer flexible working solutions that suit your needs, whether that’s from home or from your nearest Capita office.

• Company matched pension, life assurance, 15 weeks’ fully paid maternity, adoption and shared parental leave, paternity pay of two weeks, and more.

What we hope you’ll do next

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

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’d like to discuss any adjustments you might need during your recruitment process, please email reasonableadjustments at capita dot com or call 07784 237318 and we’ll get back to you to discuss. For more information about equal opportunities and the types of adjustments we can offer, please 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. If you require this support you can apply for it at the government site for communication support at a job interview via Access to Work.

#LI remote

Location

Liverpool, United Kingdom

Time Type

Full time

Contract Type

Permanent