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 27 August 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 Aug 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 891 939 959
Rank change year-on-year
+48 +20
Permanent jobs citing Snowflake Schema 24 17 18
As % of all permanent IT jobs located in the UK 0.025% 0.016% 0.015%
As % of the Database & Business Intelligence category 0.084% 0.050% 0.049%
Number of salaries quoted 23 17 17
Median salary £72,500 £41,500 £42,500
Median salary % change year-on-year
+74.69% -2.35%
UK excluding London median salary £37,500 £41,500 £42,500
% change year-on-year
-9.63% -2.35%

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
28518 33938 37022
As % of all permanent IT jobs located in the UK 29.61% 31.08% 31.75%
Number of salaries quoted 24353 28632 31193
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 £32,000 £30,000
10% offered a salary of more than £75,000 £67,500 £72,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +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 27 August 2016 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 9 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 27 August 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 +63 24 £72,500 +74.69% 1
London +56 18 £72,500 +74.69% 1
North West - 5 £36,250 -
Cheshire - 4 £35,000 -
Warrington - 4 £35,000 -
York - 1 £40,000 -
North Yorkshire - 1 £40,000 -
Manchester - 1 £60,000 -
Yorkshire - 1 £40,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 27 August 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 27 (90.00%) Star Schema
2 26 (86.67%) Data Warehouse
3 24 (80.00%) Business Intelligence
4 22 (73.33%) ETL
5 18 (60.00%) SQL
5 18 (60.00%) SQL Server Integration Services
6 16 (53.33%) Data Modelling
7 15 (50.00%) SQL Server
7 15 (50.00%) SQL Server Reporting Services
7 15 (50.00%) Kimball Methodology
8 14 (46.67%) Microsoft
9 11 (36.67%) SQL Server Analysis Services
10 10 (33.33%) Performance Tuning
11 8 (26.67%) OLAP
11 8 (26.67%) Oracle
11 8 (26.67%) Inmon Methodology
12 7 (23.33%) Enterprise Data Warehouse
13 6 (20.00%) SDLC
13 6 (20.00%) Oracle Database 12c
13 6 (20.00%) Oracle Database
13 6 (20.00%) Data Governance
13 6 (20.00%) Oracle Database 11g
13 6 (20.00%) PL/SQL
13 6 (20.00%) T-SQL
13 6 (20.00%) Data Mart
13 6 (20.00%) ERwin
14 5 (16.67%) Agile Software Development
14 5 (16.67%) Microsoft Certification
14 5 (16.67%) Mentoring
14 5 (16.67%) Power BI

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 2 (6.67%) Apache Pig
2 1 (3.33%) SharePoint
Business Applications
1 2 (6.67%) Dynamics NAV
2 1 (3.33%) Dynamics CRM
Cloud Services
1 4 (13.33%) Microsoft Azure
Database & Business Intelligence
1 27 (90.00%) Star Schema
2 26 (86.67%) Data Warehouse
3 18 (60.00%) SQL Server Integration Services
4 15 (50.00%) SQL Server
4 15 (50.00%) SQL Server Reporting Services
5 11 (36.67%) SQL Server Analysis Services
6 8 (26.67%) OLAP
7 7 (23.33%) Enterprise Data Warehouse
8 6 (20.00%) Data Mart
8 6 (20.00%) Oracle Database
8 6 (20.00%) Oracle Database 11g
8 6 (20.00%) Oracle Database 12c
9 5 (16.67%) Power BI
10 4 (13.33%) QlikView
10 4 (13.33%) SQL Server 2014
11 3 (10.00%) Azure SQL Database
11 3 (10.00%) Biml
11 3 (10.00%) RDBMS
11 3 (10.00%) Relational Database
11 3 (10.00%) SQL Server 2012
Development Applications
1 6 (20.00%) ERwin
2 4 (13.33%) Visual Studio
3 2 (6.67%) Git (software)
3 2 (6.67%) Team Foundation Server
General
1 4 (13.33%) Legal
2 3 (10.00%) Retail
3 2 (6.67%) Advertising
3 2 (6.67%) Finance
4 1 (3.33%) Banking
Job Titles
1 13 (43.33%) Architect
2 12 (40.00%) Developer
3 9 (30.00%) Data Architect
4 8 (26.67%) Data Warehouse Architect
5 6 (20.00%) Data Warehouse Developer
6 5 (16.67%) Business Intelligence Developer
7 3 (10.00%) Business Intelligence Consultant
7 3 (10.00%) Business Intelligence Lead
7 3 (10.00%) Consultant
7 3 (10.00%) Database Architect
7 3 (10.00%) Lead Developer
7 3 (10.00%) Senior Architect
7 3 (10.00%) Senior Data Warehouse Developer
7 3 (10.00%) Senior Database Architect
7 3 (10.00%) Senior Developer
8 2 (6.67%) Business Intelligence Architect
8 2 (6.67%) Data Warehouse Consultant
8 2 (6.67%) ETL Architect
8 2 (6.67%) Integration Architect
8 2 (6.67%) Technical Architect
Libraries, Frameworks & Software Standards
1 2 (6.67%) .NET
1 2 (6.67%) AngularJS
1 2 (6.67%) CSS
1 2 (6.67%) CSS3
1 2 (6.67%) HTML
1 2 (6.67%) HTML5
1 2 (6.67%) MDX
1 2 (6.67%) REST
1 2 (6.67%) Twitter Bootstrap
1 2 (6.67%) WCF
1 2 (6.67%) Web Services
Miscellaneous
1 2 (6.67%) Analytical Skills
1 2 (6.67%) Data Integration
1 2 (6.67%) Visualisation
Processes & Methodologies
1 24 (80.00%) Business Intelligence
2 22 (73.33%) ETL
3 16 (53.33%) Data Modelling
4 15 (50.00%) Kimball Methodology
5 10 (33.33%) Performance Tuning
6 8 (26.67%) Inmon Methodology
7 6 (20.00%) Data Governance
7 6 (20.00%) SDLC
8 5 (16.67%) Agile Software Development
8 5 (16.67%) Mentoring
9 3 (10.00%) Analytics
9 3 (10.00%) Data Analytics
9 3 (10.00%) ETL Development
9 3 (10.00%) Refactoring
9 3 (10.00%) Scrum
10 2 (6.67%) Data Architecture
10 2 (6.67%) Information Architecture
10 2 (6.67%) Logical Data Model
10 2 (6.67%) Master Data Management
10 2 (6.67%) Physical Data Model
Programming Languages
1 18 (60.00%) SQL
2 6 (20.00%) PL/SQL
2 6 (20.00%) T-SQL
3 2 (6.67%) C#
3 2 (6.67%) JavaScript
3 2 (6.67%) Python
3 2 (6.67%) R
3 2 (6.67%) TypeScript
3 2 (6.67%) VB.NET
Qualifications
1 5 (16.67%) Microsoft Certification
Quality Assurance & Compliance
1 2 (6.67%) Data Quality
Systems Management
1 1 (3.33%) Oracle Enterprise Manager
Vendors
1 14 (46.67%) Microsoft
2 8 (26.67%) Oracle
3 3 (10.00%) Alteryx
3 3 (10.00%) Informatica
3 3 (10.00%) Teradata
4 2 (6.67%) Google
4 2 (6.67%) Salesforce.com
4 2 (6.67%) Tableau
5 1 (3.33%) Cognos
5 1 (3.33%) MicroStrategy
London
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, gym, retail vouchers
Posted: 25 days ago