Period
to 24 February 2018

The following table provides summary statistics for permanent job vacancies advertised in Chester with a requirement for Snowflake Schema skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Snowflake Schema over the 6 months to 24 February 2018 with a comparison to the same period in the previous 2 years.

Snowflake Schema
Cheshire > Chester
6 months to
24 Feb 2018
Same period 2017 Same period 2016
Rank 56 - -
Rank change year-on-year - - -
Permanent jobs citing Snowflake Schema 5 0 0
As % of all permanent IT jobs advertised in Chester 1.21% - -
As % of the Database & Business Intelligence category 2.73% - -
Number of salaries quoted 5 0 0
Chester median annual salary £47,500 - -
Cheshire median annual salary £47,500 £36,000 -
% change year-on-year +31.94% - -

Snowflake Schema is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Chester with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Chester
Permanent vacancies with a requirement for database or business intelligence skills 183 100 142
As % of all permanent IT jobs advertised in Chester 44.20% 35.71% 43.83%
Number of salaries quoted 168 88 133
Chester median annual salary £42,500 £36,500 £45,000
Median salary % change year-on-year +16.44% -18.89% +12.50%
10th Percentile £26,250 £26,025 £23,400
90th Percentile £55,000 £48,250 £60,100
Cheshire median annual salary £42,500 £39,000 £40,000
% change year-on-year +8.97% -2.50% -

For the 6 months to 24 February 2018, IT jobs citing Snowflake Schema also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Chester region with a requirement for Snowflake Schema.

1 5 (100.00%) Finance
1 5 (100.00%) Migration
1 5 (100.00%) SQL Server Reporting Services
1 5 (100.00%) Data Analysis
1 5 (100.00%) Google
1 5 (100.00%) SQL Server Integration Services
1 5 (100.00%) Degree
1 5 (100.00%) QlikView
1 5 (100.00%) Google Analytics
1 5 (100.00%) SQL Server Analysis Services
1 5 (100.00%) Data Migration
1 5 (100.00%) Visualisation
1 5 (100.00%) Stakeholder Engagement
1 5 (100.00%) Data Visualisation
1 5 (100.00%) Tableau
1 5 (100.00%) SQL Server
1 5 (100.00%) Data Warehouse
1 5 (100.00%) Data Mining
1 5 (100.00%) ETL
1 5 (100.00%) Business Intelligence
1 5 (100.00%) Salesforce.com
1 5 (100.00%) Big Data
1 5 (100.00%) Analytics
1 5 (100.00%) Qlik Sense
1 5 (100.00%) Power BI
1 5 (100.00%) SQL Server 2016
2 2 (40.00%) Twitter

Snowflake Schema
Co-occurring IT Skills in Chester 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:

Cloud Services
1 5 (100.00%) Google Analytics
Database & Business Intelligence
1 5 (100.00%) Big Data
1 5 (100.00%) Data Mining
1 5 (100.00%) Data Warehouse
1 5 (100.00%) Power BI
1 5 (100.00%) Qlik Sense
1 5 (100.00%) QlikView
1 5 (100.00%) SQL Server
1 5 (100.00%) SQL Server 2016
1 5 (100.00%) SQL Server Analysis Services
1 5 (100.00%) SQL Server Integration Services
1 5 (100.00%) SQL Server Reporting Services
General
1 5 (100.00%) Finance
Job Titles
1 5 (100.00%) Business Intelligence Developer
1 5 (100.00%) Developer
2 4 (80.00%) Business Intelligence Lead
2 4 (80.00%) Lead Developer
Processes & Methodologies
1 5 (100.00%) Analytics
1 5 (100.00%) Business Intelligence
1 5 (100.00%) Data Analysis
1 5 (100.00%) Data Migration
1 5 (100.00%) Data Visualisation
1 5 (100.00%) ETL
1 5 (100.00%) Migration
1 5 (100.00%) Stakeholder Engagement
1 5 (100.00%) Visualisation
Qualifications
1 5 (100.00%) Degree
Vendors
1 5 (100.00%) Google
1 5 (100.00%) Salesforce.com
1 5 (100.00%) Tableau
2 2 (40.00%) Twitter