I'm currently working as a Data Analyst (10 years xp) where I do a lot of Data Visualization and PowerBI development but considering pursuing Software Development. I enjoy the technical aspects of the job: SQL, and in recent years Python, as Machine Learning becomes more prominent.
I write SQL queries for data retrieval, but also do a lot of query optimization on our existing code base, which could be considered more advanced SQL. With Python, I use it for Machine Learning, ETL tasks, and "gluing" different things together.
While I try as much as possible to follow professional development practices, e.g., clean code, source control, maintainability, etc., I lack real commercial experience in Software Development. What kinds of things can I highlight that would make me more attractive to a hiring manager? How do I overcome the lack of professional experience? Lastly, what would be a reasonable expectation of where to apply? Junior, Intermediate, Senior? Would love to hear from anyone who's made a transition from technical-but-not-so-technical role into Software Development. Thank you.