Period
to 23 October 2018

The following table provides summary statistics for permanent job vacancies advertised in Cornwall 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 23 October 2018 with a comparison to the same period in the previous 2 years.

Snowflake Schema
South West > Cornwall
6 months to
23 Oct 2018
Same period 2017 Same period 2016
Rank 51 - -
Rank change year-on-year - - -
Permanent jobs citing Snowflake Schema 4 0 0
As % of all permanent IT jobs advertised in Cornwall 1.36% - -
As % of the Database & Business Intelligence category 4.88% - -
Number of salaries quoted 0 0 0
Cornwall median annual salary - - -
South West median annual salary - - £55,000

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 Cornwall with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
Cornwall
Permanent vacancies with a requirement for database or business intelligence skills 82 80 113
As % of all permanent IT jobs advertised in Cornwall 27.89% 24.92% 37.92%
Number of salaries quoted 49 53 56
Cornwall median annual salary £33,500 £32,500 £32,500
Median salary % change year-on-year +3.08% - -
10th Percentile £23,700 £23,000 £23,875
90th Percentile £41,750 £46,600 £52,500
South West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.26%

Snowflake Schema
Job Locations in Cornwall

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Snowflake Schema within the Cornwall region over the 6 months to 23 October 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Newquay - 4 - -
Snowflake Schema
South West

For the 6 months to 23 October 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 Cornwall region with a requirement for Snowflake Schema.

1 4 (100.00%) MySQL
1 4 (100.00%) Oracle
1 4 (100.00%) SQL Server
1 4 (100.00%) Microsoft Office
1 4 (100.00%) SOAP
1 4 (100.00%) Web Services
1 4 (100.00%) ITIL
1 4 (100.00%) Windows
1 4 (100.00%) Postgraduate
1 4 (100.00%) SharePoint
1 4 (100.00%) Data Warehouse
1 4 (100.00%) EAI
1 4 (100.00%) Data Modelling
1 4 (100.00%) SOA
1 4 (100.00%) ETL
1 4 (100.00%) Business Intelligence
1 4 (100.00%) Microsoft
1 4 (100.00%) ITIL Certification
1 4 (100.00%) BizTalk Server
1 4 (100.00%) Salesforce.com
1 4 (100.00%) Project Management
1 4 (100.00%) Management Information System
1 4 (100.00%) Finance
1 4 (100.00%) Validation
1 4 (100.00%) SQL Server Reporting Services
1 4 (100.00%) Data Mart
1 4 (100.00%) SQL Server Integration Services
1 4 (100.00%) Degree
1 4 (100.00%) Computer Science
1 4 (100.00%) User Acceptance Testing

Snowflake Schema
Co-occurring IT Skills in Cornwall 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 4 (100.00%) BizTalk Server
1 4 (100.00%) Oracle SOA Suite
1 4 (100.00%) SharePoint
Applications
1 4 (100.00%) Microsoft Office
Database & Business Intelligence
1 4 (100.00%) Data Mart
1 4 (100.00%) Data Warehouse
1 4 (100.00%) MySQL
1 4 (100.00%) Power BI
1 4 (100.00%) SQL Server
1 4 (100.00%) SQL Server 2012
1 4 (100.00%) SQL Server Integration Services
1 4 (100.00%) SQL Server Reporting Services
General
1 4 (100.00%) Finance
Job Titles
1 4 (100.00%) Developer
Libraries, Frameworks & Software Standards
1 4 (100.00%) REST
1 4 (100.00%) SOAP
1 4 (100.00%) Web Services
Miscellaneous
1 4 (100.00%) Analytical Skills
1 4 (100.00%) Computer Science
1 4 (100.00%) Enterprise Software
1 4 (100.00%) Management Information System
Operating Systems
1 4 (100.00%) Windows
Processes & Methodologies
1 4 (100.00%) Business Intelligence
1 4 (100.00%) Change Data Capture
1 4 (100.00%) Continuous Improvement
1 4 (100.00%) Data Cleansing
1 4 (100.00%) Data Governance
1 4 (100.00%) Data Integration
1 4 (100.00%) Data Modelling
1 4 (100.00%) EAI
1 4 (100.00%) ETL
1 4 (100.00%) ITIL
1 4 (100.00%) Logical Data Model
1 4 (100.00%) Physical Data Model
1 4 (100.00%) Problem-Solving
1 4 (100.00%) Project Management
1 4 (100.00%) SOA
1 4 (100.00%) User Acceptance Testing
1 4 (100.00%) Validation
Qualifications
1 4 (100.00%) Degree
1 4 (100.00%) ITIL Certification
1 4 (100.00%) Postgraduate
Quality Assurance & Compliance
1 4 (100.00%) Data Quality
Vendors
1 4 (100.00%) Microsoft
1 4 (100.00%) Oracle
1 4 (100.00%) Salesforce.com