The first part of the table below looks at the demand for OLAP skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 22 May 2012 with a comparison to the same period in the previous 2 years. The second part of the table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Online Analytical Processing (OLAP)
Location
3 months to
22 May 2012
Same period 2011Same period 2010
Rank349265274
Rank change year-on-year
Down-84Up+9
Matching permanent IT job ads7931059738
As % of all permanent IT jobs located in the UK0.658 %0.864 %0.773 %
As % of the Database & Business Intelligence category2.207 %2.942 %2.770 %
Number of salaries quoted698926644
Average salary£47,500£45,000£47,500
Average salary % change year-on-year
+5.55 %-5.26 %
90% of jobs offered a salary of more than£33,600£32,500£32,500
10% of jobs offered a salary of more than£67,500£67,500£70,000
UK excluding London average salary£42,500£42,000£42,500
% change year-on-year
+1.19 %-1.17 %
IT Job Market, Database & Business Intelligence CategoryAll Database & Business Intelligence
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
359343599326642
As % of all permanent IT jobs located in the UK29.80 %29.35 %27.90 %
Number of salaries quoted317633129922952
Average salary£42,500£42,500£40,000
Average salary % change year-on-year
-+6.25 %
90% of jobs offered a salary of more than£29,500£28,860£27,500
10% of jobs offered a salary of more than£65,000£65,000£65,000
UK excluding London average salary£37,500£37,500£35,000
% change year-on-year
-+7.14 %

OLAP
Demand Trend

The chart provides the 3-month moving total of permanent IT jobs citing OLAP within the UK as a proportion of the total demand within the Database & Business Intelligence category.

OLAP Demand Trend

OLAP
Salary Trend

The chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP within the UK.

OLAP Salary Trend

OLAP
Salary Histogram

The chart provides a salary histogram for IT jobs citing OLAP over the 3 months to 22 May 2012 within the UK.

OLAP Salary Histogram

OLAP
Top 30 Job Locations

The table below looks at the demand and provides a guide to the average salaries quoted in IT jobs citing OLAP within the UK over the 3 months to 22 May 2012. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

LocationRank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
EnglandDown-82742£47,500+5.55 %
LondonDown-42408£55,000+5.26 %
City of LondonUp+26139£57,500+15.00 %
South EastDown-99123£45,000+5.88 %
East of EnglandDown-2859£40,000-3.03 %
HertfordshireUp+3550£40,000-20.00 %
West MidlandsDown-939£45,000+4.99 %
North WestDown-3935£40,375+7.66 %
ManchesterDown-1931£43,250+15.33 %
South WestDown-1330£42,500+25.00 %
BuckinghamshireDown-3727£35,000-22.22 %
Hemel HempsteadUp+1224£37,500-37.50 %
BerkshireDown-2924£50,250-4.28 %
YorkshireDown-4323£32,500-2.98 %
West YorkshireUp+122£32,500-23.52 %
BristolUp+820£45,000+34.32 %
StaffordshireUp+1117£42,500+22.30 %
OxfordshireUp+1116£40,000+29.03 %
HampshireDown-4016£35,000-22.22 %
ScotlandDown-1314£42,500+21.42 %
South WalesUp+312£39,000-
WalesUp+112£39,000-
LeedsDown-1012£30,000-42.85 %
ReadingDown-1212£55,500+0.90 %
SurreyDown-3611£67,500+55.17 %
West SussexUp+1410£45,000-24.68 %
Gerrards CrossUp+110£35,000+1.44 %
Newcastle upon TyneNew entry-10£46,250-
North EastNew entry-10£46,250-
Tyne and WearNew entry-10£46,250-

OLAP
Top 30 Related IT Skills

For the 6 months to 22 May 2012, IT jobs within the UK 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.

11147 (72.87 %)SQL Server
21061 (67.41 %)Business Intelligence
31033 (65.63 %)SQL
4995 (63.21 %)Data Warehouse
5941 (59.78 %)SQL Server Reporting Services
6895 (56.86 %)SQL Server Integration Services
7863 (54.83 %)SQL Server Analysis Services
8762 (48.41 %)ETL
9695 (44.16 %)Microsoft
10576 (36.59 %)SQL Server 2008
11472 (29.99 %)MS Excel
12459 (29.16 %)T-SQL
13396 (25.16 %)Microsoft Analysis Services
14379 (24.08 %)Oracle
14379 (24.08 %)Oracle OLAP
15377 (23.95 %)MDX
16376 (23.89 %).NET
17372 (23.63 %)SQL Server 2005
18347 (22.05 %)Finance
19340 (21.60 %)C#
20339 (21.54 %)Business Objects
21311 (19.76 %)Data Modelling
22238 (15.12 %)SAP
23225 (14.29 %)OLTP
24208 (13.21 %)BusinessObjects
25202 (12.83 %)ASP.NET
26195 (12.39 %)Cognos
27193 (12.26 %)Windows
28188 (11.94 %)Dimensional Modelling
29184 (11.69 %)Java

