The table below looks at the statistics 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 December 2014 with a comparison to the same period in the previous 2 years.

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 Dec 2014
Same period 2013 Same period 2012
Snowflake Schema
Rank 577 570 551
Rank change year-on-year
-7 -19
Contract jobs citing Snowflake Schema 18 12 6
As % of all contract IT jobs located in the UK 0.033% 0.023% 0.012%
As % of the Database & Business Intelligence category 0.16% 0.10% 0.054%
Number of daily rates quoted 11 8 5
Average daily rate
Keep up to 90%
of your Daily Rate
Get a Free Illustration
£350 £425 £500
Average daily rate % change year-on-year
-17.64% -15.00%
90% offered a daily rate of more than £300 £375 £260
10% offered a daily rate of more than £645 £470 £545
UK excluding London average daily rate £350 £425 -
% change year-on-year
-17.64% -
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - - -

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in contract jobs advertised across the UK.

Database & Business Intelligence Category
UK
Contract IT job ads with a match in the
Database & Business Intelligence category
11571 11749 11016
As % of all contract IT jobs located in the UK 20.97% 22.77% 22.20%
Number of daily rates quoted 7713 7225 6675
Average daily rate £400 £388 £375
Average daily rate % change year-on-year
+3.22% +3.33%
90% offered a daily rate of more than £275 £263 £250
10% offered a daily rate of more than £550 £550 £550
UK excluding London average daily rate £363 £325 £330
% change year-on-year
+11.53% -1.51%
Number of hourly rates quoted 162 267 274
Average hourly rate £33.50 £28.00 £30.50
Average hourly rate % change year-on-year
+19.64% -8.19%
90% offered a hourly rate of more than £14.95 £14.00 £16.00
10% offered a hourly rate of more than £55.00 £46.10 £45.00
UK excluding London average hourly rate £35.00 £28.00 £30.50
% change year-on-year
+25.00% -8.19%

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 in the UK

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 in the UK

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 December 2014.

Snowflake Schema Daily Rate Histogram in the UK

Snowflake Schema
Top 14 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 December 2014. 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
(Use links below to see detailed
statistics and historical trends)
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
Live
Job
Vacancies
England -24 18 £350 -17.64% 1
East of England - 9 £333 - 1
Hertfordshire - 9 £333 - 1
St Albans - 8 £350 -
London +19 6 £375 -21.05%
South East - 2 £425 -
Hampshire - 1 £425 -
Nottinghamshire - - - -
East Midlands - - - -
Nottingham - - - -
Southampton - - - -
Edgware - - - -
Glasgow - - - -
Scotland - - - -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 19 December 2014, 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 26 (96.30%) Data Warehouse
2 24 (88.89%) SQL
3 18 (66.67%) Microsoft
4 17 (62.96%) SQL Server
5 14 (51.85%) Performance Tuning
6 13 (48.15%) Finance
7 12 (44.44%) Analytics
8 11 (40.74%) Tableau
8 11 (40.74%) QlikView
8 11 (40.74%) Visualisation
8 11 (40.74%) MS Excel
9 10 (37.04%) ETL
9 10 (37.04%) T-SQL
10 9 (33.33%) Star Schema
11 8 (29.63%) Project Management
11 8 (29.63%) Requirements Analysis
11 8 (29.63%) QA
11 8 (29.63%) Test Strategy
12 7 (25.93%) SQL Server 2012
12 7 (25.93%) User Acceptance Testing
12 7 (25.93%) SQL Server Integration Services
12 7 (25.93%) Business Intelligence
12 7 (25.93%) Oracle
12 7 (25.93%) ERP
13 6 (22.22%) SAP
13 6 (22.22%) Oracle Financials
13 6 (22.22%) Change Management
13 6 (22.22%) Replication
13 6 (22.22%) Agile Software Development
13 6 (22.22%) Performance Monitoring

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 19 December 2014, 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.

