The table below looks at the statistics for Dimensional Modelling skills in IT contracts advertised across the UK. Included is a guide to the contractor rates offered in IT contracts that have cited Dimensional Modelling over the 3 months to 27 February 2017 with a comparison to the same period over the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

3 months to
27 Feb 2017
Same period 2016 Same period 2015
Dimensional Modelling
UK
Rank 524 558 517
Rank change year-on-year
+34 -41
Contract jobs citing Dimensional Modelling 77 78 106
As % of all contract IT jobs located in the UK 0.17% 0.15% 0.20%
As % of the Processes & Methodologies category 0.20% 0.18% 0.25%
Number of daily rates quoted 50 53 65
Median daily rate £468 £425 £425
Median daily rate % change year-on-year
+10.00% -
90% offered a daily rate of more than £368 £330 £331
10% offered a daily rate of more than £525 £550 £600
UK excluding London median daily rate £425 £438 £395
% change year-on-year
-2.85% +10.75%
Number of hourly rates quoted 1 0 4
Median hourly rate £30.00 - £67.00
UK excluding London median hourly rate - - £67.00

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in contract jobs advertised across the UK.

Processes & Methodologies Category
UK
Contract IT job ads with a match in the
Processes & Methodologies category
37677 42341 41624
As % of all contract IT jobs located in the UK 82.81% 82.72% 79.46%
Number of daily rates quoted 25060 27689 26256
Median daily rate £450 £425 £420
Median daily rate % change year-on-year
+5.88% +1.19%
90% offered a daily rate of more than £300 £298 £280
10% offered a daily rate of more than £600 £600 £575
UK excluding London median daily rate £408 £400 £399
% change year-on-year
+1.87% +0.29%
Number of hourly rates quoted 944 1155 1112
Median hourly rate £35.00 £39.00 £27.50
Median hourly rate % change year-on-year
-10.25% +41.81%
90% offered a hourly rate of more than £13.00 £13.00 £12.00
10% offered a hourly rate of more than £55.00 £55.00 £49.50
UK excluding London median hourly rate £36.00 £40.00 £29.00
% change year-on-year
-10.00% +37.93%

Dimensional Modelling
Jobs Demand Trend

The demand trend of contract jobs citing Dimensional Modelling as a proportion of all IT contracts with a match in the Processes & Methodologies category.

Dimensional Modelling Jobs Demand Trend in the UK

Dimensional Modelling
Daily Rate Trend

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

Dimensional Modelling Daily Rate Trend in the UK

Dimensional Modelling
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Dimensional Modelling within the UK over the 3 months to 27 February 2017.

Dimensional Modelling Daily Rate Histogram in the UK

Dimensional Modelling
Hourly Rate Trend

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

Dimensional Modelling Hourly Rate Trend in the UK

Dimensional Modelling
Top 30 Contract Locations

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 UK over the 3 months to 27 February 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
England +5 70 £450 +5.88% 26
London +18 37 £475 +18.75% 13
City of London +7 9 £525 +15.06% 5
South East +11 7 £475 +5.55% 4
West Midlands +9 7 £375 - 2
South West 0 7 £375 -21.05%
North West +24 6 £375 - 2
Wales - 6 £500 -
South Wales - 6 £500 -
Cardiff - 6 £500 -
Gloucestershire +4 5 £300 -36.84%
Berkshire +10 4 £435 -0.57%
Merseyside - 4 £375 -
Hampshire +5 3 £481 -12.50% 4
Gloucester +1 3 £388 -17.55%
East Midlands -3 3 £300 -29.41% 3
Liverpool - 3 £375 -
Birmingham 0 2 £375 - 1
Andover -3 2 £475 -17.39% 1
Nottingham - 2 £300 - 1
Nottinghamshire - 2 £300 - 1
Cheshire +28 1 £375 - 1
Reading +16 1 £475 -
Slough +6 1 £435 -0.57%
Croydon +5 1 £438 +12.90%
Bristol +2 1 - -
Newbury -1 1 - -
Warwickshire -2 1 £425 -2.85%
Wiltshire - 1 £400 -
Derbyshire - 1 £475 - 1

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 27 February 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 with a requirement for Dimensional Modelling.

1 148 (86.55%) Data Warehouse
2 114 (66.67%) SQL
3 110 (64.33%) Business Intelligence
4 97 (56.73%) ETL
5 92 (53.80%) Data Modelling
6 85 (49.71%) Oracle
7 78 (45.61%) SQL Server
8 52 (30.41%) SQL Server Integration Services
9 49 (28.65%) Finance
10 46 (26.90%) Agile Software Development
11 45 (26.32%) Kimball Methodology
12 42 (24.56%) SQL Server Reporting Services
12 42 (24.56%) SQL Server Analysis Services
13 41 (23.98%) Data Quality
14 40 (23.39%) Data Management
15 38 (22.22%) BusinessObjects
16 37 (21.64%) Teradata
17 35 (20.47%) Microsoft
18 34 (19.88%) Netezza
18 34 (19.88%) Degree
19 29 (16.96%) Relational Database
20 28 (16.37%) Analytics
20 28 (16.37%) T-SQL
20 28 (16.37%) QlikView
21 26 (15.20%) PL/SQL
22 25 (14.62%) Informatica
23 24 (14.04%) Data Architecture
23 24 (14.04%) SDLC
24 23 (13.45%) Banking
25 22 (12.87%) Migration

