Period
to 7 December 2019

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 6 months to 7 December 2019 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.

Snowflake Schema
UK
6 months to
7 Dec 2019
Same period 2018 Same period 2017
Rank 689 861 854
Rank change year-on-year +172 -7 +3
Contract jobs citing Snowflake Schema 103 37 46
As % of all contract IT jobs advertised in the UK 0.13% 0.035% 0.045%
As % of the Database & Business Intelligence category 0.60% 0.16% 0.20%
Number of daily rates quoted 82 28 20
UK median daily rate £550 £481 £435
Median daily rate % change year-on-year +14.29% +10.63% -10.77%
10th Percentile £401 £343 £323
90th Percentile £675 £575 £676
UK excluding London median daily rate £450 £385 £388
% change year-on-year +16.88% -0.65% -19.10%
Number of hourly rates quoted 0 0 0
UK median hourly rate - - -
UK excluding London median hourly rate - - -

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

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 17,067 23,610 22,728
As % of all contract IT jobs advertised in the UK 21.26% 22.55% 21.99%
Number of daily rates quoted 11,486 16,448 15,594
UK median daily rate £475 £475 £450
Median daily rate % change year-on-year - +5.56% +5.88%
10th Percentile £319 £313 £310
90th Percentile £656 £638 £625
UK excluding London median daily rate £438 £425 £400
% change year-on-year +2.94% +6.25% +5.26%
Number of hourly rates quoted 260 252 278
UK median hourly rate £32.50 £32.49 £30.50
Median hourly rate % change year-on-year +0.04% +6.52% +8.93%
10th Percentile £13.06 £13.72 £14.00
90th Percentile £65.00 £57.50 £57.44
UK excluding London median hourly rate £30.00 £34.25 £35.00
% change year-on-year -12.41% -2.14% +25.00%

Snowflake Schema
Job Vacancy Trend

Job postings citing Snowflake Schema as a percentage of all IT jobs advertised.

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
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing Snowflake Schema over the 6 months to 7 December 2019.

Contractor daily rate histogram for Snowflake Schema in the UK

Snowflake Schema
Top 10 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 6 months to 7 December 2019. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +172 99 £550 +14.29% 48
London +149 72 £556 +5.95% 30
UK excluding London +112 28 £450 +16.88% 19
East of England +54 14 £450 -5.26%
South East +69 9 £450 +30.43% 3
North of England +32 3 £338 - 12
North West +20 3 £338 - 12
Midlands +43 1 £500 +29.87% 2
East Midlands +22 1 £500 +29.87% 2
Wales - 1 £450 -

For the 6 months to 7 December 2019, IT contractor jobs citing Snowflake Schema also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads with a requirement for Snowflake Schema.

1 83 (80.58%) Data Warehouse
2 73 (70.87%) SQL
3 66 (64.08%) ETL
4 64 (62.14%) AWS
5 63 (61.17%) Business Intelligence
6 61 (59.22%) Amazon Redshift
7 53 (51.46%) Data Modelling
8 46 (44.66%) Agile Software Development
9 45 (43.69%) Python
10 44 (42.72%) Analytics
11 28 (27.18%) Data Lake
12 27 (26.21%) GCP
13 26 (25.24%) Data Science
13 26 (25.24%) Power BI
13 26 (25.24%) Power Platform
14 24 (23.30%) Scala
15 23 (22.33%) SQL Server
15 23 (22.33%) Visualisation
15 23 (22.33%) DevOps
16 21 (20.39%) Big Data
16 21 (20.39%) Tableau
17 20 (19.42%) Analytical Skills
17 20 (19.42%) BigQuery
18 19 (18.45%) Java
18 19 (18.45%) Data Engineering
19 17 (16.50%) Apache Airflow
19 17 (16.50%) Data Structures
19 17 (16.50%) Data Governance
19 17 (16.50%) Data Quality
20 16 (15.53%) Talend

