Data & Automation Analyst

Broadstone have an exciting opportunity for a Data & Automation Analyst to join their team.

Location: Glasgow, London or Sheffield

Who are we? Broadstone is a thriving consultancy offering a wide range of services in pensions, investments, and employee benefits. Established in 1989, the business has grown from a small team to a workforce of around 800, brought together by a desire to provide a personal, expert service to all who put their faith in us. We take pride in assisting small and medium sized pension schemes that lack the time or resources to address increasingly challenging issues themselves.

Our values are at the heart of everything we do and drive us forward every day. We strive to attract, develop, and retain high‑quality talent to work together to provide the best possible client outcomes. Our team feels empowered to share ideas to continuously improve our business. The impressive results of both client and staff surveys are a source of great pride.

Broadstone promotes an inclusive working environment and recruitment process, valuing diversity, equity and inclusion based on age, background, disability, gender, gender identity, gender expression, race, religion or sexual orientation. Please let us know if you require reasonable adjustments.

We operate out of 12 regional hubs stretching from London to Glasgow.

Broadstone is seeking a technically skilled and proactive Data & Automation Analyst to join our Business Solutions team, dedicated to supporting the Employee Benefits division. This role is pivotal in maintaining and enhancing existing data analysis models and applications, while contributing to innovative projects that leverage AI and automation to transform our data capabilities.

• Maintaining and improving Excel‑based models
• Supporting and developing on existing Python‑based applications
• Actively working on a major AI/automation initiative aimed at advancing data and analytics strategy

• Previous experience using AI technologies to extract and standardise data
• Advanced Excel skills (including VBA and Power Query)
• Strong academic background within a technical or analytical discipline
• Intermediate proficiency with Python, and willingness to develop further

• Competitive salary
• 25 days holiday plus bank holidays (with option of buying more)
• Private Medical Insurance
• Group Life Assurance
• Income Protection
• Generous pension scheme
• Health cash plan
• Additional optional benefits to best suit your lifestyle
• Social events
• Volunteering opportunities

To submit your application for this exciting Data & Automation Analyst opportunity, please click ‘Apply’ now!

If you are interested in this opportunity and wish to have a confidential conversation about the scope and expectations, please contact

Broadstone reserves the right to close our vacancies early and will endeavour to respond to all applicants. However, if for any reason you have not heard back within 28 days of applying, please assume that you have been unsuccessful on this occasion.