Period
to 25 May 2020

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

Snowflake Schema
Central London > City of London
6 months to
25 May 2020
Same period 2019 Same period 2018
Rank 217 316 321
Rank change year-on-year +99 +5 +22
Permanent jobs citing Snowflake Schema 51 8 20
As % of all permanent jobs advertised in the City of London 0.73% 0.079% 0.19%
As % of the Database & Business Intelligence category 3.06% 0.26% 0.60%
Number of salaries quoted 48 8 22
Median annual salary £82,500 £73,750 £65,000
Median salary % change year-on-year +11.86% +13.46% +116.67%
10th Percentile £47,500 £48,750 £62,500
90th Percentile £120,000 £115,000 £91,000
Central London median annual salary £72,500 £72,500 £65,000
% change year-on-year - +11.54% +44.44%

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 the City of London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
City of London
Permanent vacancies with a requirement for database or business intelligence skills 1,664 3,125 3,359
As % of all permanent IT jobs advertised in the City of London 23.90% 30.84% 31.34%
Number of salaries quoted 1,441 2,822 3,002
Median annual salary £67,500 £67,500 £65,000
Median salary % change year-on-year - +3.85% +8.33%
10th Percentile £42,110 £41,250 £41,250
90th Percentile £100,000 £97,500 £90,000
Central London median annual salary £70,000 £65,000 £62,500
% change year-on-year +7.69% +4.00% +4.17%

Snowflake Schema
Job Vacancy Trend in the City of London

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

Job vacancy trend for Snowflake Schema in the City of London

Snowflake Schema
Salary Trend in the City of London

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

Salary trend for Snowflake Schema in the City of London

Snowflake Schema
Salary Histogram in the City of London

Salary distribution for jobs citing Snowflake Schema in the City of London over the 6 months to 25 May 2020.

Salary histogram for Snowflake Schema in the City of London

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

1 40 (78.43%) SQL
2 36 (70.59%) Data Modelling
3 32 (62.75%) ETL
4 29 (56.86%) Data Governance
5 28 (54.90%) Finance
5 28 (54.90%) Analytical Skills
6 27 (52.94%) Java
7 26 (50.98%) Python
7 26 (50.98%) Data Warehouse
8 25 (49.02%) SQL Server Integration Services
9 22 (43.14%) Oracle
10 21 (41.18%) SQL Server
10 21 (41.18%) Informatica
10 21 (41.18%) Azure
10 21 (41.18%) Problem-Solving
11 17 (33.33%) Fintech
11 17 (33.33%) Analytics
12 15 (29.41%) Stakeholder Management
12 15 (29.41%) Agile Software Development
13 14 (27.45%) Degree
14 13 (25.49%) Unit Testing
14 13 (25.49%) System Testing
14 13 (25.49%) NoSQL
14 13 (25.49%) Regression Testing
14 13 (25.49%) Business Intelligence
14 13 (25.49%) DataStage
14 13 (25.49%) Shell Script
14 13 (25.49%) Unix
14 13 (25.49%) Kalman Filter
14 13 (25.49%) Data Flow Diagram

