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 January 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
24 Jan 2017
Same period 2016 Same period 2015
Snowflake Schema
UK
Rank 571 603 596
Rank change year-on-year
+32 -7
Contract jobs citing Snowflake Schema 22 9 16
As % of all contract IT jobs located in the UK 0.049% 0.018% 0.032%
As % of the Database & Business Intelligence category 0.22% 0.079% 0.15%
Number of daily rates quoted 19 6 8
Median daily rate £500 £364 £363
Median daily rate % change year-on-year
+37.45% +0.34%
90% offered a daily rate of more than £415 £284 £307
10% offered a daily rate of more than £510 £428 £645
UK excluding London median daily rate £500 £340 £350
% change year-on-year
+47.05% -2.85%
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
9954 11379 10951
As % of all contract IT jobs located in the UK 22.19% 22.76% 21.95%
Number of daily rates quoted 6652 7645 7124
Median daily rate £450 £425 £400
Median daily rate % change year-on-year
+5.88% +6.25%
90% offered a daily rate of more than £310 £300 £275
10% offered a daily rate of more than £600 £575 £550
UK excluding London median daily rate £400 £375 £363
% change year-on-year
+6.66% +3.44%
Number of hourly rates quoted 130 223 163
Median hourly rate £38.00 £27.50 £30.00
Median hourly rate % change year-on-year
+38.18% -8.33%
90% offered a hourly rate of more than £12.00 £14.20 £15.75
10% offered a hourly rate of more than £47.00 £55.00 £50.00
UK excluding London median hourly rate £38.00 £26.50 £32.50
% change year-on-year
+43.39% -18.46%

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 8 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 January 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 +35 22 £500 +37.45% 4
South East - 15 £505 - 2
Oxfordshire - 15 £505 -
Oxford - 8 £510 -
London +6 6 £415 +7.09% 1
City of London - 3 £415 -
South West +7 1 £400 +25.98%
Dorset - 1 £400 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 24 January 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 34 (94.44%) SQL Server
2 33 (91.67%) SQL
3 27 (75.00%) Migration
4 22 (61.11%) Data Analysis
4 22 (61.11%) ETL
5 20 (55.56%) Data Warehouse
6 17 (47.22%) Talend Open Studio
6 17 (47.22%) Talend
7 16 (44.44%) Degree
8 15 (41.67%) MS Excel
8 15 (41.67%) Windows
8 15 (41.67%) SQL Server Integration Services
9 14 (38.89%) SQL Server Analysis Services
9 14 (38.89%) Git (software)
9 14 (38.89%) SQL Server 2014
9 14 (38.89%) JIRA
9 14 (38.89%) SQL Server 2005
9 14 (38.89%) Microsoft Analysis Services
10 13 (36.11%) Banking
10 13 (36.11%) T-SQL
10 13 (36.11%) Microsoft
10 13 (36.11%) QlikView
10 13 (36.11%) Analytics
10 13 (36.11%) Hadoop
10 13 (36.11%) Big Data
10 13 (36.11%) Customer Insight
11 12 (33.33%) Visualisation
11 12 (33.33%) Apache Hive
11 12 (33.33%) Apache Pig
11 12 (33.33%) Hortonworks

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 12 (33.33%) Apache Pig
2 8 (22.22%) Confluence
3 1 (2.78%) Apache Spark
Applications
1 15 (41.67%) MS Excel
Business Applications
1 1 (2.78%) Dynamics AX
Communications & Networking
1 11 (30.56%) Intranet
Database & Business Intelligence
1 34 (94.44%) SQL Server
2 20 (55.56%) Data Warehouse
3 15 (41.67%) SQL Server Integration Services
4 14 (38.89%) Microsoft Analysis Services
4 14 (38.89%) SQL Server 2005
4 14 (38.89%) SQL Server 2014
4 14 (38.89%) SQL Server Analysis Services
5 13 (36.11%) Big Data
5 13 (36.11%) Hadoop
5 13 (36.11%) QlikView
6 12 (33.33%) Apache Hive
6 12 (33.33%) MySQL
6 12 (33.33%) SQL Server 2008
7 7 (19.44%) MS Access
8 6 (16.67%) MariaDB
8 6 (16.67%) OLAP
8 6 (16.67%) OLTP
9 3 (8.33%) BusinessObjects
9 3 (8.33%) Oracle ODI
9 3 (8.33%) Star Schema
Development Applications
1 17 (47.22%) Talend Open Studio
2 14 (38.89%) Git (software)
2 14 (38.89%) JIRA
3 8 (22.22%) Liquibase
General
1 13 (36.11%) Banking
2 12 (33.33%) Corporate Banking
2 12 (33.33%) Finance
2 12 (33.33%) Retail
2 12 (33.33%) Retail Banking
3 8 (22.22%) Publishing
Job Titles
1 32 (88.89%) Developer
2 15 (41.67%) ETL Developer
3 7 (19.44%) MySQL Developer
4 6 (16.67%) Database Developer
5 5 (13.89%) SQL Developer
6 4 (11.11%) OLAP Developer
7 3 (8.33%) Architect
7 3 (8.33%) Data Architect
7 3 (8.33%) SQL Database Developer
8 2 (5.56%) Analyst
8 2 (5.56%) Data Warehouse Architect
8 2 (5.56%) Data Warehouse Developer
8 2 (5.56%) SSAS Developer
9 1 (2.78%) Business Intelligence Analyst
9 1 (2.78%) Business Intelligence Developer
9 1 (2.78%) Oracle Architect
9 1 (2.78%) QlikView Analyst
9 1 (2.78%) SQL Analyst
9 1 (2.78%) SQL Data Analyst
9 1 (2.78%) SSIS Developer
Miscellaneous
1 12 (33.33%) Analytical Skills
1 12 (33.33%) Management Information System
1 12 (33.33%) Visualisation
2 7 (19.44%) Informatics
3 4 (11.11%) Economics
4 2 (5.56%) Data Integration
5 1 (2.78%) Computer Science
5 1 (2.78%) Data Structures
Operating Systems
1 15 (41.67%) Windows
2 3 (8.33%) Unix
2 3 (8.33%) Windows Server
Processes & Methodologies
1 27 (75.00%) Migration
2 22 (61.11%) Data Analysis
2 22 (61.11%) ETL
3 13 (36.11%) Analytics
3 13 (36.11%) Customer Insight
4 12 (33.33%) Investment Management
4 12 (33.33%) Kalman Filter
4 12 (33.33%) Risk Management
4 12 (33.33%) Stakeholder Management
5 10 (27.78%) Agile Software Development
6 9 (25.00%) Performance Tuning
7 7 (19.44%) Data Modelling
8 6 (16.67%) Business Intelligence
8 6 (16.67%) Database Tuning
9 5 (13.89%) ETL Development
10 4 (11.11%) Change Data Capture
10 4 (11.11%) Data Migration
10 4 (11.11%) Software Engineering
10 4 (11.11%) Workflow
11 3 (8.33%) Unit Testing
Programming Languages
1 33 (91.67%) SQL
2 13 (36.11%) T-SQL
3 12 (33.33%) C#
3 12 (33.33%) Scala
3 12 (33.33%) Shell Script
4 1 (2.78%) PL/SQL
4 1 (2.78%) Python
Qualifications
1 16 (44.44%) Degree
Quality Assurance & Compliance
1 3 (8.33%) Data Quality
Vendors
1 17 (47.22%) Talend
2 13 (36.11%) Microsoft
3 12 (33.33%) Cloudera
3 12 (33.33%) Hortonworks
4 6 (16.67%) Oracle
5 3 (8.33%) SAP
6 2 (5.56%) Alteryx
6 2 (5.56%) MicroStrategy
7 1 (2.78%) Cognos
7 1 (2.78%) Teradata
London
Eames Consulting
Rate: £400 - £500 per day
Posted: 6 days ago