The following table provides summary statistics for permanent job vacancies with a requirement for OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 3 months to 26 May 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK
3 months to
26 May 2017
Same period 2016 Same period 2015
Rank 596 565 482
Rank change year-on-year -31 -83  
Permanent jobs citing OLAP 296 387 589
As % of all permanent IT jobs advertised in the UK 0.34% 0.39% 0.55%
As % of the Database & Business Intelligence category 1.08% 1.30% 1.70%
Number of salaries quoted 231 308 468
Median salary £52,500 £50,000 £51,500
Median salary % change year-on-year +5.00% -2.91%  
90% offered a salary of more than £35,000 £37,500 £32,500
10% offered a salary of more than £70,000 £70,000 £72,500
UK excluding London median salary £42,500 £45,000 £40,000
% change year-on-year -5.55% +12.50%  

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
UK
Permanent job vacancies with a requirement for database and business intelligence skills 27499 29760 34739
As % of all permanent IT job vacancies advertised in the UK 31.38% 30.28% 32.43%
Number of salaries quoted 23311 25427 29307
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26%  
90% offered a salary of more than £32,500 £32,500 £31,500
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLAP
Job Vacancy Trend

The job posting trend of jobs advertised citing OLAP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLAP in the UK

OLAP
Salary Trend

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

Salary trend for OLAP in the UK

OLAP
Salary Histogram

The salary distribution of IT jobs citing OLAP over the 3 months to 26 May 2017.

Salary histogram for OLAP 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 26 May 2017. 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 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 +13 295 £52,500 +5.00% 34
London +38 161 £60,000 - 12
South East +49 34 £60,000 +20.00% 4
City of London +13 31 £67,500 +12.50% 7
East Midlands +25 28 £40,000 -15.78% 1
East of England -2 26 £42,500 -17.47% 3
Northamptonshire +18 24 £40,000 -20.00% 1
North West -19 16 £41,250 -2.94% 4
Northampton +19 14 £42,500 -15.00%
Buckinghamshire - 12 £80,000 -
Milton Keynes - 11 £80,000 -
Bedfordshire +26 10 £42,500 -2.29% 1
South West -12 10 £40,000 -5.88% 1
Surrey +34 9 £60,000 +20.00% 1
Yorkshire -11 9 £46,250 +8.82% 4
Somerset -14 9 - - 1
Manchester -16 9 £27,500 -40.54% 3
Bath -17 9 - - 1
Wellingborough - 9 £35,250 - 1
Hertfordshire -8 8 £42,500 -32.00% 1
West Midlands -15 8 £38,500 -14.44% 1
Luton +13 7 £42,500 -2.29% 1
Watford -2 6 £45,000 -5.26% 1
West Yorkshire -6 6 £52,500 -8.69% 3
Essex +1 5 £43,036 +1.26%
Cheshire -19 5 £45,000 -5.26% 1
West Sussex +13 4 £38,750 -27.57%
Leeds -3 4 £51,250 +22.75%
Hampshire -6 4 £48,000 +6.66% 1
Stockport - 4 £27,500 -

For the 6 months to 26 May 2017, 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 464 (77.08%) SQL
2 429 (71.26%) Business Intelligence
3 386 (64.12%) SQL Server
4 365 (60.63%) Data Warehouse
5 360 (59.80%) SQL Server Integration Services
6 342 (56.81%) ETL
7 325 (53.99%) SQL Server Analysis Services
8 320 (53.16%) SQL Server Reporting Services
9 268 (44.52%) Microsoft
10 243 (40.37%) T-SQL
11 198 (32.89%) OLAP Cube
12 154 (25.58%) Finance
13 148 (24.58%) Power BI
14 138 (22.92%) Agile Software Development
15 126 (20.93%) OLTP
16 123 (20.43%) Relational Database
17 120 (19.93%) Data Modelling
18 113 (18.77%) MDX
18 113 (18.77%) SQL Server 2012
19 111 (18.44%) Oracle OLAP
19 111 (18.44%) Oracle
20 110 (18.27%) Kimball Methodology
21 102 (16.94%) Analytics
22 101 (16.78%) SQL Server 2008
23 92 (15.28%) Analytical Skills
24 91 (15.12%) Dimensional Modelling
25 85 (14.12%) .NET
25 85 (14.12%) Big Data
26 82 (13.62%) MySQL
27 81 (13.46%) Performance Tuning

