The table below looks at the statistics for OLAP skills in IT jobs advertised across the UK. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 8 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
8 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 626 503 504
Rank change year-on-year
-123 +1
Permanent jobs citing OLAP 259 552 585
As % of all permanent IT jobs located in the UK 0.29% 0.52% 0.52%
As % of the Database & Business Intelligence category 0.96% 1.62% 1.68%
Number of salaries quoted 204 457 499
Median salary £47,500 £50,000 £47,500
Median salary % change year-on-year
-5.00% +5.26%
90% offered a salary of more than £35,000 £35,000 £32,500
10% offered a salary of more than £66,000 £66,000 £70,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

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
26928 33987 34858
As % of all permanent IT jobs located in the UK 29.98% 31.93% 30.71%
Number of salaries quoted 23062 28622 29771
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

OLAP
Jobs Demand Trend

The demand trend of job ads citing OLAP as a proportion of all IT jobs with a match in 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 8 December 2016 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 median salaries quoted in IT jobs citing OLAP within the UK over the 3 months to 8 December 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -135 244 £47,500 -5.00% 31
London -76 104 £55,000 -4.34% 9
South East +52 51 £47,750 +0.52% 6
East of England -2 27 £45,000 - 5
West Midlands +13 21 £36,250 -9.37% 2
Yorkshire -10 18 £45,000 - 1
West Yorkshire +8 17 £45,000 -
West Sussex +39 16 £45,250 +0.55% 2
North West -85 16 £42,500 -10.52% 4
City of London -5 14 £60,250 -3.60% 6
Manchester -47 13 £45,000 -5.26% 3
Leeds +13 12 £45,000 +5.88%
Surrey +34 10 £47,500 -20.83%
Hertfordshire -4 10 £45,000 -21.60% 1
Coventry - 8 - -
Bedfordshire - 8 £51,500 - 2
Scotland +18 7 £46,000 +8.23%
Glasgow - 7 £46,000 -
Suffolk - 7 £43,000 - 2
Hampshire -8 6 £45,000 -3.22%
Luton - 6 £49,500 - 2
Woking - 6 £47,500 -
Oxfordshire +24 4 £53,750 +34.37%
Cardiff +3 3 £35,000 -4.10%
South Wales -4 3 £35,000 -
East Midlands -7 3 £35,000 -33.33% 2
Wales -8 3 £35,000 -
Bradford -12 3 £45,000 -
Borehamwood - 3 £45,000 -
Portsmouth - 3 £43,125 -

OLAP
Top 30 Related IT Skills

For the 6 months to 8 December 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads with a requirement for OLAP.

1 442 (74.16%) SQL
2 416 (69.80%) SQL Server
3 392 (65.77%) Business Intelligence
4 360 (60.40%) Data Warehouse
5 274 (45.97%) Microsoft
6 266 (44.63%) SQL Server Analysis Services
7 254 (42.62%) ETL
8 244 (40.94%) SQL Server Integration Services
9 241 (40.44%) SQL Server Reporting Services
10 215 (36.07%) T-SQL
11 194 (32.55%) OLTP
12 185 (31.04%) Agile Software Development
13 161 (27.01%) MS Excel
14 159 (26.68%) Finance
15 153 (25.67%) OLAP Cube
16 152 (25.50%) Oracle
16 152 (25.50%) Oracle OLAP
17 129 (21.64%) Data Modelling
18 123 (20.64%) Big Data
19 117 (19.63%) MDX
20 113 (18.96%) Analytics
21 110 (18.46%) Performance Tuning
22 104 (17.45%) Kimball Methodology
23 99 (16.61%) SQL Server 2012
23 99 (16.61%) Hadoop
23 99 (16.61%) Relational Database
24 94 (15.77%) Tableau
25 89 (14.93%) Analytical Skills
26 81 (13.59%) Power BI
27 80 (13.42%) Scrum

