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 26 August 2016 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
26 Aug 2016
Same period 2015 Same period 2014
Dimensional Modelling
Rank 537 500 490
Rank change year-on-year
-37 -10
Contract jobs citing Dimensional Modelling 116 158 145
As % of all contract IT jobs located in the UK 0.21% 0.27% 0.26%
As % of the Processes & Methodologies category 0.26% 0.34% 0.33%
Number of daily rates quoted 62 102 73
Median daily rate £425 £440 £400
Median daily rate % change year-on-year
-3.40% +10.00%
90% offered a daily rate of more than £330 £325 £300
10% offered a daily rate of more than £545 £500 £525
UK excluding London median daily rate £423 £413 £363
% change year-on-year
+2.42% +13.79%
Number of hourly rates quoted 1 0 3
Median hourly rate £20.50 - £67.00
UK excluding London median hourly rate £20.50 - £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
44771 46893 44277
As % of all contract IT jobs located in the UK 82.75% 80.29% 78.48%
Number of daily rates quoted 29557 30468 27430
Median daily rate £438 £425 £405
Median daily rate % change year-on-year
+2.94% +4.93%
90% offered a daily rate of more than £300 £288 £275
10% offered a daily rate of more than £590 £575 £575
UK excluding London median daily rate £400 £400 £375
% change year-on-year
- +6.66%
Number of hourly rates quoted 1110 1273 1193
Median hourly rate £28.50 £31.44 £23.50
Median hourly rate % change year-on-year
-9.35% +33.78%
90% offered a hourly rate of more than £12.50 £12.50 £12.50
10% offered a hourly rate of more than £52.00 £52.13 £50.00
UK excluding London median hourly rate £30.00 £33.00 £25.75
% change year-on-year
-9.09% +28.15%

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 26 August 2016.

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 26 August 2016. 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
(Click see detailed
statistics and trends)
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 -30 102 £420 -5.61% 16
London -27 40 £425 -6.33% 6
West Yorkshire +30 23 £420 -
Yorkshire +21 23 £420 -
Bradford - 23 £420 -
North West +6 13 £550 +23.59% 2
Cheshire +21 12 £550 +49.15%
Scotland +21 12 £500 +28.20%
Edinburgh +10 11 £500 +25.00%
City of London +9 9 £428 -5.78% 3
East of England +15 8 £375 -1.31%
Hertfordshire +10 6 £375 +20.96%
South East +5 6 £419 +19.64% 5
Chester -1 6 £600 +62.71%
West Midlands -26 5 £325 -13.33% 3
Bristol -1 4 - -
South West -13 4 - -
Buckinghamshire +8 3 £425 +7.59%
Milton Keynes +7 3 £425 +7.59%
Suffolk +2 2 £375 -16.66%
Welwyn Garden City -1 2 £288 -7.25%
Ipswich -1 2 £375 -16.66%
Birmingham -13 2 £325 +6.12%
East Midlands - 2 £225 -
Staines - 2 - -
Nottinghamshire - 2 £225 -
Surrey - 2 - -
Nottingham - 2 £225 -
Preston +4 1 - -
Lancashire 0 1 - -

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 26 August 2016, 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 167 (70.46%) Business Intelligence
2 166 (70.04%) ETL
3 152 (64.14%) Data Warehouse
4 146 (61.60%) SQL
5 103 (43.46%) Data Modelling
6 96 (40.51%) Oracle
7 93 (39.24%) SQL Server
8 79 (33.33%) Kimball Methodology
9 74 (31.22%) SQL Server Analysis Services
10 68 (28.69%) Microsoft
11 62 (26.16%) OLAP
12 61 (25.74%) Agile Software Development
13 55 (23.21%) OLAP Cube
14 51 (21.52%) SQL Server Integration Services
15 50 (21.10%) SQL Server Reporting Services
16 47 (19.83%) Analytics
17 44 (18.57%) Finance
18 42 (17.72%) T-SQL
18 42 (17.72%) Oracle Database
19 41 (17.30%) Informatica
20 37 (15.61%) PL/SQL
21 36 (15.19%) Netezza
22 35 (14.77%) Continuous Integration
23 34 (14.35%) ERwin
23 34 (14.35%) Oracle Database 11g
23 34 (14.35%) Relational Database
24 33 (13.92%) Jenkins
24 33 (13.92%) Big Data
25 32 (13.50%) Data Quality
25 32 (13.50%) SDLC

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 17 (7.17%) SharePoint
2 10 (4.22%) SAS
3 2 (0.84%) SharePoint 2010
Applications
1 26 (10.97%) MS Excel
2 4 (1.69%) MS Office
2 4 (1.69%) MS PowerPoint
3 3 (1.27%) SPSS
Business Applications
1 3 (1.27%) Dynamics CRM
1 3 (1.27%) Dynamics NAV
2 2 (0.84%) Maximo
3 1 (0.42%) Dynamics AX
3 1 (0.42%) Hyperion Planning
3 1 (0.42%) Oracle EBS
3 1 (0.42%) Oracle ERP
3 1 (0.42%) Oracle General Ledger
Cloud Services
1 6 (2.53%) Microsoft Azure
1 6 (2.53%) SaaS
2 4 (1.69%) GitHub
3 2 (0.84%) Amazon AWS
3 2 (0.84%) Google Cloud Platform
4 1 (0.42%) Cloud Computing
Communications & Networking
1 7 (2.95%) Network Security
2 2 (0.84%) DNS
2 2 (0.84%) HTTP
Database & Business Intelligence
1 152 (64.14%) Data Warehouse
2 93 (39.24%) SQL Server
3 74 (31.22%) SQL Server Analysis Services
4 62 (26.16%) OLAP
5 55 (23.21%) OLAP Cube
6 51 (21.52%) SQL Server Integration Services
7 50 (21.10%) SQL Server Reporting Services
8 42 (17.72%) Oracle Database
9 34 (14.35%) Oracle Database 11g
9 34 (14.35%) Relational Database
10 33 (13.92%) Big Data
11 30 (12.66%) SQL Server 2008
12 29 (12.24%) Oracle ODI
13 20 (8.44%) BusinessObjects
13 20 (8.44%) Microsoft Analysis Services
13 20 (8.44%) Power BI
14 17 (7.17%) SQL Server 2012
15 14 (5.91%) DB2
15 14 (5.91%) NoSQL
16 13 (5.49%) SQL Server 2014
Development Applications
1 34 (14.35%) ERwin
2 33 (13.92%) Jenkins
3 24 (10.13%) Talend Open Studio
4 6 (2.53%) SQL Server Management Studio (SSMS)
4 6 (2.53%) Team Foundation Server
5 2 (0.84%) Ant
5 2 (0.84%) JIRA
5 2 (0.84%) Maven
5 2 (0.84%) Moq
5 2 (0.84%) NuGet
5 2 (0.84%) Visual Studio
5 2 (0.84%) VSS/SourceSafe
6 1 (0.42%) Subversion
General
1 44 (18.57%) Finance
2 15 (6.33%) Banking
3 8 (3.38%) Retail
4 7 (2.95%) Investment Banking
5 6 (2.53%) Pharmaceutical
6 4 (1.69%) Advertising
6 4 (1.69%) Law
7 2 (0.84%) Front Office
7 2 (0.84%) Manufacturing
7 2 (0.84%) Marketing
7 2 (0.84%) Publishing
8 1 (0.42%) Games
8 1 (0.42%) General Ledger
8 1 (0.42%) Legal
8 1 (0.42%) Local Government
8 1 (0.42%) Telecoms
Job Titles
1 118 (49.79%) Developer
2 45 (18.99%) Business Intelligence Developer
3 35 (14.77%) Analyst
4 34 (14.35%) Tester
5 32 (13.50%) Architect
6 31 (13.08%) SQL Developer
7 28 (11.81%) Data Warehouse Developer
8 27 (11.39%) Data Architect
9 26 (10.97%) ETL Developer
10 24 (10.13%) ETL Tester
10 24 (10.13%) Oracle Developer
11 18 (7.59%) Data Analyst
11 18 (7.59%) SQL BI Developer
12 17 (7.17%) Data Warehouse Architect
13 16 (6.75%) Designer
13 16 (6.75%) Oracle ETL Developer
14 15 (6.33%) ETL Designer
15 14 (5.91%) SSAS Developer
16 13 (5.49%) Consultant
16 13 (5.49%) Talend Developer
Libraries, Frameworks & Software Standards
1 16 (6.75%) MDX
2 7 (2.95%) .NET
3 6 (2.53%) Web Services
4 2 (0.84%) .NET Framework
4 2 (0.84%) Ajax
4 2 (0.84%) ASP.NET
4 2 (0.84%) Backbone.js
4 2 (0.84%) CSS
4 2 (0.84%) Entity Framework
4 2 (0.84%) Ext JS
4 2 (0.84%) HTML
4 2 (0.84%) HTML5
4 2 (0.84%) KnockoutJS
4 2 (0.84%) Modernizr
4 2 (0.84%) NHibernate
4 2 (0.84%) RESTful
4 2 (0.84%) Spring.NET
4 2 (0.84%) StructureMap
4 2 (0.84%) WCF
4 2 (0.84%) WinForms
Miscellaneous
1 23 (9.70%) Analytical Skills
2 13 (5.49%) Data Structures
2 13 (5.49%) Visualisation
3 10 (4.22%) Data Extraction
4 8 (3.38%) Data Integration
5 7 (2.95%) Digital Media
6 6 (2.53%) Credit Risk
6 6 (2.53%) Management Information System
7 3 (1.27%) Statistics
8 2 (0.84%) Enterprise Software
8 2 (0.84%) Minimum Viable Product
8 2 (0.84%) Mobile App
8 2 (0.84%) User Experience
9 1 (0.42%) Algorithms
9 1 (0.42%) Data Conversion
9 1 (0.42%) FMCG
9 1 (0.42%) Mathematics
9 1 (0.42%) Replication
9 1 (0.42%) Virtual Team
Operating Systems
1 31 (13.08%) Linux
2 3 (1.27%) Unix
2 3 (1.27%) Windows
Processes & Methodologies
1 167 (70.46%) Business Intelligence
2 166 (70.04%) ETL
3 103 (43.46%) Data Modelling
4 79 (33.33%) Kimball Methodology
5 61 (25.74%) Agile Software Development
6 47 (19.83%) Analytics
7 35 (14.77%) Continuous Integration
8 32 (13.50%) SDLC
9 28 (11.81%) E-Commerce
10 23 (9.70%) RAD
11 22 (9.28%) Data Management
12 21 (8.86%) Data Architecture
12 21 (8.86%) Migration
13 17 (7.17%) Data Transformation
13 17 (7.17%) Software Testing
14 15 (6.33%) Data Mapping
15 14 (5.91%) Data Analysis
15 14 (5.91%) Performance Tuning
15 14 (5.91%) Predictive Modelling
16 12 (5.06%) Unit Testing
Programming Languages
1 146 (61.60%) SQL
2 42 (17.72%) T-SQL
3 37 (15.61%) PL/SQL
4 29 (12.24%) Java
5 15 (6.33%) Python
6 14 (5.91%) C++
6 14 (5.91%) R
7 9 (3.80%) JavaScript
8 7 (2.95%) PHP
9 6 (2.53%) VB
10 5 (2.11%) Data Analysis Expressions (DAX)
11 4 (1.69%) VBA
12 3 (1.27%) C#
12 3 (1.27%) VB.NET
13 2 (0.84%) TypeScript
14 1 (0.42%) C
14 1 (0.42%) PowerShell
14 1 (0.42%) SAS Macro
14 1 (0.42%) Shell Script
Qualifications
1 14 (5.91%) Degree
1 14 (5.91%) ISEB
2 4 (1.69%) BPSS Clearance
2 4 (1.69%) SAS Certification
2 4 (1.69%) Security Cleared
3 1 (0.42%) BC Cleared
3 1 (0.42%) ISTQB
3 1 (0.42%) MCSE
3 1 (0.42%) Microsoft Certification
Quality Assurance & Compliance
1 32 (13.50%) Data Quality
2 7 (2.95%) QA
3 4 (1.69%) Disclosure Scotland
4 3 (1.27%) Solvency II
5 2 (0.84%) GCP
Vendors
1 96 (40.51%) Oracle
2 68 (28.69%) Microsoft
3 41 (17.30%) Informatica
4 36 (15.19%) Netezza
5 30 (12.66%) Vertica
6 28 (11.81%) Teradata
7 24 (10.13%) Talend
8 16 (6.75%) Sybase
9 13 (5.49%) Cognos
10 12 (5.06%) SAP
10 12 (5.06%) Tableau
11 3 (1.27%) Alteryx
11 3 (1.27%) CODA
11 3 (1.27%) Concur
11 3 (1.27%) Maconomy
11 3 (1.27%) MicroStrategy
11 3 (1.27%) ServiceNow
12 2 (0.84%) Embarcadero
12 2 (0.84%) Google
13 1 (0.42%) Remedy
UK
Oscar
Rate: £300 - £600 per day
Posted: 17 hours ago
London
Edward Carter Solutions
Rate: Excellent
Posted: 13 days ago