This is a big part of my role as a Concept Artist in film. Once a design is approved, the production process starts. My job is to paint over our 3d assets and renders to help bring them closer to a realistic look.
We also need to concept the look of an effect. Have a look at the blood passes to get an idea of what I mean.
Hope this helps with getting an idea of what the job is like!