Cambridgeshire OLAP Contracts

The table below looks at the demand for Online Analytical Processing (OLAP) skills within the Cambridgeshire 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 OLAP over the 3 months to 8 October 2008 with a comparison to the same period last year.

Online Analytical Processing (OLAP)
Location Basildon Basingstoke Bath Bedfordshire Belfast Berkshire Blackpool Bournemouth Brentwood Brighton Bristol Buckinghamshire Cambridge Cambridgeshire Canary Wharf Cardiff Channel Islands Cheshire City of London County Antrim Coventry Docklands, London Dorset Dundee East Midlands East of England East Sussex East Yorkshire England Essex Glasgow Guernsey Hampshire Harlow Hertfordshire Home Counties Hull Johnstone Lancashire Leeds Liverpool London M4 Corridor Manchester Merseyside Midlands Milton Keynes North West Northern Ireland Nottingham Nottinghamshire Oxfordshire Peterborough Renfrewshire Salisbury Scotland Somerset South East South Wales South West Staffordshire Stoke-on-Trent Surrey Thames Valley UK Wales Warwick Warwickshire Welwyn Garden City West Midlands West Yorkshire Wiltshire Wokingham Yorkshire	3 months to 8 Oct 2008	Same period last year
Rank	43	72
Rank change on same period last year	+29
Matching contract IT job ads	15	4
As % of all UK contract IT job ads sampled	0.021 %	0.004 %
As % of the category below	10.14 %	1.794 %
Daily rates quoted	7	1
Average minimum daily rate	£350	£300
Average daily rate	£366	£325
% change on same period last year	+12.52 %
Average maximum daily rate	£381	£350
UK excluding London average daily rate	£347	£414
% change on same period last year	-16.13 %
Hourly rates quoted	0	0
Average minimum hourly rate	-	-
Average hourly rate	-	-
% change on same period last year	-
Average maximum hourly rate	-	-
UK excluding London average hourly rate	£32.13	£42.43
% change on same period last year	-24.28 %
Database & Business Intelligence Cambridgeshire
Matching contract IT job ads	148	223
As % of all UK contract IT job ads sampled	0.207 %	0.229 %
Daily rates quoted	35	27
Average minimum daily rate	£342	£320
Average daily rate	£359	£332
% change on same period last year	+8.13 %
Average maximum daily rate	£375	£343
UK excluding London average daily rate	£342	£351
% change on same period last year	-2.57 %
Hourly rates quoted	13	33
Average minimum hourly rate	£26.63	£25.58
Average hourly rate	£28.41	£26.94
% change on same period last year	+5.42 %
Average maximum hourly rate	£30.19	£28.31
UK excluding London average hourly rate	£30.15	£31.77
% change on same period last year	-5.10 %
OLAP East of England

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.

OLAP
Demand Trend

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

OLAP
Daily Rate Trend

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

OLAP
Daily Rate Histogram

The chart provides a histogram of daily rates quoted in contract IT jobs citing OLAP across the Cambridgeshire region over the 3 months to 8 October 2008.

OLAP
Contract Locations

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing OLAP within the Cambridgeshire region over the 3 months to 8 October 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
Cambridge	+21	8	£368	-
Peterborough	+11	3	£400	+23.07 %

OLAP East of England

OLAP
Top 30 Related IT Skills

For the 6 months to 8 October 2008, IT contractor jobs across the Cambridgeshire region citing OLAP 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 OLAP.

1 32 (91.43 %) SQL Server 2 30 (85.71 %) SQL Server 2005 3 24 (68.57 %) SQL 4 22 (62.86 %) Datawarehouse 5 21 (60.00 %) SQL Server Analysis Services 6 20 (57.14 %) Microsoft Analysis Services 7 18 (51.43 %) Transact-SQL 8 15 (42.86 %) VBA 8 15 (42.86 %) Business Intelligence 8 15 (42.86 %) Finance 9 14 (40.00 %) ETL 9 14 (40.00 %) Banking 10 13 (37.14 %) SQL Server 2000 10 13 (37.14 %) .NET 11 11 (31.43 %) SQL Server Integration Services

