• Expert
  An expert brings domain-specific knowledge to the table which the company does not possess.
• Facilitator
  A facilitator manages the processes required to effect change.
• Doctor
  A doctor's primary role is to diagnose problems and prescribe appropriate solutions.

Or to put it another way, one type of consultant explains the "what?", the second manages the "how?", and the third diagnoses the "why?".