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

3 months to
24 Feb 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK
Rank 562 567 526
Rank change year-on-year
+5 -41
Permanent jobs citing OLAP 308 404 496
As % of all permanent IT jobs located in the UK 0.37% 0.40% 0.46%
As % of the Database & Business Intelligence category 1.20% 1.25% 1.49%
Number of salaries quoted 273 325 388
Median salary £50,000 £52,500 £52,500
Median salary % change year-on-year
-4.76% -
90% offered a salary of more than £35,000 £35,700 £35,000
10% offered a salary of more than £70,000 £70,800 £75,000
UK excluding London median salary £45,000 £45,500 £40,000
% change year-on-year
-1.09% +13.75%

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
25628 32229 33346
As % of all permanent IT jobs located in the UK 30.42% 31.54% 31.22%
Number of salaries quoted 21806 27310 28549
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,750
10% offered a salary of more than £72,500 £70,000 £71,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 24 February 2017 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 February 2017. 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 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 +33 297 £50,000 -9.09% 30
London +14 122 £60,000 +4.34% 9
South East +81 87 £52,500 +2.94% 3
East of England +37 35 £43,000 -29.79% 6
City of London +19 28 £62,500 +13.63% 2
Surrey +58 26 £55,000 - 2
Suffolk +32 22 £43,000 -33.84%
West Midlands +25 20 £42,500 -1.16% 3
Berkshire +38 16 £37,000 -17.77% 1
Reading +56 15 £37,000 -26.00% 1
Yorkshire -14 13 £42,500 - 2
Guildford - 13 £55,000 - 1
Buckinghamshire +30 12 £47,500 +17.28%
West Yorkshire -13 11 £42,500 - 2
Milton Keynes +23 10 £87,000 +114.81%
North West -24 9 £36,000 -20.00% 6
West Sussex +18 8 £47,500 +11.76%
Manchester -27 8 £36,000 -19.55% 3
Ipswich +32 7 £37,500 -44.44%
Kent +14 7 £50,000 +33.33%
East Midlands +12 7 £45,000 -14.28%
Leeds -5 7 £42,500 +6.25% 2
Oxfordshire +23 6 £52,500 +9.37%
Glasgow +22 5 £38,000 -5.00%
Scotland +19 5 £38,000 -10.58%
Hertfordshire +8 5 £45,000 -23.40% 1
Oxford - 5 £50,000 -
Bury St Edmunds - 5 £43,000 -
Northamptonshire +26 4 £45,000 +20.00%
Birmingham +7 4 £32,500 -7.14% 1

OLAP
Top 30 Related IT Skills

