The table below looks at the statistics 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 16 September 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
16 Sep 2014
Same period 2013 Same period 2012
Snowflake Schema
Rank 873 863 892
Rank change year-on-year
-10 +29
Permanent jobs citing Snowflake Schema 14 10 9
As % of all permanent IT jobs located in the UK 0.012% 0.009% 0.008%
As % of the Database & Business Intelligence category 0.040% 0.030% 0.025%
Number of salaries quoted 13 6 7
Average salary £42,500 £45,000 £43,500
Average salary % change year-on-year
-5.55% +3.44%
UK excluding London average salary £42,500 £40,000 £43,500
% change year-on-year
+6.25% -8.04%

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
34795 33610 36584
As % of all permanent IT jobs located in the UK 30.50% 31.61% 31.04%
Number of salaries quoted 29255 29039 32206
Average salary £45,000 £45,000 £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 £67,500 £65,000 £65,000
UK excluding London average salary £40,000 £40,000 £40,000

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 16 September 2014 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 8 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 16 September 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 -20 10 £55,000 +22.22% 2
London -16 6 £60,000 +20.00% 1
City of London -1 4 £60,000 +33.33% 1
East Midlands - 3 £42,500 -
Nottingham - 3 £42,500 -
Nottinghamshire - 3 £42,500 -
Scotland - 1 £46,500 - 1
Edinburgh - 1 £46,500 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 16 September 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 37 (88.10%) Data Warehouse
1 37 (88.10%) Business Intelligence
2 34 (80.95%) ETL
3 33 (78.57%) SQL
4 31 (73.81%) Star Schema
5 28 (66.67%) SQL Server Reporting Services
5 28 (66.67%) SQL Server Integration Services
6 26 (61.90%) Dimensional Modelling
7 25 (59.52%) SQL Server
8 24 (57.14%) Data Modelling
9 22 (52.38%) Kimball Methodology
10 19 (45.24%) Oracle
11 18 (42.86%) Data Mart
12 17 (40.48%) SQL Server Analysis Services
13 16 (38.10%) Oracle Database
13 16 (38.10%) Microsoft
14 15 (35.71%) RDBMS
14 15 (35.71%) Relational Database
14 15 (35.71%) SQL Server 2008
15 14 (33.33%) PL/SQL
16 12 (28.57%) OLAP
17 11 (26.19%) MS Excel
17 11 (26.19%) Oracle BI EE
17 11 (26.19%) SQL Server 2012
18 10 (23.81%) Unit Testing
18 10 (23.81%) Data Analysis
18 10 (23.81%) Crystal Reports
19 9 (21.43%) CSS
19 9 (21.43%) JavaScript
19 9 (21.43%) HTML

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 16 September 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 2 (4.76%) SAS
2 1 (2.38%) Tomcat
2 1 (2.38%) WebLogic
2 1 (2.38%) Oracle SOA Suite
Applications
1 11 (26.19%) MS Excel
Database & Business Intelligence
1 37 (88.10%) Data Warehouse
2 31 (73.81%) Star Schema
3 28 (66.67%) SQL Server Reporting Services
3 28 (66.67%) SQL Server Integration Services
4 25 (59.52%) SQL Server
5 18 (42.86%) Data Mart
6 17 (40.48%) SQL Server Analysis Services
7 16 (38.10%) Oracle Database
8 15 (35.71%) RDBMS
8 15 (35.71%) Relational Database
8 15 (35.71%) SQL Server 2008
9 12 (28.57%) OLAP
10 11 (26.19%) Oracle BI EE
10 11 (26.19%) SQL Server 2012
11 10 (23.81%) Crystal Reports
12 9 (21.43%) Oracle Reports
12 9 (21.43%) Oracle BI Publisher
13 4 (9.52%) Microsoft Analysis Services
13 4 (9.52%) Oracle OWB
13 4 (9.52%) Data Mining
General
1 7 (16.67%) Finance
2 2 (4.76%) Retail
2 2 (4.76%) Marketing
2 2 (4.76%) Telecoms
2 2 (4.76%) Advertising
Job Titles
1 35 (83.33%) Developer
2 13 (30.95%) Business Intelligence Developer
3 9 (21.43%) SQL Developer
4 8 (19.05%) OBIEE Developer
4 8 (19.05%) Data Warehouse Developer
5 7 (16.67%) Business Developer
6 6 (14.29%) Oracle Developer
7 5 (11.90%) Senior Developer
8 4 (9.52%) PL/SQL Developer
8 4 (9.52%) SQL Database Developer
8 4 (9.52%) Database Developer
9 3 (7.14%) Architect
9 3 (7.14%) Data Architect
10 2 (4.76%) Enterprise Data Architect
10 2 (4.76%) Enterprise Architect
10 2 (4.76%) ETL Developer
10 2 (4.76%) Lead Developer
11 1 (2.38%) Consultant
11 1 (2.38%) Quality Manager
11 1 (2.38%) Principal Consultant
Libraries, Frameworks & Software Standards
1 9 (21.43%) CSS
1 9 (21.43%) HTML
2 5 (11.90%) MDX
3 3 (7.14%) XML
3 3 (7.14%) .NET
4 2 (4.76%) Web Services
5 1 (2.38%) XML Schema
5 1 (2.38%) PostGIS
Miscellaneous
1 7 (16.67%) Computer Science
2 6 (14.29%) Analytical Skills
3 5 (11.90%) Data Integration
4 2 (4.76%) Management Information System
5 1 (2.38%) Blog
5 1 (2.38%) Social Media
5 1 (2.38%) Reference Data
5 1 (2.38%) Data Extraction
Operating Systems
1 1 (2.38%) UNIX
Processes & Methodologies
1 37 (88.10%) Business Intelligence
2 34 (80.95%) ETL
3 26 (61.90%) Dimensional Modelling
4 24 (57.14%) Data Modelling
5 22 (52.38%) Kimball Methodology
6 10 (23.81%) Unit Testing
6 10 (23.81%) Data Analysis
7 9 (21.43%) Data Architecture
7 9 (21.43%) Data Mapping
8 8 (19.05%) Refactoring
9 5 (11.90%) Data Management
10 4 (9.52%) Technical Architecture
10 4 (9.52%) E-Commerce
11 3 (7.14%) Enterprise Architecture
11 3 (7.14%) Agile Software Development
11 3 (7.14%) Analytics
12 2 (4.76%) Zachman Framework
12 2 (4.76%) TOGAF
12 2 (4.76%) Investment Management
12 2 (4.76%) CRM
Programming Languages
1 33 (78.57%) SQL
2 14 (33.33%) PL/SQL
3 9 (21.43%) JavaScript
4 7 (16.67%) T-SQL
5 6 (14.29%) Python
6 5 (11.90%) Java
6 5 (11.90%) C
7 3 (7.14%) C#
8 1 (2.38%) Perl
Qualifications
1 8 (19.05%) Degree
Quality Assurance & Compliance
1 1 (2.38%) ISO 9000
1 1 (2.38%) Data Quality
Systems Management
1 1 (2.38%) Control-M
Vendors
1 19 (45.24%) Oracle
2 16 (38.10%) Microsoft
3 4 (9.52%) Ab Initio
4 3 (7.14%) Informatica
4 3 (7.14%) MicroStrategy
4 3 (7.14%) Cognos
4 3 (7.14%) Business Objects
5 1 (2.38%) Cognizant
5 1 (2.38%) JBoss
5 1 (2.38%) SAP
5 1 (2.38%) DataFlux
5 1 (2.38%) Logi Analytics
Glasgow, Lanarkshire
Wescot Credit Services Limited
Posted: 4 days ago
St. Albans
Deloitte
Salary: Excellent + package
Posted: 12 days ago
City of London
Bridge Noble
Salary: £50000 - £70000 per annum + Benefits
Posted: 14 days ago