The table below looks at the statistics for OLAP skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 31 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
31 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 573 465 437
Rank change year-on-year
-108 -28
Permanent jobs citing OLAP 357 555 684
As % of all permanent IT jobs located in England 0.39% 0.56% 0.61%
As % of the Database & Business Intelligence category 1.28% 1.71% 1.88%
Number of salaries quoted 289 452 573
Median salary £50,000 £51,500 £50,000
Median salary % change year-on-year
-2.91% +3.00%
90% offered a salary of more than £40,000 £32,500 £35,000
10% offered a salary of more than £70,000 £72,500 £65,000
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%
OLAP
UK

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
27854 32370 36343
As % of all permanent IT jobs located in England 30.29% 32.55% 32.54%
Number of salaries quoted 24085 27599 31460
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLAP
Jobs Demand Trend in England

The demand trend of job ads across the England region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in England

OLAP
Salary Trend in England

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

OLAP Salary Trend in England

OLAP
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing OLAP across the England region over the 3 months to 31 May 2016.

OLAP Salary Histogram 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 31 May 2016. 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
(Click see detailed
statistics and trends)
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 -85 171 £60,000 -4.00% 20
West Midlands +18 48 £45,000 +12.50% 3
South East -53 36 £50,000 +31.57% 11
East of England +33 30 £51,500 +17.71% 7
Yorkshire +4 25 £42,500 +10.38% 4
East Midlands +12 17 £50,000 +25.00% 2
South West -3 16 £42,500 -5.55%
North West -8 7 £37,500 -6.25% 3
North East - 7 £40,000 -
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 31 May 2016, 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 554 (76.41%) Business Intelligence
2 504 (69.52%) SQL
3 489 (67.45%) SQL Server
4 435 (60.00%) Data Warehouse
5 381 (52.55%) SQL Server Integration Services
5 381 (52.55%) SQL Server Analysis Services
6 375 (51.72%) SQL Server Reporting Services
7 374 (51.59%) ETL
8 299 (41.24%) Microsoft
9 257 (35.45%) OLAP Cube
10 218 (30.07%) Finance
11 195 (26.90%) Agile Software Development
12 184 (25.38%) MS Excel
13 182 (25.10%) SQL Server 2012
14 181 (24.97%) T-SQL
15 177 (24.41%) Oracle
15 177 (24.41%) Oracle OLAP
16 149 (20.55%) Data Modelling
17 143 (19.72%) MDX
17 143 (19.72%) Analytical Skills
18 137 (18.90%) OLTP
19 136 (18.76%) Kimball Methodology
20 130 (17.93%) Relational Database
21 125 (17.24%) SQL Server 2008
22 122 (16.83%) Analytics
23 110 (15.17%) Tableau
24 96 (13.24%) Performance Tuning
25 93 (12.83%) PL/SQL
26 88 (12.14%) SQL Server 2014
27 83 (11.45%) Dimensional Modelling

