The table below looks at the statistics 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 31 July 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
31 Jul 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 449 386 429
Rank change year-on-year
-63 +43
Permanent jobs citing OLAP 546 785 575
As % of all permanent IT jobs located in the UK 0.50% 0.67% 0.53%
As % of the Database & Business Intelligence category 1.61% 2.16% 1.68%
Number of salaries quoted 424 669 492
Average salary £50,000 £51,750 £50,000
Average salary % change year-on-year
-3.38% +3.50%
90% offered a salary of more than £32,500 £35,000 £32,500
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London average salary £40,500 £45,000 £43,000
% change year-on-year
-10.00% +4.65%

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised across the UK.

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
33874 36349 34169
As % of all permanent IT jobs located in the UK 30.93% 31.07% 31.43%
Number of salaries quoted 28558 31032 29440
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £42,500 £40,000 £39,000
% change year-on-year
+6.25% +2.56%

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 31 July 2015 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 31 July 2015. 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 -81 512 £50,000 -4.76% 88
London -119 223 £60,000 +4.34% 31
South East +4 127 £40,000 -21.18% 13
City of London -62 48 £57,500 -4.16% 13
Yorkshire +16 43 £45,000 +21.29% 9
West Midlands -45 35 £40,000 - 11
Hampshire +11 33 £36,250 +16.00% 4
Kent +25 29 £32,500 -23.52%
West Yorkshire +15 27 £45,000 +4.04% 4
Scotland +30 24 £47,500 +35.71% 2
East of England -10 24 £42,500 +4.93% 3
Berkshire +6 23 £54,000 -1.81% 6
North West -5 21 £38,250 -10.00% 13
Leeds +30 20 £42,500 -4.49% 4
Birmingham +8 19 £51,250 +2.50% 5
Maidstone - 16 £32,500 -
Manchester +9 15 £37,500 -26.82% 8
South West -8 15 £42,500 -5.55% 3
Stirling +8 13 - -
Cambridgeshire +8 13 £32,500 -19.75%
Portsmouth +32 12 £33,750 +3.84% 1
East Midlands +2 12 £42,500 -22.72% 3
West Sussex +2 10 £43,000 -42.66%
Surrey +1 10 £46,250 -11.05% 1
York +5 9 £32,000 -8.57% 2
North Yorkshire +1 9 £32,000 -8.57% 2
Derbyshire -2 9 £42,500 -22.72% 3
Midlands - 9 £50,000 -
Leatherhead +5 8 £40,750 -25.90%
Staffordshire -30 8 £38,500 -3.75% 1

OLAP
Top 30 Related IT Skills

For the 6 months to 31 July 2015, 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 864 (74.04%) Business Intelligence
2 815 (69.84%) SQL
3 674 (57.75%) SQL Server
4 664 (56.90%) Data Warehouse
5 604 (51.76%) ETL
6 599 (51.33%) SQL Server Integration Services
7 525 (44.99%) SQL Server Reporting Services
8 485 (41.56%) SQL Server Analysis Services
9 437 (37.45%) Microsoft
10 379 (32.48%) Oracle
11 348 (29.82%) Finance
12 344 (29.48%) Oracle OLAP
13 318 (27.25%) Data Modelling
14 315 (26.99%) T-SQL
15 308 (26.39%) OLAP Cube
16 264 (22.62%) Agile Software Development
17 235 (20.14%) MS Excel
18 224 (19.19%) Analytics
19 218 (18.68%) Analytical Skills
20 181 (15.51%) Oracle Database
21 178 (15.25%) SQL Server 2008
22 177 (15.17%) Performance Tuning
23 174 (14.91%) MDX
24 158 (13.54%) OLTP
25 152 (13.02%) Degree
26 148 (12.68%) PL/SQL
27 142 (12.17%) Relational Database
28 135 (11.57%) .NET
29 132 (11.31%) Kimball Methodology
30 129 (11.05%) C#

OLAP
Top Related IT Skills by Category

