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

3 months to
24 May 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 574 469 458
Rank change year-on-year
-105 -11
Permanent jobs citing OLAP 384 596 709
As % of all permanent IT jobs located in the UK 0.39% 0.56% 0.60%
As % of the Database & Business Intelligence category 1.29% 1.73% 1.84%
Number of salaries quoted 304 473 577
Median salary £50,000 £51,500 £50,000
Median salary % change year-on-year
-2.91% +3.00%
90% offered a salary of more than £37,500 £32,500 £34,850
10% offered a salary of more than £70,000 £72,500 £65,000
UK excluding London median salary £45,000 £40,000 £42,500
% change year-on-year
+12.50% -5.88%

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
29874 34494 38472
As % of all permanent IT jobs located in the UK 30.31% 32.35% 32.31%
Number of salaries quoted 25504 29112 32994
Median salary £50,000 £47,000 £45,000
Median salary % change year-on-year
+6.38% +4.44%
90% offered a salary of more than £32,500 £31,500 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London median salary £42,500 £41,000 £40,000
% change year-on-year
+3.65% +2.50%

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 May 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 May 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 -88 355 £50,000 -4.76% 52
London -69 173 £60,000 -4.00% 19
West Midlands +6 42 £45,000 +12.50% 4
City of London +7 37 £60,000 - 3
South East -44 37 £50,000 +31.57% 9
Yorkshire +13 31 £42,500 +23.18% 3
East of England +31 25 £53,000 +22.54% 6
West Yorkshire +18 24 £57,500 +43.75%
Worcestershire - 22 £47,500 - 2
Worcester - 22 £47,500 - 1
Hampshire +13 20 £45,000 +12.50% 5
Leeds +20 18 £41,750 +4.37%
Hertfordshire +27 17 £65,000 +46.06% 3
East Midlands +12 17 £47,500 +18.75% 4
South West -1 15 £42,500 -5.55% 1
Southampton +10 14 £45,000 +1.12% 4
Nottingham +14 12 £42,500 +6.25%
Nottinghamshire +5 12 £42,500 +6.25%
Wales +11 11 £35,625 -5.00%
South Wales +7 11 £35,625 -5.00%
Scotland -14 11 £50,000 +17.64% 9
Somerset - 11 £42,500 - 1
Bath - 11 £42,500 - 1
Edinburgh +8 9 £50,000 -4.76% 3
Cardiff +3 9 £35,000 -6.66%
Staffordshire -1 9 £40,000 +14.28%
Berkshire -2 9 £60,000 +11.11% 2
Burton-upon-Trent - 9 £40,000 -
Slough +10 8 £60,000 +11.11%
North West -9 8 £42,500 +6.25% 5

OLAP
Top 30 Related IT Skills

