The new position, created by SFMoMA and the Museum of the African Diaspora, will involve the development of exhibitions and other programmes at both institutions