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

3 months to
25 Sep 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 598 498 437
Rank change year-on-year
-100 -61
Permanent jobs citing OLAP 326 546 718
As % of all permanent IT jobs located in the UK 0.35% 0.50% 0.63%
As % of the Database & Business Intelligence category 1.17% 1.61% 2.01%
Number of salaries quoted 269 420 614
Median salary £50,000 £47,500 £50,000
Median salary % change year-on-year
+5.26% -5.00%
90% offered a salary of more than £37,500 £35,000 £35,000
10% offered a salary of more than £80,000 £70,000 £70,000
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -

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
27922 33810 35801
As % of all permanent IT jobs located in the UK 29.60% 30.82% 31.37%
Number of salaries quoted 23767 28606 30042
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,500 £30,000
10% offered a salary of more than £75,000 £67,500 £72,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 25 September 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 25 September 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 -103 298 £50,000 +5.26% 32
London -71 122 £65,000 +13.04% 10
South East +6 80 £50,000 +17.64% 5
Yorkshire +27 29 £45,000 - 3
West Yorkshire +16 22 £45,000 - 2
Hampshire 0 22 £45,000 +12.50% 1
North West -1 20 £42,500 -4.49% 4
City of London +35 17 £72,500 +26.08% 3
West Sussex +27 17 £54,000 +16.75%
Southampton - 16 £50,000 - 1
Scotland +26 15 £55,000 +15.78%
Leeds +25 15 £45,000 +9.09% 2
Surrey +23 15 £58,750 +30.55%
Berkshire +25 14 £52,500 +31.25% 2
East of England +15 14 £47,500 +18.75% 4
South West -1 13 £50,000 +25.00% 3
Edinburgh +26 12 £55,000 +15.78%
Slough +25 9 £55,000 +1.85%
East Midlands +13 9 £41,250 -2.94%
Cornwall - 9 £50,000 -
Camborne - 9 £50,000 -
Hertfordshire +23 8 £51,250 -10.48% 2
South Wales +22 8 £37,500 +6.38%
Wales +11 8 £37,500 +6.38%
Cardiff +17 7 £36,250 +2.83%
Bradford -11 7 £61,250 +28.94%
Kent +8 6 £50,000 +122.22%
Oxfordshire 0 6 £35,000 -22.22% 1
Merseyside -8 6 £45,000 +15.38%
Liverpool - 6 £45,000 -

OLAP
Top 30 Related IT Skills

