Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop BI solutions to enhance business performance and reporting.
- Company: Join Capita Pensions Solutions, a leading UK pension firm with a collaborative culture.
- Benefits: Flexible working, competitive salary, company matched pension, and generous parental leave.
- Why this job: Make a real impact by driving data insights in a fast-paced environment.
- Qualifications: Advanced Power BI and Excel skills, strong analytical abilities, and excellent communication.
- Other info: Opportunity for career growth in a supportive and inclusive workplace.
The predicted salary is between 28800 - 43200 ÂŁ per year.
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.
Please note that 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.
What you\’ll be doing:
- Design, development, and deployment of Operational BI solutions.
- Production of regular and ad-hoc BI for 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, be able to confidently use techniques such as Pivot Tables and Charts, VLOOKUP, Advanced Formulae, 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.
This role requires enhanced security clearance, the details of which are contained in the following link. One of the main factors is a minimum 5 years UK residency – please only apply if you have this.
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 one of the UK\’s leading pension firms. We provide an unrivalled breath 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 believe in offering flexible working solutions that suit your needs, whether that\’s from home, 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 plenty 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 want everyone to have the best chance of succeeding as they move through their application and start their career with us. We are an equal opportunity and Disability Confident employer, we want to hear from you if you\’d like to discuss any adjustments you might need during your recruitment process. Please email reasonableadjustments@capita.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. Also 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. If you require this support you can apply for this support at https://www.gov.uk/guidance/apply-for-communication-support-at-a-job-interview-if-you-have-a-disability-or-health-condition-access-to-work.
Business Intelligence Analyst employer: Capita
Contact Detail:
Capita Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Business Intelligence Analyst
✨Tip Number 1
Network like a pro! Reach out to current employees at Capita Pensions Solutions on LinkedIn. Ask them about their experiences and any tips they might have for landing the Business Intelligence Analyst role. Personal connections can make a huge difference!
✨Tip Number 2
Prepare for the interview by brushing up on your Power BI skills. Be ready to showcase your knowledge of SQL, DAX, and Excel during the interview. Maybe even create a sample dashboard to demonstrate your abilities—show them what you can do!
✨Tip Number 3
Don’t forget to highlight your communication skills! As a Business Intelligence Analyst, you'll need to present data insights clearly. Practice explaining complex data in simple terms, so you can impress the interviewers with your ability to convey information effectively.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen. Plus, it shows you're genuinely interested in joining Capita Pensions Solutions. Don’t miss out on this opportunity—hit that 'Apply now' button!
We think you need these skills to ace Business Intelligence Analyst
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Power BI, SQL, and Excel. We want to see how your skills align with the role of Business Intelligence Analyst, so don’t hold back on showcasing your relevant achievements!
Show Off Your Communication Skills: Since this role involves liaising with various business areas, it’s crucial to demonstrate your excellent communication skills. Use your application to illustrate how you've effectively presented data insights or collaborated with teams in the past.
Be Clear and Concise: When filling out your application, keep your language clear and to the point. We appreciate straightforwardness, so avoid jargon unless it’s relevant to the role. This will help us understand your qualifications quickly!
Apply Through Our Website: Don’t forget to hit that 'Apply now' button on our website! It’s the best way for us to receive your application and get to know you better. Plus, it ensures you’re considered for this exciting opportunity right away!
How to prepare for a job interview at Capita
✨Know Your BI Tools Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss how you've used Power BI to create datasets, configure gateways, and standardise reports. Having specific examples of your work will show that you're not just familiar with the tools, but that you can leverage them effectively.
✨Showcase Your Analytical Skills
Prepare to demonstrate your analytical prowess by discussing past experiences where you've conducted root cause analysis or produced insightful reports. Think about how you can explain your thought process and the impact your analyses had on decision-making within the business.
✨Communicate Clearly and Confidently
Since this role involves presenting information to various levels of management, practice articulating your thoughts clearly. You might want to prepare a mini-presentation on a BI project you've worked on, highlighting your communication style and ability to engage stakeholders.
✨Be Ready for Flexibility Questions
Given the hybrid working model, be prepared to discuss your flexibility regarding office attendance. Think about how you can balance home and office work effectively, and be ready to share your thoughts on how this arrangement can benefit both you and the company.