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 29 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
29 Jul 2015
Same period 2014 Same period 2013
Snowflake Schema
Rank 879 890 887
Rank change year-on-year
+11 -3
Permanent jobs citing Snowflake Schema 13 24 13
As % of all permanent IT jobs located in the UK 0.012% 0.020% 0.012%
As % of the Database & Business Intelligence category 0.038% 0.066% 0.038%
Number of salaries quoted 13 24 9
Average salary £41,500 £45,000 £37,500
Average salary % change year-on-year
-7.77% +20.00%
UK excluding London average salary £41,500 £42,500 £37,500
% change year-on-year
-2.35% +13.33%

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
34060 36447 34228
As % of all permanent IT jobs located in the UK 31.06% 31.09% 31.45%
Number of salaries quoted 28708 31142 29506
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £71,000 £65,000 £70,000
UK excluding London average salary £42,500 £40,000 £39,000
% change year-on-year
+6.25% +2.56%

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 29 July 2015 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 average salaries quoted in IT jobs citing Snowflake Schema within the UK over the 3 months to 29 July 2015. 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 +10 13 £41,500 -7.77% 1
West Midlands -9 6 £41,500 +3.75% 1
Tamworth - 6 £41,500 - 1
Staffordshire - 6 £41,500 - 1
London +22 4 £43,250 -27.91%
South East +17 3 £40,000 -11.11%
Middlesex - 3 £40,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 29 July 2015, 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 23 (95.83%) SQL
2 22 (91.67%) Business Intelligence
3 21 (87.50%) SQL Server Integration Services
4 18 (75.00%) SQL Server Analysis Services
4 18 (75.00%) ETL
4 18 (75.00%) Data Warehouse
4 18 (75.00%) SQL Server
5 17 (70.83%) SQL Server Reporting Services
6 16 (66.67%) Star Schema
7 13 (54.17%) MicroStrategy
7 13 (54.17%) T-SQL
8 12 (50.00%) Dimensional Modelling
9 10 (41.67%) Oracle
9 10 (41.67%) Kimball Methodology
10 8 (33.33%) Microsoft Analysis Services
10 8 (33.33%) Microsoft
10 8 (33.33%) Data Modelling
11 7 (29.17%) Informatica
11 7 (29.17%) Python
11 7 (29.17%) Agile Software Development
12 6 (25.00%) Stakeholder Management
12 6 (25.00%) Data Cleansing
13 5 (20.83%) QlikView
13 5 (20.83%) SQL Server 2008
13 5 (20.83%) Tableau
13 5 (20.83%) Big Data
13 5 (20.83%) Analytical Skills
13 5 (20.83%) ETL Development
13 5 (20.83%) Finance
13 5 (20.83%) Cognos

Snowflake Schema
Top Related IT Skills by Category

