Period
to 11 December 2019

The following table provides summary statistics for permanent job vacancies with a requirement for Snowflake Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Snowflake Schema over the 6 months to 11 December 2019 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK
6 months to
11 Dec 2019
Same period 2018 Same period 2017
Rank 804 1030 1159
Rank change year-on-year +226 +129 +13
Permanent jobs citing Snowflake Schema 246 115 58
As % of all permanent IT jobs advertised in the UK 0.18% 0.072% 0.032%
As % of the Database & Business Intelligence category 0.69% 0.25% 0.11%
Number of salaries quoted 213 98 37
UK median annual salary £65,000 £55,000 £50,000
Median salary % change year-on-year +18.18% +10.00% -7.41%
10th Percentile £37,100 £34,750 £37,500
90th Percentile £115,000 £73,750 £80,000
UK excluding London median annual salary £52,500 £50,000 £50,000
% change year-on-year +5.00% - +11.11%

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 permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 35,827 46,020 54,445
As % of all permanent IT jobs advertised in the UK 26.85% 28.81% 30.30%
Number of salaries quoted 29,600 37,812 44,893
UK median annual salary £52,500 £50,000 £47,500
Median salary % change year-on-year +5.00% +5.26% -
10th Percentile £32,000 £31,250 £30,000
90th Percentile £87,500 £85,000 £77,500
UK excluding London median annual salary £45,000 £45,000 £42,500
% change year-on-year - +5.88% -

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
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Snowflake Schema.

Salary trend for Snowflake Schema in the UK

Snowflake Schema
Salary Histogram

The salary distribution of IT jobs citing Snowflake Schema over the 6 months to 11 December 2019.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 13 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the UK over the 6 months to 11 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +231 236 £65,000 +18.18% 50
London +154 148 £75,000 +20.00% 32
UK excluding London +130 94 £52,500 +5.00% 18
North of England +79 50 £60,000 +20.00% 11
North West +86 47 £60,000 +118.18% 11
South East +33 14 £50,000 -4.76% 3
South West +20 14 £52,500 +5.00% 1
Midlands +39 9 £38,000 - 2
West Midlands - 9 £38,000 -
Scotland - 5 £52,500 -
Yorkshire +19 3 £80,000 +60.00%
East of England +59 1 - - 1
Wales +6 1 £52,500 -

For the 6 months to 11 December 2019, IT 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 permanent job ads with a requirement for Snowflake Schema.

