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

3 months to
27 Feb 2017
Same period 2016 Same period 2015
Snowflake Schema
UK
Rank 841 941 947
Rank change year-on-year
+100 +6
Permanent jobs citing Snowflake Schema 22 12 17
As % of all permanent IT jobs located in the UK 0.026% 0.012% 0.016%
As % of the Database & Business Intelligence category 0.085% 0.038% 0.051%
Number of salaries quoted 22 8 17
Median salary £41,250 £35,000 £52,500
Median salary % change year-on-year
+17.85% -33.33%
90% offered a salary of more than £37,000 £35,000 £46,000
10% offered a salary of more than £55,000 £59,500 £57,500
UK excluding London median salary £40,000 £35,000 £52,500
% change year-on-year
+14.28% -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
25778 31785 33397
As % of all permanent IT jobs located in the UK 30.55% 31.53% 31.25%
Number of salaries quoted 21934 26906 28535
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,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,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 February 2017 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 21 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 February 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 +97 22 £41,250 +17.85% 1
South East +56 8 £37,000 -
East of England - 6 £55,000 -
Suffolk - 6 £55,000 -
Yorkshire - 5 £37,500 -
Berkshire - 5 £37,000 -
Reading - 5 £37,000 -
West Yorkshire - 5 £37,500 -
Leeds - 4 £37,500 -
Hampshire - 3 £45,000 -
Southampton - 2 £43,750 -
London +56 1 £45,000 -28.00% 1
East Midlands - 1 £40,000 -
North West - 1 £36,000 -
Leicester - 1 £40,000 -
Bradford - 1 £45,000 -
Warrington - 1 £36,000 -
Petersfield - 1 £48,500 -
West End of London - 1 £45,000 - 1
Leicestershire - 1 £40,000 -
Cheshire - 1 £36,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 27 February 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 29 (87.88%) Business Intelligence
2 28 (84.85%) SQL
3 24 (72.73%) Data Modelling
4 20 (60.61%) SQL Server Reporting Services
4 20 (60.61%) SQL Server
5 19 (57.58%) T-SQL
5 19 (57.58%) Star Schema
5 19 (57.58%) Data Warehouse
5 19 (57.58%) SQL Server Integration Services
6 18 (54.55%) Kimball Methodology
7 17 (51.52%) Power BI
7 17 (51.52%) ETL
7 17 (51.52%) Agile Software Development
8 13 (39.39%) Oracle
8 13 (39.39%) QlikView
8 13 (39.39%) SQL Server Analysis Services
9 11 (33.33%) SQL Server 2008
9 11 (33.33%) Oracle OLAP
9 11 (33.33%) OLAP
10 10 (30.30%) Tableau
10 10 (30.30%) Degree
11 7 (21.21%) Performance Tuning
11 7 (21.21%) Visual Studio
11 7 (21.21%) XML
11 7 (21.21%) MySQL
12 6 (18.18%) Crystal Reports
12 6 (18.18%) SOA
12 6 (18.18%) Microsoft
12 6 (18.18%) Replication
12 6 (18.18%) Clustering

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 6 (18.18%) Confluence
2 4 (12.12%) Oracle SOA Suite
Applications
1 5 (15.15%) MS Excel
Cloud Services
1 6 (18.18%) Microsoft Azure
2 4 (12.12%) Google Cloud Platform
3 1 (3.03%) SaaS
Database & Business Intelligence
1 20 (60.61%) SQL Server
1 20 (60.61%) SQL Server Reporting Services
2 19 (57.58%) Data Warehouse
2 19 (57.58%) SQL Server Integration Services
2 19 (57.58%) Star Schema
3 17 (51.52%) Power BI
4 13 (39.39%) QlikView
4 13 (39.39%) SQL Server Analysis Services
5 11 (33.33%) OLAP
5 11 (33.33%) Oracle OLAP
5 11 (33.33%) SQL Server 2008
6 7 (21.21%) MySQL
7 6 (18.18%) Azure SQL Database
7 6 (18.18%) Crystal Reports
7 6 (18.18%) NoSQL
7 6 (18.18%) OLAP Cube
7 6 (18.18%) Relational Database
8 5 (15.15%) Oracle BI EE
8 5 (15.15%) Oracle Reports
8 5 (15.15%) SQL Server 2012
Development Applications
1 7 (21.21%) Visual Studio
2 6 (18.18%) JIRA
3 2 (6.06%) ERwin
4 1 (3.03%) Talend Open Studio
General
1 5 (15.15%) Finance
1 5 (15.15%) Retail
Job Titles
1 26 (78.79%) Developer
2 23 (69.70%) Business Intelligence Developer
3 11 (33.33%) Senior Business Intelligence Developer
3 11 (33.33%) Senior Developer
4 7 (21.21%) SSRS Developer
5 6 (18.18%) Business Developer
5 6 (18.18%) Senior SQL Developer
5 6 (18.18%) Senior SQL Server Developer
5 6 (18.18%) SQL BI Developer
5 6 (18.18%) SQL Developer
5 6 (18.18%) SQL Server BI Developer
5 6 (18.18%) SQL Server Developer
5 6 (18.18%) SSIS Developer
6 5 (15.15%) Senior Software Developer
6 5 (15.15%) Software Developer
7 3 (9.09%) Microsoft Developer
7 3 (9.09%) Senior DBA
7 3 (9.09%) Senior Microsoft Developer
7 3 (9.09%) Senior SQL DBA
7 3 (9.09%) Senior SQL Server DBA
Libraries, Frameworks & Software Standards
1 7 (21.21%) XML
2 4 (12.12%) .NET
2 4 (12.12%) Middleware
2 4 (12.12%) Oracle GoldenGate
3 2 (6.06%) JSON
Miscellaneous
1 6 (18.18%) Clustering
1 6 (18.18%) Replication
2 5 (15.15%) Computer Science
2 5 (15.15%) NHS
3 1 (3.03%) Analytical Skills
Operating Systems
1 1 (3.03%) Windows
1 1 (3.03%) Windows Server
Processes & Methodologies
1 29 (87.88%) Business Intelligence
2 24 (72.73%) Data Modelling
3 18 (54.55%) Kimball Methodology
4 17 (51.52%) Agile Software Development
4 17 (51.52%) ETL
5 7 (21.21%) Performance Tuning
6 6 (18.18%) Analytics
6 6 (18.18%) Continuous Improvement
6 6 (18.18%) Data Analytics
6 6 (18.18%) SDLC
6 6 (18.18%) SOA
6 6 (18.18%) User Stories
7 5 (15.15%) Business Analysis
7 5 (15.15%) Security Management
7 5 (15.15%) Software Engineering
7 5 (15.15%) Unit Testing
8 4 (12.12%) ITIL
9 3 (9.09%) Database Optimisation
10 2 (6.06%) Information Architecture
10 2 (6.06%) Visualisation
Programming Languages
1 28 (84.85%) SQL
2 19 (57.58%) T-SQL
3 4 (12.12%) C#
3 4 (12.12%) VB
4 3 (9.09%) PL/SQL
Qualifications
1 10 (30.30%) Degree
Quality Assurance & Compliance
1 6 (18.18%) Data Quality
Vendors
1 13 (39.39%) Oracle
2 10 (30.30%) Tableau
3 6 (18.18%) Microsoft
4 4 (12.12%) Dell
4 4 (12.12%) Google
5 3 (9.09%) SAP
6 1 (3.03%) Alteryx
6 1 (3.03%) MicroStrategy
6 1 (3.03%) Talend
Central London / West End
Testing Circle Ltd
Salary: £0.00 - £45000 per annum + Additional benefits
Posted: 6 days ago