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

3 months to
24 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 549 494 424
Rank change year-on-year
-55 -70
Permanent jobs citing OLAP 418 561 755
As % of all permanent IT jobs located in the UK 0.43% 0.51% 0.65%
As % of the Database & Business Intelligence category 1.43% 1.59% 2.04%
Number of salaries quoted 343 439 647
Median salary £50,000 £50,000 £51,500
Median salary % change year-on-year
- -2.91%
90% offered a salary of more than £35,250 £32,500 £35,000
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%

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

Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
29137 35191 36981
As % of all permanent IT jobs located in the UK 29.72% 31.91% 32.08%
Number of salaries quoted 24750 29639 31591
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 £31,500 £30,000
10% offered a salary of more than £72,500 £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

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

OLAP Jobs Demand Trend in the UK

OLAP
Salary Trend

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

OLAP Salary Trend in the UK

OLAP
Salary Histogram

This chart provides a salary histogram for IT jobs citing OLAP over the 3 months to 24 July 2016 within the UK.

OLAP Salary Histogram 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 24 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
England -47 371 £50,000 - 44
London -26 159 £65,000 +13.04% 16
South East -19 70 £50,000 +27.38% 3
Hampshire +2 37 £44,000 +17.33% 2
West Midlands -7 33 £47,500 +18.75% 2
East of England +41 31 £47,500 +11.76%
City of London +44 29 £63,750 +10.86% 6
Southampton +25 29 £45,000 - 1
Yorkshire +13 22 £55,000 +25.71% 1
North West +20 21 £35,000 -11.39% 10
Scotland +6 21 £55,000 +29.41% 2
South Wales +21 17 £36,250 +1.39%
Wales +10 17 £36,250 +1.39%
East Midlands +10 17 £50,000 +17.64% 4
West Yorkshire +8 17 £79,000 +75.55%
Worcester - 17 £47,500 - 1
Worcestershire - 17 £47,500 - 1
Surrey +36 16 £55,000 +22.22%
Cardiff +22 15 £35,000 -2.09%
Edinburgh +20 15 £55,000 +4.76% 1
Hertfordshire +29 13 £53,000 +12.16%
South West +17 12 £41,000 -3.52% 7
Berkshire -2 12 £50,000 -7.40% 1
Bradford +13 11 £80,000 +39.13%
Liverpool 0 10 £35,000 +2.94%
Merseyside 0 10 £35,000 -4.10% 1
Cambridgeshire +1 9 £47,500 +46.15%
Staffordshire -5 8 £40,000 +3.89%
Burton-upon-Trent - 8 £40,000 -
Bath - 7 £41,000 -

OLAP
Top 30 Related IT Skills

For the 6 months to 24 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 with a requirement for OLAP.

1 590 (74.31%) Business Intelligence
2 569 (71.66%) SQL
3 538 (67.76%) SQL Server
4 447 (56.30%) Data Warehouse
5 388 (48.87%) SQL Server Reporting Services
6 367 (46.22%) SQL Server Integration Services
7 366 (46.10%) ETL
8 362 (45.59%) SQL Server Analysis Services
9 320 (40.30%) Microsoft
10 257 (32.37%) OLAP Cube
11 233 (29.35%) T-SQL
12 227 (28.59%) Finance
13 214 (26.95%) Agile Software Development
14 212 (26.70%) MS Excel
15 196 (24.69%) Oracle
15 196 (24.69%) Oracle OLAP
16 187 (23.55%) OLTP
17 175 (22.04%) SQL Server 2012
18 155 (19.52%) Analytical Skills
19 137 (17.25%) Data Modelling
20 135 (17.00%) MDX
21 133 (16.75%) Analytics
22 128 (16.12%) Tableau
23 118 (14.86%) Relational Database
24 115 (14.48%) Kimball Methodology
25 112 (14.11%) Performance Tuning
26 109 (13.73%) SQL Server 2008
27 94 (11.84%) Big Data
28 88 (11.08%) Hadoop
29 85 (10.71%) Degree

