Hymans Robertson LLP is seeking a skilled Data Analyst to join their Glasgow team in a hybrid capacity, with an expectation of two in-office days per week. This is an exciting opportunity for data professionals to work with large, complex datasets, providing insights that drive strategic decision-making within a reputable financial services firm.
The ideal candidate will hold a degree in a numerate discipline or have equivalent practical experience. Strong professional-level expertise in Python and SQL is essential, alongside experience validating, cleansing, and analysing complex datasets. The role also requires familiarity with ETL techniques and the ability to map and integrate data from multiple sources accurately.
This position offers the chance to work in a collaborative, hybrid environment while enhancing technical skills, contributing to impactful data-driven projects, and advancing a career within a respected and growing organisation in Glasgow.
Position: Data Analyst
Job Type: Full Time
Salary: Competitive
Location: Glasgow, Hybrid
The Vacancy
At Hymans Robertson, we’re passionate about delivering exceptional service to our clients and members. Our Digital Onboarding team plays a vital role in this by ensuring accurate, high‑quality data is at the heart of everything we do.
We’re looking for someone who enjoys working with data, solving problems, and making a real impact. You’ll be part of a team that onboards member data from Defined Benefit clients—either as part of a new Pensions Administration service or for short‑term project work.
If you’re detail‑oriented, proactive, and keen to grow your technical skills, this could be the perfect opportunity for you.
What will your role look like?
- The purpose of this role is to extract, analyse, transform and load data from a range of sources into our Pensions Administration System (UPM). You’ll work closely with colleagues and clients to ensure data integrity and smooth onboarding, following our agile ways of working and contributing to continuous improvement.
- You’ll also have the chance to develop your technical expertise, collaborate with a supportive team, and help shape best practices for data onboarding.
Though this is a varied role, your key tasks will include:
- Extracting, analysing, and transforming data from multiple sources ready for loading into UPM.
- Identifying, investigating, and resolving data issues, discrepancies, and risks.
- Ensuring data sets are complete, consistent, and accurate.
- Supporting client and project requirements, attending meetings as needed.
- Following the team’s onboarding lifecycle and agile delivery approach.
- Creating and maintaining internal documentation and helping embed best practices.
- Recording all work accurately and on time in our time‑tracking system.
To enjoy and succeed in this role, you will have:
- A degree in a numerate subject (or equivalent experience).
- Professional‑level skills in Python and SQL.
- Experience validating, cleansing, and analysing large, complex datasets and mapping data across different sources.
- Knowledge of ETL techniques and experience working with SQL databases, including developing automated scripts and reports.
- Familiarity with Microsoft tools, including Power BI, SQL Server Management Studio, and Azure Data & DevOps Suite.
- Excellent attention to detail and the ability to work quickly and accurately.
- Strong problem‑solving skills and a passion for finding creative solutions.
- Clear, concise communication skills, tailored to your audience.
- Ability to plan and organise workload effectively to meet client deadlines.
- A proactive, self‑starting attitude and the confidence to work independently.
- A collaborative approach—you’ll work closely with technical and non‑technical colleagues alike.
We would also encourage applications from candidates who perhaps do not possess all the attributes and experience listed above but are competent with the majority and would be able to quickly develop the additional skills and experience required in post with our full support. We would also love to hear about other knowledge and experience you may have that is not listed but could be of interest.
In addition to a competitive salary and access to our profit share scheme, we offer:
- A flexible selection of employee benefits, so you can choose a package that best matches your lifestyle and needs.
- A collaborative and encouraging work environment where your thinking and ideas are encouraged.
- On site mental health and wellbeing assistance.
- A commitment to helping you develop both personally and professionally, with mentoring opportunities and access to our award-winning learning portal, Aspire.
- Regular social activities, in addition to three days paid volunteering leave each year and a day’s leave to celebrate your birthday.
- Hybrid working so you can enjoy the positive wellbeing of working from home as well as the benefits of meeting colleagues in our sociable, modern office environments – with the expectation of two ‘in-office’ days per week.
- A flexible working window, allowing colleagues the freedom to work flexibly between the hours of 7am and 7pm.
Please note, we recruit on a rolling basis so early applications are recommended to avoid disappointment.
About Us
Together, we’ve been building better futures for over 100 years. For our people, our clients and their people, our communities and the environment.
We thrive on tackling complex problems. And we believe those problems are best solved by diverse teams – diverse in skills, approaches and backgrounds. Our independence lets our people be themselves and think freely, while working in a collaborative, supportive environment. We love innovative, independent thinking and want everyone to share their ideas.
Working alongside employers, trustees and financial services institutions, we offer pensions, investments, benefits and risk consulting services, as well as data and technology solutions. With over 1000 employees and counting, we’re one of the leading consultancies in our field and are proud to be recognised by numerous industry awards.
We’re committed to developing our people and encourage everyone to carve out their own career path. We’ve many colleagues who started out in one team in the business and have ended up somewhere completely different, having had the chance to develop new skills and explore new passions.
We are continually working to improve our inclusive culture and employ diverse talent. We therefore welcome applications from people from all backgrounds, which includes but isn’t limited to: age, disability, ethnic heritage, gender, marital or civil partnership status, neurodiversity, religion, sexual orientation, and socio-economic background.
Our hybrid working model offers the best of both worlds – home working as well as a fun, collaborative office environment – meaning flexible working patterns to accommodate individual needs. Find out more about our careers here.
If you need any assistance in relation to a personal requirement, medical condition or neurological difference during our selection process then please let us know.
Together, we can make this the best job you’ll ever have.
Application Process
Application Deadline
January 16th, 2026