Data Solution Specialist - BPA

We’re looking for a Data Solutions Specialist with strong experience in data engineering and pensions data to help us shape better retirements across the UK. In our BPA Data team, you’ll play a key role in delivering scalable, high-quality data solutions that support BPA onboarding and ongoing scheme administration.

Job Type: Permanent

Location: This role could be based in our Edinburgh, Birmingham, Telford or London offices with time spent working from home and from the office.

Flexible working: All roles are open to part-time, job-share and other types of flexibility. We will discuss what is important to you and balancing this with business requirements during the recruitment process.

Salary and benefits: From £65k depending on experience plus bonus, private medical cover, 38 days annual leave, excellent pension, 12x salary life assurance, career breaks, income protection, 3x volunteering days and much more.

Who are we? We’re Standard Life, a retirement specialist focused entirely on retirement savings and income. We champion the belief that everyone’s journey to and through retirement can be better, and for more than 200 years, we’ve been helping our customers plan and prepare for their financial futures.

The role The Data Solutions Specialist – Annuities is a technically focused role responsible for designing, building, and enhancing data solutions that support the onboarding and ongoing servicing of Bulk Purchase Annuity (BPA) schemes. Working within the BPA Data team and in close partnership with Transformation, the role will develop scalable data models, tooling, and automation to improve the efficiency, control, and accuracy of pensions data processes.

Key Responsibilities:

• Design and deliver scalable data solutions, including data models, pipelines and tooling, translating business requirements into robust technical outputs using Python and SQL.
• Develop and automate data engineering processes, building efficient pipelines, optimising performance, and standardising reusable solutions across BPA schemes.
• Analyse and interpret DB pensions data, supporting data migration, mapping and transformation, and resolving complex data issues in line with scheme rules and calculations.
• Support transformation and change initiatives, collaborating with wider teams to enhance tooling, contribute to strategic data programmes, and embed best practice.
• Embed strong data quality, controls and governance, ensuring auditability, reconciliation, and alignment to regulatory and risk frameworks.
• Engage and collaborate with stakeholders, working across actuarial, operations and transition teams to deliver accurate, reliable and insight-led data outputs.

What are we looking for?

• Proven experience in Python and SQL, with the ability to design, build and optimise data pipelines and data models.
• Strong experience working with DB pensions data (BPA) including data mapping, migration and transformation activities.
• Experience implementing data validation, reconciliation and control processes to ensure data quality and accuracy.
• Proven experience working in project or Agile delivery environments, supporting the delivery of data solutions.
• Strong analytical skills, with experience interpreting complex datasets and resolving data issues.

We want to hire the whole version of you. We are committed to ensuring that everyone feels accepted and welcome applicants from all backgrounds. If your experience looks different from what we’ve advertised and you believe that you can bring value to the role, we’d love to hear from you. If you require any adjustments to the recruitment process, please let us know so we can help you to be at your best.