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

Snowflake Schema
England > London
6 months to
24 May 2018
Same period 2017 Same period 2016
Rank 736 795 888
Rank change year-on-year +59 +93 +12
Permanent jobs citing Snowflake Schema 79 35 13
As % of all permanent IT jobs advertised in London 0.11% 0.051% 0.016%
As % of the Database & Business Intelligence category 0.36% 0.17% 0.051%
Number of salaries quoted 51 11 8
London median annual salary £65,000 £47,500 £71,250
Median salary % change year-on-year +36.84% -33.33% +23.91%
10th Percentile £47,500 £38,750 £59,625
90th Percentile £80,000 £55,000 £81,500
England median annual salary £52,500 £42,500 £55,000
% change year-on-year +23.53% -22.73% +4.76%

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 21,719 20,795 25,313
As % of all permanent IT jobs advertised in London 31.34% 30.42% 30.77%
Number of salaries quoted 17,355 17,884 22,067
London median annual salary £60,000 £60,000 £55,000
Median salary % change year-on-year - +9.09% -
10th Percentile £37,500 £36,250 £36,250
90th Percentile £92,500 £90,000 £85,000
England median annual salary £50,000 £47,500 £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 24 May 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 24 May 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
Central London 0 21 £67,500 +50.00% 1
West London - 1 £52,500 -
Snowflake Schema
England