1 200 (81.30%) Data Warehouse
2 176 (71.54%) SQL
3 163 (66.26%) AWS
4 148 (60.16%) Business Intelligence
5 140 (56.91%) ETL
6 139 (56.50%) Amazon Redshift
7 111 (45.12%) Data Modelling
8 107 (43.50%) SQL Server
9 106 (43.09%) Azure
10 98 (39.84%) Python
10 98 (39.84%) Analytics
11 88 (35.77%) GCP
12 73 (29.67%) Agile Software Development
13 70 (28.46%) BigQuery
13 70 (28.46%) Analytical Skills
14 66 (26.83%) Tableau
15 64 (26.02%) Big Data
16 59 (23.98%) Finance
17 56 (22.76%) Microsoft
18 54 (21.95%) Apache Spark
19 52 (21.14%) Looker
20 51 (20.73%) Power BI
20 51 (20.73%) Power Platform
21 49 (19.92%) Kimball Methodology
22 47 (19.11%) Visualisation
23 46 (18.70%) Data Science
24 45 (18.29%) Problem-Solving
24 45 (18.29%) SQL Server Integration Services
25 44 (17.89%) Kafka
26 40 (16.26%) Google

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 54 (21.95%) Apache Spark
2 23 (9.35%) Apache
3 19 (7.72%) Apache Airflow
4 9 (3.66%) Confluence
5 5 (2.03%) CMS
5 5 (2.03%) Joomla!
6 3 (1.22%) Apache Pig
6 3 (1.22%) Elasticsearch
6 3 (1.22%) SAS
7 2 (0.81%) Apache Solr
7 2 (0.81%) Cloud Foundry
7 2 (0.81%) Luigi
7 2 (0.81%) nginx
7 2 (0.81%) Tomcat
Applications
1 12 (4.88%) Microsoft Excel
2 1 (0.41%) Microsoft Office
2 1 (0.41%) SPSS
2 1 (0.41%) SPSS Modeler
Business Applications
1 2 (0.81%) Eikon
2 1 (0.41%) SAP CO
2 1 (0.41%) SAP FI
2 1 (0.41%) SAP FI/CO
Cloud Services
1 163 (66.26%) AWS
2 106 (43.09%) Azure
3 88 (35.77%) GCP
4 51 (20.73%) Power Platform
5 31 (12.60%) Amazon S3
6 26 (10.57%) Cloud Computing
7 17 (6.91%) SaaS
8 16 (6.50%) Serverless
9 15 (6.10%) AWS Lambda
10 13 (5.28%) PaaS
11 11 (4.47%) Amazon Kinesis
11 11 (4.47%) Azure Data Factory
11 11 (4.47%) IaaS
12 7 (2.85%) Amazon EC2
13 5 (2.03%) GitHub
13 5 (2.03%) Google Analytics
14 4 (1.63%) Azure Functions
14 4 (1.63%) OpenShift
14 4 (1.63%) WeChat
15 3 (1.22%) Amazon EMR
Communications & Networking
1 3 (1.22%) Internet
2 1 (0.41%) LAN
2 1 (0.41%) TCP/IP
2 1 (0.41%) VLAN
2 1 (0.41%) WAN
2 1 (0.41%) Wi-Fi
Database & Business Intelligence
1 200 (81.30%) Data Warehouse
2 139 (56.50%) Amazon Redshift
3 107 (43.50%) SQL Server
4 70 (28.46%) BigQuery
5 64 (26.02%) Big Data
6 52 (21.14%) Looker
7 51 (20.73%) Power BI
8 45 (18.29%) SQL Server Integration Services
9 39 (15.85%) Data Lake
9 39 (15.85%) NoSQL
10 34 (13.82%) Azure SQL Data Warehouse
10 34 (13.82%) Azure SQL Database
11 33 (13.41%) Hadoop
12 24 (9.76%) SQL Server Reporting Services
13 20 (8.13%) Relational Database
14 19 (7.72%) Apache Hive
14 19 (7.72%) MongoDB
15 18 (7.32%) Amazon RDS
16 17 (6.91%) SQL Server Analysis Services
17 16 (6.50%) Star Schema
Development Applications
1 26 (10.57%) JIRA
2 22 (8.94%) Git (software)
3 9 (3.66%) Team Foundation Server
4 7 (2.85%) SQL Server Management Studio (SSMS)
5 6 (2.44%) Bitbucket
5 6 (2.44%) ERwin
6 5 (2.03%) Jenkins
7 4 (1.63%) TeamCity
8 3 (1.22%) Subversion
9 2 (0.81%) PowerDesigner
10 1 (0.41%) Sonatype Nexus
General
1 59 (23.98%) Finance
2 32 (13.01%) Marketing
3 19 (7.72%) Legal
4 14 (5.69%) Public Sector
5 12 (4.88%) Electronics
5 12 (4.88%) Manufacturing
5 12 (4.88%) Telecoms
6 7 (2.85%) Law
6 7 (2.85%) Retail
7 6 (2.44%) Automotive
8 4 (1.63%) Banking
8 4 (1.63%) Financial Institution
9 3 (1.22%) Advertising
9 3 (1.22%) Games
10 1 (0.41%) Publishing
Job Titles
1 76 (30.89%) Architect
2 58 (23.58%) Data Architect
3 54 (21.95%) Developer
4 41 (16.67%) Business Intelligence Developer
5 37 (15.04%) Data Engineer
6 31 (12.60%) Analyst
7 30 (12.20%) Data Warehouse Architect
8 25 (10.16%) SQL Developer
9 22 (8.94%) SQL BI Developer
10 21 (8.54%) Solutions Architect
11 17 (6.91%) Data Analyst
12 16 (6.50%) Consultant
13 15 (6.10%) AWS Architect
13 15 (6.10%) Big Data Architect
13 15 (6.10%) Senior Architect
14 14 (5.69%) Business Intelligence Analyst
15 13 (5.28%) Cloud Architect
16 12 (4.88%) Senior Solutions Architect
17 11 (4.47%) ETL Architect
18 10 (4.07%) Senior Analyst
Libraries, Frameworks & Software Standards
1 44 (17.89%) Kafka
2 28 (11.38%) Web Services
3 9 (3.66%) MDX
3 9 (3.66%) XML
4 7 (2.85%) REST
4 7 (2.85%) SOAP
5 6 (2.44%) Dask
5 6 (2.44%) Natural Language Processing
6 5 (2.03%) .NET
6 5 (2.03%) CakePHP
6 5 (2.03%) CodeIgniter
6 5 (2.03%) CSS
6 5 (2.03%) HTML
6 5 (2.03%) jQuery
6 5 (2.03%) JSON
7 4 (1.63%) RabbitMQ
8 3 (1.22%) Apache Avro
9 2 (0.81%) Apache NiFi
9 2 (0.81%) GraphQL
9 2 (0.81%) PySpark
Miscellaneous
1 70 (28.46%) Analytical Skills
2 18 (7.32%) Public Cloud
3 13 (5.28%) Cloud Native
4 10 (4.07%) Hybrid Cloud
5 9 (3.66%) Data Centre
6 7 (2.85%) Data Structures
6 7 (2.85%) Private Cloud
7 5 (2.03%) Enterprise Software
7 5 (2.03%) Self-Motivation
7 5 (2.03%) User Experience
8 4 (1.63%) Hedge funds
8 4 (1.63%) Management Information System
8 4 (1.63%) Social Media
9 3 (1.22%) Reference Data
10 2 (0.81%) Foreign Exchange (FX)
10 2 (0.81%) Greenfield Project
10 2 (0.81%) Replication
10 2 (0.81%) Social Network
11 1 (0.41%) Learning Management System
11 1 (0.41%) Video\Live Streaming
Operating Systems
1 30 (12.20%) Linux
2 5 (2.03%) Unix
3 4 (1.63%) Solaris
3 4 (1.63%) Windows
Processes & Methodologies
1 148 (60.16%) Business Intelligence
2 140 (56.91%) ETL
3 111 (45.12%) Data Modelling
4 98 (39.84%) Analytics
5 73 (29.67%) Agile Software Development
6 49 (19.92%) Kimball Methodology
7 47 (19.11%) Visualisation
8 46 (18.70%) Data Science
9 45 (18.29%) Problem-Solving
10 39 (15.85%) Data Visualisation
11 35 (14.23%) Data Engineering
12 34 (13.82%) Data Integration
13 33 (13.41%) SDLC
14 30 (12.20%) Data Transformation
15 29 (11.79%) Data Management
15 29 (11.79%) Fintech
15 29 (11.79%) Migration
16 28 (11.38%) Data Architecture
17 27 (10.98%) Machine Learning
18 22 (8.94%) Software Engineering
Programming Languages
1 176 (71.54%) SQL
2 98 (39.84%) Python
3 38 (15.45%) Java
4 27 (10.98%) Scala
5 16 (6.50%) Bash Shell
5 16 (6.50%) PL/SQL
6 8 (3.25%) T-SQL
7 7 (2.85%) C#
7 7 (2.85%) Data Analysis Expressions (DAX)
7 7 (2.85%) JavaScript
7 7 (2.85%) PowerShell
7 7 (2.85%) R
8 5 (2.03%) PHP
9 4 (1.63%) C++
9 4 (1.63%) Shell Script
9 4 (1.63%) VBA
10 2 (0.81%) Ruby
11 1 (0.41%) Perl
Qualifications
1 38 (15.45%) Degree
2 10 (4.07%) Computer Science Degree
3 8 (3.25%) MBA
4 2 (0.81%) AWS Certification
4 2 (0.81%) Master's Degree
4 2 (0.81%) Microsoft Certification
4 2 (0.81%) Postgraduate
Quality Assurance & Compliance
1 24 (9.76%) Data Quality
2 13 (5.28%) QA
3 4 (1.63%) MiFID
4 3 (1.22%) GDPR
System Software
1 8 (3.25%) Docker
2 3 (1.22%) Apache Flume
3 2 (0.81%) Apache ZooKeeper
3 2 (0.81%) Varnish
4 1 (0.41%) HDFS
Systems Management
1 8 (3.25%) Opscode Chef
2 7 (2.85%) Kubernetes
3 4 (1.63%) Ansible
3 4 (1.63%) Puppet
3 4 (1.63%) Terraform
4 3 (1.22%) Oozie
5 1 (0.41%) Control-M
5 1 (0.41%) Hadoop YARN
Vendors
1 66 (26.83%) Tableau
2 56 (22.76%) Microsoft
3 40 (16.26%) Google
4 30 (12.20%) Informatica
4 30 (12.20%) Oracle
5 25 (10.16%) Teradata
6 22 (8.94%) Talend
7 16 (6.50%) SAP
8 15 (6.10%) Databricks
9 13 (5.28%) Netezza
10 8 (3.25%) Sybase
11 6 (2.44%) WorldPay
12 5 (2.03%) Adobe
12 5 (2.03%) Remedy
12 5 (2.03%) Zend
13 4 (1.63%) Twitter
13 4 (1.63%) YouTube
14 3 (1.22%) DataFlux
14 3 (1.22%) Vertica
15 2 (0.81%) Cognos