The following table provides summary statistics for contract job vacancies with a requirement for Snowflake Schema skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Snowflake Schema over the 3 months to 24 March 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Snowflake Schema
UK
Rank 591 635 610
Rank change year-on-year +44 -25  
Contract jobs citing Snowflake Schema 5 7 11
As % of all contract IT jobs advertised in the UK 0.011% 0.013% 0.021%
As % of the Database & Business Intelligence category 0.049% 0.060% 0.093%
Number of daily rates quoted 1 7 3
Median daily rate £450 £400 £400
Median daily rate % change year-on-year +12.50% -  
UK excluding London median daily rate - £450 £425
% change year-on-year - +5.88%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate - - -

Snowflake Schema is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies with a requirement for database and business intelligence skills.

Contract Database & Business Intelligence Skills
UK
Contract job vacancies with a requirement for database and business intelligence skills 10302 11737 11801
As % of all contract IT job vacancies advertised in the UK 22.74% 22.14% 22.43%
Number of daily rates quoted 6968 7866 7527
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 £600 £550
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.22% +3.33%  
Number of hourly rates quoted 130 190 155
Median hourly rate £30.50 £32.50 £32.10
Median hourly rate % change year-on-year -6.15% +1.24%  
90% offered a hourly rate of more than £11.75 £14.50 £16.45
10% offered a hourly rate of more than £47.00 £57.75 £47.50
UK excluding London median hourly rate £31.00 £32.50 £32.50
% change year-on-year -4.61% -  

Snowflake Schema
Job Vacancy Trend

The job posting trend of jobs advertised citing Snowflake Schema as a proportion of all contract or permanent IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for Snowflake Schema in the UK

Snowflake Schema
Contractor Daily Rate Trend

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

Contractor daily rate trend for Snowflake Schema in the UK

Snowflake Schema
Top 2 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 24 March 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 +32 5 £450 +12.50% 1
London +27 5 £450 +12.50%

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 24 March 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 (97.30%) SQL
2 35 (94.59%) SQL Server
3 30 (81.08%) Migration
4 25 (67.57%) Data Analysis
5 21 (56.76%) Data Warehouse
6 20 (54.05%) ETL
7 19 (51.35%) Degree
8 18 (48.65%) Windows
9 17 (45.95%) Microsoft Analysis Services
9 17 (45.95%) SQL Server Analysis Services
10 16 (43.24%) QlikView
10 16 (43.24%) SQL Server Integration Services
10 16 (43.24%) Hadoop
10 16 (43.24%) Big Data
10 16 (43.24%) Analytics
10 16 (43.24%) Analytical Skills
10 16 (43.24%) Banking
10 16 (43.24%) T-SQL
10 16 (43.24%) Microsoft
11 15 (40.54%) Shell Script
11 15 (40.54%) C#
11 15 (40.54%) MS Excel
11 15 (40.54%) Retail
11 15 (40.54%) Stakeholder Management
11 15 (40.54%) Risk Management
11 15 (40.54%) Finance
11 15 (40.54%) Apache Pig
11 15 (40.54%) Talend
11 15 (40.54%) Hortonworks
11 15 (40.54%) Cloudera

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 15 (40.54%) Apache Pig
2 8 (21.62%) Confluence
3 1 (2.70%) Apache Spark
Applications
1 15 (40.54%) MS Excel
Business Applications
1 1 (2.70%) Dynamics AX
Communications & Networking
1 11 (29.73%) Intranet
Database & Business Intelligence
1 35 (94.59%) SQL Server
2 21 (56.76%) Data Warehouse
3 17 (45.95%) Microsoft Analysis Services
3 17 (45.95%) SQL Server Analysis Services
4 16 (43.24%) Big Data
4 16 (43.24%) Hadoop
4 16 (43.24%) QlikView
4 16 (43.24%) SQL Server Integration Services
5 15 (40.54%) Apache Hive
5 15 (40.54%) SQL Server 2008
6 14 (37.84%) SQL Server 2005
6 14 (37.84%) SQL Server 2014
7 10 (27.03%) MySQL
8 7 (18.92%) MS Access
9 6 (16.22%) MariaDB
9 6 (16.22%) OLAP
9 6 (16.22%) OLTP
10 3 (8.11%) BusinessObjects
10 3 (8.11%) Oracle ODI
10 3 (8.11%) Star Schema
Development Applications
1 15 (40.54%) Talend Open Studio
2 14 (37.84%) Git (software)
2 14 (37.84%) JIRA
3 8 (21.62%) Liquibase
General
1 16 (43.24%) Banking
2 15 (40.54%) Corporate Banking
2 15 (40.54%) Finance
2 15 (40.54%) Retail
2 15 (40.54%) Retail Banking
3 8 (21.62%) Publishing
Job Titles
1 34 (91.89%) Developer
2 14 (37.84%) ETL Developer
3 7 (18.92%) MySQL Developer
4 6 (16.22%) Database Developer
5 5 (13.51%) SQL Developer
6 4 (10.81%) OLAP Developer
7 3 (8.11%) Architect
7 3 (8.11%) Data Architect
7 3 (8.11%) SQL Database Developer
8 2 (5.41%) Analyst
8 2 (5.41%) Data Warehouse Architect
8 2 (5.41%) Data Warehouse Developer
8 2 (5.41%) SSAS Developer
9 1 (2.70%) Data Analyst
9 1 (2.70%) Data Warehouse Analyst
9 1 (2.70%) Oracle Architect
9 1 (2.70%) Oracle Developer
9 1 (2.70%) QlikView Analyst
9 1 (2.70%) SQL Server Developer
9 1 (2.70%) SSIS Developer
Miscellaneous
1 16 (43.24%) Analytical Skills
2 12 (32.43%) Management Information System
3 1 (2.70%) Computer Science
3 1 (2.70%) Data Structures
Operating Systems
1 18 (48.65%) Windows
2 3 (8.11%) Unix
2 3 (8.11%) Windows Server
Processes & Methodologies
1 30 (81.08%) Migration
2 25 (67.57%) Data Analysis
3 20 (54.05%) ETL
4 16 (43.24%) Analytics
5 15 (40.54%) Investment Management
5 15 (40.54%) Risk Management
5 15 (40.54%) Stakeholder Management
5 15 (40.54%) Visualisation
6 13 (35.14%) Customer Insight
7 12 (32.43%) Kalman Filter
8 11 (29.73%) Agile Software Development
9 9 (24.32%) Performance Tuning
10 7 (18.92%) Informatics
11 6 (16.22%) Database Tuning
12 5 (13.51%) Data Modelling
12 5 (13.51%) ETL Development
13 4 (10.81%) Business Intelligence
13 4 (10.81%) Economics
13 4 (10.81%) Software Engineering
13 4 (10.81%) Workflow
Programming Languages
1 36 (97.30%) SQL
2 16 (43.24%) T-SQL
3 15 (40.54%) C#
3 15 (40.54%) Scala
3 15 (40.54%) Shell Script
4 1 (2.70%) PL/SQL
4 1 (2.70%) Python
Qualifications
1 19 (51.35%) Degree
Quality Assurance & Compliance
1 3 (8.11%) Data Quality
Vendors
1 16 (43.24%) Microsoft
2 15 (40.54%) Cloudera
2 15 (40.54%) Hortonworks
2 15 (40.54%) Talend
3 4 (10.81%) Oracle
4 3 (8.11%) SAP
5 1 (2.70%) Cognos
5 1 (2.70%) Teradata