Hampshire OLAP Jobs

This section looks at the demand for Online Analytical Processing (OLAP) skills within the Hampshire region with a comparison to our Database & Business Intelligence category. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 25 July 2008 with a comparison to the same period last year.

Online Analytical Processing (OLAP)
Location Abingdon Altrincham Barking Bath Berkshire Bicester Birkenhead Birmingham Bournemouth Bracknell Brentwood Bristol Buckinghamshire Bury Caerphilly Cambridge Cambridgeshire Canary Wharf Cardiff Cheshire Chester City of London Clapham Colchester Coventry Crawley Croydon Dartford Docklands, London Dorset East Midlands East of England Edinburgh England Essex Farnborough Gerrards Cross Glasgow Hammersmith Hampshire Harpenden Harrow Herefordshire Hertfordshire Ipswich Kent Lancashire Leatherhead Leeds Leicestershire Liverpool London Loughborough Manchester Marlow Merseyside Midlands Milton Keynes Newcastle Upon Tyne North East North West North Yorkshire Northampton Northamptonshire Nottingham Nottinghamshire Oxford Oxfordshire Peterborough Reading Reigate Scotland Sheffield Skipton Slough Somerset South Coast South East South Wales South West South Yorkshire Stafford Staffordshire Stockport Suffolk Surrey Trowbridge Tyne and Wear UK Wales Warrington Warwickshire West Midlands West Sussex West Yorkshire Wiltshire Windsor Wirral Woking Wolverhampton Worcester Worcestershire York Yorkshire	3 months to 25 Jul 2008	Same period last year
Rank	198	178
Rank change on same period last year	-20
Matching permanent IT job ads	11	27
As % of all UK permanent IT job ads sampled	0.006 %	0.011 %
As % of the category below	0.667 %	1.451 %
Salaries quoted	11	25
Average minimum salary	£37,636	£25,600
Average salary	£38,864	£29,500
% change on same period last year	+31.74 %
Average maximum salary	£40,091	£33,400
UK excluding London average salary	£40,974	£41,836
% change on same period last year	-2.06 %
Database & Business Intelligence Hampshire
Matching permanent IT job ads	1650	1861
As % of all UK permanent IT job ads sampled	0.871 %	0.762 %
Salaries quoted	1415	1547
Average minimum salary	£34,393	£33,515
Average salary	£37,442	£35,996
% change on same period last year	+4.01 %
Average maximum salary	£40,490	£38,478
UK excluding London average salary	£37,141	£38,092
% change on same period last year	-2.49 %
OLAP South East

OLAP
Demand Trend

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

OLAP
Salary Trend

The chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the Hampshire region.

OLAP
Salary Histogram

The chart provides a salary histogram for IT jobs citing OLAP across the Hampshire region over the 3 months to 25 July 2008.

OLAP
Job Locations

This section looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the Hampshire region over the 3 months to 25 July 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 Permanent IT Job Ads	Average Salary Last 3 Months	Average Salary % Change on Same Period Last Year
Farnborough	-4	5	£40,000	+33.33 %

OLAP South East

OLAP
Top 30 Related IT Skills

For the 6 months to 25 July 2008, IT jobs across the Hampshire 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 IT job ads sampled that cited OLAP.

1 61 (92.42 %) SQL Server 2 47 (71.21 %) Business Intelligence 3 36 (54.55 %) SQL Server 2000 4 31 (46.97 %) Microsoft 5 28 (42.42 %) SQL Server 2005 6 27 (40.91 %) Security Management 6 27 (40.91 %) Datawarehouse 7 24 (36.36 %) SQL 8 16 (24.24 %) MS Excel 9 14 (21.21 %) Cognos 10 13 (19.70 %) Dimensional Modelling 10 13 (19.70 %) Cognos Powerplay 10 13 (19.70 %) ReportNet 10 13 (19.70 %) Intranet 11 11 (16.67 %) Oracle OLAP

11 11 (16.67 %) Oracle 12 10 (15.15 %) XML 13 9 (13.64 %) SQL Server 7 13 9 (13.64 %) SQL Server Analysis Services 14 8 (12.12 %) OLTP 14 8 (12.12 %) Oracle 9i 15 7 (10.61 %) PL/SQL 15 7 (10.61 %) C# 15 7 (10.61 %) Microsoft Analysis Services 16 6 (9.091 %) MDX 16 6 (9.091 %) Transact-SQL 16 6 (9.091 %) MySQL 16 6 (9.091 %) Business Objects 16 6 (9.091 %) Oracle Reports 16 6 (9.091 %) BusinessObjects

OLAP
Top Related IT Skills by Category

