Period
to 20 January 2019

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

Snowflake Schema
UK
6 months to
20 Jan 2019
Same period 2018 Same period 2017
Rank 1013 1099 1126
Rank change year-on-year +86 +27 +141
Permanent jobs citing Snowflake Schema 105 81 69
As % of all permanent IT jobs advertised in the UK 0.070% 0.047% 0.039%
As % of the Database & Business Intelligence category 0.25% 0.15% 0.13%
Number of salaries quoted 85 55 64
UK median annual salary £55,000 £52,500 £48,750
Median salary % change year-on-year +4.76% +7.69% +17.47%
10th Percentile £35,850 £37,500 £33,750
90th Percentile £79,000 £80,000 £73,750
UK excluding London median annual salary £50,000 £50,000 £44,000
% change year-on-year - +13.64% +10.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 42,843 52,894 52,886
As % of all permanent IT jobs advertised in the UK 28.64% 30.55% 29.87%
Number of salaries quoted 35,189 43,854 45,270
UK median annual salary £52,500 £48,000 £47,500
Median salary % change year-on-year +9.38% +1.05% +5.56%
10th Percentile £31,250 £30,000 £29,250
90th Percentile £85,000 £77,500 £77,500
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +4.94%

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 20 January 2019.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 12 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 20 January 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
England +105 105 £55,000 +9.45% 15
London +96 74 £60,000 -4.00% 8
UK excluding London +48 31 £50,000 - 7
North of England +32 10 £50,000 +5.26% 1
East of England +31 10 £36,500 -43.85%
South East +37 8 £50,000 -6.98% 4
Yorkshire +29 5 £50,000 +25.00% 1
North West +24 4 - -
East Midlands +21 2 - -
Midlands +20 2 - - 1
North East - 1 £47,500 -
South West - 1 £50,000 - 1

For the 6 months to 20 January 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 with a requirement for Snowflake Schema.

