Period
to 22 October 2020

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

Snowflake Schema
England > London
6 months to
22 Oct 2020
Same period 2019 Same period 2018
Rank 313 629 748
Rank change year-on-year +316 +119 +84
Permanent jobs citing Snowflake Schema 166 91 67
As % of all permanent jobs advertised in London 0.84% 0.17% 0.098%
As % of the Database & Business Intelligence category 2.95% 0.58% 0.32%
Number of salaries quoted 142 77 56
Median annual salary £60,000 £72,500 £57,500
Median salary % change year-on-year -17.24% +26.09% -28.13%
10th Percentile £45,000 £45,000 £45,000
90th Percentile £87,500 £115,000 £75,625
England median annual salary £60,000 £60,000 £52,500
% change year-on-year - +14.29% +5.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 advertised in London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
London
Permanent vacancies with a requirement for database or business intelligence skills 5,636 15,727 21,134
As % of all permanent IT jobs advertised in London 28.55% 28.81% 31.05%
Number of salaries quoted 4,747 13,029 16,836
Median annual salary £70,000 £65,000 £62,500
Median salary % change year-on-year +7.69% +4.00% +4.17%
10th Percentile £42,500 £37,500 £37,500
90th Percentile £103,750 £98,750 £93,750
England median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% -

Snowflake Schema
Job Vacancy Trend in London

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

Job vacancy trend for Snowflake Schema in London

Snowflake Schema
Salary Trend in London

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

Salary trend for Snowflake Schema in London

Snowflake Schema
Salary Histogram in London

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

Salary histogram for Snowflake Schema in London

Snowflake Schema
Job Locations in London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the London region over the 6 months to 22 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
Central London +181 35 £65,000 -10.34% 4
South London +61 10 £63,750 -29.17% 1
West London +81 7 £81,250 +35.42% 1
Snowflake Schema
England

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

1 136 (81.93%) Data Warehouse
2 133 (80.12%) SQL
3 107 (64.46%) AWS
4 106 (63.86%) Business Intelligence
5 94 (56.63%) Agile Software Development
6 86 (51.81%) Data Modelling
7 81 (48.80%) Python
8 78 (46.99%) ETL
8 78 (46.99%) Amazon Redshift
9 70 (42.17%) Finance
10 67 (40.36%) Azure
11 64 (38.55%) Looker
12 60 (36.14%) GCP
13 49 (29.52%) BigQuery
14 47 (28.31%) Analytics
15 46 (27.71%) Data Engineering
16 45 (27.11%) Performance Tuning
17 43 (25.90%) Big Data
17 43 (25.90%) Power BI
17 43 (25.90%) Power Platform
18 42 (25.30%) Data Lake
18 42 (25.30%) Tableau
19 40 (24.10%) NoSQL
20 39 (23.49%) Data Science
21 38 (22.89%) Visualisation
21 38 (22.89%) Data Architecture
22 31 (18.67%) Marketing
23 29 (17.47%) Kafka
24 28 (16.87%) JIRA
25 27 (16.27%) Git (software)

