Front Office Data Architect

Front Office SQL Architect

Intro

We have an incredible opportunity for a Front Office SQL Architect to join our Investments and Fiduciary Technology Software Development team on a permanent basis, based in the London office (hybrid working).

Who we are

Railpen is responsible for the safekeeping and investment of around £34 billion in assets and the administration of several pension schemes, including the Railways Pension Scheme, one of the UK's largest and longest established pension funds.

Our heritage of looking after the pension needs of the rail industry and its employees gives us our name and our unique outlook on how we serve our members. Railpen takes a holistic view, focusing on how we serve members today and how we can positively impact the communities and the world they will retire into.

To learn more about Railpen including our values, culture and purpose, visit our LinkedIn Life page here.   

The role

The core purpose of the Front Office SQL Architect role is to define, develop and support the systems needed by the Investment and Fiduciary teams. This role will be responsible for working with your team to coordinate the development of fit for purpose, bespoke front office solutions.

This role is not eligible for visa sponsorship. Applicants must have the legal right to work in the UK.

The person

The successful candidate will have significant MS SQL experience and exceptional analytical skills with proven experience of data modelling business solutions with MS SQL Server 2016 and above. Experience of data warehousing, ETL and data integration is key. You will have good expertise of the systems development life cycle and processes, as well as general programming concepts. The ability to troubleshoot database issues, be able to engineer, design and produce enterprise data engineering solutions will be key to delivery in this role. It would be an advantage if you had experience with either Python or C# and with Microsoft Azure, especially Data Factory, Synapse, and Microsoft Fabric, however this isn’t essential.

We are looking for someone with excellent communication skills to be able to define and convey technical expectations and project goals. You will have a real passion for all aspects of data engineering, staying up to date with the latest industry trends and technologies, and have a keen eye for detail and a collaborative working approach. The ideal candidate will be comfortable in working on multiple projects simultaneously, enjoy working independently and as part of a wider team. Attention to detail and a commitment to delivering high-quality work is fundamental to this role.

Our values of integrity, community and alignment are the guiding principles that influence our behaviour. They help us make decisions and shape our relationships with others. They’re what we stand for. You will actively demonstrate our values, helping to create a safe environment, to place the needs of the community above oneself and, through a culture of ‘fair challenge’, align to the best interests of our members. 

What we can offer you

Rewarding you

• A competitive salary

• 28 days annual leave plus bank holidays

• Generous annual bonus plan

• We provide membership of the Railways Pension Scheme, a Defined Benefit arrangement under which you get a pension for life and a lump sum when you retire, based on your length of service and pay

• 4x Life Assurance cover

• Colleague referral scheme

Heath & Wellbeing

• Employee assistance programme

• Heath cash plan

• Eye care vouchers

• Flu vaccination

Lifestyle

• We support hybrid and flexible working along with very generous family leave including 12 months full pay maternity leave and 6 months full pay paternity leave

• Buy and sell holidays

• Give as you earn scheme

• Paid volunteering days

• Flexible half days leave

• Electric vehicle leasing

• Cycle to work scheme

Next Steps

Please apply for the apply button or visit Careers Page by 5pm on 21st July 2025.

Railpen is committed to creating an inclusive and diverse environment, we value diversity and welcome people from all backgrounds and walks of life