The mixed jobs picture reflects surging demand for people in healthcare and social services but a bleaker environment for government employees, factory workers and cubicle dwellers