Overview

Capita Liverpool, United Kingdom. This role is within Pensions Solutions as a Business Intelligence Analyst. The role involves developing and delivering standardised management information to drive performance and support the business plan objectives. The position offers a mix of home and office-based working with attendance at the nearest Capita office (Liverpool or Cheadle) as required by business needs (1 to 5 days per week).

Responsibilities

• 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 packages 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 for data gathering/analysis and provide support to the Operations Management team.

What we’re looking for / Qualifications

• Advanced Power BI skills, including building Power BI datasets from data sources (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 linking to SQL data sources, Pivot Tables/Charts, VLOOKUP, Advanced Formulas, and the ability to write Macros/VBA.
• Azure skills, including query writing (CTEs, Union Queries) and ability to write/maintain Stored Procedures.
• Excellent communication, interpersonal skills, and the ability to present information to all levels of management.
• Ability to analyse data and present insights clearly; gathering/st interpreting stakeholder requirements; strong problem solving and attention to detail.
• Maintenance of current reports and ad-hoc reporting for business managers.
• Eligibility for enhanced security clearance (minimum 5 years UK residency).

Note: The security clearance requirement is detailed in the UK government guidance linked here: https://www.gov.uk/government/publications/united-kingdom-security-vetting-clearance-levels/sc-guidance-pack-for-applicants

About Capita Pensions Solutions

Capita Pension Solutions is a leading UK pensions firm providing services to over 600 schemes with more than 6 million members. The team delivers end-to-end solutions across pensions administration, data & remediation, software, actuarial, investment, scheme management, and member communications.

What we can offer

Opportunity to add value from the outset with flexible working arrangements (home and office). We offer a competitive package including company matching pension, life assurance, 15 weeks fully paid maternity/adoption/shared parental leave, and paternity pay.

Next steps

Click “Apply now” to complete the short application so we can learn more about you.

Capita is an equal opportunity and Disability Confident employer. We are committed to an inclusive recruitment process and working environment. If you need adjustments during recruitment, email reasonableadjustments@capita.com or call 07784 237318. For information about equal opportunities and adjustments, visit the Capita Careers site. Access to Work can assist candidates with health conditions or disabilities in obtaining support during the hiring process (including interview communication support). See gov.uk guidance on access to work for details.

Job details

• Seniority level: Associate
• Employment type: Full-time
• Job function: Analyst
• Industries: Financial Services and Outsourcing and Offshoring Consulting

Location notes: Chester, Ellesmere Port, Warrington, Wirral, Deeside, Northwich, Liverpool, Christleton, and surrounding areas often appear in postings.