Period
to 28 October 2020

The following table provides summary statistics for permanent job vacancies advertised in England 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 28 October 2020 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK > England
6 months to
28 Oct 2020
Same period 2019 Same period 2018
Rank 456 881 1010
Rank change year-on-year +425 +129 +125
Permanent jobs citing Snowflake Schema 222 164 114
As % of all permanent jobs advertised in England 0.49% 0.13% 0.075%
As % of the Database & Business Intelligence category 1.70% 0.48% 0.25%
Number of salaries quoted 193 146 91
Median annual salary £60,000 £60,000 £52,500
Median salary % change year-on-year - +14.29% +5.00%
10th Percentile £45,000 £37,250 £34,750
90th Percentile £90,000 £93,750 £73,750
UK median annual salary £62,500 £60,000 £52,500
% change year-on-year +4.17% +14.29% +2.44%

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 advertised in England with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
England
Permanent vacancies with a requirement for database or business intelligence skills 13,037 34,419 45,136
As % of all permanent IT jobs advertised in England 28.64% 27.19% 29.59%
Number of salaries quoted 11,040 28,705 36,972
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% -
10th Percentile £34,225 £31,500 £31,250
90th Percentile £90,000 £86,250 £85,000
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +4.17%

Snowflake Schema
Job Vacancy Trend in England

Job postings citing Snowflake Schema as a proportion of all IT jobs advertised in England.

Job vacancy trend for Snowflake Schema in England

Snowflake Schema
Salary Trend in England

3-month moving average salary quoted in jobs citing Snowflake Schema in England.

Salary trend for Snowflake Schema in England

Snowflake Schema
Salary Histogram in England

Salary distribution for jobs citing Snowflake Schema in England over the 6 months to 28 October 2020.

Salary histogram for Snowflake Schema in England

Snowflake Schema
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the England region over the 6 months to 28 October 2020. 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
London +351 164 £62,500 -16.67% 15
North of England +160 21 £57,500 -4.17% 10
North West +104 19 £55,000 -8.33% 7
Midlands +141 16 £62,500 +60.26%
South East +219 14 £55,000 +10.00% 1
West Midlands +105 8 £55,000 +41.03%
East Midlands - 8 £75,000 -
South West +106 4 £55,000 +4.76%
East of England - 3 £67,500 - 3
Yorkshire +127 2 £82,500 +3.13% 2
Snowflake Schema
UK

For the 6 months to 28 October 2020, 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 across the England region with a requirement for Snowflake Schema.

1 187 (84.23%) Data Warehouse
2 169 (76.13%) SQL
3 142 (63.96%) AWS
4 134 (60.36%) Business Intelligence
5 122 (54.95%) ETL
6 115 (51.80%) Data Modelling
6 115 (51.80%) Agile Software Development
7 108 (48.65%) Amazon Redshift
8 105 (47.30%) Python
9 104 (46.85%) Azure
10 87 (39.19%) Finance
11 81 (36.49%) GCP
12 70 (31.53%) Analytics
13 69 (31.08%) Data Engineering
14 65 (29.28%) Looker
14 65 (29.28%) Big Data
15 61 (27.48%) BigQuery
16 57 (25.68%) Data Lake
17 55 (24.77%) Power BI
17 55 (24.77%) Power Platform
18 54 (24.32%) NoSQL
19 49 (22.07%) Visualisation
20 47 (21.17%) Tableau
21 43 (19.37%) Data Architecture
21 43 (19.37%) Data Science
22 42 (18.92%) Performance Tuning
23 38 (17.12%) SQL Server
24 37 (16.67%) Kafka
25 35 (15.77%) JIRA
26 33 (14.86%) Git (software)