OLAP
Top Related IT Skills by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 42 (7.05%) SharePoint
2 37 (6.21%) SAS
3 31 (5.20%) Apache
4 28 (4.70%) IIS
5 25 (4.19%) Oracle Coherence
6 24 (4.03%) Apache Spark
6 24 (4.03%) Oracle HTTP Server
6 24 (4.03%) Tomcat
6 24 (4.03%) WebSphere
7 17 (2.85%) Apache Pig
8 11 (1.85%) Oracle SOA Suite
9 4 (0.67%) Jupyter
9 4 (0.67%) SharePoint 2013
10 3 (0.50%) Elasticsearch
10 3 (0.50%) SharePoint Server
11 2 (0.34%) Apache Solr
11 2 (0.34%) Oracle 10gAS
11 2 (0.34%) Oracle Application Server
12 1 (0.17%) NetWeaver
12 1 (0.17%) Skype for Business
Applications
1 161 (27.01%) MS Excel
2 9 (1.51%) MS Office
3 4 (0.67%) Gephi
4 1 (0.17%) MS PowerPoint
4 1 (0.17%) MS Visio
4 1 (0.17%) SPSS
Business Applications
1 14 (2.35%) Cognos TM1
2 9 (1.51%) Cognos Business Intelligence
2 9 (1.51%) Cognos Controller
2 9 (1.51%) Oracle EBS
3 7 (1.17%) SAP BPC
4 5 (0.84%) Dynamics CRM
4 5 (0.84%) Dynamics NAV
5 4 (0.67%) Dynamics AX
5 4 (0.67%) FastStats
6 2 (0.34%) Adobe Campaign
6 2 (0.34%) Eloqua
6 2 (0.34%) HFM
6 2 (0.34%) Infor M3
6 2 (0.34%) Magento
6 2 (0.34%) Unica
7 1 (0.17%) JDE EnterpriseOne
7 1 (0.17%) OPENHousing
7 1 (0.17%) Oracle CRM
7 1 (0.17%) SAP CRM
7 1 (0.17%) SAP ERP
Cloud Services
1 53 (8.89%) Microsoft Azure
2 27 (4.53%) Amazon AWS
3 20 (3.36%) GitHub
4 12 (2.01%) Azure Machine Learning
4 12 (2.01%) Data Lake Analytics
5 9 (1.51%) IaaS
6 8 (1.34%) PaaS
6 8 (1.34%) SaaS
7 6 (1.01%) Google Cloud Platform
8 5 (0.84%) Amazon S3
9 2 (0.34%) Responsys
10 1 (0.17%) Google Analytics
10 1 (0.17%) Google Play
Communications & Networking
1 35 (5.87%) SAN
2 27 (4.53%) LAN
2 27 (4.53%) WAN
3 25 (4.19%) HTTP
4 24 (4.03%) FCoE
4 24 (4.03%) Fibre Channel
4 24 (4.03%) iSCSI
4 24 (4.03%) Multicast
4 24 (4.03%) NAS
5 15 (2.52%) Intranet
6 11 (1.85%) Firewall
7 9 (1.51%) Extranet
8 3 (0.50%) Internet
8 3 (0.50%) PBX
8 3 (0.50%) Skype
8 3 (0.50%) SSL
9 2 (0.34%) Ethernet
10 1 (0.17%) DHCP
10 1 (0.17%) DNS
10 1 (0.17%) GPRS
Database & Business Intelligence
1 416 (69.80%) SQL Server
2 360 (60.40%) Data Warehouse
3 266 (44.63%) SQL Server Analysis Services
4 244 (40.94%) SQL Server Integration Services
5 241 (40.44%) SQL Server Reporting Services
6 194 (32.55%) OLTP
7 153 (25.67%) OLAP Cube
8 152 (25.50%) Oracle OLAP
9 123 (20.64%) Big Data
10 99 (16.61%) Hadoop
10 99 (16.61%) Relational Database
10 99 (16.61%) SQL Server 2012
11 81 (13.59%) Power BI
12 76 (12.75%) SQL Server 2008
13 68 (11.41%) MySQL
14 67 (11.24%) NoSQL
15 64 (10.74%) SQL Server 2014
16 59 (9.90%) Microsoft Analysis Services
17 56 (9.40%) QlikView
18 54 (9.06%) RDBMS
Development Applications
1 46 (7.72%) JIRA
2 43 (7.21%) Visual Studio
3 32 (5.37%) Team Foundation Server
4 16 (2.68%) Talend Open Studio
5 11 (1.85%) ERwin
5 11 (1.85%) Jenkins
6 10 (1.68%) SQL Server Management Studio (SSMS)
7 9 (1.51%) Vagrant
8 8 (1.34%) Git (software)
9 7 (1.17%) Cucumber
9 7 (1.17%) Visual Studio Team System
9 7 (1.17%) Visual Studio Tools for Office
10 6 (1.01%) MagicDraw
11 5 (0.84%) git-flow
11 5 (0.84%) Maven
12 4 (0.67%) Oracle Forms
13 3 (0.50%) tSQLt
14 2 (0.34%) MorphX
14 2 (0.34%) PVCS
14 2 (0.34%) Subversion
General
1 159 (26.68%) Finance
2 43 (7.21%) Retail
3 36 (6.04%) Banking
4 27 (4.53%) Manufacturing
5 23 (3.86%) Games
6 19 (3.19%) Advertising
7 16 (2.68%) Legal
7 16 (2.68%) Telecoms
8 14 (2.35%) Marketing
9 9 (1.51%) Publishing
10 7 (1.17%) Investment Banking
11 6 (1.01%) Back Office
12 4 (0.67%) Front Office
12 4 (0.67%) General Ledger
13 3 (0.50%) Billing
14 2 (0.34%) Automotive
14 2 (0.34%) German Language
14 2 (0.34%) Law
14 2 (0.34%) Music Industry
14 2 (0.34%) Spanish Language
Job Titles
1 278 (46.64%) Developer
2 176 (29.53%) Business Intelligence Developer
3 82 (13.76%) Architect
4 80 (13.42%) SQL Developer
5 71 (11.91%) Analyst
5 71 (11.91%) DBA
6 54 (9.06%) Senior Developer
6 54 (9.06%) SQL DBA
7 47 (7.89%) SSIS Developer
8 45 (7.55%) ETL Developer
9 40 (6.71%) Consultant
10 38 (6.38%) Data Architect
11 37 (6.21%) SQL Server DBA
12 35 (5.87%) SSRS Developer
13 33 (5.54%) SQL BI Developer
14 30 (5.03%) Business Developer
14 30 (5.03%) Business Intelligence Analyst
14 30 (5.03%) SSAS Developer
15 29 (4.87%) Lead Architect
16 28 (4.70%) Business Intelligence Consultant
Libraries, Frameworks & Software Standards
1 117 (19.63%) MDX
2 77 (12.92%) .NET
3 48 (8.05%) XML
4 43 (7.21%) Web Services
5 28 (4.70%) Middleware
6 24 (4.03%) JSON
6 24 (4.03%) REST
7 23 (3.86%) HTML
8 17 (2.85%) Oracle GoldenGate
9 13 (2.18%) ASP.NET
9 13 (2.18%) D3.js
9 13 (2.18%) HTML5
10 11 (1.85%) SOAP
11 9 (1.51%) Akka
11 9 (1.51%) jQuery
12 8 (1.34%) .NET Framework
13 7 (1.17%) CSS
13 7 (1.17%) Leaflet
14 5 (0.84%) Spring
15 4 (0.67%) WCF
Miscellaneous
1 89 (14.93%) Analytical Skills
2 52 (8.72%) Data Integration
3 41 (6.88%) Visualisation
4 40 (6.71%) Replication
5 37 (6.21%) Computer Science
6 34 (5.70%) Management Information System
7 30 (5.03%) Clustering
8 23 (3.86%) Statistics
9 21 (3.52%) Enterprise Software
10 16 (2.68%) Fintech
11 13 (2.18%) Mobile App
12 12 (2.01%) Data Extraction
13 11 (1.85%) Neural Network
14 9 (1.51%) Mathematics
15 7 (1.17%) iPad
16 6 (1.01%) Data Structures
16 6 (1.01%) Reference Data
17 5 (0.84%) Data Protection Act
17 5 (0.84%) Life Science
17 5 (0.84%) Physics
Operating Systems
1 77 (12.92%) Windows
2 54 (9.06%) Linux
3 26 (4.36%) Unix
4 24 (4.03%) Solaris
5 15 (2.52%) Windows Server
6 4 (0.67%) Windows Server 2008
7 3 (0.50%) Windows Server 2012
8 1 (0.17%) Android
8 1 (0.17%) Apple iOS
8 1 (0.17%) CentOS
8 1 (0.17%) Red Hat Enterprise Linux
Processes & Methodologies
1 392 (65.77%) Business Intelligence
2 254 (42.62%) ETL
3 185 (31.04%) Agile Software Development
4 129 (21.64%) Data Modelling
5 113 (18.96%) Analytics
6 110 (18.46%) Performance Tuning
7 104 (17.45%) Kimball Methodology
8 80 (13.42%) Scrum
9 66 (11.07%) Dimensional Modelling
10 58 (9.73%) Data Management
11 42 (7.05%) Data Architecture
12 41 (6.88%) Project Management
13 40 (6.71%) Business Analysis
14 39 (6.54%) Migration
15 36 (6.04%) CRM
16 32 (5.37%) Kanban
17 31 (5.20%) Logical Data Model
18 30 (5.03%) Disaster Recovery
18 30 (5.03%) Risk Management
19 28 (4.70%) Time Management
Programming Languages
1 442 (74.16%) SQL
2 215 (36.07%) T-SQL
3 67 (11.24%) C#
4 56 (9.40%) PL/SQL
5 53 (8.89%) Java
6 47 (7.89%) Data Analysis Expressions (DAX)
7 33 (5.54%) JavaScript
8 29 (4.87%) PowerShell
9 27 (4.53%) Python
10 23 (3.86%) R
11 20 (3.36%) VBA
12 17 (2.85%) Shell Script
13 13 (2.18%) VB.NET
14 12 (2.01%) Scala
15 11 (1.85%) Perl
16 10 (1.68%) PHP
17 9 (1.51%) C
18 4 (0.67%) C++
19 3 (0.50%) XMLA
20 2 (0.34%) Bash Shell
Qualifications
1 70 (11.74%) Degree
2 37 (6.21%) Microsoft Certification
3 16 (2.68%) MCITP
4 13 (2.18%) SC Cleared
4 13 (2.18%) Security Cleared
5 12 (2.01%) MCSE
6 3 (0.50%) ISEB
6 3 (0.50%) MCP
6 3 (0.50%) MCSA
7 2 (0.34%) CIMA
7 2 (0.34%) MCTS
7 2 (0.34%) PRINCE2 Certification
8 1 (0.17%) ACCA
8 1 (0.17%) CISSP
8 1 (0.17%) Oracle Certification
8 1 (0.17%) Postgraduate
Quality Assurance & Compliance
1 31 (5.20%) Data Quality
2 28 (4.70%) QA
3 9 (1.51%) SLA
4 5 (0.84%) ISO20022
5 3 (0.50%) PCI DSS
6 1 (0.17%) Basel III
6 1 (0.17%) Dodd-Frank
6 1 (0.17%) HIPAA
6 1 (0.17%) ISO/IEC 27001
6 1 (0.17%) SSAE 16
System Software
1 30 (5.03%) VMware Infrastructure
2 24 (4.03%) Hyper-V
2 24 (4.03%) KVM
2 24 (4.03%) NFS
2 24 (4.03%) Oracle RAC
2 24 (4.03%) SRDF
2 24 (4.03%) Xen
3 12 (2.01%) Virtual Machines
4 9 (1.51%) HDFS
5 5 (0.84%) VMware ESX
5 5 (0.84%) vSphere
6 3 (0.50%) Apache Flume
7 2 (0.34%) Firmware
8 1 (0.17%) Active Directory
8 1 (0.17%) Apache ZooKeeper
8 1 (0.17%) Docker
8 1 (0.17%) VMware ESXi
Systems Management
1 19 (3.19%) Puppet
2 11 (1.85%) Microsoft Clustering
3 3 (0.50%) ITRS Geneos
3 3 (0.50%) Oozie
4 1 (0.17%) Hadoop YARN
4 1 (0.17%) WSUS
Vendors
1 274 (45.97%) Microsoft
2 152 (25.50%) Oracle
3 94 (15.77%) Tableau
4 66 (11.07%) Cognos
5 50 (8.39%) IBM
6 41 (6.88%) VMware
7 29 (4.87%) NetApp
8 28 (4.70%) Cisco
9 26 (4.36%) EMC
10 24 (4.03%) Intel
11 16 (2.68%) Talend
12 15 (2.52%) SAP
13 14 (2.35%) Informatica
14 13 (2.18%) Computacenter
15 12 (2.01%) Google
15 12 (2.01%) Splunk
16 9 (1.51%) Actian
17 8 (1.34%) MicroStrategy
18 6 (1.01%) Hyperion
18 6 (1.01%) RedGate
Northampton, Northamptonshire
McGregor Boyall
Salary: £45000 per annum
Posted: 21 hours ago
England
Lawrence Harvey
Salary: £45000.00 - £58000.00 per annum
Posted: 21 hours ago
UK
Lawrence Harvey Enterprise
Salary: £45000.00 - £58000.00 per annum
Posted: 9 hours ago
City, London
Capital IT Resourcing LTD
Salary: £40000 - £45000 per annum + Benefits
Posted: Yesterday
Suffolk
Proactive Appointments
Salary: great benefits
Posted: Yesterday
South East
Austin Fraser
Salary: £55000 - £65000 per annum + Bonus + Benefits
Posted: 13 hours ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: Yesterday
City, London
The Bridge Ltd
Salary: From £60,000 to £80,000 per annum Pension Scheme, Life & Medical Insur
Posted: 17 hours ago
Ipswich, Suffolk
X4 Group
Salary: Market related
Posted: 2 days ago
Reading, Berkshire
Lawrence Harvey Enterprise
Salary: £45000.00 - £55000.00 per annum
Posted: 2 days ago
Crawley
Nigel Frank International
Salary: £50000 - £65000 per annum + Benefits
Posted: 2 days ago
Tunbridge Wells
Nigel Frank International
Salary: £30000 - £55000 per annum + Pensions, Benefits
Posted: 2 days ago
West Midlands
Austin Fraser
Salary: £50000.00 - £55000.00 per annum + Benefits
Posted: 13 hours ago
City, London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 2 days ago
UK
Nigel Frank International Ltd
Salary: £40000 - £60000 per annum + Travel, Car, Pension
Posted: 3 days ago
Northampton, Northamptonshire
McGregor Boyall
Salary: £45000 per annum
Posted: 3 days ago
City, London
Henderson Drake
Salary: From £28,000 to £40,000 per annum Bonus + Pension + Insurance + Dental
Posted: Yesterday
West Midlands
Austin Fraser
Salary: £40000.00 - £45000.00 per annum + Benefits
Posted: 2 days ago
City, London
Energon People
Salary: £80000.00 - £120000.00 per annum + benefits + bonus
Posted: 5 hours ago
Luton, Bedfordshire
Understanding Recruitment
Salary: £50000.00 - £55000.00 per annum + Benefits
Posted: 3 days ago
Skipton, North Yorkshire
Redrock Consulting Ltd
Salary: £35000 - £40000 per annum + Good
Posted: 6 days ago
West London
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £60000 Per Annum Plus excellent benefits
Posted: 4 days ago
Stevenage, Hertfordshire
Nigel Frank International Ltd
Salary: £25000 - £32000 per annum + Benefits
Posted: 6 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 6 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 10 days ago
West Sussex
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + bonus, pension, health care
Posted: 14 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 27 days ago
London
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 17 days ago
Manchester
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 27 days ago
Luton
easyJet Airline
Posted: 17 days ago