City of London OLAP Contracts

This section looks at the demand for Online Analytical Processing (OLAP) skills within the City of London 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 21 August 2008 with a comparison to the same period last year.

Online Analytical Processing (OLAP)
Location Basildon Basingstoke Bath Belfast Berkshire Birmingham Blackpool Bournemouth Brentwood Brighton Buckinghamshire Cambridge Cambridgeshire Canary Wharf Cheshire City of London County Antrim Coventry Docklands, London Dorset East Midlands East of England East Sussex East Yorkshire England Essex Hampshire Hertfordshire Hull Lancashire Leeds Liverpool London M4 Corridor Maidenhead Manchester Merseyside Midlands Milton Keynes Newcastle Upon Tyne North East North West Northampton Northamptonshire Northern Ireland Nottingham Nottinghamshire Peterborough Reading Rugby Scotland Sheffield Somerset South Coast South East South West South Yorkshire Southampton Staffordshire Surrey Thames Valley Trowbridge Tyne and Wear UK Warwick Warwickshire West Midlands West Yorkshire Wiltshire Yorkshire	3 months to 21 Aug 2008	Same period last year
Rank	180	170
Rank change on same period last year	-10
Matching contract IT job ads	46	29
As % of all UK contract IT job ads sampled	0.061 %	0.029 %
As % of the category below	2.648 %	1.942 %
Daily rates quoted	24	15
Average minimum daily rate	£418	£438
Average daily rate	£446	£464
% change on same period last year	-3.96 %
Average maximum daily rate	£473	£490
UK excluding London average daily rate	£359	£419
% change on same period last year	-14.28 %
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	£44.59	£45.29
% change on same period last year	-1.54 %
Database & Business Intelligence City of London
Matching contract IT job ads	1737	1493
As % of all UK contract IT job ads sampled	2.292 %	1.487 %
Daily rates quoted	950	675
Average minimum daily rate	£390	£421
Average daily rate	£423	£452
% change on same period last year	-6.43 %
Average maximum daily rate	£456	£483
UK excluding London average daily rate	£349	£359
% change on same period last year	-2.84 %
Hourly rates quoted	56	30
Average minimum hourly rate	£28.40	£19.57
Average hourly rate	£30.93	£21.34
% change on same period last year	+44.93 %
Average maximum hourly rate	£33.46	£23.11
UK excluding London average hourly rate	£32.55	£32.20
% change on same period last year	+1.08 %
OLAP London

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 City of London 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 City of London region.

OLAP
Daily Rate Histogram

The chart provides a histogram of daily rates quoted in contract IT jobs citing OLAP across the City of London region over the 3 months to 21 August 2008.

OLAP
Hourly Rate Trend

The chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing OLAP across the City of London region.

OLAP
Top 30 Related IT Skills

For the 6 months to 21 August 2008, IT contractor jobs across the City of London 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 67 (66.34 %) SQL 2 64 (63.37 %) SQL Server 3 38 (37.62 %) SQL Server Analysis Services 4 35 (34.65 %) Microsoft Analysis Services 4 35 (34.65 %) Datawarehouse 5 34 (33.66 %) Finance 6 29 (28.71 %) SQL Server 2005 7 26 (25.74 %) Oracle OLAP 7 26 (25.74 %) Oracle 8 24 (23.76 %) SQL Server 2000 9 23 (22.77 %) ETL 10 21 (20.79 %) SQL Server Reporting Services 11 20 (19.80 %) Banking 12 19 (18.81 %) Microsoft 13 18 (17.82 %) Business Intelligence

13 18 (17.82 %) Insurance 14 17 (16.83 %) SQL Server Integration Services 15 16 (15.84 %) .NET 15 16 (15.84 %) C# 16 13 (12.87 %) Transact-SQL 16 13 (12.87 %) DTS 17 12 (11.88 %) MDX 18 11 (10.89 %) ProClarity 18 11 (10.89 %) Degree 18 11 (10.89 %) Star Schema 19 10 (9.901 %) Data Modelling 19 10 (9.901 %) Java 20 9 (8.911 %) UNIX 20 9 (8.911 %) Hyperion 20 9 (8.911 %) Investment Banking

OLAP
Top Related IT Skills by Category

