Scotland Datawarehouse Contracts

The table below looks at the demand for Data Warehouse (Data Warehousing) skills within the Scotland region with a comparison to our Database & Business Intelligence category. Included is a guide to the contractor rates offered in IT jobs that have cited Datawarehouse over the 3 months to 2 December 2008 with a comparison to the same period last year.

Data Warehouse (Data Warehousing)
Location Altrincham Andover Ayr Barrow-in-Furness Basingstoke Bath Bedfordshire Berkshire Birmingham Blackburn Blackpool Bracknell Bradford Bristol Buckinghamshire Burton-upon-Trent Cambridge Cambridgeshire Canary Wharf Cardiff Channel Islands Chelmsford Cheshire Chester Chesterfield Chorley City of London Coventry Crawley Crewe Cumbria Derby Derbyshire Docklands, London Dorset Dover East Anglia East Midlands East of England East Sussex East Yorkshire Edinburgh Enfield England Essex Feltham Gatwick Glasgow Gloucestershire Grampian Guernsey Gwent Hampshire Harlow Hertfordshire Home Counties Hull Ipswich Isleworth Johnstone Kent Lancashire Leeds Leek Lincolnshire Liverpool London Luton Macclesfield Maidenhead Manchester Merseyside Middlesex Midlands Milton Keynes Newbury Newcastle Norfolk North East North West Northampton Northamptonshire Norwich Nottingham Nottinghamshire Oxfordshire Paddington Peterborough Poole Portsmouth Reading Renfrewshire Rickmansworth Salford Salisbury Scotland Slough Somerset South Ayrshire South East South Wales South West South Yorkshire Southampton St Albans Stafford Staffordshire Staines Stirling Stoke-on-Trent Suffolk Sunbury-on-Thames Surrey Sussex Swindon Thames Valley Trowbridge Twickenham Tyne and Wear UK Wales Warrington Warwick Warwickshire Welwyn Garden City West Midlands West Sussex West Yorkshire Westminster Weybridge Wiltshire Windsor Wokingham Worcester Worcestershire Yorkshire	3 months to 2 Dec 2008	Same period last year
Rank	43	54
Rank change on same period last year	+11
Matching contract IT job ads	56	76
As % of all UK contract IT job ads sampled	0.090 %	0.082 %
As % of the category below	12.79 %	9.157 %
Daily rates quoted	16	32
Average minimum daily rate	£318	£330
Average daily rate	£324	£341
% change on same period last year	-5.12 %
Average maximum daily rate	£329	£352
UK excluding London average daily rate	£375	£368
% change on same period last year	+1.88 %
Hourly rates quoted	1	0
Average minimum hourly rate	£40.00	-
Average hourly rate	£40.00	-
% change on same period last year	-
Average maximum hourly rate	£40.00	-
UK excluding London average hourly rate	£31.21	£38.04
% change on same period last year	-17.94 %
Database & Business Intelligence Scotland
Matching contract IT job ads	438	830
As % of all UK contract IT job ads sampled	0.704 %	0.891 %
Daily rates quoted	90	147
Average minimum daily rate	£296	£296
Average daily rate	£312	£312
% change on same period last year	+0.07 %
Average maximum daily rate	£328	£328
UK excluding London average daily rate	£336	£347
% change on same period last year	-3.21 %
Hourly rates quoted	22	45
Average minimum hourly rate	£27.77	£24.25
Average hourly rate	£29.90	£27.26
% change on same period last year	+9.64 %
Average maximum hourly rate	£32.02	£30.28
UK excluding London average hourly rate	£26.57	£31.78
% change on same period last year	-16.37 %
Datawarehouse UK

We calculate average IT contractor rates directly from the figures quoted and do not attempt to derive hourly rates from daily rates or vice versa.

Datawarehouse
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of IT contractor jobs citing Datawarehouse across the Scotland region as a proportion of the total demand within the Database & Business Intelligence category.

Datawarehouse
Daily Rate Trend

The chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing Datawarehouse across the Scotland region.

Datawarehouse
Daily Rate Histogram

The chart provides a histogram of daily rates quoted in contract IT jobs citing Datawarehouse across the Scotland region over the 3 months to 2 December 2008.

