The softly spoken Yorkshireman has held ministerial roles across housing, local government, and the Treasury