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

Snowflake Schema
UK
6 months to
5 Jul 2020
Same period 2019 Same period 2018
Rank 580 1020 1103
Rank change year-on-year +440 +83 +52
Permanent jobs citing Snowflake Schema 271 92 122
As % of all permanent jobs advertised in the UK 0.34% 0.062% 0.069%
As % of the Database & Business Intelligence category 1.28% 0.23% 0.22%
Number of salaries quoted 245 91 92
Median annual salary £65,000 £52,500 £52,500
Median salary % change year-on-year +23.81% - +23.53%
10th Percentile £45,500 £35,250 £33,825
90th Percentile £91,250 £90,000 £76,250
UK excluding London median annual salary £57,500 £47,500 £45,000
% change year-on-year +21.05% +5.56% +12.50%

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 21,247 40,780 54,380
As % of all permanent IT jobs advertised in the UK 26.95% 27.68% 30.55%
Number of salaries quoted 17,311 33,413 44,536
Median annual salary £55,000 £52,000 £50,000
Median salary % change year-on-year +5.77% +4.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £90,000 £85,000 £81,250
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 5 July 2020.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 15 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 5 July 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 +432 262 £65,000 +23.81% 17
London +297 197 £67,500 +12.50% 9
UK excluding London +267 67 £57,500 +21.05% 9
Midlands - 28 £55,000 - 2
North of England +151 21 £57,500 +15.00% 3
West Midlands - 19 £55,000 - 1
Work from Home +79 12 £75,000 -13.04% 2
Yorkshire +123 10 £60,000 -7.69%
North West +111 10 £57,500 +15.00% 3
East Midlands - 9 £75,000 - 1
East of England +106 8 £47,500 +11.76% 1
South East +149 6 £65,000 +68.83% 1
South West +107 2 - - 1
Wales +24 2 £56,750 -
North East - 1 £42,000 -

