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 18 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
18 Jan 2017
Same period 2016 Same period 2015
Snowflake Schema
UK
Rank 829 916 936
Rank change year-on-year
+87 +20
Permanent jobs citing Snowflake Schema 16 11 11
As % of all permanent IT jobs located in the UK 0.019% 0.011% 0.011%
As % of the Database & Business Intelligence category 0.063% 0.034% 0.034%
Number of salaries quoted 15 9 11
Median salary £37,500 £35,000 £48,000
Median salary % change year-on-year
+7.14% -27.08%
UK excluding London median salary £37,500 £35,000 £52,500
% change year-on-year
+7.14% -33.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
25393 32297 31921
As % of all permanent IT jobs located in the UK 30.20% 32.26% 30.97%
Number of salaries quoted 21845 27309 27372
Median salary £50,000 £48,500 £45,000
Median salary % change year-on-year
+3.09% +7.77%
90% offered a salary of more than £32,500 £32,500 £30,500
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

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 18 January 2017 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 15 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 18 January 2017. 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 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 +80 16 £37,500 +7.14% 4
South East +56 6 £37,000 - 2
Berkshire - 5 £37,000 -
Reading - 5 £37,000 -
Yorkshire - 5 £41,250 - 1
West Yorkshire - 5 £41,250 - 1
Suffolk - 3 £55,000 -
Bradford - 3 £45,000 -
East of England - 3 £55,000 -
Cheshire - 2 £36,000 -
North West - 2 £36,000 -
Warrington - 2 £36,000 -
Leeds - 2 £37,500 - 1
Hampshire - 1 £45,000 - 2
Petersfield - 1 £45,000 - 1

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 18 January 2017, 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 36 (85.71%) Star Schema
2 35 (83.33%) Business Intelligence
3 32 (76.19%) Data Warehouse
4 30 (71.43%) SQL
5 27 (64.29%) Data Modelling
5 27 (64.29%) SQL Server Integration Services
6 26 (61.90%) ETL
7 24 (57.14%) SQL Server
8 23 (54.76%) SQL Server Reporting Services
8 23 (54.76%) Kimball Methodology
9 17 (40.48%) Oracle
9 17 (40.48%) T-SQL
10 16 (38.10%) SQL Server Analysis Services
10 16 (38.10%) Power BI
11 14 (33.33%) Performance Tuning
11 14 (33.33%) Agile Software Development
12 13 (30.95%) OLAP
13 12 (28.57%) Microsoft
13 12 (28.57%) QlikView
14 11 (26.19%) Oracle OLAP
14 11 (26.19%) SDLC
15 9 (21.43%) Visual Studio
16 8 (19.05%) Retail
16 8 (19.05%) Inmon Methodology
16 8 (19.05%) SQL Server 2008
17 7 (16.67%) Tableau
17 7 (16.67%) Data Quality
17 7 (16.67%) Degree
17 7 (16.67%) XML
17 7 (16.67%) PL/SQL

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 4 (9.52%) Oracle SOA Suite
2 3 (7.14%) Confluence
3 1 (2.38%) SharePoint
Applications
1 5 (11.90%) MS Excel
Business Applications
1 1 (2.38%) Dynamics CRM
Cloud Services
1 4 (9.52%) Google Cloud Platform
1 4 (9.52%) Microsoft Azure
Database & Business Intelligence
1 36 (85.71%) Star Schema
2 32 (76.19%) Data Warehouse
3 27 (64.29%) SQL Server Integration Services
4 24 (57.14%) SQL Server
5 23 (54.76%) SQL Server Reporting Services
6 16 (38.10%) Power BI
6 16 (38.10%) SQL Server Analysis Services
7 13 (30.95%) OLAP
8 12 (28.57%) QlikView
9 11 (26.19%) Oracle OLAP
10 8 (19.05%) SQL Server 2008
11 6 (14.29%) Enterprise Data Warehouse
11 6 (14.29%) OLAP Cube
11 6 (14.29%) Relational Database
12 5 (11.90%) Oracle BI EE
12 5 (11.90%) Oracle Database
12 5 (11.90%) Oracle Database 11g
12 5 (11.90%) Oracle Database 12c
12 5 (11.90%) Oracle Reports
12 5 (11.90%) SQL Server 2012
Development Applications
1 9 (21.43%) Visual Studio
2 5 (11.90%) ERwin
3 3 (7.14%) JIRA
4 1 (2.38%) Talend Open Studio
General
1 8 (19.05%) Retail
2 6 (14.29%) Finance
3 2 (4.76%) Legal
Job Titles
1 23 (54.76%) Developer
2 17 (40.48%) Business Intelligence Developer
3 11 (26.19%) Senior Developer
4 10 (23.81%) Architect
5 8 (19.05%) Senior Business Intelligence Developer
6 6 (14.29%) Data Architect
7 5 (11.90%) Data Warehouse Architect
7 5 (11.90%) Data Warehouse Developer
7 5 (11.90%) Senior Software Developer
7 5 (11.90%) Software Developer
7 5 (11.90%) SSIS Developer
7 5 (11.90%) SSRS Developer
8 4 (9.52%) Business Developer
8 4 (9.52%) SQL Developer
9 3 (7.14%) Analyst
9 3 (7.14%) Business Intelligence Consultant
9 3 (7.14%) Consultant
9 3 (7.14%) Senior DBA
9 3 (7.14%) SQL DBA
9 3 (7.14%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 7 (16.67%) XML
2 4 (9.52%) .NET
2 4 (9.52%) Middleware
2 4 (9.52%) Oracle GoldenGate
3 2 (4.76%) AngularJS
3 2 (4.76%) CSS
3 2 (4.76%) CSS3
3 2 (4.76%) HTML
3 2 (4.76%) HTML5
3 2 (4.76%) JSON
3 2 (4.76%) MDX
3 2 (4.76%) REST
3 2 (4.76%) Twitter Bootstrap
3 2 (4.76%) WCF
3 2 (4.76%) Web Services
Miscellaneous
1 5 (11.90%) NHS
2 3 (7.14%) Clustering
2 3 (7.14%) Replication
3 2 (4.76%) Analytical Skills
3 2 (4.76%) Computer Science
3 2 (4.76%) Visualisation
4 1 (2.38%) Data Integration
Processes & Methodologies
1 35 (83.33%) Business Intelligence
2 27 (64.29%) Data Modelling
3 26 (61.90%) ETL
4 23 (54.76%) Kimball Methodology
5 14 (33.33%) Agile Software Development
5 14 (33.33%) Performance Tuning
6 11 (26.19%) SDLC
7 8 (19.05%) Inmon Methodology
8 6 (14.29%) Analytics
8 6 (14.29%) Data Analytics
8 6 (14.29%) SOA
9 5 (11.90%) Business Analysis
9 5 (11.90%) Data Governance
9 5 (11.90%) Security Management
9 5 (11.90%) Software Engineering
9 5 (11.90%) Unit Testing
10 4 (9.52%) Information Architecture
10 4 (9.52%) Mentoring
11 3 (7.14%) ETL Development
11 3 (7.14%) User Stories
Programming Languages
1 30 (71.43%) SQL
2 17 (40.48%) T-SQL
3 7 (16.67%) PL/SQL
4 4 (9.52%) C#
5 2 (4.76%) JavaScript
5 2 (4.76%) TypeScript
5 2 (4.76%) VB
5 2 (4.76%) VB.NET
Qualifications
1 7 (16.67%) Degree
2 5 (11.90%) Microsoft Certification
Quality Assurance & Compliance
1 7 (16.67%) Data Quality
Vendors
1 17 (40.48%) Oracle
2 12 (28.57%) Microsoft
3 7 (16.67%) Tableau
4 4 (9.52%) Google
5 3 (7.14%) Informatica
6 2 (4.76%) Dell
6 2 (4.76%) Salesforce.com
7 1 (2.38%) Alteryx
7 1 (2.38%) MicroStrategy
7 1 (2.38%) Talend
Petersfield, Hampshire
Rullion IT Plus
Salary: £42000 - £55000 per annum + Pension
Posted: 2 days ago
Lyndhurst
Spencer Ogden
Posted: 15 days ago
Leeds, West Yorkshire
CoreCom Consulting
Salary: £30000 - £45000 per annum + Benefits
Posted: 5 days ago