Period
to 16 May 2021

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

Snowflake Schema
England > London
6 months to
16 May 2021
Same period 2020 Same period 2019
Rank 400 422 706
Rank change year-on-year +22 +284 +68
Permanent jobs citing Snowflake Schema 204 225 58
As % of all permanent jobs advertised in London 0.61% 0.56% 0.099%
As % of the Database & Business Intelligence category 2.09% 2.02% 0.34%
Number of salaries quoted 174 208 52
10th Percentile £47,500 £46,250 £45,000
25th Percentile £57,500 £55,938 £46,875
Median annual salary (50th Percentile) £72,500 £72,500 £60,000
Median % change year-on-year - +20.83% -7.69%
75th Percentile £84,688 £86,250 £76,563
90th Percentile £100,000 £115,000 £106,750
England median annual salary £70,000 £65,000 £52,500
% change year-on-year +7.69% +23.81% -

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 9,747 11,162 17,046
As % of all permanent IT jobs advertised in London 29.13% 27.85% 29.11%
Number of salaries quoted 7,163 9,206 14,304
10th Percentile £43,750 £40,000 £38,750
25th Percentile £52,500 £50,000 £47,500
Median annual salary (50th Percentile) £70,000 £65,000 £65,000
Median % change year-on-year +7.69% - +8.33%
75th Percentile £87,500 £86,188 £82,500
90th Percentile £102,500 £105,000 £95,000
England median annual salary £55,000 £55,000 £52,500
% 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 16 May 2021.

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 16 May 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
Central London +17 21 £73,750 -3.28% 12
West London +34 9 £80,000 +23.08%
South London +12 7 £80,000 +18.52%
Snowflake Schema
England

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

