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

3 months to
24 Mar 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK
Rank 590 594 501
Rank change year-on-year +4 -93  
Permanent jobs citing OLAP 274 373 528
As % of all permanent IT jobs advertised in the UK 0.32% 0.36% 0.50%
As % of the Database & Business Intelligence category 1.05% 1.17% 1.60%
Number of salaries quoted 242 294 398
Median salary £51,250 £52,500 £55,000
Median salary % change year-on-year -2.38% -4.54%  
90% offered a salary of more than £35,000 £36,000 £35,000
10% offered a salary of more than £70,000 £67,500 £75,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year - +5.88%  

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 26033 31905 33071
As % of all permanent IT job vacancies advertised in the UK 30.64% 30.99% 31.30%
Number of salaries quoted 22070 27162 28001
Median salary £47,500 £50,000 £45,000
Median salary % change year-on-year -5.00% +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

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 24 March 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 24 March 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 +28 264 £52,500 - 37
London +21 123 £61,250 +6.52% 14
South East +75 73 £55,000 +10.00% 3
City of London +39 28 £62,500 +8.69% 5
Surrey +43 24 £55,000 - 2
East of England +13 16 £43,000 -28.33% 3
Buckinghamshire - 15 £63,750 -
West Midlands +16 13 £45,000 -5.75% 4
East Midlands +8 13 £42,500 +6.25% 2
Berkshire +37 12 £39,750 -20.50%
Yorkshire -12 12 £42,500 +3.65% 1
North West -16 12 £36,000 -20.00% 8
Milton Keynes - 12 £87,000 -
Reading +37 11 £39,750 -24.28%
West Yorkshire -8 11 £42,500 +3.65% 1
Manchester -14 11 £36,000 +6.66% 4
Guildford - 11 £55,000 -
Northamptonshire - 10 £42,500 - 1
Leeds -13 9 £42,500 +6.25% 1
Suffolk +29 8 £43,000 -33.84% 1
Kent +23 7 £50,000 +29.03%
Northampton - 7 £42,500 -
Glasgow +30 5 £38,000 -5.00%
Scotland +19 5 £38,000 -10.58%
Oxfordshire +2 5 £50,000 +4.16%
Oxford - 5 £50,000 -
West Sussex +14 4 £47,500 +7.34% 1
Birmingham +10 4 £33,750 -3.57%
Hertfordshire +1 4 £45,000 -16.27% 1
Egham -7 4 £55,000 - 1

OLAP
Top 30 Related IT Skills

