The first table below looks at the demand for Dimensional Modelling skills in IT contracts advertised for the Yorkshire region. Included is a guide to the average contractor rates offered in IT contracts that have cited Dimensional Modelling over the 3 months to 24 May 2013 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Processes & Methodologies category for the Yorkshire region.

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.

Location
3 months to
24 May 2013
Same period 2012 Same period 2011
Dimensional Modeling
Rank 95 111 95
Rank change year-on-year
+16 -16
Contract jobs citing Dimensional Modelling 15 1 3
As % of all contract IT jobs located in Yorkshire 0.807% 0.045% 0.164%
As % of the Processes & Methodologies category 1.174% 0.064% 0.260%
Number of daily rates quoted 10 1 2
Average daily rate £263 £340 £357
Average daily rate % change year-on-year
-22.79% -4.76%
90% offered a daily rate of more than £188 £340 £243
10% offered a daily rate of more than £363 £340 £471
UK excluding London average daily rate £375 £358 £388
% change year-on-year
+4.89% -7.74%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate - £36.50 £35.00
% change year-on-year
- +4.28%
All Processes & Methodologies
Yorkshire
Contract IT job ads with a match in the
Processes & Methodologies category
1278 1574 1154
As % of all contract IT jobs located in Yorkshire 68.78% 70.46% 63.09%
Number of daily rates quoted 712 868 548
Average daily rate £325 £350 £350
Average daily rate % change year-on-year
-7.14% -
90% offered a daily rate of more than £225 £225 £225
10% offered a daily rate of more than £450 £455 £475
UK excluding London average daily rate £365 £365 £375
% change year-on-year
- -2.66%
Number of hourly rates quoted 44 40 60
Average hourly rate £26.00 £16.50 £23.50
Average hourly rate % change year-on-year
+57.57% -29.78%
90% offered a hourly rate of more than £12.00 £12.45 £11.00
10% offered a hourly rate of more than £170.00 £32.50 £60.00
UK excluding London average hourly rate £30.00 £25.00 £29.50
% change year-on-year
+20.00% -15.25%
Dimensional Modelling
England

Dimensional Modelling
Jobs Demand Trend

This chart provides a 3-month moving total of IT contractor jobs citing Dimensional Modelling across the Yorkshire region as a proportion of the total demand within the Processes & Methodologies category.

Yorkshire Dimensional Modelling Jobs Demand Trend

Dimensional Modelling
Daily Rate Trend

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

Yorkshire Dimensional Modelling Daily Rate Trend

Dimensional Modelling
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Dimensional Modelling across the Yorkshire region over the 3 months to 24 May 2013.

Yorkshire Dimensional Modelling Daily Rate Histogram

Dimensional Modelling
Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Dimensional Modelling within the Yorkshire region over the 3 months to 24 May 2013. 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 each for more statistics)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
West Yorkshire +14 12 £238 -30.14%
North Yorkshire - 3 £325 -
Dimensional Modelling
England

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 24 May 2013, IT contractor jobs across the Yorkshire region citing Dimensional Modelling also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Dimensional Modelling.

1 19 (79.17%) SQL
2 16 (66.67%) Data Warehouse
3 13 (54.17%) SQL Server
4 12 (50.00%) Business Intelligence
5 11 (45.83%) Oracle
5 11 (45.83%) SQL Server Integration Services
6 10 (41.67%) OLAP
7 8 (33.33%) Linux
7 8 (33.33%) SQL Server Reporting Services
7 8 (33.33%) SQL Server Analysis Services
7 8 (33.33%) Kimball Methodology
8 7 (29.17%) Oracle OWB
8 7 (29.17%) PL/SQL
8 7 (29.17%) Microsoft
8 7 (29.17%) Finance
9 6 (25.00%) Oracle 10g
9 6 (25.00%) Banking
9 6 (25.00%) Investment Banking
10 5 (20.83%) MDX
10 5 (20.83%) ETL
10 5 (20.83%) Data Modelling
10 5 (20.83%) SharePoint
10 5 (20.83%) Analytics
11 3 (12.50%) MCITP
11 3 (12.50%) Data Integration
11 3 (12.50%) MS Excel
11 3 (12.50%) T-SQL
11 3 (12.50%) Business Intelligence Development Studio
12 2 (8.333%) Data Quality
12 2 (8.333%) PowerPivot

