Sunday, January 7, 2007

Surveying the BI Salary Surveys

Ever wonder if you are compensated appropriately for your work as a BI professional? Below is some salary information I've gleaned from various sites and consolidated for your convenience.

Computerworld's Smart Salary Tool 2006 shows Data Warehousing Managers at $116,452 in 2006, a 4.17% increase of 2005. Be wary, since the job description was a bit general: "Develops and implements information management strategies. Coordinates and manages information management solutions. Manages all aspects of the warehouses such as data sourcing, migration, quality, design and implementation." Another reason to be suspicious: the sample size is quite low (i.e., approximately 37.)

A few other outputs from this tool (salary + bonus):

  • Data Warehousing Managers: $116,452
  • Business intelligence analyst: $76,045
  • Database analyst*: $66,917
  • Database architect*: $105,088
  • Database developer/modeler*: $72,788
See this site for a summary table.

Certification Magazine also published a survey with 2006 salary information. Craig Mullens did a good job of summarizing the results in this post. Of note, certified DBA's came in with an average salary of $83,790. This ranged widely depending on the type of RDMS. For more information refer to Craig's post, the original article, or the summary jpg with results.

Of course, The Data Warehouse Institute (TDWI) does a very exhaustive annual salary survey for BI called "2006 TDWI Salary, Roles, AND Responsibility Report." Membership is required to view this. A few of the highlights (for year 2005):

  • BI director: $117,260 + average bonus of $20,104 received by 75%
  • Lead architect: $107,239 + average bonus of $12,517 received by 53%
  • BI tools manager/developer: $86,757 + average bonus of $9,059 received by 64%
  • ETL manager/developer: $79,937 + average bonus of $8,397 received by 55%
  • Data analyst/modeler: $80,130 + average bonus of $8,653 received by 57%
  • Technical architect/systems analyst: $80,984 + average bonus of 9,683 received by 52%
I highly recommend the TDWI report. It'd almost be worth the membership. It has a lot of detail, job descriptions, etc behind the numbers. Salary Center also does salary surveys. An analysis of the DW/BI-related provided the following (salary + bonus):

Thoughts? Any surveys or positions I missed?

* Indicates that these figures are not necessary related specifically to BI.


Friday, January 5, 2007

Articles/Blogs of the Week: 01/05/2007

Every week, we try to outline the best articles and blogs from the past week. Below are the articles/blogs for this week:

  • CDC without triggers, timestamps, or other source table modifications. This is a post by Milind Zodge that I think provides a unique approach to dealing with Change Data Capture (CDC).
  • 2007 Vital Signs Flat budgets and slow hiring are on tap for 2007, according to our quarterly survey of IT executives. Most interesting in this article is the impact of all things data throughout the statistics. Two of three "top priorities" were data related, as well as the #1 item listed under "Quick Hits. (Data management/business analytics)
  • Aetna to offer patients access to online data. If you're not in healthcare, don't read this article. I'll quote the most interesting / BI related item for your convenience: "An analytic engine developed by Aetna subsidiary ActiveHealth Management Inc. will analyze daily the information in [a database with patient data in it] and notify a patient if anything in the data falls out of line with commonly accepted best practices, said Robert Heyl, architect manager of Aetna’s E-Health business unit. For example, he said, if a physician prescribes a medication that would have an adverse reaction with medicine prescribed by another doctor, a patient would be called and e-mailed about the potential problem." That's cool. BI and Data Mining doing some serious good.

Thanks for your time.

Labels: ,

Monday, January 1, 2007

Stat of the Week: 1/1/2007

According to the book, The Search: How Google and Its Rivals Rewrote the Rules of Business and Transformed Our Culture, by John Battelle.

Google uses 175,000 computers to power its search engine.

It's no wonder. Google houses the text of nearly every site on the web. That's big. Now, consider response time of that giant database. For example, the query for business intelligence returns in 73 hundredths of a second. That's fast.

If Google can return queries against the entire World Wide Web in less than 1 second, surely the average Data Warehouse can perform better than it does. Though most of us do not have 175,000 computers at our disposal, we do have clustering, indexes, aggregate navigation, and other mechanisms that can substantially improve performance. "Too much data." can no longer be the response to "Why don't my query run faster?"