There are no dedicated ferry pilots anymore; FRC and DCMA pilots can get to ferry aircraft as a sideline to their primary duties, but unless the contract is written to say otherwise the Fleet has right of first refusal on who performs the ferry flight.
How to get a job like this??? You fail at everything else, but be a good stick and there's no RIF.
Unfortunately the days of being able to do that are mostly gone. But I bet a lot of folks on this board - if you could offer them the chance to take nothing but flying orders, never make ppts for the Man, and come home to their family every night unless they were on a cross country - would find plenty of "success" in a career like that.
Personally, I think senior officers owe it to JO's to explain to them early on what the Navy defines as success (first tour to FRS to Loop/Boat to DH to Staff to operational command, #1 every where you go, etc). But I also believe that JO's owe it to themselves to figure out what will constitute success in their career. For some people, going to sea as a CO in your 40's will represent reaching the pinnacle of their profession. Other people will look at that and say "no thanks".
[Note: while the old ADO community no longer exists (which probably populated a lot of those ferry squadrons and similar jobs), it can be made on your own - I know a couple of AEDO's that have avoided the cubicle in Pax and lived pretty large going from flying job to flying job. Some have avoided the IA turd as well,]