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

Snowflake Schema
UK
6 months to
27 Jan 2021
Same period 2020 Same period 2019
Rank 520 725 1022
Rank change year-on-year +205 +297 +86
Permanent jobs citing Snowflake Schema 271 291 105
As % of all permanent jobs advertised in the UK 0.42% 0.23% 0.070%
As % of the Database & Business Intelligence category 1.52% 0.86% 0.24%
Number of salaries quoted 268 253 86
Median annual salary £65,000 £67,500 £55,000
Median salary % change year-on-year -3.70% +22.73% +4.76%
10th Percentile £45,000 £42,500 £36,375
90th Percentile £96,500 £115,000 £80,000
UK excluding London median annual salary £60,000 £57,500 £50,000
% change year-on-year +4.35% +15.00% -

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 17,836 33,842 43,169
As % of all permanent IT jobs advertised in the UK 27.32% 27.11% 28.81%
Number of salaries quoted 14,946 28,006 35,845
Median annual salary £55,000 £52,500 £52,500
Median salary % change year-on-year +4.76% - +9.38%
10th Percentile £33,750 £32,000 £31,250
90th Percentile £87,500 £88,750 £85,000
UK excluding London median annual salary £49,000 £45,000 £45,000
% change year-on-year +8.89% - +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 January 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 27 January 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 +233 254 £65,000 - 36
London +176 174 £65,000 -13.33% 18
UK excluding London +185 80 £60,000 +4.35% 18
Work from Home -35 45 £67,500 - 7
North of England +75 33 £60,000 - 9
South East +159 24 £55,000 +37.50% 1
North West +46 24 £60,000 - 6
East of England +101 9 £70,000 +12.00% 1
Midlands +85 8 £68,750 +78.57% 5
Yorkshire +54 6 £80,000 +10.34% 1
East Midlands +62 5 £62,000 -4.62% 2
West Midlands +51 3 £78,750 +107.24% 3
North East - 3 £57,500 - 2
South West +67 2 £55,000 +4.76% 2
Wales +44 2 £37,000 -29.52%
Scotland +35 2 £57,500 +9.52%

