Front Office Data Architect
London, United Kingdom
Railpen
Learn all about Railpen and how it delivers on its purpose to secure our members' future through award-winning investment management, ESG leadership and pension administration and communication services.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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Azure Data Warehousing Engineering ETL MS SQL Python SDLC SQL
Perks/benefits: Competitive pay Flex hours Parental leave Salary bonus
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.