Data Analyst
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
Job description
We’re looking for a Data Analyst to join our Institutional Retirement Client Services team, supporting Pension Risk Transfer activity and the management of defined benefit pension scheme data.
You’ll work with member, benefit and liability data, making sure information is accurate, complete and ready to support transactions, administration and customer communications.
This is a hands-on analytical role where attention to detail really matters. You’ll investigate inconsistencies, reconcile complex datasets and help ensure colleagues and customers can have confidence in the information they’re using. You’ll also work with a broad range of teams across pensions, actuarial, operations, risk and change. What you’ll be doing:
- Analysing, cleansing, validating, transforming and reconciling pension scheme data
- Reviewing member, benefit and liability data against scheme rules and transaction requirements
- Investigating data anomalies and identifying root causes
- Translating stakeholder requirements into clear data specifications and practical solutions
- Producing management information and reporting on quality, risks, trends and performance
- Supporting accurate customer communications with reliable benefit information
- Testing and documenting data processes, calculations and transformations
- Maintaining clear audit trails and controls throughout the data lifecycle
Requirements
- Strong experience analysing and reconciling complex datasets
- Good understanding of UK defined benefit pension schemes
- Advanced Excel skills, including formulas, lookups, pivot tables and data validation
- Strong numerical reasoning and attention to detail
- Experience investigating data-quality issues and identifying root causes
- Confidence interpreting pension, member or benefit information
- Clear communication with both technical and non-technical stakeholders
- Ability to manage competing priorities while maintaining quality and accuracy
Direct Pension Risk Transfer experience, Power BI knowledge and a PMI or CII qualification would be useful.
Benefits & conditions
Whatever your role, we reward performance and behaviour with a package that looks after all the things that are important to you. Here are some of the benefits we offer:
- The opportunity to participate in our annual, performance -related bonus plan and valuable share schemes
- Generous pension contribution
- Life assurance
- Healthcare Plan (permanent employees only)
- At least 25 days holiday, plus public holidays, 26 days after 2 years’ service. There’s also the option to buy and sell holiday
- Competitive family leave
- Participate in our electric car scheme, which offers employees the option to hire a brand-new electric car through tax efficient salary sacrifice (permanent employees only)
- There are many discounts we offer - both for our own products and at a range of high street stores and online
- We’re creating net-zero carbon workplaces by 2030 by investing in our sustainable, modern offices across the UK, all designed to bring people together and elevate the in-person experience
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…