Are trackers limited to Profiles in Safari

The answer to your question is yes. Each Safari Profile will retain information strictly limited to that Profile. However, Safari already limits the ability to use tracking cookies and similar browsing data effectively, making that technique a poor choice for anything that seeks to build an online profile of you for whatever purposes they may want to do that.

There is absolutely no way anyone should ever use a personal Mac for employer-related purposes. The potential for abuse and the personal consequences that can result are too great. If you are required to use Google products for your employment then use a different Mac — one that you do not use personally. Or, buy a Chromebook, a Windows PC, or something equally disposable. You'd be wasting money on a Mac, a product for which Apple has devoted considerable effort to protect your privacy.

I suggest that you decide at the outset whose Mac it is: yours, or your employer's. If it is your Mac, then it not your employer's, and it's certainly not Google's. Using their products will effectively surrender your personal sovereignty over to them.