I had a supervisor that took a risk and let me write some VBA scripts that would take some of the old outputs and get them into modern analysis software. We ended up revamping our process and being able to replace the old 1950s hardware simulator with an updatable modern digital workflow. My supervisor also handed some of his supervisory duties off to me, and I trained my team on the new process. We treated my code like a prototype for our in-house developer to use for a more robust system.
It was wonderful. This job had everything, great people, IO psychology, UI design, process improvement, code, data analysis.