Dimensional Modelling
Top Related IT Skills 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 14 (8.19%) SharePoint
2 12 (7.02%) SAS
3 3 (1.75%) Apache Spark
4 1 (0.58%) Apache
4 1 (0.58%) Oracle SOA Suite
Applications
1 15 (8.77%) MS Excel
2 8 (4.68%) MS Visio
3 2 (1.17%) MS Office
Business Applications
1 7 (4.09%) Dynamics CRM
2 5 (2.92%) Dynamics AX
2 5 (2.92%) Dynamics NAV
3 1 (0.58%) Oracle EBS
3 1 (0.58%) Oracle Retail
3 1 (0.58%) SAP Oil and Gas
Cloud Services
1 3 (1.75%) Amazon AWS
1 3 (1.75%) Microsoft Azure
2 2 (1.17%) Cloud Computing
3 1 (0.58%) GitHub
3 1 (0.58%) Google Cloud Platform
Communications & Networking
1 1 (0.58%) 2G
1 1 (0.58%) 3G
1 1 (0.58%) DHCP
1 1 (0.58%) DNS
1 1 (0.58%) LTE
1 1 (0.58%) Network Security
1 1 (0.58%) Radio Access Network
1 1 (0.58%) SNMP
1 1 (0.58%) Telnet
Database & Business Intelligence
1 148 (86.55%) Data Warehouse
2 78 (45.61%) SQL Server
3 52 (30.41%) SQL Server Integration Services
4 42 (24.56%) SQL Server Analysis Services
4 42 (24.56%) SQL Server Reporting Services
5 38 (22.22%) BusinessObjects
6 29 (16.96%) Relational Database
7 28 (16.37%) QlikView
8 20 (11.70%) OLAP
9 18 (10.53%) NoSQL
10 17 (9.94%) DB2
11 16 (9.36%) OLAP Cube
12 15 (8.77%) SQL Server 2012
13 14 (8.19%) Big Data
13 14 (8.19%) Hadoop
14 13 (7.60%) Oracle BI EE
15 11 (6.43%) BusinessObjects XI
15 11 (6.43%) Oracle Database
15 11 (6.43%) Power BI
16 10 (5.85%) SQL Server 2014
Development Applications
1 13 (7.60%) ERwin
2 7 (4.09%) Oracle APEX
3 6 (3.51%) Team Foundation Server
4 3 (1.75%) Git (software)
4 3 (1.75%) Subversion
4 3 (1.75%) VSS/SourceSafe
5 2 (1.17%) Jenkins
5 2 (1.17%) Talend Open Studio
5 2 (1.17%) Toad
5 2 (1.17%) Visual Studio
6 1 (0.58%) JIRA
6 1 (0.58%) MSBuild
6 1 (0.58%) SQL Server Management Studio (SSMS)
General
1 49 (28.65%) Finance
2 23 (13.45%) Banking
3 8 (4.68%) Front Office
3 8 (4.68%) Retail
4 5 (2.92%) Legal
5 4 (2.34%) Telecoms
6 3 (1.75%) Investment Banking
6 3 (1.75%) Marketing
7 2 (1.17%) Electronics
8 1 (0.58%) Manufacturing
8 1 (0.58%) Pharmaceutical
Job Titles
1 78 (45.61%) Developer
2 40 (23.39%) Analyst
3 34 (19.88%) Architect
4 29 (16.96%) Data Architect
5 25 (14.62%) Business Intelligence Developer
5 25 (14.62%) Data Analyst
5 25 (14.62%) SQL Developer
6 24 (14.04%) ETL Developer
7 19 (11.11%) Data Warehouse Developer
8 17 (9.94%) Oracle Developer
9 14 (8.19%) SQL Analyst
10 13 (7.60%) Business Intelligence Analyst
11 12 (7.02%) Consultant
11 12 (7.02%) Oracle ETL Developer
12 11 (6.43%) Business Developer
13 10 (5.85%) Designer
13 10 (5.85%) Oracle Analyst
13 10 (5.85%) SQL Data Analyst
13 10 (5.85%) SSIS Developer
14 9 (5.26%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 8 (4.68%) .NET
1 8 (4.68%) Kafka
2 5 (2.92%) MDX
3 4 (2.34%) XML
4 3 (1.75%) ASP.NET
4 3 (1.75%) REST
5 1 (0.58%) Web Services
Miscellaneous
1 20 (11.70%) Data Structures
1 20 (11.70%) Management Information System
2 17 (9.94%) Analytical Skills
3 8 (4.68%) Computer Science
4 5 (2.92%) Replication
5 3 (1.75%) Data Protection Act
5 3 (1.75%) Linux Command Line
6 2 (1.17%) Data Centre
6 2 (1.17%) NHS
7 1 (0.58%) Digital Media
7 1 (0.58%) Freedom of Information
7 1 (0.58%) Freedom of Information Act
7 1 (0.58%) iSeries
7 1 (0.58%) Reference Data
7 1 (0.58%) Virtual Team
Operating Systems
1 16 (9.36%) Unix
2 7 (4.09%) Linux
3 1 (0.58%) AIX
3 1 (0.58%) Windows
Processes & Methodologies
1 110 (64.33%) Business Intelligence
2 97 (56.73%) ETL
3 92 (53.80%) Data Modelling
4 46 (26.90%) Agile Software Development
5 45 (26.32%) Kimball Methodology
6 40 (23.39%) Data Management
7 28 (16.37%) Analytics
8 24 (14.04%) Data Architecture
8 24 (14.04%) SDLC
9 22 (12.87%) Migration
10 21 (12.28%) Performance Tuning
11 19 (11.11%) Data Analysis
12 17 (9.94%) Data Migration
12 17 (9.94%) Data Transformation
13 16 (9.36%) CRM
14 15 (8.77%) Data Integration
15 14 (8.19%) Data Governance
15 14 (8.19%) Unit Testing
16 13 (7.60%) Predictive Modelling
16 13 (7.60%) Stakeholder Management
Programming Languages
1 114 (66.67%) SQL
2 28 (16.37%) T-SQL
3 26 (15.20%) PL/SQL
4 17 (9.94%) C++
5 15 (8.77%) R
6 14 (8.19%) Python
7 11 (6.43%) Shell Script
8 7 (4.09%) C#
9 6 (3.51%) Java
10 5 (2.92%) VB
10 5 (2.92%) VB.NET
11 2 (1.17%) Tcl
12 1 (0.58%) JavaScript
12 1 (0.58%) Perl
12 1 (0.58%) PHP
12 1 (0.58%) VBA
Qualifications
1 34 (19.88%) Degree
2 4 (2.34%) ISEB
2 4 (2.34%) ISTQB
3 3 (1.75%) HNC
3 3 (1.75%) HND
3 3 (1.75%) SC Cleared
3 3 (1.75%) Security Cleared
4 2 (1.17%) MCDBA
4 2 (1.17%) MCITP
4 2 (1.17%) MCPD
4 2 (1.17%) MCSA
4 2 (1.17%) MCSD
4 2 (1.17%) MCSE
4 2 (1.17%) Microsoft Certification
5 1 (0.58%) Postgraduate
Quality Assurance & Compliance
1 41 (23.98%) Data Quality
2 6 (3.51%) QA
3 4 (2.34%) ISO 9000
3 4 (2.34%) Solvency II
4 2 (1.17%) Basel II
4 2 (1.17%) Sarbanes-Oxley
5 1 (0.58%) GDPR
5 1 (0.58%) ISO/IEC 27001
5 1 (0.58%) PCI DSS
Systems Management
1 1 (0.58%) Oracle Flashback
Vendors
1 85 (49.71%) Oracle
2 37 (21.64%) Teradata
3 35 (20.47%) Microsoft
4 34 (19.88%) Netezza
5 25 (14.62%) Informatica
6 20 (11.70%) Sybase
7 19 (11.11%) Tableau
8 13 (7.60%) SAP
9 8 (4.68%) Cognos
9 8 (4.68%) MicroStrategy
10 7 (4.09%) Ab Initio
11 5 (2.92%) IBM
11 5 (2.92%) Siebel
12 2 (1.17%) Lavastorm
12 2 (1.17%) Talend
13 1 (0.58%) Alteryx
13 1 (0.58%) Greenplum
13 1 (0.58%) Nokia Networks
13 1 (0.58%) Samsung
13 1 (0.58%) Vertica
Cumbria
Vivid Resourcing
Posted: 21 hours ago
Basingstoke, Hampshire
LA International
Rate: £403 per day
Posted: 3 days ago
Basingstoke, Hampshire
LA International
Posted: 5 days ago
City, London
Mane Contract Services Limited
Rate: £350 - £430 per day
Posted: 4 days ago
Basingstoke, Hampshire
Lorien Resourcing
Posted: 5 days ago
City, London
Harvey Nash plc
Rate: £400 - £500 per day
Posted: 6 days ago
Andover
People Source Consulting
Rate: £450 - £500 per day
Posted: 13 days ago