12 10 (28.57 %) SharePoint 13 9 (25.71 %) BusinessObjects 13 9 (25.71 %) Business Objects 13 9 (25.71 %) VB.NET 13 9 (25.71 %) Cognos 13 9 (25.71 %) XML 13 9 (25.71 %) Insurance 13 9 (25.71 %) Telecoms 14 8 (22.86 %) ProClarity 15 7 (20.00 %) DTS 16 6 (17.14 %) C# 16 6 (17.14 %) MS Office 16 6 (17.14 %) SQL Server Reporting Services 16 6 (17.14 %) Dimensional Modelling 17 5 (14.29 %) Microsoft

OLAP
Top Related IT Skills by Category

For the 6 months to 8 October 2008, IT contractor jobs across the Cambridgeshire region citing OLAP 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 OLAP. Up to 20 skills are shown per category.

Application Development 1 13 (37.14 %) .NET 2 9 (25.71 %) XML	Application Platforms 1 10 (28.57 %) SharePoint 2 2 (5.714 %) Lotus Notes
Applications 1 6 (17.14 %) MS Office 2 1 (2.857 %) MS Excel	Business Applications 1 2 (5.714 %) Academy Housing 1 2 (5.714 %) arcHouse
Database & Business Intelligence 1 32 (91.43 %) SQL Server 2 30 (85.71 %) SQL Server 2005 3 22 (62.86 %) Datawarehouse 4 21 (60.00 %) SQL Server Analysis Services 5 20 (57.14 %) Microsoft Analysis Services 6 14 (40.00 %) ETL 7 13 (37.14 %) SQL Server 2000 8 11 (31.43 %) SQL Server Integration Services 9 9 (25.71 %) BusinessObjects 10 7 (20.00 %) DTS 11 6 (17.14 %) SQL Server Reporting Services 12 2 (5.714 %) Data Mining	General 1 15 (42.86 %) Finance 2 14 (40.00 %) Banking 3 9 (25.71 %) Telecoms 3 9 (25.71 %) Insurance 4 4 (11.43 %) Retail 5 2 (5.714 %) Health
Job Titles 1 31 (88.57 %) Developer 2 13 (37.14 %) SQL Developer 3 9 (25.71 %) Datawarehouse Developer 4 7 (20.00 %) SQL Server Developer 5 6 (17.14 %) Business Developer 6 5 (14.29 %) ETL Developer 6 5 (14.29 %) Business Intelligence Developer 7 2 (5.714 %) Business Project Manager 7 2 (5.714 %) Business Manager 7 2 (5.714 %) Analyst 7 2 (5.714 %) Project Manager 7 2 (5.714 %) Business Analyst 8 1 (2.857 %) Consultant 8 1 (2.857 %) Business Intelligence Consultant 8 1 (2.857 %) DBA 8 1 (2.857 %) SQL Server DBA 8 1 (2.857 %) SQL DBA	Miscellaneous 1 1 (2.857 %) Replication
Operating Systems 1 1 (2.857 %) Windows 1 1 (2.857 %) Windows Server 2003	Processes & Methodologies 1 15 (42.86 %) Business Intelligence 2 6 (17.14 %) Dimensional Modelling 3 4 (11.43 %) Web Development 3 4 (11.43 %) CRM 4 2 (5.714 %) Project Management 4 2 (5.714 %) Asset Management 5 1 (2.857 %) E-Commerce
Programming Languages 1 24 (68.57 %) SQL 2 18 (51.43 %) Transact-SQL 3 15 (42.86 %) VBA 4 9 (25.71 %) VB.NET 5 6 (17.14 %) C# 6 2 (5.714 %) C	Vendors 1 9 (25.71 %) Business Objects 1 9 (25.71 %) Cognos 2 8 (22.86 %) ProClarity 3 5 (14.29 %) Microsoft 4 2 (5.714 %) Lotus 4 2 (5.714 %) Anite 4 2 (5.714 %) Northgate 4 2 (5.714 %) Civica 4 2 (5.714 %) Capita 4 2 (5.714 %) Orchard