I think you mean that the most sought-after employees work in jobs that appeal to the least amount of people.

Surely if the job doesn't appeal to many people, it is an oxymoron to say it is the most sought-after job.