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

3 months to
24 Aug 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 578 511 410
Rank change year-on-year
-67 -101
Permanent jobs citing OLAP 358 533 777
As % of all permanent IT jobs located in the UK 0.37% 0.48% 0.67%
As % of the Database & Business Intelligence category 1.23% 1.56% 2.11%
Number of salaries quoted 300 408 660
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £37,500 £34,000 £35,000
10% offered a salary of more than £80,000 £72,500 £72,500
UK excluding London median salary £47,500 £42,500 £45,000
% change year-on-year
+11.76% -5.55%

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
29022 34213 36838
As % of all permanent IT jobs located in the UK 29.68% 31.13% 31.86%
Number of salaries quoted 24789 28838 31061
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 £68,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 24 August 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 August 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 -73 322 £50,000 - 25
London -47 143 £65,000 +13.04% 9
South East -22 72 £50,000 +25.00% 4
Hampshire 0 32 £45,000 +20.00% 1
Yorkshire +18 28 £45,000 - 1
Southampton +17 24 £50,000 - 1
West Yorkshire +14 23 £45,000 - 1
Scotland +15 21 £55,000 +15.78% 1
North West +8 20 £35,000 -10.25% 2
City of London +30 19 £80,000 +33.33%
East of England +29 19 £44,000 -2.22% 2
Surrey +30 17 £60,000 +33.33% 1
Berkshire +7 16 £52,500 +31.25%
Edinburgh +25 15 £55,000 +15.78%
South West +5 15 £45,500 -15.34% 2
Leeds +19 12 £45,000 +12.50%
West Midlands -25 12 £41,250 +3.12% 2
Bradford +5 11 £80,000 +56.09% 1
Merseyside -1 10 £35,000 -10.25%
Liverpool -7 10 £35,000 -
Slough +24 9 £55,000 +1.85%
South Wales +20 9 £36,250 +6.61%
Cambridgeshire +18 9 £47,500 +26.66%
East Midlands +12 9 £50,000 +17.64% 2
Wales +7 9 £36,250 +6.61%
Cardiff +15 8 £35,000 +2.94%
Cornwall - 7 £50,000 - 2
Camborne - 7 £50,000 - 2
Guildford - 7 £70,000 -
Bedfordshire +23 6 £44,000 -39.31%

OLAP
Top 30 Related IT Skills

