Data Analyst, Community Pharmacy Scotland, Edinburgh

Data Analyst, Edinburgh

Job reference:

Pharmacy Name:
Contact Name: Michael Oswald
Contact Telephone: 01314663540

Data Analyst - Pharmacy Services Team

Salary circa £28k depending on experience

Community Pharmacy Scotland (CPS) represents the interests of over 1250 community pharmacy contractors in Scotland.  The organisation develops, supports and promotes the key role played by community pharmacy in meeting health needs of the Scottish population.  This post, which reports to the Head of Pharmacy Services, will be part of a small team that supports pharmacy contractors across Scotland.

Duties of the role include:

  • Using SQL server to extract accurate information within requested timescales
  • Present information in the required format
  • Model various financial scenarios for the distribution of pharmacy funding
  • ETL external data sources
  • Analysis of dispensing data to inform CPS policy decisions.

You should have a good working knowledge of SQL server or other relational database experience, have expertise in the use of Excel and either VBA, or C#.  You should have good organisational and communication skills.  Preferably educated to Degree level or equivalent as demonstrated by previous experience.

This is a full time post of 35 hours per week with 25 days holiday plus 9 public holidays. The package also offers flexitime, a non-contributory pension and a life assurance scheme.

For informal queries please contact Michael Oswald, Head of Pharmacy Services, on 0131 466 3540. To apply please fill out and send the application form and a CV to us at Community Pharmacy Scotland, 42 Queen Street, Edinburgh, EH2 3NH or e-mail:

Application Form
Job Description
Terms & Conditions