For the 6 months to 29 July 2015, 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 (12.50%) SharePoint
1 3 (12.50%) SAS
Applications
1 2 (8.33%) MS Excel
Business Applications
1 1 (4.17%) Cognos Business Intelligence
Cloud Services
1 1 (4.17%) Google Analytics
1 1 (4.17%) Microsoft Azure
Database & Business Intelligence
1 21 (87.50%) SQL Server Integration Services
2 18 (75.00%) SQL Server Analysis Services
2 18 (75.00%) SQL Server
2 18 (75.00%) Data Warehouse
3 17 (70.83%) SQL Server Reporting Services
4 16 (66.67%) Star Schema
5 8 (33.33%) Microsoft Analysis Services
6 5 (20.83%) SQL Server 2008
6 5 (20.83%) Big Data
6 5 (20.83%) QlikView
7 4 (16.67%) Hadoop
7 4 (16.67%) ROLAP
8 3 (12.50%) BusinessObjects
8 3 (12.50%) Data Mining
8 3 (12.50%) WhereScape RED
8 3 (12.50%) MongoDB
9 2 (8.33%) SQL Server 2012
10 1 (4.17%) Relational Database
10 1 (4.17%) Azure SQL Database
10 1 (4.17%) SAP Data Services
Development Applications
1 2 (8.33%) Team Foundation Server
2 1 (4.17%) HP UFT
2 1 (4.17%) FitNesse
2 1 (4.17%) Visual Studio Team System
2 1 (4.17%) Talend Open Studio
General
1 5 (20.83%) Finance
2 4 (16.67%) Retail
3 3 (12.50%) Banking
3 3 (12.50%) Telecoms
4 1 (4.17%) Marketing
Job Titles
1 12 (50.00%) Developer
2 11 (45.83%) Business Intelligence Developer
3 10 (41.67%) Analyst
4 9 (37.50%) Business Analyst
5 5 (20.83%) Business Intelligence Analyst
6 4 (16.67%) Senior Developer
6 4 (16.67%) Senior Business Intelligence Developer
7 3 (12.50%) Senior Business Analyst
7 3 (12.50%) Senior Analyst
7 3 (12.50%) Business Developer
7 3 (12.50%) Senior Business Intelligence Analyst
8 2 (8.33%) SQL Developer
9 1 (4.17%) Business Architect
9 1 (4.17%) Senior Test Engineer
9 1 (4.17%) ETL Developer
9 1 (4.17%) Business Project Manager
9 1 (4.17%) Business Intelligence Architect
9 1 (4.17%) Business Manager
9 1 (4.17%) Architect
9 1 (4.17%) Project Manager
Libraries, Frameworks & Software Standards
1 4 (16.67%) XML
2 2 (8.33%) MDX
3 1 (4.17%) LINQ
3 1 (4.17%) HTML
3 1 (4.17%) .NET
3 1 (4.17%) ASP.NET
Miscellaneous
1 5 (20.83%) Analytical Skills
2 4 (16.67%) Computer Science
3 3 (12.50%) Replication
4 1 (4.17%) Mathematics
4 1 (4.17%) Data Integration
Processes & Methodologies
1 22 (91.67%) Business Intelligence
2 18 (75.00%) ETL
3 12 (50.00%) Dimensional Modelling
4 10 (41.67%) Kimball Methodology
5 8 (33.33%) Data Modelling
6 7 (29.17%) Agile Software Development
7 6 (25.00%) Stakeholder Management
7 6 (25.00%) Data Cleansing
8 5 (20.83%) ETL Development
9 4 (16.67%) Analytics
10 3 (12.50%) Project Management
10 3 (12.50%) Change Management
10 3 (12.50%) Business Analysis
10 3 (12.50%) Business Process Mapping
11 2 (8.33%) Quality Management
11 2 (8.33%) E-Commerce
12 1 (4.17%) CRM
12 1 (4.17%) Scrum
12 1 (4.17%) Data Transformation
12 1 (4.17%) Automation Testing
Programming Languages
1 23 (95.83%) SQL
2 13 (54.17%) T-SQL
3 7 (29.17%) Python
4 4 (16.67%) C#
5 3 (12.50%) R
6 1 (4.17%) Java
6 1 (4.17%) JavaScript
Qualifications
1 4 (16.67%) Degree
2 1 (4.17%) ISEB
2 1 (4.17%) ISTQB
Vendors
1 13 (54.17%) MicroStrategy
2 10 (41.67%) Oracle
3 8 (33.33%) Microsoft
4 7 (29.17%) Informatica
5 5 (20.83%) Tableau
5 5 (20.83%) Cognos
6 4 (16.67%) SAP
6 4 (16.67%) Teradata
7 3 (12.50%) Cloudera
8 1 (4.17%) Birst
8 1 (4.17%) Talend
8 1 (4.17%) Google
8 1 (4.17%) Salesforce.com
8 1 (4.17%) Ab Initio
Tamworth, Staffordshire
Big Red Recruitment
Salary: £41500 per annum + Non contrib Pension
Posted: 14 hours ago