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 August 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 Aug 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 627 663 627
Rank change year-on-year
+36 -36
Contract jobs citing Snowflake Schema 7 1 8
As % of all contract IT jobs located in the UK 0.013% 0.002% 0.014%
As % of the Database & Business Intelligence category 0.058% 0.007% 0.064%
Number of daily rates quoted 4 0 4
Median daily rate £575 - £369
90% offered a daily rate of more than £550 - £300
10% offered a daily rate of more than £618 - £586
UK excluding London median daily rate - - £300
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
12095 13649 12490
As % of all contract IT jobs located in the UK 22.69% 23.39% 22.14%
Number of daily rates quoted 8015 8926 7692
Median daily rate £425 £400 £400
Median daily rate % change year-on-year
+6.25% -
90% offered a daily rate of more than £300 £288 £263
10% offered a daily rate of more than £575 £550 £550
UK excluding London median daily rate £375 £375 £350
% change year-on-year
- +7.14%
Number of hourly rates quoted 199 214 208
Median hourly rate £28.18 £32.50 £27.50
Median hourly rate % change year-on-year
-13.29% +18.18%
90% offered a hourly rate of more than £12.00 £14.00 £13.00
10% offered a hourly rate of more than £48.00 £53.11 £55.00
UK excluding London median hourly rate £28.18 £33.00 £28.50
% change year-on-year
-14.60% +15.78%

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 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 27 August 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 +23 7 £575 - 1
London - 7 £575 - 1

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 27 August 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 10 (76.92%) Star Schema
2 9 (69.23%) Data Warehouse
3 8 (61.54%) Business Intelligence
3 8 (61.54%) Big Data
3 8 (61.54%) Analytics
4 7 (53.85%) Finance
4 7 (53.85%) Teradata
4 7 (53.85%) ETL
5 6 (46.15%) DataStage
6 5 (38.46%) SQL
6 5 (38.46%) Relational Database
7 4 (30.77%) Hadoop
7 4 (30.77%) Oracle
7 4 (30.77%) Data Modelling
7 4 (30.77%) Data Analytics
8 3 (23.08%) Change Data Capture
8 3 (23.08%) Control-M
8 3 (23.08%) IBM
8 3 (23.08%) MicroStrategy
8 3 (23.08%) OLAP
8 3 (23.08%) Big Data Analytics
8 3 (23.08%) Data Cleansing
9 2 (15.38%) Data Integration
9 2 (15.38%) Data Architecture
9 2 (15.38%) Cognos Business Intelligence
9 2 (15.38%) Computer Science
9 2 (15.38%) Banking
9 2 (15.38%) Data Management
9 2 (15.38%) Data Analysis
9 2 (15.38%) Enterprise 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 (15.38%) Apache Spark
Business Applications
1 2 (15.38%) Cognos Business Intelligence
Database & Business Intelligence
1 10 (76.92%) Star Schema
2 9 (69.23%) Data Warehouse
3 8 (61.54%) Big Data
4 6 (46.15%) DataStage
5 5 (38.46%) Relational Database
6 4 (30.77%) Hadoop
7 3 (23.08%) OLAP
8 2 (15.38%) Apache Hive
8 2 (15.38%) Cognos Framework Manager
8 2 (15.38%) Cognos Report Studio
8 2 (15.38%) OLTP
8 2 (15.38%) RDBMS
8 2 (15.38%) SQLPlus
9 1 (7.69%) Data Mart
9 1 (7.69%) MySQL
9 1 (7.69%) Oracle OLAP
9 1 (7.69%) QlikView
9 1 (7.69%) SQL Server
9 1 (7.69%) SQL Server Integration Services
Development Applications
1 2 (15.38%) ERwin
General
1 7 (53.85%) Finance
2 2 (15.38%) Banking
3 1 (7.69%) Corporate Banking
3 1 (7.69%) Marketing
Job Titles
1 11 (84.62%) Developer
2 4 (30.77%) Data Warehouse Developer
2 4 (30.77%) ETL Developer
2 4 (30.77%) Lead Developer
3 3 (23.08%) DataStage Developer
3 3 (23.08%) MicroStrategy Developer
3 3 (23.08%) SQL Developer
4 2 (15.38%) Applications Developer
4 2 (15.38%) Architect
4 2 (15.38%) Data Architect
4 2 (15.38%) Data Integration Architect
4 2 (15.38%) DataStage ETL Developer
4 2 (15.38%) ETL Architect
4 2 (15.38%) Integration Architect
Miscellaneous
1 2 (15.38%) Analytical Skills
1 2 (15.38%) Computer Science
1 2 (15.38%) Data Integration
Processes & Methodologies
1 8 (61.54%) Analytics
1 8 (61.54%) Business Intelligence
2 7 (53.85%) ETL
3 4 (30.77%) Data Analytics
3 4 (30.77%) Data Modelling
4 3 (23.08%) Big Data Analytics
4 3 (23.08%) Change Data Capture
4 3 (23.08%) Data Cleansing
5 2 (15.38%) Data Analysis
5 2 (15.38%) Data Architecture
5 2 (15.38%) Data Management
5 2 (15.38%) E-Commerce
5 2 (15.38%) Enterprise Architecture
5 2 (15.38%) ERP
5 2 (15.38%) IT Governance
5 2 (15.38%) Logical Data Model
5 2 (15.38%) MapReduce
5 2 (15.38%) Mentoring
5 2 (15.38%) Physical Data Model
5 2 (15.38%) SOA
Programming Languages
1 5 (38.46%) SQL
2 2 (15.38%) Java
2 2 (15.38%) PL/SQL
2 2 (15.38%) Python
Quality Assurance & Compliance
1 2 (15.38%) Data Quality
Systems Management
1 3 (23.08%) Control-M
Vendors
1 7 (53.85%) Teradata
2 4 (30.77%) Oracle
3 3 (23.08%) IBM
3 3 (23.08%) MicroStrategy
4 2 (15.38%) Cognos