The latest managerial appointment in the Championship has been confirmed