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 24 May 2016 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
24 May 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 645 616 608
Rank change year-on-year
-29 -8
Contract jobs citing Snowflake Schema 6 8 3
As % of all contract IT jobs located in the UK 0.011% 0.015% 0.006%
As % of the Database & Business Intelligence category 0.051% 0.064% 0.025%
Number of daily rates quoted 6 1 3
Median daily rate £475 £400 £350
Median daily rate % change year-on-year
+18.75% +14.28%
UK excluding London median daily rate £450 - -
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
11655 12454 12033
As % of all contract IT jobs located in the UK 21.77% 23.00% 22.46%
Number of daily rates quoted 7920 8087 7666
Median daily rate £425 £400 £388
Median daily rate % change year-on-year
+6.25% +3.22%
90% offered a daily rate of more than £300 £275 £270
10% offered a daily rate of more than £600 £550 £525
UK excluding London median daily rate £388 £370 £350
% change year-on-year
+4.72% +5.71%
Number of hourly rates quoted 173 163 208
Median hourly rate £33.50 £25.00 £31.50
Median hourly rate % change year-on-year
+34.00% -20.63%
90% offered a hourly rate of more than £13.50 £15.03 £13.00
10% offered a hourly rate of more than £47.50 £46.91 £55.00
UK excluding London median hourly rate £34.00 £25.00 £32.50
% change year-on-year
+36.00% -23.07%

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 24 May 2016. 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 see detailed
statistics and trends)
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 -10 6 £475 +18.75%
London -12 4 £500 +25.00%
City of London - 2 £450 -
Nottingham - 2 £450 -
Nottinghamshire - 2 £450 -
East Midlands - 2 £450 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 24 May 2016, 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 13 (76.47%) Star Schema
2 12 (70.59%) Business Intelligence
3 10 (58.82%) SQL
3 10 (58.82%) Finance
4 9 (52.94%) Data Warehouse
5 6 (35.29%) Data Modelling
5 6 (35.29%) ETL
5 6 (35.29%) SQL Server Integration Services
6 5 (29.41%) Enterprise Architecture
6 5 (29.41%) OLAP
6 5 (29.41%) Big Data
6 5 (29.41%) Analytics
7 4 (23.53%) Relational Database
7 4 (23.53%) Marketing
8 3 (17.65%) SQL Server
8 3 (17.65%) Predictive Analytics
8 3 (17.65%) Dimensional Modelling
8 3 (17.65%) Visualisation
8 3 (17.65%) Amazon AWS
8 3 (17.65%) NoSQL
8 3 (17.65%) R
8 3 (17.65%) Tableau
8 3 (17.65%) Data Quality
8 3 (17.65%) Digital Media
8 3 (17.65%) New Media
8 3 (17.65%) MicroStrategy
8 3 (17.65%) SPSS
8 3 (17.65%) ERwin
8 3 (17.65%) Agile Software Development
8 3 (17.65%) Web Services

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 3 (17.65%) SAS
Applications
1 3 (17.65%) SPSS
2 1 (5.88%) MS Excel
Business Applications
1 1 (5.88%) Oracle EBS
1 1 (5.88%) Oracle EBS R12
Cloud Services
1 3 (17.65%) Amazon AWS
Database & Business Intelligence
1 13 (76.47%) Star Schema
2 9 (52.94%) Data Warehouse
3 6 (35.29%) SQL Server Integration Services
4 5 (29.41%) Big Data
4 5 (29.41%) OLAP
5 4 (23.53%) Relational Database
6 3 (17.65%) NoSQL
6 3 (17.65%) SQL Server
7 2 (11.76%) Data Mart
7 2 (11.76%) Hadoop
7 2 (11.76%) OLTP
7 2 (11.76%) Oracle OLAP
7 2 (11.76%) SQL Server 2008
7 2 (11.76%) SQL Server Analysis Services
8 1 (5.88%) OLAP Cube
8 1 (5.88%) Oracle BI EE
8 1 (5.88%) PowerMart
8 1 (5.88%) SQL Server 2012
8 1 (5.88%) SQL Server 2014
8 1 (5.88%) SQL Server Reporting Services
Development Applications
1 3 (17.65%) ERwin
General
1 10 (58.82%) Finance
2 4 (23.53%) Marketing
3 1 (5.88%) Banking
Job Titles
1 10 (58.82%) Developer
2 8 (47.06%) SQL Developer
3 5 (29.41%) Architect
4 4 (23.53%) Data Architect
5 3 (17.65%) Data Modeller
5 3 (17.65%) MicroStrategy Developer
6 2 (11.76%) Business Intelligence Developer
6 2 (11.76%) Data Integration Architect
6 2 (11.76%) Data Warehouse Developer
6 2 (11.76%) ETL Architect
6 2 (11.76%) Integration Architect
6 2 (11.76%) SQL BI Developer
7 1 (5.88%) Business Developer
7 1 (5.88%) Consultant
7 1 (5.88%) OBIEE Developer
7 1 (5.88%) Senior Business Intelligence Developer
7 1 (5.88%) Senior Developer
7 1 (5.88%) Senior SQL Developer
7 1 (5.88%) Tableau Consultant
Libraries, Frameworks & Software Standards
1 3 (17.65%) Web Services
Miscellaneous
1 3 (17.65%) Digital Media
1 3 (17.65%) New Media
1 3 (17.65%) Visualisation
2 2 (11.76%) Analytical Skills
2 2 (11.76%) Computer Science
2 2 (11.76%) Data Integration
2 2 (11.76%) Data Structures
Operating Systems
1 1 (5.88%) Unix
Processes & Methodologies
1 12 (70.59%) Business Intelligence
2 6 (35.29%) Data Modelling
2 6 (35.29%) ETL
3 5 (29.41%) Analytics
3 5 (29.41%) Enterprise Architecture
4 3 (17.65%) Agile Software Development
4 3 (17.65%) Dimensional Modelling
4 3 (17.65%) Predictive Analytics
5 2 (11.76%) Data Analysis
5 2 (11.76%) Data Architecture
5 2 (11.76%) E-Commerce
5 2 (11.76%) ERP
5 2 (11.76%) IT Governance
5 2 (11.76%) Kimball Methodology
5 2 (11.76%) Logical Data Model
5 2 (11.76%) Mentoring
5 2 (11.76%) Physical Data Model
5 2 (11.76%) SOA
6 1 (5.88%) Kalman Filter
6 1 (5.88%) Zachman Framework
Programming Languages
1 10 (58.82%) SQL
2 3 (17.65%) Python
2 3 (17.65%) R
3 1 (5.88%) PL/SQL
3 1 (5.88%) T-SQL
Quality Assurance & Compliance
1 3 (17.65%) Data Quality
Vendors
1 3 (17.65%) MicroStrategy
1 3 (17.65%) Tableau
2 2 (11.76%) Oracle
3 1 (5.88%) Guidewire
3 1 (5.88%) Informatica
3 1 (5.88%) Microsoft
3 1 (5.88%) Teradata