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 27 July 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
27 Jul 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 651 671 610
Rank change year-on-year
+20 -61
Contract jobs citing Snowflake Schema 9 3 6
As % of all contract IT jobs located in the UK 0.017% 0.005% 0.011%
As % of the Database & Business Intelligence category 0.075% 0.023% 0.051%
Number of daily rates quoted 6 0 4
Median daily rate £550 - £388
90% offered a daily rate of more than £500 - £350
10% offered a daily rate of more than £613 - £583
UK excluding London median daily rate - - -
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
12055 13234 11847
As % of all contract IT jobs located in the UK 22.33% 23.20% 21.97%
Number of daily rates quoted 8014 8634 7314
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £280 £270
10% offered a daily rate of more than £575 £550 £550
UK excluding London median daily rate £375 £355 £350
% change year-on-year
+5.63% +1.42%
Number of hourly rates quoted 214 190 197
Median hourly rate £29.88 £26.00 £27.50
Median hourly rate % change year-on-year
+14.92% -5.45%
90% offered a hourly rate of more than £12.00 £16.50 £13.00
10% offered a hourly rate of more than £49.00 £52.17 £53.00
UK excluding London median hourly rate £29.25 £27.50 £25.00
% change year-on-year
+6.36% +10.00%

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 3 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 27 July 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
London +11 9 £550 - 4
England -8 9 £550 - 7
City of London - 1 £500 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 27 July 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 12 (80.00%) Star Schema
2 9 (60.00%) Finance
2 9 (60.00%) Data Warehouse
2 9 (60.00%) Business Intelligence
3 8 (53.33%) Big Data
3 8 (53.33%) Analytics
4 7 (46.67%) Relational Database
4 7 (46.67%) SQL
4 7 (46.67%) Teradata
4 7 (46.67%) ETL
5 6 (40.00%) DataStage
6 4 (26.67%) Hadoop
6 4 (26.67%) Data Analytics
6 4 (26.67%) Oracle
6 4 (26.67%) Data Modelling
7 3 (20.00%) OLAP
7 3 (20.00%) Control-M
7 3 (20.00%) IBM
7 3 (20.00%) MicroStrategy
7 3 (20.00%) Change Data Capture
7 3 (20.00%) Big Data Analytics
7 3 (20.00%) Data Cleansing
7 3 (20.00%) Marketing
7 3 (20.00%) SQL Server Integration Services
8 2 (13.33%) Enterprise Architecture
8 2 (13.33%) IT Governance
8 2 (13.33%) Cognos Business Intelligence
8 2 (13.33%) Computer Science
8 2 (13.33%) Data Integration
8 2 (13.33%) Data Architecture

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 2 (13.33%) Apache Spark
Business Applications
1 2 (13.33%) Cognos Business Intelligence
Database & Business Intelligence
1 12 (80.00%) Star Schema
2 9 (60.00%) Data Warehouse
3 8 (53.33%) Big Data
4 7 (46.67%) Relational Database
5 6 (40.00%) DataStage
6 4 (26.67%) Hadoop
7 3 (20.00%) OLAP
7 3 (20.00%) SQL Server Integration Services
8 2 (13.33%) Apache Hive
8 2 (13.33%) Cognos Framework Manager
8 2 (13.33%) Cognos Report Studio
8 2 (13.33%) OLTP
8 2 (13.33%) RDBMS
8 2 (13.33%) SQLPlus
9 1 (6.67%) Data Mart
9 1 (6.67%) MySQL
9 1 (6.67%) Oracle OLAP
9 1 (6.67%) QlikView
9 1 (6.67%) SQL Server
Development Applications
1 2 (13.33%) ERwin
General
1 9 (60.00%) Finance
2 3 (20.00%) Marketing
3 2 (13.33%) Banking
4 1 (6.67%) Corporate Banking
Job Titles
1 13 (86.67%) Developer
2 5 (33.33%) SQL Developer
3 4 (26.67%) Data Warehouse Developer
3 4 (26.67%) ETL Developer
3 4 (26.67%) Lead Developer
4 3 (20.00%) DataStage Developer
4 3 (20.00%) MicroStrategy Developer
5 2 (13.33%) Applications Developer
5 2 (13.33%) Architect
5 2 (13.33%) Data Architect
5 2 (13.33%) Data Integration Architect
5 2 (13.33%) DataStage ETL Developer
5 2 (13.33%) ETL Architect
5 2 (13.33%) Integration Architect
Miscellaneous
1 2 (13.33%) Analytical Skills
1 2 (13.33%) Computer Science
1 2 (13.33%) Data Integration
Processes & Methodologies
1 9 (60.00%) Business Intelligence
2 8 (53.33%) Analytics
3 7 (46.67%) ETL
4 4 (26.67%) Data Analytics
4 4 (26.67%) Data Modelling
5 3 (20.00%) Big Data Analytics
5 3 (20.00%) Change Data Capture
5 3 (20.00%) Data Cleansing
6 2 (13.33%) Data Analysis
6 2 (13.33%) Data Architecture
6 2 (13.33%) Data Management
6 2 (13.33%) E-Commerce
6 2 (13.33%) Enterprise Architecture
6 2 (13.33%) ERP
6 2 (13.33%) IT Governance
6 2 (13.33%) Logical Data Model
6 2 (13.33%) MapReduce
6 2 (13.33%) Mentoring
6 2 (13.33%) Physical Data Model
6 2 (13.33%) SOA
Programming Languages
1 7 (46.67%) SQL
2 2 (13.33%) Java
2 2 (13.33%) PL/SQL
2 2 (13.33%) Python
Quality Assurance & Compliance
1 2 (13.33%) Data Quality
Systems Management
1 3 (20.00%) Control-M
Vendors
1 7 (46.67%) Teradata
2 4 (26.67%) Oracle
3 3 (20.00%) IBM
3 3 (20.00%) MicroStrategy
4 2 (13.33%) Cognos