The following table provides summary statistics for permanent job vacancies advertised in England 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 29 March 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK / England
3 months to
29 Mar 2017
Same period 2016 Same period 2015
Rank 588 585 507
Rank change year-on-year -3 -78  
Permanent jobs citing OLAP 260 350 504
As % of all permanent IT jobs advertised in England 0.32% 0.36% 0.50%
As % of the Database & Business Intelligence category 1.06% 1.16% 1.61%
Number of salaries quoted 229 280 388
Median salary £52,500 £52,500 £55,000
Median salary % change year-on-year - -4.54%  
90% offered a salary of more than £36,000 £36,000 £35,000
10% offered a salary of more than £70,000 £70,000 £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 advertised in England with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 24462 30231 31353
As % of all permanent IT job vacancies advertised in England 30.50% 30.88% 31.27%
Number of salaries quoted 21017 26056 26826
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year - +11.11%  
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year - +6.25%  

OLAP
Job Vacancy Trend in England

The job posting trend of jobs advertised in England 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 England

OLAP
Salary Trend in England

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

Salary trend for OLAP in England

OLAP
Salary Histogram in England

The salary distribution of IT jobs citing OLAP in England over the 3 months to 29 March 2017.

Salary histogram for OLAP in England

OLAP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the England region over the 3 months to 29 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
London +20 125 £60,000 +4.34% 18
South East +76 68 £55,000 +10.00% 1
East of England +8 15 £43,000 -28.33% 3
North West -6 13 £36,000 -20.00% 8
West Midlands +20 12 £36,750 -30.00% 3
East Midlands +5 12 £42,500 +6.25% 1
Yorkshire 0 12 £42,500 +4.93% 1
South West +24 2 £46,250 +28.47% 2
OLAP
UK

For the 6 months to 29 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 across the England region with a requirement for OLAP.

1 400 (77.67%) SQL
2 372 (72.23%) Business Intelligence
3 328 (63.69%) SQL Server
4 300 (58.25%) Data Warehouse
4 300 (58.25%) SQL Server Integration Services
5 283 (54.95%) SQL Server Reporting Services
6 271 (52.62%) SQL Server Analysis Services
7 255 (49.51%) ETL
8 238 (46.21%) Microsoft
9 200 (38.83%) T-SQL
10 151 (29.32%) Agile Software Development
11 145 (28.16%) OLAP Cube
12 125 (24.27%) OLTP
13 124 (24.08%) MS Excel
14 123 (23.88%) Power BI
15 121 (23.50%) Finance
16 116 (22.52%) Oracle
16 116 (22.52%) Oracle OLAP
17 102 (19.81%) Data Modelling
17 102 (19.81%) Relational Database
18 99 (19.22%) SQL Server 2012
18 99 (19.22%) Analytics
19 94 (18.25%) Kimball Methodology
20 91 (17.67%) .NET
21 90 (17.48%) Big Data
22 88 (17.09%) MDX
23 86 (16.70%) SQL Server 2008
24 85 (16.50%) Performance Tuning
25 72 (13.98%) Hadoop
26 71 (13.79%) Tableau