For the 6 months to 31 July 2015, 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 99 (8.48%) SharePoint
2 82 (7.03%) SAS
3 48 (4.11%) IIS
4 42 (3.60%) Apache
5 32 (2.74%) WebLogic
6 26 (2.23%) Tomcat
7 20 (1.71%) Apache Spark
8 18 (1.54%) WebSphere
9 17 (1.46%) BizTalk Server
9 17 (1.46%) Oracle HTTP Server
10 15 (1.29%) SharePoint 2013
11 14 (1.20%) SharePoint 2010
12 13 (1.11%) JBoss
13 11 (0.94%) Oracle Workflow
14 9 (0.77%) Oracle Coherence
15 8 (0.69%) Node.js
16 6 (0.51%) WebSphere Application Server
17 5 (0.43%) IBM HTTP Server
17 5 (0.43%) WebSphere Process Server
17 5 (0.43%) Commerce Server
Applications
1 235 (20.14%) MS Excel
2 72 (6.17%) PowerPivot
3 37 (3.17%) SPSS
4 20 (1.71%) MS Office
5 17 (1.46%) MS Visio
6 3 (0.26%) MS Project
7 2 (0.17%) Spreadsheet
8 1 (0.086%) MS PowerPoint
8 1 (0.086%) Gephi
Business Applications
1 33 (2.83%) Oracle ERP
2 30 (2.57%) HFM
3 24 (2.06%) Oracle EBS
4 19 (1.63%) Dynamics AX
5 13 (1.11%) Dynamics CRM
6 12 (1.03%) Oracle EBS R12
7 11 (0.94%) Cognos Business Intelligence
7 11 (0.94%) Cognos TM1
8 10 (0.86%) RMDS
8 10 (0.86%) Hyperion Planning
9 8 (0.69%) Oracle Applications
10 5 (0.43%) Dynamics NAV
10 5 (0.43%) SAP BPC
11 4 (0.34%) SAP Oil and Gas
12 2 (0.17%) Cognos Controller
12 2 (0.17%) Oracle Financials
12 2 (0.17%) WebTrends
12 2 (0.17%) ION MarketView
13 1 (0.086%) Unica
13 1 (0.086%) Siebel Analytics
Cloud Services
1 25 (2.14%) Microsoft Azure
2 16 (1.37%) Amazon AWS
3 9 (0.77%) Cloud Computing
4 2 (0.17%) Google Analytics
4 2 (0.17%) SmartFocus
4 2 (0.17%) Office 365
4 2 (0.17%) IaaS
4 2 (0.17%) Amazon EMR
5 1 (0.086%) Adobe Analytics
5 1 (0.086%) SaaS
Communications & Networking
1 27 (2.31%) HTTP
2 17 (1.46%) SAN
2 17 (1.46%) NAS
3 15 (1.29%) LAN
3 15 (1.29%) WAN
4 12 (1.03%) FCoE
4 12 (1.03%) Fibre Channel
4 12 (1.03%) Multicast
5 10 (0.86%) LDAP
6 9 (0.77%) TCP/IP
6 9 (0.77%) Internet
7 6 (0.51%) DNS
7 6 (0.51%) Firewall
7 6 (0.51%) Cisco IOS
7 6 (0.51%) iSCSI
8 5 (0.43%) BIG-IP
8 5 (0.43%) F5 BIG-IP LTM
8 5 (0.43%) F5 BIG-IP GTM
9 4 (0.34%) DMZ
9 4 (0.34%) WebEx
Database & Business Intelligence
1 674 (57.75%) SQL Server
2 664 (56.90%) Data Warehouse
3 599 (51.33%) SQL Server Integration Services
4 525 (44.99%) SQL Server Reporting Services
5 485 (41.56%) SQL Server Analysis Services
6 344 (29.48%) Oracle OLAP
7 308 (26.39%) OLAP Cube
8 181 (15.51%) Oracle Database
9 178 (15.25%) SQL Server 2008
10 158 (13.54%) OLTP
11 142 (12.17%) Relational Database
12 123 (10.54%) Data Mining
13 119 (10.20%) SQL Server 2012
14 118 (10.11%) Big Data
15 117 (10.03%) BusinessObjects
16 107 (9.17%) Oracle Database 11g
17 102 (8.74%) Oracle BI EE
18 99 (8.48%) QlikView
19 96 (8.23%) Hadoop
20 80 (6.86%) Oracle Reports
Development Applications
1 38 (3.26%) Team Foundation Server
2 28 (2.40%) Toad
3 20 (1.71%) Subversion
4 17 (1.46%) Visual Studio
5 16 (1.37%) PowerDesigner
5 16 (1.37%) Maven
6 15 (1.29%) TeamCity
7 14 (1.20%) Oracle Forms
8 12 (1.03%) SQL Server Management Studio (SSMS)
9 8 (0.69%) Moq
9 8 (0.69%) NUnit
10 6 (0.51%) Git (software)
10 6 (0.51%) VSS/SourceSafe
10 6 (0.51%) Ant
10 6 (0.51%) JUnit
10 6 (0.51%) Talend Open Studio
11 5 (0.43%) ERwin
11 5 (0.43%) JIRA
12 4 (0.34%) Jenkins
13 2 (0.17%) CruiseControl
General
1 348 (29.82%) Finance
2 86 (7.37%) Banking
3 77 (6.60%) Retail
4 52 (4.46%) Marketing
5 36 (3.08%) Investment Banking
6 33 (2.83%) Front Office
7 28 (2.40%) Telecoms
8 24 (2.06%) Advertising
9 17 (1.46%) Legal
10 16 (1.37%) Manufacturing
11 14 (1.20%) Games
12 12 (1.03%) Law
13 10 (0.86%) Back Office
14 7 (0.60%) Automotive
14 7 (0.60%) Billing
15 5 (0.43%) General Ledger
15 5 (0.43%) Publishing
16 4 (0.34%) Electronics
16 4 (0.34%) Pharmaceutical
17 2 (0.17%) Retail Banking
Job Titles
1 622 (53.30%) Developer
2 330 (28.28%) Business Intelligence Developer
3 173 (14.82%) Analyst
4 143 (12.25%) Consultant
5 131 (11.23%) SQL Developer
6 130 (11.14%) Senior Developer
7 116 (9.94%) Business Intelligence Consultant
8 112 (9.60%) Business Developer
9 84 (7.20%) Architect
10 80 (6.86%) DBA
11 77 (6.60%) Business Intelligence Analyst
12 63 (5.40%) Analyst Developer
13 53 (4.54%) MI Analyst
14 52 (4.46%) Oracle Developer
15 51 (4.37%) Business Analyst
15 51 (4.37%) SQL DBA
16 47 (4.03%) Business Consultant
17 40 (3.43%) Business Intelligence Manager
18 37 (3.17%) Administrator
19 36 (3.08%) Microsoft Consultant
Libraries, Frameworks & Software Standards
1 174 (14.91%) MDX
2 135 (11.57%) .NET
3 84 (7.20%) XML
4 69 (5.91%) Web Services
5 56 (4.80%) HTML
6 43 (3.68%) ASP.NET
7 40 (3.43%) CSS
8 25 (2.14%) JMS
9 24 (2.06%) Middleware
9 24 (2.06%) Spring
10 21 (1.80%) XSLT
11 20 (1.71%) Hibernate
12 19 (1.63%) jQuery
12 19 (1.63%) JPA
12 19 (1.63%) ASP.NET MVC
13 17 (1.46%) HTML5
13 17 (1.46%) Ajax
13 17 (1.46%) J2EE
14 16 (1.37%) Oracle GoldenGate
15 14 (1.20%) Spring Integration
Miscellaneous
1 218 (18.68%) Analytical Skills
2 103 (8.83%) Visualisation
3 80 (6.86%) Data Integration
4 68 (5.83%) Data Structures
5 66 (5.66%) Management Information System
6 65 (5.57%) Computer Science
7 50 (4.28%) Replication
8 38 (3.26%) Statistics
9 30 (2.57%) Data Conversion
10 27 (2.31%) Enterprise Software
11 21 (1.80%) Data Extraction
11 21 (1.80%) N-Tier
12 20 (1.71%) Mathematics
13 17 (1.46%) Clustering
13 17 (1.46%) Oracle Exalogic
14 14 (1.20%) Hedge funds
15 11 (0.94%) Oracle Exalytics
15 11 (0.94%) Economics
16 10 (0.86%) Credit Risk
17 8 (0.69%) Cybercrime
Operating Systems
1 103 (8.83%) Windows
2 91 (7.80%) UNIX
3 79 (6.77%) Linux
4 11 (0.94%) Solaris
4 11 (0.94%) Windows Server 2008
5 8 (0.69%) Android
6 6 (0.51%) Red Hat Enterprise Linux
7 5 (0.43%) CentOS
7 5 (0.43%) Windows Server 2012
7 5 (0.43%) SUSE Linux Enterprise Server
7 5 (0.43%) AIX
7 5 (0.43%) SUSE
7 5 (0.43%) Debian
7 5 (0.43%) Ubuntu
8 4 (0.34%) Apple iOS
9 1 (0.086%) Windows 8
9 1 (0.086%) Windows 7
9 1 (0.086%) Windows Server 2003
Processes & Methodologies
1 864 (74.04%) Business Intelligence
2 604 (51.76%) ETL
3 318 (27.25%) Data Modelling
4 264 (22.62%) Agile Software Development
5 224 (19.19%) Analytics
6 177 (15.17%) Performance Tuning
7 132 (11.31%) Kimball Methodology
8 102 (8.74%) Data Analysis
9 94 (8.05%) Project Management
10 79 (6.77%) Scrum
11 77 (6.60%) ERP
11 77 (6.60%) Data Architecture
12 64 (5.48%) Data Management
13 63 (5.40%) Dashboard Development
14 62 (5.31%) OO
15 56 (4.80%) Dimensional Modelling
16 52 (4.46%) CRM
17 51 (4.37%) Migration
18 48 (4.11%) ETL Development
19 47 (4.03%) Unit Testing
Programming Languages
1 815 (69.84%) SQL
2 315 (26.99%) T-SQL
3 148 (12.68%) PL/SQL
4 129 (11.05%) C#
5 126 (10.80%) Java
6 67 (5.74%) JavaScript
7 54 (4.63%) Shell Script
8 41 (3.51%) VBA
9 33 (2.83%) R
10 25 (2.14%) Python
11 24 (2.06%) VB.NET
12 21 (1.80%) VB
12 21 (1.80%) PowerShell
13 16 (1.37%) C
14 12 (1.03%) Data Analysis Expressions (DAX)
15 9 (0.77%) ANSI SQL
16 8 (0.69%) Bash Shell
17 7 (0.60%) Perl
18 6 (0.51%) PHP
18 6 (0.51%) X++
Qualifications
1 152 (13.02%) Degree
2 26 (2.23%) Oracle Certification
3 24 (2.06%) Microsoft Certification
4 22 (1.89%) Security Cleared
5 19 (1.63%) OCP
6 15 (1.29%) SC Cleared
7 9 (0.77%) MCDBA
8 7 (0.60%) MCITP
9 4 (0.34%) HND
10 3 (0.26%) MCP
10 3 (0.26%) MCAD
10 3 (0.26%) PMI Certification
11 2 (0.17%) IBM Certification
11 2 (0.17%) MBA
11 2 (0.17%) PMP
11 2 (0.17%) PhD
12 1 (0.086%) MCSD
12 1 (0.086%) MCSE
Quality Assurance & Compliance
1 35 (3.00%) QA
2 5 (0.43%) SLA
2 5 (0.43%) ISO/IEC 27001
3 2 (0.17%) PCI DSS
3 2 (0.17%) Data Quality
4 1 (0.086%) Sarbanes-Oxley
System Software
1 19 (1.63%) VMware Infrastructure
2 13 (1.11%) Oracle RAC
3 12 (1.03%) NFS
3 12 (1.03%) SRDF
4 7 (0.60%) Active Directory
5 5 (0.43%) VMware Server
5 5 (0.43%) Xen
5 5 (0.43%) XenServer
5 5 (0.43%) vSphere
5 5 (0.43%) VMware ESXi
5 5 (0.43%) pfSense
5 5 (0.43%) KVM
6 4 (0.34%) VMware ESX
7 1 (0.086%) Hyper-V
7 1 (0.086%) Docker
7 1 (0.086%) HDFS
Systems Management
1 5 (0.43%) Data Guard
2 4 (0.34%) SCCM
3 1 (0.086%) SCVMM
3 1 (0.086%) Puppet
Vendors
1 437 (37.45%) Microsoft
2 379 (32.48%) Oracle
3 112 (9.60%) Tableau
4 100 (8.57%) Cognos
4 100 (8.57%) Informatica
5 93 (7.97%) SAP
6 85 (7.28%) IBM
7 71 (6.08%) Hyperion
8 47 (4.03%) MicroStrategy
9 39 (3.34%) Teradata
10 37 (3.17%) Ab Initio
11 33 (2.83%) Sybase
11 33 (2.83%) Vertica
12 28 (2.40%) DataFlux
13 21 (1.80%) Netezza
14 19 (1.63%) VMware
15 18 (1.54%) Cisco
16 15 (1.29%) Hitachi
17 13 (1.11%) NetApp
18 12 (1.03%) EMC
UK
Lawrence Harvey Enterprise
Salary: £65000 - £75000 per annum
Posted: 6 hours ago
London
Lawrence Harvey Enterprise
Salary: £65000.00 - £75000 per annum
Posted: 7 hours ago
City, London
Lawrence Harvey Enterprise
Salary: £55000.00 - £80000 per annum + 20% Bonus
Posted: 7 hours ago
Manchester, Lancashire
Churchill Frank
Salary: £40000 - £45000 per annum + Pension + Bonus + Training
Posted: 20 hours ago
London
Digitech Resourcing Ltd
Salary: From £40,000 to £45,000 per annum + Benefits
Posted: 21 hours ago
Chesterfield, Derbyshire
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £55000.00 per annum + Benefits package
Posted: 22 hours ago
Essex
Ashdown IT
Salary: £50000 - £60000 per annum
Posted: 22 hours ago
Manchester, Lancashire
Rullion IT Plus
Salary: £35000 - £50000 per annum + Benefits
Posted: Yesterday
Preston, Lancashire
Rullion IT Plus
Salary: £35000 - £50000 per annum + Benefits
Posted: Yesterday
Liverpool, Merseyside
Rullion IT Plus
Salary: £35000 - £50000 per annum + Benefits
Posted: Yesterday
North London
Senitor Associates
Salary: £40000 - £50000 per annum
Posted: Yesterday
Portsmouth, Hampshire
Redrock Consulting Ltd
Salary: £30000 - £40000 per annum + Career Progression
Posted: Yesterday
London
Nicoll Curtin Technology
Salary: Bonus + Benefits
Posted: Yesterday
City, London
Deerfoot IT Resources Ltd
Salary: £65000 - £72000 per annum + Banking bonus
Posted: Yesterday
Bedford, Bedfordshire
Cooper Lomaz Recruitment Ltd
Salary: Dependant on Experience
Posted: 2 days ago
London
Exposed Solutions
Salary: £50000 - £70000 per annum, Benefits Excellent Benefits & Bonus
Posted: 2 days ago
London
Exposed Solutions
Salary: £55000 - £65000 per annum
Posted: 2 days ago
London
C4 Commerce
Salary: From £40,000 to £45,000 per annum 15% Bonus and benefit package
Posted: 2 days ago
UK
Ashdown IT
Salary: £50000 - £60000 per annum
Posted: 2 days ago
City, London
Benedict Cole Limited
Salary: £70000 - £75000 per annum + benefits
Posted: 3 days ago