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

3 months to
22 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK
Rank 583 534 532
Rank change year-on-year
-49 -2
Permanent jobs citing OLAP 276 451 468
As % of all permanent IT jobs located in the UK 0.33% 0.45% 0.45%
As % of the Database & Business Intelligence category 1.10% 1.40% 1.44%
Number of salaries quoted 236 380 396
Median salary £47,500 £50,000 £47,500
Median salary % change year-on-year
-5.00% +5.26%
90% offered a salary of more than £37,000 £35,000 £32,750
10% offered a salary of more than £65,000 £70,000 £72,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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
25139 32234 32433
As % of all permanent IT jobs located in the UK 30.28% 32.11% 30.95%
Number of salaries quoted 21611 27264 27821
Median salary £50,000 £47,850 £45,000
Median salary % change year-on-year
+4.49% +6.33%
90% offered a salary of more than £32,500 £32,500 £30,565
10% offered a salary of more than £75,000 £70,000 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +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 22 January 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 22 January 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 -31 265 £48,000 -8.57% 43
London -38 96 £60,000 +4.34% 16
South East +88 75 £50,000 +11.11% 5
East of England +35 40 £43,000 -25.08% 3
West Midlands +16 24 £42,500 +21.42% 6
Suffolk - 23 £43,000 - 2
Surrey +57 22 £55,000 - 1
City of London +14 17 £55,000 - 5
West Sussex +11 14 £47,500 +5.55%
North West -42 12 £37,500 -21.05% 5
Yorkshire -16 9 £43,750 +6.06% 4
Manchester -35 9 £37,500 -21.05% 4
Guildford - 9 £55,000 -
Reading +45 8 £37,000 -26.00%
Berkshire +44 8 £37,000 -26.00%
West Yorkshire -10 8 £45,000 +9.09% 4
Hertfordshire +2 7 £45,000 -21.73%
Ipswich - 7 £37,500 - 1
Buckinghamshire +30 6 £42,750 +5.55% 1
East Midlands +5 6 £45,000 -14.28% 3
Scotland +21 5 £46,000 +8.23%
Hampshire +18 5 £45,000 -5.26% 1
Milton Keynes +11 5 £41,500 +2.46% 1
Bury St Edmunds - 5 £43,000 - 1
Bedfordshire - 5 £58,000 -
Glasgow - 5 £46,000 -
Egham +20 4 £55,000 -
Bradford +2 4 £45,000 -28.00%
Northamptonshire 0 4 £45,000 +9.09%
Woking - 4 £47,500 -

OLAP
Top 30 Related IT Skills