For the 6 months to 24 May 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 77 (97.47%) SQL
2 54 (68.35%) Business Intelligence
3 49 (62.03%) ETL
4 48 (60.76%) SQL Server
5 45 (56.96%) Data Warehouse
6 44 (55.70%) Data Modelling
6 44 (55.70%) SQL Server Integration Services
7 35 (44.30%) Agile Software Development
8 33 (41.77%) Visualisation
9 32 (40.51%) Analytics
10 30 (37.97%) SQL Server Reporting Services
11 28 (35.44%) Data Visualisation
12 27 (34.18%) PowerShell
13 25 (31.65%) Dimensional Modelling
13 25 (31.65%) Microsoft
13 25 (31.65%) Power BI
14 24 (30.38%) Star Schema
14 24 (30.38%) Oracle
15 23 (29.11%) Linux
15 23 (29.11%) T-SQL
15 23 (29.11%) MySQL
15 23 (29.11%) SQL Server Analysis Services
16 22 (27.85%) Computer Science
17 21 (26.58%) Statistics
17 21 (26.58%) Marketing
17 21 (26.58%) Microsoft Azure
17 21 (26.58%) Data Analytics
18 20 (25.32%) NoSQL
18 20 (25.32%) Degree
18 20 (25.32%) SQL Optimisation

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 5 (6.33%) R Markdown
2 2 (2.53%) Apache Spark
Applications
1 19 (24.05%) Microsoft Excel
Cloud Services
1 21 (26.58%) Microsoft Azure
2 4 (5.06%) Amazon AWS
2 4 (5.06%) Azure Data Factory
2 4 (5.06%) Data Lake Analytics
3 3 (3.80%) PaaS
4 2 (2.53%) Google Cloud Platform
4 2 (2.53%) IaaS
4 2 (2.53%) SaaS
Communications & Networking
1 5 (6.33%) Network Security
Database & Business Intelligence
1 48 (60.76%) SQL Server
2 45 (56.96%) Data Warehouse
3 44 (55.70%) SQL Server Integration Services
4 30 (37.97%) SQL Server Reporting Services
5 25 (31.65%) Power BI
6 24 (30.38%) Star Schema
7 23 (29.11%) MySQL
7 23 (29.11%) SQL Server Analysis Services
8 20 (25.32%) NoSQL
9 19 (24.05%) Azure SQL Database
9 19 (24.05%) MongoDB
9 19 (24.05%) OLAP
9 19 (24.05%) OLTP
10 13 (16.46%) SQL Server 2012
11 10 (12.66%) Big Data
11 10 (12.66%) SQL Server 2016
12 8 (10.13%) SQL Server 2008
13 7 (8.86%) OLAP Cube
14 6 (7.59%) Data Lake
14 6 (7.59%) Pentaho
Development Applications
1 8 (10.13%) Git (software)
1 8 (10.13%) Team Foundation Server
2 7 (8.86%) SQL Server Management Studio (SSMS)
3 5 (6.33%) RStudio
4 1 (1.27%) ERwin
General
1 21 (26.58%) Marketing
2 18 (22.78%) Finance
3 9 (11.39%) Advertising
4 4 (5.06%) Games
5 1 (1.27%) Financial Institution
5 1 (1.27%) Legal
5 1 (1.27%) Manufacturing
5 1 (1.27%) Pharmaceutical
5 1 (1.27%) Retail
Job Titles
1 50 (63.29%) Developer
2 42 (53.16%) SQL Developer
3 25 (31.65%) Business Intelligence Developer
4 23 (29.11%) SQL BI Developer
5 19 (24.05%) Analytics Developer
5 19 (24.05%) Data Visualisation Developer
6 10 (12.66%) Architect
7 9 (11.39%) Business Intelligence Consultant
7 9 (11.39%) Consultant
7 9 (11.39%) Data Architect
8 8 (10.13%) Database Developer
8 8 (10.13%) SQL Database Developer
9 6 (7.59%) Microsoft BI Consultant
9 6 (7.59%) Microsoft Consultant
9 6 (7.59%) Senior Business Intelligence Developer
9 6 (7.59%) Senior Developer
9 6 (7.59%) SSIS Developer
10 5 (6.33%) Analyst
10 5 (6.33%) Python Developer
10 5 (6.33%) SQL Analyst
Libraries, Frameworks & Software Standards
1 15 (18.99%) .NET
2 8 (10.13%) SOAP
3 7 (8.86%) MDX
3 7 (8.86%) REST
4 4 (5.06%) D3.js
5 2 (2.53%) Kafka
Miscellaneous
1 22 (27.85%) Computer Science
2 12 (15.19%) Greenfield Project
3 7 (8.86%) Analytical Skills
4 6 (7.59%) Driving Licence
5 4 (5.06%) User Experience
6 3 (3.80%) Data Structures
6 3 (3.80%) Reference Data
6 3 (3.80%) Tandem
7 1 (1.27%) Algorithms
Operating Systems
1 23 (29.11%) Linux
2 19 (24.05%) Windows
Processes & Methodologies
1 54 (68.35%) Business Intelligence
2 49 (62.03%) ETL
3 44 (55.70%) Data Modelling
4 35 (44.30%) Agile Software Development
5 33 (41.77%) Visualisation
6 32 (40.51%) Analytics
7 28 (35.44%) Data Visualisation
8 25 (31.65%) Dimensional Modelling
9 21 (26.58%) Data Analytics
9 21 (26.58%) Statistics
10 20 (25.32%) SQL Optimisation
11 19 (24.05%) Marketing Intelligence
12 14 (17.72%) Mentoring
12 14 (17.72%) Release Management
13 13 (16.46%) Performance Tuning
14 10 (12.66%) Kimball Methodology
15 9 (11.39%) Problem-Solving
15 9 (11.39%) SDLC
16 8 (10.13%) Data Science
17 7 (8.86%) Data Strategy
Programming Languages
1 77 (97.47%) SQL
2 27 (34.18%) PowerShell
3 23 (29.11%) T-SQL
4 19 (24.05%) VB
4 19 (24.05%) VBA
5 9 (11.39%) Python
6 7 (8.86%) R
7 4 (5.06%) JavaScript
8 3 (3.80%) Data Analysis Expressions (DAX)
9 2 (2.53%) C#
9 2 (2.53%) Java
10 1 (1.27%) U-SQL
Qualifications
1 20 (25.32%) Degree
2 1 (1.27%) Computer Science Degree
Quality Assurance & Compliance
1 8 (10.13%) Data Quality
System Software
1 2 (2.53%) Apache Flume
Vendors
1 25 (31.65%) Microsoft
2 24 (30.38%) Oracle
3 19 (24.05%) Vertica
4 15 (18.99%) Tableau
5 5 (6.33%) SAP
6 4 (5.06%) Informatica
6 4 (5.06%) MicroStrategy
7 3 (3.80%) Teradata
8 2 (2.53%) Cognos
8 2 (2.53%) IBM
8 2 (2.53%) Netezza
8 2 (2.53%) SnapLogic
8 2 (2.53%) Talend
9 1 (1.27%) RedGate