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

3 months to
29 Sep 2016
Same period 2015 Same period 2014
Snowflake Schema
Rank 881 952 970
Rank change year-on-year
+71 +18
Permanent jobs citing Snowflake Schema 26 15 14
As % of all permanent IT jobs located in the UK 0.027% 0.014% 0.012%
As % of the Database & Business Intelligence category 0.093% 0.045% 0.039%
Number of salaries quoted 25 15 11
Median salary £67,500 £41,500 £42,500
Median salary % change year-on-year
+62.65% -2.35%
UK excluding London median salary £36,750 £41,500 £42,500
% change year-on-year
-11.44% -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
28097 33606 35887
As % of all permanent IT jobs located in the UK 29.57% 30.75% 31.39%
Number of salaries quoted 23895 28456 30138
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 £67,500 £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 29 September 2016 within the UK.

Snowflake Schema Salary Histogram in the UK

Snowflake Schema
Top 12 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 September 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 +75 25 £67,500 +62.65% 2
London +59 17 £72,500 +77.91%
Warrington - 6 £35,000 - 1
Cheshire - 6 £35,000 - 1
North West - 6 £35,000 - 1
Yorkshire - 2 £42,500 -
North Yorkshire - 1 £40,000 -
West Yorkshire - 1 £45,000 -
York - 1 £40,000 -
Glasgow - 1 £40,000 -
Leeds - 1 £45,000 -
Scotland - 1 £40,000 -

Snowflake Schema
Top 30 Related IT Skills

