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

Posted on 2006-04-01
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

    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

    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

    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 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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    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…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now