Datawarehouse
Hourly Rate Trend

The chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing Datawarehouse across the Scotland region.

Datawarehouse
Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing Datawarehouse within the Scotland region over the 3 months to 2 December 2008. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year. A positive number indicates a relative increase in demand.

Location	Rank Change on Same Period Last Last	Matching Contract IT Job Ads	Average Daily Rate Last 3 Months	Average Daily Rate % Change on Same Period Last Year
Glasgow	+29	22	£322	-11.94 %
Edinburgh	+8	13	£400	+20.60 %
South Ayrshire	-	1	-	-
Grampian	-	1	-	-
Renfrewshire	-3	1	-	-
Stirling	-	1	-	-

Datawarehouse UK

Datawarehouse
Top 30 Related IT Skills

For the 6 months to 2 December 2008, IT contractor jobs across the Scotland region citing Datawarehouse 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 Datawarehouse.

1 50 (37.59 %) Business Intelligence 2 42 (31.58 %) Oracle 3 31 (23.31 %) ETL 4 30 (22.56 %) BusinessObjects 4 30 (22.56 %) Business Objects 4 30 (22.56 %) Finance 5 26 (19.55 %) SQL Server 6 25 (18.80 %) SQL 6 25 (18.80 %) SQL Server Reporting Services 7 23 (17.29 %) Microsoft 7 23 (17.29 %) Dimensional Modelling 8 22 (16.54 %) Informatica 9 18 (13.53 %) SQL Server Integration Services 10 17 (12.78 %) UNIX 11 16 (12.03 %) Data Modelling

11 16 (12.03 %) Cognos 11 16 (12.03 %) SQL Server Analysis Services 12 14 (10.53 %) RDBMS 13 13 (9.774 %) MS Excel 14 12 (9.023 %) Oracle Financials 14 12 (9.023 %) OLAP 15 11 (8.271 %) SQL Server 2005 16 10 (7.519 %) Mainframe 16 10 (7.519 %) Cognos Business Intelligence 17 9 (6.767 %) Business Analysis 17 9 (6.767 %) Migration 17 9 (6.767 %) DB2 17 9 (6.767 %) PVCS 18 8 (6.015 %) XML 18 8 (6.015 %) IBM

Datawarehouse
Top Related IT Skills by Category

For the 6 months to 2 December 2008, IT contractor jobs across the Scotland region citing Datawarehouse 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 Datawarehouse. Up to 20 skills are shown per category.

