r/analytics • u/Little-Mine-4234 • 4d ago

Question From low code etl dev to analytics

I am almost at a year at my company working on a low code etl tool. I’ve gotten to think a lot about what I want to do and where I want to be in my career and I was wondering where to start on how to transition into more of the analytics side of things. Currently in my job it’s essentially a graph based sql with the occasional query within each component. But it just doesn’t give me the satisfaction that I would get then if I were actually coding. I think some of the skills I learned can be transferable in some way but i would like to not do this for another year if I could. Any tips on how I can make a transition?

12 Upvotes

93% Upvoted

9 comments sorted by

•

u/AutoModerator 4d ago

If this post doesn't follow the rules or isn't flaired correctly, please report it to the mods. Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

7

u/Suitable-Page-8777 4d ago

The low code tools can feel like a cage after a while I get that. You already understand the logic of moving data around and that's the hard part honestly. The sql snippets you drop in those components are more valuable than you think, start building out full queries on your own time maybe with public datasets to get comfortable writing everything from scratch.

I was in similar spot last year and what clicked for me was rebuilding some of the workflows from my day job in pure python and sql just to prove I could. Put those on github even if they're messy and then start applying analytics roles that mention the sql skills you already have. Most teams just wanna see you can think through a problem from raw data to some kind of insight.

1

u/Little-Mine-4234 3d ago

Glad to hear someone else was in my position! Did you have to teach yourself any reporting tools power bi etc? Or did you mainly just refine SQL skills and started putting applications out?

1

u/my_peen_is_clean 4d ago

lean into the sql side first, that carries over the easiest build real queries, views, reports in something like postgres or sql server then start learning python, pandas, maybe dbt if you can, offer to help with internal reporting or ad hoc analysis where you work even small stuff the mix of sql + python + some viz tool is basically the entry ticket for a lot of analytics roles

1

u/Little-Mine-4234 3d ago

We do use a bit of pyspark in the google cloud cli, I’ve also done a project in the past using pandas, what reporting tools do you recommend? And outside of technologies is there anything I should focus on learning?

2

u/BillEnough7863 3d ago

The account you responded to is a bot:  https://www.reddit.com/r/analytics/s/VOH5v2qbte