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

Snowflake Schema
UK
6 months to
17 Nov 2018
Same period 2017 Same period 2016
Rank 1043 1156 1165
Rank change year-on-year +113 +9 +94
Permanent jobs citing Snowflake Schema 112 48 66
As % of all permanent IT jobs advertised in the UK 0.069% 0.027% 0.035%
As % of the Database & Business Intelligence category 0.24% 0.088% 0.12%
Number of salaries quoted 93 22 60
UK median annual salary £52,500 £53,750 £60,000
Median salary % change year-on-year -2.33% -10.42% +44.58%
10th Percentile £34,750 £37,625 £34,900
90th Percentile £73,750 £82,250 £78,750
UK excluding London median annual salary £50,000 £52,500 £45,000
% change year-on-year -4.76% +16.67% +8.43%

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 47,127 54,489 56,356
As % of all permanent IT jobs advertised in the UK 29.11% 30.22% 29.63%
Number of salaries quoted 38,769 44,834 48,117
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £31,250 £30,000 £28,750
90th Percentile £83,750 £77,500 £76,750
UK excluding London median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.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 November 2018.

Salary histogram for Snowflake Schema in the UK

Snowflake Schema
Top 13 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 November 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 +93 112 £52,500 +1.94% 9
London +86 62 £62,500 -21.88% 7
UK excluding London +59 50 £50,000 -4.76% 2
South East +41 23 £52,500 -
North of England +33 13 £50,000 +17.65% 1
East of England +32 9 £36,500 -47.86% 1
North West +21 8 £27,500 -42.11%
Yorkshire +33 4 £50,000 +25.00% 1
South West - 3 - -
Wales - 3 - -
East Midlands - 2 - -
Midlands - 2 - -
North East - 1 £47,500 -

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