For the 6 months to 24 August 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 540 (72.78%) SQL
2 539 (72.64%) Business Intelligence
3 518 (69.81%) SQL Server
4 426 (57.41%) Data Warehouse
5 340 (45.82%) SQL Server Reporting Services
6 329 (44.34%) ETL
7 323 (43.53%) SQL Server Integration Services
8 321 (43.26%) SQL Server Analysis Services
9 303 (40.84%) Microsoft
10 246 (33.15%) T-SQL
11 237 (31.94%) OLAP Cube
12 224 (30.19%) Finance
13 204 (27.49%) Agile Software Development
14 199 (26.82%) MS Excel
15 184 (24.80%) OLTP
16 179 (24.12%) Oracle
16 179 (24.12%) Oracle OLAP
17 156 (21.02%) SQL Server 2012
18 147 (19.81%) Analytical Skills
19 133 (17.92%) Tableau
20 128 (17.25%) MDX
21 122 (16.44%) Data Modelling
22 119 (16.04%) Performance Tuning
23 118 (15.90%) Analytics
24 111 (14.96%) Kimball Methodology
25 102 (13.75%) Big Data
26 98 (13.21%) Relational Database
27 96 (12.94%) Hadoop
28 89 (11.99%) SQL Server 2008
29 81 (10.92%) 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 58 (7.82%) SAS
2 46 (6.20%) SharePoint
3 22 (2.96%) Apache
4 21 (2.83%) Apache Spark
4 21 (2.83%) IIS
5 20 (2.70%) Tomcat
6 17 (2.29%) Oracle Coherence
6 17 (2.29%) WebSphere
7 16 (2.16%) Oracle HTTP Server
8 6 (0.81%) Elasticsearch
9 5 (0.67%) Apache Pig
10 4 (0.54%) Oracle Spatial
10 4 (0.54%) Oracle Workflow
11 2 (0.27%) NetWeaver
11 2 (0.27%) Oracle 10gAS
11 2 (0.27%) Oracle Application Server
11 2 (0.27%) SharePoint 2013
12 1 (0.13%) Blackberry Enterprise Server
12 1 (0.13%) Exchange Server 2013
12 1 (0.13%) MS Exchange
Applications
1 199 (26.82%) MS Excel
2 12 (1.62%) MS Office
3 4 (0.54%) Gephi
3 4 (0.54%) MS Visio
3 4 (0.54%) SPSS
4 3 (0.40%) MS PowerPoint
5 2 (0.27%) Spreadsheet
6 1 (0.13%) Acrobat
6 1 (0.13%) MS Project
Business Applications
1 16 (2.16%) Cognos Business Intelligence
2 14 (1.89%) Cognos TM1
3 12 (1.62%) SAP Business One
4 11 (1.48%) Oracle EBS
5 9 (1.21%) Cognos Controller
6 6 (0.81%) Dynamics NAV
7 5 (0.67%) SAP BPC
8 4 (0.54%) Oracle Financials
8 4 (0.54%) Unica
9 3 (0.40%) Dynamics AX
9 3 (0.40%) SAP Oil and Gas
10 2 (0.27%) Cognos Planning
10 2 (0.27%) HFM
10 2 (0.27%) Infor M3
10 2 (0.27%) Magento
11 1 (0.13%) Hyperion Planning
11 1 (0.13%) JDE EnterpriseOne
11 1 (0.13%) JDE OneWorld
11 1 (0.13%) Oracle Applications
11 1 (0.13%) Oracle Financial Analyzer
Cloud Services
1 47 (6.33%) Microsoft Azure
2 16 (2.16%) Amazon AWS
3 7 (0.94%) Azure Machine Learning
3 7 (0.94%) Data Lake Analytics
3 7 (0.94%) IaaS
3 7 (0.94%) PaaS
4 5 (0.67%) SaaS
5 2 (0.27%) GitHub
Communications & Networking
1 27 (3.64%) SAN
2 20 (2.70%) LAN
2 20 (2.70%) WAN
3 19 (2.56%) Intranet
4 18 (2.43%) HTTP
5 16 (2.16%) FCoE
5 16 (2.16%) Fibre Channel
5 16 (2.16%) iSCSI
5 16 (2.16%) Multicast
5 16 (2.16%) NAS
6 15 (2.02%) Extranet
7 10 (1.35%) Firewall
8 3 (0.40%) PBX
9 2 (0.27%) DHCP
9 2 (0.27%) DNS
9 2 (0.27%) Skype
9 2 (0.27%) TCP/IP
10 1 (0.13%) Asterisk PBX
10 1 (0.13%) PABX
10 1 (0.13%) Remote Desktop
Database & Business Intelligence
1 518 (69.81%) SQL Server
2 426 (57.41%) Data Warehouse
3 340 (45.82%) SQL Server Reporting Services
4 323 (43.53%) SQL Server Integration Services
5 321 (43.26%) SQL Server Analysis Services
6 237 (31.94%) OLAP Cube
7 184 (24.80%) OLTP
8 179 (24.12%) Oracle OLAP
9 156 (21.02%) SQL Server 2012
10 102 (13.75%) Big Data
11 98 (13.21%) Relational Database
12 96 (12.94%) Hadoop
13 89 (11.99%) SQL Server 2008
14 79 (10.65%) SQL Server 2014
15 74 (9.97%) Microsoft Analysis Services
16 66 (8.89%) QlikView
17 52 (7.01%) Power BI
18 48 (6.47%) BusinessObjects
19 44 (5.93%) PowerPivot
20 43 (5.80%) SQL Server 2016
Development Applications
1 26 (3.50%) Visual Studio
2 24 (3.23%) Team Foundation Server
3 13 (1.75%) SQL Server Management Studio (SSMS)
4 9 (1.21%) JIRA
5 7 (0.94%) Git (software)
5 7 (0.94%) Visual Studio Tools for Office
6 6 (0.81%) tSQLt
7 5 (0.67%) Subversion
8 4 (0.54%) ERwin
9 3 (0.40%) Eclipse
9 3 (0.40%) Maven
10 2 (0.27%) MorphX
10 2 (0.27%) Oracle Forms
10 2 (0.27%) PVCS
10 2 (0.27%) Ranorex
10 2 (0.27%) Visual Studio Team System
11 1 (0.13%) Gradle
11 1 (0.13%) Jenkins
11 1 (0.13%) Talend Open Studio
11 1 (0.13%) TeamCity
General
1 224 (30.19%) Finance
2 65 (8.76%) Banking
3 57 (7.68%) Retail
4 40 (5.39%) Games
5 35 (4.72%) Manufacturing
5 35 (4.72%) Telecoms
6 32 (4.31%) Marketing
7 24 (3.23%) Legal
8 19 (2.56%) Front Office
8 19 (2.56%) Investment Banking
9 12 (1.62%) Advertising
10 11 (1.48%) Publishing
11 7 (0.94%) Back Office
12 4 (0.54%) Electronics
13 3 (0.40%) Law
14 2 (0.27%) Financial Institution
15 1 (0.13%) Automotive
15 1 (0.13%) Billing
15 1 (0.13%) German Language
Job Titles
1 380 (51.21%) Developer
2 239 (32.21%) Business Intelligence Developer
3 144 (19.41%) SQL Developer
4 101 (13.61%) Architect
5 73 (9.84%) SQL BI Developer
6 70 (9.43%) SQL Server Developer
7 66 (8.89%) SSAS Developer
8 65 (8.76%) Analyst
9 63 (8.49%) SSIS Developer
10 62 (8.36%) Data Architect
10 62 (8.36%) DBA
11 60 (8.09%) Consultant
12 56 (7.55%) Senior Developer
13 48 (6.47%) SQL DBA
14 43 (5.80%) SSRS Developer
15 39 (5.26%) Business Intelligence Consultant
16 36 (4.85%) ETL Developer
17 34 (4.58%) SQL Server BI Developer
18 31 (4.18%) Oracle Developer
19 30 (4.04%) Database Developer
Libraries, Frameworks & Software Standards
1 128 (17.25%) MDX
2 49 (6.60%) .NET
3 33 (4.45%) XML
4 27 (3.64%) REST
5 26 (3.50%) Web Services
6 21 (2.83%) HTML
7 17 (2.29%) Middleware
8 15 (2.02%) JSON
9 13 (1.75%) D3.js
10 12 (1.62%) jQuery
11 11 (1.48%) HTML5
11 11 (1.48%) Oracle GoldenGate
12 9 (1.21%) ASP.NET
12 9 (1.21%) CSS
12 9 (1.21%) SOAP
13 7 (0.94%) Leaflet
13 7 (0.94%) WCF
14 6 (0.81%) Django
14 6 (0.81%) RESTful
15 4 (0.54%) WF
Miscellaneous
1 147 (19.81%) Analytical Skills
2 74 (9.97%) Visualisation
3 52 (7.01%) Data Integration
4 46 (6.20%) Enterprise Software
5 45 (6.06%) Computer Science
6 39 (5.26%) Replication
7 28 (3.77%) Clustering
7 28 (3.77%) Statistics
8 25 (3.37%) Data Extraction
8 25 (3.37%) Management Information System
9 16 (2.16%) Fintech
10 14 (1.89%) Credit Risk
11 13 (1.75%) Mathematics
12 11 (1.48%) Neural Network
13 10 (1.35%) Data Conversion
13 10 (1.35%) Online Games
14 8 (1.08%) Data Structures
14 8 (1.08%) Economics
15 7 (0.94%) Data Protection Act
15 7 (0.94%) Mobile App
Operating Systems
1 73 (9.84%) Windows
2 62 (8.36%) Linux
3 36 (4.85%) Unix
4 16 (2.16%) Solaris
5 13 (1.75%) Windows Server
6 7 (0.94%) Oracle Linux
7 5 (0.67%) Windows Server 2008
7 5 (0.67%) Windows Server 2012
8 1 (0.13%) CentOS
8 1 (0.13%) Windows 7
8 1 (0.13%) Windows Vista
Processes & Methodologies
1 539 (72.64%) Business Intelligence
2 329 (44.34%) ETL
3 204 (27.49%) Agile Software Development
4 122 (16.44%) Data Modelling
5 119 (16.04%) Performance Tuning
6 118 (15.90%) Analytics
7 111 (14.96%) Kimball Methodology
8 75 (10.11%) Scrum
9 66 (8.89%) Dimensional Modelling
10 62 (8.36%) Project Management
11 58 (7.82%) Data Management
12 53 (7.14%) Business Analysis
13 52 (7.01%) Data Architecture
14 51 (6.87%) SDLC
15 50 (6.74%) Data Analysis
16 48 (6.47%) Data Analytics
17 41 (5.53%) Data Governance
18 38 (5.12%) Migration
19 32 (4.31%) Disaster Recovery
20 30 (4.04%) Data Visualisation
Programming Languages
1 540 (72.78%) SQL
2 246 (33.15%) T-SQL
3 57 (7.68%) C#
4 51 (6.87%) PL/SQL
5 50 (6.74%) Java
6 37 (4.99%) JavaScript
7 36 (4.85%) Python
8 35 (4.72%) Data Analysis Expressions (DAX)
9 21 (2.83%) VBA
10 19 (2.56%) Shell Script
11 18 (2.43%) R
12 17 (2.29%) PowerShell
13 16 (2.16%) C
13 16 (2.16%) Perl
14 15 (2.02%) VB.NET
15 14 (1.89%) PHP
16 9 (1.21%) Scala
17 5 (0.67%) C++
17 5 (0.67%) VB
18 3 (0.40%) SAS Macro
Qualifications
1 81 (10.92%) Degree
2 27 (3.64%) Microsoft Certification
3 10 (1.35%) MCSE
4 6 (0.81%) MCITP
4 6 (0.81%) MCP
4 6 (0.81%) MCSA
4 6 (0.81%) SC Cleared
4 6 (0.81%) Security Cleared
5 4 (0.54%) ACCA
5 4 (0.54%) CIMA
6 3 (0.40%) IBM Certification
6 3 (0.40%) ISEB
7 2 (0.27%) AAT
7 2 (0.27%) Oracle Certification
7 2 (0.27%) PRINCE2 Certification
8 1 (0.13%) CISSP
8 1 (0.13%) HND
8 1 (0.13%) ITIL Certification
8 1 (0.13%) MBA
8 1 (0.13%) MCAD
Quality Assurance & Compliance
1 37 (4.99%) QA
2 34 (4.58%) Data Quality
3 3 (0.40%) SLA
4 2 (0.27%) Basel II
4 2 (0.27%) PCI DSS
System Software
1 23 (3.10%) Oracle RAC
1 23 (3.10%) VMware Infrastructure
2 17 (2.29%) KVM
3 16 (2.16%) Hyper-V
3 16 (2.16%) NFS
3 16 (2.16%) SRDF
3 16 (2.16%) Xen
4 12 (1.62%) Virtual Machines
5 5 (0.67%) VMware ESX
5 5 (0.67%) vSphere
6 2 (0.27%) Apache Flume
6 2 (0.27%) HDFS
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 11 (1.48%) Microsoft Clustering
2 8 (1.08%) Oracle Enterprise Manager
3 7 (0.94%) Data Guard
4 4 (0.54%) Mesos
5 3 (0.40%) Oozie
6 2 (0.27%) Cisco IPCC
6 2 (0.27%) ITRS Geneos
Vendors
1 303 (40.84%) Microsoft
2 179 (24.12%) Oracle
3 133 (17.92%) Tableau
4 63 (8.49%) Cognos
5 44 (5.93%) SAP
6 43 (5.80%) IBM
7 34 (4.58%) VMware
8 22 (2.96%) NetApp
9 20 (2.70%) Informatica
10 19 (2.56%) Teradata
11 18 (2.43%) EMC
12 17 (2.29%) Cisco
13 16 (2.16%) Intel
14 15 (2.02%) MicroStrategy
15 14 (1.89%) Netezza
16 10 (1.35%) Sybase
17 8 (1.08%) Actuate
18 6 (0.81%) Alteryx
18 6 (0.81%) Vertica
19 5 (0.67%) Splunk
Tunbridge Wells, Kent
Evolution Recruitment Solutions
Salary: 20,000 - 25,000
Posted: 44 minutes ago
Hertfordshire
Nigel Frank International Ltd
Salary: £53000 - £62000 per annum
Posted: Yesterday
Solihull, West Midlands (County)
Rullion IT Plus
Salary: £275 - £320 per day
Posted: Yesterday
London
Lawrence Harvey Enterprise
Salary: £50000.00 - £85000.00 per annum + bonus + benefits
Posted: 1 hour ago
Surrey
Lawrence Harvey Enterprise
Salary: £55000.00 - £60000.00 per annum + pension, bonus, flexi-working
Posted: Yesterday
Camborne, Cornwall
Tank Recruitment Limited
Salary: benifits
Posted: Yesterday
Oxford, Oxfordshire
X4 Group
Salary: £30k - 40k per year
Posted: 4 days ago
Bradford, West Yorkshire
Modis International
Salary: £35000 - £45000 per annum + Benefits
Posted: 5 days ago
Clitheroe, Lancashire
Modis International
Salary: £35000 - £45000 per annum + Benefits
Posted: 5 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: Yesterday
Leicester, Leicestershire
Rullion IT Plus
Salary: £45000 - £50000 per annum + Benefits
Posted: 5 days ago
Newcastle-under-Lyme
KDR Recruitment
Salary: £40000 - £60000 per annum + Benefits
Posted: 7 days ago
Manchester
Arrow Global
Salary: £40k - 60k per year
Posted: 6 days ago
Nottingham
Computacenter
Salary: Competitive
Posted: 6 days ago
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: 6 days ago
Camborne
Hays Specialist Recruitment Ltd
Salary: £45000.00 - £55000.00 per annum + Relocation + Home working
Posted: 15 days ago
London
Eames Consulting
Salary: £50000 - £60000 per annum + Benefits
Posted: 6 days ago
London
Accenture
Posted: 6 days ago
London
Lawrence Harvey
Salary: £55000.00 - £65000.00 per annum + bonus, pension, health care
Posted: 22 days ago
Sutton, London UK
Reed Business Information
Salary: Competitive Salary + bonus + benefits
Posted: 8 days ago
Royston, Hertfordshire
Hotel Chocolat
Salary: From £45,000 to £55,000 per annum + bens
Posted: 8 days ago
Warwick
Computer Futures
Salary: competitive
Posted: 20 days ago