Period
to 23 October 2018

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 23 October 2018 with a comparison to the same period in the previous 2 years.

Snowflake Schema
England > London
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 754 821 824
Rank change year-on-year +67 +3 +94
Permanent jobs citing Snowflake Schema 67 26 36
As % of all permanent IT jobs advertised in London 0.098% 0.035% 0.047%
As % of the Database & Business Intelligence category 0.32% 0.12% 0.16%
Number of salaries quoted 56 5 33
London median annual salary £57,500 £80,000 £72,500
Median salary % change year-on-year -28.13% +10.34% +31.82%
10th Percentile £45,000 £41,650 £49,500
90th Percentile £75,625 £90,000 £80,000
England median annual salary £52,500 £50,000 £60,000
% change year-on-year +5.00% -16.67% +44.58%

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 20,911 22,106 22,395
As % of all permanent IT jobs advertised in London 30.73% 29.61% 29.35%
Number of salaries quoted 16,662 17,692 19,450
London median annual salary £62,500 £60,000 £57,500
Median salary % change year-on-year +4.17% +4.35% +4.55%
10th Percentile £37,500 £36,250 £35,000
90th Percentile £95,000 £89,900 £87,500
England median annual salary £50,000 £50,000 £47,500
% change year-on-year - +5.26% +5.56%

Snowflake Schema
Job Vacancy Trend in London

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

Job vacancy trend for Snowflake Schema in London

Snowflake Schema
Salary Trend in London

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Snowflake Schema in London.

Salary trend for Snowflake Schema in London

Snowflake Schema
Salary Histogram in London

The salary distribution of IT jobs citing Snowflake Schema in London over the 6 months to 23 October 2018.

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 23 October 2018. 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
West London - 15 £55,000 - 5
Central London -19 4 £67,500 +43.62% 1
South London +6 1 £57,500 -28.13%
Snowflake Schema
England

