The last two were Principal Private Secretaries to Johnson and Blair, who appointed them in turn to the role. We didn’t actually have one at all between 2012 and 2020.
The guy resigning today was described on the news as “the top civil servant” or “head of the civil service”. I’m thinking of the top mandarin, whatever the arrangement.