Cheshire OLAP Jobs

This section looks at the demand for Online Analytical Processing (OLAP) skills within the Cheshire 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	134	99
Rank change on same period last year	-35
Matching permanent IT job ads	13	44
As % of all UK permanent IT job ads sampled	0.007 %	0.018 %
As % of the category below	1.356 %	5.098 %
Salaries quoted	13	44
Average minimum salary	£30,077	£31,872
Average salary	£33,115	£34,309
% change on same period last year	-3.47 %
Average maximum salary	£36,154	£36,745
UK excluding London average salary	£40,974	£41,836
% change on same period last year	-2.06 %
Database & Business Intelligence Cheshire
Matching permanent IT job ads	959	863
As % of all UK permanent IT job ads sampled	0.506 %	0.353 %
Salaries quoted	893	781
Average minimum salary	£31,841	£30,581
Average salary	£34,482	£32,916
% change on same period last year	+4.75 %
Average maximum salary	£37,123	£35,252
UK excluding London average salary	£37,141	£38,092
% change on same period last year	-2.49 %
OLAP North West

OLAP
Demand Trend

The chart provides a 3-month moving total beginning in 2004 of permanent IT jobs citing OLAP across the Cheshire 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 Cheshire region.

OLAP
Salary Histogram

The chart provides a salary histogram for IT jobs citing OLAP across the Cheshire 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 Cheshire 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
Warrington	-22	6	£25,417	-10.32 %
Chester	+1	3	£33,333	-22.48 %

OLAP North West

OLAP
Top 30 Related IT Skills

For the 6 months to 25 July 2008, IT jobs across the Cheshire 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 20 (90.91 %) Datawarehouse 2 12 (54.55 %) SQL Server 3 11 (50.00 %) Business Intelligence 4 10 (45.45 %) Basel II 4 10 (45.45 %) SQL 4 10 (45.45 %) ETL 4 10 (45.45 %) SAS 4 10 (45.45 %) Base SAS 5 9 (40.91 %) Ab Initio 5 9 (40.91 %) Teradata 5 9 (40.91 %) Banking 5 9 (40.91 %) DataStage 6 8 (36.36 %) Microsoft 7 7 (31.82 %) SQL Server Reporting Services 7 7 (31.82 %) Marketing

7 7 (31.82 %) VB 8 5 (22.73 %) DTS 9 3 (13.64 %) SQL Server Analysis Services 9 3 (13.64 %) SQL Server Integration Services 9 3 (13.64 %) .NET 9 3 (13.64 %) XML 10 2 (9.091 %) Business Objects 10 2 (9.091 %) ActiveX 10 2 (9.091 %) MS Excel 10 2 (9.091 %) CRM 10 2 (9.091 %) Cognos 10 2 (9.091 %) Management Information System 10 2 (9.091 %) BusinessObjects 10 2 (9.091 %) SQL Server 2005 10 2 (9.091 %) VB6

OLAP
Top Related IT Skills by Category

For the 6 months to 25 July 2008, IT jobs across the Cheshire 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 3 (13.64 %) .NET 1 3 (13.64 %) XML 2 2 (9.091 %) ActiveX 3 1 (4.545 %) MDX	Application Platforms 1 10 (45.45 %) SAS
Applications 1 2 (9.091 %) MS Excel	Database & Business Intelligence 1 20 (90.91 %) Datawarehouse 2 12 (54.55 %) SQL Server 3 10 (45.45 %) ETL 3 10 (45.45 %) Base SAS 4 9 (40.91 %) DataStage 5 7 (31.82 %) SQL Server Reporting Services 6 5 (22.73 %) DTS 7 3 (13.64 %) SQL Server Integration Services 7 3 (13.64 %) SQL Server Analysis Services 8 2 (9.091 %) BusinessObjects 8 2 (9.091 %) SQL Server 2005 9 1 (4.545 %) Oracle OLAP 9 1 (4.545 %) SQL Server 7 9 1 (4.545 %) SQL Server 2000 9 1 (4.545 %) Microsoft Analysis Services 9 1 (4.545 %) Oracle Reports 9 1 (4.545 %) Oracle 9i 9 1 (4.545 %) OLTP 9 1 (4.545 %) RDBMS 9 1 (4.545 %) Oracle 10g
Development Applications 1 1 (4.545 %) VSS/SourceSafe	General 1 9 (40.91 %) Banking 2 7 (31.82 %) Marketing 3 1 (4.545 %) Finance
Job Titles 1 13 (59.09 %) Developer 2 8 (36.36 %) SAS Developer 3 7 (31.82 %) Analyst 4 5 (22.73 %) MI Analyst 5 2 (9.091 %) SQL Server Developer 5 2 (9.091 %) SQL Developer 5 2 (9.091 %) Consultant 5 2 (9.091 %) Business Intelligence Consultant 6 1 (4.545 %) DBA 6 1 (4.545 %) Analyst Programmer 6 1 (4.545 %) Programmer 6 1 (4.545 %) .NET Developer 6 1 (4.545 %) SQL Server DBA 6 1 (4.545 %) VB.NET Developer 6 1 (4.545 %) Business Objects Developer 6 1 (4.545 %) VB Developer 6 1 (4.545 %) Business Consultant 6 1 (4.545 %) SQL DBA 6 1 (4.545 %) Business Developer 6 1 (4.545 %) SAS Analyst	Miscellaneous 1 2 (9.091 %) Management Information System
Processes & Methodologies 1 11 (50.00 %) Business Intelligence 2 2 (9.091 %) CRM 3 1 (4.545 %) Data Modelling 3 1 (4.545 %) Migration 3 1 (4.545 %) Data Migration	Programming Languages 1 10 (45.45 %) SQL 2 7 (31.82 %) VB 3 2 (9.091 %) VB6 4 1 (4.545 %) SAS Macro 4 1 (4.545 %) VB.NET
Quality Assurance & Compliance 1 10 (45.45 %) Basel II	Vendors 1 9 (40.91 %) Ab Initio 1 9 (40.91 %) Teradata 2 8 (36.36 %) Microsoft 3 2 (9.091 %) Business Objects 3 2 (9.091 %) Cognos 4 1 (4.545 %) Oracle