Period
to 22 October 2018

The following table provides summary statistics for contract job vacancies advertised in Manchester with a requirement for Star Schema skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Star Schema over the 6 months to 22 October 2018 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Star Schema
North West > Manchester
6 months to
22 Oct 2018
Same period 2017 Same period 2016
Rank 142 131 154
Rank change year-on-year -11 +23 -8
Contract jobs citing Star Schema 3 9 4
As % of all contract IT jobs advertised in Manchester 0.096% 0.32% 0.11%
As % of the Database & Business Intelligence category 0.45% 1.36% 0.48%
Number of daily rates quoted 3 6 4
Manchester median daily rate £375 £501 £450
Median daily rate % change year-on-year -25.15% +11.33% +44.00%
10th Percentile £339 £313 £425
90th Percentile £400 £586 £475
North West median daily rate £380 £577 £450
% change year-on-year -34.14% +28.22% +12.50%
Number of hourly rates quoted 0 0 0
Manchester median hourly rate - - -
North West median hourly rate - - -

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

All Database and Business Intelligence Skills
Manchester
Contract vacancies with a requirement for database or business intelligence skills 665 664 827
As % of all contract IT jobs advertised in Manchester 21.25% 23.36% 22.78%
Number of daily rates quoted 467 454 547
Manchester median daily rate £400 £400 £375
Median daily rate % change year-on-year - +6.67% -
10th Percentile £300 £300 £241
90th Percentile £575 £575 £530
North West median daily rate £400 £400 £375
% change year-on-year - +6.67% -6.25%
Number of hourly rates quoted 3 2 9
Manchester median hourly rate £35.00 £18.85 £28.50
Median hourly rate % change year-on-year +85.73% -33.88% +48.05%
North West median hourly rate £35.00 £41.38 £32.26
% change year-on-year -15.41% +28.24% -13.39%

Star Schema
Job Vacancy Trend in Manchester

Job postings citing Star Schema as a percentage of all IT jobs advertised in Manchester.

Job vacancy trend for Star Schema in Manchester

Star Schema
Contractor Daily Rate Trend in Manchester

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing Star Schema in Manchester.

Contractor daily rate trend for Star Schema in Manchester

For the 6 months to 22 October 2018, IT contractor jobs citing Star Schema also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Manchester region with a requirement for Star Schema.

1 3 (100.00%) SQL Server
1 3 (100.00%) OLAP
1 3 (100.00%) Data Warehouse
1 3 (100.00%) ETL
1 3 (100.00%) Business Intelligence
1 3 (100.00%) SQL
1 3 (100.00%) Migration
1 3 (100.00%) SQL Server Integration Services
1 3 (100.00%) OLAP Cube
1 3 (100.00%) Greenfield Project
1 3 (100.00%) Problem-Solving
2 2 (66.67%) Power BI
2 2 (66.67%) SQL Server 2016
2 2 (66.67%) Data Migration
2 2 (66.67%) Agile Software Development
2 2 (66.67%) Retail
2 2 (66.67%) E-Commerce
3 1 (33.33%) E-business
3 1 (33.33%) Finance
3 1 (33.33%) SQL Server Reporting Services
3 1 (33.33%) MDX
3 1 (33.33%) SQL Server Analysis Services
3 1 (33.33%) T-SQL
3 1 (33.33%) Microsoft Azure
3 1 (33.33%) Azure SQL Database
3 1 (33.33%) SQL Server 2012
3 1 (33.33%) Data Analysis Expressions (DAX)
3 1 (33.33%) Performance Tuning
3 1 (33.33%) Dashboard Development

Star Schema
Co-occurring IT Skills in Manchester 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 1 (33.33%) Microsoft Azure
Database & Business Intelligence
1 3 (100.00%) Data Warehouse
1 3 (100.00%) OLAP
1 3 (100.00%) OLAP Cube
1 3 (100.00%) SQL Server
1 3 (100.00%) SQL Server Integration Services
2 2 (66.67%) Power BI
2 2 (66.67%) SQL Server 2016
3 1 (33.33%) Azure SQL Database
3 1 (33.33%) SQL Server 2012
3 1 (33.33%) SQL Server Analysis Services
3 1 (33.33%) SQL Server Reporting Services
General
1 2 (66.67%) Retail
2 1 (33.33%) Finance
Job Titles
1 2 (66.67%) Business Developer
1 2 (66.67%) Business Intelligence Developer
1 2 (66.67%) Developer
2 1 (33.33%) Business Intelligence Lead
2 1 (33.33%) Team Leader
Libraries, Frameworks & Software Standards
1 1 (33.33%) MDX
Miscellaneous
1 3 (100.00%) Greenfield Project
Processes & Methodologies
1 3 (100.00%) Business Intelligence
1 3 (100.00%) ETL
1 3 (100.00%) Migration
1 3 (100.00%) Problem-Solving
2 2 (66.67%) Agile Software Development
2 2 (66.67%) Data Migration
2 2 (66.67%) E-Commerce
3 1 (33.33%) Dashboard Development
3 1 (33.33%) E-business
3 1 (33.33%) Performance Tuning
Programming Languages
1 3 (100.00%) SQL
2 1 (33.33%) Data Analysis Expressions (DAX)
2 1 (33.33%) T-SQL