As the U.S. job market cools, AI prompt engineers are in hot demand, commanding six-figure salaries and fierce employer competition.