I just stumbled upon this 2 years old question searching for something else but for whom it may concern there are couple of things that can be immediately identified as weird:
1. These 2 lines will never get executed because they are after the return
call:
wp_reset_query();
restore_current_blog();
2. The name of the function in the add_filter
call is staffMemberProfilesQuery
while the name of the function defined at the beginning of the code block is MemberProfilesQuery