If the task is both undesirable, difficult to find people to fill, and yet widely sought after and greatly needed, the word you're looking for is "lucrative."

Example: plumbers.

Excel wizards: quit your whining and go make bank.