The chief marketing officer position is slowly losing its gloss. Tasked with building billion-dollar brands, marketing leaders often enjoy the job security of a freelancer.