The Vacancy Our Third Party Administration (TPA) department is a dynamic administration team with a varied portfolio of clients. They play a key part in providing our clients and members with a market-leading service on Defined Benefits (DB), Defined Contribution (DC) and CARE pension arrangements. We currently have an exciting opportunity to join this department as an Administration Consulting Analyst, within our Data Journey team in our Edinburgh or Glasgow Office. The Data Journey Team lead on the delivery of pensions administration services and projects to our defined benefit and defined contribution clients. What will your role look like? You will play a significant role in the delivery of project work related to member tracing, marital status checks, backfile reviews, data cleansing, checking of dashboards and mail merge activities. You will also collaborate with other teams who we partner with to deliver work for our clients such as the risk transfer team, payroll and administration teams. Though this is a varied role, your key tasks will include: Under guidance from a more senior colleague, undertakes data analysis and projects in a timely and accurate manner. Assists with the production of reports, as and when required. Works closely with all teams to ensure work progresses seamlessly to completion Running of data extracts and analysis of the data, calculations and letters/reports for review by team members. Ensures office procedures are followed, including keeping full notes of all telephone conversations and being aware of compliance requirements. Carries out other tasks and ad-hoc projects as required. Responds to emails within delegated level of authority. Undertakes ad-hoc associated general administration duties, including mailing exercises and helpline duties. Supports other team members across all 4 offices as and when required. To enjoy and succeed in this role, you will have: Minimum GCSE / Scottish standard (or equivalent) Maths and English, or equivalent. Experience in an administrative or similar environment. Experience of DB pensions and previous project experience. Experience of collecting and inputting data/information. Good analytical skills. Excellent planning and organisational skills. Strong interpersonal and communication skills. Will benefit from having already worked as part of a team/with teams before. Able to communicate clearly and concisely both orally and in writing. Familiarity with Microsoft applications – Word Outlook and strong excel knowledge including experience of VLookup and pivot tables. 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.