For the 6 months to 5 July 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 218 (80.44%) SQL
2 207 (76.38%) Data Warehouse
3 178 (65.68%) Business Intelligence
4 166 (61.25%) ETL
5 165 (60.89%) Data Modelling
6 141 (52.03%) Python
7 139 (51.29%) AWS
8 135 (49.82%) Azure
9 114 (42.07%) Analytics
10 113 (41.70%) Agile Software Development
11 112 (41.33%) Finance
12 101 (37.27%) Power BI
12 101 (37.27%) Power Platform
13 98 (36.16%) SQL Server
14 94 (34.69%) Amazon Redshift
15 91 (33.58%) Data Lake
16 85 (31.37%) Data Engineering
17 78 (28.78%) GCP
17 78 (28.78%) SQL Server Integration Services
18 69 (25.46%) Tableau
19 66 (24.35%) Microsoft
19 66 (24.35%) Looker
20 64 (23.62%) BigQuery
20 64 (23.62%) Java
21 61 (22.51%) Analytical Skills
22 57 (21.03%) Data Science
23 55 (20.30%) Big Data
23 55 (20.30%) Fintech
23 55 (20.30%) Data Governance
24 54 (19.93%) Data Quality

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 37 (13.65%) Apache Spark
2 28 (10.33%) Apache Airflow
3 14 (5.17%) Elasticsearch
4 13 (4.80%) Apache
5 4 (1.48%) nginx
5 4 (1.48%) Tomcat
6 3 (1.11%) Oracle Workflow
6 3 (1.11%) SharePoint
7 2 (0.74%) Confluence
7 2 (0.74%) Luigi
8 1 (0.37%) Apache Pig
Applications
1 4 (1.48%) Microsoft Office
2 3 (1.11%) Microsoft Excel
3 1 (0.37%) SPSS
Business Applications
1 4 (1.48%) Eikon
2 2 (0.74%) Raiser's Edge
3 1 (0.37%) Dynamics CRM
3 1 (0.37%) NetSuite
Cloud Services
1 139 (51.29%) AWS
2 135 (49.82%) Azure
3 101 (37.27%) Power Platform
4 78 (28.78%) GCP
5 41 (15.13%) SaaS
6 36 (13.28%) Azure Data Factory
7 25 (9.23%) Amazon S3
8 11 (4.06%) Serverless
9 6 (2.21%) Amazon EC2
9 6 (2.21%) AWS Lambda
10 5 (1.85%) Amazon EKS
10 5 (1.85%) Amazon Kinesis
11 4 (1.48%) Amazon ECS
12 3 (1.11%) Adobe Analytics
12 3 (1.11%) AdWords
12 3 (1.11%) Amazon EMR
12 3 (1.11%) Cloud Computing
12 3 (1.11%) Google Analytics
12 3 (1.11%) Office 365
12 3 (1.11%) Trello
Database & Business Intelligence
1 207 (76.38%) Data Warehouse
2 101 (37.27%) Power BI
3 98 (36.16%) SQL Server
4 94 (34.69%) Amazon Redshift
5 91 (33.58%) Data Lake
6 78 (28.78%) SQL Server Integration Services
7 66 (24.35%) Looker
8 64 (23.62%) BigQuery
9 55 (20.30%) Big Data
10 48 (17.71%) NoSQL
11 44 (16.24%) SQL Server Analysis Services
12 42 (15.50%) Azure SQL Database
13 37 (13.65%) Relational Database
14 30 (11.07%) OLAP
15 25 (9.23%) Apache Cassandra
15 25 (9.23%) OLTP
16 24 (8.86%) Amazon Athena
16 24 (8.86%) MongoDB
17 23 (8.49%) Hadoop
17 23 (8.49%) RDBMS
Development Applications
1 31 (11.44%) Git (software)
2 19 (7.01%) JIRA
3 16 (5.90%) ERwin
4 15 (5.54%) PowerDesigner
5 8 (2.95%) Jenkins
6 5 (1.85%) Flyway
6 5 (1.85%) Liquibase
7 2 (0.74%) Bitbucket
8 1 (0.37%) Oracle APEX
8 1 (0.37%) Spinnaker
8 1 (0.37%) TeamCity
General
1 112 (41.33%) Finance
2 43 (15.87%) Marketing
3 15 (5.54%) Advertising
4 9 (3.32%) Banking
5 6 (2.21%) Legal
6 5 (1.85%) Retail
7 2 (0.74%) Public Sector
8 1 (0.37%) Games
8 1 (0.37%) Local Government
8 1 (0.37%) Manufacturing
8 1 (0.37%) Publishing
Job Titles
1 114 (42.07%) Data Engineer
2 48 (17.71%) Architect
3 47 (17.34%) Developer
4 45 (16.61%) Data Architect
5 28 (10.33%) Azure Engineer
6 18 (6.64%) Business Intelligence Developer
7 16 (5.90%) Data Warehouse Developer
8 15 (5.54%) Analyst
8 15 (5.54%) AWS Engineer
9 14 (5.17%) Informatica Specialist
9 14 (5.17%) Technical Specialist
10 13 (4.80%) Cloud Engineer
10 13 (4.80%) Senior Data Warehouse Specialist
10 13 (4.80%) Senior Informatica Specialist
10 13 (4.80%) Senior Technical Specialist
10 13 (4.80%) Senior Unix Technical Specialist
11 12 (4.43%) ETL Developer
11 12 (4.43%) SQL Developer
12 11 (4.06%) Data Warehouse Architect
13 10 (3.69%) Senior Data Engineer
Libraries, Frameworks & Software Standards
1 47 (17.34%) Kafka
2 27 (9.96%) MDX
3 24 (8.86%) JSON
4 22 (8.12%) PySpark
5 21 (7.75%) .NET
6 20 (7.38%) HTML
7 19 (7.01%) CSS
8 18 (6.64%) ASP.NET
8 18 (6.64%) ASP.NET Web API
8 18 (6.64%) HTML5
9 17 (6.27%) Web Services
9 17 (6.27%) XML
10 15 (5.54%) FIX Protocol
11 14 (5.17%) ASP.NET MVC
12 13 (4.80%) J2EE
13 9 (3.32%) Apache NiFi
14 8 (2.95%) REST
15 5 (1.85%) RabbitMQ
16 4 (1.48%) Apache Avro
16 4 (1.48%) SOAP
Miscellaneous
1 61 (22.51%) Analytical Skills
2 38 (14.02%) Greenfield Project
3 17 (6.27%) Reference Data
4 16 (5.90%) Data Structures
4 16 (5.90%) Management Information System
5 12 (4.43%) Foreign Exchange (FX)
6 11 (4.06%) Self-Motivation
7 10 (3.69%) Clustering
8 5 (1.85%) Algorithms
8 5 (1.85%) Cloud Native
8 5 (1.85%) Replication
9 3 (1.11%) Social Network
9 3 (1.11%) User Experience
10 2 (0.74%) Mainframe
11 1 (0.37%) Social Media
Operating Systems
1 16 (5.90%) Unix
2 3 (1.11%) Linux
3 2 (0.74%) Windows
Processes & Methodologies
1 178 (65.68%) Business Intelligence
2 166 (61.25%) ETL
3 165 (60.89%) Data Modelling
4 114 (42.07%) Analytics
5 113 (41.70%) Agile Software Development
6 85 (31.37%) Data Engineering
7 57 (21.03%) Data Science
8 55 (20.30%) Data Governance
8 55 (20.30%) Fintech
9 53 (19.56%) Data Architecture
10 44 (16.24%) Visualisation
11 40 (14.76%) Problem-Solving
12 34 (12.55%) Data Transformation
12 34 (12.55%) Stakeholder Management
13 33 (12.18%) Software Engineering
14 31 (11.44%) Migration
15 29 (10.70%) Data Management
15 29 (10.70%) DevOps
16 28 (10.33%) Computer Science
17 27 (9.96%) User Stories
Programming Languages
1 218 (80.44%) SQL
2 141 (52.03%) Python
3 64 (23.62%) Java
4 27 (9.96%) C#
5 24 (8.86%) Data Analysis Expressions (DAX)
5 24 (8.86%) Scala
6 21 (7.75%) R
7 14 (5.17%) Shell Script
8 13 (4.80%) PL/SQL
9 8 (2.95%) JavaScript
9 8 (2.95%) T-SQL
10 6 (2.21%) C
11 3 (1.11%) C++
12 2 (0.74%) PowerShell
12 2 (0.74%) Ruby
13 1 (0.37%) Bash Shell
13 1 (0.37%) Go
13 1 (0.37%) Java 8
13 1 (0.37%) VBA
Qualifications
1 37 (13.65%) Degree
2 20 (7.38%) Computer Science Degree
3 18 (6.64%) AWS Certification
4 15 (5.54%) Master's Degree
5 3 (1.11%) MBA
5 3 (1.11%) PhD
6 2 (0.74%) Postgraduate
Quality Assurance & Compliance
1 54 (19.93%) Data Quality
2 16 (5.90%) QA
3 7 (2.58%) GDPR
System Software
1 11 (4.06%) Docker
2 4 (1.48%) Varnish
3 3 (1.11%) HDFS
4 2 (0.74%) Apache Flume
Systems Management
1 11 (4.06%) Terraform
2 7 (2.58%) Kubernetes
3 4 (1.48%) Control-M
4 3 (1.11%) Opscode Chef
4 3 (1.11%) Puppet
5 2 (0.74%) Hadoop YARN
Vendors
1 69 (25.46%) Tableau
2 66 (24.35%) Microsoft
3 54 (19.93%) Oracle
4 34 (12.55%) Informatica
5 29 (10.70%) Databricks
5 29 (10.70%) Google
6 17 (6.27%) SnapLogic
7 15 (5.54%) Talend
8 13 (4.80%) SAP
9 9 (3.32%) Vertica
10 8 (2.95%) Netezza
10 8 (2.95%) Teradata
11 7 (2.58%) Alteryx
11 7 (2.58%) MicroStrategy
12 6 (2.21%) IBM
13 5 (1.85%) Cognos
14 4 (1.48%) Sybase
15 3 (1.11%) Coremetrics
15 3 (1.11%) Crimson Hexagon
15 3 (1.11%) Facebook