OLAP
Top Related IT Skills by Category

For the 6 months to 22 May 2012, IT jobs within the UK 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.

IT Job Market, Application Development CategoryApplication Development
1377 (23.95 %)MDX
2376 (23.89 %).NET
3202 (12.83 %)ASP.NET
4120 (7.624 %)XML
575 (4.765 %)Web Services
668 (4.320 %)jQuery
761 (3.875 %)CSS
859 (3.748 %)HTML
947 (2.986 %)J2EE
1046 (2.922 %)Spring
1143 (2.732 %)SAP XI
1237 (2.351 %)Hibernate
1332 (2.033 %)ODBC
1332 (2.033 %)LINQ
1332 (2.033 %)ASP.NET MVC
1430 (1.906 %)WCF
1526 (1.652 %)WebSphere
1623 (1.461 %).NET Framework
1722 (1.398 %)Ajax
1722 (1.398 %)Silverlight
IT Job Market, Application Platforms CategoryApplication Platforms
1166 (10.55 %)SharePoint
2123 (7.814 %)SAS
340 (2.541 %)Apache
439 (2.478 %)SharePoint 2010
535 (2.224 %)IIS
629 (1.842 %)Tomcat
720 (1.271 %)SharePoint Server
89 (0.572 %)ESB
89 (0.572 %)BizTalk Server
89 (0.572 %)Apache Solr
98 (0.508 %)Google App Engine
98 (0.508 %)Amazon AWS
103 (0.191 %)MSMQ
103 (0.191 %)Oracle Application Server
112 (0.127 %)WebLogic
121 (0.064 %)NetWeaver
121 (0.064 %)Documentum
121 (0.064 %)Adobe CQ
121 (0.064 %)FileNet
121 (0.064 %)WorkSite
IT Job Market, Applications CategoryApplications
1472 (29.99 %)MS Excel
248 (3.050 %)PowerPivot
331 (1.970 %)MS Office
424 (1.525 %)MS Visio
511 (0.699 %)Spreadsheet
610 (0.635 %)SPSS
77 (0.445 %)MS PowerPoint
82 (0.127 %)MS Project
91 (0.064 %)MATLAB
IT Job Market, Business Applications CategoryBusiness Applications
143 (2.732 %)Dynamics AX
236 (2.287 %)Cognos Business Intelligence
322 (1.398 %)Dynamics CRM
411 (0.699 %)Dynamics NAV
411 (0.699 %)Hyperion Planning
57 (0.445 %)Summit
65 (0.318 %)Front Arena
74 (0.254 %)Findur
74 (0.254 %)Global One
83 (0.191 %)Misys Equation
83 (0.191 %)SAP BPC
92 (0.127 %)Cognos Controller
92 (0.127 %)Oracle EBS
92 (0.127 %)HFM
101 (0.064 %)Visualfiles
101 (0.064 %)SAP Oil and Gas
101 (0.064 %)Oracle Applications
101 (0.064 %)Agresso
101 (0.064 %)SAP HR
101 (0.064 %)Endur
IT Job Market, Communications & Networking CategoryCommunications & Networking
129 (1.842 %)Internet
215 (0.953 %)SAN
310 (0.635 %)Intranet
45 (0.318 %)Broadband
45 (0.318 %)HTTP
52 (0.127 %)TCP/IP
52 (0.127 %)VoIP
52 (0.127 %)LDAP
52 (0.127 %)IMAP
61 (0.064 %)Extranet
IT Job Market, Database & Business Intelligence CategoryDatabase & Business Intelligence
11147 (72.87 %)SQL Server
2995 (63.21 %)Data Warehouse
3941 (59.78 %)SQL Server Reporting Services
4895 (56.86 %)SQL Server Integration Services
5863 (54.83 %)SQL Server Analysis Services
6762 (48.41 %)ETL
7576 (36.59 %)SQL Server 2008
8396 (25.16 %)Microsoft Analysis Services
9379 (24.08 %)Oracle OLAP
10372 (23.63 %)SQL Server 2005
11225 (14.29 %)OLTP
12208 (13.21 %)BusinessObjects
13143 (9.085 %)BusinessObjects Web Intelligence
14125 (7.942 %)BusinessObjects Data Services
15112 (7.116 %)BODI
16111 (7.052 %)Essbase
17107 (6.798 %)Data Mining
18106 (6.734 %)RDBMS
19103 (6.544 %)Crystal Reports
2094 (5.972 %)DataStage
IT Job Market, Development Applications CategoryDevelopment Applications
183 (5.273 %)Visual Studio
264 (4.066 %)ERwin
342 (2.668 %)Team Foundation Server
437 (2.351 %)Eclipse
528 (1.779 %)JUnit
621 (1.334 %)Maven
716 (1.017 %)VSS/SourceSafe
815 (0.953 %)NUnit
99 (0.572 %)Talend Open Studio
108 (0.508 %)Subversion
108 (0.508 %)JIRA
108 (0.508 %)Selenium
115 (0.318 %)Rational Rose
115 (0.318 %)Ant
124 (0.254 %)Oracle Forms
133 (0.191 %)CruiseControl
133 (0.191 %)MagicDraw
133 (0.191 %)TeamCity
133 (0.191 %)StructureMap
142 (0.127 %)GDB
IT Job Market, General CategoryGeneral
1347 (22.05 %)Finance
2125 (7.942 %)Banking
3102 (6.480 %)Marketing
477 (4.892 %)Retail
558 (3.685 %)Investment Banking
634 (2.160 %)Manufacturing
732 (2.033 %)Telecoms
732 (2.033 %)Front Office
826 (1.652 %)Pharmaceutical
826 (1.652 %)Games
826 (1.652 %)Advertising
914 (0.889 %)Law
1011 (0.699 %)Financial Institution
119 (0.572 %)General Ledger
126 (0.381 %)Back Office
135 (0.318 %)Russian Language
144 (0.254 %)Spanish Language
153 (0.191 %)Retail Banking
153 (0.191 %)Publishing
162 (0.127 %)Legal
IT Job Market, Job Titles CategoryJob Titles
1829 (52.67 %)Developer
2389 (24.71 %)Business Intelligence (BI) Developer
3229 (14.55 %)Consultant
4216 (13.72 %)SQL Developer
5164 (10.42 %)Business Intelligence (BI) Consultant
6161 (10.23 %)Analyst
6161 (10.23 %)Business Developer
7160 (10.17 %)Architect
8145 (9.212 %)Senior Developer
9118 (7.497 %)DBA
10115 (7.306 %)Business Consultant
1192 (5.845 %)SQL Server Developer
1288 (5.591 %)SQL DBA
1370 (4.447 %)Business Intelligence (BI) Architect
1465 (4.130 %)Team Leader
1563 (4.003 %)Business Architect
1654 (3.431 %)Senior Consultant
1751 (3.240 %).NET Developer
1850 (3.177 %)Data Warehouse (DWH) Developer
1949 (3.113 %)Database Developer
IT Job Market, Miscellaneous CategoryMiscellaneous
173 (4.638 %)Clustering
272 (4.574 %)Replication
357 (3.621 %)Computer Science
444 (2.795 %)Data Integration
540 (2.541 %)Management Information System
635 (2.224 %)Credit Risk
729 (1.842 %)Derivative
828 (1.779 %)Visualisation
921 (1.334 %)Mathematics
1018 (1.144 %)Big Data
1114 (0.889 %)RIA
1114 (0.889 %)NHS
1114 (0.889 %)Fixed Income
1213 (0.826 %)Economics
1312 (0.762 %)Foreign Exchange (FX)
1411 (0.699 %)Client/Server
1411 (0.699 %)Online Games
1411 (0.699 %)Statistics
1411 (0.699 %)Open Source
158 (0.508 %)Hedge funds
IT Job Market, Operating Systems CategoryOperating Systems
1193 (12.26 %)Windows
2102 (6.480 %)Linux
391 (5.781 %)UNIX
443 (2.732 %)Windows Server 2008
537 (2.351 %)Windows Server 2003
623 (1.461 %)Solaris
76 (0.381 %)FreeBSD
85 (0.318 %)MVS
93 (0.191 %)CentOS
102 (0.127 %)Windows 2000
111 (0.064 %)SUSE
111 (0.064 %)Red Hat Enterprise Linux
IT Job Market, Processes & Methodologies CategoryProcesses & Methodologies
11061 (67.41 %)Business Intelligence
2311 (19.76 %)Data Modelling
3188 (11.94 %)Dimensional Modelling
4146 (9.276 %)Project Management
5107 (6.798 %)CRM
695 (6.036 %)Data Management
794 (5.972 %)Migration
890 (5.718 %)Agile Software Development
979 (5.019 %)Data Analysis
1064 (4.066 %)OO
1162 (3.939 %)Scrum
1259 (3.748 %)Performance Management
1354 (3.431 %)ERP
1449 (3.113 %)Capacity Planning
1545 (2.859 %)Multidimensional Analysis
1643 (2.732 %)Change Management
1741 (2.605 %)E-Commerce
1741 (2.605 %)Stakeholder Management
1741 (2.605 %)Data Migration
1840 (2.541 %)Data Architecture
IT Job Market, Programming Languages CategoryProgramming Languages
11033 (65.63 %)SQL
2459 (29.16 %)T-SQL
3340 (21.60 %)C#
4184 (11.69 %)Java
5149 (9.466 %)PL/SQL
677 (4.892 %)VB
773 (4.638 %)JavaScript
853 (3.367 %)C++
853 (3.367 %)VB.NET
952 (3.304 %)VBA
1044 (2.795 %)C
1044 (2.795 %)PHP
1143 (2.732 %)VBScript
1143 (2.732 %)Shell Script
1241 (2.605 %)Perl
1336 (2.287 %)Python
1425 (1.588 %)R
1524 (1.525 %)Ruby
1623 (1.461 %)PowerHouse
1623 (1.461 %)Fortran
IT Job Market, Qualifications CategoryQualifications
1179 (11.37 %)Degree
238 (2.414 %)Microsoft Certification
324 (1.525 %)Security Cleared
418 (1.144 %)MCITP
515 (0.953 %)MCTS
612 (0.762 %)MCDBA
710 (0.635 %)ACCA
85 (0.318 %)ISEB
94 (0.254 %)IBM Certification
94 (0.254 %)ITIL Certification
103 (0.191 %)MBA
112 (0.127 %)SCWCD
112 (0.127 %)SCJP
112 (0.127 %)SCJD
112 (0.127 %)CIMA
112 (0.127 %)Sun Certification
112 (0.127 %)ISTQB
112 (0.127 %)SCJA
121 (0.064 %)SC Cleared
121 (0.064 %)PMI Certification
IT Job Market, Quality Assurance & Compliance CategoryQuality Assurance & Compliance
1130 (8.259 %)Data Quality
246 (2.922 %)QA
38 (0.508 %)ISO/IEC 27001
44 (0.254 %)ISO 9001
44 (0.254 %)SLA
52 (0.127 %)TickIT
61 (0.064 %)IAS 39
61 (0.064 %)Sarbanes-Oxley
IT Job Market, System Software CategorySystem Software
132 (2.033 %)Oracle RAC
224 (1.525 %)Oracle RMAN
312 (0.762 %)VMware Infrastructure
312 (0.762 %)Active Directory
45 (0.318 %)Hyper-V
52 (0.127 %)Xen
IT Job Market, Systems Management CategorySystems Management
128 (1.779 %)Oracle Enterprise Manager
226 (1.652 %)Data Guard
35 (0.318 %)ZABBIX
35 (0.318 %)Foglight
41 (0.064 %)Tivoli
IT Job Market, Vendors CategoryVendors
1695 (44.16 %)Microsoft
2379 (24.08 %)Oracle
3339 (21.54 %)Business Objects
4238 (15.12 %)SAP
5195 (12.39 %)Cognos
6135 (8.577 %)Informatica
7125 (7.942 %)MicroStrategy
8120 (7.624 %)IBM
999 (6.290 %)Hyperion
1093 (5.909 %)Netezza
1190 (5.718 %)Teradata
1280 (5.083 %)Ab Initio
1368 (4.320 %)NCR
1464 (4.066 %)Trillium
1464 (4.066 %)DATAllegro
1546 (2.922 %)DataFlux
1546 (2.922 %)Ascential
1641 (2.605 %)Sybase
1720 (1.271 %)Veritas
1816 (1.017 %)Google