This is a set expression that people say when someone returns to work from a vacation, sickness, etc.

People also use "good" and "great" instead of "nice":

It's great to have you back!

If someone doesn't usually work with you, but they are with you now, you can say a similar phrase:

It's nice to have you here.