The first table below looks at the demand for Data Warehouse 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 Data Warehouse over the 3 months to 21 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 Database & Business Intelligence 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
21 May 2013
Same period 2012 Same period 2011
Data Warehousing
Rank 27 35 35
Rank change year-on-year
+8 0
Contract jobs citing Data Warehouse 32 30 39
As % of all contract IT jobs located in Edinburgh 3.907% 2.735% 3.007%
As % of the Database & Business Intelligence category 22.54% 21.58% 22.16%
Number of daily rates quoted 15 14 17
Average daily rate £450 £375 £375
Average daily rate % change year-on-year
+20.00% -
90% offered a daily rate of more than £380 £302 £296
10% offered a daily rate of more than £525 £450 £623
UK excluding London average daily rate £363 £375 £375
% change year-on-year
-3.33% -
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £38.00 £30.00 £35.50
% change year-on-year
+26.66% -15.49%
All Database & Business Intelligence
Edinburgh
Contract IT job ads with a match in the
Database & Business Intelligence category
142 139 176
As % of all contract IT jobs located in Edinburgh 17.34% 12.67% 13.57%
Number of daily rates quoted 62 65 70
Average daily rate £375 £325 £338
Average daily rate % change year-on-year
+15.38% -3.70%
90% offered a daily rate of more than £250 £260 £258
10% offered a daily rate of more than £501 £450 £500
UK excluding London average daily rate £325 £333 £335
% change year-on-year
-2.25% -0.74%
Number of hourly rates quoted 2 1 2
Average hourly rate £70.00 £16.00 £14.50
Average hourly rate % change year-on-year
+337.50% +10.34%
UK excluding London average hourly rate £27.50 £26.50 £32.50
% change year-on-year
+3.77% -18.46%
Data Warehouse
Scotland

Data Warehouse
Jobs Demand Trend

This chart provides a 3-month moving total of IT contractor jobs citing Data Warehouse across the Edinburgh region as a proportion of the total demand within the Database & Business Intelligence category.

Edinburgh Data Warehouse Jobs Demand Trend

Data Warehouse
Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Data Warehouse across the Edinburgh region.

Edinburgh Data Warehouse Daily Rate Trend

Data Warehouse
Daily Rate Histogram

This chart provides a histogram of daily rates quoted in contract IT jobs citing Data Warehouse across the Edinburgh region over the 3 months to 21 May 2013.

Edinburgh Data Warehouse Daily Rate Histogram

Data Warehouse
Hourly Rate Trend

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Data Warehouse across the Edinburgh region.

Edinburgh Data Warehouse Hourly Rate Trend

Data Warehouse
Top 30 Related IT Skills

For the 6 months to 21 May 2013, IT contractor jobs across the Edinburgh region citing Data Warehouse 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 Data Warehouse.

1 37 (56.06%) Finance
2 29 (43.94%) SQL
3 24 (36.36%) ETL
4 22 (33.33%) Business Intelligence
5 21 (31.82%) Data Modelling
6 19 (28.79%) Oracle
6 19 (28.79%) Banking
7 17 (25.76%) SQL Server Reporting Services
8 16 (24.24%) SQL Server Integration Services
8 16 (24.24%) SQL Server
9 15 (22.73%) Asset Management
10 13 (19.70%) Data Analysis
11 12 (18.18%) Business Objects
11 12 (18.18%) SAS
12 11 (16.67%) Microsoft
13 10 (15.15%) PL/SQL
13 10 (15.15%) OLAP
13 10 (15.15%) Migration
13 10 (15.15%) Teradata
14 9 (13.64%) SQL Server Analysis Services
15 8 (12.12%) Dimensional Modelling
15 8 (12.12%) Informatica
15 8 (12.12%) SQL Server 2005
16 7 (10.61%) Retail
16 7 (10.61%) T-SQL
17 6 (9.091%) SAP Data Services
17 6 (9.091%) Investment Banking
17 6 (9.091%) Stakeholder Management
18 5 (7.576%) Retail Banking
18 5 (7.576%) Windows

Data Warehouse
Top Related IT Skills by Category

For the 6 months to 21 May 2013, IT contractor jobs across the Edinburgh region citing Data Warehouse 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 Data Warehouse. Up to 20 skills are shown per category.

