Pensions Data Developer - Remote (London)

Sammons Group; Greater London; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

Sammons Group in London is seeking a Pensions Developer to design, configure and support software and data systems across the business. You will analyse data with SQL Server, write efficient queries and collaborate with business analysts on IT projects, translating requirements into robust software solutions.

You will maintain documentation, ensure security and regulatory compliance, and contribute to data mapping for IntelliPen and related interfaces.

Qualifications

• Technical experience in a SQL database development environment with a proven understanding of relational databases.
• Experience coding SQL queries and working with data. Able to demonstrate a working knowledge of the language, specifically complex select and update queries and a desire to continue learning.
• Some experience with one or all of the following: XML , VB.net, VBA, XSLT, HTML.
• Strong MS Office skills, particularly Excel.
• Strong analytical and problem solving skills.

Responsibilities

• Write and understand Microsoft SQL. Writing SQL select and update statements, stored procedures and views using industry best practices for security and efficiency.
• Development of required data conversion routines. Planning how work is to be carried out to meet targets of the project or team task.
• Produce software assets in adherence to standards. Work with business analysts and system users to develop solutions that support the intended purpose.
• Mapping data feeds into IntelliPen system which will include the use of IntelliFeed and SQL to interrogate, understand and document the required data to map.
• Develop solutions according to the brief and technical specifications. Work closely with other developers to integrate the applications according to standards and processes.
• Ensure all developments are fully documented, meet high level design requirements e.g. data, customer experience, architecture, security, quality and operations, as well as regulatory and industry standards so projects are fit for purpose leaving testing and transitioning to live.
• Ensure all new developments go through an appropriate testing process and have solid release plans for hand-over to live operation.
• Maintenance of IntelliPen System including database updates, extracts, reporting, issue resolution and change request testing.
• Perform coding or system configuration to written technical specifications, becoming a specialist in the development of; Calculations, Workflows, Data reports, Document Production and Interfaces.
• Work within a professional, influential and proactive development team that tangibly adds value.

Skills

SQL

XML

VB.NET

VBA

XSLT

HTML

Excel

Relational DBs

Tools

IntelliPen

IntelliFeed

SQL Server

Job description

Sammons Group in London is seeking a Pensions Developer to design, configure and support software and data systems across the business. You will analyse data with SQL Server, write efficient queries and collaborate with business analysts on IT projects, translating requirements into robust software solutions.

You will maintain documentation, ensure security and regulatory compliance, and contribute to data mapping for IntelliPen and related interfaces.