In case someone may need this in future.

I found a solution to my problem from this site https://www.simple-talk.com/sql/ssis/implementing-foreach-looping-logic-in-ssis-/.

A great article in there and I created a package based on it and it worked.

Just one thing though, when creating the JobTitle variable do not put the double quotes in the Value field, just leave the Value field blank.