The first table below looks at the demand for Snowflake Schema skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited Snowflake Schema over the 3 months to 30 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Location
3 months to
30 Jul 2014
Same period 2013 Same period 2012
Snowflake Schema
Rank 877 877 881
Rank change year-on-year
0 +4
Permanent jobs citing Snowflake Schema 24 10 20
As % of all permanent IT jobs located in the UK 0.021% 0.009% 0.017%
As % of the Database & Business Intelligence category 0.066% 0.029% 0.055%
Number of salaries quoted 24 6 17
Average salary £45,000 £37,500 £40,000
Average salary % change year-on-year
+20.00% -6.25%
90% offered a salary of more than £41,000 £37,500 £28,000
10% offered a salary of more than £60,000 £48,750 £60,000
UK excluding London average salary £42,500 £37,500 £40,000
% change year-on-year
+13.33% -6.25%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36236 33955 36425
As % of all permanent IT jobs located in the UK 30.98% 31.23% 30.97%
Number of salaries quoted 30959 29265 32095
Average salary £45,000 £42,500 £42,500
Average salary % change year-on-year
+5.88% -
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%

Snowflake Schema
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing Snowflake Schema within the UK as a proportion of the total demand within 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 30 July 2014 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 19 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 30 July 2014. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -14 22 £45,000 +20.00%
London -48 7 £60,000 +9.09%
Nottingham - 6 £42,500 -
East Midlands - 6 £42,500 -
Nottinghamshire - 6 £42,500 -
South East - 5 £45,000 -
West Midlands - 3 £40,000 -
West Sussex - 3 £45,000 -
Worcestershire - 3 £40,000 -
East Grinstead - 3 £45,000 -
Worcester - 3 £40,000 -
Edinburgh - 2 £47,000 -
Scotland - 2 £47,000 -
City of London - 1 £90,000 -
Surrey - 1 £50,000 -
Hampshire - 1 £45,000 -
Southampton - 1 £45,000 -
Woking - 1 £50,000 -
Crawley - 1 £45,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 30 July 2014, IT jobs within the UK citing Snowflake Schema also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Snowflake Schema.

1 44 (93.62%) Business Intelligence
2 40 (85.11%) Data Warehouse
3 39 (82.98%) ETL
4 37 (78.72%) SQL
5 33 (70.21%) Star Schema
6 31 (65.96%) Dimensional Modelling
7 28 (59.57%) SQL Server Integration Services
8 27 (57.45%) SQL Server Reporting Services
9 25 (53.19%) SQL Server
10 23 (48.94%) Oracle
10 23 (48.94%) Data Modelling
11 20 (42.55%) Kimball Methodology
12 18 (38.30%) PL/SQL
13 17 (36.17%) Microsoft
13 17 (36.17%) SQL Server 2008
14 16 (34.04%) Oracle BI EE
14 16 (34.04%) OLAP
14 16 (34.04%) Oracle Database
15 15 (31.91%) SQL Server Analysis Services
15 15 (31.91%) Data Mart
16 13 (27.66%) SQL Server 2012
17 12 (25.53%) Relational Database
17 12 (25.53%) RDBMS
18 10 (21.28%) Data Mining
18 10 (21.28%) Finance
18 10 (21.28%) Crystal Reports
18 10 (21.28%) Data Analysis
18 10 (21.28%) Unit Testing
18 10 (21.28%) Data Architecture
19 9 (19.15%) Oracle BI Publisher

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 30 July 2014, IT jobs within the UK citing Snowflake Schema also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited Snowflake Schema. Up to 20 skills are shown per category.