For the 6 months to 23 October 2018, 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 62 (92.54%) SQL
2 51 (76.12%) Data Warehouse
3 36 (53.73%) SQL Server
4 33 (49.25%) ETL
5 29 (43.28%) Finance
5 29 (43.28%) SQL Server Integration Services
5 29 (43.28%) PowerShell
6 26 (38.81%) Business Intelligence
7 25 (37.31%) T-SQL
7 25 (37.31%) SQL Server Reporting Services
8 23 (34.33%) .NET
8 23 (34.33%) Power BI
9 21 (31.34%) Windows
10 20 (29.85%) Visualisation
10 20 (29.85%) Tableau
10 20 (29.85%) Greenfield Project
11 19 (28.36%) Amazon AWS
11 19 (28.36%) OLTP
12 17 (25.37%) Microsoft Azure
13 16 (23.88%) Oracle
13 16 (23.88%) Windows Server
14 15 (22.39%) Looker
14 15 (22.39%) Data Modelling
14 15 (22.39%) Data Visualisation
14 15 (22.39%) Data Management
14 15 (22.39%) Degree
15 14 (20.90%) Statistics
15 14 (20.90%) Continuous Integration
15 14 (20.90%) Git (software)
15 14 (20.90%) Microsoft

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 3 (4.48%) Oracle SOA Suite
2 2 (2.99%) Apache
2 2 (2.99%) Apache Spark
3 1 (1.49%) Apache Airflow
3 1 (1.49%) Confluence
Applications
1 8 (11.94%) Microsoft Excel
Business Applications
1 6 (8.96%) Oracle EBS
1 6 (8.96%) Oracle Retail
2 2 (2.99%) NetSuite
Cloud Services
1 19 (28.36%) Amazon AWS
2 17 (25.37%) Microsoft Azure
3 11 (16.42%) Cloud Computing
4 10 (14.93%) Google Cloud Platform
5 4 (5.97%) AWS Lambda
5 4 (5.97%) Serverless
6 3 (4.48%) IaaS
6 3 (4.48%) PaaS
7 1 (1.49%) Amazon EMR
7 1 (1.49%) Amazon Kinesis
7 1 (1.49%) Amazon S3
7 1 (1.49%) GitHub
Database & Business Intelligence
1 51 (76.12%) Data Warehouse
2 36 (53.73%) SQL Server
3 29 (43.28%) SQL Server Integration Services
4 25 (37.31%) SQL Server Reporting Services
5 23 (34.33%) Power BI
6 19 (28.36%) OLTP
7 15 (22.39%) Looker
8 13 (19.40%) Big Data
9 10 (14.93%) Amazon Redshift
10 9 (13.43%) BigQuery
10 9 (13.43%) BusinessObjects
10 9 (13.43%) SQL Server 2008
11 8 (11.94%) MongoDB
11 8 (11.94%) MySQL
11 8 (11.94%) Star Schema
12 7 (10.45%) OLAP
13 6 (8.96%) BusinessObjects Web Intelligence
13 6 (8.96%) Oracle Database 10g
13 6 (8.96%) Oracle Database 11g
13 6 (8.96%) Oracle9i Database
Development Applications
1 14 (20.90%) Git (software)
2 6 (8.96%) Oracle APEX
2 6 (8.96%) PVCS
2 6 (8.96%) Toad
3 5 (7.46%) JIRA
4 2 (2.99%) Bitbucket
4 2 (2.99%) Team Foundation Server
5 1 (1.49%) Jenkins
5 1 (1.49%) Maven
General
1 29 (43.28%) Finance
2 8 (11.94%) Publishing
3 6 (8.96%) Games
3 6 (8.96%) Retail
4 3 (4.48%) Marketing
Job Titles
1 26 (38.81%) Developer
2 23 (34.33%) SQL Developer
3 16 (23.88%) DBA
3 16 (23.88%) SQL DBA
4 10 (14.93%) SQL Server DBA
5 7 (10.45%) Data Engineer
5 7 (10.45%) Senior DBA
5 7 (10.45%) Senior SQL DBA
5 7 (10.45%) Senior SQL Server DBA
6 6 (8.96%) Analyst
6 6 (8.96%) Software Engineer
7 5 (7.46%) Data Warehouse Developer
8 4 (5.97%) Business Intelligence Analyst
8 4 (5.97%) Business Intelligence Developer
8 4 (5.97%) Database Developer
8 4 (5.97%) IT Engineer
8 4 (5.97%) Senior Analyst
8 4 (5.97%) Senior Business Intelligence Analyst
8 4 (5.97%) SQL BI Developer
9 3 (4.48%) Business Intelligence Data Analyst
Libraries, Frameworks & Software Standards
1 23 (34.33%) .NET
2 8 (11.94%) Web Services
3 3 (4.48%) Oracle GoldenGate
3 3 (4.48%) REST
3 3 (4.48%) Velocity
4 2 (2.99%) ASP.NET
4 2 (2.99%) jQuery
4 2 (2.99%) Kafka
4 2 (2.99%) Spark Streaming
5 1 (1.49%) Apache Avro
5 1 (1.49%) XGBoost
Miscellaneous
1 20 (29.85%) Greenfield Project
2 7 (10.45%) Replication
3 6 (8.96%) Computer Science
4 4 (5.97%) Analytical Skills
4 4 (5.97%) Reference Data
4 4 (5.97%) Tandem
5 2 (2.99%) Online Games
6 1 (1.49%) Hybrid Cloud
6 1 (1.49%) Linux Command Line
6 1 (1.49%) Private Cloud
Operating Systems
1 21 (31.34%) Windows
2 16 (23.88%) Windows Server
3 13 (19.40%) Linux
4 7 (10.45%) Windows Server 2008
5 6 (8.96%) Unix
6 1 (1.49%) DC/OS
Processes & Methodologies
1 33 (49.25%) ETL
2 26 (38.81%) Business Intelligence
3 20 (29.85%) Visualisation
4 15 (22.39%) Data Management
4 15 (22.39%) Data Modelling
4 15 (22.39%) Data Visualisation
5 14 (20.90%) Agile Software Development
5 14 (20.90%) Continuous Integration
5 14 (20.90%) Statistics
6 13 (19.40%) Performance Analysis
7 12 (17.91%) Performance Tuning
7 12 (17.91%) Software Engineering
8 11 (16.42%) Analytics
8 11 (16.42%) Dimensional Modelling
9 10 (14.93%) Data Science
10 9 (13.43%) CRUD
10 9 (13.43%) Infrastructure Management
10 9 (13.43%) ITIL
11 8 (11.94%) Kimball Methodology
11 8 (11.94%) Microservices
Programming Languages
1 62 (92.54%) SQL
2 29 (43.28%) PowerShell
3 25 (37.31%) T-SQL
4 14 (20.90%) Python
5 6 (8.96%) PL/SQL
5 6 (8.96%) Shell Script
6 5 (7.46%) C#
7 4 (5.97%) Java
7 4 (5.97%) R
8 3 (4.48%) VB
8 3 (4.48%) VBA
9 2 (2.99%) Scala
10 1 (1.49%) JavaScript
Qualifications
1 15 (22.39%) Degree
Quality Assurance & Compliance
1 9 (13.43%) Data Quality
2 1 (1.49%) QA
System Software
1 9 (13.43%) Virtual Machines
Systems Management
1 1 (1.49%) Ansible
1 1 (1.49%) Opscode Chef
1 1 (1.49%) Puppet
1 1 (1.49%) Terraform
Vendors
1 20 (29.85%) Tableau
2 16 (23.88%) Oracle
3 14 (20.90%) Microsoft
4 7 (10.45%) VMware
5 6 (8.96%) SAP
6 3 (4.48%) Cognos
6 3 (4.48%) Google
6 3 (4.48%) MicroStrategy
6 3 (4.48%) MuleSoft
6 3 (4.48%) Vertica
7 1 (1.49%) Cloudera
7 1 (1.49%) Hortonworks
7 1 (1.49%) MapR
7 1 (1.49%) RedGate