Figured it out!
Created a new sheet with all Jobs listed (used a Unique function that combines and sorts the Jobs columns in the User Profile sheet ---- =sort(UNIQUE(PROPER({‘User Profile’!G2:G;‘User Profile’!H2:H})))).
This gives me a column I can use to create a relation from the array of job titles to the UNIQUE column in the Jobs sheet.
Once I have that relation done, I can add a Lookup in my other sheet that pulls in the Jobs Relation values.
It’s hard to explain but it works!