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

Online Analytical Processing (OLAP)
UK
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 550 555 495
Rank change year-on-year +5 -60  
Permanent jobs citing OLAP 344 405 579
As % of all permanent IT jobs advertised in the UK 0.38% 0.42% 0.52%
As % of the Database & Business Intelligence category 1.24% 1.39% 1.60%
Number of salaries quoted 250 327 463
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,950 £37,500 £32,500
10% offered a salary of more than £70,000 £71,000 £72,500
UK excluding London median salary £42,500 £46,750 £40,000
% change year-on-year -9.09% +16.87%  

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 27658 29042 36141
As % of all permanent IT job vacancies advertised in the UK 30.93% 29.92% 32.61%
Number of salaries quoted 23334 24763 30505
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 June 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 June 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 +8 342 £50,000 - 29
London +50 191 £60,000 - 12
South East +55 37 £60,000 +20.00% 4
City of London +22 32 £67,500 +8.00% 3
East of England -3 31 £42,500 -12.82% 6
East Midlands +31 25 £36,500 -27.00% 1
South West -3 22 £32,500 -23.52% 2
Northamptonshire +20 20 £38,000 -24.00% 1
Somerset +3 18 £32,500 -22.15% 1
Bath -7 18 £32,500 -22.15% 1
Milton Keynes - 16 £74,000 - 1
Buckinghamshire - 16 £74,000 - 1
North West -32 15 £45,000 +24.13% 1
Bedfordshire +30 12 £42,500 -3.40% 2
Wellingborough - 11 £35,250 - 1
Hertfordshire -14 10 £42,500 -34.61%
West Midlands -29 10 £27,500 -38.88% 1
Surrey +30 9 £60,000 +20.00% 2
Luton +14 9 £42,500 -2.29% 2
Northampton +12 9 £42,500 -15.00%
Yorkshire -19 8 £50,000 -23.07% 2
Manchester -30 8 £33,750 -32.50%
Warwickshire +18 7 £22,500 -52.63%
Essex +2 7 £35,000 -17.64% 4
Watford -6 7 £45,000 -5.26%
Leamington Spa - 7 £22,500 -
West Yorkshire +1 5 £65,000 -
Hampshire 0 5 £47,750 +6.11% 1
Cheshire -25 5 £45,000 -5.26%
Stockport - 4 £27,500 -

