Horowitz's new position will see him increasing Sotheby's collaboration with galleries and art dealers