Snowflake Schema
Co-occurring IT Skills in London 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 10 (6.02%) Apache Spark
2 5 (3.01%) Apache
2 5 (3.01%) Apache Airflow
3 4 (2.41%) Elasticsearch
4 1 (0.60%) Apache Pig
4 1 (0.60%) SharePoint
Applications
1 2 (1.20%) Microsoft Excel
2 1 (0.60%) Microsoft Office
Business Applications
1 1 (0.60%) Dynamics CRM
Cloud Services
1 107 (64.46%) AWS
2 67 (40.36%) Azure
3 60 (36.14%) GCP
4 43 (25.90%) Power Platform
5 22 (13.25%) SaaS
6 20 (12.05%) Amazon S3
7 16 (9.64%) Trello
8 14 (8.43%) Serverless
9 12 (7.23%) AWS Lambda
10 10 (6.02%) AWS CloudFormation
11 9 (5.42%) Azure Data Factory
12 5 (3.01%) Amazon EMR
13 2 (1.20%) Amazon Kinesis
13 2 (1.20%) AWS Step Functions
13 2 (1.20%) IaaS
13 2 (1.20%) PaaS
14 1 (0.60%) AWS Data Pipeline
14 1 (0.60%) Cloud Computing
Database & Business Intelligence
1 136 (81.93%) Data Warehouse
2 78 (46.99%) Amazon Redshift
3 64 (38.55%) Looker
4 49 (29.52%) BigQuery
5 43 (25.90%) Big Data
5 43 (25.90%) Power BI
6 42 (25.30%) Data Lake
6 42 (25.30%) Tableau
7 40 (24.10%) NoSQL
8 26 (15.66%) Relational Database
9 24 (14.46%) SQL Server
10 18 (10.84%) Azure SQL Database
11 17 (10.24%) Amazon Athena
12 16 (9.64%) Flink
13 15 (9.04%) Amazon RDS
14 12 (7.23%) SQL Server Integration Services
15 10 (6.02%) SQL Server Analysis Services
16 9 (5.42%) Azure SQL Data Warehouse
16 9 (5.42%) Hadoop
16 9 (5.42%) MongoDB
Development Applications
1 28 (16.87%) JIRA
2 27 (16.27%) Git (software)
3 4 (2.41%) ERwin
3 4 (2.41%) PowerDesigner
4 2 (1.20%) Jenkins
4 2 (1.20%) Newman
4 2 (1.20%) Postman
4 2 (1.20%) Selenium
General
1 70 (42.17%) Finance
2 31 (18.67%) Marketing
3 18 (10.84%) Banking
4 5 (3.01%) Advertising
5 4 (2.41%) Retail
6 2 (1.20%) Digital Economy
7 1 (0.60%) Games
7 1 (0.60%) Pharmaceutical
Job Titles
1 70 (42.17%) Data Engineer
2 35 (21.08%) Developer
3 22 (13.25%) Data Warehouse Developer
4 15 (9.04%) Consultant
5 14 (8.43%) SQL Developer
6 13 (7.83%) AWS Engineer
7 12 (7.23%) Analyst
7 12 (7.23%) Architect
7 12 (7.23%) Data Architect
8 11 (6.63%) Azure Engineer
8 11 (6.63%) Data Analyst
9 9 (5.42%) Business Intelligence Developer
9 9 (5.42%) SQL Analyst
9 9 (5.42%) SQL Data Analyst
10 8 (4.82%) Business Intelligence Consultant
11 7 (4.22%) Data Analytics Engineer
11 7 (4.22%) Lambda Engineer
11 7 (4.22%) Senior Business Intelligence Developer
11 7 (4.22%) Senior Developer
12 6 (3.61%) Data Consultant
Libraries, Frameworks & Software Standards
1 29 (17.47%) Kafka
2 14 (8.43%) PySpark
3 12 (7.23%) MDX
4 9 (5.42%) HTML
5 8 (4.82%) LDAP
6 7 (4.22%) JSON
7 5 (3.01%) XML
8 4 (2.41%) FIX Protocol
8 4 (2.41%) REST
9 3 (1.81%) Apache NiFi
9 3 (1.81%) D3.js
9 3 (1.81%) Spark Streaming
10 2 (1.20%) .NET
10 2 (1.20%) Gherkin
10 2 (1.20%) Web Services
10 2 (1.20%) WPF
11 1 (0.60%) CSS
11 1 (0.60%) J2EE
11 1 (0.60%) RabbitMQ
11 1 (0.60%) Velocity
Miscellaneous
1 25 (15.06%) Analytical Skills
2 21 (12.65%) Clustering
3 18 (10.84%) Data Structures
3 18 (10.84%) Greenfield Project
4 7 (4.22%) Social Media
4 7 (4.22%) Virtual Team
5 5 (3.01%) Foreign Exchange (FX)
6 4 (2.41%) Management Information System
6 4 (2.41%) Reference Data
6 4 (2.41%) Video Conferencing
7 2 (1.20%) Self-Motivation
8 1 (0.60%) Algorithms
8 1 (0.60%) Life Science
8 1 (0.60%) Reinsurance
8 1 (0.60%) Replication
8 1 (0.60%) User Experience
Operating Systems
1 5 (3.01%) Unix
2 3 (1.81%) Windows
3 1 (0.60%) Linux
Processes & Methodologies
1 106 (63.86%) Business Intelligence
2 94 (56.63%) Agile Software Development
3 86 (51.81%) Data Modelling
4 78 (46.99%) ETL
5 47 (28.31%) Analytics
6 46 (27.71%) Data Engineering
7 45 (27.11%) Performance Tuning
8 39 (23.49%) Data Science
9 38 (22.89%) Data Architecture
9 38 (22.89%) Visualisation
10 23 (13.86%) Fintech
11 22 (13.25%) SDLC
12 19 (11.45%) Data Governance
12 19 (11.45%) Problem-Solving
12 19 (11.45%) Unit Testing
13 18 (10.84%) Actionable Insight
13 18 (10.84%) Sprint Planning
14 16 (9.64%) Mentoring
15 15 (9.04%) Data Transformation
15 15 (9.04%) E-Commerce
Programming Languages
1 133 (80.12%) SQL
2 81 (48.80%) Python
3 17 (10.24%) Java
4 13 (7.83%) C#
5 10 (6.02%) C
6 8 (4.82%) Data Analysis Expressions (DAX)
7 6 (3.61%) Scala
8 4 (2.41%) JavaScript
8 4 (2.41%) Shell Script
9 2 (1.20%) Julia
9 2 (1.20%) PL/SQL
9 2 (1.20%) R
10 1 (0.60%) T-SQL
Qualifications
1 18 (10.84%) Degree
2 9 (5.42%) AWS Certification
3 6 (3.61%) Computer Science Degree
4 5 (3.01%) Master's Degree
5 2 (1.20%) Postgraduate
6 1 (0.60%) PhD
Quality Assurance & Compliance
1 14 (8.43%) GDPR
2 8 (4.82%) Data Quality
3 6 (3.61%) QA
System Software
1 2 (1.20%) Docker
1 2 (1.20%) HDFS
2 1 (0.60%) Apache Flume
Systems Management
1 4 (2.41%) Control-M
2 3 (1.81%) Kubernetes
3 1 (0.60%) Ansible
3 1 (0.60%) Opscode Chef
3 1 (0.60%) Puppet
3 1 (0.60%) Terraform
Vendors
1 21 (12.65%) Microsoft
2 17 (10.24%) Databricks
3 15 (9.04%) Google
4 13 (7.83%) Oracle
5 10 (6.02%) Informatica
6 7 (4.22%) Teradata
7 3 (1.81%) MicroStrategy
7 3 (1.81%) Splunk
8 2 (1.20%) Cloudera
8 2 (1.20%) SnapLogic
8 2 (1.20%) Talend
9 1 (0.60%) Alteryx
9 1 (0.60%) Netezza
9 1 (0.60%) Sybase