Period
to 17 January 2018

The following table provides summary statistics for permanent job vacancies 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 January 2018 with a comparison to the same period in the previous 2 years.

Snowflake Schema
UK
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 1082 1104 1248
Rank change year-on-year +22 +144 +5
Permanent jobs citing Snowflake Schema 75 69 35
As % of all permanent IT jobs advertised in the UK 0.043% 0.039% 0.017%
As % of the Database & Business Intelligence category 0.14% 0.13% 0.054%
Number of salaries quoted 50 64 38
UK median annual salary £51,500 £50,000 £41,500
Median salary % change year-on-year +3.00% +20.48% -17.00%
10th Percentile £37,500 £33,750 £32,500
90th Percentile £80,000 £73,750 £63,000
UK excluding London median annual salary £50,000 £44,000 £40,000
% change year-on-year +13.64% +10.00% -20.00%

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

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 52,836 53,088 65,008
As % of all permanent IT jobs advertised in the UK 30.51% 29.85% 31.63%
Number of salaries quoted 43,759 45,430 54,939
UK median annual salary £48,000 £47,500 £45,000
Median salary % change year-on-year +1.05% +5.56% +1.69%
10th Percentile £30,000 £29,375 £28,750
90th Percentile £77,500 £77,500 £75,000
UK excluding London median annual salary £42,500 £42,500 £40,500
% change year-on-year - +4.94% +1.25%

Snowflake Schema
Job Vacancy Trend

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

Job vacancy trend for Snowflake Schema in the UK

Snowflake Schema
Salary Trend

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

Salary trend for Snowflake Schema in the UK

Snowflake Schema
Salary Histogram

The salary distribution of IT jobs citing Snowflake Schema over the 6 months to 17 January 2018.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 9 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the UK over the 6 months to 17 January 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
England +12 68 £50,000 +2.56% 7
UK excluding London +13 43 £50,000 +13.64% 3
London +30 32 £66,250 -1.85% 4
North of England +4 18 £47,500 +29.25% 1
East of England +26 11 £65,000 +18.18%
North West 0 10 £47,500 +33.80% 1
Yorkshire +17 8 £40,000 -
South East +10 7 £52,500 +14.13% 1
Scotland -23 7 £62,000 +55.00%

For the 6 months to 17 January 2018, IT jobs citing Snowflake Schema also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for Snowflake Schema.

1 61 (81.33%) Business Intelligence
2 57 (76.00%) SQL
3 45 (60.00%) Visualisation
4 43 (57.33%) Data Warehouse
5 42 (56.00%) SQL Server
6 41 (54.67%) Data Visualisation
7 40 (53.33%) Data Modelling
8 39 (52.00%) ETL
8 39 (52.00%) Analytics
9 29 (38.67%) Star Schema
10 28 (37.33%) SQL Server Integration Services
11 27 (36.00%) SQL Server Reporting Services
12 25 (33.33%) Oracle
12 25 (33.33%) T-SQL
13 23 (30.67%) Data Analytics
14 22 (29.33%) Microsoft
15 21 (28.00%) Degree
15 21 (28.00%) Dimensional Modelling
16 20 (26.67%) SQL Server Analysis Services
17 19 (25.33%) Power BI
18 18 (24.00%) Kimball Methodology
18 18 (24.00%) Tableau
18 18 (24.00%) MySQL
19 16 (21.33%) Microsoft Excel
19 16 (21.33%) Computer Science
20 15 (20.00%) Vertica
20 15 (20.00%) MongoDB
20 15 (20.00%) NoSQL
20 15 (20.00%) Statistics
20 15 (20.00%) Marketing

