Period
to 17 February 2019

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 17 February 2019 with a comparison to the same period in the previous 2 years.

Snowflake Schema
England > London
6 months to
17 Feb 2019
Same period 2018 Same period 2017
Rank 679 785 803
Rank change year-on-year +106 +18 +108
Permanent jobs citing Snowflake Schema 80 38 13
As % of all permanent IT jobs advertised in London 0.13% 0.055% 0.019%
As % of the Database & Business Intelligence category 0.44% 0.18% 0.062%
Number of salaries quoted 68 19 10
London median annual salary £60,000 £62,500 £47,500
Median salary % change year-on-year -4.00% +31.58% -29.63%
10th Percentile £41,750 £39,750 £43,250
90th Percentile £85,000 £82,000 £59,900
England median annual salary £55,000 £52,500 £45,000
% change year-on-year +4.76% +16.67% +7.14%

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 18,324 21,152 20,832
As % of all permanent IT jobs advertised in London 29.51% 30.36% 29.76%
Number of salaries quoted 15,160 17,435 18,189
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 £37,500 £35,000
90th Percentile £95,000 £90,000 £87,500
England median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

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 17 February 2019.

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 17 February 2019. 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 - 14 £55,000 - 2
Central London +15 3 £60,000 -7.69% 2
South London - 2 £76,250 -
Snowflake Schema
England