1 96 (91.43%) SQL
2 85 (80.95%) Data Warehouse
3 75 (71.43%) SQL Server
4 65 (61.90%) Business Intelligence
5 58 (55.24%) ETL
6 56 (53.33%) T-SQL
7 48 (45.71%) SQL Server Integration Services
8 47 (44.76%) Tableau
9 46 (43.81%) Data Modelling
10 45 (42.86%) SQL Server Reporting Services
11 42 (40.00%) Microsoft Azure
12 40 (38.10%) Agile Software Development
13 39 (37.14%) Amazon AWS
14 37 (35.24%) Analytics
14 37 (35.24%) Microsoft
15 32 (30.48%) .NET
16 31 (29.52%) Finance
17 30 (28.57%) SQL Server Analysis Services
18 29 (27.62%) PowerShell
18 29 (27.62%) Power BI
18 29 (27.62%) Python
19 27 (25.71%) C#
19 27 (25.71%) Visualisation
20 24 (22.86%) Looker
21 23 (21.90%) Kimball Methodology
21 23 (21.90%) Amazon Redshift
21 23 (21.90%) Oracle
21 23 (21.90%) Data Management
21 23 (21.90%) Degree
22 20 (19.05%) OLAP

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 11 (10.48%) Confluence
2 9 (8.57%) Apache
2 9 (8.57%) Apache Spark
3 3 (2.86%) Oracle SOA Suite
4 2 (1.90%) Apache Airflow
Applications
1 10 (9.52%) Microsoft Excel
Business Applications
1 6 (5.71%) Oracle EBS
1 6 (5.71%) Oracle Retail
2 2 (1.90%) NetSuite
3 1 (0.95%) Dynamics AX
3 1 (0.95%) Dynamics CRM
3 1 (0.95%) Dynamics NAV
Cloud Services
1 42 (40.00%) Microsoft Azure
2 39 (37.14%) Amazon AWS
3 13 (12.38%) Google Cloud Platform
4 12 (11.43%) Cloud Computing
5 9 (8.57%) Azure Data Factory
6 7 (6.67%) Amazon Kinesis
7 5 (4.76%) Amazon SageMaker
7 5 (4.76%) AWS Lambda
7 5 (4.76%) Serverless
8 3 (2.86%) Data Lake Analytics
8 3 (2.86%) IaaS
8 3 (2.86%) PaaS
9 2 (1.90%) Amazon EMR
9 2 (1.90%) GitHub
10 1 (0.95%) Amazon S3
10 1 (0.95%) AWS CloudFormation
10 1 (0.95%) SaaS
Communications & Networking
1 3 (2.86%) FTP
Database & Business Intelligence
1 85 (80.95%) Data Warehouse
2 75 (71.43%) SQL Server
3 48 (45.71%) SQL Server Integration Services
4 45 (42.86%) SQL Server Reporting Services
5 30 (28.57%) SQL Server Analysis Services
6 29 (27.62%) Power BI
7 24 (22.86%) Looker
8 23 (21.90%) Amazon Redshift
9 20 (19.05%) OLAP
9 20 (19.05%) Star Schema
10 19 (18.10%) Azure SQL Database
10 19 (18.10%) Big Data
10 19 (18.10%) MongoDB
11 18 (17.14%) OLTP
12 17 (16.19%) MySQL
13 14 (13.33%) BusinessObjects
13 14 (13.33%) Crystal Reports
13 14 (13.33%) Data Lake
14 12 (11.43%) NoSQL
15 11 (10.48%) BusinessObjects Web Intelligence
Development Applications
1 17 (16.19%) JIRA
2 16 (15.24%) Git (software)
3 6 (5.71%) Oracle APEX
3 6 (5.71%) PVCS
3 6 (5.71%) Toad
4 5 (4.76%) SQL Server Management Studio (SSMS)
5 3 (2.86%) Bitbucket
6 2 (1.90%) Jenkins
6 2 (1.90%) Team Foundation Server
7 1 (0.95%) Maven
7 1 (0.95%) TeamCity
General
1 31 (29.52%) Finance
2 18 (17.14%) Retail
3 9 (8.57%) Games
4 8 (7.62%) Publishing
5 1 (0.95%) Advertising
5 1 (0.95%) Banking
5 1 (0.95%) Retail Banking
Job Titles
1 46 (43.81%) Developer
2 22 (20.95%) Business Intelligence Developer
2 22 (20.95%) SQL Developer
3 18 (17.14%) DBA
3 18 (17.14%) SQL DBA
4 14 (13.33%) SQL Server Developer
5 13 (12.38%) SQL BI Developer
5 13 (12.38%) SQL Server BI Developer
6 11 (10.48%) Analyst
6 11 (10.48%) Data Engineer
6 11 (10.48%) Senior Developer
6 11 (10.48%) SQL Server DBA
7 7 (6.67%) Data Warehouse Developer
8 6 (5.71%) Azure Developer
8 6 (5.71%) Microsoft BI Developer
8 6 (5.71%) Microsoft Developer
8 6 (5.71%) Senior DBA
8 6 (5.71%) Senior SQL DBA
8 6 (5.71%) Senior SQL Server DBA
8 6 (5.71%) Software Engineer
Libraries, Frameworks & Software Standards
1 32 (30.48%) .NET
2 19 (18.10%) Web Services
3 9 (8.57%) Kafka
4 7 (6.67%) XML
5 6 (5.71%) LAMP
5 6 (5.71%) LAPP Stack
6 4 (3.81%) REST
7 3 (2.86%) Oracle GoldenGate
7 3 (2.86%) Spark Streaming
7 3 (2.86%) Velocity
8 2 (1.90%) ASP.NET
8 2 (1.90%) jQuery
9 1 (0.95%) Apache Avro
9 1 (0.95%) Apache Beam
9 1 (0.95%) Apache NiFi
9 1 (0.95%) JSON
9 1 (0.95%) MDX
9 1 (0.95%) RAML
9 1 (0.95%) Swagger
9 1 (0.95%) XGBoost
Miscellaneous
1 12 (11.43%) Greenfield Project
2 10 (9.52%) Analytical Skills
3 6 (5.71%) Data Structures
3 6 (5.71%) Replication
4 3 (2.86%) Online Games
5 1 (0.95%) Blog
5 1 (0.95%) Hybrid Cloud
5 1 (0.95%) Linux Command Line
5 1 (0.95%) Private Cloud
Operating Systems
1 20 (19.05%) Windows
2 18 (17.14%) Windows Server
3 16 (15.24%) Linux
4 6 (5.71%) Unix
4 6 (5.71%) Windows Server 2008
5 1 (0.95%) DC/OS
Processes & Methodologies
1 65 (61.90%) Business Intelligence
2 58 (55.24%) ETL
3 46 (43.81%) Data Modelling
4 40 (38.10%) Agile Software Development
5 37 (35.24%) Analytics
6 27 (25.71%) Visualisation
7 23 (21.90%) Data Management
7 23 (21.90%) Kimball Methodology
8 20 (19.05%) Data Analytics
8 20 (19.05%) Data Visualisation
9 19 (18.10%) Data Integration
9 19 (18.10%) Software Engineering
10 18 (17.14%) Statistics
11 17 (16.19%) Data Science
12 16 (15.24%) Continuous Integration
12 16 (15.24%) Performance Tuning
13 15 (14.29%) User Stories
14 14 (13.33%) Dimensional Modelling
15 13 (12.38%) Mentoring
15 13 (12.38%) Unit Testing
Programming Languages
1 96 (91.43%) SQL
2 56 (53.33%) T-SQL
3 29 (27.62%) PowerShell
3 29 (27.62%) Python
4 27 (25.71%) C#
5 16 (15.24%) Java
6 14 (13.33%) Scala
7 12 (11.43%) PL/SQL
7 12 (11.43%) Shell Script
8 7 (6.67%) JavaScript
9 6 (5.71%) HiveQL
9 6 (5.71%) R
10 5 (4.76%) Ruby
11 2 (1.90%) VB
Qualifications
1 23 (21.90%) Degree
2 8 (7.62%) AWS Certification
3 7 (6.67%) Master's Degree
4 2 (1.90%) Computer Science Degree
Quality Assurance & Compliance
1 19 (18.10%) Data Quality
2 2 (1.90%) QA
3 1 (0.95%) COBIT
System Software
1 12 (11.43%) Virtual Machines
2 6 (5.71%) Apache Flume
Systems Management
1 2 (1.90%) Ansible
1 2 (1.90%) Opscode Chef
1 2 (1.90%) Terraform
2 1 (0.95%) Puppet
Vendors
1 47 (44.76%) Tableau
2 37 (35.24%) Microsoft
3 23 (21.90%) Oracle
4 11 (10.48%) SAP
5 8 (7.62%) Talend
6 7 (6.67%) Cloudera
7 6 (5.71%) IBM
7 6 (5.71%) Informatica
7 6 (5.71%) VMware
8 3 (2.86%) Cognos
8 3 (2.86%) Google
8 3 (2.86%) MicroStrategy
8 3 (2.86%) MuleSoft
8 3 (2.86%) Netezza
9 2 (1.90%) Teradata
10 1 (0.95%) Hortonworks
10 1 (0.95%) Hyperion
10 1 (0.95%) MapR
10 1 (0.95%) RedGate