OLAP
Co-occurring IT Skills in England 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 (7.77%) SharePoint
2 24 (4.66%) Apache
3 22 (4.27%) IIS
4 21 (4.08%) Apache Spark
5 16 (3.11%) Elasticsearch
6 12 (2.33%) Tomcat
6 12 (2.33%) WebSphere
7 11 (2.14%) Apache Airflow
7 11 (2.14%) Apache Pig
8 10 (1.94%) Oracle Coherence
8 10 (1.94%) Oracle HTTP Server
9 8 (1.55%) SAS
10 7 (1.36%) Oracle SOA Suite
11 6 (1.17%) Oracle Service Bus
12 4 (0.78%) SharePoint 2013
13 3 (0.58%) Jupyter
14 2 (0.39%) Apache Solr
15 1 (0.19%) BizTalk Server
15 1 (0.19%) SharePoint Server
Applications
1 124 (24.08%) MS Excel
2 14 (2.72%) MS Visio
3 6 (1.17%) MS Office
4 1 (0.19%) MS PowerPoint
4 1 (0.19%) SPSS
Business Applications
1 17 (3.30%) Cognos TM1
2 8 (1.55%) SAP BPC
3 5 (0.97%) FastStats
3 5 (0.97%) Infor SunSystems
4 4 (0.78%) Cognos Business Intelligence
4 4 (0.78%) Dynamics AX
5 3 (0.58%) Dynamics CRM
5 3 (0.58%) Hyperion Planning
6 2 (0.39%) Adobe Campaign
6 2 (0.39%) Dynamics NAV
6 2 (0.39%) Eloqua
6 2 (0.39%) HFM
6 2 (0.39%) Unica
7 1 (0.19%) Cognos Planning
7 1 (0.19%) OPENHousing
7 1 (0.19%) Oracle Applications
Cloud Services
1 49 (9.51%) Microsoft Azure
2 23 (4.47%) Amazon AWS
3 11 (2.14%) Amazon Kinesis
4 10 (1.94%) GitHub
5 6 (1.17%) SaaS
6 5 (0.97%) Azure Machine Learning
6 5 (0.97%) Data Lake Analytics
7 4 (0.78%) Google Cloud Platform
7 4 (0.78%) IaaS
8 2 (0.39%) Responsys
9 1 (0.19%) Adobe Analytics
9 1 (0.19%) Google Analytics
9 1 (0.19%) PaaS
Communications & Networking
1 23 (4.47%) Intranet
2 18 (3.50%) SAN
3 13 (2.52%) NAS
4 11 (2.14%) HTTP
4 11 (2.14%) LAN
4 11 (2.14%) WAN
5 10 (1.94%) FCoE
5 10 (1.94%) Fibre Channel
5 10 (1.94%) iSCSI
5 10 (1.94%) Multicast
6 4 (0.78%) Ethernet
7 3 (0.58%) Internet
7 3 (0.58%) SSL
8 2 (0.39%) Extranet
9 1 (0.19%) FTP
9 1 (0.19%) Modbus
9 1 (0.19%) RS-485
Database & Business Intelligence
1 328 (63.69%) SQL Server
2 300 (58.25%) Data Warehouse
2 300 (58.25%) SQL Server Integration Services
3 283 (54.95%) SQL Server Reporting Services
4 271 (52.62%) SQL Server Analysis Services
5 145 (28.16%) OLAP Cube
6 125 (24.27%) OLTP
7 123 (23.88%) Power BI
8 116 (22.52%) Oracle OLAP
9 102 (19.81%) Relational Database
10 99 (19.22%) SQL Server 2012
11 90 (17.48%) Big Data
12 86 (16.70%) SQL Server 2008
13 72 (13.98%) Hadoop
14 66 (12.82%) MySQL
15 59 (11.46%) QlikView
16 58 (11.26%) SQL Server 2014
17 53 (10.29%) Microsoft Analysis Services
18 49 (9.51%) RDBMS
19 44 (8.54%) SQL Server 2016
Development Applications
1 51 (9.90%) Visual Studio
2 36 (6.99%) Team Foundation Server
3 33 (6.41%) JIRA
4 15 (2.91%) Talend Open Studio
5 14 (2.72%) Visual Studio Team System
6 9 (1.75%) Git (software)
6 9 (1.75%) PowerDesigner
7 8 (1.55%) Eclipse
8 7 (1.36%) git-flow
9 5 (0.97%) SQL Server Management Studio (SSMS)
10 4 (0.78%) JUnit
11 3 (0.58%) ERwin
11 3 (0.58%) Maven
12 2 (0.39%) Oracle Forms
12 2 (0.39%) TestNG
13 1 (0.19%) MagicDraw
13 1 (0.19%) MSTest
13 1 (0.19%) SpecFlow
13 1 (0.19%) Subversion
13 1 (0.19%) TortoiseSVN
General
1 121 (23.50%) Finance
2 42 (8.16%) Advertising
3 26 (5.05%) Legal
4 24 (4.66%) Marketing
5 22 (4.27%) Banking
6 20 (3.88%) Manufacturing
7 13 (2.52%) Investment Banking
8 11 (2.14%) Retail
9 10 (1.94%) Financial Institution
10 8 (1.55%) German Language
10 8 (1.55%) Spanish Language
11 6 (1.17%) French Language
12 5 (0.97%) Games
13 4 (0.78%) Automotive
13 4 (0.78%) Dutch Language
13 4 (0.78%) Electronics
13 4 (0.78%) Italian Language
14 3 (0.58%) Billing
14 3 (0.58%) Music Industry
14 3 (0.58%) Telecoms
Job Titles
1 261 (50.68%) Developer
2 143 (27.77%) Business Intelligence Developer
3 91 (17.67%) SQL Developer
4 90 (17.48%) Analyst
5 66 (12.82%) DBA
6 65 (12.62%) Senior Developer
7 54 (10.49%) SSIS Developer
8 46 (8.93%) Business Intelligence Analyst
8 46 (8.93%) SQL BI Developer
9 45 (8.74%) SSRS Developer
10 44 (8.54%) SQL DBA
11 42 (8.16%) SSAS Developer
12 38 (7.38%) Data Warehouse Developer
13 35 (6.80%) Architect
14 30 (5.83%) ETL Developer
14 30 (5.83%) Senior Business Intelligence Developer
14 30 (5.83%) SQL Server Developer
15 28 (5.44%) Administrator
16 27 (5.24%) Business Developer
17 26 (5.05%) SQL Analyst
Libraries, Frameworks & Software Standards
1 91 (17.67%) .NET
2 88 (17.09%) MDX
3 27 (5.24%) XML
4 24 (4.66%) Web Services
5 18 (3.50%) HTML
5 18 (3.50%) Oracle GoldenGate
6 15 (2.91%) ASP.NET
7 14 (2.72%) Middleware
8 12 (2.33%) Kafka
9 11 (2.14%) Scrapy
10 8 (1.55%) GraphX
10 8 (1.55%) Serverless Framework
11 7 (1.36%) .NET Framework
12 6 (1.17%) JSON
12 6 (1.17%) SOAP
12 6 (1.17%) Spring
13 5 (0.97%) Akka
13 5 (0.97%) CSS
13 5 (0.97%) jQuery
13 5 (0.97%) REST
Miscellaneous
1 67 (13.01%) Analytical Skills
2 50 (9.71%) Management Information System
3 37 (7.18%) Replication
4 23 (4.47%) Clustering
5 20 (3.88%) Computer Science
5 20 (3.88%) Fintech
6 6 (1.17%) Data Structures
6 6 (1.17%) Mobile App
7 5 (0.97%) NHS
8 4 (0.78%) Data Protection Act
8 4 (0.78%) Social Media
9 3 (0.58%) Data Centre
9 3 (0.58%) Enterprise Software
10 2 (0.39%) iPad
10 2 (0.39%) Online Games
10 2 (0.39%) Reference Data
10 2 (0.39%) User Experience
11 1 (0.19%) Credit Risk
11 1 (0.19%) Spread Betting
11 1 (0.19%) Taxonomies
Operating Systems
1 41 (7.96%) Windows
2 31 (6.02%) Linux
3 15 (2.91%) Windows Server 2008
3 15 (2.91%) Windows Server 2012
4 12 (2.33%) Unix
5 10 (1.94%) Solaris
6 9 (1.75%) Windows Server
Processes & Methodologies
1 372 (72.23%) Business Intelligence
2 255 (49.51%) ETL
3 151 (29.32%) Agile Software Development
4 102 (19.81%) Data Modelling
5 99 (19.22%) Analytics
6 94 (18.25%) Kimball Methodology
7 85 (16.50%) Performance Tuning
8 69 (13.40%) Dimensional Modelling
9 56 (10.87%) Scrum
10 44 (8.54%) Visualisation
11 43 (8.35%) SDLC
11 43 (8.35%) Time Management
12 40 (7.77%) Data Integration
13 37 (7.18%) ITIL
14 32 (6.21%) Performance Monitoring
15 31 (6.02%) Data Visualisation
15 31 (6.02%) Disaster Recovery
15 31 (6.02%) Mentoring
16 27 (5.24%) Stakeholder Management
16 27 (5.24%) Statistics
Programming Languages
1 400 (77.67%) SQL
2 200 (38.83%) T-SQL
3 63 (12.23%) C#
4 50 (9.71%) PL/SQL
5 36 (6.99%) Data Analysis Expressions (DAX)
6 26 (5.05%) Java
7 24 (4.66%) Python
8 15 (2.91%) JavaScript
8 15 (2.91%) R
9 14 (2.72%) VB.NET
9 14 (2.72%) VBA
10 12 (2.33%) PowerShell
11 7 (1.36%) Scala
12 6 (1.17%) C
12 6 (1.17%) Shell Script
13 5 (0.97%) ABAP
13 5 (0.97%) C++
14 4 (0.78%) Embedded C
14 4 (0.78%) Embedded C++
14 4 (0.78%) PHP
Qualifications
1 63 (12.23%) Degree
2 20 (3.88%) Microsoft Certification
3 7 (1.36%) MCSE
4 5 (0.97%) CIMA
4 5 (0.97%) MCITP
4 5 (0.97%) SC Cleared
4 5 (0.97%) Security Cleared
5 2 (0.39%) MCTS
6 1 (0.19%) Postgraduate
Quality Assurance & Compliance
1 48 (9.32%) Data Quality
2 26 (5.05%) QA
3 14 (2.72%) SLA
4 5 (0.97%) PMO
5 3 (0.58%) ISO/IEC 20000
6 2 (0.39%) PCI DSS
7 1 (0.19%) Basel III
7 1 (0.19%) Dodd-Frank
7 1 (0.19%) EFQM
7 1 (0.19%) IFRS
7 1 (0.19%) IFRS 9
System Software
1 16 (3.11%) Oracle RAC
2 13 (2.52%) KVM
2 13 (2.52%) VMware Infrastructure
3 10 (1.94%) Hyper-V
3 10 (1.94%) NFS
3 10 (1.94%) SRDF
3 10 (1.94%) Xen
4 7 (1.36%) Active Directory
5 4 (0.78%) Firmware
6 3 (0.58%) HDFS
7 2 (0.39%) Apache ZooKeeper
8 1 (0.19%) Apache Flume
Systems Management
1 11 (2.14%) Kibana
2 10 (1.94%) Puppet
3 6 (1.17%) Enterprise Manager Cloud Control
3 6 (1.17%) Oracle Enterprise Manager
3 6 (1.17%) Oracle RMAN
4 2 (0.39%) Hadoop YARN
4 2 (0.39%) Oozie
4 2 (0.39%) Perfmon
Vendors
1 238 (46.21%) Microsoft
2 116 (22.52%) Oracle
3 71 (13.79%) Tableau
4 52 (10.10%) Cognos
5 22 (4.27%) IBM
6 19 (3.69%) SAP
7 16 (3.11%) MicroStrategy
8 15 (2.91%) Talend
9 14 (2.72%) EMC
10 13 (2.52%) Cisco
10 13 (2.52%) VMware
11 10 (1.94%) Hyperion
11 10 (1.94%) Intel
11 10 (1.94%) NetApp
12 9 (1.75%) Informatica
12 9 (1.75%) Sybase
13 8 (1.55%) Infor
14 7 (1.36%) Google
14 7 (1.36%) SolarWinds
15 5 (0.97%) Salesforce.com
London
Nigel Frank International
Salary: £40000 - £50000 per annum
Posted: Yesterday
London
Nigel Frank International
Salary: £40000 - £50000 per annum
Posted: Yesterday
London
Talent International
Salary: £350 - £500 per day
Posted: Yesterday
Stockport, Cheshire
Adria Solutions Ltd
Salary: £25000 - £30000 per annum + Bonus + Benefits
Posted: 17 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: 6 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: 9 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: 12 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: 21 days ago
Northamptonshire
Lawrence Harvey
Salary: £45000 - £50000 per annum
Posted: 20 days ago
Manchester
Bupa
Posted: 14 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: 21 days ago