The table below looks at the statistics for Snowflake Schema skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited Snowflake Schema over the 3 months to 22 February 2017 with a comparison to the same period over 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.

3 months to
22 Feb 2017
Same period 2016 Same period 2015
Snowflake Schema
UK
Rank 581 618 603
Rank change year-on-year
+37 -15
Contract jobs citing Snowflake Schema 13 11 13
As % of all contract IT jobs located in the UK 0.029% 0.021% 0.025%
As % of the Database & Business Intelligence category 0.13% 0.094% 0.11%
Number of daily rates quoted 10 8 6
Median daily rate £500 £394 £400
Median daily rate % change year-on-year
+26.98% -1.56%
90% offered a daily rate of more than £415 £268 £313
10% offered a daily rate of more than £510 £464 £645
UK excluding London median daily rate £500 £389 £388
% change year-on-year
+28.61% +0.32%
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median 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
10130 11652 11497
As % of all contract IT jobs located in the UK 22.33% 22.40% 22.27%
Number of daily rates quoted 6857 7834 7432
Median daily rate £438 £425 £400
Median daily rate % change year-on-year
+2.94% +6.25%
90% offered a daily rate of more than £300 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £375 £370
% change year-on-year
+6.66% +1.35%
Number of hourly rates quoted 138 212 159
Median hourly rate £36.25 £35.00 £30.00
Median hourly rate % change year-on-year
+3.57% +16.66%
90% offered a hourly rate of more than £12.50 £14.00 £15.00
10% offered a hourly rate of more than £44.00 £60.62 £55.00
UK excluding London median hourly rate £38.00 £32.50 £32.50
% change year-on-year
+16.92% -

Snowflake Schema
Jobs Demand Trend

The demand trend of contract jobs citing Snowflake Schema as a proportion of all IT contracts with a match in 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
Top 6 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 22 February 2017. 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 Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +46 13 £500 +26.98% 2
South East - 8 £500 -
Oxfordshire - 8 £500 -
London +21 5 £415 +5.39% 1
Oxford - 3 £510 -
City of London -2 2 £415 -10.27%

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 22 February 2017, IT contractor jobs citing Snowflake Schema also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for Snowflake Schema.

1 36 (94.74%) SQL Server
2 35 (92.11%) SQL
3 29 (76.32%) Migration
4 24 (63.16%) Data Analysis
5 22 (57.89%) ETL
5 22 (57.89%) Data Warehouse
6 18 (47.37%) Degree
7 17 (44.74%) Talend Open Studio
7 17 (44.74%) Talend
7 17 (44.74%) Windows
7 17 (44.74%) SQL Server Integration Services
8 16 (42.11%) Microsoft Analysis Services
8 16 (42.11%) SQL Server Analysis Services
9 15 (39.47%) QlikView
9 15 (39.47%) Hadoop
9 15 (39.47%) Big Data
9 15 (39.47%) Analytics
9 15 (39.47%) Banking
9 15 (39.47%) MS Excel
9 15 (39.47%) T-SQL
9 15 (39.47%) Microsoft
10 14 (36.84%) Shell Script
10 14 (36.84%) C#
10 14 (36.84%) Finance
10 14 (36.84%) Stakeholder Management
10 14 (36.84%) Risk Management
10 14 (36.84%) Retail
10 14 (36.84%) Retail Banking
10 14 (36.84%) Corporate Banking
10 14 (36.84%) SQL Server 2005