For the 6 months to 24 February 2017, 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 450 (78.81%) SQL
2 397 (69.53%) Business Intelligence
3 377 (66.02%) SQL Server
4 328 (57.44%) Data Warehouse
5 318 (55.69%) SQL Server Integration Services
6 304 (53.24%) SQL Server Reporting Services
7 288 (50.44%) SQL Server Analysis Services
8 277 (48.51%) ETL
9 270 (47.29%) Microsoft
10 219 (38.35%) T-SQL
11 177 (31.00%) Agile Software Development
12 170 (29.77%) OLTP
13 149 (26.09%) OLAP Cube
14 144 (25.22%) MS Excel
15 135 (23.64%) Oracle
15 135 (23.64%) Oracle OLAP
16 134 (23.47%) Finance
17 132 (23.12%) Power BI
18 123 (21.54%) Data Modelling
19 114 (19.96%) SQL Server 2012
19 114 (19.96%) Relational Database
20 112 (19.61%) Analytics
21 109 (19.09%) Big Data
22 105 (18.39%) MDX
23 103 (18.04%) SQL Server 2008
24 102 (17.86%) .NET
25 101 (17.69%) Kimball Methodology
26 96 (16.81%) Performance Tuning
27 92 (16.11%) Hadoop
28 80 (14.01%) Tableau

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 49 (8.58%) SharePoint
2 29 (5.08%) IIS
3 26 (4.55%) Apache
4 20 (3.50%) Apache Pig
4 20 (3.50%) Apache Spark
5 17 (2.98%) Tomcat
5 17 (2.98%) WebSphere
6 15 (2.63%) Oracle Coherence
6 15 (2.63%) Oracle HTTP Server
7 12 (2.10%) SAS
8 9 (1.58%) Elasticsearch
9 8 (1.40%) Oracle SOA Suite
10 7 (1.23%) Apache Airflow
11 5 (0.88%) Jupyter
11 5 (0.88%) Oracle Service Bus
12 4 (0.70%) SharePoint 2013
13 3 (0.53%) Apache Solr
13 3 (0.53%) SharePoint Server
14 1 (0.18%) DataSynapse
14 1 (0.18%) Skype for Business
Applications
1 144 (25.22%) MS Excel
2 11 (1.93%) MS Visio
3 9 (1.58%) MS Office
4 1 (0.18%) MS PowerPoint
Business Applications
1 11 (1.93%) Cognos TM1
2 9 (1.58%) SAP BPC
3 6 (1.05%) Dynamics AX
3 6 (1.05%) FastStats
4 5 (0.88%) Dynamics CRM
5 3 (0.53%) Hyperion Planning
6 2 (0.35%) Adobe Campaign
6 2 (0.35%) Dynamics NAV
6 2 (0.35%) Eloqua
6 2 (0.35%) HFM
6 2 (0.35%) Unica
7 1 (0.18%) Cognos Business Intelligence
7 1 (0.18%) Cognos Planning
7 1 (0.18%) OPENHousing
7 1 (0.18%) Oracle Applications
7 1 (0.18%) Oracle CRM
7 1 (0.18%) SAP CRM
7 1 (0.18%) SAP ERP
7 1 (0.18%) SAP SD
Cloud Services
1 55 (9.63%) Microsoft Azure
2 27 (4.73%) Amazon AWS
3 21 (3.68%) GitHub
4 7 (1.23%) Amazon Kinesis
4 7 (1.23%) Google Cloud Platform
4 7 (1.23%) SaaS
5 5 (0.88%) Amazon S3
5 5 (0.88%) Azure Machine Learning
5 5 (0.88%) Data Lake Analytics
6 3 (0.53%) Google Analytics
6 3 (0.53%) IaaS
7 2 (0.35%) PaaS
7 2 (0.35%) Responsys
8 1 (0.18%) Google Play
Communications & Networking
1 23 (4.03%) Intranet
2 21 (3.68%) SAN
3 16 (2.80%) HTTP
3 16 (2.80%) LAN
3 16 (2.80%) WAN
4 15 (2.63%) FCoE
4 15 (2.63%) Fibre Channel
4 15 (2.63%) iSCSI
4 15 (2.63%) Multicast
4 15 (2.63%) NAS
5 4 (0.70%) Ethernet
6 3 (0.53%) Internet
6 3 (0.53%) SSL
7 2 (0.35%) Extranet
7 2 (0.35%) Firewall
8 1 (0.18%) DHCP
8 1 (0.18%) DNS
8 1 (0.18%) FTP
8 1 (0.18%) GPRS
8 1 (0.18%) HTTPS
Database & Business Intelligence
1 377 (66.02%) SQL Server
2 328 (57.44%) Data Warehouse
3 318 (55.69%) SQL Server Integration Services
4 304 (53.24%) SQL Server Reporting Services
5 288 (50.44%) SQL Server Analysis Services
6 170 (29.77%) OLTP
7 149 (26.09%) OLAP Cube
8 135 (23.64%) Oracle OLAP
9 132 (23.12%) Power BI
10 114 (19.96%) Relational Database
10 114 (19.96%) SQL Server 2012
11 109 (19.09%) Big Data
12 103 (18.04%) SQL Server 2008
13 92 (16.11%) Hadoop
14 74 (12.96%) MySQL
15 65 (11.38%) SQL Server 2014
16 63 (11.03%) QlikView
16 63 (11.03%) SQL Server 2005
17 62 (10.86%) NoSQL
18 60 (10.51%) Microsoft Analysis Services
Development Applications
1 54 (9.46%) Visual Studio
2 49 (8.58%) JIRA
3 47 (8.23%) Team Foundation Server
4 25 (4.38%) Talend Open Studio
5 15 (2.63%) Visual Studio Team System
6 12 (2.10%) ERwin
7 11 (1.93%) Jenkins
8 10 (1.75%) Git (software)
9 9 (1.58%) Vagrant
10 7 (1.23%) Cucumber
10 7 (1.23%) Eclipse
10 7 (1.23%) git-flow
10 7 (1.23%) MagicDraw
11 6 (1.05%) PowerDesigner
11 6 (1.05%) SQL Server Management Studio (SSMS)
12 4 (0.70%) JUnit
12 4 (0.70%) Maven
13 2 (0.35%) Oracle Forms
13 2 (0.35%) Subversion
13 2 (0.35%) TestNG
General
1 134 (23.47%) Finance
2 37 (6.48%) Advertising
3 31 (5.43%) Banking
4 23 (4.03%) Legal
5 21 (3.68%) Manufacturing
6 19 (3.33%) Marketing
7 14 (2.45%) Investment Banking
8 13 (2.28%) Retail
9 9 (1.58%) Financial Institution
9 9 (1.58%) Games
10 8 (1.40%) German Language
10 8 (1.40%) Spanish Language
11 6 (1.05%) French Language
12 5 (0.88%) Back Office
13 4 (0.70%) Automotive
13 4 (0.70%) Billing
13 4 (0.70%) Dutch Language
13 4 (0.70%) Electronics
13 4 (0.70%) General Ledger
13 4 (0.70%) Italian Language
Job Titles
1 293 (51.31%) Developer
2 167 (29.25%) Business Intelligence Developer
3 100 (17.51%) SQL Developer
4 88 (15.41%) Analyst
5 75 (13.13%) DBA
6 72 (12.61%) Senior Developer
7 58 (10.16%) SSIS Developer
8 53 (9.28%) SQL DBA
9 47 (8.23%) SQL BI Developer
10 46 (8.06%) Architect
11 44 (7.71%) SSRS Developer
12 43 (7.53%) Business Intelligence Analyst
13 41 (7.18%) ETL Developer
14 37 (6.48%) SSAS Developer
15 33 (5.78%) Business Developer
16 32 (5.60%) Administrator
17 31 (5.43%) Data Warehouse Developer
17 31 (5.43%) SQL Server DBA
18 30 (5.25%) Senior Business Intelligence Developer
19 28 (4.90%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 105 (18.39%) MDX
2 102 (17.86%) .NET
3 40 (7.01%) XML
4 29 (5.08%) Web Services
5 20 (3.50%) Middleware
6 18 (3.15%) HTML
7 16 (2.80%) ASP.NET
7 16 (2.80%) Oracle GoldenGate
8 13 (2.28%) JSON
9 11 (1.93%) .NET Framework
10 8 (1.40%) Akka
10 8 (1.40%) Kafka
10 8 (1.40%) SOAP
11 7 (1.23%) CSS
11 7 (1.23%) jQuery
11 7 (1.23%) REST
11 7 (1.23%) Scrapy
11 7 (1.23%) Spring
12 5 (0.88%) GraphX
12 5 (0.88%) Serverless Framework
Miscellaneous
1 74 (12.96%) Analytical Skills
2 53 (9.28%) Management Information System
3 41 (7.18%) Replication
4 27 (4.73%) Clustering
5 22 (3.85%) Computer Science
6 16 (2.80%) Fintech
7 8 (1.40%) Reference Data
8 6 (1.05%) Mobile App
9 5 (0.88%) Data Structures
9 5 (0.88%) NHS
9 5 (0.88%) Taxonomies
10 4 (0.70%) Data Centre
10 4 (0.70%) Online Games
10 4 (0.70%) Social Media
11 3 (0.53%) Derivative
11 3 (0.53%) Enterprise Software
11 3 (0.53%) iPad
12 2 (0.35%) Credit Derivative
12 2 (0.35%) Data Protection Act
12 2 (0.35%) Spread Betting
Operating Systems
1 51 (8.93%) Windows
2 41 (7.18%) Linux
3 17 (2.98%) Unix
4 16 (2.80%) Windows Server 2008
5 15 (2.63%) Solaris
5 15 (2.63%) Windows Server 2012
6 12 (2.10%) Windows Server
7 1 (0.18%) Android
7 1 (0.18%) Apple iOS
7 1 (0.18%) CentOS
7 1 (0.18%) Red Hat Enterprise Linux
Processes & Methodologies
1 397 (69.53%) Business Intelligence
2 277 (48.51%) ETL
3 177 (31.00%) Agile Software Development
4 123 (21.54%) Data Modelling
5 112 (19.61%) Analytics
6 101 (17.69%) Kimball Methodology
7 96 (16.81%) Performance Tuning
8 74 (12.96%) Dimensional Modelling
9 68 (11.91%) Scrum
10 55 (9.63%) Data Integration
11 49 (8.58%) Visualisation
12 46 (8.06%) Time Management
13 41 (7.18%) SDLC
14 36 (6.30%) Data Visualisation
15 35 (6.13%) Disaster Recovery
16 34 (5.95%) Mentoring
16 34 (5.95%) Migration
17 30 (5.25%) High Availability
17 30 (5.25%) ITIL
18 29 (5.08%) Data Management
Programming Languages
1 450 (78.81%) SQL
2 219 (38.35%) T-SQL
3 70 (12.26%) C#
4 52 (9.11%) PL/SQL
5 42 (7.36%) Data Analysis Expressions (DAX)
6 38 (6.65%) Java
7 24 (4.20%) PowerShell
8 20 (3.50%) Python
9 19 (3.33%) JavaScript
10 15 (2.63%) VB.NET
11 14 (2.45%) VBA
12 13 (2.28%) R
13 12 (2.10%) Shell Script
14 10 (1.75%) Scala
15 9 (1.58%) C
16 7 (1.23%) C++
17 6 (1.05%) PHP
18 5 (0.88%) ABAP
19 4 (0.70%) Embedded C
19 4 (0.70%) Embedded C++
Qualifications
1 67 (11.73%) Degree
2 34 (5.95%) Microsoft Certification
3 15 (2.63%) MCITP
3 15 (2.63%) SC Cleared
3 15 (2.63%) Security Cleared
4 10 (1.75%) MCSE
5 6 (1.05%) CIMA
6 2 (0.35%) MCTS
6 2 (0.35%) Postgraduate
7 1 (0.18%) ACCA
Quality Assurance & Compliance
1 51 (8.93%) Data Quality
2 23 (4.03%) QA
3 14 (2.45%) SLA
4 5 (0.88%) ISO20022
5 3 (0.53%) PCI DSS
6 2 (0.35%) Basel III
6 2 (0.35%) Dodd-Frank
7 1 (0.18%) HIPAA
7 1 (0.18%) IFRS
7 1 (0.18%) IFRS 9
7 1 (0.18%) ISO/IEC 27001
7 1 (0.18%) SSAE 16
System Software
1 20 (3.50%) Oracle RAC
2 16 (2.80%) VMware Infrastructure
3 15 (2.63%) Hyper-V
3 15 (2.63%) KVM
3 15 (2.63%) NFS
3 15 (2.63%) SRDF
3 15 (2.63%) Xen
4 9 (1.58%) HDFS
5 8 (1.40%) Active Directory
6 4 (0.70%) Firmware
7 2 (0.35%) Apache Flume
7 2 (0.35%) Apache ZooKeeper
8 1 (0.18%) Docker
8 1 (0.18%) VMware ESXi
Systems Management
1 22 (3.85%) Puppet
2 7 (1.23%) Kibana
3 5 (0.88%) Enterprise Manager Cloud Control
3 5 (0.88%) Oracle Enterprise Manager
3 5 (0.88%) Oracle RMAN
4 3 (0.53%) Oozie
5 2 (0.35%) Hadoop YARN
5 2 (0.35%) Microsoft Clustering
5 2 (0.35%) Perfmon
6 1 (0.18%) ITRS Geneos
6 1 (0.18%) WSUS
Vendors
1 270 (47.29%) Microsoft
2 135 (23.64%) Oracle
3 80 (14.01%) Tableau
4 53 (9.28%) Cognos
5 27 (4.73%) IBM
6 25 (4.38%) Talend
7 20 (3.50%) SAP
8 19 (3.33%) Cisco
8 19 (3.33%) EMC
9 18 (3.15%) VMware
10 15 (2.63%) Intel
10 15 (2.63%) NetApp
11 13 (2.28%) Google
12 11 (1.93%) Computacenter
12 11 (1.93%) MicroStrategy
13 10 (1.75%) Hyperion
14 8 (1.40%) Actian
14 8 (1.40%) Informatica
14 8 (1.40%) Splunk
14 8 (1.40%) Sybase
Borehamwood, Hertfordshire
Capital IT Resourcing LTD
Salary: £35000 - £45000 per annum + Benefits
Posted: 6 hours ago
Falmouth
Nigel Frank International
Salary: £30000 - £40000 per annum + pension, negotiable
Posted: Yesterday
London
Huxley
Salary: competitive
Posted: Yesterday
Brentford
Nigel Frank International
Salary: £60000 per annum
Posted: 2 days ago
Greater Manchester
Verticality Ltd
Salary: to £25k DOE + Bonus + Benefits
Posted: 2 days ago
Solihull, West Midlands (County)
Modis International
Salary: £30000.00 - £38000.00 per annum + Benefits package
Posted: 2 days ago
Birmingham, West Midlands (County)
Modis International
Posted: 2 days ago
Diss, Norfolk
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £45000.00 per annum
Posted: 4 days ago
Stoke-On-Trent, Staffordshire
Uniting Ambition
Salary: £35k - 45k per year + pension, holidays and flexible working
Posted: 4 days ago
Warrington
Nigel Frank International
Salary: £40000 - £45000 per annum + package
Posted: 3 days ago
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + package
Posted: 7 days ago
City, London
Henderson Drake
Salary: From £34,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 2 days ago
Surrey
Opus Recruitment Solutions Ltd
Salary: £50000 - £70000 per annum, Benefits Benefits & Bonus included
Posted: 3 days ago
Reading, Oxfordshire
Oracle
Salary: Competitive
Posted: 2 days ago
Leeds
Nigel Frank International
Salary: £25000 - £30000 per annum + company package
Posted: 9 days ago
Wilmslow
Nigel Frank International
Salary: £35000 - £40000 per annum + company bonus + benefits
Posted: 9 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 11 days ago
West London
The Workshop
Salary: Excellent salary + benefits
Posted: 7 days ago
Isle of Man
Nigel Frank International
Salary: £35000 - £45000 per annum + Package
Posted: 17 days ago
City of London
Venturi
Salary: £22000.00 - £30000.00 per annum
Posted: 15 days ago
Guildford
Venturi
Salary: £50000 - £60000 per annum + company benefits
Posted: 22 days ago
Brentwood, Essex
Shawbrook
Posted: 22 days ago