Getting on with work colleagues and developing a career is more important than pay, according to new research.