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.