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

3 months to
28 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 564 506 416
Rank change year-on-year
-58 -90
Permanent jobs citing OLAP 350 509 742
As % of all permanent IT jobs located in England 0.38% 0.50% 0.67%
As % of the Database & Business Intelligence category 1.28% 1.56% 2.10%
Number of salaries quoted 296 410 632
Median salary £50,000 £50,000 £52,500
Median salary % change year-on-year
- -4.76%
90% offered a salary of more than £37,500 £32,500 £37,500
10% offered a salary of more than £80,000 £75,000 £70,000
UK excluding London median salary £47,500 £40,000 £45,000
% change year-on-year
+18.75% -11.11%
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
27241 32706 35335
As % of all permanent IT jobs located in England 29.68% 31.89% 32.10%
Number of salaries quoted 23521 27811 30454
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 £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 28 July 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 28 July 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 -25 149 £65,000 +8.33% 17
South East -20 73 £50,000 +27.38% 2
East of England +41 31 £48,750 +14.70% 1
West Midlands -19 28 £47,500 +18.75% 2
North West +8 20 £35,000 -11.39% 6
Yorkshire +3 20 £47,500 +5.55% 1
East Midlands +8 13 £50,000 +17.64% 3
South West +11 11 £41,000 -3.52% 7
North East - 5 £40,000 -
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 28 July 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 532 (74.30%) Business Intelligence
2 507 (70.81%) SQL
3 485 (67.74%) SQL Server
4 409 (57.12%) Data Warehouse
5 350 (48.88%) SQL Server Reporting Services
6 324 (45.25%) SQL Server Integration Services
7 321 (44.83%) ETL
8 316 (44.13%) SQL Server Analysis Services
9 285 (39.80%) Microsoft
10 234 (32.68%) OLAP Cube
11 210 (29.33%) T-SQL
12 205 (28.63%) Finance
13 191 (26.68%) Agile Software Development
14 178 (24.86%) Oracle OLAP
14 178 (24.86%) Oracle
14 178 (24.86%) MS Excel
15 170 (23.74%) OLTP
16 157 (21.93%) SQL Server 2012
17 151 (21.09%) Analytical Skills
18 131 (18.30%) Analytics
19 121 (16.90%) Tableau
19 121 (16.90%) Data Modelling
20 111 (15.50%) MDX
20 111 (15.50%) Kimball Methodology
21 109 (15.22%) Performance Tuning
22 103 (14.39%) SQL Server 2008
23 102 (14.25%) Relational Database
24 83 (11.59%) Big Data
25 81 (11.31%) Degree
26 74 (10.34%) PL/SQL

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 48 (6.70%) SharePoint
2 44 (6.15%) SAS
3 16 (2.23%) Apache
3 16 (2.23%) Tomcat
4 15 (2.09%) IIS
5 14 (1.96%) Apache Spark
6 13 (1.82%) Oracle Coherence
6 13 (1.82%) WebSphere
7 12 (1.68%) Oracle HTTP Server
8 6 (0.84%) Elasticsearch
9 4 (0.56%) Apache Pig
9 4 (0.56%) Confluence
9 4 (0.56%) Oracle Spatial
9 4 (0.56%) Oracle Workflow
10 2 (0.28%) NetWeaver
10 2 (0.28%) SharePoint 2013
11 1 (0.14%) Blackberry Enterprise Server
11 1 (0.14%) MS Exchange
Applications
1 178 (24.86%) MS Excel
2 17 (2.37%) MS Office
3 12 (1.68%) MS Visio
4 3 (0.42%) Gephi
4 3 (0.42%) MS PowerPoint
4 3 (0.42%) SPSS
5 2 (0.28%) Spreadsheet
6 1 (0.14%) Acrobat
6 1 (0.14%) MS Project
Business Applications
1 14 (1.96%) Cognos Business Intelligence
2 13 (1.82%) Cognos TM1
3 12 (1.68%) SAP Business One
4 9 (1.26%) Oracle EBS
5 7 (0.98%) Cognos Controller
6 6 (0.84%) SAP BPC
7 4 (0.56%) Oracle Financials
7 4 (0.56%) Unica
8 3 (0.42%) SAP Oil and Gas
9 2 (0.28%) Cognos Planning
9 2 (0.28%) Dynamics NAV
9 2 (0.28%) HFM
9 2 (0.28%) Hyperion Planning
9 2 (0.28%) JDE OneWorld
10 1 (0.14%) Dynamics AX
10 1 (0.14%) Infor M3
10 1 (0.14%) JDE EnterpriseOne
10 1 (0.14%) Oracle Applications
10 1 (0.14%) Oracle Financial Analyzer
Cloud Services
1 43 (6.01%) Microsoft Azure
2 20 (2.79%) Amazon AWS
3 7 (0.98%) Azure Machine Learning
3 7 (0.98%) Data Lake Analytics
3 7 (0.98%) IaaS
3 7 (0.98%) PaaS
4 6 (0.84%) SaaS
5 2 (0.28%) GitHub
Communications & Networking
1 21 (2.93%) SAN
2 18 (2.51%) Intranet
3 16 (2.23%) Extranet
3 16 (2.23%) LAN
3 16 (2.23%) WAN
4 15 (2.09%) HTTP
5 12 (1.68%) FCoE
5 12 (1.68%) Fibre Channel
5 12 (1.68%) iSCSI
5 12 (1.68%) Multicast
5 12 (1.68%) NAS
6 9 (1.26%) Firewall
7 3 (0.42%) PBX
8 2 (0.28%) DHCP
8 2 (0.28%) DNS
8 2 (0.28%) Skype
8 2 (0.28%) TCP/IP
9 1 (0.14%) Network Security
9 1 (0.14%) Remote Desktop
9 1 (0.14%) VLAN
Database & Business Intelligence
1 485 (67.74%) SQL Server
2 409 (57.12%) Data Warehouse
3 350 (48.88%) SQL Server Reporting Services
4 324 (45.25%) SQL Server Integration Services
5 316 (44.13%) SQL Server Analysis Services
6 234 (32.68%) OLAP Cube
7 178 (24.86%) Oracle OLAP
8 170 (23.74%) OLTP
9 157 (21.93%) SQL Server 2012
10 103 (14.39%) SQL Server 2008
11 102 (14.25%) Relational Database
12 83 (11.59%) Big Data
13 74 (10.34%) Hadoop
14 73 (10.20%) SQL Server 2014
15 61 (8.52%) Microsoft Analysis Services
16 56 (7.82%) QlikView
17 55 (7.68%) BusinessObjects
18 54 (7.54%) Power BI
18 54 (7.54%) PowerPivot
19 49 (6.84%) SQL Server 2005
Development Applications
1 20 (2.79%) Team Foundation Server
2 16 (2.23%) Visual Studio
3 14 (1.96%) Git (software)
4 12 (1.68%) JIRA
5 9 (1.26%) SQL Server Management Studio (SSMS)
6 7 (0.98%) Visual Studio Tools for Office
7 6 (0.84%) Jenkins
7 6 (0.84%) tSQLt
8 5 (0.70%) Eclipse
8 5 (0.70%) ERwin
8 5 (0.70%) Subversion
9 3 (0.42%) Maven
10 1 (0.14%) Gradle
10 1 (0.14%) JUnit
10 1 (0.14%) Talend Open Studio
10 1 (0.14%) TeamCity
General
1 205 (28.63%) Finance
2 51 (7.12%) Banking
3 39 (5.45%) Retail
4 37 (5.17%) Marketing
5 33 (4.61%) Games
6 26 (3.63%) Manufacturing
7 25 (3.49%) Telecoms
8 21 (2.93%) Investment Banking
9 20 (2.79%) Legal
10 18 (2.51%) Front Office
11 11 (1.54%) Publishing
12 7 (0.98%) Advertising
12 7 (0.98%) Back Office
13 4 (0.56%) Electronics
14 2 (0.28%) Financial Institution
14 2 (0.28%) Law
15 1 (0.14%) Automotive
15 1 (0.14%) Billing
15 1 (0.14%) Pharmaceutical
Job Titles
1 374 (52.23%) Developer
2 238 (33.24%) Business Intelligence Developer
3 159 (22.21%) SQL Developer
4 92 (12.85%) Architect
5 83 (11.59%) SQL BI Developer
6 78 (10.89%) SSAS Developer
7 75 (10.47%) Analyst
8 72 (10.06%) SQL Server Developer
9 67 (9.36%) SSIS Developer
10 55 (7.68%) DBA
11 54 (7.54%) Consultant
12 53 (7.40%) SSRS Developer
13 52 (7.26%) Senior Developer
14 51 (7.12%) Data Architect
15 42 (5.87%) SQL Server BI Developer
16 41 (5.73%) Oracle Developer
17 40 (5.59%) SQL DBA
18 37 (5.17%) Business Intelligence Consultant
19 35 (4.89%) Business Intelligence Lead
20 31 (4.33%) Business Developer
Libraries, Frameworks & Software Standards
1 111 (15.50%) MDX
2 60 (8.38%) .NET
3 35 (4.89%) XML
4 29 (4.05%) HTML
5 19 (2.65%) Web Services
6 13 (1.82%) jQuery
6 13 (1.82%) Middleware
7 12 (1.68%) D3.js
7 12 (1.68%) Oracle GoldenGate
7 12 (1.68%) REST
8 11 (1.54%) JSON
9 9 (1.26%) ASP.NET
9 9 (1.26%) CSS
9 9 (1.26%) HTML5
10 7 (0.98%) Leaflet
11 6 (0.84%) Django
11 6 (0.84%) SOAP
11 6 (0.84%) WCF
12 4 (0.56%) RESTful
12 4 (0.56%) WF
Miscellaneous
1 151 (21.09%) Analytical Skills
2 65 (9.08%) Visualisation
3 53 (7.40%) Data Integration
4 47 (6.56%) Enterprise Software
5 44 (6.15%) Computer Science
6 39 (5.45%) Replication
7 36 (5.03%) Management Information System
8 32 (4.47%) Statistics
9 26 (3.63%) Clustering
9 26 (3.63%) Data Extraction
10 16 (2.23%) Credit Risk
10 16 (2.23%) Fintech
11 15 (2.09%) Mathematics
12 14 (1.96%) Online Games
13 10 (1.40%) Economics
13 10 (1.40%) Neural Network
14 9 (1.26%) Data Conversion
15 8 (1.12%) Data Protection Act
16 7 (0.98%) Data Structures
16 7 (0.98%) Mobile App
Operating Systems
1 51 (7.12%) Linux
2 50 (6.98%) Windows
3 32 (4.47%) Unix
4 12 (1.68%) Solaris
5 10 (1.40%) Windows Server
6 8 (1.12%) Oracle Linux
7 5 (0.70%) Windows Server 2008
7 5 (0.70%) Windows Server 2012
8 1 (0.14%) CentOS
8 1 (0.14%) Windows 7
8 1 (0.14%) Windows Vista
Processes & Methodologies
1 532 (74.30%) Business Intelligence
2 321 (44.83%) ETL
3 191 (26.68%) Agile Software Development
4 131 (18.30%) Analytics
5 121 (16.90%) Data Modelling
6 111 (15.50%) Kimball Methodology
7 109 (15.22%) Performance Tuning
8 73 (10.20%) Dimensional Modelling
9 65 (9.08%) Scrum
10 62 (8.66%) Business Analysis
11 58 (8.10%) Data Management
12 53 (7.40%) Data Analysis
13 50 (6.98%) SDLC
14 47 (6.56%) Project Management
15 45 (6.28%) Data Analytics
16 43 (6.01%) Data Architecture
17 35 (4.89%) ITIL
18 34 (4.75%) Migration
19 30 (4.19%) Translating Business Requirements
20 29 (4.05%) SOA
Programming Languages
1 507 (70.81%) SQL
2 210 (29.33%) T-SQL
3 74 (10.34%) PL/SQL
4 58 (8.10%) C#
5 48 (6.70%) Java
6 43 (6.01%) JavaScript
7 34 (4.75%) Python
8 29 (4.05%) VBA
9 28 (3.91%) Data Analysis Expressions (DAX)
10 17 (2.37%) C
10 17 (2.37%) R
11 15 (2.09%) PowerShell
12 13 (1.82%) VB.NET
13 12 (1.68%) PHP
14 9 (1.26%) C++
15 8 (1.12%) Shell Script
16 6 (0.84%) Perl
17 5 (0.70%) Scala
17 5 (0.70%) VB
18 3 (0.42%) Bash Shell
Qualifications
1 81 (11.31%) Degree
2 28 (3.91%) Microsoft Certification
3 10 (1.40%) MCSE
4 6 (0.84%) MCITP
4 6 (0.84%) MCP
4 6 (0.84%) MCSA
5 5 (0.70%) ACCA
5 5 (0.70%) CIMA
5 5 (0.70%) SC Cleared
5 5 (0.70%) Security Cleared
6 3 (0.42%) IBM Certification
6 3 (0.42%) ISEB
6 3 (0.42%) MCAD
6 3 (0.42%) Oracle Certification
7 2 (0.28%) AAT
8 1 (0.14%) CISSP
8 1 (0.14%) HND
8 1 (0.14%) ITIL Certification
8 1 (0.14%) MBA
Quality Assurance & Compliance
1 46 (6.42%) Data Quality
2 34 (4.75%) QA
3 7 (0.98%) PCI DSS
4 4 (0.56%) Basel II
5 3 (0.42%) SLA
System Software
1 20 (2.79%) Oracle RAC
2 17 (2.37%) VMware Infrastructure
3 13 (1.82%) KVM
4 12 (1.68%) Hyper-V
4 12 (1.68%) NFS
4 12 (1.68%) SRDF
4 12 (1.68%) Xen
5 11 (1.54%) Virtual Machines
6 4 (0.56%) VMware ESX
6 4 (0.56%) vSphere
7 1 (0.14%) Active Directory
7 1 (0.14%) Firmware
7 1 (0.14%) Microsoft Virtual Server
7 1 (0.14%) Virtual Servers
7 1 (0.14%) VirtualBox
Systems Management
1 8 (1.12%) Data Guard
1 8 (1.12%) Oracle Enterprise Manager
2 7 (0.98%) Microsoft Clustering
3 4 (0.56%) Mesos
4 2 (0.28%) Cisco IPCC
5 1 (0.14%) ITRS Geneos
5 1 (0.14%) Oozie
5 1 (0.14%) Puppet
Vendors
1 285 (39.80%) Microsoft
2 178 (24.86%) Oracle
3 121 (16.90%) Tableau
4 66 (9.22%) Cognos
5 49 (6.84%) SAP
6 40 (5.59%) IBM
7 24 (3.35%) Teradata
7 24 (3.35%) VMware
8 23 (3.21%) Netezza
9 16 (2.23%) NetApp
10 13 (1.82%) EMC
11 12 (1.68%) Cisco
11 12 (1.68%) Intel
12 11 (1.54%) MicroStrategy
13 9 (1.26%) Sybase
14 8 (1.12%) Vertica
15 7 (0.98%) Informatica
16 6 (0.84%) Actuate
16 6 (0.84%) Alteryx
17 5 (0.70%) Facebook
London
Lorien Resourcing
Salary: £65000 per annum
Posted: Yesterday
Slough, Berkshire
Oscar
Salary: £45000 - £55000 per annum + Benefits
Posted: Yesterday
South East London
Vantage Recruitment Solutions Ltd
Salary: From £55,000 to £65,000 per annum Bonus, Pension, Training, Healthcare
Posted: 3 days ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 3 days ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 3 days ago
London
Lorien Resourcing
Posted: 5 days ago
London
Big Wednesday Digital Ltd
Posted: 2 days ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 5 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 2 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 2 days ago
Hemel Hempstead
Epson Europe BV
Salary: Competitive Salary plus benefits
Posted: 22 hours ago
Manchester
Computer Futures
Salary: competitive
Posted: 12 days ago
City of London
Hays London City Cheapside
Salary: £50000.00 - £65000.00 per annum
Posted: 15 days ago
City of London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + bonus, pension, flexible working
Posted: 14 days ago
London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 10 days ago
Manchester
Arrow Global
Salary: Competitive
Posted: 16 days ago
Malmesbury, Wiltshire
Dyson
Posted: 19 days ago
City, London
DCV Technologies
Salary: From £65,000 to £70,000 per annum Plus Benefits
Posted: 6 days ago
Preston, Lancashire
BAE Systems
Posted: 13 days ago
London - Mornington Crescent
ASOS
Posted: 22 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 12 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 20 days ago
Leicester
Recruitment Genius Ltd
Salary: £25000 - £35000 per annum
Posted: 24 days ago
Scunthorpe
Hays Specialist Recruitment
Salary: £35000.00 - £40000.00 per annum
Posted: 16 days ago
City of London
Modis International Ltd
Salary: £70000 per annum
Posted: 24 days ago