The first 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 23 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Location
3 months to
23 Jul 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 375 419 304
Rank change year-on-year
+44 -115
Permanent jobs citing OLAP 768 582 936
As % of all permanent IT jobs located in the UK 0.66% 0.53% 0.79%
As % of the Database & Business Intelligence category 2.12% 1.71% 2.56%
Number of salaries quoted 657 501 811
Average salary £52,000 £50,000 £45,500
Average salary % change year-on-year
+4.00% +9.89%
90% offered a salary of more than £35,000 £32,500 £32,500
10% offered a salary of more than £70,000 £70,000 £70,000
UK excluding London average salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36182 34055 36608
As % of all permanent IT jobs located in the UK 31.11% 31.28% 31.04%
Number of salaries quoted 30951 29408 32311
Average salary £45,000 £42,500 £42,500
Average salary % change year-on-year
+5.88% -
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%

OLAP
Jobs Demand Trend

This 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 Jobs Demand Trend in the UK

OLAP
Salary Trend

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

OLAP Salary Trend in the UK

OLAP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLAP over the 3 months to 23 July 2014 within the UK.

OLAP Salary Histogram in the UK

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 23 July 2014. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +55 730 £52,500 +5.00% 76
London +66 429 £57,500 - 41
City of London +45 136 £60,000 -4.00% 20
South East +21 120 £51,750 +15.00% 14
West Midlands +51 67 £40,000 +8.10% 1
Staffordshire +32 43 £40,000 +21.21% 1
East of England -3 40 £40,500 -4.70% 4
Yorkshire -45 29 £35,000 - 7
Surrey +21 25 £52,000 +9.47% 1
Hampshire +18 23 £31,250 -17.76% 2
Berkshire 0 22 £55,000 - 5
North West -21 21 £40,000 -11.11% 5
Wales -2 18 £37,500 +15.38% 4
Southampton - 18 £31,250 - 1
Cambridgeshire +18 17 £40,500 -10.00% 2
West Yorkshire -45 17 £44,000 +21.37% 7
Burton-upon-Trent +11 16 £40,000 +21.21%
Suffolk +15 15 £40,000 -5.88%
Cardiff +2 15 £39,740 +44.50% 4
South Wales 0 15 £39,740 +22.27% 4
West Sussex +6 12 £75,000 +36.36% 3
North Yorkshire -5 12 £35,000 +16.66%
Kent -5 12 £42,500 - 1
Reading +8 11 £50,000 -4.76% 3
East Midlands -3 11 £55,000 +52.77% 5
South West -20 11 £45,000 -10.00% 1
Manchester -32 11 £47,500 - 2
Camberley - 11 £52,000 -
Crawley +24 10 £75,000 +35.74% 1
Buckinghamshire -5 10 £50,000 +50.37%

OLAP
Top 30 Related IT Skills

For the 6 months to 23 July 2014, 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.

