You can use formula to extract the job titles.
IF(
OR(CONTAINS([Job Title], "Marketing"), CONTAINS([Job Title], "Brand"), CONTAINS([Job Title], "Growth")),
"Marketing",
IF(
OR(CONTAINS([Job Title], "Operations"), CONTAINS([Job Title], "Logistics"), CONTAINS([Job Title], "Supply Chain")),
"Operations",
"Other"
)
)
After categorization shift them into multiple tables