I did a masters in data analytics, and then the niche I fell into in the working world was building dashboards, reports and spreadsheets of financial data for non-technical bureaucrats. Instead of ensuring data quality by technical means, my current company often just has me manually reviewing and checking financial data. This is pretty frustrating to me because I have no education in finance, and the things I miss or get wrong are so second nature to my boss that he doesn't even see them as something I should have been trained on. The only technologies I use are SQL server and excel. Any proactive steps I've made to automate processes has been discouraged as not worth the time.

I'm aware that most people spend years on tedious stuff before ever getting to work with more engaging technology, but honestly I'm starting to wonder if they've forgotten I'm not a finance guy. I want to move up in my career especially to escape my current role, but I'm feeling completely lost as to how. There's no obvious role in my company that could be a 'next rung of the ladder' to advance into, so there's nobody I can emulate to help chart a course. My boss had an unconventional path to his current role, and isn't really into manager stuff like career mentoring, so he's no help in that regard.

To anyone with experience in data science, what is the advancement supposed to look like? What are the key skills I should be developing? Am I being too averse to learning the subject matter of the data I'm working on? Any insight is appreciated!

I went to university for computer science up until the pandemic started. It was great. I remember working on so many projects that were basic but a lot of fun and others that were a lot more complex but still fun and rewarding. For example, one of the staples of beginner projects is Conway's Game of Life. I remember building that in HTML, CSS, and Java Script. One of my other favorite projects was a website for alum to visit to see alumni news and events, and also to lookup other alum.

What were your favorite projects when learning to code?