is it texturing or lighting/lookdev you want to do? Because after a model leaves a texture artists desk it doesn't look awesome. It looks all diffuse and has no shadows.

here is job posting for a texture artist.
https://www.cinesite.com/jobs/texture-artist