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 5 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
5 Dec 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 621 490 477
Rank change year-on-year
-131 -13
Permanent jobs citing OLAP 242 524 570
As % of all permanent IT jobs located in England 0.28% 0.53% 0.53%
As % of the Database & Business Intelligence category 0.95% 1.64% 1.73%
Number of salaries quoted 196 436 488
Median salary £47,500 £50,000 £49,750
Median salary % change year-on-year
-5.00% +0.50%
90% offered a salary of more than £36,000 £35,000 £32,500
10% offered a salary of more than £66,000 £66,000 £70,000
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +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
25444 31894 32902
As % of all permanent IT jobs located in England 29.85% 32.07% 30.56%
Number of salaries quoted 21985 27134 28288
Median salary £50,000 £48,000 £45,000
Median salary % change year-on-year
+4.16% +6.66%
90% offered a salary of more than £32,500 £32,500 £30,000
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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 5 December 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 5 December 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 -44 100 £55,000 -1.78% 10
South East +47 54 £50,000 +5.26% 3
East of England -6 26 £45,000 - 5
Yorkshire -9 19 £45,000 - 2
West Midlands -3 18 £35,000 -12.50% 4
North West -78 17 £45,000 -5.26% 4
East Midlands -5 3 £35,000 -33.33% 1
South West -23 2 £87,500 +133.33% 2
North East +1 1 £40,000 +23.07%
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 5 December 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 414 (75.00%) SQL
2 392 (71.01%) SQL Server
3 378 (68.48%) Business Intelligence
4 332 (60.14%) Data Warehouse
5 253 (45.83%) Microsoft
6 252 (45.65%) SQL Server Analysis Services
7 229 (41.49%) SQL Server Reporting Services
8 228 (41.30%) ETL
9 226 (40.94%) SQL Server Integration Services
10 197 (35.69%) T-SQL
11 178 (32.25%) OLTP
12 165 (29.89%) Agile Software Development
13 150 (27.17%) MS Excel
14 145 (26.27%) OLAP Cube
15 139 (25.18%) Oracle
15 139 (25.18%) Oracle OLAP
16 137 (24.82%) Finance
17 113 (20.47%) Big Data
18 111 (20.11%) Analytics
19 108 (19.57%) Data Modelling
20 106 (19.20%) MDX
20 106 (19.20%) Performance Tuning
21 99 (17.93%) Kimball Methodology
22 97 (17.57%) SQL Server 2012
23 92 (16.67%) Tableau
24 90 (16.30%) Relational Database
25 89 (16.12%) Hadoop
26 80 (14.49%) Analytical Skills
27 73 (13.22%) Power BI
28 71 (12.86%) Windows

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 38 (6.88%) SAS
1 38 (6.88%) SharePoint
2 28 (5.07%) Apache
3 26 (4.71%) IIS
4 25 (4.53%) Oracle Coherence
5 24 (4.35%) Oracle HTTP Server
5 24 (4.35%) Tomcat
5 24 (4.35%) WebSphere
6 23 (4.17%) Apache Spark
7 17 (3.08%) Apache Pig
8 10 (1.81%) Oracle SOA Suite
9 4 (0.72%) Jupyter
9 4 (0.72%) SharePoint 2013
10 3 (0.54%) Elasticsearch
10 3 (0.54%) SharePoint Server
11 2 (0.36%) NetWeaver
12 1 (0.18%) Apache Solr
Applications
1 150 (27.17%) MS Excel
2 8 (1.45%) MS Office
3 4 (0.72%) Gephi
4 1 (0.18%) MS PowerPoint
4 1 (0.18%) MS Visio
4 1 (0.18%) SPSS
Business Applications
1 14 (2.54%) Cognos TM1
2 9 (1.63%) Cognos Business Intelligence
2 9 (1.63%) Cognos Controller
2 9 (1.63%) Oracle EBS
3 8 (1.45%) SAP BPC
4 5 (0.91%) Dynamics CRM
5 4 (0.72%) Dynamics NAV
5 4 (0.72%) FastStats
6 2 (0.36%) Adobe Campaign
6 2 (0.36%) Dynamics AX
6 2 (0.36%) Eloqua
6 2 (0.36%) HFM
6 2 (0.36%) Infor M3
6 2 (0.36%) Magento
6 2 (0.36%) Unica
7 1 (0.18%) JDE EnterpriseOne
7 1 (0.18%) OPENHousing
7 1 (0.18%) Oracle CRM
7 1 (0.18%) SAP CRM
7 1 (0.18%) SAP SD
Cloud Services
1 50 (9.06%) Microsoft Azure
2 24 (4.35%) Amazon AWS
3 20 (3.62%) GitHub
4 12 (2.17%) Azure Machine Learning
4 12 (2.17%) Data Lake Analytics
5 8 (1.45%) IaaS
6 7 (1.27%) PaaS
6 7 (1.27%) SaaS
7 6 (1.09%) Google Cloud Platform
8 5 (0.91%) Amazon S3
9 2 (0.36%) Responsys
10 1 (0.18%) Google Play
Communications & Networking
1 33 (5.98%) SAN
2 27 (4.89%) LAN
2 27 (4.89%) WAN
3 25 (4.53%) HTTP
4 24 (4.35%) FCoE
4 24 (4.35%) Fibre Channel
4 24 (4.35%) iSCSI
4 24 (4.35%) Multicast
4 24 (4.35%) NAS
5 12 (2.17%) Intranet
6 10 (1.81%) Firewall
7 9 (1.63%) Extranet
8 3 (0.54%) Internet
8 3 (0.54%) PBX
8 3 (0.54%) Skype
8 3 (0.54%) SSL
9 1 (0.18%) Ethernet
9 1 (0.18%) GPRS
Database & Business Intelligence
1 392 (71.01%) SQL Server
2 332 (60.14%) Data Warehouse
3 252 (45.65%) SQL Server Analysis Services
4 229 (41.49%) SQL Server Reporting Services
5 226 (40.94%) SQL Server Integration Services
6 178 (32.25%) OLTP
7 145 (26.27%) OLAP Cube
8 139 (25.18%) Oracle OLAP
9 113 (20.47%) Big Data
10 97 (17.57%) SQL Server 2012
11 90 (16.30%) Relational Database
12 89 (16.12%) Hadoop
13 73 (13.22%) Power BI
14 69 (12.50%) SQL Server 2008
15 66 (11.96%) MySQL
15 66 (11.96%) NoSQL
16 63 (11.41%) SQL Server 2014
17 54 (9.78%) Microsoft Analysis Services
18 53 (9.60%) SQL Server 2016
19 52 (9.42%) RDBMS
Development Applications
1 45 (8.15%) JIRA
2 38 (6.88%) Visual Studio
3 29 (5.25%) Team Foundation Server
4 16 (2.90%) Talend Open Studio
5 10 (1.81%) Jenkins
5 10 (1.81%) SQL Server Management Studio (SSMS)
6 9 (1.63%) Vagrant
7 8 (1.45%) Git (software)
8 7 (1.27%) Cucumber
8 7 (1.27%) Visual Studio Tools for Office
9 6 (1.09%) ERwin
10 5 (0.91%) git-flow
10 5 (0.91%) Maven
11 4 (0.72%) tSQLt
11 4 (0.72%) Visual Studio Team System
12 2 (0.36%) Oracle Forms
13 1 (0.18%) JUnit
13 1 (0.18%) Subversion
13 1 (0.18%) TeamCity
13 1 (0.18%) TestNG
General
1 137 (24.82%) Finance
2 33 (5.98%) Retail
3 29 (5.25%) Banking
4 26 (4.71%) Manufacturing
5 18 (3.26%) Advertising
6 17 (3.08%) Legal
7 13 (2.36%) Games
8 11 (1.99%) Marketing
9 9 (1.63%) Publishing
10 7 (1.27%) Investment Banking
11 6 (1.09%) Telecoms
12 4 (0.72%) Front Office
13 3 (0.54%) Billing
14 2 (0.36%) Automotive
14 2 (0.36%) Financial Institution
14 2 (0.36%) German Language
14 2 (0.36%) Music Industry
14 2 (0.36%) Spanish Language
15 1 (0.18%) Back Office
15 1 (0.18%) Law
Job Titles
1 260 (47.10%) Developer
2 172 (31.16%) Business Intelligence Developer
3 79 (14.31%) SQL Developer
4 69 (12.50%) Architect
5 68 (12.32%) DBA
6 67 (12.14%) Analyst
7 51 (9.24%) SQL DBA
8 47 (8.51%) SSIS Developer
9 44 (7.97%) ETL Developer
10 41 (7.43%) Senior Developer
11 40 (7.25%) Consultant
12 35 (6.34%) SQL BI Developer
12 35 (6.34%) SSRS Developer
13 34 (6.16%) SQL Server DBA
14 31 (5.62%) SSAS Developer
15 29 (5.25%) Business Intelligence Analyst
15 29 (5.25%) Business Intelligence Consultant
15 29 (5.25%) Data Architect
15 29 (5.25%) Lead Architect
16 28 (5.07%) Business Developer
Libraries, Frameworks & Software Standards
1 106 (19.20%) MDX
2 69 (12.50%) .NET
3 40 (7.25%) Web Services
4 39 (7.07%) XML
5 27 (4.89%) Middleware
6 22 (3.99%) JSON
7 21 (3.80%) HTML
8 16 (2.90%) Oracle GoldenGate
9 14 (2.54%) REST
10 13 (2.36%) ASP.NET
10 13 (2.36%) D3.js
11 11 (1.99%) HTML5
12 9 (1.63%) Akka
12 9 (1.63%) SOAP
13 8 (1.45%) .NET Framework
14 7 (1.27%) Leaflet
15 6 (1.09%) jQuery
16 5 (0.91%) CSS
16 5 (0.91%) Spring
17 3 (0.54%) J2EE
Miscellaneous
1 80 (14.49%) Analytical Skills
2 49 (8.88%) Data Integration
3 40 (7.25%) Replication
4 39 (7.07%) Visualisation
5 33 (5.98%) Computer Science
6 31 (5.62%) Management Information System
7 29 (5.25%) Clustering
8 22 (3.99%) Statistics
9 20 (3.62%) Enterprise Software
10 14 (2.54%) Fintech
11 13 (2.36%) Mobile App
12 12 (2.17%) Data Extraction
13 11 (1.99%) Neural Network
14 9 (1.63%) Mathematics
15 7 (1.27%) iPad
16 6 (1.09%) Data Structures
17 5 (0.91%) Data Protection Act
17 5 (0.91%) Life Science
17 5 (0.91%) Microsoft Licensing
17 5 (0.91%) Online Games
Operating Systems
1 71 (12.86%) Windows
2 52 (9.42%) Linux
3 26 (4.71%) Unix
4 24 (4.35%) Solaris
5 12 (2.17%) Windows Server
6 2 (0.36%) Windows Server 2008
6 2 (0.36%) Windows Server 2012
7 1 (0.18%) Android
7 1 (0.18%) Apple iOS
Processes & Methodologies
1 378 (68.48%) Business Intelligence
2 228 (41.30%) ETL
3 165 (29.89%) Agile Software Development
4 111 (20.11%) Analytics
5 108 (19.57%) Data Modelling
6 106 (19.20%) Performance Tuning
7 99 (17.93%) Kimball Methodology
8 69 (12.50%) Scrum
9 65 (11.78%) Dimensional Modelling
10 55 (9.96%) Data Management
11 39 (7.07%) Business Analysis
11 39 (7.07%) Project Management
12 35 (6.34%) Migration
13 33 (5.98%) CRM
14 30 (5.43%) Disaster Recovery
14 30 (5.43%) Risk Management
15 28 (5.07%) Data Analytics
15 28 (5.07%) Data Visualisation
16 27 (4.89%) Data Architecture
16 27 (4.89%) Time Management
Programming Languages
1 414 (75.00%) SQL
2 197 (35.69%) T-SQL
3 59 (10.69%) C#
4 52 (9.42%) PL/SQL
5 51 (9.24%) Java
6 47 (8.51%) Data Analysis Expressions (DAX)
7 30 (5.43%) JavaScript
8 27 (4.89%) Python
9 26 (4.71%) PowerShell
10 23 (4.17%) R
11 21 (3.80%) VBA
12 13 (2.36%) VB.NET
13 12 (2.17%) Scala
14 8 (1.45%) C
14 8 (1.45%) PHP
15 7 (1.27%) Shell Script
16 3 (0.54%) C++
16 3 (0.54%) XMLA
17 2 (0.36%) Bash Shell
17 2 (0.36%) VB
Qualifications
1 61 (11.05%) Degree
2 36 (6.52%) Microsoft Certification
3 14 (2.54%) MCITP
4 13 (2.36%) MCSE
5 11 (1.99%) SC Cleared
5 11 (1.99%) Security Cleared
6 4 (0.72%) MCP
6 4 (0.72%) MCSA
7 3 (0.54%) ISEB
8 2 (0.36%) MCTS
9 1 (0.18%) ACCA
9 1 (0.18%) CIMA
9 1 (0.18%) CISSP
9 1 (0.18%) Oracle Certification
9 1 (0.18%) Postgraduate
9 1 (0.18%) PRINCE2 Certification
Quality Assurance & Compliance
1 25 (4.53%) Data Quality
1 25 (4.53%) QA
2 9 (1.63%) SLA
3 3 (0.54%) PCI DSS
4 1 (0.18%) Basel III
4 1 (0.18%) Dodd-Frank
4 1 (0.18%) HIPAA
4 1 (0.18%) ISO/IEC 27001
4 1 (0.18%) SSAE 16
System Software
1 29 (5.25%) VMware Infrastructure
2 24 (4.35%) Hyper-V
2 24 (4.35%) KVM
2 24 (4.35%) NFS
2 24 (4.35%) Oracle RAC
2 24 (4.35%) SRDF
2 24 (4.35%) Xen
3 12 (2.17%) Virtual Machines
4 9 (1.63%) HDFS
5 5 (0.91%) VMware ESX
5 5 (0.91%) vSphere
6 3 (0.54%) Apache Flume
7 1 (0.18%) Apache ZooKeeper
7 1 (0.18%) Firmware
Systems Management
1 18 (3.26%) Puppet
2 11 (1.99%) Microsoft Clustering
3 3 (0.54%) ITRS Geneos
3 3 (0.54%) Oozie
4 1 (0.18%) Hadoop YARN
Vendors
1 253 (45.83%) Microsoft
2 139 (25.18%) Oracle
3 92 (16.67%) Tableau
4 67 (12.14%) Cognos
5 45 (8.15%) IBM
6 40 (7.25%) VMware
7 29 (5.25%) NetApp
8 27 (4.89%) Cisco
9 25 (4.53%) EMC
10 24 (4.35%) Intel
11 16 (2.90%) Talend
12 15 (2.72%) SAP
13 12 (2.17%) Splunk
14 11 (1.99%) Computacenter
14 11 (1.99%) Google
15 9 (1.63%) Actian
16 8 (1.45%) MicroStrategy
17 6 (1.09%) Hyperion
17 6 (1.09%) RedGate
18 5 (0.91%) SolarWinds
Northampton, Northamptonshire
McGregor Boyall
Salary: £45000 per annum
Posted: 11 hours ago
Luton, Bedfordshire
Understanding Recruitment
Salary: £50000.00 - £55000.00 per annum + Benefits
Posted: 19 hours ago
West London
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: £60000 Per Annum Plus excellent benefits
Posted: Yesterday
Skipton, North Yorkshire
Modis International
Salary: £35000 - £40000 per annum
Posted: 4 days ago
Skipton, North Yorkshire
Redrock Consulting Ltd
Salary: £35000 - £40000 per annum + Good
Posted: 3 days ago
Stevenage, Hertfordshire
Nigel Frank International Ltd
Salary: £25000 - £32000 per annum + Benefits
Posted: 3 days ago
Worcestershire
Spring Technology
Salary: £30000.00 - £40000.00 per annum
Posted: 5 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 3 days ago
Crawley
Nigel Frank International
Salary: £50000 - £65000 per annum + Benefits
Posted: 7 days ago
London
Joseph Harry Ltd
Salary: £55000 - £65000 per annum + 15% Bonus + Pension
Posted: 4 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 7 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 7 days ago
West Midlands
Austin Fraser
Salary: £45000.00 - £50000.00 per annum + Benefits
Posted: 6 days ago
West Midlands
Austin Fraser
Salary: £40000.00 - £45000.00 per annum + Benefits
Posted: 6 days ago
London
Lorien Resourcing
Salary: £50000 - £55000 per annum
Posted: 5 days ago
West Sussex
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + bonus, pension, health care
Posted: 11 days ago
City, London
The Bridge Ltd
Salary: From £60,000 to £80,000 per annum Pension Scheme, Life & Medical Insur
Posted: 6 days ago
City, London
Henderson Drake
Salary: From £28,000 to £40,000 per annum Bonus + Pension + Insurance + Dental
Posted: 5 days ago
West Midlands
Austin Fraser
Salary: £50000.00 - £55000.00 per annum + Benefits
Posted: 6 days ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 14 days ago
Diss
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £45000.00 per annum
Posted: 26 days ago
Manchester
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 24 days ago
London
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 14 days ago
Reading
Oracle
Salary: Competitive
Posted: 6 days ago
Manchester
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 24 days ago
Bristol, Avon
Swiis
Salary: From £35,000 to £45,000 per annum plus benefits
Posted: 27 days ago
Luton
easyJet Airline
Posted: 14 days ago