Business Intelligence Analyst

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.