Application Platforms
1 3 (6.38%) SAS
2 1 (2.13%) Tomcat
2 1 (2.13%) WebLogic
2 1 (2.13%) Oracle SOA Suite
Applications
1 8 (17.02%) MS Excel
Business Applications
1 2 (4.26%) Eagle PACE
1 2 (4.26%) Eagle STAR
1 2 (4.26%) Siebel Analytics
1 2 (4.26%) Oracle Applications
1 2 (4.26%) Oracle EBS
Cloud Services
1 1 (2.13%) SaaS
Database & Business Intelligence
1 40 (85.11%) Data Warehouse
2 33 (70.21%) Star Schema
3 28 (59.57%) SQL Server Integration Services
4 27 (57.45%) SQL Server Reporting Services
5 25 (53.19%) SQL Server
6 17 (36.17%) SQL Server 2008
7 16 (34.04%) Oracle BI EE
7 16 (34.04%) OLAP
7 16 (34.04%) Oracle Database
8 15 (31.91%) SQL Server Analysis Services
8 15 (31.91%) Data Mart
9 13 (27.66%) SQL Server 2012
10 12 (25.53%) Relational Database
10 12 (25.53%) RDBMS
11 10 (21.28%) Data Mining
11 10 (21.28%) Crystal Reports
12 9 (19.15%) Oracle BI Publisher
12 9 (19.15%) Oracle Reports
13 5 (10.64%) DataStage
13 5 (10.64%) Oracle OWB
Development Applications
1 2 (4.26%) Toad
General
1 10 (21.28%) Finance
2 4 (8.51%) Advertising
3 2 (4.26%) Marketing
3 2 (4.26%) Retail
Job Titles
1 37 (78.72%) Developer
2 15 (31.91%) Business Intelligence Developer
3 10 (21.28%) OBIEE Developer
4 9 (19.15%) SQL Developer
5 7 (14.89%) Business Developer
5 7 (14.89%) Data Warehouse Developer
6 6 (12.77%) Enterprise Data Architect
6 6 (12.77%) Enterprise Architect
6 6 (12.77%) Data Architect
6 6 (12.77%) Senior Developer
6 6 (12.77%) Architect
7 4 (8.51%) SQL Database Developer
7 4 (8.51%) Database Developer
7 4 (8.51%) PL/SQL Developer
7 4 (8.51%) Oracle Developer
8 2 (4.26%) ETL Developer
9 1 (2.13%) Consultant
9 1 (2.13%) Principal Consultant
9 1 (2.13%) Quality Manager
9 1 (2.13%) Data Modeller
Libraries, Frameworks & Software Standards
1 9 (19.15%) CSS
1 9 (19.15%) HTML
2 7 (14.89%) XML
3 6 (12.77%) MDX
3 6 (12.77%) Web Services
4 3 (6.38%) .NET
5 1 (2.13%) XML Schema
5 1 (2.13%) PostGIS
Miscellaneous
1 6 (12.77%) Management Information System
2 5 (10.64%) Data Integration
2 5 (10.64%) Reference Data
2 5 (10.64%) Computer Science
3 1 (2.13%) Social Media
3 1 (2.13%) Blog
3 1 (2.13%) Data Extraction
Operating Systems
1 3 (6.38%) UNIX
Processes & Methodologies
1 44 (93.62%) Business Intelligence
2 39 (82.98%) ETL
3 31 (65.96%) Dimensional Modelling
4 23 (48.94%) Data Modelling
5 20 (42.55%) Kimball Methodology
6 10 (21.28%) Data Analysis
6 10 (21.28%) Unit Testing
6 10 (21.28%) Data Architecture
7 9 (19.15%) Data Mapping
8 7 (14.89%) Analytics
9 6 (12.77%) Data Management
9 6 (12.77%) Zachman Framework
9 6 (12.77%) TOGAF
9 6 (12.77%) Refactoring
10 5 (10.64%) Asset Management
11 4 (8.51%) Investment Management
11 4 (8.51%) Data Migration
11 4 (8.51%) Data Governance
11 4 (8.51%) Fund Accounting
11 4 (8.51%) Technical Architecture
Programming Languages
1 37 (78.72%) SQL
2 18 (38.30%) PL/SQL
3 9 (19.15%) JavaScript
4 6 (12.77%) Java
4 6 (12.77%) T-SQL
4 6 (12.77%) Python
5 5 (10.64%) C
6 3 (6.38%) C#
7 1 (2.13%) Perl
Qualifications
1 6 (12.77%) Degree
Quality Assurance & Compliance
1 4 (8.51%) Data Quality
2 3 (6.38%) ISO 9000
Systems Management
1 1 (2.13%) Control-M
Vendors
1 23 (48.94%) Oracle
2 17 (36.17%) Microsoft
3 8 (17.02%) Cognos
3 8 (17.02%) Business Objects
3 8 (17.02%) Informatica
3 8 (17.02%) MicroStrategy
4 7 (14.89%) Ab Initio
5 3 (6.38%) Logi Analytics
6 2 (4.26%) Vermilion
6 2 (4.26%) Siebel
7 1 (2.13%) Cognizant
7 1 (2.13%) JBoss
7 1 (2.13%) SAP
7 1 (2.13%) DataFlux