I'm not sure what it means. My boss says it all the time.
1) He says it about attractive women.
2) He says it about a retarded guy wearing a neon yellow reflective vest and riding a tricycle on the sidewalk.
1) Wooo, look at her. She's a piece of work.
2) Look at that guy. He's a piece of work isn't he?