For the 6 months to 25 July 2008, IT jobs across the Hampshire 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 IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Development 1 10 (15.15 %) XML 2 6 (9.091 %) MDX 3 5 (7.576 %) ASP.NET 3 5 (7.576 %) .NET 4 4 (6.061 %) ADO 4 4 (6.061 %) .NET Framework	Application Platforms 1 5 (7.576 %) SharePoint 2 3 (4.545 %) SAS
Applications 1 16 (24.24 %) MS Excel 2 1 (1.515 %) MS Office	Communications & Networking 1 13 (19.70 %) Intranet 2 1 (1.515 %) Internet
Database & Business Intelligence 1 61 (92.42 %) SQL Server 2 36 (54.55 %) SQL Server 2000 3 28 (42.42 %) SQL Server 2005 4 27 (40.91 %) Datawarehouse 5 13 (19.70 %) Cognos Powerplay 5 13 (19.70 %) ReportNet 6 11 (16.67 %) Oracle OLAP 7 9 (13.64 %) SQL Server Analysis Services 7 9 (13.64 %) SQL Server 7 8 8 (12.12 %) OLTP 8 8 (12.12 %) Oracle 9i 9 7 (10.61 %) Microsoft Analysis Services 10 6 (9.091 %) MySQL 10 6 (9.091 %) Oracle Reports 10 6 (9.091 %) BusinessObjects 11 5 (7.576 %) ETL 11 5 (7.576 %) Crystal Reports 12 4 (6.061 %) SQL Server Reporting Services 12 4 (6.061 %) Oracle OWB 13 3 (4.545 %) Oracle 10g	Development Applications 1 1 (1.515 %) Visual Studio
General 1 5 (7.576 %) Telecoms 2 4 (6.061 %) Insurance 3 2 (3.030 %) Finance 4 1 (1.515 %) Retail 4 1 (1.515 %) Pensions	Job Titles 1 33 (50.00 %) DBA 1 33 (50.00 %) SQL DBA 2 25 (37.88 %) Developer 3 23 (34.85 %) SQL Server DBA 4 14 (21.21 %) Administrator 5 13 (19.70 %) Analyst 6 12 (18.18 %) Analyst Developer 7 8 (12.12 %) Datawarehouse Developer 8 6 (9.091 %) Data Analyst 8 6 (9.091 %) Datawarehouse Analyst 9 5 (7.576 %) Database Engineer 9 5 (7.576 %) Business Analyst 9 5 (7.576 %) Systems Developer 9 5 (7.576 %) Support Engineer 10 4 (6.061 %) Business Systems Analyst 10 4 (6.061 %) Systems Analyst 10 4 (6.061 %) Business Developer 10 4 (6.061 %) Server Administrator 11 3 (4.545 %) Consultant 12 2 (3.030 %) SAS Consultant
Miscellaneous 1 5 (7.576 %) Replication 2 3 (4.545 %) Client/Server 2 3 (4.545 %) Management Information System 3 2 (3.030 %) Credit Risk 4 1 (1.515 %) Economics 4 1 (1.515 %) Mathematics	Operating Systems 1 2 (3.030 %) Windows
Processes & Methodologies 1 47 (71.21 %) Business Intelligence 2 27 (40.91 %) Security Management 3 13 (19.70 %) Dimensional Modelling 4 5 (7.576 %) OO 5 4 (6.061 %) Data Modelling 6 2 (3.030 %) Statistical Analysis 6 2 (3.030 %) Risk Analysis 7 1 (1.515 %) Information Management 7 1 (1.515 %) Business Analysis 7 1 (1.515 %) UML	Programming Languages 1 24 (36.36 %) SQL 2 7 (10.61 %) C# 2 7 (10.61 %) PL/SQL 3 6 (9.091 %) Transact-SQL 4 4 (6.061 %) Python 4 4 (6.061 %) C++ 4 4 (6.061 %) Java 4 4 (6.061 %) Perl 4 4 (6.061 %) Ruby 5 3 (4.545 %) VB 6 1 (1.515 %) VB6
Qualifications 1 5 (7.576 %) Degree	Vendors 1 31 (46.97 %) Microsoft 2 14 (21.21 %) Cognos 3 11 (16.67 %) Oracle 4 6 (9.091 %) Business Objects 5 1 (1.515 %) SAP 5 1 (1.515 %) Trillium 5 1 (1.515 %) Ascential 5 1 (1.515 %) Hyperion 5 1 (1.515 %) Informatica 5 1 (1.515 %) MicroStrategy 5 1 (1.515 %) Ab Initio 5 1 (1.515 %) Teradata