Pensions Implementation SQL Specialist

Trafalgar House

England

Presencial

GBP 60.000 - 90.000

Jornada completa

14 días+

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

Trafalgar House is seeking a Pensions Implementation Developer to configure and onboard new pension schemes onto our administration systems. The role focuses on SQL-based pension system implementation, including scheme configuration, data transformation, data mapping, calculations, interfaces, reporting and migration activities.

You will work with Business Analysts and pensions teams to translate requirements into robust, tested solutions.

Formación

  • Hands-on experience implementing or configuring a pensions administration platform.
  • Strong SQL Server development experience within a pensions implementation, configuration or migration environment.
  • 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.

Responsabilidades

  • Onboard and configure new client pension schemes onto pensions administration platforms.
  • Develop and maintain SQL-based implementation components including queries, stored procedures, views, data conversion routines and validation scripts.
  • Configure scheme-specific functionality including workflows, calculations, data structures, interfaces, extracts, reports and automated processes.
  • Support the onboarding of new pension schemes and clients, from initial analysis through configuration, testing, migration and go-live.
  • Where applicable, configure and develop solutions within IntelliPen, including data feeds using IntelliFeed and associated SQL components.
  • Understand the impact of configuration and data changes across the wider pensions administration environment.
  • Work with Project Managers to ensure key delivery deadlines are met.
  • Analyse source pension administration data and map it into target system structures.
  • Develop SQL routines for data extraction, transformation, cleansing, validation and loading.
  • Support data migration cycles including trial conversions, reconciliations and final production migrations.
  • Investigate and resolve data quality, mapping and reconciliation issues.
  • Develop and support interfaces between pensions administration systems and third-party or internal applications.
  • Produce clear data mapping, transformation and technical implementation documentation.
  • Write secure, maintainable and efficient SQL, including complex SELECT and UPDATE statements, stored procedures, functions and views.
  • Interrogate large pensions datasets to identify data issues, implementation defects and configuration problems.
  • Develop repeatable scripts and utilities to support implementation, migration, reconciliation and testing activities.
  • Ensure database changes are controlled, documented, peer reviewed where appropriate and capable of being deployed safely between environments.
  • Support system, integration, migration and user acceptance testing.
  • Develop SQL-based validation and reconciliation routines to demonstrate that data has been migrated and configured correctly.
  • Investigate defects identified during implementation and testing, determining whether they relate to data, configuration, system functionality or requirements.
  • Support test-loads and readiness activities prior to go-live.
  • Provide technical support during implementation and post-go-live stabilisation.
  • Ensure technical solutions meet agreed security, quality, architectural and operational standards.
  • Work closely with Business Analysts and Data Analysts to translate pensions administration requirements into technical implementation tasks.
  • Collaborate with pension administrators and subject matter experts to understand scheme requirements and administration processes.
  • Provide technical input into implementation planning, estimation and solution design.
  • Clearly communicate technical issues, dependencies and implementation risks.
  • Maintain accurate documentation and progress reporting throughout the implementation lifecycle.
  • Support effective handover of implemented schemes into BAU support and administration teams.
  • Identify opportunities to standardise and automate scheme implementation activities.
  • Develop reusable SQL scripts, templates and implementation components where appropriate.
  • Improve data migration, reconciliation and validation processes.
  • Contribute to the ongoing improvement of implementation standards, documentation and technical controls.

Conocimientos

SQL Server development
SQL queries & procedures
Pensions implementation
Data migration & mapping
Analytical problem-solving
Independent collaboration

Herramientas

IntelliPen
IntelliFeed

Descripción del empleo

Trafalgar House is seeking a Pensions Implementation Developer to configure and onboard new pension schemes onto our administration systems. The role focuses on SQL-based pension system implementation, including scheme configuration, data transformation, data mapping, calculations, interfaces, reporting and migration activities.

You will work with Business Analysts and pensions teams to translate requirements into robust, tested solutions.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Pensions Implementation Specialist (SQL & Data Migrations)
Pensions Implementation Specialist (SQL & Data Migrations)

Trafalgar House Pensions Administration • Greater London

Presencial
GBP 65.000 - 90.000
SQL Pensions Implementation Specialist
SQL Pensions Implementation Specialist

Trafalgar House • Greater London

Híbrido
GBP 70.000 - 100.000
Pensions Data & Systems Engineer
Pensions Data & Systems Engineer

Trafalgar House • Greater London

Presencial
GBP 40.000 - 65.000
Pensions Calculation Specialist
Pensions Calculation Specialist

Trafalgar House • England

Presencial
GBP 50.000 - 75.000
Pensions Implementation Developer
Pensions Implementation Developer

Trafalgar House Pensions Administration • Greater London

Presencial
GBP 65.000 - 90.000
Pensions Developer
Pensions Developer

Abenefit2u Limited • Greater London

Híbrido
GBP 40.000 - 75.000
Pensions Business Analyst – Change & Delivery
Pensions Business Analyst – Change & Delivery

Trafalgar House • England

Presencial
GBP 45.000 - 65.000
Pension Calculations Lead
Pension Calculations Lead

Trafalgar House Pensions Administration • Greater London

Presencial
GBP 40.000 - 56.000
Pensions Developer
Pensions Developer

Trafalgar House • Greater London

Presencial
GBP 40.000 - 65.000
Pensions Calculation Developer
Pensions Calculation Developer

Trafalgar House Pensions Administration • Greater London

Presencial
GBP 70.000 - 90.000