Pensions Calculation Developer

Trafalgar House

England

On-site

GBP 50,000 - 75,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Trafalgar House is seeking a Pensions Calculation Developer in the United Kingdom. You will develop, configure and maintain the pensions calculation software suite, ensuring accuracy and regulatory compliance. The role involves data analysis with SQL Server, building secure queries and maintaining IntelliPen systems.

You will collaborate with analysts and project teams, contribute to system testing, and support releases and continuous improvement initiatives in a fast-paced environment.

Qualifications

  • Strong technical 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 Intellicalcs, XML, VB.NET, VBA, XSL and HTML.
  • Excellent MS Office skills, particularly in Excel for modelling and testing.

Responsibilities

  • Develop, configure and maintain 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.
  • Collaborate with Calculation Analysts, Project Teams and Systems colleagues to translate requirements.
  • Support release management, including testing, sign-off and deployment activities.
  • Provide responsive system support, troubleshoot issues, and produce status reports for stakeholders.
  • Build relationships across teams and manage workload against competing priorities.

Skills

Pensions calculations
SQL
Data analysis
VB.NET
VBA
XSL
XML
HTML
SQL Server
Excel

Tools

SQL Server
VB.NET
VBA
XSL
XML
HTML
Excel

Job description

Main purpose of the role

The Pensions Calculation Developer plays a critical role in ensuring Trafalgar House delivers accurate, efficient and reliable pensions calculation software. This role is responsible for developing, configuring and maintaining the full suite of calculation functionality used across the organisation, supporting both day to day operations and long term system enhancements.

Key responsibilities
Technical Development & Application Support

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.

Data Analysis & SQL Development

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 to support projects and operational change.

Project Delivery & Cross Functional Collaboration

Collaborate closely with Calculation Analysts, Project Teams and Systems colleagues to translate business requirements into robust 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.

Quality Governance & Compliance

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.

Operational Support and Continuous Improvement

Provide responsive and proactive system support, troubleshooting and resolving issues in a timely manner.

Record technical activity, monitor progress and produce clear status reports for stakeholders.

Build and maintain strong working relationships across teams to support organisational goals.

Manage personal workload effectively, adapting to competing priorities and deadlines.

Professional qualities
Essential

Strong technical 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 Intellicalcs, XML, VB.NET, VBA, XSL and HTML.

Excellent MS Office skills, particularly in Excel for modelling and testing.

A highly analytical, motivated and detail oriented approach to work.

Flexible, adaptable and collaborative, with a strong team ethic.

Desirable

Knowledge of pension administration processes or payroll operations.

Experience delivering client implementations, system migrations or SQL driven projects.

Strong verbal and written communication skills, able to explain technical concepts clearly.

Ability to work effectively in a fast-paced, change focused environment

Personal qualities

Supportive, approachable and confident in decisions.

Organised and able to manage multiple priorities.

Calm under pressure and adaptable to change.

Promotes a positive, collaborative and inclusive team culture.

Reporting line

Pension Systems Manager

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Pensions Calculation Developer
Pensions Calculation Developer

Trafalgar House Pensions Administration • Greater London

On-site
GBP 70,000 - 90,000
Pensions Developer
Pensions Developer

Trafalgar House • Greater London

On-site
GBP 40,000 - 65,000
Pension Calculation Analyst
Pension Calculation Analyst

Trafalgar House Pensions Administration • Greater London

On-site
GBP 40,000 - 56,000
Pensions Implementation Developer
Pensions Implementation Developer

Trafalgar House • England

On-site
GBP 60,000 - 90,000
Pensions Implementation Developer
Pensions Implementation Developer

Trafalgar House • Greater London

Hybrid
GBP 70,000 - 100,000
Pensions Implementation Developer
Pensions Implementation Developer

Trafalgar House Pensions Administration • Greater London

On-site
GBP 65,000 - 90,000
Pensions Calculation Engineer | SQL & IntelliPen Expert
Pensions Calculation Engineer | SQL & IntelliPen Expert

Trafalgar House Pensions Administration • Greater London

On-site
GBP 70,000 - 90,000
Pensions Developer
Pensions Developer

Abenefit2u Limited • Greater London

Hybrid
GBP 40,000 - 75,000
Senior Pensions Calculation Analyst
Senior Pensions Calculation Analyst

ISIO • Birmingham

Hybrid
GBP 90,000 - 120,000
Salary and market-leading bonus scheme
Study support for professional quals
Training opportunities and career dev
+1
Senior Pensions Calculation Analyst
Senior Pensions Calculation Analyst

ISIO • Reading

Hybrid
GBP 70,000 - 100,000
Competitive salary + market-leading/tu
Study support for professional quals
Development and training opportunities
+1