It used to be simple.
We had a DBA and a Developer.
The DBA maintained the database. And the Developer wrote T-SQL and create reports.
And along came the Data Warehouse, which required a mix of table creation, writing queries to populate data known as ETL, and reporting / Dashboards.
This role became the Business Intelligence or Data Warehouse developer.
And then a distributed architecture was created, known as Hadoop, and some people dabbled there.
Then we had the ability to work in the Cloud, in the Microsoft world, Azure. This allowed for remote development, hybrid solutions as well as fault tolerant redundant backups as well as ability to scale on demand.
Along with other technologies like PowerShell, Service Broker, BIML, Mobile BI, PowerBI, Team Foundation Server, Machine Learning, DocumentDB database, Graph Database, and Artificial Intelligence.
So it's no wonder that many traditional Microsoft DBAs and Business Intelligence Developers have expanded into these new technologies.
We have dedicated conferences for Business Analytics now. And a plethora of Big Data and NoSQLDB conferences.
The world of data has splintered into many subtopics. To some degree, the traditional roles have been watered down. You can
still make a descent living, but the need to grow one's skill set is
increasing. Or get left behind.
And we're just talking about a specific vender here. There are dozens of venders each with their own flavors.
The world of technology is changing. Especially the world of Data. I would say it's very difficult to be great at everything, there's just too much to learn and it changes constantly.
Therefore, you have to take a reading of the current trends to see if they align with your current skill set. And then see if that's the direction you'd like to be in a few years and make the necessary adjustments.
It's not to say that any one technology is the best, because that will change over time.
One methodology is build upon your existing skill set, continually adding the technologies in demand.
Or you could side step completely into a new realm.
It basically comes down to each person's particular path and you get to decide which direction to take.
Traditional roles are feeling the pressure to adapt to survive. Our careers are like marathons. You don't want to waste all your energy on the first few miles. Save some for the rest of the journey. And make good decisions on how to structure your career so that you'll find work when the wind changes direction. And it changes quite often.