Application Platforms
1 2 (7.41%) IIS
2 1 (3.70%) Apache Pig
Applications
1 11 (40.74%) MS Excel
2 3 (11.11%) MS Visio
3 1 (3.70%) PowerPivot
Business Applications
1 6 (22.22%) Oracle Financials
1 6 (22.22%) Oracle Payables
2 3 (11.11%) Dynamics NAV
Database & Business Intelligence
1 26 (96.30%) Data Warehouse
2 17 (62.96%) SQL Server
3 11 (40.74%) QlikView
4 9 (33.33%) Star Schema
5 7 (25.93%) SQL Server 2012
5 7 (25.93%) SQL Server Integration Services
6 4 (14.81%) Data Mart
6 4 (14.81%) SQL Server Analysis Services
7 2 (7.41%) SQL Server Reporting Services
7 2 (7.41%) Apache Hive
7 2 (7.41%) Hadoop
8 1 (3.70%) Big Data
8 1 (3.70%) Spotfire
8 1 (3.70%) Oracle BI EE
8 1 (3.70%) SQL Server 2008
8 1 (3.70%) Microsoft Analysis Services
8 1 (3.70%) PowerCenter
Development Applications
1 3 (11.11%) SQL Server Management Studio (SSMS)
2 2 (7.41%) Visual Studio
3 1 (3.70%) Team Foundation Server
3 1 (3.70%) ERwin
General
1 13 (48.15%) Finance
2 1 (3.70%) Banking
Job Titles
1 15 (55.56%) Developer
2 8 (29.63%) SQL Developer
3 7 (25.93%) Team Leader
3 7 (25.93%) DBA
4 5 (18.52%) SQL DBA
5 2 (7.41%) Development Team Leader
5 2 (7.41%) Data Warehouse Developer
5 2 (7.41%) Senior DBA
5 2 (7.41%) Excel Developer
5 2 (7.41%) Hadoop Developer
6 1 (3.70%) Senior Data Modeller
6 1 (3.70%) Business Intelligence Developer
6 1 (3.70%) Developer Analyst
6 1 (3.70%) Data Consultant
6 1 (3.70%) Data Modeller
6 1 (3.70%) Data Warehouse Consultant
6 1 (3.70%) Technical Analyst
6 1 (3.70%) Analyst Developer
6 1 (3.70%) Architect
6 1 (3.70%) Analyst
Libraries, Frameworks & Software Standards
1 3 (11.11%) .NET
2 2 (7.41%) HTML
2 2 (7.41%) Microsoft Enterprise Library
2 2 (7.41%) HTML5
2 2 (7.41%) Kendo UI
3 1 (3.70%) jQuery
3 1 (3.70%) XML
Miscellaneous
1 11 (40.74%) Visualisation
2 6 (22.22%) Replication
3 3 (11.11%) Management Information System
4 2 (7.41%) Analytical Skills
5 1 (3.70%) Enterprise Software
5 1 (3.70%) Data Integration
5 1 (3.70%) Derivative
Operating Systems
1 1 (3.70%) Windows
Processes & Methodologies
1 14 (51.85%) Performance Tuning
2 12 (44.44%) Analytics
3 10 (37.04%) ETL
4 8 (29.63%) Project Management
4 8 (29.63%) Requirements Analysis
4 8 (29.63%) Test Strategy
5 7 (25.93%) User Acceptance Testing
5 7 (25.93%) Business Intelligence
5 7 (25.93%) ERP
6 6 (22.22%) Change Management
6 6 (22.22%) Agile Software Development
6 6 (22.22%) Performance Monitoring
6 6 (22.22%) Coaching
7 5 (18.52%) Database Security
8 4 (14.81%) Kimball Methodology
9 3 (11.11%) CRM
10 2 (7.41%) Data Modelling
10 2 (7.41%) Migration
10 2 (7.41%) Stakeholder Management
10 2 (7.41%) Data Analysis
Programming Languages
1 24 (88.89%) SQL
2 10 (37.04%) T-SQL
3 5 (18.52%) C#
4 2 (7.41%) Shell Script
4 2 (7.41%) VB.NET
Quality Assurance & Compliance
1 8 (29.63%) QA
2 1 (3.70%) Solvency II
2 1 (3.70%) Data Quality
Vendors
1 18 (66.67%) Microsoft
2 11 (40.74%) Tableau
3 7 (25.93%) Oracle
4 6 (22.22%) SAP
5 5 (18.52%) Red Gate
5 5 (18.52%) Informatica
6 3 (11.11%) Salesforce.com
7 2 (7.41%) Telerik
7 2 (7.41%) Cloudera
8 1 (3.70%) Hortonworks
8 1 (3.70%) Business Objects