Finding all employees of a certain company

Option 1

Do one regex query over linkedin_profile.org and/or linkedin_profile.title and compare text. These columns are always extracted from the profile's current position which in turn is stored in linkedin_profile_position2. 

• PRO: Fastest way to find current employees, as good as your regex. 
• CON: People can have multiple active positions but only one will be visible here.

Option 2

Query linkedin_profile_position2 

• PRO: Lets us look back at historical records and discover trends 
• PRO: Shows multiple active position for the same person 
• CON: Slow