Snowflake Schema
Co-occurring IT Skills 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 6 (8.00%) JBoss
1 6 (8.00%) WildFly
2 3 (4.00%) Oracle SOA Suite
3 2 (2.67%) SharePoint
4 1 (1.33%) Apache
4 1 (1.33%) SAS
Applications
1 16 (21.33%) Microsoft Excel
2 1 (1.33%) MS Visio
Cloud Services
1 10 (13.33%) Amazon AWS
2 8 (10.67%) Microsoft Azure
3 7 (9.33%) Azure Data Factory
4 5 (6.67%) Google Analytics
5 4 (5.33%) Azure Machine Learning
6 2 (2.67%) Data Lake Analytics
Database & Business Intelligence
1 43 (57.33%) Data Warehouse
2 42 (56.00%) SQL Server
3 29 (38.67%) Star Schema
4 28 (37.33%) SQL Server Integration Services
5 27 (36.00%) SQL Server Reporting Services
6 20 (26.67%) SQL Server Analysis Services
7 19 (25.33%) Power BI
8 18 (24.00%) MySQL
9 15 (20.00%) MongoDB
9 15 (20.00%) NoSQL
10 14 (18.67%) QlikView
11 12 (16.00%) Hadoop
12 10 (13.33%) Amazon RDS
12 10 (13.33%) Apache Hive
12 10 (13.33%) Big Data
12 10 (13.33%) Relational Database
13 9 (12.00%) Enterprise Data Warehouse
13 9 (12.00%) Qlik Sense
14 8 (10.67%) BusinessObjects
15 6 (8.00%) RDBMS
Development Applications
1 10 (13.33%) SQL Server Management Studio (SSMS)
2 1 (1.33%) ERwin
2 1 (1.33%) Team Foundation Server
2 1 (1.33%) Toad
2 1 (1.33%) VSS/SourceSafe
General
1 15 (20.00%) Advertising
1 15 (20.00%) Marketing
2 9 (12.00%) Finance
3 7 (9.33%) Retail
4 5 (6.67%) Publishing
5 4 (5.33%) Automotive
6 2 (2.67%) Banking
6 2 (2.67%) Financial Institution
7 1 (1.33%) Investment Banking
7 1 (1.33%) Manufacturing
7 1 (1.33%) Pharmaceutical
7 1 (1.33%) Retail Finance
7 1 (1.33%) Telecoms
Job Titles
1 33 (44.00%) Developer
2 21 (28.00%) Consultant
3 19 (25.33%) Business Intelligence Consultant
3 19 (25.33%) Business Intelligence Developer
4 17 (22.67%) Architect
5 16 (21.33%) Analytics Consultant
5 16 (21.33%) Data Analytics Consultant
5 16 (21.33%) Data Consultant
6 14 (18.67%) Data Visualisation Consultant
7 13 (17.33%) SQL Developer
8 8 (10.67%) Analytics Developer
8 8 (10.67%) Data Visualisation Developer
8 8 (10.67%) Lead Developer
9 7 (9.33%) Business Intelligence Architect
9 7 (9.33%) SQL BI Developer
10 6 (8.00%) Data Model Consultant
10 6 (8.00%) ETL Developer
11 5 (6.67%) Microsoft BI Consultant
11 5 (6.67%) Microsoft Consultant
11 5 (6.67%) Tableau Developer
Libraries, Frameworks & Software Standards
1 6 (8.00%) Java EE
1 6 (8.00%) JSON
1 6 (8.00%) Spring
2 4 (5.33%) REST
3 3 (4.00%) D3.js
3 3 (4.00%) Entity Framework
3 3 (4.00%) Middleware
3 3 (4.00%) XML
4 1 (1.33%) MDX
4 1 (1.33%) RESTful
4 1 (1.33%) Web Services
Miscellaneous
1 16 (21.33%) Computer Science
2 10 (13.33%) Analytical Skills
3 5 (6.67%) Management Information System
4 4 (5.33%) Driving Licence
4 4 (5.33%) Greenfield Project
5 3 (4.00%) Fintech
5 3 (4.00%) N-Tier
5 3 (4.00%) User Experience
6 1 (1.33%) Algorithms
6 1 (1.33%) Market Risk
Operating Systems
1 15 (20.00%) Linux
1 15 (20.00%) Windows
Processes & Methodologies
1 61 (81.33%) Business Intelligence
2 45 (60.00%) Visualisation
3 41 (54.67%) Data Visualisation
4 40 (53.33%) Data Modelling
5 39 (52.00%) Analytics
5 39 (52.00%) ETL
6 23 (30.67%) Data Analytics
7 21 (28.00%) Dimensional Modelling
8 18 (24.00%) Kimball Methodology
9 15 (20.00%) Marketing Intelligence
9 15 (20.00%) Statistics
10 13 (17.33%) Data Integration
11 12 (16.00%) TOGAF
12 10 (13.33%) Migration
13 8 (10.67%) Dashboard Development
13 8 (10.67%) Predictive Analytics
14 7 (9.33%) Data Architecture
14 7 (9.33%) High Availability
14 7 (9.33%) Machine Learning
14 7 (9.33%) Performance Tuning
Programming Languages
1 57 (76.00%) SQL
2 25 (33.33%) T-SQL
3 15 (20.00%) VB
3 15 (20.00%) VBA
4 7 (9.33%) Python
5 6 (8.00%) Java
6 5 (6.67%) R
7 4 (5.33%) PowerShell
8 3 (4.00%) COBOL
8 3 (4.00%) Data Analysis Expressions (DAX)
8 3 (4.00%) JavaScript
8 3 (4.00%) JCL
9 2 (2.67%) C#
10 1 (1.33%) PL/SQL
10 1 (1.33%) SAS Macro
Qualifications
1 21 (28.00%) Degree
2 1 (1.33%) Computer Science Degree
2 1 (1.33%) PhD
Quality Assurance & Compliance
1 5 (6.67%) Data Quality
Vendors
1 25 (33.33%) Oracle
2 22 (29.33%) Microsoft
3 18 (24.00%) Tableau
4 15 (20.00%) Vertica
5 8 (10.67%) SAP
6 5 (6.67%) Google
6 5 (6.67%) Salesforce.com
7 4 (5.33%) Infor
8 2 (2.67%) Ab Initio
8 2 (2.67%) Twitter
9 1 (1.33%) Cognos
9 1 (1.33%) Informatica
9 1 (1.33%) TARGIT