Snowflake Schema
Top Related IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 14 (36.84%) Apache Pig
2 8 (21.05%) Confluence
3 1 (2.63%) Apache Spark
Applications
1 15 (39.47%) MS Excel
Business Applications
1 1 (2.63%) Dynamics AX
Communications & Networking
1 11 (28.95%) Intranet
Database & Business Intelligence
1 36 (94.74%) SQL Server
2 22 (57.89%) Data Warehouse
3 17 (44.74%) SQL Server Integration Services
4 16 (42.11%) Microsoft Analysis Services
4 16 (42.11%) SQL Server Analysis Services
5 15 (39.47%) Big Data
5 15 (39.47%) Hadoop
5 15 (39.47%) QlikView
6 14 (36.84%) Apache Hive
6 14 (36.84%) SQL Server 2005
6 14 (36.84%) SQL Server 2008
6 14 (36.84%) SQL Server 2014
7 12 (31.58%) MySQL
8 7 (18.42%) MS Access
9 6 (15.79%) MariaDB
9 6 (15.79%) OLAP
9 6 (15.79%) OLTP
10 3 (7.89%) BusinessObjects
10 3 (7.89%) Oracle ODI
10 3 (7.89%) Relational Database
Development Applications
1 17 (44.74%) Talend Open Studio
2 14 (36.84%) Git (software)
2 14 (36.84%) JIRA
3 8 (21.05%) Liquibase
General
1 15 (39.47%) Banking
2 14 (36.84%) Corporate Banking
2 14 (36.84%) Finance
2 14 (36.84%) Retail
2 14 (36.84%) Retail Banking
3 8 (21.05%) Publishing
Job Titles
1 34 (89.47%) Developer
2 15 (39.47%) ETL Developer
3 7 (18.42%) MySQL Developer
4 6 (15.79%) Database Developer
5 5 (13.16%) SQL Developer
6 4 (10.53%) OLAP Developer
7 3 (7.89%) Architect
7 3 (7.89%) Data Architect
7 3 (7.89%) SQL Database Developer
8 2 (5.26%) Analyst
8 2 (5.26%) Data Warehouse Architect
8 2 (5.26%) Data Warehouse Developer
8 2 (5.26%) SSAS Developer
9 1 (2.63%) Data Analyst
9 1 (2.63%) ETL Tester
9 1 (2.63%) Oracle Architect
9 1 (2.63%) QlikView Analyst
9 1 (2.63%) SQL Analyst
9 1 (2.63%) SQL Data Analyst
9 1 (2.63%) SSIS Developer
Miscellaneous
1 14 (36.84%) Analytical Skills
2 12 (31.58%) Management Information System
3 1 (2.63%) Computer Science
3 1 (2.63%) Data Structures
Operating Systems
1 17 (44.74%) Windows
2 3 (7.89%) Unix
2 3 (7.89%) Windows Server
Processes & Methodologies
1 29 (76.32%) Migration
2 24 (63.16%) Data Analysis
3 22 (57.89%) ETL
4 15 (39.47%) Analytics
5 14 (36.84%) Investment Management
5 14 (36.84%) Risk Management
5 14 (36.84%) Stakeholder Management
5 14 (36.84%) Visualisation
6 13 (34.21%) Customer Insight
7 12 (31.58%) Kalman Filter
8 10 (26.32%) Agile Software Development
9 9 (23.68%) Performance Tuning
10 7 (18.42%) Data Modelling
10 7 (18.42%) Informatics
11 6 (15.79%) Business Intelligence
11 6 (15.79%) Database Tuning
12 5 (13.16%) ETL Development
13 4 (10.53%) Change Data Capture
13 4 (10.53%) Data Migration
13 4 (10.53%) Software Engineering
Programming Languages
1 35 (92.11%) SQL
2 15 (39.47%) T-SQL
3 14 (36.84%) C#
3 14 (36.84%) Scala
3 14 (36.84%) Shell Script
4 1 (2.63%) PL/SQL
4 1 (2.63%) Python
Qualifications
1 18 (47.37%) Degree
Quality Assurance & Compliance
1 3 (7.89%) Data Quality
Vendors
1 17 (44.74%) Talend
2 15 (39.47%) Microsoft
3 14 (36.84%) Cloudera
3 14 (36.84%) Hortonworks
4 6 (15.79%) Oracle
5 3 (7.89%) SAP
6 2 (5.26%) Alteryx
6 2 (5.26%) MicroStrategy
7 1 (2.63%) Cognos
7 1 (2.63%) Teradata