Period
to 27 September 2020

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 27 September 2020 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK
6 months to
27 Sep 2020
Same period 2019 Same period 2018
Rank 464 954 1053
Rank change year-on-year +490 +99 +115
Permanent jobs citing Snowflake Schema 226 138 117
As % of all permanent jobs advertised in the UK 0.47% 0.098% 0.070%
As % of the Database & Business Intelligence category 1.67% 0.36% 0.24%
Number of salaries quoted 199 131 93
Median annual salary £60,000 £57,500 £52,500
Median salary % change year-on-year +4.35% +9.52% +20.00%
10th Percentile £45,000 £36,250 £34,750
90th Percentile £86,250 £90,000 £73,750
UK excluding London median annual salary £55,000 £52,500 £48,750
% change year-on-year +4.76% +7.69% +21.88%

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 13,533 37,998 49,268
As % of all permanent IT jobs advertised in the UK 28.42% 27.08% 29.65%
Number of salaries quoted 11,303 31,024 40,201
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £33,750 £31,250 £31,250
90th Percentile £90,000 £85,000 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

Snowflake Schema
Job Vacancy Trend

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

Job vacancy trend for Snowflake Schema in the UK

Snowflake Schema
Salary Trend

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

Salary trend for Snowflake Schema in the UK

Snowflake Schema
Salary Histogram

Salary distribution for jobs citing Snowflake Schema over the 6 months to 27 September 2020.

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 27 September 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
England +468 209 £60,000 - 28
London +377 161 £60,000 -15.79% 14
UK excluding London +308 51 £55,000 +4.76% 18
Midlands - 24 £55,000 - 5
West Midlands - 19 £55,000 - 1
Work from Home +76 18 £80,000 - 5
South East +203 10 £55,000 +10.00% 5
North of England +175 10 £52,500 -12.50% 1
North West +119 10 £52,500 -12.50% 1
East Midlands - 5 £75,000 - 4
South West +119 4 £55,000 +4.76%
Wales +54 2 £59,250 -
Scotland +99 1 £47,500 -9.52% 2

For the 6 months to 27 September 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 with a requirement for Snowflake Schema.

