Period
to 22 September 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 22 September 2020 with a comparison to the same period in the previous 2 years.

Snowflake Schema
Central London > City of London
6 months to
22 Sep 2020
Same period 2019 Same period 2018
Rank 173 310 349
Rank change year-on-year +137 +39 -23
Permanent jobs citing Snowflake Schema 25 9 8
As % of all permanent jobs advertised in the City of London 0.64% 0.091% 0.073%
As % of the Database & Business Intelligence category 2.37% 0.29% 0.23%
Number of salaries quoted 25 7 9
Median annual salary £72,500 £75,000 £67,500
Median salary % change year-on-year -3.33% +11.11% +75.32%
10th Percentile £46,250 £55,750 £57,500
90th Percentile £91,250 £103,000 £71,250
Central London median annual salary £68,750 £75,000 £67,500
% change year-on-year -8.33% +11.11% +75.32%

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,054 3,074 3,423
As % of all permanent IT jobs advertised in the City of London 27.03% 30.91% 31.16%
Number of salaries quoted 877 2,771 3,106
Median annual salary £70,000 £67,500 £65,000
Median salary % change year-on-year +3.70% +3.85% +8.33%
10th Percentile £42,500 £43,750 £40,000
90th Percentile £100,000 £98,750 £94,250
Central London median annual salary £70,000 £65,000 £65,000
% change year-on-year +7.69% - +8.33%

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 22 September 2020.

Salary histogram for Snowflake Schema in the City of London

