The table below looks at the statistics for Snowflake Schema skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited Snowflake Schema over the 3 months to 31 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
31 May 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 910 946 970
Rank change year-on-year
+36 +24
Permanent jobs citing Snowflake Schema 7 5 27
As % of all permanent IT jobs located in the UK 0.007% 0.005% 0.023%
As % of the Database & Business Intelligence category 0.024% 0.014% 0.070%
Number of salaries quoted 6 5 23
Median salary £57,500 £37,500 £45,000
Median salary % change year-on-year
+53.33% -16.66%
90% offered a salary of more than £55,000 £35,400 £40,000
10% offered a salary of more than £72,500 £54,000 £47,500
UK excluding London median salary £55,000 £37,500 £43,750
% change year-on-year
+46.66% -14.28%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
29747 34616 38736
As % of all permanent IT jobs located in the UK 30.25% 32.44% 32.42%
Number of salaries quoted 25362 29214 33250
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £31,500 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

Snowflake Schema
Jobs Demand Trend

The demand trend of job ads citing Snowflake Schema as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

Snowflake Schema Jobs Demand Trend 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 within the UK.

Snowflake Schema Salary Trend in the UK

Snowflake Schema
Salary Histogram

This chart provides a salary histogram for IT jobs citing Snowflake Schema over the 3 months to 31 May 2016 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 7 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 3 months to 31 May 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +31 6 £57,500 +53.33%
South West - 3 £55,000 -
Cheltenham - 3 £55,000 -
Gloucestershire - 3 £55,000 -
North West - 2 £60,000 -
Manchester - 2 £60,000 -
London +9 1 £85,000 +54.54%

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 31 May 2016, 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 17 (89.47%) Data Warehouse
1 17 (89.47%) Business Intelligence
2 15 (78.95%) SQL
3 13 (68.42%) ETL
4 12 (63.16%) Star Schema
5 11 (57.89%) Data Modelling
5 11 (57.89%) Microsoft
5 11 (57.89%) SQL Server
5 11 (57.89%) SQL Server Reporting Services
5 11 (57.89%) SQL Server Integration Services
5 11 (57.89%) SQL Server Analysis Services
6 10 (52.63%) Data Mart
6 10 (52.63%) OLAP
7 9 (47.37%) Refactoring
7 9 (47.37%) RDBMS
7 9 (47.37%) Kimball Methodology
7 9 (47.37%) Relational Database
8 8 (42.11%) Power BI
9 6 (31.58%) Data Structures
9 6 (31.58%) MDX
9 6 (31.58%) Test Scripting
9 6 (31.58%) Visual Studio
9 6 (31.58%) C#
9 6 (31.58%) VB
9 6 (31.58%) SOAP
9 6 (31.58%) Web Services
9 6 (31.58%) XML
9 6 (31.58%) XSL
9 6 (31.58%) BizTalk Server
9 6 (31.58%) OpenView

