Pensions Implementation Consultants and Analysts

1. Pensions Implementation Analyst - Scheme Benefits 30-35k

• Lead client implementation projects
• Implement the products and services on our technology platforms
• Manage system configuration activities and quality
• Deliver tools to allow successful calculation automation and data migration
• Identify, troubleshoot and resolve client queries and issues
• Support Project Managers and Implementation Consultants through the efficient delivery of project tasks, 2. Implementation Consultant Level 2 Configuration- 35-40k
• Gather and interpret client requirements and processes, and translate these into system solutions
• Manage system configuration activities and quality
• Deliver calculation automation
• Risk and issue identification and mitigation
• Lead client implementation projects
• Facilitate internal and external system training, and provide appropriate documentation
• Troubleshoot and resolve client queries and issues

Essential Experience

• Strong DB Pensions experience
• Can draft an automated excel calculator with basic formula
• Demonstrate the ability to use filters, sorting, pivot tables (rows, columns, grouping, filters and totalling), lookups, control totals, IF and nested IF statements and formatting of cells to specific guidelines
• Describe the use of mixing range types on graphs to enable Supply and Demand to be represented graphically as Red, Amber or Green
• Able to manipulate data with exceptional data accuracy
• Can parse and import data/text files and use data validation
• Can create and run macros

3. Implementation Consultant Level 3 - Scheme Benefits - 40-47k

• Deputise for the Implementation Manager and act as an escalation point
• Review, interpret and identify project and process impacts as a result of changes to Pension legislation and technical guidance
• Lead client implementation projects
• Gather and interpret client requirements and processes, and translate these into system solutions
• Deliver tools to allow successful calculation automation and data migration
• Risk and issue identification and mitigation
• Facilitate internal and external system training, and provide appropriate documentation
• Identify, troubleshoot and resolve client queries and issues

Excel, DB Pensions

• 3 more

Please see below essential experience, as these roles are very data based please do not apply if you do not possess as a minimum very strong Excel Skills including Pivot table, filters, sorting, lookups, control totals, IF and nested IF statements., * Strong DB Pensions experience

• Can draft an excel calculator with basic formula
• Demonstrate the ability to use filters, sorting, lookups, control totals, IF and nested IF statements and formatting of cells to specific guidelines
• Can validate data with good data accuracy, * Can draft an excel calculator with basic formula
• Describe the use of mixing range types on graphs to enable Supply and Demand to be represented graphically as Red, Amber or Green
• Demonstrate the ability to use filters, sorting, lookups, control totals, IF and nested IF statements and formatting of cells to specific guidelines
• Can validate data with good exceptional accuracy
• Experience of handling sensitive client data
• Understanding GDPR and its role in this sector
• Follow all Information Security and GDPR policies and guidelines, * Excel
• pensions admin
• DB Pensions
• Pensions Implementation
• Pensions Data