Period
to 22 July 2017

The following table provides summary statistics for contract job vacancies advertised in Manchester with a requirement for Dimensional Modelling skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited Dimensional Modelling over the 6 months to 22 July 2017 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.

Dimensional Modelling
North West > Manchester
6 months to
22 Jul 2017
Same period 2016 Same period 2015
Rank 136 148 143
Rank change year-on-year +12 -5 -27
Contract jobs citing Dimensional Modelling 4 1 2
As % of all contract IT jobs advertised in Manchester 0.14% 0.027% 0.061%
As % of the Processes & Methodologies category 0.18% 0.033% 0.079%
Number of daily rates quoted 2 1 1
Manchester median daily rate £325 £220 £350
Median daily rate % change year-on-year +47.73% -37.14% -23.08%
North West median daily rate £450 £413 £520
% change year-on-year +9.09% -20.67% +15.56%
Number of hourly rates quoted 0 0 0
Manchester median hourly rate - - -
North West median hourly rate - £20.50 -

Dimensional Modelling is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Manchester with a requirement for process and methodology skills.

Contract Process & Methodology Skills
Manchester
Contract job vacancies with a requirement for process and methodology skills 2274 3024 2532
As % of all contract IT job vacancies advertised in Manchester 80.75% 82.26% 77.76%
Number of daily rates quoted 1400 1838 1445
Manchester median daily rate £388 £400 £363
Median daily rate % change year-on-year -3.13% +10.34% +3.57%
10th Percentile £237 £255 £226
90th Percentile £544 £538 £538
North West median daily rate £400 £400 £383
% change year-on-year - +4.58% +9.29%
Number of hourly rates quoted 61 52 60
Manchester median hourly rate £18.00 £15.64 £16.31
Median hourly rate % change year-on-year +15.09% -4.08% +5.19%
10th Percentile £11.75 £12.14 £10.73
90th Percentile £43.75 £44.65 £38.88
North West median hourly rate £36.00 £29.25 £27.50
% change year-on-year +23.08% +6.36% +23.94%

Dimensional Modelling
Job Vacancy Trend in Manchester

Job postings citing Dimensional Modelling as a percentage of all IT jobs advertised in Manchester.

Job vacancy trend for Dimensional Modelling in Manchester

Dimensional Modelling
Contractor Daily Rate Trend in Manchester

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

Contractor daily rate trend for Dimensional Modelling in Manchester

For the 6 months to 22 July 2017, IT contractor jobs citing Dimensional Modelling also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads across the Manchester region with a requirement for Dimensional Modelling.

1 4 (100.00%) SQL
1 4 (100.00%) T-SQL
1 4 (100.00%) SQL Server
1 4 (100.00%) Data Warehouse
1 4 (100.00%) ETL
1 4 (100.00%) SQL Server Integration Services
2 2 (50.00%) Marketing
2 2 (50.00%) SQL Server Analysis Services
2 2 (50.00%) SQL Server 2012
2 2 (50.00%) Kimball Methodology
2 2 (50.00%) Data Transformation
2 2 (50.00%) Performance Tuning
2 2 (50.00%) ETL Development
2 2 (50.00%) Data Flow Diagram
2 2 (50.00%) Business Intelligence
2 2 (50.00%) Microsoft
2 2 (50.00%) MS Visio
2 2 (50.00%) Data Modelling
2 2 (50.00%) SharePoint

Dimensional Modelling
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:

Application Platforms
1 2 (50.00%) SharePoint
Applications
1 2 (50.00%) MS Visio
Database & Business Intelligence
1 4 (100.00%) Data Warehouse
1 4 (100.00%) SQL Server
1 4 (100.00%) SQL Server Integration Services
2 2 (50.00%) SQL Server 2012
2 2 (50.00%) SQL Server Analysis Services
General
1 2 (50.00%) Marketing
Job Titles
1 4 (100.00%) Developer
2 2 (50.00%) Business Intelligence Developer
2 2 (50.00%) Data Warehouse Developer
2 2 (50.00%) Senior Business Intelligence Developer
2 2 (50.00%) Senior Developer
2 2 (50.00%) Senior SQL Developer
2 2 (50.00%) SQL BI Developer
2 2 (50.00%) SQL Developer
2 2 (50.00%) SSIS Developer
2 2 (50.00%) T-SQL Developer
Processes & Methodologies
1 4 (100.00%) ETL
2 2 (50.00%) Business Intelligence
2 2 (50.00%) Data Flow Diagram
2 2 (50.00%) Data Modelling
2 2 (50.00%) Data Transformation
2 2 (50.00%) ETL Development
2 2 (50.00%) Kimball Methodology
2 2 (50.00%) Performance Tuning
Programming Languages
1 4 (100.00%) SQL
1 4 (100.00%) T-SQL
Vendors
1 2 (50.00%) Microsoft