1 1052 (70.99%) SQL
2 1048 (70.72%) Business Intelligence
3 1027 (69.30%) SQL Server
4 854 (57.62%) Data Warehouse
5 817 (55.13%) SQL Server Integration Services
6 787 (53.10%) SQL Server Reporting Services
7 765 (51.62%) ETL
8 757 (51.08%) SQL Server Analysis Services
9 556 (37.52%) Microsoft
10 470 (31.71%) T-SQL
11 427 (28.81%) Finance
12 399 (26.92%) SQL Server 2008
13 385 (25.98%) MS Excel
14 353 (23.82%) Oracle
15 351 (23.68%) Oracle OLAP
16 304 (20.51%) .NET
17 303 (20.45%) MDX
18 302 (20.38%) Data Modelling
19 246 (16.60%) C#
20 230 (15.52%) Relational Database
21 213 (14.37%) OLTP
22 212 (14.30%) Microsoft Analysis Services
23 211 (14.24%) Analytics
24 207 (13.97%) Degree
25 202 (13.63%) SQL Server 2012
26 189 (12.75%) Dimensional Modelling
27 174 (11.74%) Performance Tuning
28 169 (11.40%) Cognos
28 169 (11.40%) SQL Server 2005
29 160 (10.80%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 23 July 2014, 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.

Application Platforms
1 146 (9.85%) SharePoint
2 79 (5.33%) SAS
3 40 (2.70%) IIS
4 27 (1.82%) BizTalk Server
5 22 (1.48%) Tomcat
6 16 (1.08%) Apache
6 16 (1.08%) WebSphere
7 11 (0.74%) Oracle Application Server
8 9 (0.61%) Oracle 10gAS
9 8 (0.54%) FileNet
10 7 (0.47%) SharePoint Server
10 7 (0.47%) Oracle Workflow
11 6 (0.40%) SharePoint 2010
12 5 (0.34%) Apache Solr
12 5 (0.34%) WebLogic
13 4 (0.27%) NetWeaver
14 3 (0.20%) MS Exchange
15 2 (0.13%) Blackberry Enterprise Server
15 2 (0.13%) Oracle Coherence
15 2 (0.13%) SharePoint 2013
Applications
1 385 (25.98%) MS Excel
2 84 (5.67%) MS Office
3 52 (3.51%) PowerPivot
4 36 (2.43%) MS Project
5 18 (1.21%) MS PowerPoint
6 14 (0.94%) Spreadsheet
7 13 (0.88%) SPSS
8 9 (0.61%) MS Visio
9 6 (0.40%) FastStats
10 5 (0.34%) S-PLUS
11 3 (0.20%) Stata
Business Applications
1 59 (3.98%) Cognos Business Intelligence
2 51 (3.44%) Cognos TM1
3 20 (1.35%) HFM
4 15 (1.01%) Dynamics AX
5 14 (0.94%) Oracle EBS
6 12 (0.81%) Dynamics CRM
7 10 (0.67%) Hyperion Planning
8 5 (0.34%) Google Analytics
9 4 (0.27%) Summit
9 4 (0.27%) Siebel Analytics
9 4 (0.27%) Line 500
10 3 (0.20%) Dynamics NAV
11 2 (0.13%) SAP Oil and Gas
11 2 (0.13%) Oracle Financials
11 2 (0.13%) Adaptiv
11 2 (0.13%) Oracle CRM
11 2 (0.13%) Oracle ERP
11 2 (0.13%) Oracle Applications
11 2 (0.13%) Magento
11 2 (0.13%) Oracle Procure-to-Pay
Cloud Services
1 11 (0.74%) SaaS
2 9 (0.61%) Office 365
2 9 (0.61%) Amazon EC2
3 6 (0.40%) Microsoft Azure
3 6 (0.40%) Amazon AWS
4 1 (0.067%) Cloud Computing
Communications & Networking
1 32 (2.16%) Intranet
2 20 (1.35%) Internet
3 18 (1.21%) SAN
4 8 (0.54%) Extranet
5 7 (0.47%) ATM
6 6 (0.40%) LAN
6 6 (0.40%) WAN
6 6 (0.40%) DMZ
6 6 (0.40%) NAS
7 5 (0.34%) Firewall
8 4 (0.27%) iSCSI
8 4 (0.27%) Fibre Channel
9 3 (0.20%) InfiniBand
9 3 (0.20%) FCoE
9 3 (0.20%) DNS
9 3 (0.20%) Ethernet
9 3 (0.20%) FTP
9 3 (0.20%) PPP
10 2 (0.13%) TCP/IP
10 2 (0.13%) LDAP
Database & Business Intelligence
1 1027 (69.30%) SQL Server
2 854 (57.62%) Data Warehouse
3 817 (55.13%) SQL Server Integration Services
4 787 (53.10%) SQL Server Reporting Services
5 757 (51.08%) SQL Server Analysis Services
6 399 (26.92%) SQL Server 2008
7 351 (23.68%) Oracle OLAP
8 230 (15.52%) Relational Database
9 213 (14.37%) OLTP
10 212 (14.30%) Microsoft Analysis Services
11 202 (13.63%) SQL Server 2012
12 169 (11.40%) SQL Server 2005
13 150 (10.12%) RDBMS
14 130 (8.77%) Oracle Database
15 118 (7.96%) Data Mining
16 100 (6.75%) MySQL
16 100 (6.75%) Big Data
17 77 (5.20%) DTS
18 64 (4.32%) DB2
19 60 (4.05%) QlikView
Development Applications
1 50 (3.37%) Team Foundation Server
2 45 (3.04%) Visual Studio
3 26 (1.75%) Talend Open Studio
4 21 (1.42%) SQL Server Management Studio (SSMS)
5 20 (1.35%) JUnit
5 20 (1.35%) ERwin
6 19 (1.28%) Eclipse
7 18 (1.21%) Maven
8 16 (1.08%) Git (software)
9 14 (0.94%) Selenium
9 14 (0.94%) Visual Studio Team System
10 12 (0.81%) Oracle Forms
11 9 (0.61%) MorphX
11 9 (0.61%) Subversion
11 9 (0.61%) PVCS
12 7 (0.47%) Toad
12 7 (0.47%) Oracle APEX
12 7 (0.47%) NuGet
13 5 (0.34%) PowerDesigner
14 3 (0.20%) NUnit
General
1 427 (28.81%) Finance
2 121 (8.16%) Banking
3 72 (4.86%) Marketing
4 59 (3.98%) Games
5 55 (3.71%) Advertising
6 53 (3.58%) Retail
6 53 (3.58%) Investment Banking
7 46 (3.10%) Telecoms
8 29 (1.96%) Law
9 28 (1.89%) Legal
10 17 (1.15%) Publishing
11 16 (1.08%) Front Office
12 13 (0.88%) Pharmaceutical
13 11 (0.74%) Financial Institution
14 10 (0.67%) Back Office
15 7 (0.47%) Billing
15 7 (0.47%) Music Industry
16 6 (0.40%) International Banking
16 6 (0.40%) German Language
17 5 (0.34%) French Language
Job Titles
1 811 (54.72%) Developer
2 392 (26.45%) Business Intelligence Developer
3 239 (16.13%) SQL Developer
4 188 (12.69%) Analyst
5 160 (10.80%) Consultant
6 157 (10.59%) DBA
7 152 (10.26%) Business Developer
8 108 (7.29%) Senior Developer
9 97 (6.55%) Business Intelligence Consultant
10 94 (6.34%) Data Warehouse Developer
11 89 (6.01%) SQL Server Developer
12 85 (5.74%) SQL DBA
13 78 (5.26%) Business Intelligence Analyst
14 77 (5.20%) Architect
15 70 (4.72%) Administrator
16 53 (3.58%) Microsoft Developer
17 51 (3.44%) Business Analyst
18 46 (3.10%) Database Developer
19 43 (2.90%) SQL Server DBA
20 41 (2.77%) Analyst Developer
Libraries, Frameworks & Software Standards
1 304 (20.51%) .NET
2 303 (20.45%) MDX
3 134 (9.04%) XML
4 111 (7.49%) ASP.NET
5 88 (5.94%) Web Services
6 73 (4.93%) HTML
7 70 (4.72%) CSS
8 35 (2.36%) jQuery
9 30 (2.02%) ASP.NET MVC
10 25 (1.69%) Ajax
10 25 (1.69%) NHibernate
11 24 (1.62%) Spring
12 23 (1.55%) HTML5
13 22 (1.48%) CSS3
13 22 (1.48%) .NET Framework
14 21 (1.42%) WCF
15 20 (1.35%) OOXML
16 17 (1.15%) WPF
17 15 (1.01%) Castle Windsor
18 14 (0.94%) Razor View Engine
Miscellaneous
1 95 (6.41%) Computer Science
2 94 (6.34%) Management Information System
3 88 (5.94%) Replication
4 68 (4.59%) Clustering
5 64 (4.32%) Data Integration
6 52 (3.51%) Visualisation
7 33 (2.23%) Statistics
8 30 (2.02%) Mathematics
9 24 (1.62%) Online Games
10 22 (1.48%) Enterprise Software
11 20 (1.35%) Data Extraction
11 20 (1.35%) GIS
12 19 (1.28%) Data Conversion
12 19 (1.28%) Credit Risk
13 17 (1.15%) iPad
13 17 (1.15%) Client/Server
14 16 (1.08%) Hedge funds
14 16 (1.08%) Inversion of Control
15 13 (0.88%) Open Source
15 13 (0.88%) Kindle
Operating Systems
1 145 (9.78%) Windows
2 117 (7.89%) Linux
3 60 (4.05%) UNIX
4 27 (1.82%) Windows Server 2008
5 17 (1.15%) Android
6 16 (1.08%) Windows Server 2003
7 14 (0.94%) AIX
8 6 (0.40%) Oracle Linux
9 4 (0.27%) Solaris
9 4 (0.27%) Ubuntu
10 3 (0.20%) CentOS
10 3 (0.20%) Red Hat Enterprise Linux
11 2 (0.13%) Apple iOS
11 2 (0.13%) VMS
12 1 (0.067%) Windows 7
Processes & Methodologies
1 1048 (70.72%) Business Intelligence
2 765 (51.62%) ETL
3 302 (20.38%) Data Modelling
4 211 (14.24%) Analytics
5 189 (12.75%) Dimensional Modelling
6 174 (11.74%) Performance Tuning
7 160 (10.80%) Kimball Methodology
8 154 (10.39%) Agile Software Development
9 122 (8.23%) Data Management
10 120 (8.10%) Project Management
11 119 (8.03%) Scrum
12 93 (6.28%) Business Analysis
13 91 (6.14%) E-Commerce
14 83 (5.60%) Data Analysis
15 77 (5.20%) Data Architecture
16 74 (4.99%) CRM
17 67 (4.52%) OO
18 62 (4.18%) Migration
19 57 (3.85%) Performance Management
20 54 (3.64%) Change Management
Programming Languages
1 1052 (70.99%) SQL
2 470 (31.71%) T-SQL
3 246 (16.60%) C#
4 97 (6.55%) Java
5 93 (6.28%) PL/SQL
6 67 (4.52%) JavaScript
7 54 (3.64%) VBA
8 37 (2.50%) VB.NET
9 28 (1.89%) Data Mining Extensions (DMX)
10 27 (1.82%) Python
11 26 (1.75%) PowerShell
12 24 (1.62%) VB
13 22 (1.48%) Shell Script
14 20 (1.35%) PHP
15 15 (1.01%) R
16 12 (0.81%) C
17 9 (0.61%) Perl
17 9 (0.61%) X++
17 9 (0.61%) Data Analysis Expressions (DAX)
18 7 (0.47%) C++
Qualifications
1 207 (13.97%) Degree
2 83 (5.60%) Microsoft Certification
3 28 (1.89%) MCITP
4 22 (1.48%) MCAD
5 20 (1.35%) MCDBA
6 19 (1.28%) Security Cleared
7 14 (0.94%) MCTS
8 13 (0.88%) Oracle Certification
9 12 (0.81%) ITIL Certification
9 12 (0.81%) PMI Certification
10 9 (0.61%) ACCA
10 9 (0.61%) CIMA
11 6 (0.40%) MCSE
12 5 (0.34%) PhD
13 4 (0.27%) ISEB
13 4 (0.27%) ISTQB
13 4 (0.27%) MCSD
13 4 (0.27%) SAS Certification
14 3 (0.20%) HND
14 3 (0.20%) MCSA
Quality Assurance & Compliance
1 79 (5.33%) QA
2 22 (1.48%) ISO 9001
3 17 (1.15%) SLA
4 14 (0.94%) PCI DSS
5 10 (0.67%) Data Quality
6 9 (0.61%) TickIT
7 5 (0.34%) Sarbanes-Oxley
8 3 (0.20%) GAAP
8 3 (0.20%) ISO/IEC 27001
8 3 (0.20%) HL7
System Software
1 29 (1.96%) Oracle RAC
2 9 (0.61%) VMware Infrastructure
3 7 (0.47%) Active Directory
4 6 (0.40%) Oracle RMAN
5 5 (0.34%) HDFS
6 3 (0.20%) Hyper-V
7 2 (0.13%) XenApp
7 2 (0.13%) XenDesktop
7 2 (0.13%) VMware ESX
Systems Management
1 28 (1.89%) Data Guard
2 7 (0.47%) Oracle Enterprise Manager
3 5 (0.34%) Opscode Chef
4 3 (0.20%) Foglight
5 2 (0.13%) SCCM
5 2 (0.13%) OSSEC
5 2 (0.13%) Puppet
5 2 (0.13%) Red Hat Spacewalk
5 2 (0.13%) Nagios
6 1 (0.067%) Tivoli
Vendors
1 556 (37.52%) Microsoft
2 353 (23.82%) Oracle
3 169 (11.40%) Cognos
4 132 (8.91%) Business Objects
5 118 (7.96%) IBM
6 75 (5.06%) Informatica
7 70 (4.72%) SAP
8 62 (4.18%) MicroStrategy
9 57 (3.85%) Tableau
10 48 (3.24%) Teradata
11 44 (2.97%) Sybase
12 41 (2.77%) Netezza
13 28 (1.89%) Dundas
14 26 (1.75%) Talend
15 23 (1.55%) Hyperion
16 18 (1.21%) Sun
17 16 (1.08%) Vertica
18 14 (0.94%) Red Gate
18 14 (0.94%) JBoss
19 13 (0.88%) VMware
South East
Venturi
Salary: £50000 - £75000 per annum + 15% bonus + Benefits
Posted: 12 hours ago
Bradford, West Yorkshire
Fruition IT Resources Limited
Salary: £40000 - £50000 per annum + Benefits
Posted: 13 hours ago
Reading, Berkshire
Oxbridge Answers
Salary: 45-55k
Posted: 17 hours ago
West Yorkshire
ReThink Recruitment
Salary: £40000 - £50000.00 per annum + negotiable
Posted: 19 hours ago
London
Oliver Bernard
Salary: From £45,000 to £55,000 per annum + Excellent Benefits
Posted: Yesterday
Crawley, West Sussex
Connectus
Salary: £50000 - £60000 per annum + Benefits
Posted: Yesterday
Manchester, Lancashire
Adria Solutions Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: Yesterday
Kingston Upon Thames, Surrey
Steria
Salary: Up to £45,000 per annum
Posted: Yesterday
City, London
McGregor Boyall
Salary: £35000 - £50000 per annum
Posted: Yesterday
West Sussex
Oscar Associates (UK) Ltd
Salary: £25000 - £40000 per annum
Posted: Yesterday
Nottingham, Nottinghamshire
Oscar Associates (UK) Ltd
Salary: £35000 - £45000 per annum
Posted: Yesterday
City, London
Oliver James Associates
Salary: £50000 - £51000 per annum + pension
Posted: 2 days ago
Bradford, West Yorkshire
Harvey Nash plc
Salary: £40000 - £45000 per annum + + benefits
Posted: 2 days ago
London
TIMES Resources Ltd
Salary: benefits
Posted: 2 days ago
Staffordshire
Experis Ltd
Salary: Excellent Salary and Package
Posted: 2 days ago
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £40K + Excellent Benefits
Posted: 2 days ago
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £40K + Excellent Benefits
Posted: 2 days ago
London
Networking People
Posted: 2 days ago
City, London
Networking People
Posted: 2 days ago
Wakefield, West Yorkshire
Head Resourcing
Salary: £25000 - £30000 per annum + pension, healthcare, training
Posted: 2 days ago