Period
to 18 November 2017

The following table provides summary statistics for contract job vacancies advertised in the South 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 18 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 > South West
6 months to
18 Nov 2017
Same period 2016 Same period 2015
Rank 171 195 177
Rank change year-on-year +24 -18 +16
Contract jobs citing Dimensional Modelling 26 14 45
As % of all contract IT jobs advertised in the South West 0.46% 0.24% 0.68%
As % of the Processes & Methodologies category 0.57% 0.30% 0.85%
Number of daily rates quoted 18 7 37
South West median daily rate £425 £375 £450
Median daily rate % change year-on-year +13.33% -16.67% +38.46%
10th Percentile £363 £253 £320
90th Percentile £466 £425 £493
England median daily rate £450 £425 £450
% change year-on-year +5.88% -5.56% +5.88%
Number of hourly rates quoted 0 0 0
South West median hourly rate - - -
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 South West with a requirement for process or methodology skills.

All Process and Methodology Skills
South West
Contract vacancies with a requirement for process or methodology skills 4570 4641 5272
As % of all contract IT jobs advertised in the South West 81.33% 79.92% 79.60%
Number of daily rates quoted 2882 3120 3572
South West median daily rate £400 £375 £375
Median daily rate % change year-on-year +6.67% - -
10th Percentile £260 £238 £255
90th Percentile £556 £550 £525
England median daily rate £450 £425 £420
% change year-on-year +5.88% +1.19% +5.00%
Number of hourly rates quoted 186 269 254
South West median hourly rate £35.00 £31.50 £38.50
Median hourly rate % change year-on-year +11.11% -18.18% +48.08%
10th Percentile £12.19 £12.00 £13.86
90th Percentile £50.00 £47.50 £49.76
England median hourly rate £24.00 £24.41 £22.50
% change year-on-year -1.68% +8.49% +18.42%

Dimensional Modelling
Job Vacancy Trend in the South West

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

Job vacancy trend for Dimensional Modelling in the South West

Dimensional Modelling
Contractor Daily Rate Trend in the South West

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

Contractor daily rate trend for Dimensional Modelling in the South West

Dimensional Modelling
Contractor Daily Rate Histogram in the South West

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

Contractor daily rate histogram for Dimensional Modelling in the South West

Dimensional Modelling
Contractor Hourly Rate Trend in the South West

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

Contractor hourly rate trend for Dimensional Modelling in the South West

Dimensional Modelling
Contract Job Locations in the South 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 South West region over the 6 months to 18 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
Wiltshire +6 11 £388 -3.13%
Gloucestershire +19 8 £425 +13.33%
Bristol -12 4 - -
Dimensional Modelling
England

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

1 25 (96.15%) Data Warehouse
2 19 (73.08%) Business Intelligence
3 18 (69.23%) ETL
4 16 (61.54%) SQL
4 16 (61.54%) Finance
4 16 (61.54%) Kimball Methodology
5 15 (57.69%) Data Modelling
6 12 (46.15%) Teradata
7 11 (42.31%) Oracle
7 11 (42.31%) Oracle ODI
7 11 (42.31%) Relational Database
8 9 (34.62%) Analytics
8 9 (34.62%) Data Analysis
9 8 (30.77%) SQL Server Integration Services
9 8 (30.77%) Shell Script
9 8 (30.77%) SDLC
10 7 (26.92%) Data Mining
10 7 (26.92%) Unix
10 7 (26.92%) SQL Server Analysis Services
11 6 (23.08%) Oracle BI EE
11 6 (23.08%) Marketing
11 6 (23.08%) SQL Server
11 6 (23.08%) Star Schema
11 6 (23.08%) DevOps
12 5 (19.23%) Validation
12 5 (19.23%) SQL Server Reporting Services
13 4 (15.38%) Investment Banking
13 4 (15.38%) Banking
13 4 (15.38%) PL/SQL
13 4 (15.38%) Analytical Skills

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