Dimensional Modelling
Top Related IT Skills by Category

For the 6 months to 24 May 2013, IT contractor jobs across the Yorkshire region citing Dimensional Modelling also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited Dimensional Modelling. Up to 20 skills are shown per category.

Application Development
1 5 (20.83%) MDX
2 1 (4.167%) .NET
Application Platforms
1 5 (20.83%) SharePoint
Applications
1 3 (12.50%) MS Excel
2 2 (8.333%) PowerPivot
Database & Business Intelligence
1 16 (66.67%) Data Warehouse
2 13 (54.17%) SQL Server
3 11 (45.83%) SQL Server Integration Services
4 10 (41.67%) OLAP
5 8 (33.33%) SQL Server Reporting Services
5 8 (33.33%) SQL Server Analysis Services
6 7 (29.17%) Oracle OWB
7 6 (25.00%) Oracle 10g
8 3 (12.50%) Business Intelligence Development Studio
9 2 (8.333%) Star Schema
9 2 (8.333%) RDBMS
9 2 (8.333%) SQL Server 2008
9 2 (8.333%) PerformancePoint
9 2 (8.333%) Oracle BI EE
9 2 (8.333%) Oracle 11g
9 2 (8.333%) SQL Server 2005
10 1 (4.167%) ROLAP
10 1 (4.167%) MOLAP
10 1 (4.167%) PowerCenter
10 1 (4.167%) Data Mining
General
1 7 (29.17%) Finance
2 6 (25.00%) Banking
2 6 (25.00%) Investment Banking
3 1 (4.167%) Advertising
Job Titles
1 18 (75.00%) Developer
2 10 (41.67%) Business Intelligence Developer
3 7 (29.17%) Data Warehouse Developer
4 6 (25.00%) Business Developer
4 6 (25.00%) Oracle Developer
5 5 (20.83%) Oracle Data Warehouse Developer
6 4 (16.67%) SQL Developer
7 3 (12.50%) Development Team Leader
7 3 (12.50%) Team Leader
8 2 (8.333%) Designer
8 2 (8.333%) Architect
9 1 (4.167%) Data Warehouse Analyst
9 1 (4.167%) ETL Architect
9 1 (4.167%) Data Warehouse Test Analyst
9 1 (4.167%) OBIEE Architect
9 1 (4.167%) Oracle Architect
9 1 (4.167%) Analyst
9 1 (4.167%) Test Analyst
9 1 (4.167%) Data Architect
9 1 (4.167%) ETL Designer
Miscellaneous
1 3 (12.50%) Data Integration
2 1 (4.167%) Computer Science
Operating Systems
1 8 (33.33%) Linux
Processes & Methodologies
1 12 (50.00%) Business Intelligence
2 8 (33.33%) Kimball Methodology
3 5 (20.83%) ETL
3 5 (20.83%) Data Modelling
3 5 (20.83%) Analytics
4 1 (4.167%) Technical Architecture
4 1 (4.167%) Software Testing
4 1 (4.167%) Data Analysis
4 1 (4.167%) Test Scripting
4 1 (4.167%) Manual Testing
4 1 (4.167%) Migration
4 1 (4.167%) TMap
Programming Languages
1 19 (79.17%) SQL
2 7 (29.17%) PL/SQL
3 3 (12.50%) T-SQL
4 1 (4.167%) VB.NET
4 1 (4.167%) C
4 1 (4.167%) C#
Qualifications
1 3 (12.50%) MCITP
Quality Assurance & Compliance
1 2 (8.333%) Data Quality
1 2 (8.333%) QA
Systems Management
1 1 (4.167%) HP Quality Center
Vendors
1 11 (45.83%) Oracle
2 7 (29.17%) Microsoft
3 1 (4.167%) HP
3 1 (4.167%) Informatica