Snowflake Schema
Top Related 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 (31.58%) BizTalk Server
2 2 (10.53%) Apache Pig
3 1 (5.26%) Apache Spark
3 1 (5.26%) SAS
Applications
1 1 (5.26%) SPSS
Business Applications
1 2 (10.53%) Dynamics NAV
2 1 (5.26%) SAP APO
Cloud Services
1 3 (15.79%) Microsoft Azure
Database & Business Intelligence
1 17 (89.47%) Data Warehouse
2 12 (63.16%) Star Schema
3 11 (57.89%) SQL Server
3 11 (57.89%) SQL Server Analysis Services
3 11 (57.89%) SQL Server Integration Services
3 11 (57.89%) SQL Server Reporting Services
4 10 (52.63%) Data Mart
4 10 (52.63%) OLAP
5 9 (47.37%) RDBMS
5 9 (47.37%) Relational Database
6 8 (42.11%) Power BI
7 6 (31.58%) BusinessObjects
8 3 (15.79%) Apache Hive
8 3 (15.79%) Azure SQL Database
8 3 (15.79%) Big Data
8 3 (15.79%) Biml
8 3 (15.79%) Hadoop
8 3 (15.79%) QlikView
8 3 (15.79%) SQL Server 2012
9 2 (10.53%) MySQL
Development Applications
1 6 (31.58%) Visual Studio
2 4 (21.05%) ERwin
3 2 (10.53%) Git (software)
3 2 (10.53%) Team Foundation Server
General
1 2 (10.53%) Advertising
2 1 (5.26%) Banking
2 1 (5.26%) Finance
2 1 (5.26%) Pharmaceutical
Job Titles
1 17 (89.47%) Developer
2 10 (52.63%) Business Intelligence Developer
3 6 (31.58%) Analyst
3 6 (31.58%) Analyst Developer
3 6 (31.58%) Business Intelligence Analyst
3 6 (31.58%) Developer Analyst
3 6 (31.58%) Report Analyst
3 6 (31.58%) Report Developer
4 5 (26.32%) MicroStrategy Developer
5 3 (15.79%) Business Intelligence Lead
5 3 (15.79%) Data Warehouse Developer
5 3 (15.79%) Lead Developer
6 2 (10.53%) Architect
6 2 (10.53%) Data Architect
7 1 (5.26%) Big Data Architect
7 1 (5.26%) Data Modeller
7 1 (5.26%) Principal Architect
7 1 (5.26%) Principal Data Architect
Libraries, Frameworks & Software Standards
1 6 (31.58%) MDX
1 6 (31.58%) SOAP
1 6 (31.58%) Web Services
1 6 (31.58%) XML
1 6 (31.58%) XSL
Miscellaneous
1 6 (31.58%) Data Structures
2 4 (21.05%) Analytical Skills
3 2 (10.53%) Visualisation
4 1 (5.26%) Fintech
Processes & Methodologies
1 17 (89.47%) Business Intelligence
2 13 (68.42%) ETL
3 11 (57.89%) Data Modelling
4 9 (47.37%) Kimball Methodology
4 9 (47.37%) Refactoring
5 6 (31.58%) Test Scripting
6 5 (26.32%) Open Source
7 4 (21.05%) Analytics
7 4 (21.05%) Data Cleansing
7 4 (21.05%) Data Transformation
7 4 (21.05%) Enterprise Architecture
7 4 (21.05%) High Availability
7 4 (21.05%) Performance Tuning
8 3 (15.79%) Agile Software Development
8 3 (15.79%) Scrum
9 2 (10.53%) E-Commerce
9 2 (10.53%) Mentoring
10 1 (5.26%) Kalman Filter
10 1 (5.26%) Logical Data Model
10 1 (5.26%) Physical Data Model
Programming Languages
1 15 (78.95%) SQL
2 6 (31.58%) C#
2 6 (31.58%) VB
3 3 (15.79%) Python
4 2 (10.53%) R
4 2 (10.53%) T-SQL
5 1 (5.26%) Bash Shell
5 1 (5.26%) C-shell
5 1 (5.26%) Java
Qualifications
1 4 (21.05%) Degree
System Software
1 1 (5.26%) Apache Flume
Systems Management
1 6 (31.58%) OpenView
2 1 (5.26%) Hadoop YARN
2 1 (5.26%) Oozie
2 1 (5.26%) Oracle Enterprise Manager
Vendors
1 11 (57.89%) Microsoft
2 5 (26.32%) MicroStrategy
3 3 (15.79%) Alteryx
3 3 (15.79%) Teradata
4 2 (10.53%) Google
4 2 (10.53%) Oracle
4 2 (10.53%) Tableau
5 1 (5.26%) Cloudera
5 1 (5.26%) Cognos
5 1 (5.26%) Hortonworks
5 1 (5.26%) IBM
5 1 (5.26%) MapR
5 1 (5.26%) SAP