OLAP
Top Related 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 42 (5.79%) SAS
2 39 (5.38%) SharePoint
3 11 (1.52%) Tomcat
4 10 (1.38%) Apache
5 9 (1.24%) IIS
6 7 (0.97%) WebSphere
7 6 (0.83%) Apache Spark
7 6 (0.83%) BizTalk Server
7 6 (0.83%) Confluence
7 6 (0.83%) Oracle Coherence
7 6 (0.83%) Oracle HTTP Server
8 5 (0.69%) Apache Pig
8 5 (0.69%) Oracle Spatial
8 5 (0.69%) Oracle Workflow
9 4 (0.55%) Elasticsearch
9 4 (0.55%) Node.js
10 1 (0.14%) Adobe Experience Manager
10 1 (0.14%) Drupal
10 1 (0.14%) Joomla!
10 1 (0.14%) OpenCms
Applications
1 184 (25.38%) MS Excel
2 26 (3.59%) MS Office
3 21 (2.90%) MS Visio
4 4 (0.55%) SPSS
5 3 (0.41%) MS PowerPoint
6 2 (0.28%) Spreadsheet
7 1 (0.14%) Acrobat
7 1 (0.14%) MS Project
Business Applications
1 12 (1.66%) SAP Business One
2 11 (1.52%) Cognos Business Intelligence
2 11 (1.52%) Cognos TM1
3 10 (1.38%) HFM
4 6 (0.83%) Cognos Controller
5 5 (0.69%) Oracle Financials
5 5 (0.69%) Unica
6 4 (0.55%) SAP BPC
7 3 (0.41%) Dynamics NAV
7 3 (0.41%) SAP Oil and Gas
8 2 (0.28%) Cognos Planning
8 2 (0.28%) Dynamics AX
8 2 (0.28%) Hyperion Planning
8 2 (0.28%) JDE OneWorld
8 2 (0.28%) Oracle EBS
9 1 (0.14%) Oracle Applications
9 1 (0.14%) Oracle Financial Analyzer
Cloud Services
1 40 (5.52%) Microsoft Azure
2 15 (2.07%) Amazon AWS
3 5 (0.69%) SaaS
4 1 (0.14%) GitHub
Communications & Networking
1 13 (1.79%) Intranet
2 11 (1.52%) Extranet
3 9 (1.24%) SAN
4 8 (1.10%) LAN
4 8 (1.10%) WAN
5 7 (0.97%) HTTP
6 6 (0.83%) FCoE
6 6 (0.83%) Fibre Channel
6 6 (0.83%) iSCSI
6 6 (0.83%) Multicast
6 6 (0.83%) NAS
7 2 (0.28%) DHCP
7 2 (0.28%) DNS
7 2 (0.28%) TCP/IP
8 1 (0.14%) Asterisk PBX
8 1 (0.14%) Firewall
8 1 (0.14%) Internet
8 1 (0.14%) Network Security
8 1 (0.14%) VLAN
8 1 (0.14%) VoIP
Database & Business Intelligence
1 489 (67.45%) SQL Server
2 435 (60.00%) Data Warehouse
3 381 (52.55%) SQL Server Analysis Services
3 381 (52.55%) SQL Server Integration Services
4 375 (51.72%) SQL Server Reporting Services
5 257 (35.45%) OLAP Cube
6 182 (25.10%) SQL Server 2012
7 177 (24.41%) Oracle OLAP
8 137 (18.90%) OLTP
9 130 (17.93%) Relational Database
10 125 (17.24%) SQL Server 2008
11 88 (12.14%) SQL Server 2014
12 76 (10.48%) Hadoop
13 68 (9.38%) BusinessObjects
14 60 (8.28%) Big Data
14 60 (8.28%) SQL Server 2005
15 58 (8.00%) Microsoft Analysis Services
16 57 (7.86%) PowerPivot
17 55 (7.59%) RDBMS
18 54 (7.45%) QlikView
Development Applications
1 18 (2.48%) Git (software)
1 18 (2.48%) Team Foundation Server
2 9 (1.24%) Jenkins
2 9 (1.24%) JIRA
3 7 (0.97%) Eclipse
3 7 (0.97%) Visual Studio
4 6 (0.83%) ERwin
5 5 (0.69%) Oracle Forms
5 5 (0.69%) SQL Server Management Studio (SSMS)
6 4 (0.55%) Subversion
7 2 (0.28%) Maven
7 2 (0.28%) tSQLt
8 1 (0.14%) JUnit
8 1 (0.14%) Talend Open Studio
General
1 218 (30.07%) Finance
2 64 (8.83%) Banking
3 56 (7.72%) Marketing
4 43 (5.93%) Games
5 36 (4.97%) Investment Banking
6 30 (4.14%) Retail
7 24 (3.31%) Telecoms
8 22 (3.03%) Legal
9 16 (2.21%) Front Office
10 10 (1.38%) Manufacturing
11 8 (1.10%) Advertising
12 7 (0.97%) Publishing
13 6 (0.83%) Back Office
14 5 (0.69%) Financial Institution
15 4 (0.55%) Law
16 3 (0.41%) Electronics
17 1 (0.14%) Automotive
17 1 (0.14%) Billing
17 1 (0.14%) Military
17 1 (0.14%) Pharmaceutical
Job Titles
1 409 (56.41%) Developer
2 264 (36.41%) Business Intelligence Developer
3 177 (24.41%) SQL Developer
4 116 (16.00%) SSAS Developer
5 105 (14.48%) SQL BI Developer
6 87 (12.00%) SSIS Developer
7 83 (11.45%) SQL Server Developer
8 80 (11.03%) Analyst
9 78 (10.76%) SSRS Developer
10 73 (10.07%) Senior Developer
11 70 (9.66%) Consultant
12 67 (9.24%) Architect
13 56 (7.72%) SQL Server BI Developer
14 53 (7.31%) DBA
15 48 (6.62%) Business Intelligence Consultant
16 47 (6.48%) Oracle Developer
17 44 (6.07%) Business Developer
18 39 (5.38%) Data Warehouse Developer
19 38 (5.24%) Senior Business Intelligence Developer
20 37 (5.10%) Microsoft BI Developer
Libraries, Frameworks & Software Standards
1 143 (19.72%) MDX
2 67 (9.24%) .NET
3 51 (7.03%) XML
4 27 (3.72%) HTML
5 23 (3.17%) Web Services
6 20 (2.76%) Oracle GoldenGate
7 13 (1.79%) SOAP
8 10 (1.38%) jQuery
8 10 (1.38%) REST
9 9 (1.24%) CSS
10 7 (0.97%) JSON
10 7 (0.97%) Middleware
10 7 (0.97%) WCF
11 6 (0.83%) XSL
12 5 (0.69%) WF
12 5 (0.69%) Windows Identity Foundation
13 4 (0.55%) AngularJS
13 4 (0.55%) J2SE
13 4 (0.55%) RESTful
14 3 (0.41%) ODBC
Miscellaneous
1 143 (19.72%) Analytical Skills
2 61 (8.41%) Data Integration
3 60 (8.28%) Visualisation
4 42 (5.79%) Replication
5 37 (5.10%) Management Information System
6 34 (4.69%) Computer Science
7 29 (4.00%) Enterprise Software
7 29 (4.00%) Statistics
8 28 (3.86%) Online Games
9 27 (3.72%) Credit Risk
10 26 (3.59%) Data Extraction
11 14 (1.93%) Clustering
11 14 (1.93%) Economics
11 14 (1.93%) Mathematics
12 10 (1.38%) Data Structures
12 10 (1.38%) Fintech
13 9 (1.24%) Data Protection Act
14 7 (0.97%) Data Conversion
14 7 (0.97%) Reinsurance
15 6 (0.83%) Freedom of Information
Operating Systems
1 42 (5.79%) Linux
2 39 (5.38%) Unix
3 27 (3.72%) Windows
4 14 (1.93%) Oracle Linux
5 6 (0.83%) Solaris
6 5 (0.69%) Windows Server 2012
7 4 (0.55%) Windows Server
7 4 (0.55%) Windows Server 2008
8 2 (0.28%) Windows 7
9 1 (0.14%) AIX
9 1 (0.14%) CentOS
9 1 (0.14%) Windows Vista
Processes & Methodologies
1 554 (76.41%) Business Intelligence
2 374 (51.59%) ETL
3 195 (26.90%) Agile Software Development
4 149 (20.55%) Data Modelling
5 136 (18.76%) Kimball Methodology
6 122 (16.83%) Analytics
7 96 (13.24%) Performance Tuning
8 83 (11.45%) Dimensional Modelling
9 66 (9.10%) Business Analysis
10 56 (7.72%) Data Management
11 51 (7.03%) SDLC
12 50 (6.90%) Scrum
13 48 (6.62%) Data Analysis
14 35 (4.83%) E-Commerce
15 32 (4.41%) Data Architecture
16 31 (4.28%) Presales
16 31 (4.28%) Translating Business Requirements
17 30 (4.14%) ITIL
17 30 (4.14%) Migration
18 29 (4.00%) Data Analytics
Programming Languages
1 504 (69.52%) SQL
2 181 (24.97%) T-SQL
3 93 (12.83%) PL/SQL
4 66 (9.10%) C#
5 37 (5.10%) Java
6 34 (4.69%) JavaScript
7 32 (4.41%) VBA
8 26 (3.59%) C
9 24 (3.31%) Python
10 23 (3.17%) Data Analysis Expressions (DAX)
11 16 (2.21%) Shell Script
12 13 (1.79%) VB
13 11 (1.52%) VB.NET
14 10 (1.38%) PHP
15 9 (1.24%) C++
16 7 (0.97%) PowerShell
16 7 (0.97%) R
17 6 (0.83%) Perl
18 5 (0.69%) Ruby
19 3 (0.41%) Scala
Qualifications
1 69 (9.52%) Degree
2 18 (2.48%) Microsoft Certification
3 12 (1.66%) ACCA
3 12 (1.66%) CIMA
4 4 (0.55%) MCAD
4 4 (0.55%) MCITP
4 4 (0.55%) Security Cleared
5 3 (0.41%) IBM Certification
5 3 (0.41%) Oracle Certification
5 3 (0.41%) SC Cleared
6 2 (0.28%) AAT
6 2 (0.28%) ISEB
6 2 (0.28%) MCP
6 2 (0.28%) MCSA
6 2 (0.28%) MCSE
7 1 (0.14%) CIPFA
7 1 (0.14%) HND
7 1 (0.14%) ITIL Certification
7 1 (0.14%) MBA
7 1 (0.14%) MCDBA
Quality Assurance & Compliance
1 51 (7.03%) Data Quality
2 27 (3.72%) QA
3 8 (1.10%) PCI DSS
4 6 (0.83%) Sarbanes-Oxley
5 4 (0.55%) Basel II
5 4 (0.55%) SLA
6 1 (0.14%) COBIT
System Software
1 20 (2.76%) Oracle RAC
2 7 (0.97%) KVM
2 7 (0.97%) VMware Infrastructure
3 6 (0.83%) Hyper-V
3 6 (0.83%) NFS
3 6 (0.83%) SRDF
3 6 (0.83%) Xen
4 1 (0.14%) Active Directory
4 1 (0.14%) Docker
4 1 (0.14%) Microsoft Virtual Server
4 1 (0.14%) Varnish
4 1 (0.14%) VirtualBox
Systems Management
1 16 (2.21%) Data Guard
2 15 (2.07%) Oracle Enterprise Manager
3 6 (0.83%) OpenView
4 5 (0.69%) Mesos
5 3 (0.41%) Puppet
6 2 (0.28%) Cisco IPCC
7 1 (0.14%) Oozie
7 1 (0.14%) Oracle RMAN
Vendors
1 299 (41.24%) Microsoft
2 177 (24.41%) Oracle
3 110 (15.17%) Tableau
4 55 (7.59%) SAP
5 52 (7.17%) Cognos
6 29 (4.00%) IBM
7 24 (3.31%) Teradata
8 22 (3.03%) Netezza
9 19 (2.62%) Splunk
10 15 (2.07%) MicroStrategy
11 14 (1.93%) Hyperion
12 12 (1.66%) Hitachi
13 10 (1.38%) Sybase
14 9 (1.24%) Vertica
14 9 (1.24%) VMware
15 8 (1.10%) Informatica
16 7 (0.97%) Alteryx
17 6 (0.83%) Actuate
17 6 (0.83%) Cisco
17 6 (0.83%) NetApp
Woking, Surrey
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: 10 hours ago
London
ninesharp
Salary: £55000 - £65000 per annum + Bonus, Pension, Healthcare
Posted: 17 hours ago
Bedfordshire
Zorba Consulting Limited
Salary: £40k - 48k per year
Posted: 19 hours ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 17 hours ago
Leeds, West Yorkshire
CoreCom Consulting
Salary: £35000 - £45000 per annum + Benefits
Posted: 4 days ago
Teddington, Middlesex
Profile 29 Limited
Salary: Up to £55,000 per annum + benefits (see advert)
Posted: 17 hours ago
Waltham Cross, Hertfordshire
Understanding Recruitment
Salary: £60000.00 - £70000.00 per annum + benefits
Posted: Yesterday
London
ninesharp
Salary: £55000 - £65000 per annum + Bonus, Pension, Healthcare
Posted: 17 hours ago
City, London
ANSON MCCADE
Salary: £45,000 - £65,000 and Competitive Package
Posted: 15 hours ago
London
Joseph Harry Ltd
Salary: £45000 - £60000 per annum + 10% Pension + c.25% Bonus
Posted: 4 days ago
Hampshire
Austin Fraser
Salary: £41 - £45000 per annum + Benefits
Posted: 6 days ago
London
Lorien Resourcing
Salary: £48000 - £53000 per annum + Excellent benefits + Bonus
Posted: 4 days ago
Bedfordshire
Lawrence Harvey Enterprise
Salary: £45000.00 - £50000.00 per annum
Posted: 4 days ago
Hampshire
Austin Fraser
Salary: £45000 - £50000 per annum + Benefits
Posted: 6 days ago
London
Computer Futures
Salary: competitive
Posted: 7 days ago
Leicestershire
Vivid Resourcing
Posted: 8 days ago
Southampton, Hampshire
Go IT Recruitment Ltd
Salary: From £35,000 to £50,000 per annum + 25 days Holiday + Great career pro
Posted: 3 days ago
Cambridge, Cambridgeshire
Circle Recruitment
Salary: £23000 - £30000 per annum + Benefits
Posted: 4 days ago
Northampton
Venturi
Salary: £45000 - £55000 per annum + Benefits
Posted: 11 days ago
City Of London
HFG
Salary: £50000 - £55000 per annum, Benefits: Bonus + Corp Bens.
Posted: 16 days ago
London
Vivid Resourcing
Posted: 15 days ago
London
Vivid Resourcing
Salary: £60 - £65 per annum + benefits
Posted: 11 days ago
London
onezeero.
Salary: £55000 - £65000 per annum + 20% uncapped bonus + 12% pension
Posted: 6 days ago
Reading
Venturi
Salary: £45000 - £55000.00 per annum + 30% bonus + full bens
Posted: 13 days ago
Watford
Vivid Resourcing
Posted: 14 days ago
Reading, Berkshire
Oracle Corporation UK Ltd
Salary: Competitive
Posted: 6 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 8 days ago
Southampton
Deerfoot IT Resources Ltd
Salary: £50000 per annum
Posted: 22 days ago
York
Computer Futures
Salary: competitive
Posted: 26 days ago
West Midlands
Huxley
Salary: £40000 - £50000 per annum + Benefits
Posted: 27 days ago