I just built a similar flow for someone this week. High level approach: find jobs table -> pull jobs (use filters to handle location and company size) -> use formula to fill job titles of desired leads -> plug into Apollo or find people native enrichment (or both, perhaps with a fallback) -> to actually find the most likely hiring manager the secret sauce is claygent -> write your people into another table -> run an email waterfall to get emails alongside their LI URL if desired -> happy prospecting