How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Data Architect – Full Time (Hybrid) | Railpen
About the Role
We are excited to offer an opportunity for a Data Architect to join our Data Architecture Technical Support Group (TSG). This is a full-time position with the flexibility of a hybrid working arrangement.
Who We Are
Railpen is responsible for safeguarding and investing around £34 billion in assets while administering multiple pension schemes, including the Railways Pension Scheme—one of the UK’s largest and longest-establishing pension funds.
With a heritage rooted in supporting the rail industry’s employees, Railpen takes a holistic approach to member care, balancing today’s needs with the future impact on their communities.
The Role
As the Data Architect, your core responsibilities will include:
- Providing architectural leadership across Railpen’s data ecosystem, ensuring alignment with Member Services, Finance, and Pension Investment Management (PIM).
- Defining and enforcing enterprise data standards, including modelling approaches, integration patterns, and platform design—to ensure scalable, secure, and AI-aligned solutions.
- Collaborating with investment stakeholders to translate business requirements into robust, scalable data models and platform architectures.
- Ensuring compliance and best practices in data integration (ETL/ELT), warehousing, and governance.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Important: This role is not eligible for visa sponsorship. Applicants must have the legal right to work in the UK.
The Person
We’re seeking a hands-on Data Architect with strong technical expertise and exceptional stakeholder engagement skills. Ideal candidates will have:
✅ Proven experience with:
- MS SQL Server 2016+ or similar modern data platforms, with preference for Microsoft Fabric
- Investment data management—familiarity with domains like securities, holdings, pricing, transactions, risk, performance, and reference data
- Data warehousing, BI/reporting, or ETL/ELT designs for operational and analytical use
- Data integration and platform architecture amid regulatory, compliance, and operational demands
✅ Technical Proficiency:
- Hands-on ability to develop scalable data solutions
- Knowledge of Azure Data Factory, Python, or other tools in the Microsoft data stack
✅ Soft Skills & Mindset:
- Ability to bridge technical and business needs, explaining complex ideas clearly
- Commitment to integrity, collaboration, and constructive challenge
- Open to feedback and thriving in environments that encourage innovation and continuous learning
Get help with your application
Your very own career expert that helps elevate your application to the next level.
What We Can Offer
Financial & Benefits
- Competitive salary
- 28 days’ annual leave (plus bank holidays)
- Generous annual bonus scheme
- Membership of the Railways Pension Scheme (Defined Contributions): lifetime pension and a retirement lump sum
- Life assurance cover
Wellbeing & Support
- Colleague referral scheme
- Employee Assistance Programme
- Cycle-to-work scheme, Electric Vehicle (EV) leasing, and Flu vaccination
- Paid volunteering days, Flexible Working Policy, and Eye Care vouchers
Next Steps & Commitment
- Application deadline: 5:00 PM (UK time), 14th July 2026
- Railpen is committed to inclusivity and diversity, fostering an environment that values different perspectives.
We understand that talent makes us excellent—The opportunity here isn’t just technical; it’s about driving mission-led change, learning from challenges, and being part of an innovative team that prioritises both member security and external impact.
If you’re passionate about data architecture, investment systems, and valuable growth, we’d love to hear from you.
Join us in shaping pensions for the future—smartly and sustainably.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location