1 98 (87.50%) SQL
2 93 (83.04%) Data Warehouse
3 67 (59.82%) SQL Server
4 66 (58.93%) ETL
5 62 (55.36%) Business Intelligence
6 55 (49.11%) T-SQL
7 54 (48.21%) SQL Server Reporting Services
7 54 (48.21%) SQL Server Integration Services
8 49 (43.75%) Tableau
9 47 (41.96%) Finance
10 46 (41.07%) Power BI
11 45 (40.18%) PowerShell
12 42 (37.50%) Data Modelling
13 41 (36.61%) .NET
14 36 (32.14%) Agile Software Development
15 34 (30.36%) Microsoft
15 34 (30.36%) Microsoft Azure
16 32 (28.57%) Amazon AWS
16 32 (28.57%) Analytics
17 30 (26.79%) Degree
17 30 (26.79%) Visualisation
18 27 (24.11%) Oracle
19 26 (23.21%) Greenfield Project
20 25 (22.32%) Windows
20 25 (22.32%) Data Visualisation
21 24 (21.43%) Data Management
22 23 (20.54%) Web Services
23 22 (19.64%) OLTP
23 22 (19.64%) Data Quality
23 22 (19.64%) Big Data

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 10 (8.93%) Confluence
2 6 (5.36%) Oracle SOA Suite
3 3 (2.68%) BizTalk Server
3 3 (2.68%) SharePoint
4 2 (1.79%) Apache
4 2 (1.79%) Apache Spark
5 1 (0.89%) Apache Airflow
Applications
1 10 (8.93%) Microsoft Excel
2 3 (2.68%) Microsoft Office
Business Applications
1 6 (5.36%) Oracle EBS
1 6 (5.36%) Oracle Retail
2 4 (3.57%) SAP S/4HANA
3 2 (1.79%) NetSuite
Cloud Services
1 34 (30.36%) Microsoft Azure
2 32 (28.57%) Amazon AWS
3 12 (10.71%) Cloud Computing
4 11 (9.82%) Google Cloud Platform
5 9 (8.04%) Azure Data Factory
6 5 (4.46%) Amazon Kinesis
7 4 (3.57%) Amazon SageMaker
7 4 (3.57%) AWS Lambda
7 4 (3.57%) Serverless
8 3 (2.68%) Data Lake Analytics
8 3 (2.68%) IaaS
8 3 (2.68%) PaaS
9 1 (0.89%) Amazon EMR
9 1 (0.89%) Amazon S3
9 1 (0.89%) GitHub
Database & Business Intelligence
1 93 (83.04%) Data Warehouse
2 67 (59.82%) SQL Server
3 54 (48.21%) SQL Server Integration Services
3 54 (48.21%) SQL Server Reporting Services
4 46 (41.07%) Power BI
5 22 (19.64%) Amazon Redshift
5 22 (19.64%) Big Data
5 22 (19.64%) Looker
5 22 (19.64%) OLTP
5 22 (19.64%) SQL Server Analysis Services
6 18 (16.07%) BusinessObjects
6 18 (16.07%) Crystal Reports
7 17 (15.18%) MySQL
8 15 (13.39%) Azure SQL Database
8 15 (13.39%) OLAP
9 13 (11.61%) Data Lake
10 12 (10.71%) MongoDB
10 12 (10.71%) SQL Server 2008
11 11 (9.82%) BusinessObjects Web Intelligence
11 11 (9.82%) NoSQL
Development Applications
1 15 (13.39%) Git (software)
1 15 (13.39%) JIRA
2 6 (5.36%) Oracle APEX
2 6 (5.36%) PVCS
2 6 (5.36%) Toad
3 5 (4.46%) SQL Server Management Studio (SSMS)
4 2 (1.79%) Bitbucket
4 2 (1.79%) Team Foundation Server
5 1 (0.89%) Jenkins
5 1 (0.89%) Maven
General
1 47 (41.96%) Finance
2 11 (9.82%) Retail
3 8 (7.14%) Games
3 8 (7.14%) Publishing
4 3 (2.68%) Advertising
Job Titles
1 55 (49.11%) Developer
2 31 (27.68%) SQL Developer
3 20 (17.86%) DBA
3 20 (17.86%) SQL DBA
4 16 (14.29%) Business Intelligence Developer
5 13 (11.61%) SQL Server DBA
6 12 (10.71%) Analyst
7 10 (8.93%) Business Intelligence Analyst
7 10 (8.93%) SQL Server Developer
8 9 (8.04%) Data Engineer
8 9 (8.04%) Senior Developer
8 9 (8.04%) SQL BI Developer
8 9 (8.04%) SQL Server BI Developer
9 8 (7.14%) Senior DBA
9 8 (7.14%) Senior SQL DBA
9 8 (7.14%) Senior SQL Server DBA
10 7 (6.25%) Data Warehouse Developer
11 6 (5.36%) Business Intelligence Specialist
11 6 (5.36%) ETL Developer
11 6 (5.36%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 41 (36.61%) .NET
2 23 (20.54%) Web Services
3 7 (6.25%) XML
4 6 (5.36%) REST
5 3 (2.68%) Oracle GoldenGate
5 3 (2.68%) SOAP
5 3 (2.68%) Velocity
6 2 (1.79%) ASP.NET
6 2 (1.79%) jQuery
6 2 (1.79%) Kafka
6 2 (1.79%) Spark Streaming
7 1 (0.89%) Apache Avro
7 1 (0.89%) XGBoost
Miscellaneous
1 26 (23.21%) Greenfield Project
2 10 (8.93%) Analytical Skills
3 8 (7.14%) Computer Science
3 8 (7.14%) Replication
4 4 (3.57%) Reference Data
4 4 (3.57%) Tandem
5 3 (2.68%) Enterprise Software
5 3 (2.68%) Management Information System
5 3 (2.68%) Online Games
6 1 (0.89%) Hybrid Cloud
6 1 (0.89%) Linux Command Line
6 1 (0.89%) Private Cloud
Operating Systems
1 25 (22.32%) Windows
2 20 (17.86%) Windows Server
3 10 (8.93%) Linux
4 8 (7.14%) Windows Server 2008
5 6 (5.36%) Unix
6 1 (0.89%) DC/OS
Processes & Methodologies
1 66 (58.93%) ETL
2 62 (55.36%) Business Intelligence
3 42 (37.50%) Data Modelling
4 36 (32.14%) Agile Software Development
5 32 (28.57%) Analytics
6 30 (26.79%) Visualisation
7 25 (22.32%) Data Visualisation
8 24 (21.43%) Data Management
9 19 (16.96%) Data Integration
10 18 (16.07%) Performance Tuning
10 18 (16.07%) Software Engineering
11 16 (14.29%) Dimensional Modelling
12 15 (13.39%) Continuous Integration
12 15 (13.39%) SDLC
12 15 (13.39%) User Stories
13 14 (12.50%) Data Science
13 14 (12.50%) Kimball Methodology
13 14 (12.50%) Performance Analysis
14 13 (11.61%) Data Analytics
14 13 (11.61%) Mentoring
Programming Languages
1 98 (87.50%) SQL
2 55 (49.11%) T-SQL
3 45 (40.18%) PowerShell
4 21 (18.75%) C#
5 20 (17.86%) Python
6 8 (7.14%) Java
7 6 (5.36%) PL/SQL
7 6 (5.36%) Scala
7 6 (5.36%) Shell Script
8 5 (4.46%) JavaScript
8 5 (4.46%) R
9 4 (3.57%) Ruby
Qualifications
1 30 (26.79%) Degree
2 11 (9.82%) Master's Degree
3 9 (8.04%) AWS Certification
4 3 (2.68%) ITIL Certification
4 3 (2.68%) Postgraduate
5 2 (1.79%) Computer Science Degree
Quality Assurance & Compliance
1 22 (19.64%) Data Quality
2 1 (0.89%) QA
System Software
1 12 (10.71%) Virtual Machines
Systems Management
1 1 (0.89%) Ansible
1 1 (0.89%) Opscode Chef
1 1 (0.89%) Puppet
1 1 (0.89%) Terraform
Vendors
1 49 (43.75%) Tableau
2 34 (30.36%) Microsoft
3 27 (24.11%) Oracle
4 15 (13.39%) SAP
5 8 (7.14%) Informatica
5 8 (7.14%) VMware
6 3 (2.68%) Cognos
6 3 (2.68%) Google
6 3 (2.68%) MicroStrategy
6 3 (2.68%) MuleSoft
6 3 (2.68%) Salesforce.com
7 2 (1.79%) Netezza
7 2 (1.79%) Teradata
8 1 (0.89%) Cloudera
8 1 (0.89%) Hortonworks
8 1 (0.89%) MapR
8 1 (0.89%) RedGate