Ok this is probably a stupid question but a hospital pharmacist works at a hospital right?

Yes, that is where he or she works as a pharmacist. If you Google the phrase "hospital pharmacist", you will get an detailed job description of this occupation.