For the 6 months to 26 June 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 476 (77.27%) SQL
2 417 (67.69%) Business Intelligence
3 398 (64.61%) Data Warehouse
4 383 (62.18%) SQL Server
5 360 (58.44%) ETL
6 348 (56.49%) SQL Server Integration Services
7 323 (52.44%) SQL Server Analysis Services
8 297 (48.21%) SQL Server Reporting Services
9 264 (42.86%) Microsoft
10 223 (36.20%) T-SQL
11 210 (34.09%) OLAP Cube
12 159 (25.81%) Finance
13 142 (23.05%) Agile Software Development
14 138 (22.40%) Power BI
15 133 (21.59%) Relational Database
16 122 (19.81%) OLTP
17 117 (18.99%) MDX
18 116 (18.83%) Kimball Methodology
19 115 (18.67%) Data Modelling
20 114 (18.51%) Oracle
20 114 (18.51%) Oracle OLAP
21 109 (17.69%) Analytics
22 102 (16.56%) SQL Server 2012
23 101 (16.40%) Analytical Skills
24 100 (16.23%) Dimensional Modelling
25 85 (13.80%) SQL Server 2008
26 78 (12.66%) MySQL
26 78 (12.66%) Performance Tuning
27 74 (12.01%) Tableau
28 73 (11.85%) PL/SQL

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 38 (6.17%) SharePoint
2 29 (4.71%) Apache Spark
2 29 (4.71%) Elasticsearch
3 18 (2.92%) Apache
4 17 (2.76%) Apache Airflow
5 10 (1.62%) IIS
6 5 (0.81%) Oracle SOA Suite
7 4 (0.65%) Oracle Service Bus
7 4 (0.65%) SAS
7 4 (0.65%) Tomcat
7 4 (0.65%) WebSphere
8 3 (0.49%) Apache Pig
9 2 (0.32%) GemFire
9 2 (0.32%) SharePoint 2010
9 2 (0.32%) SharePoint 2013
10 1 (0.16%) Apache Solr
10 1 (0.16%) BizTalk Server
10 1 (0.16%) OpenStack
10 1 (0.16%) Oracle Coherence
Applications
1 53 (8.60%) Microsoft Excel
2 33 (5.36%) MS Visio
3 4 (0.65%) Microsoft PowerPoint
4 3 (0.49%) Microsoft Office
5 1 (0.16%) SPSS
Business Applications
1 22 (3.57%) Cognos TM1
2 14 (2.27%) Cognos Business Intelligence
3 11 (1.79%) Infor SunSystems
4 10 (1.62%) Dynamics CRM
5 5 (0.81%) Dynamics AX
5 5 (0.81%) Hyperion Planning
5 5 (0.81%) SAP BPC
6 4 (0.65%) Oracle Applications
7 1 (0.16%) Cognos Planning
7 1 (0.16%) Dynamics NAV
7 1 (0.16%) FastStats
7 1 (0.16%) ION MarketView
7 1 (0.16%) PeopleSoft HRMS
7 1 (0.16%) SAP ERP
Cloud Services
1 37 (6.01%) Amazon AWS
2 32 (5.19%) Microsoft Azure
3 17 (2.76%) Amazon Kinesis
4 7 (1.14%) GitHub
5 5 (0.81%) IaaS
5 5 (0.81%) SaaS
6 3 (0.49%) Azure Data Factory
6 3 (0.49%) Google Analytics
6 3 (0.49%) Office 365
7 2 (0.32%) Google Cloud Platform
8 1 (0.16%) Adobe Analytics
8 1 (0.16%) Cloud Computing
8 1 (0.16%) Data Lake Analytics
8 1 (0.16%) Datadog
8 1 (0.16%) Dynamics 365
8 1 (0.16%) PaaS
Communications & Networking
1 16 (2.60%) Intranet
2 7 (1.14%) SAN
3 4 (0.65%) Extranet
4 3 (0.49%) Ethernet
4 3 (0.49%) Kerberos
4 3 (0.49%) NAS
5 1 (0.16%) FTP
5 1 (0.16%) HTTP
5 1 (0.16%) Internet
5 1 (0.16%) LAN
5 1 (0.16%) Modbus
5 1 (0.16%) RS-485
5 1 (0.16%) WAN
Database & Business Intelligence
1 398 (64.61%) Data Warehouse
2 383 (62.18%) SQL Server
3 348 (56.49%) SQL Server Integration Services
4 323 (52.44%) SQL Server Analysis Services
5 297 (48.21%) SQL Server Reporting Services
6 210 (34.09%) OLAP Cube
7 138 (22.40%) Power BI
8 133 (21.59%) Relational Database
9 122 (19.81%) OLTP
10 114 (18.51%) Oracle OLAP
11 102 (16.56%) SQL Server 2012
12 85 (13.80%) SQL Server 2008
13 78 (12.66%) MySQL
14 69 (11.20%) Big Data
15 67 (10.88%) QlikView
16 64 (10.39%) RDBMS
17 60 (9.74%) SQL Server 2014
18 50 (8.12%) Hadoop
18 50 (8.12%) Microsoft Analysis Services
19 45 (7.31%) BusinessObjects
Development Applications
1 36 (5.84%) Visual Studio
2 25 (4.06%) PowerDesigner
3 23 (3.73%) Team Foundation Server
4 16 (2.60%) JIRA
5 10 (1.62%) Eclipse
6 8 (1.30%) Talend Open Studio
7 7 (1.14%) Visual Studio Team System
8 6 (0.97%) tSQLt
9 5 (0.81%) JUnit
9 5 (0.81%) Maven
10 4 (0.65%) Git (software)
10 4 (0.65%) Octopus Deploy
11 3 (0.49%) Liquibase
12 2 (0.32%) TeamCity
13 1 (0.16%) ERwin
13 1 (0.16%) MagicDraw
13 1 (0.16%) MSTest
13 1 (0.16%) Subversion
13 1 (0.16%) TestNG
13 1 (0.16%) TortoiseSVN
General
1 159 (25.81%) Finance
2 52 (8.44%) Banking
3 49 (7.95%) Retail
4 42 (6.82%) Advertising
5 40 (6.49%) Marketing
6 34 (5.52%) Investment Banking
7 29 (4.71%) Legal
8 22 (3.57%) Retail Banking
9 12 (1.95%) Manufacturing
10 11 (1.79%) Front Office
11 8 (1.30%) Financial Institution
12 7 (1.14%) French Language
12 7 (1.14%) German Language
12 7 (1.14%) Spanish Language
13 6 (0.97%) Law
14 5 (0.81%) Dutch Language
14 5 (0.81%) Italian Language
15 4 (0.65%) Publishing
16 3 (0.49%) Electronics
16 3 (0.49%) Games
Job Titles
1 316 (51.30%) Developer
2 175 (28.41%) Business Intelligence Developer
3 119 (19.32%) SQL Developer
4 115 (18.67%) Analyst
5 75 (12.18%) DBA
6 66 (10.71%) Business Intelligence Analyst
7 65 (10.55%) Senior Developer
8 63 (10.23%) SQL BI Developer
9 62 (10.06%) SSAS Developer
10 61 (9.90%) Data Warehouse Developer
11 56 (9.09%) SQL Analyst
12 49 (7.95%) SSIS Developer
13 46 (7.47%) Senior Business Intelligence Developer
14 43 (6.98%) SSRS Developer
15 41 (6.66%) SQL DBA
16 38 (6.17%) Administrator
17 37 (6.01%) Architect
17 37 (6.01%) SQL Server Developer
18 33 (5.36%) Business Developer
18 33 (5.36%) OLAP Developer
Libraries, Frameworks & Software Standards
1 117 (18.99%) MDX
2 66 (10.71%) .NET
3 33 (5.36%) XML
4 32 (5.19%) HTML
5 29 (4.71%) Web Services
6 23 (3.73%) Oracle GoldenGate
7 17 (2.76%) Kafka
7 17 (2.76%) Scrapy
8 13 (2.11%) GraphX
8 13 (2.11%) Serverless Framework
9 10 (1.62%) XSD
10 9 (1.46%) REST
11 8 (1.30%) ASP.NET
11 8 (1.30%) CSS
11 8 (1.30%) HTML5
11 8 (1.30%) SOAP
12 7 (1.14%) .NET Framework
12 7 (1.14%) WSDL
12 7 (1.14%) XML Messaging
13 6 (0.97%) Ajax
Miscellaneous
1 101 (16.40%) Analytical Skills
2 50 (8.12%) Management Information System
3 33 (5.36%) Replication
4 25 (4.06%) Data Structures
4 25 (4.06%) Enterprise Software
5 23 (3.73%) Computer Science
6 20 (3.25%) Fintech
7 19 (3.08%) Clustering
8 17 (2.76%) Greenfield Project
9 8 (1.30%) Foreign Exchange (FX)
9 8 (1.30%) iPad
10 4 (0.65%) Data Protection Act
10 4 (0.65%) Mobile App
10 4 (0.65%) NHS
11 3 (0.49%) Client/Server
11 3 (0.49%) Credit Risk
11 3 (0.49%) N-Tier
11 3 (0.49%) User Experience
12 2 (0.32%) Market Risk
12 2 (0.32%) Spread Betting
Operating Systems
1 44 (7.14%) Windows
2 41 (6.66%) Unix
3 24 (3.90%) Linux
4 14 (2.27%) Windows Server
5 12 (1.95%) Solaris
5 12 (1.95%) Windows Server 2008
5 12 (1.95%) Windows Server 2012
Processes & Methodologies
1 417 (67.69%) Business Intelligence
2 360 (58.44%) ETL
3 142 (23.05%) Agile Software Development
4 116 (18.83%) Kimball Methodology
5 115 (18.67%) Data Modelling
6 109 (17.69%) Analytics
7 100 (16.23%) Dimensional Modelling
8 78 (12.66%) Performance Tuning
9 63 (10.23%) Visualisation
10 60 (9.74%) ITIL
11 54 (8.77%) Data Analysis
12 52 (8.44%) SDLC
13 47 (7.63%) Data Management
13 47 (7.63%) Data Visualisation
14 40 (6.49%) Data Analytics
14 40 (6.49%) Scrum
15 39 (6.33%) ETL Development
16 38 (6.17%) SOA
17 37 (6.01%) Stakeholder Management
18 34 (5.52%) Disaster Recovery
Programming Languages
1 476 (77.27%) SQL
2 223 (36.20%) T-SQL
3 73 (11.85%) PL/SQL
4 64 (10.39%) Java
5 61 (9.90%) C#
6 55 (8.93%) Python
7 31 (5.03%) R
8 23 (3.73%) C++
8 23 (3.73%) Data Analysis Expressions (DAX)
8 23 (3.73%) Perl
9 17 (2.76%) JavaScript
9 17 (2.76%) VB.NET
10 14 (2.27%) PowerShell
11 10 (1.62%) PHP
12 8 (1.30%) VBA
13 5 (0.81%) C
14 4 (0.65%) ABAP
14 4 (0.65%) Scala
14 4 (0.65%) Shell Script
14 4 (0.65%) VBScript
Qualifications
1 65 (10.55%) Degree
2 16 (2.60%) Microsoft Certification
3 9 (1.46%) Computer Science Degree
4 8 (1.30%) ITIL Certification
5 7 (1.14%) MCSE
6 6 (0.97%) Oracle Certification
6 6 (0.97%) SC Cleared
6 6 (0.97%) Security Cleared
7 4 (0.65%) MCITP
8 3 (0.49%) CIMA
9 2 (0.32%) Master's Degree
10 1 (0.16%) PMI Certification
10 1 (0.16%) Postgraduate
Quality Assurance & Compliance
1 65 (10.55%) Data Quality
2 47 (7.63%) QA
3 3 (0.49%) GDPR
3 3 (0.49%) PMO
3 3 (0.49%) SLA
4 2 (0.32%) PCI DSS
5 1 (0.16%) Basel III
5 1 (0.16%) Dodd-Frank
5 1 (0.16%) EFQM
5 1 (0.16%) GCP
5 1 (0.16%) IFRS
5 1 (0.16%) IFRS 9
5 1 (0.16%) Sarbanes-Oxley
System Software
1 10 (1.62%) Oracle RAC
2 9 (1.46%) KVM
2 9 (1.46%) VMware Infrastructure
3 6 (0.97%) Active Directory
4 3 (0.49%) Firmware
5 2 (0.32%) HDFS
6 1 (0.16%) Apache Flume
6 1 (0.16%) Apache ZooKeeper
6 1 (0.16%) Docker
Systems Management
1 18 (2.92%) Kibana
2 5 (0.81%) Oozie
2 5 (0.81%) Puppet
3 4 (0.65%) Enterprise Manager Cloud Control
3 4 (0.65%) Opscode Chef
3 4 (0.65%) Oracle Enterprise Manager
3 4 (0.65%) Oracle RMAN
4 3 (0.49%) Ansible
5 2 (0.32%) Perfmon
6 1 (0.16%) Cobbler
6 1 (0.16%) Control-M
6 1 (0.16%) Hadoop YARN
6 1 (0.16%) Kubernetes
6 1 (0.16%) Nagios
6 1 (0.16%) PowerCLI
6 1 (0.16%) Rundeck
6 1 (0.16%) Systems Management Server (SMS)
6 1 (0.16%) ZABBIX
Vendors
1 264 (42.86%) Microsoft
2 114 (18.51%) Oracle
3 74 (12.01%) Tableau
4 53 (8.60%) Cognos
5 33 (5.36%) SAP
6 25 (4.06%) Sybase
7 22 (3.57%) MicroStrategy
8 21 (3.41%) VMware
9 15 (2.44%) IBM
10 14 (2.27%) Informatica
11 13 (2.11%) Hyperion
11 13 (2.11%) Infor
12 12 (1.95%) NetApp
13 11 (1.79%) Jedox
13 11 (1.79%) RedGate
14 9 (1.46%) Percona
15 8 (1.30%) Talend
16 7 (1.14%) Callidus
16 7 (1.14%) Guidewire
16 7 (1.14%) Sun
Essex
Nigel Frank International
Salary: £30000 - £45000 per annum + Health, Benefits
Posted: 14 hours ago
Wellingborough, Northamptonshire
Latcom Ltd
Salary: From £25,000 to £25,000 per annum + Training + Excellent Pension + Ben
Posted: 8 hours ago
London
Venturi
Salary: £40000.00 - £55000.00 per annum + Bonus & Benefits
Posted: 12 hours ago
Bath, Avon
Optima Connections
Salary: From £30,000 to £35,000 per annum + Benefits
Posted: 11 hours ago
Surrey
Venturi
Salary: £40000.00 - £55000.00 per annum + Bonus & Benefits
Posted: 2 days ago
York, North Yorkshire
onezeero.
Salary: £25000 - £40000 per annum
Posted: 5 days ago
City, London
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: 5 days ago
Surrey
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 2 days ago
London
Talent Spa
Salary: £70k per year
Posted: 3 days ago
Colchester
Nigel Frank International
Salary: £35000 - £45000 per annum + Benefits
Posted: 6 days ago
Brentwood, Essex
Shawbrook
Posted: 3 days ago
Birmingham, West Midlands (County)
Colossus Associates
Salary: £40000 - £60000 per annum, Benefits 0
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 3 days ago
London
Harvey Nash plc
Salary: £40000 - £50000 per annum
Posted: 6 days ago
Bristol, Avon
Sanderson
Salary: £60000 - £75000 per annum
Posted: 6 days ago
London
onezeero.
Salary: £50000 - £65000 per annum
Posted: 6 days ago
London
Opus Recruitment Solutions Ltd
Salary: £100000 - £150000 per annum
Posted: 9 hours ago
Colchester
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits, Pension
Posted: 11 days ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 11 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 7 days ago
Glasgow
Call Centre Associates
Posted: 20 days ago
Southampton, Hampshire
Red Funnel Group
Salary: £44,000 per annum including annual bonus and great benefits scheme
Posted: 18 days ago
East London
Cognizant
Salary: Competitive
Posted: 6 days ago
Preston, Lancashire
Oscar
Salary: £25000 - £40000 per annum
Posted: 4 days ago
Milton Keynes
Mint
Posted: 25 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 17 days ago