1 169 (82.84%) Data Warehouse
2 162 (79.41%) SQL
3 126 (61.76%) Business Intelligence
4 116 (56.86%) Analytics
5 110 (53.92%) ETL
6 108 (52.94%) AWS
7 102 (50.00%) Python
8 87 (42.65%) Data Modelling
9 69 (33.82%) Tableau
10 64 (31.37%) Agile Software Development
11 63 (30.88%) Data Science
12 61 (29.90%) Amazon Redshift
13 59 (28.92%) GCP
14 57 (27.94%) Looker
15 56 (27.45%) Data Architecture
16 55 (26.96%) Google
17 53 (25.98%) Data Engineering
17 53 (25.98%) Big Data
18 51 (25.00%) Azure
19 50 (24.51%) Power BI
19 50 (24.51%) Power Platform
20 49 (24.02%) Finance
21 48 (23.53%) Visualisation
21 48 (23.53%) Data Pipeline
22 43 (21.08%) Data Analysis
23 42 (20.59%) Migration
24 41 (20.10%) Social Skills
25 40 (19.61%) Data Governance
26 39 (19.12%) Apache Spark
27 38 (18.63%) BigQuery

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 39 (19.12%) Apache Spark
2 36 (17.65%) Apache Airflow
3 12 (5.88%) Oracle Application Server
4 5 (2.45%) Oracle Workflow
5 4 (1.96%) Luigi
6 3 (1.47%) Apache
6 3 (1.47%) Confluence
7 2 (0.98%) Apache Pig
7 2 (0.98%) SAS
7 2 (0.98%) SharePoint
8 1 (0.49%) Elasticsearch
Applications
1 7 (3.43%) Microsoft Excel
2 6 (2.94%) Microsoft Office
Business Applications
1 6 (2.94%) Magento
2 2 (0.98%) Sentinel
Cloud Services
1 108 (52.94%) AWS
2 59 (28.92%) GCP
3 51 (25.00%) Azure
4 50 (24.51%) Power Platform
5 27 (13.24%) Google Analytics
6 19 (9.31%) Amazon S3
7 13 (6.37%) Serverless
8 11 (5.39%) Amazon Kinesis
8 11 (5.39%) AWS Lambda
9 10 (4.90%) Matillion
10 9 (4.41%) Trello
11 8 (3.92%) Amazon CloudWatch
11 8 (3.92%) AWS CloudFormation
11 8 (3.92%) Cloud Computing
12 7 (3.43%) Amazon SageMaker
12 7 (3.43%) Azure Data Factory
12 7 (3.43%) Azure Synapse Analytics
12 7 (3.43%) GitHub
12 7 (3.43%) Google Data Studio
12 7 (3.43%) PaaS
Communications & Networking
1 2 (0.98%) FTP
1 2 (0.98%) HTTP
2 1 (0.49%) Internet
Database & Business Intelligence
1 169 (82.84%) Data Warehouse
2 69 (33.82%) Tableau
3 61 (29.90%) Amazon Redshift
4 57 (27.94%) Looker
5 53 (25.98%) Big Data
6 50 (24.51%) Power BI
7 38 (18.63%) BigQuery
8 31 (15.20%) NoSQL
9 30 (14.71%) Data Lake
10 25 (12.25%) Relational Database
11 23 (11.27%) SQL Server
12 22 (10.78%) Hadoop
12 22 (10.78%) Oracle Database
13 21 (10.29%) PostgreSQL
14 19 (9.31%) Oracle Database 12c
14 19 (9.31%) Oracle ODI
15 17 (8.33%) Amazon RDS
16 16 (7.84%) Oracle BI EE
17 12 (5.88%) Amazon DynamoDB
18 11 (5.39%) Enterprise Data Warehouse
Development Applications
1 17 (8.33%) Oracle APEX
2 16 (7.84%) Git (software)
3 15 (7.35%) JIRA
4 5 (2.45%) ER Studio
4 5 (2.45%) ERwin
4 5 (2.45%) PowerDesigner
5 3 (1.47%) Subversion
5 3 (1.47%) Toad
5 3 (1.47%) TortoiseSVN
6 2 (0.98%) DBeaver
6 2 (0.98%) Jenkins
6 2 (0.98%) Spinnaker
7 1 (0.49%) Bitbucket
7 1 (0.49%) SQL Server Management Studio (SSMS)
7 1 (0.49%) Visual Studio
General
1 49 (24.02%) Finance
2 41 (20.10%) Social Skills
3 17 (8.33%) Analytical Skills
4 11 (5.39%) Advertising
5 9 (4.41%) Marketing
5 9 (4.41%) Retail
6 8 (3.92%) Banking
7 5 (2.45%) Publishing
8 3 (1.47%) Czech Language
8 3 (1.47%) Organisational Skills
9 2 (0.98%) Automotive
9 2 (0.98%) Digital Economy
9 2 (0.98%) Games
10 1 (0.49%) Back Office
10 1 (0.49%) Documentation Skills
10 1 (0.49%) General Ledger
10 1 (0.49%) Manufacturing
10 1 (0.49%) Music Industry
10 1 (0.49%) Presentation Skills
10 1 (0.49%) Retail Banking
Job Titles
1 59 (28.92%) Data Engineer
2 33 (16.18%) Architect
3 29 (14.22%) Data Architect
4 28 (13.73%) Analyst
5 18 (8.82%) Data Analyst
5 18 (8.82%) Developer
6 14 (6.86%) Business Intelligence Lead
6 14 (6.86%) Consultant
7 11 (5.39%) Python Engineer
8 9 (4.41%) SQL Analyst
8 9 (4.41%) SQL Data Analyst
9 8 (3.92%) AWS Engineer
9 8 (3.92%) Business Intelligence Developer
9 8 (3.92%) Senior Analyst
10 7 (3.43%) Business Intelligence Analyst
10 7 (3.43%) Team Leader
11 6 (2.94%) Data Consultant
11 6 (2.94%) Senior Business Intelligence Analyst
11 6 (2.94%) Senior Data Engineer
12 5 (2.45%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 36 (17.65%) Kafka
2 20 (9.80%) Oracle GoldenGate
3 18 (8.82%) PySpark
3 18 (8.82%) REST
4 15 (7.35%) HTML
5 12 (5.88%) CSS
6 9 (4.41%) JSON
7 8 (3.92%) Spark Streaming
8 6 (2.94%) Bulma
8 6 (2.94%) D3.js
8 6 (2.94%) Django
8 6 (2.94%) OLE
8 6 (2.94%) Vue.js
9 5 (2.45%) Web Services
10 4 (1.96%) Apache Avro
10 4 (1.96%) Apache Beam
10 4 (1.96%) Node.js
10 4 (1.96%) React
11 3 (1.47%) Elastic Stack
11 3 (1.47%) XML
Miscellaneous
1 11 (5.39%) Data Structures
2 10 (4.90%) Video Conferencing
3 8 (3.92%) Clustering
4 7 (3.43%) Management Information System
5 6 (2.94%) Self-Motivation
6 5 (2.45%) Algorithms
6 5 (2.45%) Social Media
7 4 (1.96%) Cloud Native
8 2 (0.98%) Derivative
8 2 (0.98%) EPoS
8 2 (0.98%) User Experience
8 2 (0.98%) Virtual Team
9 1 (0.49%) Blog
9 1 (0.49%) Data Centre
9 1 (0.49%) Enterprise Software
9 1 (0.49%) Equities
9 1 (0.49%) FMCG
9 1 (0.49%) Life Science
9 1 (0.49%) Mobile App
9 1 (0.49%) Replication
Operating Systems
1 1 (0.49%) Android
1 1 (0.49%) Apple iOS
1 1 (0.49%) Linux
1 1 (0.49%) Unix
Processes & Methodologies
1 126 (61.76%) Business Intelligence
2 116 (56.86%) Analytics
3 110 (53.92%) ETL
4 87 (42.65%) Data Modelling
5 64 (31.37%) Agile Software Development
6 63 (30.88%) Data Science
7 56 (27.45%) Data Architecture
8 53 (25.98%) Data Engineering
9 48 (23.53%) Data Pipeline
9 48 (23.53%) Visualisation
10 43 (21.08%) Data Analysis
11 42 (20.59%) Migration
12 40 (19.61%) Data Governance
13 32 (15.69%) Data Visualisation
14 27 (13.24%) Data Analytics
14 27 (13.24%) Dimensional Modelling
15 23 (11.27%) Data Transformation
16 21 (10.29%) Data Integration
17 17 (8.33%) Kimball Methodology
17 17 (8.33%) TDD
Programming Languages
1 162 (79.41%) SQL
2 102 (50.00%) Python
3 30 (14.71%) Java
4 26 (12.75%) PL/SQL
5 19 (9.31%) R
6 16 (7.84%) Scala
7 10 (4.90%) C
8 9 (4.41%) C#
8 9 (4.41%) JavaScript
9 7 (3.43%) C++
10 6 (2.94%) Bash Shell
10 6 (2.94%) Go
11 5 (2.45%) PowerShell
12 2 (0.98%) Kotlin
13 1 (0.49%) Shell Script
13 1 (0.49%) T-SQL
13 1 (0.49%) VB
13 1 (0.49%) VBA
Qualifications
1 30 (14.71%) Degree
2 8 (3.92%) Master's Degree
3 5 (2.45%) Computer Science Degree
4 1 (0.49%) AWS Certification
4 1 (0.49%) DV Cleared
4 1 (0.49%) PhD
4 1 (0.49%) PMI Certification
4 1 (0.49%) PMP
4 1 (0.49%) SC Cleared
4 1 (0.49%) Security Cleared
4 1 (0.49%) TOGAF Certification
Quality Assurance & Compliance
1 17 (8.33%) Data Quality
2 10 (4.90%) GDPR
System Software
1 8 (3.92%) Docker
2 3 (1.47%) HDFS
3 2 (0.98%) Active Directory
3 2 (0.98%) Apache Flume
Systems Management
1 9 (4.41%) Kubernetes
1 9 (4.41%) Terraform
2 2 (0.98%) Ansible
3 1 (0.49%) Hadoop YARN
Vendors
1 55 (26.96%) Google
2 38 (18.63%) Oracle
3 25 (12.25%) Databricks
4 22 (10.78%) Informatica
5 18 (8.82%) Microsoft
6 9 (4.41%) Salesforce.com
7 8 (3.92%) Alteryx
8 7 (3.43%) MuleSoft
8 7 (3.43%) Talend
9 6 (2.94%) Cloudera
10 5 (2.45%) SAP
11 3 (1.47%) Hortonworks
12 2 (0.98%) Salesforce Marketing Cloud
12 2 (0.98%) StreamSets
13 1 (0.49%) Calypso
13 1 (0.49%) FIS
13 1 (0.49%) Intel
13 1 (0.49%) Netezza
13 1 (0.49%) Sparx
13 1 (0.49%) Teradata