For the 6 months to 27 January 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 232 (85.61%) Data Warehouse
2 184 (67.90%) SQL
3 176 (64.94%) AWS
4 164 (60.52%) Business Intelligence
5 154 (56.83%) ETL
6 130 (47.97%) Data Modelling
6 130 (47.97%) Amazon Redshift
7 113 (41.70%) Analytics
7 113 (41.70%) Python
8 112 (41.33%) Azure
9 105 (38.75%) Agile Software Development
10 88 (32.47%) GCP
11 80 (29.52%) Looker
12 77 (28.41%) Data Engineering
13 71 (26.20%) Visualisation
14 70 (25.83%) Big Data
15 69 (25.46%) Data Science
16 61 (22.51%) Power Platform
16 61 (22.51%) Power BI
17 59 (21.77%) Tableau
17 59 (21.77%) BigQuery
18 58 (21.40%) Data Architecture
19 52 (19.19%) Finance
20 50 (18.45%) NoSQL
21 44 (16.24%) Performance Tuning
22 42 (15.50%) Data Lake
23 41 (15.13%) Google
24 40 (14.76%) Data Governance
25 39 (14.39%) Data Visualisation
25 39 (14.39%) JIRA

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 33 (12.18%) Apache Spark
2 20 (7.38%) Apache
3 17 (6.27%) Apache Airflow
4 12 (4.43%) Elasticsearch
5 4 (1.48%) SharePoint
6 3 (1.11%) nginx
6 3 (1.11%) Tomcat
7 1 (0.37%) Apache Pig
7 1 (0.37%) ArcGIS
7 1 (0.37%) Oracle Workflow
Applications
1 4 (1.48%) Microsoft Excel
2 2 (0.74%) Microsoft Office
Business Applications
1 1 (0.37%) Sentinel
Cloud Services
1 176 (64.94%) AWS
2 112 (41.33%) Azure
3 88 (32.47%) GCP
4 61 (22.51%) Power Platform
5 28 (10.33%) Amazon S3
6 27 (9.96%) Serverless
7 25 (9.23%) Trello
8 23 (8.49%) AWS Lambda
9 13 (4.80%) AWS CloudFormation
10 9 (3.32%) Amazon EMR
11 7 (2.58%) PaaS
11 7 (2.58%) SaaS
12 6 (2.21%) Cloud Computing
12 6 (2.21%) IaaS
13 5 (1.85%) Azure Data Factory
14 4 (1.48%) Amazon EC2
14 4 (1.48%) Amazon Kinesis
15 3 (1.11%) Amazon ECS
15 3 (1.11%) Amazon EKS
16 2 (0.74%) Azure Active Directory
Database & Business Intelligence
1 232 (85.61%) Data Warehouse
2 130 (47.97%) Amazon Redshift
3 80 (29.52%) Looker
4 70 (25.83%) Big Data
5 61 (22.51%) Power BI
6 59 (21.77%) BigQuery
6 59 (21.77%) Tableau
7 50 (18.45%) NoSQL
8 42 (15.50%) Data Lake
9 38 (14.02%) SQL Server
10 33 (12.18%) SQL Server Integration Services
11 27 (9.96%) Amazon Athena
11 27 (9.96%) Relational Database
12 20 (7.38%) Hadoop
13 19 (7.01%) BusinessObjects
14 17 (6.27%) Amazon QuickSight
15 16 (5.90%) Azure SQL Data Warehouse
16 15 (5.54%) Amazon RDS
16 15 (5.54%) MongoDB
17 14 (5.17%) Apache Hive
Development Applications
1 39 (14.39%) JIRA
2 29 (10.70%) Git (software)
3 6 (2.21%) Jenkins
4 4 (1.48%) Selenium
5 2 (0.74%) Cucumber
5 2 (0.74%) Cypress.io
5 2 (0.74%) Newman
5 2 (0.74%) Postman
5 2 (0.74%) SQL Server Management Studio (SSMS)
5 2 (0.74%) TeamCity
5 2 (0.74%) WebDriver
6 1 (0.37%) ERwin
6 1 (0.37%) Oracle Forms
6 1 (0.37%) Team Foundation Server
General
1 52 (19.19%) Finance
2 23 (8.49%) Marketing
3 20 (7.38%) Retail
4 13 (4.80%) Banking
5 10 (3.69%) Digital Economy
6 7 (2.58%) Games
7 5 (1.85%) Advertising
8 2 (0.74%) Automotive
8 2 (0.74%) Music Industry
8 2 (0.74%) Publishing
9 1 (0.37%) General Ledger
9 1 (0.37%) Housing Association
9 1 (0.37%) Manufacturing
9 1 (0.37%) Pharmaceutical
9 1 (0.37%) Retail Banking
9 1 (0.37%) Telecoms
Job Titles
1 110 (40.59%) Data Engineer
2 42 (15.50%) Developer
3 27 (9.96%) Architect
4 26 (9.59%) Consultant
5 23 (8.49%) Data Warehouse Developer
6 21 (7.75%) Analyst
7 20 (7.38%) Data Architect
8 14 (5.17%) Data Consultant
9 13 (4.80%) SQL Developer
10 12 (4.43%) Business Intelligence Consultant
10 12 (4.43%) Principal Engineer
11 11 (4.06%) AWS Engineer
11 11 (4.06%) Business Intelligence Developer
11 11 (4.06%) Data Analyst
12 10 (3.69%) Senior Data Engineer
13 8 (2.95%) AWS Architect
13 8 (2.95%) Business Intelligence Analyst
13 8 (2.95%) Data Warehouse Consultant
13 8 (2.95%) Solutions Architect
14 7 (2.58%) Senior Analyst
Libraries, Frameworks & Software Standards
1 29 (10.70%) Kafka
2 18 (6.64%) PySpark
3 13 (4.80%) HTML
4 9 (3.32%) Apache NiFi
4 9 (3.32%) LDAP
5 8 (2.95%) Web Services
6 7 (2.58%) RabbitMQ
6 7 (2.58%) REST
7 5 (1.85%) .NET
7 5 (1.85%) JSON
8 4 (1.48%) CSS
8 4 (1.48%) GraphQL
8 4 (1.48%) Spark Streaming
9 3 (1.11%) Apache Avro
9 3 (1.11%) RESTful
9 3 (1.11%) SOAP
10 2 (0.74%) ASP.NET Web API
10 2 (0.74%) Entity Framework
10 2 (0.74%) Gherkin
10 2 (0.74%) Node.js
Miscellaneous
1 24 (8.86%) Analytical Skills
1 24 (8.86%) Clustering
2 11 (4.06%) Social Media
3 10 (3.69%) Data Structures
3 10 (3.69%) Video Conferencing
4 8 (2.95%) Cloud Native
5 7 (2.58%) Algorithms
5 7 (2.58%) Self-Motivation
6 6 (2.21%) User Experience
7 5 (1.85%) Greenfield Project
7 5 (1.85%) Virtual Team
8 3 (1.11%) Public Cloud
8 3 (1.11%) Replication
9 2 (0.74%) FMCG
10 1 (0.37%) Enterprise Software
10 1 (0.37%) Equities
10 1 (0.37%) Foreign Exchange (FX)
10 1 (0.37%) Life Science
10 1 (0.37%) Management Information System
10 1 (0.37%) Reinsurance
Operating Systems
1 9 (3.32%) Unix
2 4 (1.48%) Windows
3 1 (0.37%) Android
3 1 (0.37%) Apple iOS
3 1 (0.37%) Linux
Processes & Methodologies
1 164 (60.52%) Business Intelligence
2 154 (56.83%) ETL
3 130 (47.97%) Data Modelling
4 113 (41.70%) Analytics
5 105 (38.75%) Agile Software Development
6 77 (28.41%) Data Engineering
7 71 (26.20%) Visualisation
8 69 (25.46%) Data Science
9 58 (21.40%) Data Architecture
10 44 (16.24%) Performance Tuning
11 40 (14.76%) Data Governance
12 39 (14.39%) Data Visualisation
13 31 (11.44%) Actionable Insight
13 31 (11.44%) Data Ingestion
14 30 (11.07%) Data Analytics
14 30 (11.07%) Sprint Planning
15 29 (10.70%) Data Integration
16 26 (9.59%) Data Analysis
17 25 (9.23%) Migration
18 24 (8.86%) DevOps
Programming Languages
1 184 (67.90%) SQL
2 113 (41.70%) Python
3 24 (8.86%) Java
4 18 (6.64%) C
5 13 (4.80%) Scala
6 12 (4.43%) C#
6 12 (4.43%) R
7 10 (3.69%) JavaScript
8 8 (2.95%) PL/SQL
9 5 (1.85%) Shell Script
10 4 (1.48%) T-SQL
11 3 (1.11%) Julia
12 1 (0.37%) Data Analysis Expressions (DAX)
12 1 (0.37%) Go
12 1 (0.37%) VB.NET
12 1 (0.37%) VBA
Qualifications
1 24 (8.86%) Degree
2 6 (2.21%) Master's Degree
3 3 (1.11%) AWS Certification
4 2 (0.74%) Computer Science Degree
4 2 (0.74%) Postgraduate
5 1 (0.37%) Numerate Degree
5 1 (0.37%) PMI Certification
5 1 (0.37%) PMP
Quality Assurance & Compliance
1 21 (7.75%) GDPR
2 20 (7.38%) Data Quality
3 7 (2.58%) QA
System Software
1 7 (2.58%) HDFS
2 3 (1.11%) Docker
2 3 (1.11%) Varnish
3 2 (0.74%) Active Directory
4 1 (0.37%) Apache Flume
Systems Management
1 8 (2.95%) Terraform
2 4 (1.48%) Control-M
2 4 (1.48%) Kubernetes
3 1 (0.37%) Ansible
3 1 (0.37%) Kibana
3 1 (0.37%) Opscode Chef
3 1 (0.37%) Puppet
Vendors
1 41 (15.13%) Google
2 29 (10.70%) Oracle
3 27 (9.96%) Informatica
4 17 (6.27%) Databricks
5 16 (5.90%) Microsoft
6 14 (5.17%) Cognos
7 13 (4.80%) Talend
8 11 (4.06%) Teradata
9 8 (2.95%) Netezza
9 8 (2.95%) SAP
10 7 (2.58%) Vertica
11 5 (1.85%) MicroStrategy
11 5 (1.85%) TIBCO
12 4 (1.48%) Cloudera
13 3 (1.11%) Alteryx
14 2 (0.74%) Apple
14 2 (0.74%) Confluent
14 2 (0.74%) MuleSoft
14 2 (0.74%) Splunk
15 1 (0.37%) Salesforce.com