I was actually neogtiating with my university-employer to _get_ such a job. Why you ask? Research is my thing, I can win grants which easily allow me to pay my own salary, hopefully til retirement. I just need the affiliation to be able to apply for many grants.
In my case the employer actually declined, because of the risks involved with German job security laws (it may have put me in a position to sue for a paid position after some time).