Snowflake Schema
Co-occurring IT Skills in England 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 30 (13.51%) Apache Spark
2 17 (7.66%) Apache
3 12 (5.41%) Elasticsearch
4 8 (3.60%) Apache Airflow
5 7 (3.15%) nginx
5 7 (3.15%) Tomcat
6 1 (0.45%) Apache Pig
6 1 (0.45%) SharePoint
Applications
1 3 (1.35%) Microsoft Excel
Business Applications
1 4 (1.80%) Eikon
2 1 (0.45%) Dynamics CRM
2 1 (0.45%) Sentinel
Cloud Services
1 142 (63.96%) AWS
2 104 (46.85%) Azure
3 81 (36.49%) GCP
4 55 (24.77%) Power Platform
5 32 (14.41%) Amazon S3
6 28 (12.61%) SaaS
7 23 (10.36%) Serverless
8 21 (9.46%) AWS Lambda
9 16 (7.21%) Trello
10 10 (4.50%) AWS CloudFormation
11 9 (4.05%) Amazon EMR
11 9 (4.05%) Azure Data Factory
12 7 (3.15%) Amazon EC2
12 7 (3.15%) Amazon ECS
12 7 (3.15%) Amazon EKS
13 3 (1.35%) IaaS
13 3 (1.35%) PaaS
14 2 (0.90%) Amazon Kinesis
14 2 (0.90%) AWS Step Functions
15 1 (0.45%) OpenShift
Communications & Networking
1 1 (0.45%) AMQP
Database & Business Intelligence
1 187 (84.23%) Data Warehouse
2 108 (48.65%) Amazon Redshift
3 65 (29.28%) Big Data
3 65 (29.28%) Looker
4 61 (27.48%) BigQuery
5 57 (25.68%) Data Lake
6 55 (24.77%) Power BI
7 54 (24.32%) NoSQL
8 47 (21.17%) Tableau
9 38 (17.12%) SQL Server
10 27 (12.16%) Relational Database
10 27 (12.16%) SQL Server Integration Services
11 24 (10.81%) Amazon Athena
12 22 (9.91%) Azure SQL Database
13 20 (9.01%) Flink
14 18 (8.11%) Azure SQL Data Warehouse
15 16 (7.21%) Amazon RDS
16 15 (6.76%) Hadoop
16 15 (6.76%) SQL Server Analysis Services
17 13 (5.86%) MongoDB
Development Applications
1 35 (15.77%) JIRA
2 33 (14.86%) Git (software)
3 6 (2.70%) Jenkins
4 3 (1.35%) ERwin
4 3 (1.35%) PowerDesigner
5 2 (0.90%) Newman
5 2 (0.90%) Postman
5 2 (0.90%) Selenium
General
1 87 (39.19%) Finance
2 30 (13.51%) Marketing
3 22 (9.91%) Banking
4 7 (3.15%) Retail
5 6 (2.70%) Advertising
5 6 (2.70%) Digital Economy
6 1 (0.45%) Automotive
6 1 (0.45%) Games
6 1 (0.45%) Pharmaceutical
6 1 (0.45%) Telecoms
Job Titles
1 107 (48.20%) Data Engineer
2 39 (17.57%) Developer
3 23 (10.36%) Architect
4 22 (9.91%) Data Warehouse Developer
5 20 (9.01%) Data Architect
6 16 (7.21%) SQL Developer
7 14 (6.31%) Analyst
7 14 (6.31%) AWS Engineer
7 14 (6.31%) Consultant
8 13 (5.86%) Data Analyst
9 12 (5.41%) Business Intelligence Developer
10 10 (4.50%) Azure Engineer
11 9 (4.05%) SQL Analyst
11 9 (4.05%) SQL Data Analyst
12 8 (3.60%) Business Intelligence Consultant
13 7 (3.15%) Lead Developer
13 7 (3.15%) Senior Architect
13 7 (3.15%) Senior Data Architect
13 7 (3.15%) Senior Data Engineer
13 7 (3.15%) Solutions Architect
Libraries, Frameworks & Software Standards
1 37 (16.67%) Kafka
2 22 (9.91%) PySpark
3 15 (6.76%) HTML
4 12 (5.41%) JSON
4 12 (5.41%) REST
5 11 (4.95%) .NET
6 10 (4.50%) Web Services
7 9 (4.05%) MDX
8 8 (3.60%) LDAP
9 7 (3.15%) Apache Avro
9 7 (3.15%) Apache NiFi
9 7 (3.15%) ASP.NET
9 7 (3.15%) ASP.NET Web API
9 7 (3.15%) CSS
9 7 (3.15%) GraphQL
9 7 (3.15%) HTML5
9 7 (3.15%) SOAP
10 6 (2.70%) ASP.NET MVC
11 3 (1.35%) D3.js
11 3 (1.35%) Spark Streaming
Miscellaneous
1 28 (12.61%) Analytical Skills
2 20 (9.01%) Clustering
3 18 (8.11%) Data Structures
3 18 (8.11%) Greenfield Project
4 9 (4.05%) Self-Motivation
5 8 (3.60%) Cloud Native
5 8 (3.60%) Replication
6 7 (3.15%) Social Media
6 7 (3.15%) Virtual Team
7 6 (2.70%) Algorithms
8 4 (1.80%) Foreign Exchange (FX)
8 4 (1.80%) Video Conferencing
9 3 (1.35%) Management Information System
9 3 (1.35%) Public Cloud
9 3 (1.35%) Reference Data
10 2 (0.90%) FMCG
10 2 (0.90%) User Experience
11 1 (0.45%) Life Science
11 1 (0.45%) Private Cloud
11 1 (0.45%) Reinsurance
Operating Systems
1 7 (3.15%) Unix
2 5 (2.25%) Windows
3 1 (0.45%) Linux
Processes & Methodologies
1 134 (60.36%) Business Intelligence
2 122 (54.95%) ETL
3 115 (51.80%) Agile Software Development
3 115 (51.80%) Data Modelling
4 70 (31.53%) Analytics
5 69 (31.08%) Data Engineering
6 49 (22.07%) Visualisation
7 43 (19.37%) Data Architecture
7 43 (19.37%) Data Science
8 42 (18.92%) Performance Tuning
9 26 (11.71%) Data Integration
10 25 (11.26%) Data Governance
11 22 (9.91%) Data Management
11 22 (9.91%) DevOps
11 22 (9.91%) Fintech
12 21 (9.46%) Sprint Planning
12 21 (9.46%) Unit Testing
12 21 (9.46%) User Stories
13 20 (9.01%) Data Visualisation
13 20 (9.01%) SDLC
Programming Languages
1 169 (76.13%) SQL
2 105 (47.30%) Python
3 19 (8.56%) Java
4 13 (5.86%) C#
5 12 (5.41%) Data Analysis Expressions (DAX)
6 10 (4.50%) C
7 9 (4.05%) Scala
8 6 (2.70%) JavaScript
9 4 (1.80%) PL/SQL
9 4 (1.80%) Shell Script
10 3 (1.35%) Julia
10 3 (1.35%) R
10 3 (1.35%) T-SQL
11 1 (0.45%) ANSI SQL
11 1 (0.45%) Go
Qualifications
1 17 (7.66%) Degree
2 8 (3.60%) AWS Certification
3 4 (1.80%) Computer Science Degree
3 4 (1.80%) Master's Degree
4 2 (0.90%) Postgraduate
5 1 (0.45%) PhD
Quality Assurance & Compliance
1 16 (7.21%) Data Quality
2 14 (6.31%) GDPR
3 5 (2.25%) QA
System Software
1 7 (3.15%) Varnish
2 3 (1.35%) Docker
2 3 (1.35%) HDFS
3 1 (0.45%) Apache Flume
Systems Management
1 5 (2.25%) Kubernetes
2 4 (1.80%) Control-M
3 2 (0.90%) Ansible
3 2 (0.90%) Terraform
4 1 (0.45%) Opscode Chef
4 1 (0.45%) Puppet
Vendors
1 30 (13.51%) Microsoft
2 24 (10.81%) Google
2 24 (10.81%) Oracle
3 18 (8.11%) Databricks
4 13 (5.86%) Informatica
5 9 (4.05%) Teradata
6 7 (3.15%) Vertica
7 6 (2.70%) Talend
8 3 (1.35%) Cloudera
8 3 (1.35%) Cognos
8 3 (1.35%) MicroStrategy
8 3 (1.35%) Netezza
8 3 (1.35%) Splunk
9 2 (0.90%) SnapLogic
10 1 (0.45%) Ab Initio
10 1 (0.45%) Alteryx
10 1 (0.45%) Hortonworks
10 1 (0.45%) IBM
10 1 (0.45%) Red Hat
10 1 (0.45%) Sybase