Definitely keep personal and work stuff separate. Doing otherwise might get you in trouble with your workplace. Credentials are absolutely sensitive so storing that in your personal device or personal cloud account can be a security risk, especially when it is mixed with your personal files.

I am currently using bitwarden but with 2 separate accounts and the work account is logged in a separate work profile. My personal account is not logged anywhere in work devices either. When I am switching jobs, I would probably mass delete everything without affecting my personal entries.

But coming to the actual autofill part, it is pretty much impossible to use 2 of them simultaneously as a service afaik. You can only keep 1 active and manually copy paste for the other. But if you are using the same app for both, bitwarden lets you log in 2 accounts but you still have to switch between the accounts for it to kick in. If you don’t care about security risks then you could use share functionality to share one account’s vault to the other and keep everything accessible with just 1 account but obviously not recommended.