For the 6 months to 24 May 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 598 (75.89%) Business Intelligence
2 562 (71.32%) SQL
3 519 (65.86%) SQL Server
4 466 (59.14%) Data Warehouse
5 425 (53.93%) SQL Server Analysis Services
6 418 (53.05%) SQL Server Integration Services
7 409 (51.90%) SQL Server Reporting Services
8 400 (50.76%) ETL
9 322 (40.86%) Microsoft
10 274 (34.77%) OLAP Cube
11 229 (29.06%) Finance
12 211 (26.78%) MS Excel
13 206 (26.14%) Agile Software Development
14 201 (25.51%) T-SQL
15 198 (25.13%) SQL Server 2012
16 190 (24.11%) Oracle
16 190 (24.11%) Oracle OLAP
17 166 (21.07%) MDX
18 152 (19.29%) Data Modelling
19 151 (19.16%) Kimball Methodology
20 147 (18.65%) OLTP
21 145 (18.40%) Analytical Skills
22 140 (17.77%) Relational Database
23 134 (17.01%) SQL Server 2008
24 125 (15.86%) Tableau
25 120 (15.23%) Analytics
26 98 (12.44%) Performance Tuning
27 96 (12.18%) PL/SQL
28 86 (10.91%) SQL Server 2014
29 80 (10.15%) 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 54 (6.85%) SAS
1 54 (6.85%) SharePoint
2 10 (1.27%) Tomcat
3 9 (1.14%) Apache
4 8 (1.02%) IIS
5 6 (0.76%) BizTalk Server
5 6 (0.76%) Confluence
5 6 (0.76%) WebSphere
6 5 (0.63%) Apache Pig
6 5 (0.63%) Apache Spark
6 5 (0.63%) Oracle Coherence
6 5 (0.63%) Oracle HTTP Server
6 5 (0.63%) Oracle Spatial
6 5 (0.63%) Oracle Workflow
7 4 (0.51%) Elasticsearch
7 4 (0.51%) Node.js
8 3 (0.38%) SharePoint 2013
9 2 (0.25%) SharePoint 2010
10 1 (0.13%) Adobe Experience Manager
10 1 (0.13%) Exchange Server 2013
Applications
1 211 (26.78%) MS Excel
2 28 (3.55%) MS Office
3 20 (2.54%) MS Visio
4 4 (0.51%) SPSS
5 2 (0.25%) MS PowerPoint
5 2 (0.25%) Spreadsheet
6 1 (0.13%) Acrobat
6 1 (0.13%) MS Project
Business Applications
1 11 (1.40%) Cognos Business Intelligence
1 11 (1.40%) Cognos TM1
2 10 (1.27%) HFM
2 10 (1.27%) SAP Business One
3 6 (0.76%) Cognos Controller
4 5 (0.63%) Oracle Financials
4 5 (0.63%) Unica
5 4 (0.51%) SAP BPC
6 3 (0.38%) SAP Oil and Gas
7 2 (0.25%) Cognos Planning
7 2 (0.25%) Dynamics AX
7 2 (0.25%) Dynamics NAV
7 2 (0.25%) Hyperion Planning
7 2 (0.25%) Oracle EBS
8 1 (0.13%) JDE OneWorld
8 1 (0.13%) Oracle Financial Analyzer
Cloud Services
1 41 (5.20%) Microsoft Azure
2 14 (1.78%) Amazon AWS
3 4 (0.51%) SaaS
4 1 (0.13%) Azure Machine Learning
4 1 (0.13%) GitHub
4 1 (0.13%) IaaS
4 1 (0.13%) Office 365
4 1 (0.13%) PaaS
Communications & Networking
1 13 (1.65%) Intranet
2 11 (1.40%) Extranet
3 7 (0.89%) LAN
3 7 (0.89%) SAN
3 7 (0.89%) WAN
4 6 (0.76%) HTTP
5 5 (0.63%) FCoE
5 5 (0.63%) Fibre Channel
5 5 (0.63%) iSCSI
5 5 (0.63%) Multicast
5 5 (0.63%) NAS
6 2 (0.25%) DHCP
6 2 (0.25%) DNS
6 2 (0.25%) TCP/IP
7 1 (0.13%) Asterisk PBX
7 1 (0.13%) Firewall
7 1 (0.13%) Network Security
7 1 (0.13%) PABX
7 1 (0.13%) VLAN
7 1 (0.13%) VoIP
Database & Business Intelligence
1 519 (65.86%) SQL Server
2 466 (59.14%) Data Warehouse
3 425 (53.93%) SQL Server Analysis Services
4 418 (53.05%) SQL Server Integration Services
5 409 (51.90%) SQL Server Reporting Services
6 274 (34.77%) OLAP Cube
7 198 (25.13%) SQL Server 2012
8 190 (24.11%) Oracle OLAP
9 147 (18.65%) OLTP
10 140 (17.77%) Relational Database
11 134 (17.01%) SQL Server 2008
12 86 (10.91%) SQL Server 2014
13 80 (10.15%) Hadoop
14 71 (9.01%) BusinessObjects
15 69 (8.76%) Big Data
15 69 (8.76%) QlikView
16 64 (8.12%) SQL Server 2005
17 62 (7.87%) RDBMS
18 57 (7.23%) Microsoft Analysis Services
19 56 (7.11%) PowerPivot
Development Applications
1 22 (2.79%) Team Foundation Server
2 20 (2.54%) Git (software)
3 11 (1.40%) Visual Studio
4 9 (1.14%) Eclipse
4 9 (1.14%) Jenkins
4 9 (1.14%) JIRA
5 8 (1.02%) SQL Server Management Studio (SSMS)
6 6 (0.76%) ERwin
7 5 (0.63%) Oracle Forms
8 4 (0.51%) Subversion
9 2 (0.25%) Maven
10 1 (0.13%) JUnit
10 1 (0.13%) Talend Open Studio
10 1 (0.13%) tSQLt
General
1 229 (29.06%) Finance
2 71 (9.01%) Banking
3 57 (7.23%) Marketing
4 49 (6.22%) Games
5 37 (4.70%) Investment Banking
6 36 (4.57%) Retail
7 25 (3.17%) Telecoms
8 22 (2.79%) Legal
9 16 (2.03%) Front Office
10 15 (1.90%) Manufacturing
11 10 (1.27%) Advertising
12 7 (0.89%) Publishing
13 6 (0.76%) Back Office
13 6 (0.76%) Financial Institution
14 5 (0.63%) Law
15 3 (0.38%) Electronics
16 1 (0.13%) Billing
16 1 (0.13%) German Language
16 1 (0.13%) Military
16 1 (0.13%) Pharmaceutical
Job Titles
1 447 (56.73%) Developer
2 275 (34.90%) Business Intelligence Developer
3 203 (25.76%) SQL Developer
4 131 (16.62%) SSAS Developer
5 114 (14.47%) SQL BI Developer
6 96 (12.18%) SSIS Developer
7 92 (11.68%) SQL Server Developer
8 90 (11.42%) SSRS Developer
9 85 (10.79%) Senior Developer
10 84 (10.66%) Analyst
11 80 (10.15%) Consultant
12 66 (8.38%) Architect
13 56 (7.11%) DBA
13 56 (7.11%) SQL Server BI Developer
14 54 (6.85%) Business Intelligence Consultant
15 52 (6.60%) Business Developer
16 50 (6.35%) Database Developer
17 49 (6.22%) Oracle Developer
18 43 (5.46%) Data Warehouse Developer
19 41 (5.20%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 166 (21.07%) MDX
2 67 (8.50%) .NET
3 50 (6.35%) XML
4 26 (3.30%) HTML
5 23 (2.92%) Web Services
6 20 (2.54%) Oracle GoldenGate
7 13 (1.65%) SOAP
8 11 (1.40%) REST
9 9 (1.14%) jQuery
10 8 (1.02%) CSS
11 7 (0.89%) JSON
11 7 (0.89%) WCF
12 6 (0.76%) Middleware
12 6 (0.76%) XSL
13 5 (0.63%) WF
13 5 (0.63%) Windows Identity Foundation
14 4 (0.51%) AngularJS
14 4 (0.51%) J2SE
14 4 (0.51%) RESTful
15 3 (0.38%) Hibernate
Miscellaneous
1 145 (18.40%) Analytical Skills
2 65 (8.25%) Data Integration
3 59 (7.49%) Visualisation
4 41 (5.20%) Replication
5 38 (4.82%) Management Information System
6 31 (3.93%) Statistics
7 30 (3.81%) Computer Science
8 28 (3.55%) Credit Risk
8 28 (3.55%) Enterprise Software
8 28 (3.55%) Online Games
9 25 (3.17%) Data Extraction
10 14 (1.78%) Economics
11 13 (1.65%) Clustering
11 13 (1.65%) Mathematics
12 10 (1.27%) Data Structures
12 10 (1.27%) Fintech
13 9 (1.14%) Data Protection Act
13 9 (1.14%) Reinsurance
14 6 (0.76%) Data Conversion
14 6 (0.76%) Freedom of Information
Operating Systems
1 49 (6.22%) Linux
2 48 (6.09%) Unix
3 28 (3.55%) Windows
4 14 (1.78%) Oracle Linux
5 5 (0.63%) Solaris
6 4 (0.51%) Windows Server 2012
7 3 (0.38%) Windows Server
7 3 (0.38%) Windows Server 2008
8 2 (0.25%) Windows 7
9 1 (0.13%) AIX
9 1 (0.13%) CentOS
9 1 (0.13%) Windows Vista
Processes & Methodologies
1 598 (75.89%) Business Intelligence
2 400 (50.76%) ETL
3 206 (26.14%) Agile Software Development
4 152 (19.29%) Data Modelling
5 151 (19.16%) Kimball Methodology
6 120 (15.23%) Analytics
7 98 (12.44%) Performance Tuning
8 80 (10.15%) Dimensional Modelling
9 68 (8.63%) Business Analysis
10 58 (7.36%) Scrum
11 55 (6.98%) Data Management
12 52 (6.60%) SDLC
13 45 (5.71%) Data Analysis
14 37 (4.70%) Project Management
15 36 (4.57%) E-Commerce
15 36 (4.57%) ITIL
16 33 (4.19%) ETL Development
17 32 (4.06%) Data Architecture
17 32 (4.06%) Translating Business Requirements
18 31 (3.93%) Presales
Programming Languages
1 562 (71.32%) SQL
2 201 (25.51%) T-SQL
3 96 (12.18%) PL/SQL
4 68 (8.63%) C#
5 39 (4.95%) Java
6 33 (4.19%) JavaScript
7 32 (4.06%) VBA
8 26 (3.30%) C
9 22 (2.79%) Data Analysis Expressions (DAX)
9 22 (2.79%) Python
10 17 (2.16%) Shell Script
11 12 (1.52%) VB
12 10 (1.27%) PHP
12 10 (1.27%) VB.NET
13 9 (1.14%) C++
14 8 (1.02%) R
15 7 (0.89%) Perl
15 7 (0.89%) SAS Macro
16 5 (0.63%) PowerShell
16 5 (0.63%) Ruby
Qualifications
1 63 (7.99%) Degree
2 18 (2.28%) Microsoft Certification
3 12 (1.52%) ACCA
3 12 (1.52%) CIMA
4 7 (0.89%) Security Cleared
5 5 (0.63%) SC Cleared
6 4 (0.51%) MCAD
6 4 (0.51%) MCITP
7 3 (0.38%) IBM Certification
8 2 (0.25%) AAT
8 2 (0.25%) ISEB
8 2 (0.25%) Oracle Certification
9 1 (0.13%) CIPFA
9 1 (0.13%) HND
9 1 (0.13%) ITIL Certification
9 1 (0.13%) MBA
9 1 (0.13%) MCDBA
9 1 (0.13%) MCP
9 1 (0.13%) MCSA
9 1 (0.13%) MCSE
Quality Assurance & Compliance
1 51 (6.47%) Data Quality
2 28 (3.55%) QA
3 8 (1.02%) PCI DSS
4 6 (0.76%) Sarbanes-Oxley
5 4 (0.51%) Basel II
5 4 (0.51%) SLA
6 1 (0.13%) COBIT
System Software
1 19 (2.41%) Oracle RAC
2 7 (0.89%) VMware Infrastructure
3 6 (0.76%) KVM
4 5 (0.63%) Hyper-V
4 5 (0.63%) NFS
4 5 (0.63%) SRDF
4 5 (0.63%) Xen
5 1 (0.13%) Active Directory
5 1 (0.13%) Docker
5 1 (0.13%) Microsoft Virtual Server
5 1 (0.13%) Varnish
5 1 (0.13%) VirtualBox
Systems Management
1 16 (2.03%) Data Guard
1 16 (2.03%) Oracle Enterprise Manager
2 6 (0.76%) OpenView
3 5 (0.63%) Mesos
4 3 (0.38%) Puppet
5 2 (0.25%) Cisco IPCC
6 1 (0.13%) Oracle RMAN
Vendors
1 322 (40.86%) Microsoft
2 190 (24.11%) Oracle
3 125 (15.86%) Tableau
4 54 (6.85%) SAP
5 52 (6.60%) Cognos
6 28 (3.55%) IBM
7 24 (3.05%) Teradata
8 21 (2.66%) Netezza
9 20 (2.54%) Splunk
10 18 (2.28%) MicroStrategy
11 15 (1.90%) Hyperion
12 13 (1.65%) Vertica
13 12 (1.52%) Hitachi
14 10 (1.27%) Sybase
15 8 (1.02%) Actuate
15 8 (1.02%) Informatica
15 8 (1.02%) VMware
16 7 (0.89%) EMC
17 6 (0.76%) Cisco
17 6 (0.76%) NetApp
London
ninesharp
Salary: £55000 - £65000 per annum + Bonus, Pension, Healthcare
Posted: 9 hours ago
London
Computer Futures
Salary: competitive
Posted: 10 hours ago
South East London
Think IT Recruitment
Salary: £40000 - £50000 per annum + benefits
Posted: 21 hours ago
London
Harvey Nash plc
Salary: £80000 per annum
Posted: Yesterday
Glasgow, Lanarkshire
Cognizant
Posted: Yesterday
Woking, Surrey
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: Yesterday
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: Yesterday
Bedfordshire
Zorba Consulting Limited
Salary: £40k - 48k per year
Posted: Yesterday
Southampton, Hampshire
Spectrum IT Recruitment (South) Ltd
Salary: £45000 - £55000 per annum + benefits
Posted: Yesterday
Leicestershire
Vivid Resourcing
Posted: Yesterday
Broxbourne, Hertfordshire
Understanding Recruitment
Salary: £55000.00 - £65000.00 per annum + benefits
Posted: 2 days ago
Edinburgh, Midlothian
Churchill Frank
Salary: £45000 - £50000 per annum + Negotiable
Posted: 3 days ago
Bath, Avon
Reed Technology
Salary: £36000 - £46000 per annum
Posted: 4 days ago
Northampton, Northamptonshire
Venturi
Salary: £45000 - £55000 per annum + Benefits
Posted: 4 days ago
London
Vivid Resourcing
Salary: £60 - £65 per annum + benefits
Posted: 4 days ago
Northamptonshire
Fruition IT Resources Limited
Salary: £45000.00 - £55000 per annum + Benefits
Posted: 5 days ago
London
Joseph Harry Ltd
Salary: £45000 - £60000 per annum + 10% Pension + c.25% Bonus
Posted: 5 days ago
Sheffield
Churchill Frank International
Salary: £40000 - £45000 per annum + Lifestyle/Negotiable
Posted: 5 days ago
Glasgow, Lanarkshire
FPSG Connect
Salary: Pension, Healthcare, Bonus etc.
Posted: 6 days ago
Luton
Ortolan Group
Salary: £40000 - £46000 per annum
Posted: 6 days ago
London
Lorien Resourcing
Salary: Excellent benefits
Posted: 6 days ago
Reading, Berkshire
Venturi
Salary: £45000 - £55000.00 per annum + 30% bonus + full bens
Posted: 6 days ago
Hampshire
Send
Posted: 6 days ago
Guildford, Surrey
Allianz
Salary: £60,000 - £80,000 per year plus excellent benefits
Posted: 6 days ago
Central London / West End
ANSON MCCADE
Salary: £55,000 - £60,000 plus benefits
Posted: 6 days ago
Watford
Vivid Resourcing
Posted: 7 days ago
Southampton, Hampshire
Red Funnel
Salary: From £35,000 to £38,000 per annum
Posted: 8 days ago
London
Vivid Resourcing
Posted: 8 days ago
City Of London
HFG
Salary: £50000 - £55000 per annum, Benefits: Bonus + Corp Bens.
Posted: 8 days ago
Edinburgh
Churchill Frank International
Salary: £40000 - £45000 per annum + Negotiable
Posted: 13 days ago
Southampton
Deerfoot IT Resources Ltd
Salary: £50000 per annum
Posted: 14 days ago
Sheffield
Computer Futures
Salary: competitive
Posted: 19 days ago
Teddington
Ortolan Group
Posted: 19 days ago
York
Computer Futures
Salary: competitive
Posted: 19 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 19 days ago
West Midlands
Huxley
Salary: £40000 - £50000 per annum + Benefits
Posted: 20 days ago
Worcestershire
Huxley
Salary: competitive
Posted: 20 days ago
Glasgow
Vivid Resourcing
Posted: 21 days ago
West Midlands
Real Staffing
Salary: £35000 - £45000 per annum + competitive
Posted: 21 days ago
Worcester
Vivid Resourcing
Salary: £44k - 46k per year
Posted: 26 days ago