We’re looking for a Business Intelligence Analyst to join our Reporting & Insights team in Darlington on an 18-month fixed‑term contract, working hybrid. This is an exciting opportunity to play a key role in how Railpen understands and uses its data helping us deliver accurate, meaningful insight that supports strategic and operational decision‑making across the organisation.
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
In this role you’ll provide timely, accurate data to Member Services allowing for the delivery of business-critical insights for colleagues and senior leaders.
You’ll work across a mix of report development, data modelling and data engineering, using tools such as Power BI, Azure, SQL, Oracle. A significant part of your work will involve supporting our Azure Data Warehouse project: building and testing data flows, validating complex data sets, and helping to create a scalable, well‑structured data environment.
Key responsibilities include:
Producing and enhancing Power BI dashboards, visualisations and reports for BAU, risk, performance and committee use
Building and maintaining SQL tables, views and pipelines to support automated and reliable reporting
Investigating data inaccuracies, supporting data cleansing processes, and ensuring reporting is always based on trusted sources
Supporting the production of DC Committee, Trustee and DB quarterly reporting packs
Documenting business requirements and contributing to data mapping
Collaborating with internal teams and our external partner TCS to resolve data issues and continuously improve our reporting environment
This is a hands‑on role where you’ll balance technical delivery with stakeholder engagement, helping colleagues interpret data and understand the story behind it.
This role is not eligible for visa sponsorship. Applicants must have the legal right to work in the UK.
You’ll bring experience working in a BI Analyst, BI Developer or reporting‑focused data role, with confidence in handling large and complex datasets. You’re someone who enjoys understanding how data fits together, spotting issues before they become problems, and improving how information flows through an organisation.
We’re looking for:
Strong practical experience using Power BI, including data modelling and producing intuitive dashboards and reports
Solid knowledge of SQL (Azure SQL, Oracle SQL or similar), with the ability to build and test tables, views and scripts
Experience supporting or contributing to data warehouse or pipeline development
A structured approach to problem‑solving, with excellent attention to detail and a commitment to accuracy
Clear written and verbal communication skills, with the ability to explain data concepts to non‑technical stakeholders
A collaborative mindset, sharing best practice and working closely with colleagues and partners to deliver high‑quality reporting
An interest in automation, cloud technologies and continuous improvement will help you thrive in 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.
A competitive salary (depending on experience)
28 days annual leave, plus bank holidays
Defined Contribution pension
Employee assistance programme
Health cash plan
Eye care vouchers
Flu vaccination
Give as you earn scheme
Paid volunteering days
Please click apply or visit Careers by 5pm on Thursday 9th April 2026.
Railpen is committed to creating an inclusive and diverse environment, we value diversity and welcome people from all backgrounds and walks of life
