this post was submitted on 19 Feb 2024
148 points (93.5% liked)
Asklemmy
43942 readers
522 users here now
A loosely moderated place to ask open-ended questions
Search asklemmy ๐
If your post meets the following criteria, it's welcome here!
- Open-ended question
- Not offensive: at this point, we do not have the bandwidth to moderate overtly political discussions. Assume best intent and be excellent to each other.
- Not regarding using or support for Lemmy: context, see the list of support communities and tools for finding communities below
- Not ad nauseam inducing: please make sure it is a question that would be new to most members
- An actual topic of discussion
Looking for support?
Looking for a community?
- Lemmyverse: community search
- sub.rehab: maps old subreddits to fediverse options, marks official as such
- !lemmy411@lemmy.ca: a community for finding communities
~Icon~ ~by~ ~@Double_A@discuss.tchncs.de~
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
It really depends on where you're coming from. I've known several people who made a rather successful transition from a more business oriented position to business intelligence. It's like data science's older and less sexy brother :) General domain knowledge of business processes and finances are always a positive and IT knowledge for a junior can consist of as little as SQL knowledge and experience with a reporting and ETL tool.
You don't get to do a lot of programming, but there's always demand for people capable of building a proper data warehouse or able to translate an information request in a properly build report. Internal positions are often an option because companies like to retain people with expert knowledge of the inner workings of their information systems.
Source: I used to be a BI specialist for ten years or so :)
Thanks for replying with valuable info!
What's the first step in this direction you'd recommend now?
Learn SQL and data modelling. The Data Warehouse Toolkit by Ralph Kimball is a good introduction to data warehouses and dimensional modelling. It's not a universal model for data warehouses, but the core concepts remain the same among different implementations. This should give you a good basic understanding of the basic concepts of data warehousing.
I know Reddit isn't exactly popular here, but their business intelligence community is quite active. It might be a good place to lurk and gain some insights.
Best of luck! :)
Thank you! Is SQL and data modelling the most in-demand IT-related thing I can learn these days to get employed remotely?
Oof, I wouldn't know about that. I was purely talking from personal experience. I don't have a good picture of the job market in total, let alone in whichever country you live. If you want to get into the data-related IT fields (data analist, data engineer, business intelligence specialist, etc.) then SQL and data modeling skills are a must-have. But it's just a small part of a much bigger discipline.
If possible, find some professional career counseling. Someone with better knowledge of the job market where you live might give you some good advice on which steps to take first.
I've been in search of a career counselor online but couldn't find anything worthwhile. Any advice on who I could talk to?
No, I'm sorry. I wish I could help but I'm a bit out of my depth with this one. You might try a local career counselor, but that really depends on where you live and who's available.
I wish you the best of luck though, I hope you'll find what you're looking for.
Actually a good piece of advice. Haven't thought of a career counselor before.