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 3 months to 28 June 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
3 months to
28 Jun 2017
Same period 2016 Same period 2015
Rank 129 138 121
Rank change year-on-year +9 -17  
Contract jobs citing Dimensional Modelling 13 2 21
As % of all contract IT jobs advertised in the South West 0.47% 0.067% 0.68%
As % of the Processes & Methodologies category 0.58% 0.085% 0.87%
Number of daily rates quoted 11 2 18
Median daily rate £425 £438 £380
Median daily rate % change year-on-year -2.85% +15.13%  
90% offered a daily rate of more than £400 £408 £314
10% offered a daily rate of more than £450 £468 £483
UK excluding London median daily rate £450 £413 £425
% change year-on-year +9.09% -2.94%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London 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 the South West with a requirement for process and methodology skills.

Contract Process & Methodology Skills
South West
Contract job vacancies with a requirement for process and methodology skills 2243 2364 2422
As % of all contract IT job vacancies advertised in the South West 81.92% 78.91% 78.66%
Number of daily rates quoted 1417 1565 1645
Median daily rate £400 £388 £388
Median daily rate % change year-on-year +3.22% -  
90% offered a daily rate of more than £285 £288 £290
10% offered a daily rate of more than £550 £588 £525
UK excluding London median daily rate £415 £400 £385
% change year-on-year +3.75% +3.89%  
Number of hourly rates quoted 96 106 109
Median hourly rate £42.50 £35.00 £37.00
Median hourly rate % change year-on-year +21.42% -5.40%  
90% offered a hourly rate of more than £17.00 £21.50 £16.00
10% offered a hourly rate of more than £52.50 £44.00 £55.00
UK excluding London median hourly rate £34.75 £28.50 £30.00
% change year-on-year +21.92% -5.00%  

Dimensional Modelling
Job Vacancy Trend in the South West

The job posting trend of jobs advertised in the South West citing Dimensional Modelling as a proportion of all contract or permanent IT jobs with a match in the Processes & Methodologies category.

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 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 3 months to 28 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Wiltshire +2 4 £413 -13.15%
Gloucestershire - 4 £425 -
Bristol -2 2 £413 +3.12%
Dimensional Modelling
England

For the 6 months to 28 June 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 18 (100.00%) Data Warehouse
2 14 (77.78%) Business Intelligence
3 13 (72.22%) SQL
3 13 (72.22%) Finance
3 13 (72.22%) Kimball Methodology
4 12 (66.67%) Data Modelling
5 9 (50.00%) Data Analysis
6 8 (44.44%) Degree
6 8 (44.44%) Relational Database
6 8 (44.44%) SDLC
6 8 (44.44%) Teradata
7 7 (38.89%) Oracle
7 7 (38.89%) HNC
7 7 (38.89%) HND
8 6 (33.33%) Oracle ODI
8 6 (33.33%) Data Mining
8 6 (33.33%) ETL
8 6 (33.33%) Validation
9 5 (27.78%) Stakeholder Management
9 5 (27.78%) PL/SQL
9 5 (27.78%) Shell Script
9 5 (27.78%) Unix
9 5 (27.78%) Analytical Skills
9 5 (27.78%) Banking
10 4 (22.22%) Investment Banking
10 4 (22.22%) Marketing
10 4 (22.22%) Oracle BI EE
10 4 (22.22%) DevOps
10 4 (22.22%) Analytics
10 4 (22.22%) Star Schema

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 1 (5.56%) SAS
Cloud Services
1 3 (16.67%) Amazon AWS
Database & Business Intelligence
1 18 (100.00%) Data Warehouse
2 8 (44.44%) Relational Database
3 6 (33.33%) Data Mining
3 6 (33.33%) Oracle ODI
4 4 (22.22%) Oracle BI EE
4 4 (22.22%) SQL Server
4 4 (22.22%) Star Schema
5 3 (16.67%) Amazon Redshift
5 3 (16.67%) MySQL
6 2 (11.11%) SQL Server Integration Services
7 1 (5.56%) BusinessObjects
7 1 (5.56%) Enterprise Data Warehouse
7 1 (5.56%) IBM InfoSphere
7 1 (5.56%) Oracle OWB
7 1 (5.56%) RDBMS
7 1 (5.56%) SQL Server Analysis Services
7 1 (5.56%) SQL Server Reporting Services
General
1 13 (72.22%) Finance
2 5 (27.78%) Banking
3 4 (22.22%) Investment Banking
3 4 (22.22%) Marketing
Job Titles
1 15 (83.33%) Developer
2 7 (38.89%) Data Warehouse Developer
3 6 (33.33%) Business Intelligence Developer
4 5 (27.78%) ETL Developer
5 3 (16.67%) Analyst
5 3 (16.67%) Redshift Developer
6 2 (11.11%) Analyst Developer
6 2 (11.11%) Business Intelligence Analyst
6 2 (11.11%) SSIS Developer
6 2 (11.11%) Teradata Analyst
6 2 (11.11%) Teradata Developer
7 1 (5.56%) Architect
7 1 (5.56%) Business Intelligence Architect
7 1 (5.56%) Oracle Developer
7 1 (5.56%) SSAS Developer
7 1 (5.56%) SSRS Developer
7 1 (5.56%) Test Analyst
Miscellaneous
1 5 (27.78%) Analytical Skills
2 1 (5.56%) Data Protection Act
Operating Systems
1 5 (27.78%) Unix
Processes & Methodologies
1 14 (77.78%) Business Intelligence
2 13 (72.22%) Kimball Methodology
3 12 (66.67%) Data Modelling
4 9 (50.00%) Data Analysis
5 8 (44.44%) SDLC
6 6 (33.33%) ETL
6 6 (33.33%) Validation
7 5 (27.78%) Stakeholder Management
8 4 (22.22%) Analytics
8 4 (22.22%) DevOps
9 1 (5.56%) Coaching
9 1 (5.56%) Data Governance
9 1 (5.56%) Data Ingestion
9 1 (5.56%) Data Protection
9 1 (5.56%) ETL Development
9 1 (5.56%) Quality Management
9 1 (5.56%) Test Strategy
9 1 (5.56%) Web Development
Programming Languages
1 13 (72.22%) SQL
2 5 (27.78%) PL/SQL
2 5 (27.78%) Shell Script
Qualifications
1 8 (44.44%) Degree
2 7 (38.89%) HNC
2 7 (38.89%) HND
3 1 (5.56%) ISEB
3 1 (5.56%) ISTQB
Quality Assurance & Compliance
1 1 (5.56%) Basel II
1 1 (5.56%) ISO 9000
1 1 (5.56%) QA
1 1 (5.56%) Sarbanes-Oxley
Vendors
1 8 (44.44%) Teradata
2 7 (38.89%) Oracle
3 1 (5.56%) IBM
3 1 (5.56%) Microsoft
3 1 (5.56%) Unisys