The first table below looks at the demand for Dimensional Modelling skills in IT contracts advertised for the Edinburgh region. Included is a guide to the average contractor rates offered in IT contracts that have cited Dimensional Modelling over the 3 months to 23 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 Edinburgh 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
23 May 2013
Same period 2012 Same period 2011
Dimensional Modeling
Rank 51 64 70
Rank change year-on-year
+13 +6
Contract jobs citing Dimensional Modelling 5 1 4
As % of all contract IT jobs located in Edinburgh 0.609% 0.092% 0.303%
As % of the Processes & Methodologies category 0.894% 0.138% 0.458%
Number of daily rates quoted 2 0 1
Average daily rate £525 - £325
UK excluding London average daily rate £375 £358 £394
% change year-on-year
+4.89% -9.20%
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
Edinburgh
Contract IT job ads with a match in the
Processes & Methodologies category
559 727 873
As % of all contract IT jobs located in Edinburgh 68.09% 66.88% 66.19%
Number of daily rates quoted 258 362 475
Average daily rate £413 £375 £375
Average daily rate % change year-on-year
+10.00% -
90% offered a daily rate of more than £270 £249 £225
10% offered a daily rate of more than £540 £475 £525
UK excluding London average daily rate £365 £365 £375
% change year-on-year
- -2.66%
Number of hourly rates quoted 8 18 8
Average hourly rate £20.00 £27.50 £17.50
Average hourly rate % change year-on-year
-27.27% +57.14%
90% offered a hourly rate of more than £11.00 £13.26 £14.50
10% offered a hourly rate of more than £25.45 £38.00 £43.75
UK excluding London average hourly rate £30.45 £25.00 £29.00
% change year-on-year
+21.78% -13.79%
Dimensional Modelling
Scotland

Dimensional Modelling
Jobs Demand Trend

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

Edinburgh 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 Edinburgh region.

Edinburgh Dimensional Modelling Daily Rate Trend

Dimensional Modelling
Top 30 Related IT Skills

For the 6 months to 23 May 2013, IT contractor jobs across the Edinburgh 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 8 (88.89%) Data Warehouse
1 8 (88.89%) Business Intelligence
2 5 (55.56%) Asset Management
3 4 (44.44%) BusinessObjects Web Intelligence
3 4 (44.44%) Microsoft
3 4 (44.44%) BusinessObjects
3 4 (44.44%) PL/SQL
3 4 (44.44%) SQL
3 4 (44.44%) Oracle
3 4 (44.44%) Business Objects
3 4 (44.44%) SAP
3 4 (44.44%) SAP Data Services
3 4 (44.44%) Kimball Methodology
4 3 (33.33%) Banking
4 3 (33.33%) OLAP
4 3 (33.33%) ETL
4 3 (33.33%) Investment Banking
4 3 (33.33%) SQL Server Integration Services
4 3 (33.33%) Finance
4 3 (33.33%) Ab Initio
5 2 (22.22%) Salesforce.com
5 2 (22.22%) SQL Server
5 2 (22.22%) Investment Management
6 1 (11.11%) Data Architecture
6 1 (11.11%) PowerPivot
6 1 (11.11%) SQL Server 2012
6 1 (11.11%) MTS
6 1 (11.11%) MS Excel
6 1 (11.11%) CRM
6 1 (11.11%) SharePoint

Dimensional Modelling
Top Related IT Skills by Category

For the 6 months to 23 May 2013, IT contractor jobs across the Edinburgh 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 Platforms
1 1 (11.11%) MTS
1 1 (11.11%) SharePoint
Applications
1 1 (11.11%) PowerPivot
1 1 (11.11%) MS Excel
Database & Business Intelligence
1 8 (88.89%) Data Warehouse
2 4 (44.44%) BusinessObjects Web Intelligence
2 4 (44.44%) BusinessObjects
2 4 (44.44%) SAP Data Services
3 3 (33.33%) OLAP
3 3 (33.33%) SQL Server Integration Services
4 2 (22.22%) SQL Server
5 1 (11.11%) SQL Server 2012
5 1 (11.11%) SQL Server Reporting Services
5 1 (11.11%) SQL Server Analysis Services
General
1 3 (33.33%) Banking
1 3 (33.33%) Investment Banking
1 3 (33.33%) Finance
Job Titles
1 4 (44.44%) Designer
2 2 (22.22%) Business Consultant
2 2 (22.22%) Consultant
2 2 (22.22%) Lead Designer
2 2 (22.22%) Business Intelligence Consultant
3 1 (11.11%) Architect
3 1 (11.11%) Solutions Architect
3 1 (11.11%) Business Intelligence Specialist
3 1 (11.11%) Data Architect
3 1 (11.11%) Data Warehouse Architect
Processes & Methodologies
1 8 (88.89%) Business Intelligence
2 5 (55.56%) Asset Management
3 4 (44.44%) Kimball Methodology
4 3 (33.33%) ETL
5 2 (22.22%) Investment Management
6 1 (11.11%) Data Architecture
6 1 (11.11%) CRM
6 1 (11.11%) Data Modelling
6 1 (11.11%) Content Management
Programming Languages
1 4 (44.44%) PL/SQL
1 4 (44.44%) SQL
Vendors
1 4 (44.44%) Microsoft
1 4 (44.44%) Oracle
1 4 (44.44%) Business Objects
1 4 (44.44%) SAP
2 3 (33.33%) Ab Initio
3 2 (22.22%) Salesforce.com
4 1 (11.11%) IBM