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 4 September 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
4 Sep 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 470 384 405
Rank change year-on-year
-86 +21
Permanent jobs citing OLAP 525 752 612
As % of all permanent IT jobs located in the UK 0.48% 0.66% 0.58%
As % of the Database & Business Intelligence category 1.59% 2.14% 1.83%
Number of salaries quoted 395 643 517
Average salary £50,000 £51,250 £50,000
Average salary % change year-on-year
-2.43% +2.50%
90% offered a salary of more than £34,700 £35,000 £32,500
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £42,500 £45,000 £40,000
% change year-on-year
-5.55% +12.50%

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
33119 35117 33446
As % of all permanent IT jobs located in the UK 30.36% 30.79% 31.70%
Number of salaries quoted 28081 29579 28849
Average salary £47,500 £45,000 £45,000
Average salary % change year-on-year
+5.55% -
90% offered a salary of more than £32,500 £30,000 £30,000
10% offered a salary of more than £72,500 £65,000 £67,500
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

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 4 September 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 4 September 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 -87 493 £50,000 -4.76% 97
London -103 243 £57,500 +4.54% 32
South East +16 115 £40,500 -22.11% 11
City of London -51 50 £61,250 -2.00% 10
West Midlands -17 44 £40,000 +5.26% 8
Yorkshire +13 32 £45,000 +20.64% 9
Hampshire +33 29 £36,250 +16.00% 1
Birmingham +21 25 £41,250 -2.94% 4
Scotland +28 24 £47,500 -40.62% 1
West Yorkshire +9 24 £45,000 +5.88% 7
Berkshire +14 20 £40,000 -27.27% 3
North West -18 20 £40,000 -17.94% 19
Leeds +20 17 £42,500 -1.73% 4
Manchester -6 16 £40,000 -20.00% 14
Stirling - 14 - -
East Sussex +29 13 £50,000 - 2
Surrey -9 13 £45,000 -10.00% 2
South West -16 13 £51,250 +13.88% 7
Kent -6 12 £22,500 -47.05%
East of England -23 12 £42,500 +2.40% 2
Brighton - 12 £50,000 - 2
Buckinghamshire -5 10 £43,250 -13.50% 1
West Sussex -15 10 £46,250 -38.33%
Milton Keynes -10 9 £42,500 -15.00% 1
East Midlands -2 8 £43,750 +6.06% 9
Staffordshire -29 8 £38,500 -3.75% 2
Portsmouth - 8 £32,500 -
Leatherhead - 8 £40,750 -
Bracknell +20 7 £37,500 -31.81%
Kingston Upon Thames +11 6 £53,000 +20.45%

OLAP
Top 30 Related IT Skills

For the 6 months to 4 September 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 818 (72.45%) Business Intelligence
2 816 (72.28%) SQL
3 641 (56.78%) SQL Server
4 634 (56.16%) Data Warehouse
5 604 (53.50%) SQL Server Integration Services
6 540 (47.83%) ETL
7 522 (46.24%) SQL Server Reporting Services
8 484 (42.87%) SQL Server Analysis Services
9 442 (39.15%) Microsoft
10 328 (29.05%) T-SQL
11 317 (28.08%) Finance
12 314 (27.81%) Oracle
13 306 (27.10%) OLAP Cube
14 286 (25.33%) Oracle OLAP
15 276 (24.45%) Data Modelling
16 262 (23.21%) Agile Software Development
17 242 (21.43%) MS Excel
18 207 (18.33%) Analytics
19 203 (17.98%) Analytical Skills
20 188 (16.65%) MDX
21 180 (15.94%) SQL Server 2008
22 179 (15.85%) Performance Tuning
23 178 (15.77%) OLTP
24 147 (13.02%) Degree
25 142 (12.58%) Relational Database
26 141 (12.49%) .NET
27 135 (11.96%) Oracle Database
28 133 (11.78%) PL/SQL
29 127 (11.25%) C#
29 127 (11.25%) Java