For the 6 months to 21 August 2008, IT contractor jobs across the City of London 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 16 (15.84 %) .NET 2 12 (11.88 %) MDX 3 8 (7.921 %) XML 4 7 (6.931 %) ASP.NET 5 3 (2.970 %) Spring 5 3 (2.970 %) JFC 5 3 (2.970 %) JRules 5 3 (2.970 %) Hibernate 5 3 (2.970 %) J2EE 5 3 (2.970 %) HTML 5 3 (2.970 %) ASP 5 3 (2.970 %) Struts 5 3 (2.970 %) WebServices 5 3 (2.970 %) Middleware 5 3 (2.970 %) Swing 6 1 (0.990 %) COM	Application Platforms 1 5 (4.950 %) SAS 2 3 (2.970 %) JBoss 3 2 (1.980 %) SharePoint 4 1 (0.990 %) SharePoint Server 2007
Applications 1 6 (5.941 %) MS Excel 2 4 (3.960 %) MS Project 3 2 (1.980 %) MS Office 4 1 (0.990 %) Spreadsheet	Communications & Networking 1 1 (0.990 %) Internet 1 1 (0.990 %) SAN 1 1 (0.990 %) Kerberos
Database & Business Intelligence 1 64 (63.37 %) SQL Server 2 38 (37.62 %) SQL Server Analysis Services 3 35 (34.65 %) Microsoft Analysis Services 3 35 (34.65 %) Datawarehouse 4 29 (28.71 %) SQL Server 2005 5 26 (25.74 %) Oracle OLAP 6 24 (23.76 %) SQL Server 2000 7 23 (22.77 %) ETL 8 21 (20.79 %) SQL Server Reporting Services 9 17 (16.83 %) SQL Server Integration Services 10 13 (12.87 %) DTS 11 11 (10.89 %) Star Schema 12 8 (7.921 %) Oracle 10g 12 8 (7.921 %) Hyperion Essbase 13 5 (4.950 %) Data Mining 14 4 (3.960 %) Data Mart 14 4 (3.960 %) Reference Data 15 3 (2.970 %) Crystal Reports 15 3 (2.970 %) MySQL 15 3 (2.970 %) BusinessObjects	Development Applications 1 3 (2.970 %) Ant 1 3 (2.970 %) Visual Studio 2 2 (1.980 %) ProC 3 1 (0.990 %) TestDirector
General 1 34 (33.66 %) Finance 2 20 (19.80 %) Banking 3 18 (17.82 %) Insurance 4 9 (8.911 %) Investment Banking 5 4 (3.960 %) Financial Institution 5 4 (3.960 %) Front Office 5 4 (3.960 %) General Ledger 6 3 (2.970 %) Government 6 3 (2.970 %) Health 6 3 (2.970 %) Publishing 6 3 (2.970 %) Pharmaceutical 7 1 (0.990 %) Marketing 7 1 (0.990 %) Billing	Job Titles 1 68 (67.33 %) Developer 2 23 (22.77 %) SQL Developer 3 20 (19.80 %) Analyst 4 14 (13.86 %) SQL Server Developer 5 13 (12.87 %) Datawarehouse Developer 6 11 (10.89 %) Oracle Developer 7 6 (5.941 %) Architect 7 6 (5.941 %) Senior Developer 8 5 (4.950 %) Developer Analyst 8 5 (4.950 %) Consultant 8 5 (4.950 %) Senior Analyst 8 5 (4.950 %) Data Analyst 9 4 (3.960 %) Analyst Developer 9 4 (3.960 %) Datawarehouse Architect 9 4 (3.960 %) Datawarehouse Analyst 10 3 (2.970 %) Report Developer 10 3 (2.970 %) Senior Java Consultant 10 3 (2.970 %) Hyperion Developer 10 3 (2.970 %) Senior J2EE Developer 10 3 (2.970 %) Senior Analyst Developer
Miscellaneous 1 8 (7.921 %) Mathematics 2 6 (5.941 %) Management Information System 3 4 (3.960 %) Equities 3 4 (3.960 %) Data Extraction 3 4 (3.960 %) Computer Science 3 4 (3.960 %) Statistics 4 3 (2.970 %) Physics 5 1 (0.990 %) Derivative 5 1 (0.990 %) Credit Risk 5 1 (0.990 %) Market Risk 5 1 (0.990 %) Credit Derivative 5 1 (0.990 %) Replication 5 1 (0.990 %) Fixed Income 5 1 (0.990 %) Grid Computing 5 1 (0.990 %) Clustering	Operating Systems 1 9 (8.911 %) UNIX 2 3 (2.970 %) Windows 2 3 (2.970 %) Linux
Processes & Methodologies 1 18 (17.82 %) Business Intelligence 2 10 (9.901 %) Data Modelling 3 6 (5.941 %) Migration 3 6 (5.941 %) System Testing 3 6 (5.941 %) Logistics 4 4 (3.960 %) UML 4 4 (3.960 %) Data Migration 5 3 (2.970 %) Dimensional Modelling 5 3 (2.970 %) Validation 5 3 (2.970 %) Project Management 5 3 (2.970 %) OOA/OOD 5 3 (2.970 %) ERP 6 2 (1.980 %) CRM 6 2 (1.980 %) Multidimensional Analysis 6 2 (1.980 %) OO 6 2 (1.980 %) Asset Management 6 2 (1.980 %) Business Analysis 6 2 (1.980 %) User Acceptance Testing 6 2 (1.980 %) Unit Testing 6 2 (1.980 %) DV Cleared	Programming Languages 1 67 (66.34 %) SQL 2 16 (15.84 %) C# 3 13 (12.87 %) Transact-SQL 4 10 (9.901 %) Java 5 8 (7.921 %) PL/SQL 6 7 (6.931 %) Perl 7 3 (2.970 %) VBA 8 2 (1.980 %) SAS Macro 9 1 (0.990 %) Ruby 9 1 (0.990 %) VB 9 1 (0.990 %) Python
Qualifications 1 11 (10.89 %) Degree 2 1 (0.990 %) ISEB	Quality Assurance & Compliance 1 1 (0.990 %) Basel II
System Software 1 1 (0.990 %) Oracle RAC	Vendors 1 26 (25.74 %) Oracle 2 19 (18.81 %) Microsoft 3 11 (10.89 %) ProClarity 4 9 (8.911 %) Hyperion 5 6 (5.941 %) Informatica 5 6 (5.941 %) Agresso 5 6 (5.941 %) Cognos 6 4 (3.960 %) SAP 7 3 (2.970 %) Apple 7 3 (2.970 %) Business Objects 8 2 (1.980 %) Sybase 8 2 (1.980 %) Sony 9 1 (0.990 %) Teradata 9 1 (0.990 %) Brio