Pensions Calculation Engineer | SQL & IntelliPen Expert

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

Job summary

Trafalgar House Pensions Administration is seeking a skilled Pensions Calculation Developer to design, configure and maintain the full suite of pensions calculation software. You will work across development, testing and deployment, ensuring compliance and quality while supporting system improvements.

You will analyse pension data using SQL Server tools, optimise stored procedures and scripts, and collaborate with cross-functional teams to deliver robust technical outputs for projects and

Qualifications

• Experience in pensions calculations within an administration or systems environment.
• Proven SQL and data analysis skills, with the ability to write secure and efficient code.
• Experience of working with IntelliPen, XML, VB.NET, VBA, XSL and HTML.
• Excellent MS Excel skills, particularly for modelling and testing.

Responsibilities

• Develop, configure and maintain all pensions calculation software to meet business and regulatory requirements.
• Produce, execute and document comprehensive system testing for all calculation changes and releases.
• Perform coding and system configuration tasks aligned to technical specifications.
• Maintain, enhance and support the IntelliPen system, ensuring stability and continuous improvement.
• Analyse, validate and manipulate pensions data using SQL Server tools and methodologies.
• Design, optimise and maintain secure SQL queries, stored procedures, views and scripts.
• Build and maintain data driven calculation routines and conversion processes.
• Collaborate with Calculation Analysts, Project Teams and Systems colleagues to translate business requirements into technical outputs.
• Contribute to project planning, effort estimation, solution design and integration activities.
• Support the delivery of new implementations, system upgrades and large-scale configuration changes.
• Ensure all developments adhere to design, documentation and quality assurance standards.
• Support release management processes, including acceptance testing, sign off and deployment activities.
• Maintain awareness of ISO2007 and contribute to compliance, resilience and business continuity practices.
• Provide responsive system support, troubleshooting and resolving issues, and report progress to stakeholders.

Skills

Pensions calculations

SQL and data analysis

IntelliPen experience

VB.NET

VBA

XML

XSL

HTML

Excel modelling

Tools

SQL Server

SQL Client Tools

Job description

Trafalgar House Pensions Administration is seeking a skilled Pensions Calculation Developer to design, configure and maintain the full suite of pensions calculation software. You will work across development, testing and deployment, ensuring compliance and quality while supporting system improvements.

You will analyse pension data using SQL Server tools, optimise stored procedures and scripts, and collaborate with cross-functional teams to deliver robust technical outputs for projects and