I work in Chicago at JP Morgan in Operations. I have a BA in Economics from a Big 10 school. My title is "analytical project manager", so I do a bit of the below: Create reports via excel, SQL, tableau, qliksense Automate reporting, many times with vba Serve as the point of contact for software/user tool enhancements and changes Just overall find solutions and present strategies to address technical and reporting issues Any advice for what positions I may be a good fit at a tech company? Are there skills I should building outside of this roll to bring to another job? TC last year= 76K base + 6K bonus
How advanced is your SQL? Any python? If not may be hard to break into data science/analytics at a real tech firm. Should be easy to learn for u though......start using python to automate stuff instead of VBA. That way u can use it ok your resume.
Almost every business/finance person I've met who says they "know" SQL or even Python...it's super basic stuff. They love their Excel.
I can attest to this.....was exactly how all my old colleagues were at my first job out of college a long while ago.
It's true, finance loves excel. With SQL, I haved used it at work and practiced at home for the past year. Some of the harder stuff I can do would be multiple subqueries inside one outer query, recursive subqueries, joins on as many as 10 different tables, triggers...I have had to really just adapt it to replace legit reporting because we dont have nearly all the canned reports we need. I dont know know python but I'm more than willing to learn and start using it at work.
Learn python and hive/spark/big data SQL and you’ll have no problem getting analytics role, especially if in Bay Area. If not then may still have a hard time, as there are way less analytics roles at tech companies outside of Bay Area since there aren’t near as many tech companies in any other metro.
PM