Job market for sql server 2000/2005 Data warehousing/Business Intellgence developer

Posted on 2006-04-01
Medium Priority
Last Modified: 2012-06-22
How is the job market for a SQL server 2000/2005 data warehousing and Business intelligence developer (AS, MDX, SSIS,RS,..)?  Is it good skills to have? What would be the future of DW/BI market?
Question by:jung1975
LVL 28

Accepted Solution

imran_fast earned 172 total points
ID: 16353554
Is it good skills to have?
After the relational store the first major component of the SQL Server 2005 platform is Integration Services.
Enterprise ETL platform
High performance
High scale
More trustworthy and reliable
Best in class usability
Rich development environment
Source control
Visual debugging of control flow and data
Great range of transforms out-of-the-box
Highly extensible
Custom tasks
Custom enumerations
Custom transformations
Custom data sources
LVL 13

Assisted Solution

MikeWalsh earned 164 total points
ID: 16354204
Jung - to answer your question more directly rather than a generalization of 2005 components.. Yes they are marketable skills. People are deploying BI databases with SQL, and even if they are using other DBMSs (like Oracle as we talked about in your last employment type question about which skills to have, and I said both if you can), SSIS in 2005 and DTS in 2000 are used for a lot of ETL processes.

I would say it is first good to have solid DBA skills in general, then SQL DBA skills and Database development skills, then add to that a solid understanding of AS and it's components including the tools (DTS and SSIS in 2005) used to get data into the warehouse. Having a degree based in Mathematics helps with the DW end of things.
LVL 11

Assisted Solution

by:Craig Yellick
Craig Yellick earned 164 total points
ID: 16355805
Microsoft bundles all of the BI/DW/OLAP and reporting tools into the base product price, which means anyone with an installation of SQL Server could potentially be in need of the services of such a developer. SQL Server does not (yet) dominate the market in terms of license dollars, but it does dominate the sheer number of installations.

Go to www.Dice.com and search on "microsoft sql server BI", as of this afternoon there were 95 listings.

From everything that I can see, BI in general and the Microsoft SQL Server platform in particular looks to be a good long-term career option.

-- Craig

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question