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

3 months to
28 Jun 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 550 488 429
Rank change year-on-year
-62 -59
Permanent jobs citing OLAP 416 569 757
As % of all permanent IT jobs located in the UK 0.42% 0.52% 0.64%
As % of the Database & Business Intelligence category 1.41% 1.59% 1.98%
Number of salaries quoted 336 455 650
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £37,500 £32,500 £35,000
10% offered a salary of more than £70,000 £72,500 £70,000
UK excluding London median salary £47,500 £40,000 £42,562
% change year-on-year
+18.75% -6.01%

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
29487 35721 38181
As % of all permanent IT jobs located in the UK 29.97% 32.63% 32.16%
Number of salaries quoted 25153 30150 32797
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 £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

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 28 June 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 28 June 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 -56 382 £50,000 - 39
London -42 171 £60,000 - 13
West Midlands +14 53 £45,000 +12.50% 1
South East -40 47 £50,000 +25.00% 8
East of England +48 37 £47,500 +5.55% 4
City of London +36 36 £62,500 +4.16% 4
Worcestershire - 27 £47,500 -
Worcester - 27 £47,500 -
Hampshire +11 26 £45,000 +20.00% 4
Yorkshire +6 21 £65,000 +62.50% 3
Southampton +17 20 £47,500 +6.74% 3
Hertfordshire +43 19 £65,000 +44.44%
West Yorkshire +6 19 £65,000 +44.44% 2
South West +2 17 £42,500 -8.10% 2
East Midlands +6 16 £50,000 +25.00% 2
Scotland -14 15 £50,000 +17.64% 2
North West +8 14 £36,250 -9.37% 5
Surrey +36 12 £50,000 -
South Wales +14 12 £33,750 -5.59% 3
Wales +12 12 £33,750 -5.59% 3
Staffordshire -12 12 £40,000 +14.28%
Somerset - 12 £41,750 -
Burton-upon-Trent - 12 £40,000 -
Bath - 12 £41,750 -
Cardiff +9 11 £32,500 -9.09% 3
Bradford +17 10 £65,000 +26.82% 2
Edinburgh +14 10 £50,000 -4.76% 1
Leeds +10 9 £42,500 -
Berkshire -1 9 £50,000 -10.31% 1
Nottingham +13 7 £47,500 +15.15%

OLAP
Top 30 Related IT Skills

