The ex-Manchester United striker has left his role with Sunderland’s Championship rivals