Application Development 1 8 (6.015 %) XML 2 7 (5.263 %) .NET 3 6 (4.511 %) HTML 4 5 (3.759 %) WebServices 4 5 (3.759 %) ASP.NET 5 4 (3.008 %) CSS 5 4 (3.008 %) XSL 5 4 (3.008 %) AJAX 6 2 (1.504 %) WebSphere 6 2 (1.504 %) J2EE 7 1 (0.752 %) JSF	Application Platforms 1 5 (3.759 %) SharePoint 2 4 (3.008 %) SharePoint Server 2007 3 1 (0.752 %) SAS
Applications 1 13 (9.774 %) MS Excel 2 2 (1.504 %) MS Office 3 1 (0.752 %) SPSS 3 1 (0.752 %) DOC1	Business Applications 1 12 (9.023 %) Oracle Financials 2 10 (7.519 %) Cognos Business Intelligence 3 3 (2.256 %) Oracle Applications 4 1 (0.752 %) AWD
Database & Business Intelligence 1 31 (23.31 %) ETL 2 30 (22.56 %) BusinessObjects 3 26 (19.55 %) SQL Server 4 25 (18.80 %) SQL Server Reporting Services 5 18 (13.53 %) SQL Server Integration Services 6 16 (12.03 %) SQL Server Analysis Services 7 14 (10.53 %) RDBMS 8 12 (9.023 %) OLAP 9 11 (8.271 %) SQL Server 2005 10 9 (6.767 %) DB2 11 8 (6.015 %) DataStage 12 7 (5.263 %) BusinessObjects XI 13 6 (4.511 %) Oracle 8/8i 14 5 (3.759 %) Crystal Reports 15 4 (3.008 %) Oracle Reports 15 4 (3.008 %) DTS 15 4 (3.008 %) BODI 16 3 (2.256 %) Oracle 10g 17 2 (1.504 %) Microsoft Analysis Services 17 2 (1.504 %) PowerCenter	Development Applications 1 9 (6.767 %) PVCS 2 3 (2.256 %) ClearCase 2 3 (2.256 %) TestDirector 3 2 (1.504 %) PowerBuilder 3 2 (1.504 %) Subversion 4 1 (0.752 %) JUnit 4 1 (0.752 %) Visual Studio
General 1 30 (22.56 %) Finance 2 7 (5.263 %) Banking 3 6 (4.511 %) General Ledger 4 4 (3.008 %) Retail 4 4 (3.008 %) Manufacturing 5 1 (0.752 %) Home Office 5 1 (0.752 %) Government 5 1 (0.752 %) Billing 5 1 (0.752 %) Marketing	Job Titles 1 70 (52.63 %) Developer 2 38 (28.57 %) Analyst 3 23 (17.29 %) Business Analyst 4 16 (12.03 %) Datawarehouse Developer 5 14 (10.53 %) Business Intelligence Analyst 6 12 (9.023 %) Cognos Developer 7 11 (8.271 %) Test Analyst 8 10 (7.519 %) SQL Developer 9 9 (6.767 %) SQL Server Developer 9 9 (6.767 %) Informatica Developer 10 8 (6.015 %) Consultant 10 8 (6.015 %) DataStage Developer 11 7 (5.263 %) Architect 12 6 (4.511 %) Project Manager 12 6 (4.511 %) ETL Developer 12 6 (4.511 %) Ab Initio Developer 13 5 (3.759 %) Business Developer 14 4 (3.008 %) Senior Developer 14 4 (3.008 %) .NET Developer 14 4 (3.008 %) Business Objects Developer
Miscellaneous 1 10 (7.519 %) Mainframe 2 5 (3.759 %) Client/Server 3 3 (2.256 %) Management Information System 4 2 (1.504 %) N-Tier 5 1 (0.752 %) Statistics 5 1 (0.752 %) Mathematics 5 1 (0.752 %) Data Integration	Operating Systems 1 17 (12.78 %) UNIX
Processes & Methodologies 1 50 (37.59 %) Business Intelligence 2 23 (17.29 %) Dimensional Modelling 3 16 (12.03 %) Data Modelling 4 9 (6.767 %) Migration 4 9 (6.767 %) Business Analysis 5 6 (4.511 %) User Acceptance Testing 5 6 (4.511 %) Test Scripting 6 5 (3.759 %) Investment Management 6 5 (3.759 %) Systems Analysis 7 4 (3.008 %) Web Development 7 4 (3.008 %) Web Design 7 4 (3.008 %) Content Management 7 4 (3.008 %) Project Management 8 3 (2.256 %) Fund Management 8 3 (2.256 %) Test Management 8 3 (2.256 %) Security Cleared 9 2 (1.504 %) Data Migration 9 2 (1.504 %) System Testing 9 2 (1.504 %) E-Commerce 10 1 (0.752 %) ERP	Programming Languages 1 25 (18.80 %) SQL 2 6 (4.511 %) Transact-SQL 3 5 (3.759 %) C# 3 5 (3.759 %) Java 3 5 (3.759 %) Shell Script 4 4 (3.008 %) JavaScript 4 4 (3.008 %) PL/SQL 4 4 (3.008 %) DHTML 5 2 (1.504 %) C++ 6 1 (0.752 %) COBOL 6 1 (0.752 %) C 6 1 (0.752 %) VB 6 1 (0.752 %) VBA 6 1 (0.752 %) VB6
Systems Management 1 1 (0.752 %) AutoSys	Vendors 1 42 (31.58 %) Oracle 2 30 (22.56 %) Business Objects 3 23 (17.29 %) Microsoft 4 22 (16.54 %) Informatica 5 16 (12.03 %) Cognos 6 8 (6.015 %) IBM 7 6 (4.511 %) Ab Initio 8 3 (2.256 %) Ascential 9 2 (1.504 %) Teradata 9 2 (1.504 %) Sybase 10 1 (0.752 %) PeopleSoft 10 1 (0.752 %) Genesys 10 1 (0.752 %) JD Edwards