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

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 904 962 969
Rank change year-on-year
+58 +7
Permanent jobs citing Snowflake Schema 14 13 24
As % of all permanent IT jobs located in the UK 0.014% 0.012% 0.020%
As % of the Database & Business Intelligence category 0.048% 0.037% 0.064%
Number of salaries quoted 13 13 24
Median salary £67,500 £41,500 £45,000
Median salary % change year-on-year
+62.65% -7.77%
90% offered a salary of more than £38,000 £40,000 £41,000
10% offered a salary of more than £72,500 £44,300 £60,000
UK excluding London median salary £40,000 £41,500 £42,500
% change year-on-year
-3.61% -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
29124 34912 37414
As % of all permanent IT jobs located in the UK 29.74% 31.81% 31.90%
Number of salaries quoted 24743 29407 31937
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 £31,500 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 29 July 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 29 July 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 +35 13 £67,500 +62.65% 7
London +60 8 £72,500 +67.63% 5
North West - 4 £48,750 - 1
Cheshire - 2 £36,250 - 1
Manchester - 2 £60,000 -
Warrington - 2 £36,250 - 1
York - 1 £40,000 - 1
North Yorkshire - 1 £40,000 - 1
Yorkshire - 1 £40,000 - 1

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 29 July 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 17 (94.44%) Business Intelligence
2 16 (88.89%) Data Warehouse
3 14 (77.78%) Star Schema
3 14 (77.78%) SQL
4 11 (61.11%) Data Modelling
4 11 (61.11%) ETL
5 8 (44.44%) SQL Server
5 8 (44.44%) SQL Server Reporting Services
5 8 (44.44%) SQL Server Integration Services
6 7 (38.89%) Kimball Methodology
6 7 (38.89%) Performance Tuning
7 6 (33.33%) SQL Server Analysis Services
7 6 (33.33%) OLAP
7 6 (33.33%) Microsoft
7 6 (33.33%) Oracle
8 5 (27.78%) Data Mart
9 4 (22.22%) Oracle Database 11g
9 4 (22.22%) Agile Software Development
9 4 (22.22%) T-SQL
9 4 (22.22%) PL/SQL
9 4 (22.22%) Microsoft Azure
9 4 (22.22%) Data Governance
9 4 (22.22%) SDLC
9 4 (22.22%) Oracle Database 12c
9 4 (22.22%) Oracle Database
10 3 (16.67%) Power BI
10 3 (16.67%) Relational Database
10 3 (16.67%) Biml
10 3 (16.67%) Azure SQL Database
10 3 (16.67%) SQL Server 2012

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 (11.11%) Apache Pig
2 1 (5.56%) SharePoint
Business Applications
1 2 (11.11%) Dynamics NAV
2 1 (5.56%) Dynamics CRM
Cloud Services
1 4 (22.22%) Microsoft Azure
Database & Business Intelligence
1 16 (88.89%) Data Warehouse
2 14 (77.78%) Star Schema
3 8 (44.44%) SQL Server
3 8 (44.44%) SQL Server Integration Services
3 8 (44.44%) SQL Server Reporting Services
4 6 (33.33%) OLAP
4 6 (33.33%) SQL Server Analysis Services
5 5 (27.78%) Data Mart
6 4 (22.22%) Oracle Database
6 4 (22.22%) Oracle Database 11g
6 4 (22.22%) Oracle Database 12c
7 3 (16.67%) Azure SQL Database
7 3 (16.67%) Biml
7 3 (16.67%) Power BI
7 3 (16.67%) RDBMS
7 3 (16.67%) Relational Database
7 3 (16.67%) SQL Server 2012
8 2 (11.11%) Apache Hive
8 2 (11.11%) Hadoop
8 2 (11.11%) MySQL
Development Applications
1 3 (16.67%) ERwin
2 2 (11.11%) Git (software)
2 2 (11.11%) Team Foundation Server
2 2 (11.11%) Visual Studio
General
1 3 (16.67%) Legal
2 2 (11.11%) Advertising
3 1 (5.56%) Banking
3 1 (5.56%) Finance
Job Titles
1 10 (55.56%) Developer
2 7 (38.89%) Architect
2 7 (38.89%) Data Architect
3 6 (33.33%) Data Warehouse Architect
4 5 (27.78%) Business Intelligence Developer
5 3 (16.67%) Business Intelligence Lead
5 3 (16.67%) Data Warehouse Developer
5 3 (16.67%) Lead Developer
6 2 (11.11%) Business Intelligence Architect
6 2 (11.11%) Data Integration Architect
6 2 (11.11%) ETL Architect
6 2 (11.11%) Integration Architect
6 2 (11.11%) MicroStrategy Developer
7 1 (5.56%) Analyst
7 1 (5.56%) Analyst Developer
7 1 (5.56%) Business Intelligence Consultant
7 1 (5.56%) Enterprise Architect
7 1 (5.56%) Software Architect
7 1 (5.56%) SQL Developer
7 1 (5.56%) Technical Architect
Libraries, Frameworks & Software Standards
1 1 (5.56%) .NET
1 1 (5.56%) AngularJS
1 1 (5.56%) CSS
1 1 (5.56%) CSS3
1 1 (5.56%) HTML
1 1 (5.56%) HTML5
1 1 (5.56%) REST
1 1 (5.56%) Twitter Bootstrap
1 1 (5.56%) WCF
1 1 (5.56%) Web Services
Miscellaneous
1 2 (11.11%) Analytical Skills
1 2 (11.11%) Data Integration
1 2 (11.11%) Visualisation
Processes & Methodologies
1 17 (94.44%) Business Intelligence
2 11 (61.11%) Data Modelling
2 11 (61.11%) ETL
3 7 (38.89%) Kimball Methodology
3 7 (38.89%) Performance Tuning
4 4 (22.22%) Agile Software Development
4 4 (22.22%) Data Governance
4 4 (22.22%) SDLC
5 3 (16.67%) Refactoring
5 3 (16.67%) Scrum
6 2 (11.11%) Data Architecture
6 2 (11.11%) Data Management
6 2 (11.11%) E-Commerce
6 2 (11.11%) Enterprise Architecture
6 2 (11.11%) Master Data Management
6 2 (11.11%) Mentoring
7 1 (5.56%) Analytics
7 1 (5.56%) Data Transformation
7 1 (5.56%) Kalman Filter
7 1 (5.56%) Logical Data Model
Programming Languages
1 14 (77.78%) SQL
2 4 (22.22%) PL/SQL
2 4 (22.22%) T-SQL
3 2 (11.11%) Python
3 2 (11.11%) R
4 1 (5.56%) C#
4 1 (5.56%) JavaScript
4 1 (5.56%) TypeScript
4 1 (5.56%) VB.NET
Qualifications
1 1 (5.56%) Degree
Quality Assurance & Compliance
1 1 (5.56%) Data Quality
Systems Management
1 1 (5.56%) Oracle Enterprise Manager
Vendors
1 6 (33.33%) Microsoft
1 6 (33.33%) Oracle
2 3 (16.67%) Alteryx
2 3 (16.67%) Teradata
3 2 (11.11%) Google
3 2 (11.11%) MicroStrategy
3 2 (11.11%) Tableau
4 1 (5.56%) Cognos
4 1 (5.56%) Salesforce.com
London
Lawrence Harvey Enterprise
Salary: £70000.00 - £75000.00 per annum + bonus, pension, health care
Posted: 20 hours ago
Warrington, Cheshire
Harvey Nash plc
Posted: 3 days ago
London
Harvey Nash plc
Salary: £70000 - £75000 per annum + 10% Bonus & Excellent Package
Posted: 4 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 3 days ago
London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 11 days ago
York
Computer Futures
Salary: competitive
Posted: 15 days ago
London
Venturi
Salary: £70000 - £75000 per annum + Bonus + Benefits
Posted: 11 days ago