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

3 months to
10 Dec 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 869 958 960
Rank change year-on-year
+89 +2
Permanent jobs citing Snowflake Schema 13 6 18
As % of all permanent IT jobs located in the UK 0.015% 0.006% 0.016%
As % of the Database & Business Intelligence category 0.048% 0.018% 0.052%
Number of salaries quoted 11 6 13
Median salary £45,000 £40,000 £48,000
Median salary % change year-on-year
+12.50% -16.66%
UK excluding London median salary £45,000 £40,000 £50,000
% change year-on-year
+12.50% -20.00%

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
26918 33781 34948
As % of all permanent IT jobs located in the UK 30.03% 31.91% 30.78%
Number of salaries quoted 23086 28440 29876
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 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 10 December 2016 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 10 December 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 +68 13 £45,000 +12.50% 2
Yorkshire - 5 £45,000 -
West Yorkshire - 5 £45,000 -
Cheshire - 4 £36,000 -
Warrington - 4 £36,000 -
North West - 4 £36,000 -
South East - 3 £45,000 - 1
Bradford - 3 £45,000 -
Leeds - 2 £45,000 -
Petersfield - 2 £45,500 -
Hampshire - 2 £45,500 -
Berkshire - 1 £37,000 -
Reading - 1 £37,000 -
East of England - 1 £55,000 - 1
Suffolk - 1 £55,000 - 1

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 10 December 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 34 (94.44%) Star Schema
2 31 (86.11%) Business Intelligence
3 28 (77.78%) Data Warehouse
4 26 (72.22%) ETL
5 24 (66.67%) SQL
6 23 (63.89%) Data Modelling
7 22 (61.11%) SQL Server Integration Services
8 20 (55.56%) Kimball Methodology
9 19 (52.78%) SQL Server
10 18 (50.00%) SQL Server Reporting Services
11 16 (44.44%) Performance Tuning
12 13 (36.11%) Oracle
13 12 (33.33%) T-SQL
13 12 (33.33%) SQL Server Analysis Services
14 11 (30.56%) QlikView
15 10 (27.78%) Microsoft
15 10 (27.78%) Visual Studio
15 10 (27.78%) Power BI
16 9 (25.00%) OLAP
17 8 (22.22%) PL/SQL
17 8 (22.22%) SDLC
17 8 (22.22%) Inmon Methodology
18 7 (19.44%) Enterprise Data Warehouse
18 7 (19.44%) Agile Software Development
19 6 (16.67%) Oracle Database 11g
19 6 (16.67%) Oracle OLAP
19 6 (16.67%) Data Governance
19 6 (16.67%) Oracle Database 12c
19 6 (16.67%) Oracle Database
20 5 (13.89%) OLAP Cube

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 3 (8.33%) Oracle SOA Suite
2 1 (2.78%) Confluence
2 1 (2.78%) SharePoint
Applications
1 1 (2.78%) MS Excel
Business Applications
1 1 (2.78%) Dynamics CRM
Cloud Services
1 3 (8.33%) Google Cloud Platform
2 2 (5.56%) Microsoft Azure
Database & Business Intelligence
1 34 (94.44%) Star Schema
2 28 (77.78%) Data Warehouse
3 22 (61.11%) SQL Server Integration Services
4 19 (52.78%) SQL Server
5 18 (50.00%) SQL Server Reporting Services
6 12 (33.33%) SQL Server Analysis Services
7 11 (30.56%) QlikView
8 10 (27.78%) Power BI
9 9 (25.00%) OLAP
10 7 (19.44%) Enterprise Data Warehouse
11 6 (16.67%) Oracle Database
11 6 (16.67%) Oracle Database 11g
11 6 (16.67%) Oracle Database 12c
11 6 (16.67%) Oracle OLAP
12 5 (13.89%) OLAP Cube
12 5 (13.89%) SQL Server 2014
13 4 (11.11%) Oracle BI EE
14 3 (8.33%) Oracle ODI
14 3 (8.33%) Qlik Sense
15 2 (5.56%) BigQuery
Development Applications
1 10 (27.78%) Visual Studio
2 5 (13.89%) ERwin
3 1 (2.78%) JIRA
3 1 (2.78%) Talend Open Studio
General
1 4 (11.11%) Retail
2 3 (8.33%) Legal
3 2 (5.56%) Finance
Job Titles
1 16 (44.44%) Developer
2 12 (33.33%) Architect
3 11 (30.56%) Business Intelligence Developer
4 8 (22.22%) Data Architect
5 7 (19.44%) Data Warehouse Architect
6 5 (13.89%) Data Warehouse Developer
6 5 (13.89%) Senior Developer
6 5 (13.89%) SSIS Developer
6 5 (13.89%) SSRS Developer
7 3 (8.33%) Analyst
7 3 (8.33%) Business Developer
7 3 (8.33%) Business Intelligence Consultant
7 3 (8.33%) Consultant
7 3 (8.33%) Database Architect
7 3 (8.33%) Senior Architect
7 3 (8.33%) Senior Data Warehouse Developer
7 3 (8.33%) Senior Database Architect
8 2 (5.56%) Microsoft BI Consultant
8 2 (5.56%) Oracle BI Developer
8 2 (5.56%) Report Writer
Libraries, Frameworks & Software Standards
1 3 (8.33%) Middleware
1 3 (8.33%) Oracle GoldenGate
1 3 (8.33%) XML
2 2 (5.56%) .NET
2 2 (5.56%) AngularJS
2 2 (5.56%) CSS
2 2 (5.56%) CSS3
2 2 (5.56%) HTML
2 2 (5.56%) HTML5
2 2 (5.56%) JSON
2 2 (5.56%) MDX
2 2 (5.56%) REST
2 2 (5.56%) Twitter Bootstrap
2 2 (5.56%) WCF
2 2 (5.56%) Web Services
Miscellaneous
1 2 (5.56%) Analytical Skills
1 2 (5.56%) Data Integration
1 2 (5.56%) Visualisation
2 1 (2.78%) Clustering
2 1 (2.78%) NHS
2 1 (2.78%) Replication
Processes & Methodologies
1 31 (86.11%) Business Intelligence
2 26 (72.22%) ETL
3 23 (63.89%) Data Modelling
4 20 (55.56%) Kimball Methodology
5 16 (44.44%) Performance Tuning
6 8 (22.22%) Inmon Methodology
6 8 (22.22%) SDLC
7 7 (19.44%) Agile Software Development
8 6 (16.67%) Data Governance
9 5 (13.89%) SOA
10 4 (11.11%) Analytics
10 4 (11.11%) Data Analytics
10 4 (11.11%) Information Architecture
10 4 (11.11%) Mentoring
11 3 (8.33%) ETL Development
12 2 (5.56%) Data Visualisation
12 2 (5.56%) Enterprise Architecture
12 2 (5.56%) Logical Data Model
12 2 (5.56%) Physical Data Model
12 2 (5.56%) Waterfall
Programming Languages
1 24 (66.67%) SQL
2 12 (33.33%) T-SQL
3 8 (22.22%) PL/SQL
4 2 (5.56%) C#
4 2 (5.56%) JavaScript
4 2 (5.56%) TypeScript
4 2 (5.56%) VB.NET
Qualifications
1 5 (13.89%) Microsoft Certification
2 1 (2.78%) Degree
Quality Assurance & Compliance
1 3 (8.33%) Data Quality
Vendors
1 13 (36.11%) Oracle
2 10 (27.78%) Microsoft
3 4 (11.11%) Tableau
4 3 (8.33%) Google
4 3 (8.33%) Informatica
5 2 (5.56%) Salesforce.com
6 1 (2.78%) Alteryx
6 1 (2.78%) MicroStrategy
6 1 (2.78%) Talend
Haverhill, Suffolk
Opus Resourcing Ltd
Salary: £50000 - £60000 per annum + Bens + Bonus
Posted: 4 days ago