For the 6 months to 24 March 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 416 (77.32%) SQL
2 382 (71.00%) Business Intelligence
3 343 (63.75%) SQL Server
4 315 (58.55%) Data Warehouse
5 311 (57.81%) SQL Server Integration Services
6 291 (54.09%) SQL Server Reporting Services
7 279 (51.86%) SQL Server Analysis Services
8 265 (49.26%) ETL
9 246 (45.72%) Microsoft
10 213 (39.59%) T-SQL
11 158 (29.37%) Agile Software Development
12 151 (28.07%) OLAP Cube
13 135 (25.09%) OLTP
14 130 (24.16%) MS Excel
15 128 (23.79%) Power BI
16 127 (23.61%) Finance
17 120 (22.30%) Oracle
17 120 (22.30%) Oracle OLAP
18 108 (20.07%) Data Modelling
19 107 (19.89%) SQL Server 2012
19 107 (19.89%) Analytics
20 102 (18.96%) Relational Database
21 95 (17.66%) Kimball Methodology
22 92 (17.10%) MDX
23 90 (16.73%) SQL Server 2008
23 90 (16.73%) .NET
24 89 (16.54%) Big Data
25 88 (16.36%) Performance Tuning
26 77 (14.31%) Tableau
27 74 (13.75%) Analytical Skills

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 41 (7.62%) SharePoint
2 25 (4.65%) Apache
3 24 (4.46%) IIS
4 21 (3.90%) Apache Spark
5 15 (2.79%) Elasticsearch
6 13 (2.42%) Tomcat
6 13 (2.42%) WebSphere
7 11 (2.04%) Apache Airflow
7 11 (2.04%) Apache Pig
7 11 (2.04%) Oracle Coherence
7 11 (2.04%) Oracle HTTP Server
8 8 (1.49%) SAS
9 7 (1.30%) Oracle SOA Suite
10 6 (1.12%) Oracle Service Bus
11 4 (0.74%) SharePoint 2013
12 3 (0.56%) Jupyter
13 2 (0.37%) Apache Solr
14 1 (0.19%) SharePoint Server
14 1 (0.19%) Skype for Business
Applications
1 130 (24.16%) MS Excel
2 13 (2.42%) MS Visio
3 6 (1.12%) MS Office
4 1 (0.19%) MS PowerPoint
4 1 (0.19%) SPSS
Business Applications
1 16 (2.97%) Cognos TM1
2 8 (1.49%) SAP BPC
3 5 (0.93%) Dynamics AX
3 5 (0.93%) FastStats
4 4 (0.74%) Cognos Business Intelligence
4 4 (0.74%) Infor SunSystems
5 3 (0.56%) Dynamics CRM
5 3 (0.56%) Hyperion Planning
6 2 (0.37%) Adobe Campaign
6 2 (0.37%) Dynamics NAV
6 2 (0.37%) Eloqua
6 2 (0.37%) HFM
6 2 (0.37%) Unica
7 1 (0.19%) Cognos Planning
7 1 (0.19%) OPENHousing
7 1 (0.19%) Oracle Applications
7 1 (0.19%) SAP ERP
Cloud Services
1 51 (9.48%) Microsoft Azure
2 24 (4.46%) Amazon AWS
3 11 (2.04%) Amazon Kinesis
4 10 (1.86%) GitHub
5 6 (1.12%) SaaS
6 5 (0.93%) Azure Machine Learning
6 5 (0.93%) Data Lake Analytics
6 5 (0.93%) Google Cloud Platform
7 4 (0.74%) Google Analytics
7 4 (0.74%) IaaS
8 2 (0.37%) Responsys
9 1 (0.19%) Adobe Analytics
9 1 (0.19%) PaaS
Communications & Networking
1 23 (4.28%) Intranet
2 20 (3.72%) SAN
3 14 (2.60%) NAS
4 12 (2.23%) HTTP
4 12 (2.23%) LAN
4 12 (2.23%) WAN
5 11 (2.04%) FCoE
5 11 (2.04%) Fibre Channel
5 11 (2.04%) iSCSI
5 11 (2.04%) Multicast
6 4 (0.74%) Ethernet
7 3 (0.56%) Internet
7 3 (0.56%) SSL
8 2 (0.37%) Extranet
9 1 (0.19%) Cisco ASA
9 1 (0.19%) DHCP
9 1 (0.19%) DNS
9 1 (0.19%) Firewall
9 1 (0.19%) FTP
9 1 (0.19%) HTTPS
Database & Business Intelligence
1 343 (63.75%) SQL Server
2 315 (58.55%) Data Warehouse
3 311 (57.81%) SQL Server Integration Services
4 291 (54.09%) SQL Server Reporting Services
5 279 (51.86%) SQL Server Analysis Services
6 151 (28.07%) OLAP Cube
7 135 (25.09%) OLTP
8 128 (23.79%) Power BI
9 120 (22.30%) Oracle OLAP
10 107 (19.89%) SQL Server 2012
11 102 (18.96%) Relational Database
12 90 (16.73%) SQL Server 2008
13 89 (16.54%) Big Data
14 73 (13.57%) Hadoop
15 65 (12.08%) MySQL
16 61 (11.34%) QlikView
16 61 (11.34%) SQL Server 2014
17 53 (9.85%) Microsoft Analysis Services
18 47 (8.74%) RDBMS
18 47 (8.74%) SQL Server 2016
Development Applications
1 51 (9.48%) Visual Studio
2 40 (7.43%) Team Foundation Server
3 33 (6.13%) JIRA
4 15 (2.79%) Talend Open Studio
5 14 (2.60%) Visual Studio Team System
6 9 (1.67%) Git (software)
7 8 (1.49%) Eclipse
7 8 (1.49%) ERwin
7 8 (1.49%) PowerDesigner
8 7 (1.30%) git-flow
8 7 (1.30%) MagicDraw
9 5 (0.93%) SQL Server Management Studio (SSMS)
10 4 (0.74%) JUnit
11 3 (0.56%) Maven
12 2 (0.37%) Oracle Forms
12 2 (0.37%) Subversion
12 2 (0.37%) TestNG
13 1 (0.19%) MSTest
13 1 (0.19%) SpecFlow
13 1 (0.19%) TortoiseSVN
General
1 127 (23.61%) Finance
2 41 (7.62%) Advertising
3 26 (4.83%) Banking
4 25 (4.65%) Legal
4 25 (4.65%) Marketing
5 20 (3.72%) Manufacturing
6 13 (2.42%) Investment Banking
7 10 (1.86%) Financial Institution
7 10 (1.86%) Retail
8 8 (1.49%) German Language
8 8 (1.49%) Spanish Language
9 6 (1.12%) French Language
9 6 (1.12%) Games
10 4 (0.74%) Automotive
10 4 (0.74%) Back Office
10 4 (0.74%) Dutch Language
10 4 (0.74%) Electronics
10 4 (0.74%) General Ledger
10 4 (0.74%) Italian Language
11 3 (0.56%) Music Industry
Job Titles
1 274 (50.93%) Developer
2 153 (28.44%) Business Intelligence Developer
3 97 (18.03%) SQL Developer
4 93 (17.29%) Analyst
5 68 (12.64%) Senior Developer
6 67 (12.45%) DBA
7 52 (9.67%) SSIS Developer
8 49 (9.11%) SQL BI Developer
9 48 (8.92%) Business Intelligence Analyst
10 44 (8.18%) SQL DBA
11 43 (7.99%) SSRS Developer
12 41 (7.62%) Architect
13 40 (7.43%) SSAS Developer
14 39 (7.25%) Data Warehouse Developer
15 31 (5.76%) Senior Business Intelligence Developer
15 31 (5.76%) SQL Server Developer
16 30 (5.58%) Business Developer
17 29 (5.39%) Administrator
17 29 (5.39%) ETL Developer
18 28 (5.20%) SQL Analyst
Libraries, Frameworks & Software Standards
1 92 (17.10%) MDX
2 90 (16.73%) .NET
3 34 (6.32%) XML
4 24 (4.46%) Web Services
5 19 (3.53%) Oracle GoldenGate
6 17 (3.16%) HTML
7 15 (2.79%) Middleware
8 14 (2.60%) ASP.NET
9 12 (2.23%) Kafka
10 11 (2.04%) Scrapy
11 8 (1.49%) GraphX
11 8 (1.49%) Serverless Framework
12 7 (1.30%) .NET Framework
12 7 (1.30%) JSON
13 6 (1.12%) SOAP
13 6 (1.12%) Spring
14 5 (0.93%) Akka
14 5 (0.93%) CSS
14 5 (0.93%) REST
15 4 (0.74%) Lucene
Miscellaneous
1 74 (13.75%) Analytical Skills
2 50 (9.29%) Management Information System
3 39 (7.25%) Replication
4 25 (4.65%) Clustering
5 20 (3.72%) Computer Science
5 20 (3.72%) Fintech
6 6 (1.12%) Data Structures
6 6 (1.12%) Mobile App
6 6 (1.12%) Reference Data
7 5 (0.93%) NHS
7 5 (0.93%) Taxonomies
8 4 (0.74%) Data Protection Act
8 4 (0.74%) Social Media
9 3 (0.56%) Data Centre
9 3 (0.56%) Enterprise Software
9 3 (0.56%) Online Games
10 2 (0.37%) iPad
10 2 (0.37%) Spread Betting
10 2 (0.37%) User Experience
11 1 (0.19%) FMCG
Operating Systems
1 43 (7.99%) Windows
2 32 (5.95%) Linux
3 16 (2.97%) Windows Server 2008
4 15 (2.79%) Windows Server 2012
5 12 (2.23%) Unix
6 11 (2.04%) Solaris
7 10 (1.86%) Windows Server
Processes & Methodologies
1 382 (71.00%) Business Intelligence
2 265 (49.26%) ETL
3 158 (29.37%) Agile Software Development
4 108 (20.07%) Data Modelling
5 107 (19.89%) Analytics
6 95 (17.66%) Kimball Methodology
7 88 (16.36%) Performance Tuning
8 70 (13.01%) Dimensional Modelling
9 56 (10.41%) Scrum
10 49 (9.11%) Visualisation
11 45 (8.36%) Data Integration
12 43 (7.99%) Time Management
13 42 (7.81%) SDLC
14 36 (6.69%) ITIL
15 35 (6.51%) Data Visualisation
16 34 (6.32%) Mentoring
17 32 (5.95%) Performance Monitoring
18 31 (5.76%) Disaster Recovery
19 29 (5.39%) Migration
20 28 (5.20%) Stakeholder Management
Programming Languages
1 416 (77.32%) SQL
2 213 (39.59%) T-SQL
3 66 (12.27%) C#
4 50 (9.29%) PL/SQL
5 37 (6.88%) Data Analysis Expressions (DAX)
6 26 (4.83%) Java
7 23 (4.28%) Python
8 15 (2.79%) VB.NET
9 14 (2.60%) JavaScript
9 14 (2.60%) PowerShell
9 14 (2.60%) R
10 13 (2.42%) VBA
11 7 (1.30%) Scala
12 6 (1.12%) C
12 6 (1.12%) Shell Script
13 5 (0.93%) ABAP
13 5 (0.93%) C++
14 4 (0.74%) Embedded C
14 4 (0.74%) Embedded C++
14 4 (0.74%) PHP
Qualifications
1 68 (12.64%) Degree
2 19 (3.53%) Microsoft Certification
3 6 (1.12%) MCSE
4 5 (0.93%) CIMA
4 5 (0.93%) MCITP
4 5 (0.93%) SC Cleared
4 5 (0.93%) Security Cleared
5 2 (0.37%) MCTS
6 1 (0.19%) Postgraduate
Quality Assurance & Compliance
1 53 (9.85%) Data Quality
2 26 (4.83%) QA
3 14 (2.60%) SLA
4 5 (0.93%) ISO20022
4 5 (0.93%) PMO
5 2 (0.37%) ISO/IEC 20000
5 2 (0.37%) PCI DSS
6 1 (0.19%) Basel III
6 1 (0.19%) Dodd-Frank
6 1 (0.19%) EFQM
6 1 (0.19%) IFRS
6 1 (0.19%) IFRS 9
System Software
1 17 (3.16%) Oracle RAC
2 14 (2.60%) VMware Infrastructure
3 13 (2.42%) KVM
4 11 (2.04%) Hyper-V
4 11 (2.04%) NFS
4 11 (2.04%) SRDF
4 11 (2.04%) Xen
5 8 (1.49%) Active Directory
6 4 (0.74%) Firmware
7 3 (0.56%) HDFS
8 2 (0.37%) Apache ZooKeeper
9 1 (0.19%) Apache Flume
9 1 (0.19%) VMware ESXi
Systems Management
1 11 (2.04%) Kibana
2 10 (1.86%) Puppet
3 6 (1.12%) Enterprise Manager Cloud Control
3 6 (1.12%) Oracle Enterprise Manager
3 6 (1.12%) Oracle RMAN
4 2 (0.37%) Hadoop YARN
4 2 (0.37%) Oozie
4 2 (0.37%) Perfmon
5 1 (0.19%) WSUS
Vendors
1 246 (45.72%) Microsoft
2 120 (22.30%) Oracle
3 77 (14.31%) Tableau
4 51 (9.48%) Cognos
5 28 (5.20%) IBM
6 20 (3.72%) SAP
7 15 (2.79%) Cisco
7 15 (2.79%) EMC
7 15 (2.79%) MicroStrategy
7 15 (2.79%) Talend
8 14 (2.60%) VMware
9 11 (2.04%) Google
9 11 (2.04%) Intel
9 11 (2.04%) NetApp
10 10 (1.86%) Hyperion
11 9 (1.67%) Informatica
12 8 (1.49%) Sybase
13 7 (1.30%) Infor
13 7 (1.30%) SolarWinds
14 5 (0.93%) Salesforce.com
Preston
Nigel Frank International
Salary: £25000 - £32000 per annum + company benefits
Posted: 17 hours ago
Manchester
Nigel Frank International
Salary: £25000 - £32000 per annum + company benefits
Posted: 17 hours ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 15 hours ago
Hatfield, Hertfordshire
ComputaCenter
Salary: Benefits
Posted: Yesterday
Leeds, West Yorkshire
Rullion
Salary: £60000 - £70000 per annum + comprehensive benefits
Posted: 16 hours ago
City, London
The Datawarehousing Company
Salary: £65,000 per annum + pension, medical, dental, critical illness, childc
Posted: 2 days ago
Worcestershire
Rullion
Salary: £40000 per annum + extensive benefits
Posted: 3 days ago
Worcester, Worcestershire
Sanderson
Salary: £37000 - £40000 per annum
Posted: 2 days ago
Chester
Nigel Frank International
Salary: £40000 - £50000 per annum + company package and benefits
Posted: 2 days ago
Burton-On-Trent, Staffordshire
Blues Point Ltd
Salary: From £34,000 to £41,000 per annum + benefits inc pension, 25 days hol
Posted: 2 days ago
Cambridge
Nigel Frank International
Salary: £30000 - £50000 per annum + Benefits
Posted: 2 days ago
Bath
Wessex Water
Salary: Circa £40k dependent on experience
Posted: Yesterday
West Midlands
Austin Fraser
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: Yesterday
London
Premier IT
Salary: £45000 - £60000 per annum
Posted: Yesterday
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: 18 hours ago
City of London
Lawrence Harvey
Salary: £600 - £700 per annum
Posted: 4 days ago
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 4 days ago
Central London / West End
The Workshop
Posted: 3 days ago
Egham, Surrey
Spargonet Consulting Plc
Salary: £50000 - £60000 per annum, Benefits Pension, Life, Health and 25 days
Posted: 5 days ago
City of London
Huxley
Salary: competitive
Posted: 8 days ago
Surrey
Opus Recruitment Solutions Ltd
Salary: £50000 - £70000 per annum, Benefits Benefits & Bonus included
Posted: 4 days ago
Haywards Heath
Nigel Frank International
Salary: £40000 - £55000 per annum + Benfits
Posted: 10 days ago
London
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 15 days ago
Ipswich
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 16 days ago
Manchester
Bupa
Posted: 10 days ago
Northamptonshire
Lawrence Harvey
Salary: £45000 - £50000 per annum
Posted: 16 days ago
Devon
Nigel Frank International
Salary: £38000 - £50000 per annum + pension, negotiable
Posted: 23 days ago
City of London
Lawrence Harvey
Salary: £50000.00 - £65000.00 per annum
Posted: 16 days ago
Salford, Lancashire
BLM law
Salary: Competitive salary and company benefits
Posted: 17 days ago
West London
London Borough of Ealing
Salary: From £33,996 to £42,450 per annum
Posted: 23 days ago