For the 6 months to 22 September 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 21 (84.00%) SQL
1 21 (84.00%) Data Modelling
2 16 (64.00%) ETL
3 14 (56.00%) SQL Server Integration Services
4 13 (52.00%) Azure
4 13 (52.00%) Business Intelligence
4 13 (52.00%) Finance
5 11 (44.00%) SQL Server
5 11 (44.00%) Agile Software Development
5 11 (44.00%) Analytical Skills
5 11 (44.00%) Power BI
5 11 (44.00%) Power Platform
6 10 (40.00%) Data Governance
6 10 (40.00%) Java
6 10 (40.00%) Informatica
7 9 (36.00%) Unit Testing
7 9 (36.00%) Problem-Solving
8 8 (32.00%) SQL Server Analysis Services
8 8 (32.00%) Microsoft Analysis Services
8 8 (32.00%) MDX
8 8 (32.00%) DataStage
8 8 (32.00%) Teradata
8 8 (32.00%) Data Warehouse
8 8 (32.00%) Azure SQL Database
8 8 (32.00%) Master Data Management
8 8 (32.00%) Data Analysis Expressions (DAX)
8 8 (32.00%) SDLC
9 7 (28.00%) SQL Optimisation
9 7 (28.00%) Data Flow Diagram
9 7 (28.00%) Prototyping

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 1 (4.00%) Apache Airflow
1 1 (4.00%) Apache Spark
1 1 (4.00%) Elasticsearch
Cloud Services
1 13 (52.00%) Azure
2 11 (44.00%) Power Platform
3 5 (20.00%) SaaS
4 1 (4.00%) AWS
4 1 (4.00%) Azure Stack
4 1 (4.00%) GCP
4 1 (4.00%) Serverless
Database & Business Intelligence
1 14 (56.00%) SQL Server Integration Services
2 11 (44.00%) Power BI
2 11 (44.00%) SQL Server
3 8 (32.00%) Azure SQL Database
3 8 (32.00%) Data Warehouse
3 8 (32.00%) DataStage
3 8 (32.00%) Microsoft Analysis Services
3 8 (32.00%) SQL Server Analysis Services
4 7 (28.00%) SQL Server 2017
5 4 (16.00%) Amazon Redshift
6 2 (8.00%) Apache Cassandra
6 2 (8.00%) Big Data
6 2 (8.00%) Hadoop
6 2 (8.00%) NoSQL
6 2 (8.00%) Relational Database
7 1 (4.00%) OLAP
7 1 (4.00%) OLTP
7 1 (4.00%) PostgreSQL
7 1 (4.00%) RDBMS
7 1 (4.00%) Star Schema
Development Applications
1 3 (12.00%) Jenkins
2 1 (4.00%) Flyway
2 1 (4.00%) Liquibase
General
1 13 (52.00%) Finance
2 1 (4.00%) Advertising
2 1 (4.00%) Banking
2 1 (4.00%) Retail
Job Titles
1 10 (40.00%) Developer
2 8 (32.00%) Business Intelligence Developer
3 7 (28.00%) Informatica Specialist
3 7 (28.00%) Senior Business Intelligence Developer
3 7 (28.00%) Senior Data Warehouse Specialist
3 7 (28.00%) Senior Developer
3 7 (28.00%) Senior Informatica Specialist
3 7 (28.00%) Senior Technical Specialist
3 7 (28.00%) Senior Unix Technical Specialist
3 7 (28.00%) Technical Specialist
4 3 (12.00%) Data Engineer
5 2 (8.00%) Business Intelligence Lead
5 2 (8.00%) Cloud Developer
5 2 (8.00%) ETL Developer
5 2 (8.00%) SSAS Developer
6 1 (4.00%) Business Developer
6 1 (4.00%) Business Intelligence Manager
6 1 (4.00%) Lead Developer
6 1 (4.00%) Product Manager
6 1 (4.00%) SQL Developer
Libraries, Frameworks & Software Standards
1 8 (32.00%) MDX
2 1 (4.00%) Apache NiFi
2 1 (4.00%) D3.js
2 1 (4.00%) Kafka
2 1 (4.00%) Spark Streaming
Miscellaneous
1 11 (44.00%) Analytical Skills
2 1 (4.00%) Algorithms
2 1 (4.00%) Reinsurance
Operating Systems
1 7 (28.00%) Unix
Processes & Methodologies
1 21 (84.00%) Data Modelling
2 16 (64.00%) ETL
3 13 (52.00%) Business Intelligence
4 11 (44.00%) Agile Software Development
5 10 (40.00%) Data Governance
6 9 (36.00%) Problem-Solving
6 9 (36.00%) Unit Testing
7 8 (32.00%) Master Data Management
7 8 (32.00%) SDLC
8 7 (28.00%) Data Analysis
8 7 (28.00%) Data Flow Diagram
8 7 (28.00%) Kalman Filter
8 7 (28.00%) Performance Tuning
8 7 (28.00%) Prototyping
8 7 (28.00%) Regression Testing
8 7 (28.00%) Release Management
8 7 (28.00%) SQL Optimisation
8 7 (28.00%) System Testing
9 5 (20.00%) Analytics
9 5 (20.00%) Risk Management
Programming Languages
1 21 (84.00%) SQL
2 10 (40.00%) Java
3 8 (32.00%) Data Analysis Expressions (DAX)
4 7 (28.00%) Shell Script
5 6 (24.00%) Python
6 3 (12.00%) R
6 3 (12.00%) Scala
7 2 (8.00%) C#
8 1 (4.00%) T-SQL
Qualifications
1 2 (8.00%) Degree
2 1 (4.00%) Computer Science Degree
Quality Assurance & Compliance
1 7 (28.00%) Data Quality
System Software
1 2 (8.00%) Docker
2 1 (4.00%) Apache Flume
Systems Management
1 7 (28.00%) Control-M
2 2 (8.00%) Terraform
3 1 (4.00%) Ansible
3 1 (4.00%) Kubernetes
3 1 (4.00%) Opscode Chef
3 1 (4.00%) Puppet
Vendors
1 10 (40.00%) Informatica
2 8 (32.00%) Teradata
3 7 (28.00%) Microsoft
3 7 (28.00%) Oracle
4 4 (16.00%) Tableau
5 3 (12.00%) SnapLogic
6 2 (8.00%) Talend
7 1 (4.00%) Databricks
7 1 (4.00%) Netezza
7 1 (4.00%) Splunk