Former HSBC banker John Goddard has been appointed chief executive at wealth manager Quilter's high net worth division Quilter Cheviot following regulatory approval.