Period
to 13 April 2021

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 13 April 2021 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK
6 months to
13 Apr 2021
Same period 2020 Same period 2019
Rank 552 668 1043
Rank change year-on-year +116 +375 +56
Permanent jobs citing Snowflake Schema 306 328 87
As % of all permanent jobs advertised in the UK 0.37% 0.29% 0.058%
As % of the Database & Business Intelligence category 1.40% 1.07% 0.21%
Number of salaries quoted 253 294 79
10th Percentile £38,750 £42,875 £35,250
25th Percentile £51,250 £52,500 £42,125
Median annual salary (50th Percentile) £65,000 £68,750 £52,500
Median % change year-on-year -5.45% +30.95% -2.33%
75th Percentile £82,500 £86,250 £63,750
90th Percentile £100,000 £115,000 £80,000
UK excluding London median annual salary £57,500 £60,000 £40,000
% change year-on-year -4.17% +50.00% -15.79%

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,917 30,681 42,357
As % of all permanent IT jobs advertised in the UK 26.39% 26.95% 28.45%
Number of salaries quoted 17,685 25,311 35,070
10th Percentile £33,750 £32,500 £31,250
25th Percentile £41,250 £40,000 £37,500
Median annual salary (50th Percentile) £55,000 £52,500 £52,500
Median % change year-on-year +4.76% - +5.00%
75th Percentile £73,750 £72,500 £70,000
90th Percentile £88,750 £88,750 £85,000
UK excluding London median annual salary £48,500 £45,000 £45,000
% change year-on-year +7.78% - +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 13 April 2021.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 16 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 13 April 2021. 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 +90 286 £67,500 - 53
London +53 171 £70,000 -6.67% 30
UK excluding London +135 115 £57,500 -4.17% 23
Work from Home -78 55 £60,000 -12.73% 5
North of England +49 45 £57,500 -4.17% 8
South East +102 28 £55,000 -15.38% 4
North West +34 26 £60,000 - 6
East of England +65 18 £75,000 +20.00% 5
Midlands +35 13 £57,500 +4.55% 2
West Midlands +26 11 £57,500 +38.55% 1
Yorkshire +5 11 £51,250 -14.58%
North East +22 8 £40,000 -4.76% 2
Scotland +17 8 £47,500 -50.00% 2
Wales +32 2 £36,500 -35.68%
East Midlands +15 2 £44,000 -32.31% 1
South West +22 1 £69,000 - 2

