Flight Engineers are still required on 727s, 747 Classics (all except the -400), and DC-8s. In the US, most of these (except some 747s) are in cargo service.
Most US passenger airlines hire pilots as "Second Officers" to fly the FE seat. Some cargo carriers still hire Professional Flight Engineers; many of them come from the military.