For the 6 months to 22 January 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 428 (78.24%) SQL
2 386 (70.57%) SQL Server
3 374 (68.37%) Business Intelligence
4 318 (58.14%) Data Warehouse
5 286 (52.29%) SQL Server Integration Services
6 274 (50.09%) SQL Server Analysis Services
7 269 (49.18%) SQL Server Reporting Services
8 266 (48.63%) Microsoft
9 261 (47.71%) ETL
10 217 (39.67%) T-SQL
11 181 (33.09%) Agile Software Development
12 172 (31.44%) OLTP
13 144 (26.33%) OLAP Cube
14 142 (25.96%) MS Excel
15 139 (25.41%) Oracle
15 139 (25.41%) Oracle OLAP
16 133 (24.31%) Finance
17 125 (22.85%) Data Modelling
18 116 (21.21%) Big Data
19 113 (20.66%) MDX
20 108 (19.74%) Power BI
21 107 (19.56%) SQL Server 2012
22 104 (19.01%) Hadoop
23 102 (18.65%) Performance Tuning
24 100 (18.28%) Analytics
25 98 (17.92%) Kimball Methodology
26 97 (17.73%) Relational Database
26 97 (17.73%) SQL Server 2008
27 85 (15.54%) .NET
28 84 (15.36%) 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 45 (8.23%) SharePoint
2 32 (5.85%) IIS
3 26 (4.75%) Apache
4 21 (3.84%) Apache Pig
4 21 (3.84%) SAS
5 20 (3.66%) Apache Spark
5 20 (3.66%) Oracle Coherence
6 19 (3.47%) Oracle HTTP Server
6 19 (3.47%) Tomcat
6 19 (3.47%) WebSphere
7 8 (1.46%) Oracle SOA Suite
8 5 (0.91%) Jupyter
9 3 (0.55%) Elasticsearch
9 3 (0.55%) Oracle Service Bus
9 3 (0.55%) SharePoint Server
10 2 (0.37%) Apache Solr
10 2 (0.37%) SharePoint 2013
11 1 (0.18%) Apache Airflow
11 1 (0.18%) Skype for Business
Applications
1 142 (25.96%) MS Excel
2 7 (1.28%) MS Office
3 6 (1.10%) MS Visio
4 2 (0.37%) Gephi
5 1 (0.18%) MS PowerPoint
5 1 (0.18%) SPSS
Business Applications
1 8 (1.46%) SAP BPC
2 7 (1.28%) Cognos TM1
3 6 (1.10%) FastStats
4 5 (0.91%) Dynamics AX
4 5 (0.91%) Dynamics CRM
4 5 (0.91%) Dynamics NAV
5 2 (0.37%) Adobe Campaign
5 2 (0.37%) Cognos Business Intelligence
5 2 (0.37%) Cognos Controller
5 2 (0.37%) Eloqua
5 2 (0.37%) HFM
5 2 (0.37%) Infor M3
5 2 (0.37%) Magento
5 2 (0.37%) Oracle EBS
5 2 (0.37%) Unica
6 1 (0.18%) OPENHousing
6 1 (0.18%) Oracle Applications
6 1 (0.18%) Oracle CRM
6 1 (0.18%) SAP CRM
6 1 (0.18%) SAP ERP
Cloud Services
1 51 (9.32%) Microsoft Azure
2 23 (4.20%) Amazon AWS
3 21 (3.84%) GitHub
4 7 (1.28%) Google Cloud Platform
4 7 (1.28%) SaaS
5 6 (1.10%) Azure Machine Learning
5 6 (1.10%) Data Lake Analytics
6 5 (0.91%) Amazon S3
7 3 (0.55%) IaaS
8 2 (0.37%) Google Analytics
8 2 (0.37%) PaaS
8 2 (0.37%) Responsys
9 1 (0.18%) Amazon Kinesis
9 1 (0.18%) Google Play
Communications & Networking
1 24 (4.39%) SAN
2 22 (4.02%) Intranet
3 19 (3.47%) FCoE
3 19 (3.47%) Fibre Channel
3 19 (3.47%) HTTP
3 19 (3.47%) iSCSI
3 19 (3.47%) LAN
3 19 (3.47%) Multicast
3 19 (3.47%) NAS
3 19 (3.47%) WAN
4 4 (0.73%) Firewall
5 3 (0.55%) Internet
5 3 (0.55%) SSL
6 2 (0.37%) Ethernet
6 2 (0.37%) Extranet
7 1 (0.18%) Cisco ASA
7 1 (0.18%) DHCP
7 1 (0.18%) DNS
7 1 (0.18%) HTTPS
7 1 (0.18%) Skype
Database & Business Intelligence
1 386 (70.57%) SQL Server
2 318 (58.14%) Data Warehouse
3 286 (52.29%) SQL Server Integration Services
4 274 (50.09%) SQL Server Analysis Services
5 269 (49.18%) SQL Server Reporting Services
6 172 (31.44%) OLTP
7 144 (26.33%) OLAP Cube
8 139 (25.41%) Oracle OLAP
9 116 (21.21%) Big Data
10 108 (19.74%) Power BI
11 107 (19.56%) SQL Server 2012
12 104 (19.01%) Hadoop
13 97 (17.73%) Relational Database
13 97 (17.73%) SQL Server 2008
14 75 (13.71%) MySQL
15 71 (12.98%) NoSQL
16 68 (12.43%) SQL Server 2014
17 64 (11.70%) Microsoft Analysis Services
18 63 (11.52%) SQL Server 2005
19 62 (11.33%) QlikView
Development Applications
1 51 (9.32%) JIRA
1 51 (9.32%) Visual Studio
2 42 (7.68%) Team Foundation Server
3 25 (4.57%) Talend Open Studio
4 15 (2.74%) Visual Studio Team System
5 11 (2.01%) ERwin
5 11 (2.01%) Jenkins
6 10 (1.83%) Git (software)
7 9 (1.65%) Vagrant
8 8 (1.46%) SQL Server Management Studio (SSMS)
9 7 (1.28%) Cucumber
9 7 (1.28%) git-flow
10 6 (1.10%) MagicDraw
11 5 (0.91%) Maven
12 3 (0.55%) PowerDesigner
13 2 (0.37%) JUnit
13 2 (0.37%) Oracle Forms
13 2 (0.37%) Subversion
13 2 (0.37%) TeamCity
13 2 (0.37%) TestNG
General
1 133 (24.31%) Finance
2 35 (6.40%) Banking
3 27 (4.94%) Advertising
4 22 (4.02%) Legal
4 22 (4.02%) Manufacturing
4 22 (4.02%) Retail
5 12 (2.19%) Investment Banking
6 11 (2.01%) Games
6 11 (2.01%) Marketing
7 7 (1.28%) Telecoms
8 6 (1.10%) Financial Institution
9 5 (0.91%) Back Office
10 4 (0.73%) Automotive
10 4 (0.73%) Billing
10 4 (0.73%) General Ledger
10 4 (0.73%) German Language
10 4 (0.73%) Publishing
10 4 (0.73%) Spanish Language
11 3 (0.55%) Music Industry
12 2 (0.37%) Law
Job Titles
1 280 (51.19%) Developer
2 168 (30.71%) Business Intelligence Developer
3 81 (14.81%) SQL Developer
4 75 (13.71%) Analyst
5 74 (13.53%) DBA
6 65 (11.88%) Senior Developer
7 59 (10.79%) SSIS Developer
8 53 (9.69%) ETL Developer
9 51 (9.32%) SQL DBA
10 50 (9.14%) Architect
11 38 (6.95%) SSRS Developer
12 37 (6.76%) SQL BI Developer
13 36 (6.58%) SSAS Developer
14 35 (6.40%) Business Intelligence Analyst
15 34 (6.22%) Administrator
16 33 (6.03%) SQL Server DBA
17 31 (5.67%) Business Developer
18 29 (5.30%) Consultant
19 27 (4.94%) Data Warehouse Developer
20 26 (4.75%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 113 (20.66%) MDX
2 85 (15.54%) .NET
3 45 (8.23%) XML
4 33 (6.03%) Web Services
5 24 (4.39%) Middleware
6 20 (3.66%) JSON
7 15 (2.74%) Oracle GoldenGate
7 15 (2.74%) REST
8 14 (2.56%) HTML
9 13 (2.38%) ASP.NET
10 10 (1.83%) Akka
11 8 (1.46%) SOAP
11 8 (1.46%) Spring
12 7 (1.28%) .NET Framework
12 7 (1.28%) jQuery
13 5 (0.91%) D3.js
14 4 (0.73%) CSS
14 4 (0.73%) XML Schema
15 3 (0.55%) J2EE
15 3 (0.55%) WSDL
Miscellaneous
1 76 (13.89%) Analytical Skills
2 53 (9.69%) Data Integration
3 49 (8.96%) Visualisation
4 46 (8.41%) Management Information System
5 41 (7.50%) Replication
6 28 (5.12%) Statistics
7 26 (4.75%) Clustering
8 20 (3.66%) Computer Science
9 15 (2.74%) Fintech
10 11 (2.01%) Data Extraction
11 9 (1.65%) Physics
12 8 (1.46%) Mathematics
13 7 (1.28%) Mobile App
14 6 (1.10%) Economics
14 6 (1.10%) NHS
14 6 (1.10%) Reference Data
15 4 (0.73%) Data Structures
15 4 (0.73%) Derivative
15 4 (0.73%) Ontologies
15 4 (0.73%) Taxonomies
Operating Systems
1 63 (11.52%) Windows
2 46 (8.41%) Linux
3 19 (3.47%) Solaris
3 19 (3.47%) Unix
4 12 (2.19%) Windows Server
5 11 (2.01%) Windows Server 2008
6 10 (1.83%) Windows Server 2012
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 374 (68.37%) Business Intelligence
2 261 (47.71%) ETL
3 181 (33.09%) Agile Software Development
4 125 (22.85%) Data Modelling
5 102 (18.65%) Performance Tuning
6 100 (18.28%) Analytics
7 98 (17.92%) Kimball Methodology
8 72 (13.16%) Scrum
9 62 (11.33%) Dimensional Modelling
10 46 (8.41%) Time Management
11 37 (6.76%) Data Visualisation
12 35 (6.40%) Data Management
13 34 (6.22%) Migration
14 33 (6.03%) Project Management
15 32 (5.85%) SDLC
16 31 (5.67%) Disaster Recovery
16 31 (5.67%) Kanban
17 29 (5.30%) Mentoring
18 28 (5.12%) Logical Data Model
19 26 (4.75%) Data Analytics
Programming Languages
1 428 (78.24%) SQL
2 217 (39.67%) T-SQL
3 60 (10.97%) C#
4 48 (8.78%) Data Analysis Expressions (DAX)
4 48 (8.78%) PL/SQL
5 45 (8.23%) Java
6 23 (4.20%) PowerShell
7 22 (4.02%) JavaScript
8 19 (3.47%) Python
9 16 (2.93%) R
10 14 (2.56%) Shell Script
11 12 (2.19%) Scala
11 12 (2.19%) VBA
12 9 (1.65%) C
12 9 (1.65%) VB.NET
13 6 (1.10%) PHP
14 5 (0.91%) C++
15 4 (0.73%) Perl
16 3 (0.55%) Data Mining Extensions (DMX)
16 3 (0.55%) XMLA
Qualifications
1 55 (10.05%) Degree
2 35 (6.40%) Microsoft Certification
3 15 (2.74%) MCITP
4 14 (2.56%) SC Cleared
4 14 (2.56%) Security Cleared
5 9 (1.65%) MCSE
6 3 (0.55%) CIMA
7 2 (0.37%) MCTS
8 1 (0.18%) ACCA
8 1 (0.18%) Postgraduate
8 1 (0.18%) PRINCE2 Certification
Quality Assurance & Compliance
1 38 (6.95%) Data Quality
2 18 (3.29%) QA
3 12 (2.19%) SLA
4 5 (0.91%) ISO20022
5 3 (0.55%) PCI DSS
6 1 (0.18%) Basel III
6 1 (0.18%) Dodd-Frank
6 1 (0.18%) HIPAA
6 1 (0.18%) ISO/IEC 27001
6 1 (0.18%) SSAE 16
System Software
1 22 (4.02%) Oracle RAC
1 22 (4.02%) VMware Infrastructure
2 19 (3.47%) Hyper-V
2 19 (3.47%) KVM
2 19 (3.47%) NFS
2 19 (3.47%) SRDF
2 19 (3.47%) Xen
3 10 (1.83%) HDFS
4 7 (1.28%) Active Directory
5 3 (0.55%) Apache Flume
5 3 (0.55%) Virtual Machines
6 2 (0.37%) Apache ZooKeeper
6 2 (0.37%) Firmware
6 2 (0.37%) VMware ESX
6 2 (0.37%) vSphere
7 1 (0.18%) Docker
7 1 (0.18%) VMware ESXi
Systems Management
1 22 (4.02%) Puppet
2 7 (1.28%) Microsoft Clustering
3 4 (0.73%) Oozie
4 3 (0.55%) Enterprise Manager Cloud Control
4 3 (0.55%) Oracle Enterprise Manager
4 3 (0.55%) Oracle RMAN
5 2 (0.37%) Hadoop YARN
5 2 (0.37%) ITRS Geneos
6 1 (0.18%) Kibana
6 1 (0.18%) WSUS
Vendors
1 266 (48.63%) Microsoft
2 139 (25.41%) Oracle
3 84 (15.36%) Tableau
4 56 (10.24%) Cognos
5 33 (6.03%) IBM
6 29 (5.30%) VMware
7 25 (4.57%) Talend
8 23 (4.20%) Cisco
9 21 (3.84%) EMC
9 21 (3.84%) NetApp
10 19 (3.47%) Intel
11 15 (2.74%) SAP
12 13 (2.38%) Google
13 12 (2.19%) Informatica
13 12 (2.19%) Splunk
14 11 (2.01%) Computacenter
15 10 (1.83%) Actian
16 8 (1.46%) MicroStrategy
16 8 (1.46%) SolarWinds
17 6 (1.10%) Hyperion
Greater Manchester
Nigel Frank International
Salary: £60000 - £70000 per annum + company bonus and benefits
Posted: 2 days ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: Yesterday
Birmingham, West Midlands (County)
Harvey Nash plc
Salary: £30000 - £35000 per annum + Package
Posted: 2 days ago
London
onezeero.
Salary: £70000 - £80000 per annum + benefits
Posted: 2 days ago
Coventry
Nigel Frank International
Salary: £26 - £26000 per annum + Family Health care, car allowance,
Posted: 3 days ago
West Yorkshire
Rullion IT Plus
Salary: £60000 - £80000 per annum + Bonus + Pension + Health
Posted: Yesterday
Solihull, West Midlands (County)
Modis International
Salary: £30000.00 - £36000.00 per annum + Benefits package
Posted: 3 days ago
London
HFG
Salary: £40000 - £60000 per annum, Benefits + bonus + benefits
Posted: 4 days ago
Bury St. Edmunds, Suffolk
Proactive Appointments
Salary: £40000 - £46000 per annum + great benefits
Posted: 3 days ago
Greater Manchester
Verticality Ltd
Salary: £34k-£38k DOE + Bonus + Benefits
Posted: 4 days ago
Bristol, Avon
Redrock Consulting Ltd
Salary: £60000 - £80000 per annum + Great Benefits/Home Working
Posted: 3 days ago
Rugby
Nigel Frank International
Salary: £22000 - £28000 per annum + company benefits
Posted: 5 days ago
City, London
I3
Salary: £55000 - £70000 per annum + benefits + bonus
Posted: 4 days ago
Liverpool, Merseyside
Oho Group Ltd.
Salary: £40000 - £45000 per annum
Posted: 4 days ago
Milton Keynes, Buckinghamshire
Robert Walters
Salary: £80000 - £94000 per annum + 10% Bonus, Car Allowance
Posted: Yesterday
Surrey
Venturi
Salary: £50000 - £60000 per annum + company benefits
Posted: 5 days ago
West Midlands
Austin Fraser
Salary: £40000.00 - £50000 per annum + Benefits
Posted: 4 days ago
Cambridgeshire
Lawrence Harvey Enterprise
Salary: £35000.00 - £50000.00 per annum
Posted: 6 days ago
Manchester, Lancashire
Jagger Talent
Salary: From £25,000 to £30,000 per annum upto 30K + Benefits
Posted: 3 days ago
West Malling, Kent
Anthony James Consulting
Salary: From £60,000 to £70,000 per annum
Posted: 3 days ago
Folkestone
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 11 days ago
London
Premier IT
Salary: £45000 - £60000 per annum
Posted: 5 days ago
Ipswich
Nigel Frank International
Salary: £35000 - £50000 per annum
Posted: 13 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + stock options
Posted: 3 days ago
City, London
Henderson Drake
Salary: From £34,000 to £40,000 per annum Bonus + Pension + Healthcare + Holid
Posted: 5 days ago
Hampshire
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £50000.00 per annum + bens
Posted: 17 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 11 days ago
City, London
ANSON MCCADE
Salary: £45,000 - £70,000 + extensive benefits package
Posted: 4 days ago
London
Lawrence Harvey
Salary: £50000 - £55000 per annum + Benefits
Posted: 19 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 9 days ago