OLAP
Co-occurring 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 40 (6.64%) SharePoint
2 26 (4.32%) Elasticsearch
3 25 (4.15%) Apache Spark
4 20 (3.32%) Apache
5 17 (2.82%) Apache Airflow
6 14 (2.33%) IIS
7 6 (1.00%) Oracle Service Bus
7 6 (1.00%) Oracle SOA Suite
7 6 (1.00%) Tomcat
7 6 (1.00%) WebSphere
8 5 (0.83%) Apache Pig
9 4 (0.66%) SAS
10 3 (0.50%) Oracle Coherence
11 2 (0.33%) Oracle HTTP Server
11 2 (0.33%) SharePoint 2013
12 1 (0.17%) Apache Solr
12 1 (0.17%) BizTalk Server
12 1 (0.17%) Jupyter
12 1 (0.17%) OpenStack
12 1 (0.17%) SharePoint 2010
Applications
1 66 (10.96%) Microsoft Excel
2 33 (5.48%) MS Visio
3 5 (0.83%) Microsoft PowerPoint
4 4 (0.66%) Microsoft Office
5 1 (0.17%) SPSS
Business Applications
1 23 (3.82%) Cognos TM1
2 11 (1.83%) Infor SunSystems
3 10 (1.66%) Cognos Business Intelligence
4 8 (1.33%) Dynamics CRM
5 6 (1.00%) SAP BPC
6 5 (0.83%) Dynamics AX
6 5 (0.83%) Hyperion Planning
7 4 (0.66%) Oracle Applications
8 2 (0.33%) FastStats
9 1 (0.17%) Cognos Planning
9 1 (0.17%) Dynamics NAV
9 1 (0.17%) HFM
9 1 (0.17%) ION MarketView
9 1 (0.17%) OPENHousing
9 1 (0.17%) PeopleSoft HRMS
Cloud Services
1 37 (6.15%) Microsoft Azure
2 31 (5.15%) Amazon AWS
3 17 (2.82%) Amazon Kinesis
4 6 (1.00%) GitHub
5 5 (0.83%) IaaS
5 5 (0.83%) SaaS
6 3 (0.50%) Google Analytics
7 2 (0.33%) Office 365
8 1 (0.17%) Adobe Analytics
8 1 (0.17%) Data Lake Analytics
8 1 (0.17%) Datadog
8 1 (0.17%) Google Cloud Platform
8 1 (0.17%) PaaS
Communications & Networking
1 25 (4.15%) Intranet
2 10 (1.66%) SAN
3 5 (0.83%) NAS
4 4 (0.66%) Ethernet
4 4 (0.66%) Extranet
5 3 (0.50%) HTTP
5 3 (0.50%) LAN
5 3 (0.50%) WAN
6 2 (0.33%) FCoE
6 2 (0.33%) Fibre Channel
6 2 (0.33%) iSCSI
6 2 (0.33%) Kerberos
6 2 (0.33%) Multicast
7 1 (0.17%) FTP
7 1 (0.17%) Modbus
7 1 (0.17%) RS-485
7 1 (0.17%) SSL
Database & Business Intelligence
1 386 (64.12%) SQL Server
2 365 (60.63%) Data Warehouse
3 360 (59.80%) SQL Server Integration Services
4 325 (53.99%) SQL Server Analysis Services
5 320 (53.16%) SQL Server Reporting Services
6 198 (32.89%) OLAP Cube
7 148 (24.58%) Power BI
8 126 (20.93%) OLTP
9 123 (20.43%) Relational Database
10 113 (18.77%) SQL Server 2012
11 111 (18.44%) Oracle OLAP
12 101 (16.78%) SQL Server 2008
13 85 (14.12%) Big Data
14 82 (13.62%) MySQL
15 72 (11.96%) QlikView
16 67 (11.13%) RDBMS
17 60 (9.97%) Hadoop
18 59 (9.80%) SQL Server 2014
19 52 (8.64%) Microsoft Analysis Services
20 46 (7.64%) BusinessObjects
Development Applications
1 41 (6.81%) Visual Studio
2 27 (4.49%) Team Foundation Server
3 24 (3.99%) JIRA
4 22 (3.65%) PowerDesigner
5 14 (2.33%) Visual Studio Team System
6 10 (1.66%) Eclipse
6 10 (1.66%) Talend Open Studio
7 5 (0.83%) JUnit
8 4 (0.66%) Git (software)
8 4 (0.66%) Maven
9 3 (0.50%) Liquibase
9 3 (0.50%) Octopus Deploy
9 3 (0.50%) SQL Server Management Studio (SSMS)
10 2 (0.33%) git-flow
10 2 (0.33%) TeamCity
11 1 (0.17%) Grunt
11 1 (0.17%) MSTest
11 1 (0.17%) SpecFlow
11 1 (0.17%) TortoiseSVN
11 1 (0.17%) tSQLt
General
1 154 (25.58%) Finance
2 43 (7.14%) Advertising
3 37 (6.15%) Marketing
4 34 (5.65%) Legal
5 31 (5.15%) Banking
5 31 (5.15%) Retail
6 17 (2.82%) Investment Banking
6 17 (2.82%) Manufacturing
7 9 (1.50%) Financial Institution
8 7 (1.16%) Front Office
9 6 (1.00%) French Language
9 6 (1.00%) German Language
9 6 (1.00%) Law
9 6 (1.00%) Spanish Language
10 4 (0.66%) Dutch Language
10 4 (0.66%) Electronics
10 4 (0.66%) Italian Language
10 4 (0.66%) Retail Banking
11 2 (0.33%) Music Industry
11 2 (0.33%) Telecoms
Job Titles
1 309 (51.33%) Developer
2 171 (28.41%) Business Intelligence Developer
3 121 (20.10%) SQL Developer
4 119 (19.77%) Analyst
5 79 (13.12%) Senior Developer
6 73 (12.13%) DBA
7 72 (11.96%) Business Intelligence Analyst
8 64 (10.63%) SQL BI Developer
8 64 (10.63%) SSAS Developer
9 58 (9.63%) Data Warehouse Developer
10 55 (9.14%) SSIS Developer
11 52 (8.64%) SQL Analyst
12 49 (8.14%) Senior Business Intelligence Developer
13 46 (7.64%) SSRS Developer
14 42 (6.98%) SQL DBA
15 40 (6.64%) SQL Server Developer
16 39 (6.48%) Architect
17 36 (5.98%) OLAP Developer
18 32 (5.32%) Administrator
19 31 (5.15%) Business Developer
Libraries, Frameworks & Software Standards
1 113 (18.77%) MDX
2 85 (14.12%) .NET
3 28 (4.65%) XML
4 25 (4.15%) HTML
5 22 (3.65%) Web Services
6 19 (3.16%) Oracle GoldenGate
7 17 (2.82%) Kafka
7 17 (2.82%) Scrapy
8 13 (2.16%) GraphX
8 13 (2.16%) Serverless Framework
9 12 (1.99%) ASP.NET
10 9 (1.50%) SOAP
10 9 (1.50%) XSD
11 8 (1.33%) REST
12 7 (1.16%) CSS
12 7 (1.16%) HTML5
12 7 (1.16%) Spring
12 7 (1.16%) WSDL
13 6 (1.00%) Ajax
13 6 (1.00%) XML Messaging
Miscellaneous
1 92 (15.28%) Analytical Skills
2 54 (8.97%) Management Information System
3 31 (5.15%) Replication
4 24 (3.99%) Computer Science
4 24 (3.99%) Fintech
5 21 (3.49%) Clustering
5 21 (3.49%) Data Structures
6 17 (2.82%) Greenfield Project
7 7 (1.16%) NHS
8 6 (1.00%) Foreign Exchange (FX)
9 5 (0.83%) Data Protection Act
10 4 (0.66%) Enterprise Software
10 4 (0.66%) Mobile App
11 3 (0.50%) iPad
11 3 (0.50%) User Experience
12 2 (0.33%) Reference Data
12 2 (0.33%) Reinsurance
12 2 (0.33%) Social Media
12 2 (0.33%) Spread Betting
13 1 (0.17%) Hedge funds
Operating Systems
1 45 (7.48%) Windows
2 27 (4.49%) Linux
3 22 (3.65%) Unix
4 15 (2.49%) Windows Server
4 15 (2.49%) Windows Server 2008
4 15 (2.49%) Windows Server 2012
5 10 (1.66%) Solaris
Processes & Methodologies
1 429 (71.26%) Business Intelligence
2 342 (56.81%) ETL
3 138 (22.92%) Agile Software Development
4 120 (19.93%) Data Modelling
5 110 (18.27%) Kimball Methodology
6 102 (16.94%) Analytics
7 91 (15.12%) Dimensional Modelling
8 81 (13.46%) Performance Tuning
9 60 (9.97%) Visualisation
10 55 (9.14%) ITIL
11 51 (8.47%) Data Analysis
12 48 (7.97%) SDLC
13 46 (7.64%) Scrum
14 43 (7.14%) Data Visualisation
15 38 (6.31%) SOA
16 35 (5.81%) Stakeholder Management
17 34 (5.65%) Data Management
18 33 (5.48%) Disaster Recovery
19 31 (5.15%) Migration
19 31 (5.15%) Project Management
Programming Languages
1 464 (77.08%) SQL
2 243 (40.37%) T-SQL
3 62 (10.30%) C#
4 53 (8.80%) PL/SQL
5 43 (7.14%) Java
6 35 (5.81%) Python
7 31 (5.15%) Data Analysis Expressions (DAX)
8 18 (2.99%) JavaScript
9 14 (2.33%) R
9 14 (2.33%) VB.NET
10 9 (1.50%) PowerShell
11 8 (1.33%) C++
11 8 (1.33%) VBA
12 7 (1.16%) PHP
13 6 (1.00%) Perl
13 6 (1.00%) Shell Script
13 6 (1.00%) VBScript
14 5 (0.83%) C
15 4 (0.66%) Embedded C
15 4 (0.66%) Embedded C++
Qualifications
1 69 (11.46%) Degree
2 17 (2.82%) Microsoft Certification
3 8 (1.33%) ITIL Certification
4 6 (1.00%) MCSE
5 5 (0.83%) CIMA
5 5 (0.83%) SC Cleared
5 5 (0.83%) Security Cleared
6 4 (0.66%) Oracle Certification
7 3 (0.50%) MCITP
8 2 (0.33%) Master's Degree
9 1 (0.17%) Postgraduate
Quality Assurance & Compliance
1 62 (10.30%) Data Quality
2 41 (6.81%) QA
3 5 (0.83%) PMO
3 5 (0.83%) SLA
4 4 (0.66%) ISO/IEC 20000
5 3 (0.50%) PCI DSS
6 2 (0.33%) GDPR
7 1 (0.17%) Basel III
7 1 (0.17%) Dodd-Frank
7 1 (0.17%) EFQM
7 1 (0.17%) IFRS
7 1 (0.17%) IFRS 9
7 1 (0.17%) Sarbanes-Oxley
System Software
1 12 (1.99%) Oracle RAC
2 10 (1.66%) KVM
2 10 (1.66%) VMware Infrastructure
3 7 (1.16%) Active Directory
4 4 (0.66%) Firmware
5 2 (0.33%) HDFS
5 2 (0.33%) Hyper-V
5 2 (0.33%) NFS
5 2 (0.33%) SRDF
5 2 (0.33%) Xen
6 1 (0.17%) Apache Flume
6 1 (0.17%) Apache ZooKeeper
Systems Management
1 18 (2.99%) Kibana
2 8 (1.33%) Puppet
3 6 (1.00%) Enterprise Manager Cloud Control
3 6 (1.00%) Oracle Enterprise Manager
3 6 (1.00%) Oracle RMAN
4 5 (0.83%) Oozie
5 3 (0.50%) Opscode Chef
6 2 (0.33%) Perfmon
7 1 (0.17%) Ansible
7 1 (0.17%) Cobbler
7 1 (0.17%) Control-M
7 1 (0.17%) Hadoop YARN
7 1 (0.17%) Nagios
7 1 (0.17%) PowerCLI
7 1 (0.17%) Rundeck
7 1 (0.17%) ZABBIX
Vendors
1 268 (44.52%) Microsoft
2 111 (18.44%) Oracle
3 79 (13.12%) Tableau
4 54 (8.97%) Cognos
5 29 (4.82%) SAP
6 22 (3.65%) Sybase
7 21 (3.49%) MicroStrategy
8 18 (2.99%) VMware
9 16 (2.66%) IBM
10 14 (2.33%) Hyperion
11 13 (2.16%) Infor
12 12 (1.99%) Informatica
13 11 (1.83%) Jedox
14 10 (1.66%) NetApp
14 10 (1.66%) Talend
15 8 (1.33%) Percona
16 7 (1.16%) SolarWinds
16 7 (1.16%) Sun
17 6 (1.00%) Callidus
17 6 (1.00%) EMC
London
Joseph Harry Ltd
Salary: £60000 - £75000 per annum + 20-30% Bonus + 10% Pension
Posted: 22 hours ago
London
Burns Sheehan
Salary: £50000 - £65000.00 per annum + benefits
Posted: 21 hours ago
Wellingborough, Northamptonshire
Latcom Ltd
Salary: From £36,000 to £40,000 per annum + Excellent Pension + Benefits
Posted: Yesterday
City, London
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: 3 days ago
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 2 days ago
Portsmouth, Hampshire
Experis Ltd
Salary: £40000 - £55000 per annum + Benefits
Posted: 2 days ago
Manchester, Lancashire
Morson International
Posted: 6 days ago
Manchester, Lancashire
Morson International
Posted: 9 days ago
Tonbridge
Nigel Frank International
Salary: £30000 - £60000 per annum + Benefits, holidays, pension
Posted: 15 days ago
Bath, Somerset
Wessex Water
Posted: 6 days ago
England
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + bonus, gym, flex-working etc
Posted: 10 days ago
London
Lawrence Harvey
Salary: £75000.00 - £80000.00 per annum
Posted: 9 days ago
Cambridge, Cambridgeshire
ARM Ltd
Salary: Competitive Salary
Posted: 3 days ago
England
Lawrence Harvey
Salary: £55000.00 - £70000.00 per annum + bonus, pension, car
Posted: 7 days ago
Luton, Bedfordshire
Easyjet
Posted: 3 days ago
Surrey
Opus Recruitment Solutions Ltd
Salary: £50000 - £70000 per annum, Benefits Benefits & Bonus included
Posted: 6 days ago
London
Venturi
Salary: £0.00 - £65000 per annum + Bonus
Posted: 18 days ago
City, London
Experis Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: 6 days ago
Birmingham, West Midlands (County)
S S P Ltd
Salary: Competitive + Benefits
Posted: 15 days ago
City, London
Experis Ltd
Salary: £30000 - £50000 per annum + Benefits
Posted: 6 days ago
City of London
Lawrence Harvey
Salary: £50000.00 - £65000.00 per annum + excellent benefits
Posted: 18 days ago
England
Nigel Frank International
Salary: £45000 - £55000 per annum + Benefits, Travel
Posted: 19 days ago
Watford
Arrows Group Ltd
Posted: 18 days ago
England
Nigel Frank International
Salary: £50000 - £70000 per annum
Posted: 23 days ago
City, London
Experis Ltd
Salary: £65000 - £75000 per annum + Benefits
Posted: 6 days ago
London
UBS
Posted: 13 days ago
Bradford, West Yorkshire
Candour Solutions
Salary: Excellent plus outstanding benefits
Posted: 6 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 23 days ago
Bradford, West Yorkshire
ReThink Recruitment
Posted: 6 days ago
Manchester
Bupa
Posted: 27 days ago