This sounds almost exactly what happened to me and got me inspired to move into tech. I was working at an economic data company that had a bunch of grunts uploading publicly available data into our databases so our users could use it with our software. I figured out how to automate and simplify the some of the steps of the update process and shared it around with coworkers. I didn't get rewarded for it at all, then quit to do a coding bootcamp.
My advice: if the coding part is what you enjoy, pursue that. Go become a software engineer.
My advice: if the coding part is what you enjoy, pursue that. Go become a software engineer.