For the 6 months to 28 June 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 594 (75.29%) Business Intelligence
2 563 (71.36%) SQL
3 529 (67.05%) SQL Server
4 464 (58.81%) Data Warehouse
5 409 (51.84%) SQL Server Reporting Services
6 402 (50.95%) SQL Server Integration Services
7 394 (49.94%) SQL Server Analysis Services
8 384 (48.67%) ETL
9 324 (41.06%) Microsoft
10 266 (33.71%) OLAP Cube
11 222 (28.14%) Finance
12 214 (27.12%) T-SQL
13 212 (26.87%) Agile Software Development
14 207 (26.24%) MS Excel
15 192 (24.33%) Oracle OLAP
15 192 (24.33%) Oracle
16 186 (23.57%) SQL Server 2012
17 169 (21.42%) OLTP
18 154 (19.52%) Analytical Skills
19 144 (18.25%) MDX
20 142 (18.00%) Data Modelling
21 133 (16.86%) Kimball Methodology
22 127 (16.10%) Relational Database
23 120 (15.21%) Analytics
24 119 (15.08%) Tableau
24 119 (15.08%) SQL Server 2008
25 103 (13.05%) Performance Tuning
26 83 (10.52%) PL/SQL
27 82 (10.39%) SQL Server 2014
28 80 (10.14%) Dimensional Modelling

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 (6.97%) SharePoint
2 52 (6.59%) SAS
3 14 (1.77%) Apache
3 14 (1.77%) Tomcat
4 13 (1.65%) IIS
5 11 (1.39%) WebSphere
6 10 (1.27%) Oracle Coherence
6 10 (1.27%) Oracle HTTP Server
7 8 (1.01%) Apache Spark
8 6 (0.76%) Confluence
9 5 (0.63%) Apache Pig
9 5 (0.63%) BizTalk Server
9 5 (0.63%) Elasticsearch
9 5 (0.63%) Oracle Spatial
9 5 (0.63%) Oracle Workflow
10 4 (0.51%) SharePoint 2013
11 1 (0.13%) Blackberry Enterprise Server
11 1 (0.13%) Exchange Server 2013
11 1 (0.13%) NetWeaver
11 1 (0.13%) SharePoint 2010
Applications
1 207 (26.24%) MS Excel
2 27 (3.42%) MS Office
3 18 (2.28%) MS Visio
4 3 (0.38%) MS PowerPoint
4 3 (0.38%) SPSS
5 2 (0.25%) Spreadsheet
6 1 (0.13%) Acrobat
6 1 (0.13%) MS Project
Business Applications
1 12 (1.52%) SAP Business One
2 8 (1.01%) Cognos Business Intelligence
3 7 (0.89%) Cognos TM1
4 5 (0.63%) HFM
4 5 (0.63%) SAP BPC
4 5 (0.63%) Unica
5 4 (0.51%) Oracle Financials
6 3 (0.38%) Dynamics NAV
6 3 (0.38%) SAP Oil and Gas
7 2 (0.25%) Cognos Planning
7 2 (0.25%) Dynamics AX
7 2 (0.25%) Hyperion Planning
7 2 (0.25%) JDE OneWorld
7 2 (0.25%) Oracle EBS
8 1 (0.13%) Cognos Controller
8 1 (0.13%) Oracle Applications
8 1 (0.13%) Oracle Financial Analyzer
Cloud Services
1 46 (5.83%) Microsoft Azure
2 16 (2.03%) Amazon AWS
3 5 (0.63%) SaaS
4 2 (0.25%) Azure Machine Learning
4 2 (0.25%) IaaS
4 2 (0.25%) PaaS
5 1 (0.13%) GitHub
Communications & Networking
1 16 (2.03%) Intranet
2 14 (1.77%) Extranet
3 13 (1.65%) HTTP
3 13 (1.65%) SAN
4 12 (1.52%) LAN
4 12 (1.52%) WAN
5 10 (1.27%) FCoE
5 10 (1.27%) Fibre Channel
5 10 (1.27%) iSCSI
5 10 (1.27%) Multicast
5 10 (1.27%) NAS
6 5 (0.63%) Firewall
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
8 1 (0.13%) VoIP
Database & Business Intelligence
1 529 (67.05%) SQL Server
2 464 (58.81%) Data Warehouse
3 409 (51.84%) SQL Server Reporting Services
4 402 (50.95%) SQL Server Integration Services
5 394 (49.94%) SQL Server Analysis Services
6 266 (33.71%) OLAP Cube
7 192 (24.33%) Oracle OLAP
8 186 (23.57%) SQL Server 2012
9 169 (21.42%) OLTP
10 127 (16.10%) Relational Database
11 119 (15.08%) SQL Server 2008
12 82 (10.39%) SQL Server 2014
13 77 (9.76%) Hadoop
14 75 (9.51%) BusinessObjects
15 73 (9.25%) Big Data
16 63 (7.98%) QlikView
17 62 (7.86%) SQL Server 2005
18 60 (7.60%) Microsoft Analysis Services
19 58 (7.35%) PowerPivot
20 56 (7.10%) RDBMS
Development Applications
1 24 (3.04%) Team Foundation Server
2 18 (2.28%) Git (software)
3 17 (2.15%) Visual Studio
4 11 (1.39%) JIRA
5 9 (1.14%) Jenkins
5 9 (1.14%) SQL Server Management Studio (SSMS)
6 7 (0.89%) Eclipse
7 6 (0.76%) ERwin
8 4 (0.51%) Subversion
8 4 (0.51%) tSQLt
9 2 (0.25%) Ranorex
9 2 (0.25%) Visual Studio Tools for Office
10 1 (0.13%) JUnit
10 1 (0.13%) Maven
10 1 (0.13%) Oracle Forms
10 1 (0.13%) Talend Open Studio
General
1 222 (28.14%) Finance
2 64 (8.11%) Banking
3 50 (6.34%) Marketing
4 46 (5.83%) Retail
5 45 (5.70%) Games
6 31 (3.93%) Telecoms
7 28 (3.55%) Investment Banking
8 22 (2.79%) Legal
8 22 (2.79%) Manufacturing
9 17 (2.15%) Front Office
10 11 (1.39%) Advertising
11 8 (1.01%) Publishing
12 6 (0.76%) Back Office
13 3 (0.38%) Electronics
14 2 (0.25%) Financial Institution
14 2 (0.25%) Law
15 1 (0.13%) Automotive
15 1 (0.13%) Billing
15 1 (0.13%) Military
15 1 (0.13%) Pharmaceutical
Job Titles
1 428 (54.25%) Developer
2 264 (33.46%) Business Intelligence Developer
3 193 (24.46%) SQL Developer
4 117 (14.83%) SSAS Developer
5 104 (13.18%) SQL BI Developer
6 93 (11.79%) SSIS Developer
7 91 (11.53%) Analyst
8 90 (11.41%) SQL Server Developer
9 82 (10.39%) SSRS Developer
10 80 (10.14%) Architect
10 80 (10.14%) Consultant
11 73 (9.25%) Senior Developer
12 53 (6.72%) Business Intelligence Consultant
13 52 (6.59%) SQL Server BI Developer
14 51 (6.46%) DBA
15 47 (5.96%) Database Developer
16 44 (5.58%) Business Intelligence Lead
16 44 (5.58%) Oracle Developer
17 42 (5.32%) Business Intelligence Analyst
18 41 (5.20%) Data Architect
Libraries, Frameworks & Software Standards
1 144 (18.25%) MDX
2 70 (8.87%) .NET
3 45 (5.70%) XML
4 30 (3.80%) HTML
5 20 (2.53%) Web Services
6 15 (1.90%) Oracle GoldenGate
7 14 (1.77%) REST
8 12 (1.52%) jQuery
8 12 (1.52%) SOAP
9 11 (1.39%) Middleware
10 8 (1.01%) CSS
11 7 (0.89%) ASP.NET
11 7 (0.89%) JSON
11 7 (0.89%) WCF
12 5 (0.63%) COM
12 5 (0.63%) Django
12 5 (0.63%) WF
12 5 (0.63%) Windows Identity Foundation
12 5 (0.63%) XSL
13 4 (0.51%) D3.js
Miscellaneous
1 154 (19.52%) Analytical Skills
2 63 (7.98%) Visualisation
3 61 (7.73%) Data Integration
4 42 (5.32%) Replication
5 41 (5.20%) Enterprise Software
6 40 (5.07%) Computer Science
7 35 (4.44%) Management Information System
8 33 (4.18%) Statistics
9 26 (3.30%) Data Extraction
10 23 (2.92%) Credit Risk
11 20 (2.53%) Clustering
12 19 (2.41%) Online Games
13 15 (1.90%) Fintech
14 13 (1.65%) Mathematics
15 12 (1.52%) Data Structures
15 12 (1.52%) Economics
16 10 (1.27%) Data Protection Act
17 9 (1.14%) Data Conversion
18 6 (0.76%) Freedom of Information
19 5 (0.63%) N-Tier
Operating Systems
1 52 (6.59%) Linux
2 46 (5.83%) Windows
3 44 (5.58%) Unix
4 10 (1.27%) Oracle Linux
4 10 (1.27%) Solaris
5 6 (0.76%) Windows Server 2012
6 5 (0.63%) Windows Server
6 5 (0.63%) Windows Server 2008
7 2 (0.25%) Windows 7
8 1 (0.13%) CentOS
8 1 (0.13%) Windows Vista
Processes & Methodologies
1 594 (75.29%) Business Intelligence
2 384 (48.67%) ETL
3 212 (26.87%) Agile Software Development
4 142 (18.00%) Data Modelling
5 133 (16.86%) Kimball Methodology
6 120 (15.21%) Analytics
7 103 (13.05%) Performance Tuning
8 80 (10.14%) Dimensional Modelling
9 69 (8.75%) Business Analysis
10 64 (8.11%) Scrum
11 52 (6.59%) Data Analysis
11 52 (6.59%) Data Management
12 51 (6.46%) SDLC
13 44 (5.58%) Project Management
14 39 (4.94%) ITIL
15 37 (4.69%) Data Architecture
16 35 (4.44%) Data Analytics
17 30 (3.80%) E-Commerce
17 30 (3.80%) Migration
17 30 (3.80%) Presales
Programming Languages
1 563 (71.36%) SQL
2 214 (27.12%) T-SQL
3 83 (10.52%) PL/SQL
4 69 (8.75%) C#
5 42 (5.32%) Java
6 38 (4.82%) JavaScript
7 36 (4.56%) VBA
8 26 (3.30%) Python
9 23 (2.92%) C
10 21 (2.66%) Data Analysis Expressions (DAX)
11 14 (1.77%) Shell Script
11 14 (1.77%) VB.NET
12 12 (1.52%) PHP
13 10 (1.27%) Perl
13 10 (1.27%) PowerShell
13 10 (1.27%) R
14 9 (1.14%) C++
15 8 (1.01%) VB
16 5 (0.63%) Ruby
16 5 (0.63%) Scala
Qualifications
1 77 (9.76%) Degree
2 23 (2.92%) Microsoft Certification
3 8 (1.01%) ACCA
3 8 (1.01%) CIMA
4 7 (0.89%) MCSE
5 5 (0.63%) SC Cleared
5 5 (0.63%) Security Cleared
6 4 (0.51%) MCITP
6 4 (0.51%) MCP
6 4 (0.51%) MCSA
6 4 (0.51%) Oracle Certification
7 3 (0.38%) IBM Certification
7 3 (0.38%) MCAD
8 2 (0.25%) AAT
8 2 (0.25%) ISEB
9 1 (0.13%) CISSP
9 1 (0.13%) HND
9 1 (0.13%) ITIL Certification
9 1 (0.13%) MBA
9 1 (0.13%) MCDBA
Quality Assurance & Compliance
1 48 (6.08%) Data Quality
2 32 (4.06%) QA
3 10 (1.27%) PCI DSS
4 4 (0.51%) Basel II
5 3 (0.38%) Sarbanes-Oxley
5 3 (0.38%) SLA
System Software
1 20 (2.53%) Oracle RAC
2 12 (1.52%) VMware Infrastructure
3 11 (1.39%) KVM
4 10 (1.27%) Hyper-V
4 10 (1.27%) NFS
4 10 (1.27%) SRDF
4 10 (1.27%) Xen
5 2 (0.25%) Virtual Machines
6 1 (0.13%) Active Directory
6 1 (0.13%) Docker
6 1 (0.13%) Microsoft Virtual Server
6 1 (0.13%) Virtual Servers
6 1 (0.13%) VirtualBox
Systems Management
1 11 (1.39%) Data Guard
1 11 (1.39%) Oracle Enterprise Manager
2 5 (0.63%) Mesos
2 5 (0.63%) Microsoft Clustering
2 5 (0.63%) OpenView
3 3 (0.38%) Puppet
4 2 (0.25%) Cisco IPCC
5 1 (0.13%) ITRS Geneos
5 1 (0.13%) Oozie
Vendors
1 324 (41.06%) Microsoft
2 192 (24.33%) Oracle
3 119 (15.08%) Tableau
4 55 (6.97%) SAP
5 54 (6.84%) Cognos
6 29 (3.68%) IBM
7 26 (3.30%) Teradata
8 23 (2.92%) Netezza
9 17 (2.15%) MicroStrategy
9 17 (2.15%) VMware
10 12 (1.52%) EMC
10 12 (1.52%) Informatica
11 11 (1.39%) Cisco
11 11 (1.39%) NetApp
11 11 (1.39%) Splunk
11 11 (1.39%) Sybase
12 10 (1.27%) Intel
12 10 (1.27%) Vertica
13 9 (1.14%) Hitachi
14 8 (1.01%) Hyperion
North Yorkshire
Lawrence Harvey Enterprise
Salary: £40000 - £55000 per annum
Posted: 10 hours ago
Cardiff, South Glamorgan
Colston Consulting
Salary: £40000 per annum
Posted: 11 hours ago
Tunbridge Wells, Kent
Evolution Recruitment Solutions
Salary: 20,000 - 25,000
Posted: 9 hours ago
Glasgow, Lanarkshire
Net Talent
Posted: 8 hours ago
Liverpool, Merseyside
Search Consultancy
Salary: Benefits
Posted: 11 hours ago
City, London
ANSON MCCADE
Salary: £65,000 - £75,000
Posted: 9 hours ago
City, London
ANSON MCCADE
Salary: £50,000 - £75,000
Posted: 9 hours ago
Cardiff, South Glamorgan
Opus Recruitment Solutions Ltd
Salary: £25000 - £40000 per annum
Posted: Yesterday
City, London
ANSON MCCADE
Salary: £50,000 - £75,000
Posted: Yesterday
City, London
Searchability
Salary: £25000 - £30000 per annum + benefits
Posted: Yesterday
London
Logic Engagements Ltd
Salary: £75000 - £85000 per annum + Car allowance + bonus ++
Posted: 6 hours ago
Camborne
Recruitment Genius Ltd
Salary: £45000 - £55000 per annum
Posted: Yesterday
Cardiff, South Glamorgan
Monarch Recruitment Ltd.
Posted: 19 hours ago
Southampton, Hampshire
Go IT Recruitment Ltd
Salary: From £35,000 to £50,000 per annum + 25 days Holiday + Great career pro
Posted: Yesterday
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: Yesterday
Basingstoke
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: Yesterday
Crewe
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: Yesterday
Abingdon
Sophos
Salary: Highly Competitive + bonus & benefits
Posted: Yesterday
Milton Keynes, Buckinghamshire, United Kingdom
White Clarke Group
Salary: £28 - £42k + Excellent Benefits
Posted: 6 days ago
Newcastle Upon Tyne, Tyne and Wear
Harvey Nash plc
Salary: £35000 - £45000 per annum
Posted: 4 days ago
London
Harvey Nash plc
Salary: £80000 per annum
Posted: 6 days ago
London
Square One Resources
Salary: From £90,000 to £95,000 per annum
Posted: 6 days ago
Liverpool
Computer Futures
Salary: competitive
Posted: 7 days ago
London
NST Recruitment Limited
Salary: Benefits
Posted: Yesterday
Cambridgeshire
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, bonus etc
Posted: 11 days ago
London
Venturi
Salary: £60000.00 - £85000.00 per annum + Bonus and Benefits
Posted: 4 days ago
Edinburgh
Lawrence Harvey
Salary: £60000.00 - £70000.00 per annum + pension, bonus, health care
Posted: 11 days ago
Cambridge, Cambridgeshire
Circle Recruitment
Salary: £23000 - £33000 per annum + Benefits
Posted: 5 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 11 days ago