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

Online Analytical Processing (OLAP)
UK
3 months to
28 Mar 2017
Same period 2016 Same period 2015
Rank 589 603 519
Rank change year-on-year +14 -84  
Permanent jobs citing OLAP 273 373 539
As % of all permanent IT jobs advertised in the UK 0.32% 0.36% 0.50%
As % of the Database & Business Intelligence category 1.04% 1.16% 1.59%
Number of salaries quoted 241 293 408
Median salary £52,500 £52,500 £55,000
Median salary % change year-on-year - -4.54%  
90% offered a salary of more than £35,000 £36,000 £35,000
10% offered a salary of more than £70,000 £69,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 26256 32144 33841
As % of all permanent IT job vacancies advertised in the UK 30.81% 30.91% 31.32%
Number of salaries quoted 22270 27377 28672
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 28 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 28 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 +25 264 £52,500 - 37
London +31 124 £60,000 +4.34% 18
South East +69 73 £55,000 +10.00% 1
City of London +27 29 £62,500 +8.69% 5
Surrey +58 25 £55,000 -
East of England +8 14 £43,000 -28.33% 3
Buckinghamshire - 14 £80,000 -
West Midlands +30 13 £45,000 -14.28% 3
East Midlands +13 13 £42,500 +6.25% 1
Berkshire +41 12 £39,750 -24.28%
Yorkshire -4 12 £42,500 +4.93% 1
North West -12 12 £36,000 -20.00% 8
Reading +40 11 £39,750 -24.28%
West Yorkshire 0 11 £42,500 +3.65% 1
Manchester -18 11 £36,000 +6.66% 5
Guildford - 11 £55,000 -
Milton Keynes - 11 £87,000 -
Northamptonshire - 10 £42,500 - 1
Leeds -2 9 £42,500 +6.25% 1
Kent +25 7 £50,000 +25.00%
Northampton - 7 £42,500 -
Suffolk +26 6 £43,000 -33.84% 1
Glasgow +23 5 £38,000 -5.00%
Scotland +22 5 £38,000 -13.14%
Oxfordshire +6 5 £50,000 +4.16%
Oxford - 5 £50,000 -
West Sussex +12 4 £47,500 +7.34% 1
Birmingham +11 4 £33,750 -3.57%
Hertfordshire +7 4 £45,000 -16.27% 1
Egham -5 4 £55,000 -