Snowflake Schema
Co-occurring IT Skills in the City of 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 4 (7.84%) Apache Airflow
1 4 (7.84%) Elasticsearch
2 3 (5.88%) Apache Spark
Cloud Services
1 21 (41.18%) Azure
2 12 (23.53%) AWS
3 10 (19.61%) Power Platform
4 3 (5.88%) SaaS
5 2 (3.92%) GCP
6 1 (1.96%) Amazon S3
6 1 (1.96%) Azure Stack
6 1 (1.96%) Serverless
Database & Business Intelligence
1 26 (50.98%) Data Warehouse
2 25 (49.02%) SQL Server Integration Services
3 21 (41.18%) SQL Server
4 13 (25.49%) DataStage
4 13 (25.49%) NoSQL
5 12 (23.53%) Amazon Redshift
5 12 (23.53%) OLAP
6 11 (21.57%) Apache Cassandra
6 11 (21.57%) OLTP
7 10 (19.61%) Power BI
8 8 (15.69%) Amazon DynamoDB
8 8 (15.69%) MongoDB
8 8 (15.69%) Relational Database
9 7 (13.73%) CouchDB
9 7 (13.73%) Oracle OLAP
9 7 (13.73%) RDBMS
10 6 (11.76%) Azure SQL Database
10 6 (11.76%) Microsoft Analysis Services
10 6 (11.76%) SQL Server Analysis Services
11 5 (9.80%) Looker
Development Applications
1 7 (13.73%) ERwin
1 7 (13.73%) PowerDesigner
2 4 (7.84%) Flyway
2 4 (7.84%) Jenkins
2 4 (7.84%) Liquibase
General
1 28 (54.90%) Finance
2 1 (1.96%) Advertising
2 1 (1.96%) Games
Job Titles
1 14 (27.45%) Developer
2 13 (25.49%) Informatica Specialist
2 13 (25.49%) Senior Data Warehouse Specialist
2 13 (25.49%) Senior Informatica Specialist
2 13 (25.49%) Senior Technical Specialist
2 13 (25.49%) Senior Unix Technical Specialist
2 13 (25.49%) Technical Specialist
3 9 (17.65%) Architect
3 9 (17.65%) Data Architect
4 8 (15.69%) Cloud Developer
4 8 (15.69%) Data Engineer
4 8 (15.69%) ETL Developer
5 6 (11.76%) Business Intelligence Developer
6 5 (9.80%) Business Intelligence Lead
6 5 (9.80%) Senior Business Intelligence Developer
6 5 (9.80%) Senior Developer
7 4 (7.84%) Azure Engineer
7 4 (7.84%) Cloud Engineer
8 3 (5.88%) Python Engineer
9 2 (3.92%) Platform Engineer
Libraries, Frameworks & Software Standards
1 10 (19.61%) Kafka
2 9 (17.65%) J2EE
3 7 (13.73%) FIX Protocol
3 7 (13.73%) JSON
3 7 (13.73%) MDX
3 7 (13.73%) XML
4 4 (7.84%) Apache NiFi
5 2 (3.92%) boto
5 2 (3.92%) Pandas
5 2 (3.92%) SQLAlchemy
Miscellaneous
1 28 (54.90%) Analytical Skills
2 7 (13.73%) Foreign Exchange (FX)
2 7 (13.73%) Management Information System
2 7 (13.73%) Reference Data
3 2 (3.92%) Greenfield Project
3 2 (3.92%) Hedge funds
4 1 (1.96%) Algorithms
4 1 (1.96%) Video\Live Streaming
Operating Systems
1 13 (25.49%) Unix
2 1 (1.96%) Linux
2 1 (1.96%) Windows
Processes & Methodologies
1 36 (70.59%) Data Modelling
2 32 (62.75%) ETL
3 29 (56.86%) Data Governance
4 21 (41.18%) Problem-Solving
5 17 (33.33%) Analytics
5 17 (33.33%) Fintech
6 15 (29.41%) Agile Software Development
6 15 (29.41%) Stakeholder Management
7 13 (25.49%) Business Intelligence
7 13 (25.49%) Data Flow Diagram
7 13 (25.49%) Kalman Filter
7 13 (25.49%) Regression Testing
7 13 (25.49%) System Testing
7 13 (25.49%) Unit Testing
8 10 (19.61%) Critical Thinking
8 10 (19.61%) Migration
9 9 (17.65%) Computer Science
9 9 (17.65%) Data Management
9 9 (17.65%) ETL Development
10 8 (15.69%) Data Architecture
Programming Languages
1 40 (78.43%) SQL
2 27 (52.94%) Java
3 26 (50.98%) Python
4 13 (25.49%) Shell Script
5 6 (11.76%) Data Analysis Expressions (DAX)
5 6 (11.76%) Scala
6 5 (9.80%) C#
6 5 (9.80%) R
7 2 (3.92%) C++
7 2 (3.92%) PL/SQL
8 1 (1.96%) Bash Shell
8 1 (1.96%) PowerShell
Qualifications
1 14 (27.45%) Degree
2 7 (13.73%) AWS Certification
2 7 (13.73%) Computer Science Degree
2 7 (13.73%) Master's Degree
3 1 (1.96%) Postgraduate
Quality Assurance & Compliance
1 11 (21.57%) Data Quality
2 8 (15.69%) QA
3 2 (3.92%) MiFID
System Software
1 7 (13.73%) Docker
Systems Management
1 4 (7.84%) Control-M
1 4 (7.84%) Terraform
2 3 (5.88%) Kubernetes
Vendors
1 22 (43.14%) Oracle
2 21 (41.18%) Informatica
3 12 (23.53%) SnapLogic
4 10 (19.61%) Tableau
5 8 (15.69%) Talend
6 5 (9.80%) Microsoft
6 5 (9.80%) Teradata
7 2 (3.92%) Netezza
8 1 (1.96%) Alteryx
8 1 (1.96%) Cognos
8 1 (1.96%) Google
8 1 (1.96%) MicroStrategy
8 1 (1.96%) Vertica