Pensions Implementation Specialist (SQL & Data Migrations)

Trafalgar House Pensions Administration; Greater London; On-site; GBP 65,000 - 90,000; Full time

Job summary

Trafalgar House Pensions Administration is seeking a Pensions Implementation Developer to configure and onboard new pension schemes on our administration platform. The role emphasizes SQL-based implementation, data transformation, mapping, and validation, with potential IntelliPen work.

You will collaborate with BAs and pension admins to translate requirements into robust, tested solutions, supporting migrations and go-lives across complex datasets.

Qualifications

• Hands-on experience implementing or configuring a pensions administration platform.
• Strong commercial SQL Server development experience within a pensions implementation, configuration or migration environment.
• Demonstrable experience using SQL to support the implementation or configuration of pension schemes.
• Strong SQL skills including complex queries, joins, data manipulation, stored procedures, views and data validation.
• Experience of pensions data migration, conversion, transformation or reconciliation.
• Good understanding of relational database structures and data dependencies.
• Experience translating business, pension scheme or functional requirements into technical solutions.
• Experience supporting testing and resolving defects during pensions system implementations.
• Strong analytical and problem-solving capability.
• High level of accuracy when working with complex pension scheme and member data.
• Ability to manage multiple implementation activities and priorities.
• Able to work independently while collaborating effectively with Business Analysts, developers, administrators and other stakeholders.

Responsibilities

• Pensions system implementation and onboarding of new client schemes onto administration platforms.
• Develop and maintain SQL-based implementation components including queries, stored procedures, views and data conversions.
• Configure scheme-specific functionality including workflows, data structures, interfaces, extracts and reports.
• Support onboarding from analysis through go-live and migration.
• Work with IntelliPen where applicable, including data feeds using IntelliFeed and SQL components.
• Translate scheme requirements into technical implementations and document changes.

Skills

SQL Server development

SQL queries

Data transformation

Data mapping

Data validation

Pensions data migration

Relational databases

Requirements translation

Testing support

Analytical thinking

Problem solving

Attention to detail

Independent working

Collaboration

Delivery-focused

Tools

IntelliPen

IntelliFeed

IntelliPen data mapping

Job description

Trafalgar House Pensions Administration is seeking a Pensions Implementation Developer to configure and onboard new pension schemes on our administration platform. The role emphasizes SQL-based implementation, data transformation, mapping, and validation, with potential IntelliPen work.

You will collaborate with BAs and pension admins to translate requirements into robust, tested solutions, supporting migrations and go-lives across complex datasets.