The Grammy-winning percussionist is to take up the post at Robert Gordon University in Aberdeen.