OLAP
Top Related 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 56 (7.05%) SharePoint
2 54 (6.80%) SAS
3 18 (2.27%) Apache
4 16 (2.02%) Tomcat
5 15 (1.89%) IIS
6 13 (1.64%) Apache Spark
6 13 (1.64%) WebSphere
7 12 (1.51%) Oracle Coherence
7 12 (1.51%) Oracle HTTP Server
8 6 (0.76%) Elasticsearch
9 5 (0.63%) Confluence
9 5 (0.63%) Oracle Workflow
10 4 (0.50%) Apache Pig
10 4 (0.50%) Oracle Spatial
11 2 (0.25%) NetWeaver
11 2 (0.25%) Oracle 10gAS
11 2 (0.25%) Oracle Application Server
11 2 (0.25%) SharePoint 2013
12 1 (0.13%) Blackberry Enterprise Server
12 1 (0.13%) MS Exchange
Applications
1 212 (26.70%) MS Excel
2 21 (2.64%) MS Office
3 12 (1.51%) MS Visio
4 3 (0.38%) MS PowerPoint
4 3 (0.38%) SPSS
5 2 (0.25%) Gephi
5 2 (0.25%) Spreadsheet
6 1 (0.13%) Acrobat
6 1 (0.13%) MS Project
Business Applications
1 14 (1.76%) Cognos Business Intelligence
2 13 (1.64%) Cognos TM1
3 12 (1.51%) SAP Business One
4 9 (1.13%) Oracle EBS
5 7 (0.88%) Cognos Controller
6 6 (0.76%) SAP BPC
7 5 (0.63%) Unica
8 4 (0.50%) Dynamics AX
8 4 (0.50%) Dynamics NAV
8 4 (0.50%) Oracle Financials
9 3 (0.38%) SAP Oil and Gas
10 2 (0.25%) Cognos Planning
10 2 (0.25%) HFM
10 2 (0.25%) Hyperion Planning
10 2 (0.25%) JDE OneWorld
11 1 (0.13%) JDE EnterpriseOne
11 1 (0.13%) Oracle Applications
11 1 (0.13%) Oracle Financial Analyzer
Cloud Services
1 47 (5.92%) Microsoft Azure
2 21 (2.64%) Amazon AWS
3 6 (0.76%) Azure Machine Learning
3 6 (0.76%) Data Lake Analytics
3 6 (0.76%) IaaS
3 6 (0.76%) PaaS
3 6 (0.76%) SaaS
4 2 (0.25%) GitHub
Communications & Networking
1 20 (2.52%) Intranet
1 20 (2.52%) SAN
2 16 (2.02%) Extranet
2 16 (2.02%) LAN
2 16 (2.02%) WAN
3 15 (1.89%) HTTP
4 12 (1.51%) FCoE
4 12 (1.51%) Fibre Channel
4 12 (1.51%) iSCSI
4 12 (1.51%) Multicast
4 12 (1.51%) NAS
5 8 (1.01%) Firewall
6 3 (0.38%) PBX
7 2 (0.25%) DHCP
7 2 (0.25%) DNS
7 2 (0.25%) Skype
7 2 (0.25%) TCP/IP
8 1 (0.13%) Asterisk PBX
8 1 (0.13%) PABX
8 1 (0.13%) Remote Desktop
Database & Business Intelligence
1 538 (67.76%) SQL Server
2 447 (56.30%) Data Warehouse
3 388 (48.87%) SQL Server Reporting Services
4 367 (46.22%) SQL Server Integration Services
5 362 (45.59%) SQL Server Analysis Services
6 257 (32.37%) OLAP Cube
7 196 (24.69%) Oracle OLAP
8 187 (23.55%) OLTP
9 175 (22.04%) SQL Server 2012
10 118 (14.86%) Relational Database
11 109 (13.73%) SQL Server 2008
12 94 (11.84%) Big Data
13 88 (11.08%) Hadoop
14 75 (9.45%) SQL Server 2014
15 65 (8.19%) Microsoft Analysis Services
16 64 (8.06%) QlikView
17 62 (7.81%) BusinessObjects
18 59 (7.43%) Power BI
19 54 (6.80%) PowerPivot
20 52 (6.55%) SQL Server 2005
Development Applications
1 25 (3.15%) Team Foundation Server
2 23 (2.90%) Visual Studio
3 14 (1.76%) Git (software)
4 12 (1.51%) JIRA
5 11 (1.39%) SQL Server Management Studio (SSMS)
6 7 (0.88%) Jenkins
7 6 (0.76%) ERwin
7 6 (0.76%) tSQLt
7 6 (0.76%) Visual Studio Tools for Office
8 5 (0.63%) Eclipse
9 4 (0.50%) Subversion
10 2 (0.25%) MorphX
10 2 (0.25%) Oracle Forms
10 2 (0.25%) PVCS
10 2 (0.25%) Ranorex
10 2 (0.25%) Visual Studio Team System
11 1 (0.13%) JUnit
11 1 (0.13%) Maven
11 1 (0.13%) Talend Open Studio
General
1 227 (28.59%) Finance
2 61 (7.68%) Banking
3 53 (6.68%) Retail
4 44 (5.54%) Marketing
5 41 (5.16%) Games
6 33 (4.16%) Telecoms
7 31 (3.90%) Manufacturing
8 22 (2.77%) Investment Banking
9 20 (2.52%) Legal
10 18 (2.27%) Front Office
11 12 (1.51%) Publishing
12 11 (1.39%) Advertising
13 7 (0.88%) Back Office
14 4 (0.50%) Electronics
15 2 (0.25%) Financial Institution
15 2 (0.25%) Law
16 1 (0.13%) Automotive
16 1 (0.13%) Billing
16 1 (0.13%) German Language
16 1 (0.13%) Pharmaceutical
Job Titles
1 410 (51.64%) Developer
2 249 (31.36%) Business Intelligence Developer
3 178 (22.42%) SQL Developer
4 100 (12.59%) Architect
5 94 (11.84%) SSAS Developer
6 89 (11.21%) SQL BI Developer
7 84 (10.58%) Analyst
8 83 (10.45%) SQL Server Developer
9 74 (9.32%) SSIS Developer
10 71 (8.94%) Senior Developer
11 67 (8.44%) Consultant
12 63 (7.93%) SSRS Developer
13 60 (7.56%) DBA
14 58 (7.30%) Data Architect
15 47 (5.92%) SQL Server BI Developer
16 45 (5.67%) Database Developer
17 44 (5.54%) Business Intelligence Consultant
18 43 (5.42%) SQL DBA
19 41 (5.16%) Oracle Developer
20 39 (4.91%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 135 (17.00%) MDX
2 67 (8.44%) .NET
3 35 (4.41%) XML
4 30 (3.78%) HTML
5 20 (2.52%) Web Services
6 19 (2.39%) REST
7 15 (1.89%) jQuery
8 13 (1.64%) Middleware
8 13 (1.64%) Oracle GoldenGate
9 11 (1.39%) CSS
9 11 (1.39%) JSON
10 10 (1.26%) D3.js
10 10 (1.26%) HTML5
11 9 (1.13%) ASP.NET
12 8 (1.01%) SOAP
13 7 (0.88%) WCF
14 6 (0.76%) Django
14 6 (0.76%) Leaflet
14 6 (0.76%) RESTful
15 4 (0.50%) AngularJS
Miscellaneous
1 155 (19.52%) Analytical Skills
2 67 (8.44%) Visualisation
3 58 (7.30%) Data Integration
4 48 (6.05%) Enterprise Software
5 47 (5.92%) Computer Science
6 42 (5.29%) Replication
7 37 (4.66%) Management Information System
8 33 (4.16%) Statistics
9 28 (3.53%) Clustering
10 26 (3.27%) Data Extraction
11 17 (2.14%) Credit Risk
12 16 (2.02%) Fintech
13 14 (1.76%) Mathematics
13 14 (1.76%) Online Games
14 10 (1.26%) Economics
15 9 (1.13%) Data Conversion
16 8 (1.01%) Data Protection Act
16 8 (1.01%) Data Structures
16 8 (1.01%) Neural Network
17 6 (0.76%) Mobile App
Operating Systems
1 58 (7.30%) Windows
2 54 (6.80%) Linux
3 40 (5.04%) Unix
4 12 (1.51%) Solaris
5 9 (1.13%) Windows Server
6 8 (1.01%) Oracle Linux
7 5 (0.63%) Windows Server 2008
7 5 (0.63%) Windows Server 2012
8 1 (0.13%) CentOS
8 1 (0.13%) Windows 7
8 1 (0.13%) Windows Vista
Processes & Methodologies
1 590 (74.31%) Business Intelligence
2 366 (46.10%) ETL
3 214 (26.95%) Agile Software Development
4 137 (17.25%) Data Modelling
5 133 (16.75%) Analytics
6 115 (14.48%) Kimball Methodology
7 112 (14.11%) Performance Tuning
8 76 (9.57%) Dimensional Modelling
9 72 (9.07%) Scrum
10 67 (8.44%) Business Analysis
11 60 (7.56%) Data Management
12 55 (6.93%) Project Management
13 54 (6.80%) Data Analysis
14 51 (6.42%) Data Architecture
14 51 (6.42%) SDLC
15 44 (5.54%) Data Analytics
16 36 (4.53%) Data Governance
16 36 (4.53%) ITIL
17 35 (4.41%) Migration
18 29 (3.65%) SOA
Programming Languages
1 569 (71.66%) SQL
2 233 (29.35%) T-SQL
3 75 (9.45%) PL/SQL
4 63 (7.93%) C#
5 44 (5.54%) Java
6 43 (5.42%) JavaScript
7 33 (4.16%) Python
8 31 (3.90%) VBA
9 27 (3.40%) Data Analysis Expressions (DAX)
10 18 (2.27%) C
11 16 (2.02%) Shell Script
12 15 (1.89%) R
13 14 (1.76%) Perl
13 14 (1.76%) PHP
13 14 (1.76%) PowerShell
13 14 (1.76%) VB.NET
14 9 (1.13%) C++
15 5 (0.63%) SAS Macro
15 5 (0.63%) Scala
15 5 (0.63%) VB
Qualifications
1 85 (10.71%) Degree
2 28 (3.53%) Microsoft Certification
3 10 (1.26%) MCSE
4 7 (0.88%) SC Cleared
4 7 (0.88%) Security Cleared
5 6 (0.76%) MCITP
5 6 (0.76%) MCP
5 6 (0.76%) MCSA
6 5 (0.63%) ACCA
6 5 (0.63%) CIMA
7 4 (0.50%) Oracle Certification
8 3 (0.38%) IBM Certification
8 3 (0.38%) ISEB
8 3 (0.38%) MCAD
9 2 (0.25%) AAT
10 1 (0.13%) CISSP
10 1 (0.13%) HND
10 1 (0.13%) ITIL Certification
10 1 (0.13%) MBA
10 1 (0.13%) PRINCE2 Certification
Quality Assurance & Compliance
1 48 (6.05%) Data Quality
2 39 (4.91%) QA
3 8 (1.01%) PCI DSS
4 4 (0.50%) Basel II
5 3 (0.38%) SLA
System Software
1 20 (2.52%) Oracle RAC
2 17 (2.14%) VMware Infrastructure
3 13 (1.64%) KVM
4 12 (1.51%) Hyper-V
4 12 (1.51%) NFS
4 12 (1.51%) SRDF
4 12 (1.51%) Xen
5 9 (1.13%) Virtual Machines
6 3 (0.38%) VMware ESX
6 3 (0.38%) vSphere
7 1 (0.13%) Active Directory
7 1 (0.13%) Firmware
7 1 (0.13%) Microsoft Virtual Server
7 1 (0.13%) Virtual Servers
7 1 (0.13%) VirtualBox
Systems Management
1 9 (1.13%) Data Guard
1 9 (1.13%) Oracle Enterprise Manager
2 7 (0.88%) Microsoft Clustering
3 4 (0.50%) Mesos
4 2 (0.25%) Cisco IPCC
4 2 (0.25%) Puppet
5 1 (0.13%) ITRS Geneos
5 1 (0.13%) Oozie
Vendors
1 320 (40.30%) Microsoft
2 196 (24.69%) Oracle
3 128 (16.12%) Tableau
4 65 (8.19%) Cognos
5 51 (6.42%) SAP
6 39 (4.91%) IBM
7 25 (3.15%) Teradata
8 24 (3.02%) VMware
9 23 (2.90%) Netezza
10 16 (2.02%) NetApp
11 15 (1.89%) EMC
11 15 (1.89%) Informatica
12 14 (1.76%) MicroStrategy
13 13 (1.64%) Cisco
14 12 (1.51%) Intel
15 9 (1.13%) Sybase
16 8 (1.01%) Actuate
16 8 (1.01%) Vertica
17 6 (0.76%) Alteryx
17 6 (0.76%) Splunk
South East London
Vantage Recruitment Solutions Ltd
Salary: From £55,000 to £65,000 per annum Bonus, Pension, Training, Healthcare
Posted: 12 hours ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 17 hours ago
London
Venturi
Salary: £50000.00 - £60000.00 per annum + Bonus & Benefits
Posted: 17 hours ago
London
Lorien Resourcing
Posted: 2 days ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 2 days ago
Birkenhead, Merseyside
Uniting Ambition
Salary: £30k - 40k per year + (Depending on experience)
Posted: 5 days ago
Manchester, Lancashire
Nigel Frank International Ltd
Salary: £55000 per annum + Benefits
Posted: 5 days ago
Ellesmere Port, Merseyside
Uniting Ambition
Salary: Market related
Posted: 6 days ago
Manchester
Computer Futures
Salary: competitive
Posted: 9 days ago
City, London
ANSON MCCADE
Salary: £50,000 - £75,000
Posted: 6 days ago
Glasgow
Vivid Resourcing
Posted: 5 days ago
City of London
Hays London City Cheapside
Salary: £50000.00 - £65000.00 per annum
Posted: 12 days ago
City of London
Lawrence Harvey
Salary: £65000.00 - £80000.00 per annum + bonus, pension, flexible working
Posted: 11 days ago
London
Lawrence Harvey Enterprise
Salary: £65000.00 - £80000.00 per annum + car, bonus, flexible working
Posted: 6 days ago
Slough, Berkshire
IT Talent Solutions
Salary: From £50,000 to £60,000 per annum
Posted: 6 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 6 days ago
Manchester
Arrow Global
Salary: Competitive
Posted: 13 days ago
City, London
DCV Technologies
Salary: From £65,000 to £70,000 per annum Plus Benefits
Posted: 3 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 7 days ago
Belfast, County Antrim
HAYS INFORMATION TECHNOLOGY
Salary: £27000.00 - £35000.00 per annum
Posted: 5 days ago
Malmesbury, Wiltshire
Dyson
Posted: 16 days ago
Preston, Lancashire
BAE Systems
Posted: 10 days ago
North Yorkshire
Lawrence Harvey
Salary: £40000 - £55000 per annum
Posted: 26 days ago
Greater Manchester
ANSON MCCADE
Salary: £40K-£60k plus attractive benefits, 30 days holiday and rapid career p
Posted: 6 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40K-£60k plus attractive benefits, 30 days holiday and rapid career p
Posted: 6 days ago
City, London
ANSON MCCADE
Salary: £40K-£60k plus attractive benefits, 30 days holiday and rapid career p
Posted: 6 days ago
Newcastle Upon Tyne, Tyne and Wear
ANSON MCCADE
Salary: £40K-£60k plus attractive benefits, 30 days holiday and rapid career p
Posted: 6 days ago
London - Mornington Crescent
ASOS
Posted: 19 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 9 days ago
London
Creative Personnel
Salary: £60000 - £70000 per annum
Posted: 6 days ago