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.