For the 6 months to 13 April 2021, 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 258 (84.31%) Data Warehouse
2 209 (68.30%) SQL
3 195 (63.73%) Business Intelligence
4 179 (58.50%) ETL
5 168 (54.90%) AWS
6 146 (47.71%) Analytics
7 130 (42.48%) Python
8 126 (41.18%) Data Modelling
9 123 (40.20%) Amazon Redshift
10 117 (38.24%) Azure
11 101 (33.01%) Tableau
12 99 (32.35%) Power Platform
13 96 (31.37%) Power BI
14 90 (29.41%) GCP
15 88 (28.76%) Visualisation
16 87 (28.43%) Agile Software Development
17 86 (28.10%) Data Engineering
18 81 (26.47%) Data Science
19 76 (24.84%) Big Data
20 74 (24.18%) Looker
21 66 (21.57%) Data Architecture
22 64 (20.92%) SQL Server
23 54 (17.65%) BigQuery
23 54 (17.65%) Data Visualisation
24 50 (16.34%) Informatica
25 49 (16.01%) Data Analytics
26 48 (15.69%) Data Governance
27 47 (15.36%) Data Lake
27 47 (15.36%) Google
28 46 (15.03%) SQL Server Integration Services

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 27 (8.82%) Apache Spark
2 21 (6.86%) Apache Airflow
3 15 (4.90%) Apache
4 12 (3.92%) Elasticsearch
5 5 (1.63%) SharePoint
6 3 (0.98%) Jupyter
7 1 (0.33%) ArcGIS
7 1 (0.33%) Confluence
7 1 (0.33%) Oracle Workflow
7 1 (0.33%) SAS
Applications
1 7 (2.29%) Microsoft Office
2 6 (1.96%) Microsoft Excel
Business Applications
1 4 (1.31%) Magento
2 3 (0.98%) Sentinel
Cloud Services
1 168 (54.90%) AWS
2 117 (38.24%) Azure
3 99 (32.35%) Power Platform
4 90 (29.41%) GCP
5 32 (10.46%) Matillion
6 27 (8.82%) Amazon S3
7 22 (7.19%) Serverless
8 19 (6.21%) AWS Lambda
9 16 (5.23%) Amazon EMR
10 13 (4.25%) Cloud Computing
11 12 (3.92%) Amazon Kinesis
11 12 (3.92%) AWS CloudFormation
11 12 (3.92%) Trello
12 11 (3.59%) GitHub
12 11 (3.59%) Google Data Studio
13 8 (2.61%) Google Analytics
14 7 (2.29%) Amazon CloudWatch
14 7 (2.29%) Azure Data Factory
15 6 (1.96%) PaaS
16 5 (1.63%) IaaS
Communications & Networking
1 2 (0.65%) FTP
1 2 (0.65%) Internet
Database & Business Intelligence
1 258 (84.31%) Data Warehouse
2 123 (40.20%) Amazon Redshift
3 101 (33.01%) Tableau
4 96 (31.37%) Power BI
5 76 (24.84%) Big Data
6 74 (24.18%) Looker
7 64 (20.92%) SQL Server
8 54 (17.65%) BigQuery
9 47 (15.36%) Data Lake
10 46 (15.03%) SQL Server Integration Services
11 37 (12.09%) NoSQL
12 35 (11.44%) Relational Database
13 28 (9.15%) Amazon Athena
14 27 (8.82%) Data Mining
14 27 (8.82%) SQL Server Reporting Services
15 24 (7.84%) BusinessObjects
16 21 (6.86%) Hadoop
17 19 (6.21%) Amazon QuickSight
17 19 (6.21%) Azure SQL Data Warehouse
18 17 (5.56%) Enterprise Data Warehouse
Development Applications
1 19 (6.21%) Git (software)
2 17 (5.56%) JIRA
3 9 (2.94%) Jenkins
4 4 (1.31%) Spinnaker
5 3 (0.98%) TeamCity
6 2 (0.65%) Cucumber
6 2 (0.65%) Cypress.io
6 2 (0.65%) DBeaver
6 2 (0.65%) ERwin
6 2 (0.65%) Selenium
6 2 (0.65%) SQL Server Management Studio (SSMS)
6 2 (0.65%) WebDriver
7 1 (0.33%) Bitbucket
7 1 (0.33%) ER Studio
7 1 (0.33%) Oracle Forms
7 1 (0.33%) Team Foundation Server
General
1 43 (14.05%) Finance
2 17 (5.56%) Retail
3 14 (4.58%) Marketing
4 13 (4.25%) Banking
5 9 (2.94%) Advertising
5 9 (2.94%) Digital Economy
6 8 (2.61%) Publishing
7 7 (2.29%) Games
8 3 (0.98%) Czech Language
9 2 (0.65%) Manufacturing
9 2 (0.65%) Music Industry
10 1 (0.33%) Automotive
10 1 (0.33%) Back Office
10 1 (0.33%) General Ledger
10 1 (0.33%) Housing Association
10 1 (0.33%) Legal
10 1 (0.33%) Pharmaceutical
10 1 (0.33%) Retail Banking
10 1 (0.33%) Telecoms
Job Titles
1 105 (34.31%) Data Engineer
2 51 (16.67%) Developer
3 40 (13.07%) Analyst
3 40 (13.07%) Architect
4 32 (10.46%) Data Architect
5 27 (8.82%) Data Analyst
6 24 (7.84%) Business Intelligence Developer
7 18 (5.88%) Consultant
8 13 (4.25%) Principal Engineer
9 12 (3.92%) Data Warehouse Developer
10 10 (3.27%) Data Consultant
10 10 (3.27%) Senior Data Engineer
11 9 (2.94%) AWS Architect
11 9 (2.94%) AWS Engineer
12 8 (2.61%) Business Intelligence Analyst
12 8 (2.61%) Senior Analyst
12 8 (2.61%) Senior Developer
12 8 (2.61%) SQL Analyst
13 7 (2.29%) Head of Engineering
13 7 (2.29%) Python Engineer
Libraries, Frameworks & Software Standards
1 27 (8.82%) Kafka
2 22 (7.19%) PySpark
3 19 (6.21%) REST
4 14 (4.58%) HTML
5 13 (4.25%) CSS
6 9 (2.94%) Apache NiFi
7 8 (2.61%) .NET
7 8 (2.61%) Web Services
8 7 (2.29%) Django
9 6 (1.96%) RabbitMQ
9 6 (1.96%) Spark Streaming
10 5 (1.63%) Bulma
10 5 (1.63%) D3.js
10 5 (1.63%) OLE
10 5 (1.63%) Pandas
10 5 (1.63%) Vue.js
11 4 (1.31%) JSON
11 4 (1.31%) React
11 4 (1.31%) RESTful
12 3 (0.98%) Middleware
Miscellaneous
1 34 (11.11%) Analytical Skills
2 16 (5.23%) Data Structures
3 11 (3.59%) Clustering
3 11 (3.59%) Video Conferencing
4 9 (2.94%) Greenfield Project
5 7 (2.29%) Algorithms
6 6 (1.96%) Social Media
7 5 (1.63%) Cloud Native
7 5 (1.63%) User Experience
8 4 (1.31%) Management Information System
9 3 (0.98%) Blog
10 2 (0.65%) Client/Server
10 2 (0.65%) EPoS
10 2 (0.65%) FMCG
10 2 (0.65%) Life Science
10 2 (0.65%) Self-Motivation
10 2 (0.65%) Virtual Team
11 1 (0.33%) Enterprise Software
11 1 (0.33%) Equities
11 1 (0.33%) Replication
Operating Systems
1 3 (0.98%) Unix
2 1 (0.33%) Android
2 1 (0.33%) Apple iOS
2 1 (0.33%) Linux
2 1 (0.33%) Windows
Processes & Methodologies
1 195 (63.73%) Business Intelligence
2 179 (58.50%) ETL
3 146 (47.71%) Analytics
4 126 (41.18%) Data Modelling
5 88 (28.76%) Visualisation
6 87 (28.43%) Agile Software Development
7 86 (28.10%) Data Engineering
8 81 (26.47%) Data Science
9 66 (21.57%) Data Architecture
10 54 (17.65%) Data Visualisation
11 49 (16.01%) Data Analytics
12 48 (15.69%) Data Governance
13 40 (13.07%) Data Analysis
14 34 (11.11%) Migration
15 32 (10.46%) DevOps
15 32 (10.46%) Problem-Solving
16 26 (8.50%) Data Integration
17 25 (8.17%) Data Ingestion
18 24 (7.84%) Performance Tuning
18 24 (7.84%) Stakeholder Management
Programming Languages
1 209 (68.30%) SQL
2 130 (42.48%) Python
3 31 (10.13%) R
4 27 (8.82%) Java
5 14 (4.58%) JavaScript
6 13 (4.25%) Scala
7 11 (3.59%) C
8 8 (2.61%) C#
8 8 (2.61%) PL/SQL
9 5 (1.63%) T-SQL
10 3 (0.98%) C++
11 2 (0.65%) Bash Shell
12 1 (0.33%) Data Analysis Expressions (DAX)
12 1 (0.33%) Go
12 1 (0.33%) MATLAB
12 1 (0.33%) PowerShell
12 1 (0.33%) Shell Script
12 1 (0.33%) VB.NET
12 1 (0.33%) VBA
Qualifications
1 28 (9.15%) Degree
2 8 (2.61%) Master's Degree
3 5 (1.63%) Computer Science Degree
4 2 (0.65%) PhD
5 1 (0.33%) AWS Certification
5 1 (0.33%) DV Cleared
5 1 (0.33%) Numerate Degree
5 1 (0.33%) PMI Certification
5 1 (0.33%) PMP
5 1 (0.33%) SC Cleared
5 1 (0.33%) Security Cleared
5 1 (0.33%) TOGAF Certification
Quality Assurance & Compliance
1 23 (7.52%) Data Quality
2 12 (3.92%) GDPR
3 6 (1.96%) QA
System Software
1 10 (3.27%) Docker
2 7 (2.29%) HDFS
3 2 (0.65%) Active Directory
Systems Management
1 12 (3.92%) Terraform
2 8 (2.61%) Kubernetes
3 4 (1.31%) Ansible
4 2 (0.65%) Kibana
5 1 (0.33%) Hadoop YARN
Vendors
1 50 (16.34%) Informatica
2 47 (15.36%) Google
3 31 (10.13%) Oracle
4 25 (8.17%) Microsoft
5 21 (6.86%) Talend
6 17 (5.56%) Cognos
6 17 (5.56%) Databricks
7 11 (3.59%) SAP
8 9 (2.94%) Alteryx
9 8 (2.61%) Netezza
10 7 (2.29%) Cloudera
10 7 (2.29%) Salesforce.com
11 6 (1.96%) Hortonworks
11 6 (1.96%) MicroStrategy
11 6 (1.96%) MuleSoft
11 6 (1.96%) TIBCO
12 5 (1.63%) Teradata
12 5 (1.63%) Vertica
13 3 (0.98%) Splunk
14 2 (0.65%) Salesforce Marketing Cloud