For the 6 months to 28 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 415 (77.28%) SQL
2 381 (70.95%) Business Intelligence
3 342 (63.69%) SQL Server
4 314 (58.47%) Data Warehouse
5 312 (58.10%) SQL Server Integration Services
6 291 (54.19%) SQL Server Reporting Services
7 279 (51.96%) SQL Server Analysis Services
8 265 (49.35%) ETL
9 246 (45.81%) Microsoft
10 212 (39.48%) T-SQL
11 156 (29.05%) Agile Software Development
12 152 (28.31%) OLAP Cube
13 134 (24.95%) OLTP
14 129 (24.02%) Power BI
15 128 (23.84%) MS Excel
16 127 (23.65%) Finance
17 118 (21.97%) Oracle
17 118 (21.97%) Oracle OLAP
18 109 (20.30%) Data Modelling
19 106 (19.74%) Analytics
20 105 (19.55%) SQL Server 2012
21 103 (19.18%) Relational Database
22 95 (17.69%) Kimball Methodology
23 91 (16.95%) .NET
23 91 (16.95%) MDX
23 91 (16.95%) SQL Server 2008
24 90 (16.76%) Big Data
25 87 (16.20%) Performance Tuning
26 76 (14.15%) Tableau
27 74 (13.78%) Analytical Skills

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 41 (7.64%) SharePoint
2 24 (4.47%) Apache
3 23 (4.28%) IIS
4 21 (3.91%) Apache Spark
5 16 (2.98%) Elasticsearch
6 12 (2.23%) Tomcat
6 12 (2.23%) WebSphere
7 11 (2.05%) Apache Airflow
7 11 (2.05%) Apache Pig
8 10 (1.86%) Oracle Coherence
8 10 (1.86%) Oracle HTTP Server
9 8 (1.49%) SAS
10 7 (1.30%) Oracle SOA Suite
11 6 (1.12%) Oracle Service Bus
12 4 (0.74%) SharePoint 2013
13 3 (0.56%) Jupyter
14 2 (0.37%) Apache Solr
15 1 (0.19%) SharePoint Server
15 1 (0.19%) Skype for Business
Applications
1 128 (23.84%) MS Excel
2 14 (2.61%) MS Visio
3 6 (1.12%) MS Office
4 1 (0.19%) MS PowerPoint
4 1 (0.19%) SPSS
Business Applications
1 16 (2.98%) 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 52 (9.68%) Microsoft Azure
2 25 (4.66%) Amazon AWS
3 11 (2.05%) 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
7 4 (0.74%) Google Analytics
7 4 (0.74%) Google Cloud Platform
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 19 (3.54%) SAN
3 13 (2.42%) NAS
4 11 (2.05%) HTTP
4 11 (2.05%) LAN
4 11 (2.05%) WAN
5 10 (1.86%) FCoE
5 10 (1.86%) Fibre Channel
5 10 (1.86%) iSCSI
5 10 (1.86%) 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 342 (63.69%) SQL Server
2 314 (58.47%) Data Warehouse
3 312 (58.10%) SQL Server Integration Services
4 291 (54.19%) SQL Server Reporting Services
5 279 (51.96%) SQL Server Analysis Services
6 152 (28.31%) OLAP Cube
7 134 (24.95%) OLTP
8 129 (24.02%) Power BI
9 118 (21.97%) Oracle OLAP
10 105 (19.55%) SQL Server 2012
11 103 (19.18%) Relational Database
12 91 (16.95%) SQL Server 2008
13 90 (16.76%) Big Data
14 73 (13.59%) Hadoop
15 66 (12.29%) MySQL
16 60 (11.17%) SQL Server 2014
17 59 (10.99%) QlikView
18 53 (9.87%) Microsoft Analysis Services
19 48 (8.94%) RDBMS
20 46 (8.57%) SQL Server 2005
Development Applications
1 51 (9.50%) Visual Studio
2 37 (6.89%) Team Foundation Server
3 33 (6.15%) JIRA
4 15 (2.79%) Talend Open Studio
5 14 (2.61%) Visual Studio Team System
6 9 (1.68%) Git (software)
6 9 (1.68%) PowerDesigner
7 8 (1.49%) Eclipse
7 8 (1.49%) ERwin
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.65%) Finance
2 42 (7.82%) Advertising
3 26 (4.84%) Banking
3 26 (4.84%) Legal
4 25 (4.66%) 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 273 (50.84%) Developer
2 151 (28.12%) Business Intelligence Developer
3 98 (18.25%) SQL Developer
4 93 (17.32%) Analyst
5 68 (12.66%) Senior Developer
6 67 (12.48%) DBA
7 54 (10.06%) SSIS Developer
8 50 (9.31%) SQL BI Developer
9 48 (8.94%) Business Intelligence Analyst
10 44 (8.19%) SQL DBA
10 44 (8.19%) SSRS Developer
11 42 (7.82%) SSAS Developer
12 41 (7.64%) Architect
13 38 (7.08%) Data Warehouse Developer
14 32 (5.96%) SQL Server Developer
15 31 (5.77%) Senior Business Intelligence Developer
16 30 (5.59%) ETL Developer
17 28 (5.21%) Administrator
17 28 (5.21%) Business Developer
17 28 (5.21%) SQL Analyst
Libraries, Frameworks & Software Standards
1 91 (16.95%) .NET
1 91 (16.95%) MDX
2 33 (6.15%) XML
3 24 (4.47%) Web Services
4 18 (3.35%) HTML
4 18 (3.35%) Oracle GoldenGate
5 15 (2.79%) ASP.NET
6 14 (2.61%) Middleware
7 12 (2.23%) Kafka
8 11 (2.05%) Scrapy
9 8 (1.49%) GraphX
9 8 (1.49%) Serverless Framework
10 7 (1.30%) .NET Framework
11 6 (1.12%) JSON
11 6 (1.12%) SOAP
11 6 (1.12%) Spring
12 5 (0.93%) Akka
12 5 (0.93%) CSS
12 5 (0.93%) jQuery
12 5 (0.93%) REST
Miscellaneous
1 74 (13.78%) Analytical Skills
2 50 (9.31%) Management Information System
3 39 (7.26%) Replication
4 25 (4.66%) Clustering
5 20 (3.72%) Computer Science
5 20 (3.72%) Fintech
6 7 (1.30%) Data Structures
7 6 (1.12%) Mobile App
7 6 (1.12%) Reference Data
8 5 (0.93%) NHS
8 5 (0.93%) Taxonomies
9 4 (0.74%) Data Protection Act
9 4 (0.74%) Social Media
10 3 (0.56%) Data Centre
10 3 (0.56%) Enterprise Software
10 3 (0.56%) Online Games
11 2 (0.37%) iPad
11 2 (0.37%) Spread Betting
11 2 (0.37%) User Experience
12 1 (0.19%) FMCG
Operating Systems
1 42 (7.82%) Windows
2 32 (5.96%) Linux
3 16 (2.98%) Windows Server 2008
4 15 (2.79%) Windows Server 2012
5 12 (2.23%) Unix
6 10 (1.86%) Solaris
6 10 (1.86%) Windows Server
Processes & Methodologies
1 381 (70.95%) Business Intelligence
2 265 (49.35%) ETL
3 156 (29.05%) Agile Software Development
4 109 (20.30%) Data Modelling
5 106 (19.74%) Analytics
6 95 (17.69%) Kimball Methodology
7 87 (16.20%) Performance Tuning
8 70 (13.04%) Dimensional Modelling
9 57 (10.61%) Scrum
10 49 (9.12%) Visualisation
11 45 (8.38%) Data Integration
12 43 (8.01%) SDLC
12 43 (8.01%) Time Management
13 36 (6.70%) ITIL
14 35 (6.52%) Data Visualisation
15 34 (6.33%) Mentoring
16 32 (5.96%) Performance Monitoring
17 31 (5.77%) Disaster Recovery
18 28 (5.21%) Migration
18 28 (5.21%) Stakeholder Management
Programming Languages
1 415 (77.28%) SQL
2 212 (39.48%) T-SQL
3 66 (12.29%) C#
4 49 (9.12%) PL/SQL
5 37 (6.89%) Data Analysis Expressions (DAX)
6 26 (4.84%) Java
7 24 (4.47%) Python
8 15 (2.79%) JavaScript
8 15 (2.79%) R
8 15 (2.79%) VB.NET
9 13 (2.42%) PowerShell
9 13 (2.42%) VBA
10 7 (1.30%) Scala
11 6 (1.12%) C
11 6 (1.12%) Shell Script
12 5 (0.93%) ABAP
12 5 (0.93%) C++
13 4 (0.74%) Embedded C
13 4 (0.74%) Embedded C++
13 4 (0.74%) PHP
Qualifications
1 68 (12.66%) Degree
2 20 (3.72%) Microsoft Certification
3 7 (1.30%) 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.87%) Data Quality
2 26 (4.84%) QA
3 14 (2.61%) 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 16 (2.98%) Oracle RAC
2 14 (2.61%) VMware Infrastructure
3 13 (2.42%) KVM
4 10 (1.86%) Hyper-V
4 10 (1.86%) NFS
4 10 (1.86%) SRDF
4 10 (1.86%) 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.05%) 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.81%) Microsoft
2 118 (21.97%) Oracle
3 76 (14.15%) Tableau
4 51 (9.50%) Cognos
5 27 (5.03%) IBM
6 20 (3.72%) SAP
7 15 (2.79%) MicroStrategy
7 15 (2.79%) Talend
8 14 (2.61%) Cisco
8 14 (2.61%) EMC
8 14 (2.61%) VMware
9 10 (1.86%) Google
9 10 (1.86%) Hyperion
9 10 (1.86%) Intel
9 10 (1.86%) NetApp
10 9 (1.68%) Informatica
10 9 (1.68%) Sybase
11 7 (1.30%) Infor
11 7 (1.30%) SolarWinds
12 5 (0.93%) Salesforce.com
London
Nigel Frank International
Salary: £40000 - £50000 per annum
Posted: 20 hours ago
London
Nigel Frank International
Salary: £40000 - £50000 per annum
Posted: 19 hours ago
London
Talent International
Salary: £350 - £500 per day
Posted: Yesterday
Stockport, Cheshire
Adria Solutions Ltd
Salary: £25000 - £30000 per annum + Bonus + Benefits
Posted: 9 hours ago
London
Venturi
Salary: £40000 - £60000.00 per annum + company benefits
Posted: Yesterday
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: Yesterday
Manchester
Nigel Frank International
Salary: £25000 - £32000 per annum + company benefits
Posted: 4 days ago
Preston
Nigel Frank International
Salary: £25000 - £32000 per annum + company benefits
Posted: 4 days ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 4 days ago
City, London
The Datawarehousing Company
Salary: £65,000 per annum + pension, medical, dental, critical illness, childc
Posted: 6 days ago
Worcester, Worcestershire
Sanderson
Salary: £37000 - £40000 per annum
Posted: 6 days ago
Hatfield, Hertfordshire
ComputaCenter
Salary: Benefits
Posted: 5 days ago
Chester
Nigel Frank International
Salary: £40000 - £50000 per annum + company package and benefits
Posted: 6 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + stock options
Posted: Yesterday
Burton-On-Trent, Staffordshire
Blues Point Ltd
Salary: From £34,000 to £41,000 per annum + benefits inc pension, 25 days hol
Posted: 6 days ago
Cambridge
Nigel Frank International
Salary: £30000 - £50000 per annum + Benefits
Posted: 6 days ago
Bath
Wessex Water
Salary: Circa £40k dependent on experience
Posted: 5 days ago
Leeds, West Yorkshire
Rullion
Salary: £60000 - £70000 per annum + comprehensive benefits
Posted: 4 days ago
City of London
Lawrence Harvey
Salary: £600 - £700 per annum
Posted: 8 days ago
West Midlands
Austin Fraser
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: 5 days ago
London
Premier IT
Salary: £45000 - £60000 per annum
Posted: 5 days ago
Central London / West End
The Workshop
Posted: 7 days ago
City of London
Huxley
Salary: competitive
Posted: 11 days ago
Haywards Heath
Nigel Frank International
Salary: £40000 - £55000 per annum + Benfits
Posted: 14 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: 4 days ago
Ipswich
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 20 days ago
Northamptonshire
Lawrence Harvey
Salary: £45000 - £50000 per annum
Posted: 20 days ago
Manchester
Bupa
Posted: 13 days ago
Devon
Nigel Frank International
Salary: £38000 - £50000 per annum + pension, negotiable
Posted: 27 days ago
City of London
Lawrence Harvey
Salary: £50000.00 - £65000.00 per annum
Posted: 20 days ago