Membership and Data Officer

Vacancy: Membership and Data Officer

Salary: £33,221

Location: Edinburgh

35 hours per week – permanent contract

The Royal College of Physicians of Edinburgh ("the College") seeks to appoint a Membership and Data Officer to provide data administration and membership services to the Colleges' growing membership and fellowship community and maintain and update the membership database to ensure data accuracy, relevance and quality. The post holder will operate in partnership with colleagues in the department and across-College, managing, recording, reporting and analysing large volumes of data.

The College is a professional membership organisation and registered charity, which supports the medical profession to deliver the gold standard in healthcare provision. We have a network of over 14,500 members worldwide and help hospital doctors throughout their careers through leading an effective and supportive physicians' community as well as providing our world-renowned education and training programme which helps qualified doctors pursue their careers in specialist medicine.

The Role

This is a role in the department of Global Engagement. Please refer to the Job Description for full details.

Key responsibilities include:

· Maintaining and updating the College's membership database and managing database information from stakeholders (including the GMC and JRCPTB).

· Generating reports and searches, for a range of College-wide business and analytical purposes (including analysing membership trends) and generating data and commentary for senior management reports, Council papers, etc.

· Playing a key role in Membership Enrolment and administration, creating data records and ensuring all new subscription information is uploaded on the College database timeously and accurately each year.

· Developing standard operation procedures to improve system efficiency, team productivity and performance.

· Finding and improving formats for entering data in the database to present information in a standardised way, to make searches easier and improve accuracy.

Person Specification

· Advanced IT skills including Word, Excel, and Outlook.

· Experience of using member databases.

· Knowledge of using survey and e-communication tools to create online surveys and mass emails.

· Ability to identify and clarify user requirements and present often complex data in a clearly understood format.

· An understanding and working knowledge of GDPR and appropriate data protection legislation.

· Knowledge of SQL to store, query, and manipulate relational data; experience of SQL clients (e.g. Enterprise Manager, Sybase Central) and data analysis tools such as Power BI.

· Experience in a membership or hospitality organisation, or an appropriate work environment that requires a high level of quality customer service delivered in an administrative capacity.

· Experience of handling large volumes of customer data and financial transactions.

· Exceptional levels of attention to detail, and an ability to respond immediately to changing demands.

· Strong team player that can operate with a friendly and inclusive approach.

· A general understanding of the UK Medical Training system, the related organisations, the various Royal Colleges and the roles they play and the qualifications which they confer.

Remuneration Package

The salary for this role will be £33,221 per annum plus benefits. Additional benefits include:

• Pension: with employer contributions of 9%.
• Holidays: 23 days' annual leave (with incremental increase over five years to 28 days) and 11 days' public holiday/College close downs.
• Life assurance scheme.
• Long-term income protection scheme for those unable to work due to illness.
• Cycle to Work scheme.
• Discounted rates for use of the venue for personal events.

To Apply:

Please go to our website for a full job description and further details.

Please note agencies need not apply.

Closing Date: 12pm Thursday 20th November 2025

Interviews: Monday 1st December 2025

Job Types: Full-time, Permanent

Pay: £33,221.00 per year

Benefits:

• Company pension

Work Location: Hybrid remote in Edinburgh EH2 1JQ

Application deadline: 20/11/2025