Application Development
1 2 (3.030%) JDBC
1 2 (3.030%) Web Services
1 2 (3.030%) MDX
2 1 (1.515%) .NET
2 1 (1.515%) XML
2 1 (1.515%) XSD
2 1 (1.515%) ASP.NET
2 1 (1.515%) ASP.NET MVC 2
Application Platforms
1 12 (18.18%) SAS
2 3 (4.545%) SharePoint
2 3 (4.545%) IIS
3 2 (3.030%) SharePoint 2013
3 2 (3.030%) PowerExchange
Applications
1 1 (1.515%) MS Excel
1 1 (1.515%) PowerPivot
Business Applications
1 1 (1.515%) Dynamics NAV
Communications & Networking
1 1 (1.515%) HTTP
Database & Business Intelligence
1 17 (25.76%) SQL Server Reporting Services
2 16 (24.24%) SQL Server Integration Services
2 16 (24.24%) SQL Server
3 10 (15.15%) OLAP
4 9 (13.64%) SQL Server Analysis Services
5 8 (12.12%) SQL Server 2005
6 6 (9.091%) SAP Data Services
7 5 (7.576%) SQL Server 2008
8 4 (6.061%) SQL Server 2012
8 4 (6.061%) BusinessObjects Web Intelligence
8 4 (6.061%) PowerCenter
8 4 (6.061%) SQL Server 2000
9 3 (4.545%) BODI
9 3 (4.545%) BusinessObjects
9 3 (4.545%) Star Schema
9 3 (4.545%) Data Mining
9 3 (4.545%) DTS
9 3 (4.545%) BusinessObjects XI
9 3 (4.545%) QlikView
9 3 (4.545%) Oracle 11g
Development Applications
1 1 (1.515%) NUnit
1 1 (1.515%) ERwin
1 1 (1.515%) ProC
1 1 (1.515%) Team Foundation Server
1 1 (1.515%) MSTest
General
1 37 (56.06%) Finance
2 19 (28.79%) Banking
3 7 (10.61%) Retail
4 6 (9.091%) Investment Banking
5 5 (7.576%) Retail Banking
6 2 (3.030%) Marketing
7 1 (1.515%) General Ledger
7 1 (1.515%) Financial Institution
Job Titles
1 20 (30.30%) Analyst
2 9 (13.64%) Developer
2 9 (13.64%) Data Analyst
2 9 (13.64%) Architect
3 7 (10.61%) Designer
4 6 (9.091%) DBA
5 5 (7.576%) Solutions Architect
5 5 (7.576%) Consultant
6 4 (6.061%) Systems Analyst
6 4 (6.061%) Business Intelligence Developer
6 4 (6.061%) Data Architect
7 3 (4.545%) SQL DBA
7 3 (4.545%) Business Intelligence Analyst
7 3 (4.545%) Business Developer
7 3 (4.545%) Business Analyst
7 3 (4.545%) MI Manager
8 2 (3.030%) Lead Designer
8 2 (3.030%) Programmer
8 2 (3.030%) MI Analyst
8 2 (3.030%) Systems Architect
Miscellaneous
1 4 (6.061%) Visualisation
1 4 (6.061%) Replication
1 4 (6.061%) Management Information System
2 3 (4.545%) Clustering
3 2 (3.030%) Data Integration
3 2 (3.030%) Data Conversion
3 2 (3.030%) Mathematics
4 1 (1.515%) VSAM
4 1 (1.515%) Statistics
4 1 (1.515%) Credit Risk
Operating Systems
1 5 (7.576%) Windows
2 3 (4.545%) Windows Server 2003
2 3 (4.545%) Windows Server 2008
3 2 (3.030%) Linux
3 2 (3.030%) UNIX
Processes & Methodologies
1 24 (36.36%) ETL
2 22 (33.33%) Business Intelligence
3 21 (31.82%) Data Modelling
4 15 (22.73%) Asset Management
5 13 (19.70%) Data Analysis
6 10 (15.15%) Migration
7 8 (12.12%) Dimensional Modelling
8 6 (9.091%) Stakeholder Management
9 5 (7.576%) UML
9 5 (7.576%) Investment Management
9 5 (7.576%) Kimball Methodology
10 4 (6.061%) Data Mapping
10 4 (6.061%) Data Architecture
11 3 (4.545%) GAP Analysis
11 3 (4.545%) Business Analysis
11 3 (4.545%) Network Load Balancing
11 3 (4.545%) CRM
11 3 (4.545%) Data Migration
12 2 (3.030%) Data Cleansing
12 2 (3.030%) Capacity Management
Programming Languages
1 29 (43.94%) SQL
2 10 (15.15%) PL/SQL
3 7 (10.61%) T-SQL
4 2 (3.030%) VBA
4 2 (3.030%) Shell Script
5 1 (1.515%) C
5 1 (1.515%) C#
Qualifications
1 2 (3.030%) Degree
2 1 (1.515%) ISTQB
2 1 (1.515%) ISEB
Quality Assurance & Compliance
1 4 (6.061%) QA
2 1 (1.515%) Solvency II
Systems Management
1 1 (1.515%) Oracle Enterprise Manager
Vendors
1 19 (28.79%) Oracle
2 12 (18.18%) Business Objects
3 11 (16.67%) Microsoft
4 10 (15.15%) Teradata
5 8 (12.12%) Informatica
6 4 (6.061%) Ab Initio
7 3 (4.545%) Salesforce.com
7 3 (4.545%) SAP
8 2 (3.030%) Trillium
8 2 (3.030%) IBM
8 2 (3.030%) CheckPoint
8 2 (3.030%) DataFlux
9 1 (1.515%) Cadis
9 1 (1.515%) TSYS
Edinburgh, Midlothian
We have an immediate requirement for an experienced Datawarehouse Test Analyst with background testing ETL / MI Reporting solutions, ideally within the Financial Services Sector. Successful candidates will have...
Search Consultancy
Posted: 20 May 2013
Edinburgh, Midlothian
Search Consultancy is looking for an experienced Data Analyst who has the technical abilities to work with data models and database design development. Be able to understand XML...
Search Consultancy
Rate: Market rate
Posted: 20 May 2013
Edinburgh, Midlothian
Analysis, Documentation, Specifications, Functional, Data Analysis, Data Warehouse, MI My banking client in Edinburgh are actively recruiting for a number of business analysts for a major transformation programme...
Aston Carter
Rate: £325 - £375 per day
Posted: 15 May 2013