Normally, it would have a negative connotation. If you say someone is "opportunistic," it usually something like "sneaky" and "self-serving," like the person is looking for ways to build themselves up in the company, usually at the expense of others.
Example: Frank is really opportunistic. He is always looking for ways to kiss up to the boss.