OLAP
Top Related IT Skills by Category

For the 6 months to 4 September 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 89 (7.88%) SAS
2 88 (7.79%) SharePoint
3 53 (4.69%) IIS
4 42 (3.72%) Apache
5 27 (2.39%) Apache Spark
6 26 (2.30%) Tomcat
7 22 (1.95%) WebLogic
8 18 (1.59%) WebSphere
9 17 (1.51%) Oracle HTTP Server
10 14 (1.24%) SharePoint 2013
11 13 (1.15%) JBoss
11 13 (1.15%) BizTalk Server
12 12 (1.06%) GemFire
13 10 (0.89%) SharePoint 2010
14 9 (0.80%) Node.js
15 8 (0.71%) Oracle Coherence
16 6 (0.53%) WebSphere Application Server
17 5 (0.44%) Commerce Server
17 5 (0.44%) Joomla!
17 5 (0.44%) Oracle Workflow
Applications
1 242 (21.43%) MS Excel
2 70 (6.20%) PowerPivot
3 31 (2.75%) SPSS
4 22 (1.95%) MS Office
5 14 (1.24%) MS Visio
6 3 (0.27%) MS Project
7 2 (0.18%) Spreadsheet
8 1 (0.089%) MS PowerPoint
8 1 (0.089%) Gephi
Business Applications
1 21 (1.86%) HFM
1 21 (1.86%) Dynamics AX
2 18 (1.59%) Oracle ERP
3 17 (1.51%) Cognos Business Intelligence
4 11 (0.97%) Oracle EBS
5 9 (0.80%) Dynamics CRM
6 8 (0.71%) Oracle Applications
7 7 (0.62%) Cognos TM1
7 7 (0.62%) Hyperion Planning
7 7 (0.62%) SAP BPC
8 6 (0.53%) RMDS
9 4 (0.35%) SAP Oil and Gas
10 3 (0.27%) Oracle EBS R12
11 2 (0.18%) Dynamics NAV
11 2 (0.18%) WebTrends
12 1 (0.089%) Primavera
12 1 (0.089%) Hyperion Enterprise
12 1 (0.089%) ION MarketView
12 1 (0.089%) Oracle BPM
12 1 (0.089%) Sage CRM
Cloud Services
1 40 (3.54%) Microsoft Azure
2 22 (1.95%) Amazon AWS
3 9 (0.80%) Cloud Computing
4 6 (0.53%) Office 365
5 4 (0.35%) IaaS
5 4 (0.35%) Amazon EMR
6 2 (0.18%) Google Analytics
6 2 (0.18%) SaaS
6 2 (0.18%) SmartFocus
Communications & Networking
1 28 (2.48%) HTTP
2 17 (1.51%) LAN
2 17 (1.51%) WAN
3 13 (1.15%) TCP/IP
3 13 (1.15%) SAN
3 13 (1.15%) NAS
4 12 (1.06%) FCoE
4 12 (1.06%) Fibre Channel
4 12 (1.06%) Multicast
5 10 (0.89%) LDAP
6 9 (0.80%) Internet
7 8 (0.71%) Firewall
8 6 (0.53%) Cisco IOS
8 6 (0.53%) iSCSI
9 5 (0.44%) BIG-IP
9 5 (0.44%) F5 BIG-IP LTM
9 5 (0.44%) F5 BIG-IP GTM
10 4 (0.35%) DMZ
10 4 (0.35%) WebEx
11 3 (0.27%) DNS
Database & Business Intelligence
1 641 (56.78%) SQL Server
2 634 (56.16%) Data Warehouse
3 604 (53.50%) SQL Server Integration Services
4 522 (46.24%) SQL Server Reporting Services
5 484 (42.87%) SQL Server Analysis Services
6 306 (27.10%) OLAP Cube
7 286 (25.33%) Oracle OLAP
8 180 (15.94%) SQL Server 2008
9 178 (15.77%) OLTP
10 142 (12.58%) Relational Database
11 135 (11.96%) Oracle Database
12 124 (10.98%) SQL Server 2012
13 113 (10.01%) Big Data
14 106 (9.39%) Data Mining
15 102 (9.03%) BusinessObjects
16 98 (8.68%) Hadoop
17 94 (8.33%) Oracle Database 11g
18 79 (7.00%) QlikView
19 67 (5.93%) Microsoft Analysis Services
20 66 (5.85%) Oracle BI EE
Development Applications
1 43 (3.81%) Team Foundation Server
2 25 (2.21%) Maven
3 21 (1.86%) Visual Studio
4 20 (1.77%) Subversion
5 18 (1.59%) Toad
6 15 (1.33%) TeamCity
7 14 (1.24%) Git (software)
8 12 (1.06%) PowerDesigner
8 12 (1.06%) Jenkins
8 12 (1.06%) SQL Server Management Studio (SSMS)
9 11 (0.97%) JIRA
10 9 (0.80%) NUnit
10 9 (0.80%) Moq
11 8 (0.71%) Oracle Forms
12 7 (0.62%) ERwin
12 7 (0.62%) JUnit
13 6 (0.53%) Ant
13 6 (0.53%) VSS/SourceSafe
14 5 (0.44%) Talend Open Studio
15 2 (0.18%) ClearCase
General
1 317 (28.08%) Finance
2 101 (8.95%) Banking
3 77 (6.82%) Retail
4 40 (3.54%) Marketing
5 39 (3.45%) Investment Banking
6 27 (2.39%) Advertising
6 27 (2.39%) Front Office
7 24 (2.13%) Telecoms
8 17 (1.51%) Legal
9 16 (1.42%) Manufacturing
10 12 (1.06%) Games
11 9 (0.80%) Back Office
12 7 (0.62%) Law
12 7 (0.62%) Billing
13 6 (0.53%) Automotive
14 5 (0.44%) Pharmaceutical
14 5 (0.44%) Financial Institution
15 4 (0.35%) Electronics
15 4 (0.35%) Publishing
16 2 (0.18%) General Ledger
Job Titles
1 631 (55.89%) Developer
2 343 (30.38%) Business Intelligence Developer
3 171 (15.15%) Analyst
4 150 (13.29%) SQL Developer
5 132 (11.69%) Senior Developer
6 112 (9.92%) Business Developer
7 94 (8.33%) Consultant
8 88 (7.79%) DBA
9 82 (7.26%) Business Intelligence Analyst
10 76 (6.73%) Business Intelligence Consultant
11 70 (6.20%) Architect
12 61 (5.40%) Business Analyst
13 50 (4.43%) Analyst Developer
13 50 (4.43%) MI Analyst
14 48 (4.25%) Oracle Developer
15 47 (4.16%) SQL DBA
16 37 (3.28%) Business Consultant
17 35 (3.10%) Administrator
18 34 (3.01%) SQL Server Developer
19 33 (2.92%) Team Leader
Libraries, Frameworks & Software Standards
1 188 (16.65%) MDX
2 141 (12.49%) .NET
3 67 (5.93%) XML
4 63 (5.58%) Web Services
5 56 (4.96%) HTML
6 44 (3.90%) CSS
7 36 (3.19%) ASP.NET
8 33 (2.92%) JMS
8 33 (2.92%) Spring
9 24 (2.13%) Middleware
10 20 (1.77%) jQuery
11 18 (1.59%) XSLT
12 17 (1.51%) Ajax
13 16 (1.42%) Hibernate
13 16 (1.42%) ASP.NET MVC
14 15 (1.33%) JPA
14 15 (1.33%) Oracle GoldenGate
15 14 (1.24%) Spring Integration
15 14 (1.24%) HTML5
15 14 (1.24%) XSL
Miscellaneous
1 203 (17.98%) Analytical Skills
2 100 (8.86%) Visualisation
3 67 (5.93%) Data Integration
4 65 (5.76%) Computer Science
5 59 (5.23%) Management Information System
6 58 (5.14%) Replication
7 55 (4.87%) Data Structures
8 45 (3.99%) Statistics
9 30 (2.66%) Mathematics
10 25 (2.21%) Enterprise Software
11 23 (2.04%) Credit Risk
12 22 (1.95%) Data Extraction
12 22 (1.95%) Clustering
12 22 (1.95%) N-Tier
13 18 (1.59%) Data Conversion
14 13 (1.15%) Hedge funds
15 12 (1.06%) Market Risk
16 10 (0.89%) Economics
17 9 (0.80%) Client/Server
17 9 (0.80%) Oracle Exalogic
Operating Systems
1 108 (9.57%) Windows
2 88 (7.79%) Linux
3 68 (6.02%) UNIX
4 15 (1.33%) Windows Server 2008
5 11 (0.97%) Solaris
6 7 (0.62%) Red Hat Enterprise Linux
7 5 (0.44%) CentOS
7 5 (0.44%) AIX
7 5 (0.44%) SUSE
7 5 (0.44%) Debian
7 5 (0.44%) Ubuntu
7 5 (0.44%) Windows Server 2012
7 5 (0.44%) SUSE Linux Enterprise Server
8 4 (0.35%) Android
9 2 (0.18%) Apple iOS
10 1 (0.089%) Windows 8
10 1 (0.089%) Windows 7
10 1 (0.089%) Windows Server 2003
Processes & Methodologies
1 818 (72.45%) Business Intelligence
2 540 (47.83%) ETL
3 276 (24.45%) Data Modelling
4 262 (23.21%) Agile Software Development
5 207 (18.33%) Analytics
6 179 (15.85%) Performance Tuning
7 122 (10.81%) Kimball Methodology
8 100 (8.86%) Data Analysis
9 82 (7.26%) Project Management
10 68 (6.02%) Scrum
11 63 (5.58%) Migration
11 63 (5.58%) Data Management
11 63 (5.58%) Dimensional Modelling
12 61 (5.40%) Dashboard Development
13 56 (4.96%) Data Architecture
14 54 (4.78%) OO
15 47 (4.16%) CRM
15 47 (4.16%) ERP
16 44 (3.90%) TDD
17 43 (3.81%) Continuous Improvement
Programming Languages
1 816 (72.28%) SQL
2 328 (29.05%) T-SQL
3 133 (11.78%) PL/SQL
4 127 (11.25%) C#
4 127 (11.25%) Java
5 66 (5.85%) JavaScript
6 44 (3.90%) VBA
7 35 (3.10%) Shell Script
8 33 (2.92%) VB.NET
9 29 (2.57%) R
10 25 (2.21%) Python
11 24 (2.13%) VB
12 21 (1.86%) C
13 20 (1.77%) PowerShell
14 17 (1.51%) Data Analysis Expressions (DAX)
15 9 (0.80%) Bash Shell
15 9 (0.80%) Perl
16 6 (0.53%) PHP
16 6 (0.53%) X++
17 5 (0.44%) Korn
Qualifications
1 147 (13.02%) Degree
2 29 (2.57%) Oracle Certification
3 25 (2.21%) Microsoft Certification
4 19 (1.68%) OCP
5 15 (1.33%) Security Cleared
6 8 (0.71%) MCDBA
7 7 (0.62%) SC Cleared
8 6 (0.53%) MCITP
9 4 (0.35%) IBM Certification
10 3 (0.27%) MCAD
10 3 (0.27%) APMP
11 2 (0.18%) HND
11 2 (0.18%) MCP
11 2 (0.18%) MBA
12 1 (0.089%) ACCA
12 1 (0.089%) CIMA
12 1 (0.089%) PMI Certification
12 1 (0.089%) MCSE
12 1 (0.089%) MCSD
12 1 (0.089%) PhD
Quality Assurance & Compliance
1 36 (3.19%) QA
2 8 (0.71%) PCI DSS
3 7 (0.62%) SLA
4 2 (0.18%) ISO/IEC 27001
System Software
1 19 (1.68%) VMware Infrastructure
2 13 (1.15%) Oracle RAC
3 12 (1.06%) NFS
3 12 (1.06%) SRDF
4 7 (0.62%) Active Directory
5 5 (0.44%) VMware Server
5 5 (0.44%) Xen
5 5 (0.44%) XenServer
5 5 (0.44%) vSphere
5 5 (0.44%) VMware ESXi
5 5 (0.44%) pfSense
5 5 (0.44%) KVM
6 4 (0.35%) VMware ESX
7 1 (0.089%) Hyper-V
7 1 (0.089%) Docker
Systems Management
1 8 (0.71%) Data Guard
2 7 (0.62%) Puppet
3 4 (0.35%) SCCM
4 1 (0.089%) SCVMM
Vendors
1 442 (39.15%) Microsoft
2 314 (27.81%) Oracle
3 100 (8.86%) Cognos
4 85 (7.53%) Tableau
5 83 (7.35%) SAP
5 83 (7.35%) IBM
6 60 (5.31%) Informatica
7 49 (4.34%) Hyperion
8 47 (4.16%) MicroStrategy
9 39 (3.45%) Vertica
10 34 (3.01%) Teradata
11 30 (2.66%) Sybase
12 28 (2.48%) Ab Initio
13 23 (2.04%) DataFlux
14 19 (1.68%) VMware
14 19 (1.68%) Netezza
15 18 (1.59%) Cisco
16 14 (1.24%) Hitachi
17 13 (1.15%) NetApp
18 12 (1.06%) EMC
London
Exposed Solutions
Salary: £50000 - £70000 per annum, Benefits Excellent Benefits & Bonus
Posted: 6 hours ago
London
Exposed Solutions
Salary: £55000 - £65000 per annum
Posted: 6 hours ago
Chesterfield, Derbyshire
Hays Specialist Recruitment
Salary: Benefits package
Posted: 16 hours ago
London
Austin Fraser Ltd
Salary: Bens
Posted: 16 hours ago
London
Lawrence Harvey Enterprise
Salary: £60000.00 - £75000.00 per annum + 10% Bonus and Benefits
Posted: 22 hours ago
London
Nigel Frank International Ltd
Salary: £425 - £450 per annum
Posted: 22 hours ago
Surrey
Intapeople
Salary: £45000 - £55000 per annum
Posted: Yesterday
Melksham, Wiltshire
Computer Futures
Salary: £45000 - £55000 per annum + competitive
Posted: Yesterday
City, London
BrightTALK Ltd
Salary: Competitive salary + strong benefits package
Posted: Yesterday
Stockport, Cheshire
Adria Solutions Ltd
Salary: £40000 - £55000 per annum + Fantastic Benefits
Posted: Yesterday
London
Opus Recruitment Solutions Ltd
Salary: £80000 - £100000 per annum, Benefits Bonus and Bens
Posted: Yesterday
London
Salt
Salary: £30000 - £35000 per annum
Posted: Yesterday
Lichfield, Staffordshire
Computer Futures
Salary: £55000 - £70000 per annum + excellent benefits
Posted: Yesterday
Preston, Lancashire
Rullion IT Plus
Salary: £35000 - £50000 per annum + Benefits
Posted: Yesterday
Manchester, 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
Manchester, Lancashire
McGregor Boyall
Salary: £42000 - £47000 per annum
Posted: Yesterday
City, London
I.T. Skillfinder
Salary: £45000 - £57000 per annum + bonus and benefits
Posted: 2 days ago
Bradford, West Yorkshire
4it Recruitment Ltd
Salary: From £40,000 to £50,000 per annum plus bonus and additional excellent
Posted: 2 days ago
London
I.T. Skillfinder
Posted: 2 days ago