I worked two maybe three years doing just this. Hired into a non-IT department, tasked with others to script/automate the in-house ERP (Enterprise Resource Planning) system. We were able to increase the productivity of the department, tasks taking two weeks turning to an hour or less. However, honestly it was a house of cards because the automation we created could fail when the IT department changed the ERP system significantly.