Snowflake Schema
Co-occurring 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 17 (16.50%) Apache Airflow
2 14 (13.59%) Apache Spark
3 1 (0.97%) Confluence
Applications
1 2 (1.94%) Microsoft Excel
Business Applications
1 2 (1.94%) Dynamics AX
1 2 (1.94%) Salesforce.com CRM
Cloud Services
1 64 (62.14%) AWS
2 27 (26.21%) GCP
3 26 (25.24%) Power Platform
4 14 (13.59%) Amazon S3
5 12 (11.65%) Amazon EMR
5 12 (11.65%) Azure
6 9 (8.74%) Serverless
7 7 (6.80%) Amazon EC2
7 7 (6.80%) AWS CloudFormation
7 7 (6.80%) AWS Lambda
8 5 (4.85%) Amazon SQS
9 4 (3.88%) Virtual Private Cloud
10 3 (2.91%) Adobe Analytics
10 3 (2.91%) Amazon Kinesis
11 2 (1.94%) Dynamics 365
11 2 (1.94%) SaaS
12 1 (0.97%) Cloud Computing
12 1 (0.97%) GitHub
Communications & Networking
1 3 (2.91%) Internet
2 2 (1.94%) HTTP
Database & Business Intelligence
1 83 (80.58%) Data Warehouse
2 61 (59.22%) Amazon Redshift
3 28 (27.18%) Data Lake
4 26 (25.24%) Power BI
5 23 (22.33%) SQL Server
6 21 (20.39%) Big Data
7 20 (19.42%) BigQuery
8 15 (14.56%) SQL Server Integration Services
9 13 (12.62%) Apache Hive
9 13 (12.62%) Relational Database
9 13 (12.62%) Star Schema
10 9 (8.74%) OLAP
11 8 (7.77%) Amazon Athena
11 8 (7.77%) Hadoop
11 8 (7.77%) PostgreSQL
12 7 (6.80%) Data Mart
12 7 (6.80%) NoSQL
12 7 (6.80%) Presto
13 6 (5.83%) Oracle BI EE
14 5 (4.85%) Spotfire
Development Applications
1 9 (8.74%) Git (software)
2 7 (6.80%) Jenkins
3 5 (4.85%) Sonatype Nexus
4 3 (2.91%) ERwin
5 1 (0.97%) Artifactory
5 1 (0.97%) ER Studio
5 1 (0.97%) JIRA
5 1 (0.97%) Maven
General
1 5 (4.85%) Finance
1 5 (4.85%) Retail
2 4 (3.88%) Marketing
3 2 (1.94%) Advertising
3 2 (1.94%) Games
4 1 (0.97%) Aerospace
4 1 (0.97%) Arabic Language
4 1 (0.97%) Banking
4 1 (0.97%) Investment Banking
4 1 (0.97%) Law
4 1 (0.97%) Pharmaceutical
Job Titles
1 29 (28.16%) Data Engineer
2 24 (23.30%) Architect
3 22 (21.36%) Data Architect
4 19 (18.45%) Developer
5 9 (8.74%) Python Engineer
6 8 (7.77%) AWS Engineer
6 8 (7.77%) Data Modeller
6 8 (7.77%) Senior Data Engineer
7 7 (6.80%) Business Intelligence Developer
8 5 (4.85%) Analyst
8 5 (4.85%) Consultant
8 5 (4.85%) Data Warehouse Developer
8 5 (4.85%) DevOps Engineer
8 5 (4.85%) SQL Developer
9 4 (3.88%) Data Analyst
10 3 (2.91%) AWS Developer
10 3 (2.91%) Data Consultant
10 3 (2.91%) Data Warehouse Architect
10 3 (2.91%) ETL Developer
10 3 (2.91%) SAP Architect
Libraries, Frameworks & Software Standards
1 10 (9.71%) XML
2 9 (8.74%) JSON
3 5 (4.85%) Kafka
4 3 (2.91%) Node.js
5 2 (1.94%) Apache Avro
5 2 (1.94%) CSS
5 2 (1.94%) HTML
6 1 (0.97%) Oracle GoldenGate
6 1 (0.97%) Spark Streaming
6 1 (0.97%) Spring
6 1 (0.97%) Web Services
Miscellaneous
1 20 (19.42%) Analytical Skills
2 17 (16.50%) Data Structures
3 3 (2.91%) Cloud Native
3 3 (2.91%) Greenfield Project
4 2 (1.94%) User Experience
5 1 (0.97%) Algorithms
5 1 (0.97%) Management Information System
5 1 (0.97%) Online Games
5 1 (0.97%) Reference Data
5 1 (0.97%) Taxonomies
Operating Systems
1 4 (3.88%) Unix
2 3 (2.91%) Linux
3 2 (1.94%) Windows
Processes & Methodologies
1 66 (64.08%) ETL
2 63 (61.17%) Business Intelligence
3 53 (51.46%) Data Modelling
4 46 (44.66%) Agile Software Development
5 44 (42.72%) Analytics
6 26 (25.24%) Data Science
7 23 (22.33%) DevOps
7 23 (22.33%) Visualisation
8 19 (18.45%) Data Engineering
9 17 (16.50%) Data Governance
10 15 (14.56%) Data Visualisation
11 14 (13.59%) Scrum
12 12 (11.65%) Dimensional Modelling
12 12 (11.65%) Migration
13 11 (10.68%) Statistics
14 10 (9.71%) Continuous Deployment
15 9 (8.74%) Coaching
15 9 (8.74%) Data Analysis
15 9 (8.74%) Logical Data Model
15 9 (8.74%) Test Automation
Programming Languages
1 73 (70.87%) SQL
2 45 (43.69%) Python
3 24 (23.30%) Scala
4 19 (18.45%) Java
5 4 (3.88%) PL/SQL
6 3 (2.91%) Ruby
6 3 (2.91%) T-SQL
7 2 (1.94%) JavaScript
8 1 (0.97%) Bash Shell
8 1 (0.97%) C
8 1 (0.97%) C#
8 1 (0.97%) Data Analysis Expressions (DAX)
8 1 (0.97%) Shell Script
Qualifications
1 9 (8.74%) Degree
2 3 (2.91%) Computer Science Degree
3 1 (0.97%) BPSS Clearance
3 1 (0.97%) ISEB
Quality Assurance & Compliance
1 17 (16.50%) Data Quality
2 5 (4.85%) QA
3 2 (1.94%) GDPR
4 1 (0.97%) Disclosure Scotland
System Software
1 5 (4.85%) Docker
2 1 (0.97%) Oracle RAC
Systems Management
1 4 (3.88%) Terraform
2 2 (1.94%) Oozie
3 1 (0.97%) Data Guard
3 1 (0.97%) EMC NetWorker
3 1 (0.97%) Oracle RMAN
3 1 (0.97%) Tivoli Storage Manager
Vendors
1 21 (20.39%) Tableau
2 16 (15.53%) Talend
3 14 (13.59%) Microsoft
4 12 (11.65%) Teradata
5 10 (9.71%) Oracle
6 8 (7.77%) Informatica
6 8 (7.77%) SAP
7 7 (6.80%) Cognos
7 7 (6.80%) Google
8 6 (5.83%) MicroStrategy
9 5 (4.85%) IBM
10 3 (2.91%) Adobe
10 3 (2.91%) Ariba
11 2 (1.94%) Ab Initio
11 2 (1.94%) MuleSoft
11 2 (1.94%) Salesforce.com
12 1 (0.97%) CA
12 1 (0.97%) Databricks
12 1 (0.97%) Netezza
12 1 (0.97%) Sybase