Application Platforms
1 2 (7.69%) SAS
Cloud Services
1 2 (7.69%) Amazon AWS
1 2 (7.69%) Microsoft Azure
Database & Business Intelligence
1 25 (96.15%) Data Warehouse
2 11 (42.31%) Oracle ODI
2 11 (42.31%) Relational Database
3 8 (30.77%) SQL Server Integration Services
4 7 (26.92%) Data Mining
4 7 (26.92%) SQL Server Analysis Services
5 6 (23.08%) Oracle BI EE
5 6 (23.08%) SQL Server
5 6 (23.08%) Star Schema
6 5 (19.23%) SQL Server Reporting Services
7 3 (11.54%) Enterprise Data Warehouse
7 3 (11.54%) IBM InfoSphere
8 2 (7.69%) Amazon Redshift
8 2 (7.69%) Azure SQL Database
8 2 (7.69%) DataStage
8 2 (7.69%) Power BI
8 2 (7.69%) QualityStage
8 2 (7.69%) RDBMS
8 2 (7.69%) Semantic Layer
8 2 (7.69%) SQL Server 2016
Development Applications
1 1 (3.85%) ERwin
General
1 16 (61.54%) Finance
2 6 (23.08%) Marketing
3 4 (15.38%) Banking
3 4 (15.38%) Investment Banking
4 1 (3.85%) Retail
Job Titles
1 20 (76.92%) Developer
2 8 (30.77%) ETL Developer
3 7 (26.92%) Business Intelligence Developer
4 6 (23.08%) Teradata Developer
5 3 (11.54%) Analyst
5 3 (11.54%) Data Warehouse Developer
5 3 (11.54%) SSAS Developer
5 3 (11.54%) SSIS Developer
6 2 (7.69%) Analyst Developer
6 2 (7.69%) Business Intelligence Analyst
6 2 (7.69%) Power BI Developer
6 2 (7.69%) Redshift Developer
6 2 (7.69%) SSRS Developer
6 2 (7.69%) Teradata Analyst
7 1 (3.85%) Architect
7 1 (3.85%) Data Analyst
7 1 (3.85%) Data Architect
7 1 (3.85%) Data Modeller
7 1 (3.85%) Developer Analyst
7 1 (3.85%) Microsoft Developer
Miscellaneous
1 4 (15.38%) Analytical Skills
2 1 (3.85%) Greenfield Project
2 1 (3.85%) Management Information System
Operating Systems
1 7 (26.92%) Unix
2 1 (3.85%) Linux
2 1 (3.85%) Windows
2 1 (3.85%) Windows Server
Processes & Methodologies
1 19 (73.08%) Business Intelligence
2 18 (69.23%) ETL
3 16 (61.54%) Kimball Methodology
4 15 (57.69%) Data Modelling
5 9 (34.62%) Analytics
5 9 (34.62%) Data Analysis
6 8 (30.77%) SDLC
7 6 (23.08%) DevOps
8 5 (19.23%) Validation
9 4 (15.38%) Data Ingestion
10 3 (11.54%) Data Analytics
10 3 (11.54%) ETL Development
11 2 (7.69%) Agile Software Development
11 2 (7.69%) Data Governance
11 2 (7.69%) Data Lineage
11 2 (7.69%) Data Management
11 2 (7.69%) Data Security
11 2 (7.69%) Dependency Management
11 2 (7.69%) Inmon Methodology
11 2 (7.69%) Stakeholder Management
Programming Languages
1 16 (61.54%) SQL
2 8 (30.77%) Shell Script
3 4 (15.38%) PL/SQL
4 2 (7.69%) T-SQL
Qualifications
1 3 (11.54%) Degree
1 3 (11.54%) HNC
1 3 (11.54%) HND
Quality Assurance & Compliance
1 2 (7.69%) Data Quality
Vendors
1 12 (46.15%) Teradata
2 11 (42.31%) Oracle
3 3 (11.54%) Microsoft
4 2 (7.69%) IBM
4 2 (7.69%) Netezza