Senior Pensions Technician

About the position We are looking for a Senior Pensions Technician to join the Consulting division of Capita Pension Solutions. We are a new force in the market and our fantastic team are aspiring to create better outcomes and bright futures by putting people and pensions at the heart of everything we do. The Consulting division was created to better enable us to fulfil the long-term strategic objectives of our business and to empower us to better excite our clients and provide them, and their members, with better outcomes. We are continuously looking to improve the services and products we provide to our clients, with a focus on people and the use of technology to achieve this goal. This positions us, and you, to be at the forefront of a rapidly growing and advancing organisation and industry. Responsibilities • To work individually and with the team to deliver requirements for projects (time scales, deliverables, quality, sign off) • To be responsible for the accuracy, delivery and quality of projects • Ownership of the full project life cycle • To lead on the delivery of assigned projects • To promote the provision of a first-class experience for customers and to share knowledge and expertise with other team members • Completing and documenting an analysis of existing scheme design and system builds to provide recommendations for improvements and define and design the solution • Working with relevant stakeholders both internally and externally to deliver the agreed solution • Running and specifying data extracts from the administration system including bespoke reports • Preparing and distributing communications • Transforming extracted data or data received into the required format and structure • Performing and specifying data uploads to the administration system • Building, enhancing and validating Proforma templates and specifying development of system automation • Testing bulk communications and calculations • Perform bulk calculations in Excel Requirements • DB pensions experience • Technical pensions calculations/analysis • Bulk data analysis/manipulation • Excel - Demonstrate the ability to use filters, sorting, pivot tables (rows, columns, grouping, filters and totalling) • Excel - use formulas including lookups, IF and nested IF statements, date calculations and formatting of cells to specific guidelines • Excel - import data/text files and use data validation • Project Management skills Nice-to-haves • GMP equalisation experience • PMI Qualification Benefits • 23 days' holiday (rising to 27) with the opportunity to buy extra leave • Company matched pension, life assurance, a cycle2work scheme, 15 weeks' fully paid maternity, adoption and shared parental leave, paternity pay of two weeks • Voluntary benefits designed to suit your lifestyle - from discounts on retail and socialising, to health & wellbeing, travel and technology • The opportunity to take a paid day out of the office, volunteering for our charity partners or a cause of your choice • Access to our Employee Network Groups, which represent every strand of diversity and allow colleagues to connect and learn from each other on an open, inclusive platform Apply tot his job