Period
to 20 November 2017

The following table provides summary statistics for contract job vacancies advertised in the North West 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 20 November 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
England > North West
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 189 209 217
Rank change year-on-year +20 +8 -58
Contract jobs citing Dimensional Modelling 13 14 31
As % of all contract IT jobs advertised in the North West 0.23% 0.21% 0.36%
As % of the Processes & Methodologies category 0.28% 0.25% 0.45%
Number of daily rates quoted 7 9 17
North West median daily rate £475 £550 £450
Median daily rate % change year-on-year -13.64% +22.22% -
10th Percentile £319 £399 £343
90th Percentile £525 £625 £488
England median daily rate £450 £423 £450
% change year-on-year +6.51% -6.11% +5.88%
Number of hourly rates quoted 0 1 0
North West median hourly rate - £20.50 -
England median hourly rate - £20.50 -

Dimensional Modelling is in the Processes and Methodologies category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in the North West with a requirement for process or methodology skills.

All Process and Methodology Skills
North West
Contract vacancies with a requirement for process or methodology skills 4629 5692 6965
As % of all contract IT jobs advertised in the North West 81.32% 83.89% 81.06%
Number of daily rates quoted 2952 3672 4228
North West median daily rate £400 £400 £400
10th Percentile £263 £263 £255
90th Percentile £587 £556 £575
England median daily rate £450 £425 £423
% change year-on-year +5.88% +0.59% +5.63%
Number of hourly rates quoted 202 166 283
North West median hourly rate £27.00 £22.42 £30.52
Median hourly rate % change year-on-year +20.41% -26.53% +69.56%
10th Percentile £11.56 £12.13 £12.38
90th Percentile £52.93 £53.00 £52.47
England median hourly rate £24.00 £24.42 £22.50
% change year-on-year -1.72% +8.53% +18.42%

Dimensional Modelling
Job Vacancy Trend in the North West

Job postings citing Dimensional Modelling as a percentage of all IT jobs advertised in the North West.

Job vacancy trend for Dimensional Modelling in the North West

Dimensional Modelling
Contractor Daily Rate Trend in the North West

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

Contractor daily rate trend for Dimensional Modelling in the North West

Dimensional Modelling
Contractor Daily Rate Histogram in the North West

The daily rate distribution of IT jobs citing Dimensional Modelling in the North West over the 6 months to 20 November 2017.

Contractor daily rate histogram for Dimensional Modelling in the North West

Dimensional Modelling
Contractor Hourly Rate Trend in the North West

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing Dimensional Modelling in the North West.

Contractor hourly rate trend for Dimensional Modelling in the North West

Dimensional Modelling
Contract Job Locations in the North West

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing Dimensional Modelling within the North West region over the 6 months to 20 November 2017. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Cheshire -1 5 £500 -9.09% 1
Manchester - 3 £475 -
Merseyside - 1 - -
Dimensional Modelling
England

For the 6 months to 20 November 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 North West region with a requirement for Dimensional Modelling.

1 12 (92.31%) Data Modelling
2 11 (84.62%) Data Warehouse
3 10 (76.92%) Logical Data Model
4 8 (61.54%) Kimball Methodology
5 7 (53.85%) Conceptual Models
6 6 (46.15%) ETL
7 5 (38.46%) Snowflake Schema
7 5 (38.46%) Data Integration
8 3 (23.08%) Finance
8 3 (23.08%) Banking
8 3 (23.08%) Retail
8 3 (23.08%) Data Management
8 3 (23.08%) IBM
8 3 (23.08%) DataStage
8 3 (23.08%) Tivoli
8 3 (23.08%) Tivoli Workload Scheduler
8 3 (23.08%) Oracle
8 3 (23.08%) IBM InfoSphere
8 3 (23.08%) SDLC
8 3 (23.08%) ETL Development
9 2 (15.38%) Spatial Data
9 2 (15.38%) GDPR
9 2 (15.38%) Physical Data Model
9 2 (15.38%) Data Structures
9 2 (15.38%) Business Intelligence
9 2 (15.38%) SOA
9 2 (15.38%) Data Mart
9 2 (15.38%) Data Cleansing
9 2 (15.38%) Data Architecture
9 2 (15.38%) Reverse Engineering

Dimensional Modelling
Co-occurring IT Skills in the North West 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:

Database & Business Intelligence
1 11 (84.62%) Data Warehouse
2 5 (38.46%) Snowflake Schema
3 3 (23.08%) DataStage
3 3 (23.08%) IBM InfoSphere
4 2 (15.38%) Data Mart
4 2 (15.38%) Spatial Data
5 1 (7.69%) SQL Server
5 1 (7.69%) SQL Server Integration Services
Development Applications
1 1 (7.69%) ERwin
General
1 3 (23.08%) Banking
1 3 (23.08%) Finance
1 3 (23.08%) Retail
Job Titles
1 6 (46.15%) Developer
2 5 (38.46%) Data Modeller
3 3 (23.08%) DataStage Developer
4 2 (15.38%) Architect
4 2 (15.38%) Data Architect
4 2 (15.38%) ETL Developer
5 1 (7.69%) Data Warehouse Developer
Miscellaneous
1 2 (15.38%) Data Structures
Processes & Methodologies
1 12 (92.31%) Data Modelling
2 10 (76.92%) Logical Data Model
3 8 (61.54%) Kimball Methodology
4 7 (53.85%) Conceptual Models
5 6 (46.15%) ETL
6 5 (38.46%) Data Integration
7 3 (23.08%) Data Management
7 3 (23.08%) ETL Development
7 3 (23.08%) SDLC
8 2 (15.38%) Business Intelligence
8 2 (15.38%) Data Architecture
8 2 (15.38%) Data Cleansing
8 2 (15.38%) Data Governance
8 2 (15.38%) Information Architecture
8 2 (15.38%) Physical Data Model
8 2 (15.38%) Reverse Engineering
8 2 (15.38%) SOA
9 1 (7.69%) ArchiMate
9 1 (7.69%) Enterprise Architecture
9 1 (7.69%) TOGAF
Programming Languages
1 1 (7.69%) SQL
1 1 (7.69%) T-SQL
Quality Assurance & Compliance
1 2 (15.38%) GDPR
System Software
1 3 (23.08%) Tivoli Workload Scheduler
Systems Management
1 3 (23.08%) Tivoli
Vendors
1 3 (23.08%) IBM
1 3 (23.08%) Oracle