For the 6 months to 17 February 2019, 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 73 (91.25%) SQL
2 60 (75.00%) Data Warehouse
3 57 (71.25%) SQL Server
4 48 (60.00%) Business Intelligence
5 42 (52.50%) ETL
6 39 (48.75%) T-SQL
6 39 (48.75%) Microsoft Azure
7 38 (47.50%) SQL Server Integration Services
8 31 (38.75%) SQL Server Reporting Services
8 31 (38.75%) Tableau
9 29 (36.25%) Kimball Methodology
10 27 (33.75%) Amazon AWS
11 26 (32.50%) Python
12 25 (31.25%) Data Modelling
12 25 (31.25%) Power BI
13 24 (30.00%) Looker
13 24 (30.00%) Agile Software Development
14 23 (28.75%) .NET
14 23 (28.75%) OLAP
14 23 (28.75%) Visualisation
15 22 (27.50%) Microsoft
16 19 (23.75%) Star Schema
16 19 (23.75%) Statistics
16 19 (23.75%) SQL Server Analysis Services
16 19 (23.75%) Git (software)
17 17 (21.25%) Software Engineering
17 17 (21.25%) Continuous Integration
17 17 (21.25%) Finance
17 17 (21.25%) MongoDB
17 17 (21.25%) Analytics

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 9 (11.25%) Apache
1 9 (11.25%) Apache Spark
2 2 (2.50%) Apache Airflow
2 2 (2.50%) Confluence
2 2 (2.50%) Oracle SOA Suite
Applications
1 6 (7.50%) Microsoft Excel
Business Applications
1 6 (7.50%) Oracle EBS
1 6 (7.50%) Oracle Retail
2 2 (2.50%) NetSuite
3 1 (1.25%) Dynamics AX
3 1 (1.25%) Dynamics CRM
3 1 (1.25%) Dynamics NAV
Cloud Services
1 39 (48.75%) Microsoft Azure
2 27 (33.75%) Amazon AWS
3 17 (21.25%) Google Cloud Platform
4 10 (12.50%) Cloud Computing
5 4 (5.00%) AWS Lambda
5 4 (5.00%) Serverless
6 2 (2.50%) Amazon EMR
6 2 (2.50%) Amazon Kinesis
6 2 (2.50%) GitHub
6 2 (2.50%) IaaS
6 2 (2.50%) PaaS
6 2 (2.50%) SaaS
7 1 (1.25%) Amazon S3
7 1 (1.25%) AWS CloudFormation
Communications & Networking
1 4 (5.00%) FTP
Database & Business Intelligence
1 60 (75.00%) Data Warehouse
2 57 (71.25%) SQL Server
3 38 (47.50%) SQL Server Integration Services
4 31 (38.75%) SQL Server Reporting Services
5 25 (31.25%) Power BI
6 24 (30.00%) Looker
7 23 (28.75%) OLAP
8 19 (23.75%) SQL Server Analysis Services
8 19 (23.75%) Star Schema
9 17 (21.25%) MongoDB
10 16 (20.00%) Amazon Redshift
11 15 (18.75%) OLTP
12 14 (17.50%) BigQuery
13 13 (16.25%) Azure SQL Database
13 13 (16.25%) Big Data
13 13 (16.25%) Cosmos DB
14 9 (11.25%) Hadoop
15 8 (10.00%) BusinessObjects
15 8 (10.00%) MySQL
16 7 (8.75%) QlikView
Development Applications
1 19 (23.75%) Git (software)
2 12 (15.00%) JIRA
3 6 (7.50%) Oracle APEX
3 6 (7.50%) PVCS
3 6 (7.50%) Toad
4 3 (3.75%) Bitbucket
5 2 (2.50%) Jenkins
5 2 (2.50%) Team Foundation Server
6 1 (1.25%) Maven
6 1 (1.25%) TeamCity
General
1 17 (21.25%) Finance
2 13 (16.25%) Retail
3 11 (13.75%) Games
4 8 (10.00%) Publishing
5 1 (1.25%) Banking
5 1 (1.25%) Retail Banking
Job Titles
1 26 (32.50%) Developer
2 18 (22.50%) SQL Developer
3 16 (20.00%) Business Intelligence Developer
4 14 (17.50%) Analyst
5 13 (16.25%) DBA
5 13 (16.25%) SQL DBA
6 12 (15.00%) Data Engineer
7 11 (13.75%) SQL BI Developer
7 11 (13.75%) SQL Server BI Developer
7 11 (13.75%) SQL Server Developer
8 8 (10.00%) Senior Analyst
9 7 (8.75%) Data Analyst
9 7 (8.75%) Data Warehouse Developer
9 7 (8.75%) Senior Data Analyst
9 7 (8.75%) SQL Server DBA
10 6 (7.50%) Senior Developer
10 6 (7.50%) Software Engineer
11 4 (5.00%) Senior DBA
11 4 (5.00%) Senior SQL DBA
11 4 (5.00%) Support Analyst
Libraries, Frameworks & Software Standards
1 23 (28.75%) .NET
2 9 (11.25%) Kafka
3 8 (10.00%) Web Services
4 6 (7.50%) LAMP
4 6 (7.50%) LAPP Stack
5 3 (3.75%) REST
5 3 (3.75%) Spark Streaming
6 2 (2.50%) ASP.NET
6 2 (2.50%) jQuery
6 2 (2.50%) Oracle GoldenGate
6 2 (2.50%) Velocity
7 1 (1.25%) Apache Avro
7 1 (1.25%) Apache Beam
7 1 (1.25%) Apache NiFi
7 1 (1.25%) MDX
7 1 (1.25%) RAML
7 1 (1.25%) Swagger
7 1 (1.25%) XGBoost
Miscellaneous
1 13 (16.25%) Analytical Skills
2 9 (11.25%) Greenfield Project
3 6 (7.50%) Data Structures
4 4 (5.00%) Replication
5 2 (2.50%) Online Games
6 1 (1.25%) Blog
6 1 (1.25%) Hybrid Cloud
6 1 (1.25%) Linux Command Line
6 1 (1.25%) Private Cloud
Operating Systems
1 15 (18.75%) Linux
1 15 (18.75%) Windows
2 13 (16.25%) Windows Server
3 6 (7.50%) Unix
4 4 (5.00%) Windows Server 2008
5 1 (1.25%) DC/OS
Processes & Methodologies
1 48 (60.00%) Business Intelligence
2 42 (52.50%) ETL
3 29 (36.25%) Kimball Methodology
4 25 (31.25%) Data Modelling
5 24 (30.00%) Agile Software Development
6 23 (28.75%) Visualisation
7 19 (23.75%) Statistics
8 17 (21.25%) Analytics
8 17 (21.25%) Continuous Integration
8 17 (21.25%) Software Engineering
9 16 (20.00%) Data Visualisation
10 14 (17.50%) Scrum
11 13 (16.25%) Data Management
11 13 (16.25%) Data Science
12 10 (12.50%) Performance Analysis
13 9 (11.25%) Actionable Insight
13 9 (11.25%) CRUD
13 9 (11.25%) Infrastructure Management
13 9 (11.25%) Microservices
13 9 (11.25%) Task Automation
Programming Languages
1 73 (91.25%) SQL
2 39 (48.75%) T-SQL
3 26 (32.50%) Python
4 15 (18.75%) C#
4 15 (18.75%) PowerShell
5 12 (15.00%) PL/SQL
5 12 (15.00%) Shell Script
6 11 (13.75%) Java
7 10 (12.50%) R
8 9 (11.25%) Scala
9 6 (7.50%) HiveQL
10 2 (2.50%) VB
11 1 (1.25%) JavaScript
Qualifications
1 12 (15.00%) Degree
2 1 (1.25%) CISSP
2 1 (1.25%) SC Cleared
2 1 (1.25%) Security Cleared
Quality Assurance & Compliance
1 7 (8.75%) Data Quality
2 2 (2.50%) QA
3 1 (1.25%) COBIT
3 1 (1.25%) FedRAMP
3 1 (1.25%) GDPR
3 1 (1.25%) HIPAA
3 1 (1.25%) NIST 800
3 1 (1.25%) SLA
System Software
1 9 (11.25%) Virtual Machines
2 6 (7.50%) Apache Flume
Systems Management
1 2 (2.50%) Ansible
1 2 (2.50%) Opscode Chef
1 2 (2.50%) Terraform
2 1 (1.25%) Puppet
Vendors
1 31 (38.75%) Tableau
2 22 (27.50%) Microsoft
3 15 (18.75%) Oracle
4 8 (10.00%) Talend
5 7 (8.75%) Cloudera
6 6 (7.50%) IBM
6 6 (7.50%) SAP
7 4 (5.00%) VMware
8 3 (3.75%) Google
9 2 (2.50%) Cognos
9 2 (2.50%) MicroStrategy
9 2 (2.50%) MuleSoft
10 1 (1.25%) Hortonworks
10 1 (1.25%) Hyperion
10 1 (1.25%) MapR
10 1 (1.25%) Netezza