For the 6 months to 29 September 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 30 (88.24%) Star Schema
2 28 (82.35%) Data Warehouse
2 28 (82.35%) Business Intelligence
3 25 (73.53%) ETL
4 21 (61.76%) SQL
4 21 (61.76%) SQL Server Integration Services
5 19 (55.88%) Data Modelling
6 18 (52.94%) SQL Server
6 18 (52.94%) Kimball Methodology
7 17 (50.00%) SQL Server Reporting Services
8 14 (41.18%) Microsoft
9 12 (35.29%) Performance Tuning
9 12 (35.29%) SQL Server Analysis Services
10 10 (29.41%) Oracle
11 9 (26.47%) OLAP
12 8 (23.53%) T-SQL
12 8 (23.53%) Inmon Methodology
13 7 (20.59%) PL/SQL
13 7 (20.59%) Enterprise Data Warehouse
13 7 (20.59%) SDLC
14 6 (17.65%) Power BI
14 6 (17.65%) Agile Software Development
14 6 (17.65%) Visual Studio
14 6 (17.65%) ERwin
14 6 (17.65%) Oracle Database 12c
14 6 (17.65%) Oracle Database
14 6 (17.65%) Mentoring
14 6 (17.65%) Data Governance
14 6 (17.65%) QlikView
14 6 (17.65%) Oracle Database 11g

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 (5.88%) Apache Pig
2 1 (2.94%) SharePoint
Business Applications
1 2 (5.88%) Dynamics NAV
2 1 (2.94%) Dynamics CRM
Cloud Services
1 4 (11.76%) Microsoft Azure
2 1 (2.94%) Google Cloud Platform
Database & Business Intelligence
1 30 (88.24%) Star Schema
2 28 (82.35%) Data Warehouse
3 21 (61.76%) SQL Server Integration Services
4 18 (52.94%) SQL Server
5 17 (50.00%) SQL Server Reporting Services
6 12 (35.29%) SQL Server Analysis Services
7 9 (26.47%) OLAP
8 7 (20.59%) Enterprise Data Warehouse
9 6 (17.65%) Data Mart
9 6 (17.65%) Oracle Database
9 6 (17.65%) Oracle Database 11g
9 6 (17.65%) Oracle Database 12c
9 6 (17.65%) Power BI
9 6 (17.65%) QlikView
10 5 (14.71%) SQL Server 2014
11 4 (11.76%) Relational Database
12 3 (8.82%) Azure SQL Database
12 3 (8.82%) MySQL
12 3 (8.82%) RDBMS
12 3 (8.82%) SQL Server 2012
Development Applications
1 6 (17.65%) ERwin
1 6 (17.65%) Visual Studio
2 2 (5.88%) Git (software)
2 2 (5.88%) Team Foundation Server
3 1 (2.94%) Talend Open Studio
General
1 4 (11.76%) Legal
2 3 (8.82%) Retail
3 2 (5.88%) Advertising
3 2 (5.88%) Finance
4 1 (2.94%) Banking
Job Titles
1 15 (44.12%) Developer
2 13 (38.24%) Architect
3 9 (26.47%) Data Architect
4 8 (23.53%) Data Warehouse Architect
5 7 (20.59%) Business Intelligence Developer
5 7 (20.59%) Data Warehouse Developer
6 3 (8.82%) Business Intelligence Consultant
6 3 (8.82%) Business Intelligence Lead
6 3 (8.82%) Consultant
6 3 (8.82%) Database Architect
6 3 (8.82%) Lead Developer
6 3 (8.82%) Senior Architect
6 3 (8.82%) Senior Data Warehouse Developer
6 3 (8.82%) Senior Database Architect
6 3 (8.82%) Senior Developer
7 2 (5.88%) Analyst
7 2 (5.88%) Data Warehouse Consultant
7 2 (5.88%) Enterprise Technical Architect
7 2 (5.88%) SQL Analyst
7 2 (5.88%) Technical Architect
Libraries, Frameworks & Software Standards
1 2 (5.88%) .NET
1 2 (5.88%) AngularJS
1 2 (5.88%) CSS
1 2 (5.88%) CSS3
1 2 (5.88%) HTML
1 2 (5.88%) HTML5
1 2 (5.88%) MDX
1 2 (5.88%) REST
1 2 (5.88%) Twitter Bootstrap
1 2 (5.88%) WCF
1 2 (5.88%) Web Services
2 1 (2.94%) JSON
2 1 (2.94%) Oracle GoldenGate
2 1 (2.94%) XML
Miscellaneous
1 3 (8.82%) Data Integration
1 3 (8.82%) Visualisation
2 2 (5.88%) Analytical Skills
Processes & Methodologies
1 28 (82.35%) Business Intelligence
2 25 (73.53%) ETL
3 19 (55.88%) Data Modelling
4 18 (52.94%) Kimball Methodology
5 12 (35.29%) Performance Tuning
6 8 (23.53%) Inmon Methodology
7 7 (20.59%) SDLC
8 6 (17.65%) Agile Software Development
8 6 (17.65%) Data Governance
8 6 (17.65%) Mentoring
9 3 (8.82%) Analytics
9 3 (8.82%) Data Analytics
9 3 (8.82%) ETL Development
9 3 (8.82%) Refactoring
9 3 (8.82%) Scrum
10 2 (5.88%) Enterprise Architecture
10 2 (5.88%) Logical Data Model
10 2 (5.88%) Physical Data Model
10 2 (5.88%) Project Planning
10 2 (5.88%) Technical Architecture
Programming Languages
1 21 (61.76%) SQL
2 8 (23.53%) T-SQL
3 7 (20.59%) PL/SQL
4 2 (5.88%) C#
4 2 (5.88%) JavaScript
4 2 (5.88%) Python
4 2 (5.88%) R
4 2 (5.88%) TypeScript
4 2 (5.88%) VB.NET
Qualifications
1 5 (14.71%) Microsoft Certification
Quality Assurance & Compliance
1 2 (5.88%) Data Quality
Systems Management
1 1 (2.94%) Oracle Enterprise Manager
Vendors
1 14 (41.18%) Microsoft
2 10 (29.41%) Oracle
3 4 (11.76%) Alteryx
4 3 (8.82%) Google
4 3 (8.82%) Informatica
4 3 (8.82%) Tableau
4 3 (8.82%) Teradata
5 2 (5.88%) MicroStrategy
5 2 (5.88%) Salesforce.com
6 1 (2.94%) Cognos
6 1 (2.94%) Talend
Petersfield, Hampshire
Rullion IT Plus
Salary: £42000 - £50000 per annum + Pension
Posted: Yesterday
Warrington, Cheshire
Harvey Nash plc
Posted: 6 days ago