Most companies have lots of in-house tools and scripts they have written to help artists do their job. A company like Bungie will have people dedicated to working on tools for artists. The positions are called tech artist or tools programmer. Some companies have much better tools than others.