The first table below looks at the demand for Snowflake Schema skills in IT contracts advertised across the UK. Included is a guide to the average contractor rates offered in IT contracts that have cited Snowflake Schema over the 3 months to 19 June 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

Location
3 months to
19 Jun 2013
Same period 2012 Same period 2011
Snowflake Schema
Rank 535 568 596
Rank change year-on-year
+33 +28
Contract jobs citing Snowflake Schema 6 2 5
As % of all contract IT jobs located in the UK 0.012% 0.003% 0.008%
As % of the Database & Business Intelligence category 0.061% 0.018% 0.039%
Number of daily rates quoted 3 2 2
Average daily rate £550 £398 £375
Average daily rate % change year-on-year
+38.36% +6.00%
UK excluding London average daily rate £350 £320 £325
% change year-on-year
+9.37% -1.53%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - - -
All Database & Business Intelligence
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
9914 11321 12918
As % of all contract IT jobs located in the UK 20.60% 19.51% 20.75%
Number of daily rates quoted 5926 6581 7327
Average daily rate £382 £375 £400
Average daily rate % change year-on-year
+1.86% -6.25%
90% offered a daily rate of more than £250 £250 £250
10% offered a daily rate of more than £550 £525 £550
UK excluding London average daily rate £330 £325 £330
% change year-on-year
+1.53% -1.51%
Number of hourly rates quoted 220 265 342
Average hourly rate £27.49 £26.00 £30.00
Average hourly rate % change year-on-year
+5.73% -13.33%
90% offered a hourly rate of more than £16.50 £14.06 £16.15
10% offered a hourly rate of more than £51.09 £43.50 £45.00
UK excluding London average hourly rate £27.50 £25.00 £31.00
% change year-on-year
+10.00% -19.35%

Snowflake Schema
Jobs Demand Trend

This chart provides the 3-month moving total of IT contractor jobs citing Snowflake Schema within the UK as a proportion of the total demand within the Database & Business Intelligence category.

Snowflake Schema Jobs Demand Trend

Snowflake Schema
Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Snowflake Schema within the UK.

Snowflake Schema Daily Rate Trend

Snowflake Schema
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Snowflake Schema within the UK over the 3 months to 19 June 2013.

Snowflake Schema Daily Rate Histogram

Snowflake Schema
Top 6 Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 19 June 2013. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Find
Job
Vacancies
England +17 6 £550 +38.36% 1
London +29 4 £550 +15.78%
Salisbury - - - -
Wiltshire - - - -
City of London - - - -
South West - - - -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 19 June 2013, IT contractor jobs within the UK citing Snowflake Schema also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Snowflake Schema.

1 6 (75.00%) SQL
2 4 (50.00%) T-SQL
2 4 (50.00%) Data Warehouse
2 4 (50.00%) ETL
2 4 (50.00%) Informatica
2 4 (50.00%) SQL Server Reporting Services
2 4 (50.00%) SQL Server Integration Services
2 4 (50.00%) SQL Server Analysis Services
3 3 (37.50%) Business Intelligence
3 3 (37.50%) Star Schema
3 3 (37.50%) Data Modelling
4 2 (25.00%) Oracle
4 2 (25.00%) SQL Server
4 2 (25.00%) SAP
4 2 (25.00%) Project Management
4 2 (25.00%) Change Management
4 2 (25.00%) Finance
4 2 (25.00%) Stakeholder Management
4 2 (25.00%) PL/SQL
4 2 (25.00%) PowerPivot
4 2 (25.00%) Performance Management
4 2 (25.00%) StreamInsight
4 2 (25.00%) Change Control
4 2 (25.00%) Derivative
4 2 (25.00%) Requirements Management
4 2 (25.00%) QlikView
4 2 (25.00%) Data Analysis
4 2 (25.00%) Kimball Methodology
4 2 (25.00%) Inmon Methodology
5 1 (12.50%) Data Quality

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 19 June 2013, IT contractor jobs within the UK citing Snowflake Schema also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Snowflake Schema. Up to 20 skills are shown per category.

Applications
1 2 (25.00%) PowerPivot
Database & Business Intelligence
1 4 (50.00%) Data Warehouse
1 4 (50.00%) SQL Server Reporting Services
1 4 (50.00%) SQL Server Integration Services
1 4 (50.00%) SQL Server Analysis Services
2 3 (37.50%) Star Schema
3 2 (25.00%) SQL Server
3 2 (25.00%) StreamInsight
3 2 (25.00%) QlikView
General
1 2 (25.00%) Finance
Job Titles
1 4 (50.00%) Developer
2 3 (37.50%) Data Warehouse Developer
3 2 (25.00%) Project Manager
4 1 (12.50%) Business Intelligence Developer
4 1 (12.50%) Oracle Data Warehouse Developer
4 1 (12.50%) Business Intelligence Manager
4 1 (12.50%) Business Intelligence Project Manager
4 1 (12.50%) Report Analyst
4 1 (12.50%) Oracle Developer
4 1 (12.50%) Analyst
Miscellaneous
1 2 (25.00%) Derivative
Processes & Methodologies
1 4 (50.00%) ETL
2 3 (37.50%) Business Intelligence
2 3 (37.50%) Data Modelling
3 2 (25.00%) Project Management
3 2 (25.00%) Change Management
3 2 (25.00%) Stakeholder Management
3 2 (25.00%) Performance Management
3 2 (25.00%) Change Control
3 2 (25.00%) Requirements Management
3 2 (25.00%) Data Analysis
3 2 (25.00%) Kimball Methodology
3 2 (25.00%) Inmon Methodology
4 1 (12.50%) Quality Management
Programming Languages
1 6 (75.00%) SQL
2 4 (50.00%) T-SQL
3 2 (25.00%) PL/SQL
Quality Assurance & Compliance
1 1 (12.50%) Data Quality
Vendors
1 4 (50.00%) Informatica
2 2 (25.00%) Oracle
2 2 (25.00%) SAP
Sunderland, North East
Oracle Data Warehouse Developer - Oracle / Informatica / ETL / PL/SQL - Sunderland - £350+Oracle Developer with excellent PL/SQL and ETL / Informatica skills required for an initial 3 month contract...
OPUS
Rate: GBP350 per day
Posted: 30 May 2013