For the 6 months to 25 September 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 546 (74.79%) SQL
2 523 (71.64%) SQL Server
3 518 (70.96%) Business Intelligence
4 421 (57.67%) Data Warehouse
5 334 (45.75%) SQL Server Reporting Services
6 327 (44.79%) ETL
7 319 (43.70%) SQL Server Integration Services
8 315 (43.15%) SQL Server Analysis Services
9 307 (42.05%) Microsoft
10 245 (33.56%) T-SQL
11 227 (31.10%) OLAP Cube
12 220 (30.14%) Finance
13 208 (28.49%) Agile Software Development
14 202 (27.67%) OLTP
15 198 (27.12%) MS Excel
16 180 (24.66%) Oracle
16 180 (24.66%) Oracle OLAP
17 145 (19.86%) SQL Server 2012
18 139 (19.04%) Analytical Skills
19 138 (18.90%) MDX
20 137 (18.77%) Data Modelling
21 129 (17.67%) Tableau
22 118 (16.16%) Analytics
23 116 (15.89%) Performance Tuning
24 115 (15.75%) Big Data
25 112 (15.34%) Kimball Methodology
26 109 (14.93%) Hadoop
27 107 (14.66%) Relational Database
28 85 (11.64%) SQL Server 2008
29 81 (11.10%) Windows

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 55 (7.53%) SAS
2 48 (6.58%) SharePoint
3 26 (3.56%) Apache
3 26 (3.56%) Apache Spark
3 26 (3.56%) IIS
4 23 (3.15%) Tomcat
5 21 (2.88%) Oracle Coherence
5 21 (2.88%) WebSphere
6 20 (2.74%) Oracle HTTP Server
7 14 (1.92%) Apache Pig
8 6 (0.82%) Elasticsearch
9 3 (0.41%) Oracle Spatial
10 2 (0.27%) Jupyter
10 2 (0.27%) NetWeaver
10 2 (0.27%) Oracle 10gAS
10 2 (0.27%) Oracle Application Server
10 2 (0.27%) Oracle Workflow
10 2 (0.27%) SharePoint 2013
10 2 (0.27%) SharePoint Server
11 1 (0.14%) Apache Solr
Applications
1 198 (27.12%) MS Excel
2 12 (1.64%) MS Office
3 4 (0.55%) Gephi
4 3 (0.41%) MS Visio
5 2 (0.27%) MS PowerPoint
5 2 (0.27%) SPSS
6 1 (0.14%) Acrobat
6 1 (0.14%) MS Project
6 1 (0.14%) Spreadsheet
Business Applications
1 16 (2.19%) Cognos TM1
2 14 (1.92%) Cognos Business Intelligence
3 12 (1.64%) SAP Business One
4 11 (1.51%) Oracle EBS
5 9 (1.23%) Cognos Controller
6 7 (0.96%) SAP BPC
7 5 (0.68%) Dynamics NAV
8 4 (0.55%) Dynamics AX
8 4 (0.55%) Oracle Financials
9 3 (0.41%) SAP Oil and Gas
10 2 (0.27%) Cognos Planning
10 2 (0.27%) Dynamics CRM
10 2 (0.27%) HFM
10 2 (0.27%) Infor M3
10 2 (0.27%) Magento
10 2 (0.27%) Unica
11 1 (0.14%) FastStats
11 1 (0.14%) Hyperion Planning
11 1 (0.14%) JDE EnterpriseOne
11 1 (0.14%) Oracle Financial Analyzer
Cloud Services
1 47 (6.44%) Microsoft Azure
2 23 (3.15%) Amazon AWS
3 13 (1.78%) GitHub
4 8 (1.10%) IaaS
4 8 (1.10%) PaaS
5 7 (0.96%) Azure Machine Learning
5 7 (0.96%) Data Lake Analytics
5 7 (0.96%) SaaS
6 5 (0.68%) Amazon S3
7 2 (0.27%) Google Cloud Platform
8 1 (0.14%) Google Play
Communications & Networking
1 31 (4.25%) SAN
2 24 (3.29%) LAN
2 24 (3.29%) WAN
3 22 (3.01%) HTTP
4 20 (2.74%) FCoE
4 20 (2.74%) Fibre Channel
4 20 (2.74%) iSCSI
4 20 (2.74%) Multicast
4 20 (2.74%) NAS
5 16 (2.19%) Intranet
6 13 (1.78%) Extranet
7 11 (1.51%) Firewall
8 3 (0.41%) PBX
8 3 (0.41%) Skype
9 2 (0.27%) DHCP
9 2 (0.27%) DNS
9 2 (0.27%) TCP/IP
10 1 (0.14%) Ethernet
10 1 (0.14%) GPRS
10 1 (0.14%) VoIP
Database & Business Intelligence
1 523 (71.64%) SQL Server
2 421 (57.67%) Data Warehouse
3 334 (45.75%) SQL Server Reporting Services
4 319 (43.70%) SQL Server Integration Services
5 315 (43.15%) SQL Server Analysis Services
6 227 (31.10%) OLAP Cube
7 202 (27.67%) OLTP
8 180 (24.66%) Oracle OLAP
9 145 (19.86%) SQL Server 2012
10 115 (15.75%) Big Data
11 109 (14.93%) Hadoop
12 107 (14.66%) Relational Database
13 85 (11.64%) SQL Server 2008
14 76 (10.41%) Microsoft Analysis Services
15 72 (9.86%) SQL Server 2014
16 62 (8.49%) QlikView
17 59 (8.08%) Power BI
18 57 (7.81%) NoSQL
19 56 (7.67%) MySQL
20 53 (7.26%) RDBMS
Development Applications
1 31 (4.25%) Visual Studio
2 30 (4.11%) Team Foundation Server
3 25 (3.42%) JIRA
4 14 (1.92%) SQL Server Management Studio (SSMS)
5 12 (1.64%) Jenkins
6 11 (1.51%) Talend Open Studio
7 9 (1.23%) Vagrant
8 7 (0.96%) Cucumber
8 7 (0.96%) ERwin
8 7 (0.96%) Visual Studio Tools for Office
9 6 (0.82%) tSQLt
10 4 (0.55%) Maven
11 3 (0.41%) Eclipse
11 3 (0.41%) Visual Studio Team System
12 2 (0.27%) MorphX
12 2 (0.27%) Oracle Forms
12 2 (0.27%) PVCS
12 2 (0.27%) Ranorex
12 2 (0.27%) Subversion
12 2 (0.27%) TeamCity
General
1 220 (30.14%) Finance
2 61 (8.36%) Banking
3 56 (7.67%) Retail
4 36 (4.93%) Manufacturing
5 34 (4.66%) Games
6 29 (3.97%) Telecoms
7 25 (3.42%) Marketing
8 20 (2.74%) Legal
9 16 (2.19%) Investment Banking
10 15 (2.05%) Front Office
11 11 (1.51%) Advertising
12 9 (1.23%) Publishing
13 7 (0.96%) Back Office
14 4 (0.55%) Electronics
15 3 (0.41%) Law
16 2 (0.27%) Billing
16 2 (0.27%) Financial Institution
17 1 (0.14%) Automotive
Job Titles
1 370 (50.68%) Developer
2 236 (32.33%) Business Intelligence Developer
3 130 (17.81%) SQL Developer
4 105 (14.38%) Architect
5 71 (9.73%) DBA
6 64 (8.77%) SQL BI Developer
7 62 (8.49%) Analyst
7 62 (8.49%) Data Architect
7 62 (8.49%) SSIS Developer
8 60 (8.22%) SSAS Developer
9 56 (7.67%) Senior Developer
9 56 (7.67%) SQL DBA
10 53 (7.26%) Consultant
11 50 (6.85%) SQL Server Developer
12 45 (6.16%) SSRS Developer
13 44 (6.03%) ETL Developer
14 39 (5.34%) Business Intelligence Consultant
15 37 (5.07%) SQL Server DBA
16 29 (3.97%) Business Intelligence Analyst
17 28 (3.84%) Business Developer
Libraries, Frameworks & Software Standards
1 138 (18.90%) MDX
2 58 (7.95%) .NET
3 34 (4.66%) XML
4 30 (4.11%) Web Services
5 26 (3.56%) REST
6 22 (3.01%) Middleware
7 21 (2.88%) HTML
8 19 (2.60%) JSON
9 13 (1.78%) D3.js
10 12 (1.64%) HTML5
10 12 (1.64%) jQuery
11 10 (1.37%) ASP.NET
12 9 (1.23%) Oracle GoldenGate
12 9 (1.23%) SOAP
13 8 (1.10%) CSS
14 7 (0.96%) Akka
14 7 (0.96%) Leaflet
15 6 (0.82%) .NET Framework
15 6 (0.82%) COM
15 6 (0.82%) RESTful
Miscellaneous
1 139 (19.04%) Analytical Skills
2 71 (9.73%) Visualisation
3 57 (7.81%) Data Integration
4 43 (5.89%) Computer Science
5 38 (5.21%) Enterprise Software
5 38 (5.21%) Replication
6 31 (4.25%) Clustering
7 30 (4.11%) Management Information System
8 28 (3.84%) Data Extraction
9 22 (3.01%) Statistics
10 16 (2.19%) Fintech
11 11 (1.51%) Mathematics
11 11 (1.51%) Neural Network
12 10 (1.37%) Credit Risk
12 10 (1.37%) Data Conversion
13 7 (0.96%) Data Structures
13 7 (0.96%) iPad
13 7 (0.96%) Mobile App
14 6 (0.82%) Data Protection Act
15 5 (0.68%) Life Science
Operating Systems
1 81 (11.10%) Windows
2 66 (9.04%) Linux
3 36 (4.93%) Unix
4 20 (2.74%) Solaris
5 15 (2.05%) Windows Server
6 5 (0.68%) Windows Server 2008
6 5 (0.68%) Windows Server 2012
7 4 (0.55%) Oracle Linux
8 2 (0.27%) CentOS
9 1 (0.14%) Android
9 1 (0.14%) Apple iOS
9 1 (0.14%) Red Hat Enterprise Linux
9 1 (0.14%) Windows 7
9 1 (0.14%) Windows Vista
Processes & Methodologies
1 518 (70.96%) Business Intelligence
2 327 (44.79%) ETL
3 208 (28.49%) Agile Software Development
4 137 (18.77%) Data Modelling
5 118 (16.16%) Analytics
6 116 (15.89%) Performance Tuning
7 112 (15.34%) Kimball Methodology
8 80 (10.96%) Scrum
9 73 (10.00%) Dimensional Modelling
10 62 (8.49%) Project Management
11 56 (7.67%) Data Architecture
12 55 (7.53%) Data Management
13 50 (6.85%) Business Analysis
14 46 (6.30%) Data Analysis
14 46 (6.30%) Data Analytics
15 44 (6.03%) Migration
15 44 (6.03%) SDLC
16 40 (5.48%) Data Governance
17 35 (4.79%) Disaster Recovery
18 29 (3.97%) Risk Management
Programming Languages
1 546 (74.79%) SQL
2 245 (33.56%) T-SQL
3 56 (7.67%) C#
4 53 (7.26%) Java
5 47 (6.44%) PL/SQL
6 43 (5.89%) Data Analysis Expressions (DAX)
7 38 (5.21%) JavaScript
8 32 (4.38%) Python
9 27 (3.70%) PowerShell
10 23 (3.15%) Shell Script
10 23 (3.15%) VBA
11 18 (2.47%) R
12 15 (2.05%) C
13 13 (1.78%) Perl
14 12 (1.64%) VB.NET
15 11 (1.51%) PHP
15 11 (1.51%) Scala
16 4 (0.55%) VB
17 3 (0.41%) C++
17 3 (0.41%) SAS Macro
Qualifications
1 74 (10.14%) Degree
2 36 (4.93%) Microsoft Certification
3 14 (1.92%) MCITP
3 14 (1.92%) MCSE
4 13 (1.78%) SC Cleared
4 13 (1.78%) Security Cleared
5 6 (0.82%) MCP
5 6 (0.82%) MCSA
6 5 (0.68%) ACCA
6 5 (0.68%) CIMA
7 3 (0.41%) IBM Certification
7 3 (0.41%) ISEB
8 2 (0.27%) AAT
8 2 (0.27%) Oracle Certification
8 2 (0.27%) PRINCE2 Certification
9 1 (0.14%) CISSP
9 1 (0.14%) HND
9 1 (0.14%) ITIL Certification
9 1 (0.14%) Postgraduate
Quality Assurance & Compliance
1 34 (4.66%) QA
2 31 (4.25%) Data Quality
3 3 (0.41%) PCI DSS
4 1 (0.14%) Basel III
4 1 (0.14%) Dodd-Frank
4 1 (0.14%) HIPAA
4 1 (0.14%) ISO/IEC 27001
4 1 (0.14%) SLA
4 1 (0.14%) SSAE 16
System Software
1 26 (3.56%) VMware Infrastructure
2 24 (3.29%) Oracle RAC
3 21 (2.88%) KVM
4 20 (2.74%) Hyper-V
4 20 (2.74%) NFS
4 20 (2.74%) SRDF
4 20 (2.74%) Xen
5 12 (1.64%) Virtual Machines
6 8 (1.10%) HDFS
7 5 (0.68%) VMware ESX
7 5 (0.68%) vSphere
8 3 (0.41%) Apache Flume
9 1 (0.14%) Active Directory
9 1 (0.14%) Docker
9 1 (0.14%) Firmware
9 1 (0.14%) Microsoft Virtual Server
9 1 (0.14%) Virtual Servers
9 1 (0.14%) VirtualBox
Systems Management
1 13 (1.78%) Microsoft Clustering
2 12 (1.64%) Puppet
3 5 (0.68%) Oracle Enterprise Manager
4 4 (0.55%) Data Guard
4 4 (0.55%) Mesos
4 4 (0.55%) Oozie
5 3 (0.41%) ITRS Geneos
6 1 (0.14%) Cisco IPCC
Vendors
1 307 (42.05%) Microsoft
2 180 (24.66%) Oracle
3 129 (17.67%) Tableau
4 65 (8.90%) Cognos
5 45 (6.16%) IBM
6 41 (5.62%) SAP
7 39 (5.34%) VMware
8 25 (3.42%) NetApp
9 21 (2.88%) EMC
10 20 (2.74%) Cisco
10 20 (2.74%) Informatica
10 20 (2.74%) Intel
11 17 (2.33%) Teradata
12 13 (1.78%) Computacenter
12 13 (1.78%) Netezza
13 12 (1.64%) MicroStrategy
14 11 (1.51%) Sybase
14 11 (1.51%) Talend
15 8 (1.10%) Google
15 8 (1.10%) Splunk
City, London
Capital IT Resourcing LTD
Salary: £45000 - £50000 per annum + Benefits
Posted: 3 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 2 days ago
London
Oscar
Salary: £35000 - £45000 per annum
Posted: 2 days ago
City, London
Oxbridge Answers
Salary: 45,000-50,000
Posted: 3 days ago
City, London
Evolution Recruitment Solutions
Salary: 32,000 - 35,000 + Bonus
Posted: 4 days ago
Swindon, Wiltshire
Redrock Consulting Ltd
Salary: £40000 - £50000 per annum + excellent benefits
Posted: 4 days ago
Oxfordshire
Lawrence Harvey Enterprise
Salary: £55000.00 - £60000.00 per annum + pension, bonus, health care
Posted: 4 days ago
Reading, Berkshire
Opus Recruitment Solutions Ltd
Salary: £40000 - £50000 per annum
Posted: 5 days ago
Leeds, West Yorkshire
onezeero.
Salary: £45000 - £50000 per annum
Posted: 5 days ago
North Yorkshire
Redrock Consulting Ltd
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 3 days ago
Central London / West End
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 2 days ago
Reading, Berkshire
Lawrence Harvey Enterprise
Salary: £60000 - £65000 per annum + Benefits
Posted: 3 days ago
Stratford-Upon-Avon, Warwickshire
Rebel Recruitment
Salary: From £40,000 to £55,000 per annum £40k - £50k + £5k benefits/cash alte
Posted: 5 days ago
Leeds, West Yorkshire
Fruition IT Resources Limited
Salary: £40000.00 - £50000.00 per annum + Benefits + Free Parking
Posted: 6 days ago
Suffolk
Nigel Frank International Ltd
Salary: £30000 - £50000 per annum + Pension, Training
Posted: 13 days ago
Manchester
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 17 days ago
Coventry, West Midlands (County)
Leidos
Posted: 23 days ago
Manchester
Nigel Frank International Ltd
Salary: £60000 per annum
Posted: 19 days ago
Bristol
Hargreaves Lansdown
Salary: Competitive
Posted: 19 days ago
London
Lawrence Harvey
Salary: £40000.00 - £45000.00 per annum + Benefits
Posted: 23 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 9 days ago
London
Lawrence Harvey
Salary: £50000.00 - £85000.00 per annum + bonus + benefits
Posted: 19 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 25 days ago
Luton, Bedfordshire
Tui (Ip) Ltd
Salary: Competitive Salary
Posted: 17 days ago