1 175 (77.43%) Data Warehouse
2 171 (75.66%) SQL
3 146 (64.60%) Business Intelligence
4 127 (56.19%) AWS
5 123 (54.42%) Data Modelling
6 122 (53.98%) Agile Software Development
6 122 (53.98%) Azure
7 108 (47.79%) Python
8 107 (47.35%) ETL
8 107 (47.35%) Finance
9 80 (35.40%) Amazon Redshift
10 78 (34.51%) Analytics
11 74 (32.74%) GCP
12 72 (31.86%) Data Engineering
13 67 (29.65%) Power BI
13 67 (29.65%) Looker
13 67 (29.65%) Power Platform
14 61 (26.99%) Data Lake
15 59 (26.11%) Big Data
16 57 (25.22%) BigQuery
17 51 (22.57%) SQL Server
18 47 (20.80%) NoSQL
19 46 (20.35%) Performance Tuning
20 44 (19.47%) Data Science
20 44 (19.47%) Tableau
20 44 (19.47%) Git (software)
21 43 (19.03%) Microsoft
21 43 (19.03%) Data Architecture
21 43 (19.03%) Kafka
22 38 (16.81%) Visualisation

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 32 (14.16%) Apache Spark
2 9 (3.98%) Apache
3 7 (3.10%) Apache Airflow
4 5 (2.21%) Elasticsearch
4 5 (2.21%) nginx
4 5 (2.21%) Tomcat
5 1 (0.44%) Apache Pig
Applications
1 1 (0.44%) Microsoft Excel
1 1 (0.44%) Microsoft Office
1 1 (0.44%) SPSS
Business Applications
1 4 (1.77%) Eikon
2 1 (0.44%) Dynamics CRM
Cloud Services
1 127 (56.19%) AWS
2 122 (53.98%) Azure
3 74 (32.74%) GCP
4 67 (29.65%) Power Platform
5 31 (13.72%) SaaS
6 24 (10.62%) Amazon S3
7 15 (6.64%) Serverless
8 13 (5.75%) AWS Lambda
9 11 (4.87%) Trello
10 10 (4.42%) Azure Data Factory
11 6 (2.65%) AWS CloudFormation
12 5 (2.21%) Amazon EC2
12 5 (2.21%) Amazon ECS
12 5 (2.21%) Amazon EKS
13 4 (1.77%) IaaS
13 4 (1.77%) PaaS
14 3 (1.33%) Adobe Analytics
14 3 (1.33%) AdWords
14 3 (1.33%) Google Analytics
15 2 (0.88%) Amazon Kinesis
Communications & Networking
1 1 (0.44%) AMQP
Database & Business Intelligence
1 175 (77.43%) Data Warehouse
2 80 (35.40%) Amazon Redshift
3 67 (29.65%) Looker
3 67 (29.65%) Power BI
4 61 (26.99%) Data Lake
5 59 (26.11%) Big Data
6 57 (25.22%) BigQuery
7 51 (22.57%) SQL Server
8 47 (20.80%) NoSQL
9 36 (15.93%) SQL Server Integration Services
10 29 (12.83%) SQL Server Analysis Services
11 28 (12.39%) Relational Database
12 23 (10.18%) Azure SQL Database
13 21 (9.29%) Flink
13 21 (9.29%) Hadoop
14 19 (8.41%) Amazon Athena
15 16 (7.08%) Azure SQL Data Warehouse
15 16 (7.08%) MongoDB
16 15 (6.64%) Amazon RDS
17 14 (6.19%) Apache Cassandra
Development Applications
1 44 (19.47%) Git (software)
2 31 (13.72%) JIRA
3 7 (3.10%) ERwin
3 7 (3.10%) PowerDesigner
4 5 (2.21%) Jenkins
5 2 (0.88%) Newman
5 2 (0.88%) Postman
5 2 (0.88%) Selenium
General
1 107 (47.35%) Finance
2 36 (15.93%) Marketing
3 16 (7.08%) Banking
4 5 (2.21%) Advertising
5 4 (1.77%) Retail
6 1 (0.44%) Games
6 1 (0.44%) Manufacturing
Job Titles
1 99 (43.81%) Data Engineer
2 44 (19.47%) Developer
3 28 (12.39%) Data Warehouse Developer
4 20 (8.85%) Architect
5 17 (7.52%) AWS Engineer
5 17 (7.52%) Data Architect
5 17 (7.52%) SQL Developer
6 13 (5.75%) Analyst
6 13 (5.75%) Consultant
7 12 (5.31%) Business Intelligence Developer
7 12 (5.31%) Data Analyst
8 11 (4.87%) Azure Engineer
9 9 (3.98%) SQL Analyst
9 9 (3.98%) SQL Data Analyst
10 8 (3.54%) Data Analytics Engineer
10 8 (3.54%) Product Owner
11 7 (3.10%) Business Intelligence Consultant
11 7 (3.10%) Cloud Engineer
11 7 (3.10%) Senior Business Intelligence Developer
11 7 (3.10%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 43 (19.03%) Kafka
2 25 (11.06%) HTML
3 21 (9.29%) .NET
4 20 (8.85%) PySpark
5 19 (8.41%) CSS
6 18 (7.96%) ASP.NET
6 18 (7.96%) ASP.NET Web API
6 18 (7.96%) HTML5
7 15 (6.64%) JSON
8 14 (6.19%) ASP.NET MVC
9 11 (4.87%) MDX
10 10 (4.42%) REST
11 8 (3.54%) XML
12 7 (3.10%) FIX Protocol
12 7 (3.10%) Web Services
13 6 (2.65%) LDAP
14 5 (2.21%) Apache Avro
14 5 (2.21%) GraphQL
14 5 (2.21%) SOAP
15 4 (1.77%) Spark Streaming
Miscellaneous
1 31 (13.72%) Analytical Skills
2 21 (9.29%) Clustering
3 19 (8.41%) Greenfield Project
4 17 (7.52%) Data Structures
5 9 (3.98%) Algorithms
6 8 (3.54%) Foreign Exchange (FX)
7 7 (3.10%) Management Information System
7 7 (3.10%) Reference Data
7 7 (3.10%) Self-Motivation
7 7 (3.10%) Social Media
7 7 (3.10%) Virtual Team
8 6 (2.65%) Cloud Native
8 6 (2.65%) Replication
9 3 (1.33%) Social Network
10 2 (0.88%) Mainframe
10 2 (0.88%) User Experience
10 2 (0.88%) Video Conferencing
11 1 (0.44%) Private Cloud
11 1 (0.44%) Public Cloud
11 1 (0.44%) Reinsurance
Operating Systems
1 7 (3.10%) Unix
2 3 (1.33%) Windows
3 1 (0.44%) Linux
Processes & Methodologies
1 146 (64.60%) Business Intelligence
2 123 (54.42%) Data Modelling
3 122 (53.98%) Agile Software Development
4 107 (47.35%) ETL
5 78 (34.51%) Analytics
6 72 (31.86%) Data Engineering
7 46 (20.35%) Performance Tuning
8 44 (19.47%) Data Science
9 43 (19.03%) Data Architecture
10 38 (16.81%) Visualisation
11 29 (12.83%) User Stories
12 28 (12.39%) DevOps
12 28 (12.39%) Fintech
13 27 (11.95%) Data Integration
14 26 (11.50%) Problem-Solving
14 26 (11.50%) Software Engineering
14 26 (11.50%) Unit Testing
15 22 (9.73%) Data Governance
15 22 (9.73%) Data Management
15 22 (9.73%) SDLC
Programming Languages
1 171 (75.66%) SQL
2 108 (47.79%) Python
3 31 (13.72%) Java
4 26 (11.50%) Data Analysis Expressions (DAX)
5 18 (7.96%) C#
6 11 (4.87%) Scala
7 10 (4.42%) C
8 8 (3.54%) R
9 7 (3.10%) JavaScript
10 6 (2.65%) Shell Script
11 3 (1.33%) C++
11 3 (1.33%) Julia
11 3 (1.33%) PL/SQL
12 1 (0.44%) ANSI SQL
12 1 (0.44%) T-SQL
Qualifications
1 22 (9.73%) Degree
2 13 (5.75%) AWS Certification
3 9 (3.98%) Computer Science Degree
4 8 (3.54%) Master's Degree
5 2 (0.88%) PhD
6 1 (0.44%) Postgraduate
Quality Assurance & Compliance
1 32 (14.16%) Data Quality
2 13 (5.75%) GDPR
3 9 (3.98%) QA
System Software
1 5 (2.21%) Varnish
2 3 (1.33%) Docker
2 3 (1.33%) HDFS
3 2 (0.88%) Apache Flume
Systems Management
1 6 (2.65%) Control-M
2 5 (2.21%) Kubernetes
3 2 (0.88%) Ansible
3 2 (0.88%) Terraform
4 1 (0.44%) Opscode Chef
4 1 (0.44%) Puppet
Vendors
1 44 (19.47%) Tableau
2 43 (19.03%) Microsoft
3 24 (10.62%) Google
3 24 (10.62%) Oracle
4 17 (7.52%) Databricks
5 14 (6.19%) Informatica
6 11 (4.87%) SAP
7 8 (3.54%) Teradata
8 5 (2.21%) Vertica
9 4 (1.77%) MicroStrategy
10 3 (1.33%) Cloudera
10 3 (1.33%) Coremetrics
10 3 (1.33%) Crimson Hexagon
10 3 (1.33%) Facebook
10 3 (1.33%) SnapLogic
10 3 (1.33%) Splunk
11 2 (0.88%) Alteryx
11 2 (0.88%) IBM
11 2 (0.88%) Netezza
11 2 (0.88%) Talend