The table below looks at the statistics for OLAP skills in IT jobs advertised across the UK. Included is a guide to the average salaries offered in IT jobs that have cited OLAP over the 3 months to 5 May 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
5 May 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 430 422 344
Rank change year-on-year
-8 -78
Permanent jobs citing OLAP 613 707 811
As % of all permanent IT jobs located in the UK 0.56% 0.59% 0.74%
As % of the Database & Business Intelligence category 1.78% 1.88% 2.30%
Number of salaries quoted 470 560 685
Average salary £52,500 £47,500 £50,000
Average salary % change year-on-year
+10.52% -5.00%
90% offered a salary of more than £34,000 £32,500 £35,000
10% offered a salary of more than £72,500 £65,000 £70,000
UK excluding London average salary £40,000 £42,250 £45,000
% change year-on-year
-5.32% -6.11%

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
34407 37704 35301
As % of all permanent IT jobs located in the UK 31.15% 31.44% 32.00%
Number of salaries quoted 29074 32113 30526
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £31,500 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £67,500
UK excluding London average salary £41,000 £40,000 £39,000
% change year-on-year
+2.50% +2.56%

OLAP
Jobs Demand Trend

This chart provides the 3-month moving total of permanent IT jobs citing OLAP within the UK as a proportion of the total demand within 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 5 May 2015 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 average salaries quoted in IT jobs citing OLAP within the UK over the 3 months to 5 May 2015. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Average Salary
Last 3 Months
Average Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England -4 574 £54,000 +13.68% 100
London -7 309 £62,500 +19.04% 42
South East -7 95 £40,000 -14.89% 17
City of London +35 81 £62,500 +19.04% 17
North West -15 42 £40,000 +18.51% 9
South West +13 34 £55,000 +29.41% 8
Berkshire 0 27 £61,000 +43.52% 5
Yorkshire +5 26 £32,500 -7.14% 15
Manchester +2 26 £40,000 +14.28% 4
West Midlands -37 22 £40,000 +6.66% 5
East of England +6 20 £43,250 +8.12% 3
Gloucestershire - 20 £62,500 -
Cheltenham - 19 £62,500 -
Scotland +9 18 £44,250 -11.50% 1
West Yorkshire +28 16 £40,000 +6.66% 10
West Sussex +10 15 £44,250 -41.00%
East Midlands -1 15 £40,000 -3.61%
Cheshire -2 14 £40,750 +25.38% 4
Kent 0 11 £32,500 -31.57% 1
Bedfordshire +23 10 £62,500 +42.85% 1
Oxfordshire +14 10 £40,000 -11.11% 1
Buckinghamshire +2 10 £47,500 - 4
Bracknell +2 10 - - 1
Maidstone +32 9 £32,500 - 1
Stirling +6 9 - -
Staffordshire 0 9 £40,000 -9.09%
Bradford -9 9 £40,500 +15.71%
Warrington +17 8 £41,500 -2.35%
Oxford +12 8 £39,000 -13.33% 1
Cambridgeshire +12 8 £37,500 -5.06% 1

OLAP
Top 30 Related IT Skills

For the 6 months to 5 May 2015, IT jobs within the UK citing OLAP also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP.

1 833 (76.42%) Business Intelligence
2 735 (67.43%) SQL
3 673 (61.74%) SQL Server
4 629 (57.71%) Data Warehouse
5 625 (57.34%) ETL
6 568 (52.11%) SQL Server Integration Services
7 520 (47.71%) SQL Server Reporting Services
8 500 (45.87%) SQL Server Analysis Services
9 408 (37.43%) Microsoft
10 347 (31.83%) Finance
11 344 (31.56%) Oracle
12 333 (30.55%) OLAP Cube
13 320 (29.36%) T-SQL
13 320 (29.36%) Oracle OLAP
14 314 (28.81%) Data Modelling
15 234 (21.47%) Analytical Skills
16 232 (21.28%) SQL Server 2008
17 223 (20.46%) Agile Software Development
18 214 (19.63%) MS Excel
19 213 (19.54%) Analytics
20 192 (17.61%) Degree
21 167 (15.32%) Oracle Database
22 165 (15.14%) MDX
23 150 (13.76%) OLTP
24 148 (13.58%) Relational Database
25 142 (13.03%) SQL Server 2012
26 137 (12.57%) Kimball Methodology
27 136 (12.48%) SharePoint
28 135 (12.39%) Performance Tuning
29 130 (11.93%) C#

OLAP
Top Related IT Skills by Category

For the 6 months to 5 May 2015, IT jobs within the UK citing OLAP also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited OLAP. Up to 20 skills are shown per category.

Application Platforms
1 136 (12.48%) SharePoint
2 74 (6.79%) SAS
3 32 (2.94%) WebLogic
4 28 (2.57%) Tomcat
5 27 (2.48%) SharePoint 2010
6 25 (2.29%) IIS
7 21 (1.93%) BizTalk Server
8 17 (1.56%) Apache
9 11 (1.01%) Oracle Coherence
10 10 (0.92%) ColdFusion
11 9 (0.83%) JBoss
11 9 (0.83%) CMS
11 9 (0.83%) OpenCms
11 9 (0.83%) Drupal
11 9 (0.83%) WebSphere
11 9 (0.83%) Oracle Workflow
11 9 (0.83%) SharePoint 2013
12 7 (0.64%) Oracle HTTP Server
13 6 (0.55%) Apache Spark
14 4 (0.37%) Apache Solr
Applications
1 214 (19.63%) MS Excel
2 60 (5.50%) PowerPivot
3 29 (2.66%) SPSS
4 22 (2.02%) MS Office
5 16 (1.47%) MS Visio
6 10 (0.92%) MS Project
7 2 (0.18%) MS PowerPoint
8 1 (0.092%) FastStats
8 1 (0.092%) Spreadsheet
Business Applications
1 38 (3.49%) Cognos TM1
2 28 (2.57%) Cognos Business Intelligence
3 27 (2.48%) Oracle ERP
4 26 (2.39%) Dynamics CRM
5 21 (1.93%) Oracle EBS
5 21 (1.93%) HFM
6 13 (1.19%) Oracle EBS R12
7 12 (1.10%) Hyperion Planning
8 9 (0.83%) RMDS
9 7 (0.64%) Dynamics NAV
10 6 (0.55%) Oracle Applications
11 4 (0.37%) Oracle Financials
12 2 (0.18%) Oracle Procure-to-Pay
12 2 (0.18%) ION MarketView
12 2 (0.18%) Cognos Planning
12 2 (0.18%) Unica
12 2 (0.18%) WebTrends
13 1 (0.092%) SAP FI
13 1 (0.092%) SAP Oil and Gas
13 1 (0.092%) Cognos Controller
Cloud Services
1 10 (0.92%) Amazon AWS
2 9 (0.83%) Microsoft Azure
3 6 (0.55%) Office 365
3 6 (0.55%) Cloud Computing
4 3 (0.28%) SaaS
5 2 (0.18%) Adobe Analytics
5 2 (0.18%) SmartFocus
5 2 (0.18%) Google Analytics
6 1 (0.092%) Amazon EC2
6 1 (0.092%) Amazon S3
Communications & Networking
1 16 (1.47%) SAN
2 13 (1.19%) NAS
3 11 (1.01%) HTTP
4 8 (0.73%) DNS
5 7 (0.64%) LAN
5 7 (0.64%) WAN
5 7 (0.64%) Multicast
5 7 (0.64%) FCoE
5 7 (0.64%) Fibre Channel
6 5 (0.46%) TCP/IP
6 5 (0.46%) Internet
7 4 (0.37%) WebEx
7 4 (0.37%) LDAP
8 3 (0.28%) Intranet
8 3 (0.28%) iSCSI
9 1 (0.092%) DAB
Database & Business Intelligence
1 673 (61.74%) SQL Server
2 629 (57.71%) Data Warehouse
3 568 (52.11%) SQL Server Integration Services
4 520 (47.71%) SQL Server Reporting Services
5 500 (45.87%) SQL Server Analysis Services
6 333 (30.55%) OLAP Cube
7 320 (29.36%) Oracle OLAP
8 232 (21.28%) SQL Server 2008
9 167 (15.32%) Oracle Database
10 150 (13.76%) OLTP
11 148 (13.58%) Relational Database
12 142 (13.03%) SQL Server 2012
13 120 (11.01%) Data Mining
14 112 (10.28%) QlikView
15 100 (9.17%) Oracle BI EE
16 96 (8.81%) Big Data
17 89 (8.17%) Microsoft Analysis Services
18 79 (7.25%) Hadoop
19 78 (7.16%) Oracle Reports
20 70 (6.42%) Oracle Database 11g
Development Applications
1 41 (3.76%) Team Foundation Server
2 24 (2.20%) Toad
3 20 (1.83%) PowerDesigner
4 16 (1.47%) Oracle Forms
5 14 (1.28%) Subversion
6 11 (1.01%) Maven
7 10 (0.92%) Talend Open Studio
7 10 (0.92%) Git (software)
8 8 (0.73%) ERwin
9 7 (0.64%) Visual Studio
10 4 (0.37%) SQL Server Management Studio (SSMS)
10 4 (0.37%) VSS/SourceSafe
11 3 (0.28%) JIRA
11 3 (0.28%) TeamCity
11 3 (0.28%) MSBuild
12 2 (0.18%) Ant
13 1 (0.092%) JUnit
13 1 (0.092%) Eclipse
13 1 (0.092%) ClearCase
13 1 (0.092%) ClearQuest
General
1 347 (31.83%) Finance
2 91 (8.35%) Banking
3 63 (5.78%) Retail
4 60 (5.50%) Marketing
5 32 (2.94%) Front Office
6 19 (1.74%) Telecoms
7 18 (1.65%) Investment Banking
7 18 (1.65%) Games
8 17 (1.56%) Legal
9 15 (1.38%) Advertising
10 11 (1.01%) Law
11 10 (0.92%) General Ledger
12 9 (0.83%) Financial Institution
12 9 (0.83%) Back Office
13 8 (0.73%) Retail Banking
13 8 (0.73%) Manufacturing
14 5 (0.46%) Billing
15 4 (0.37%) Pharmaceutical
15 4 (0.37%) Automotive
16 2 (0.18%) Publishing
Job Titles
1 534 (48.99%) Developer
2 265 (24.31%) Business Intelligence Developer
3 179 (16.42%) Consultant
4 158 (14.50%) Analyst
5 133 (12.20%) Business Intelligence Consultant
6 101 (9.27%) Senior Developer
7 100 (9.17%) Business Developer
8 96 (8.81%) Architect
9 79 (7.25%) SQL Developer
10 78 (7.16%) DBA
11 66 (6.06%) Business Intelligence Analyst
12 60 (5.50%) Business Consultant
13 56 (5.14%) Microsoft Consultant
14 54 (4.95%) Microsoft BI Consultant
15 52 (4.77%) SQL DBA
16 50 (4.59%) Business Analyst
17 47 (4.31%) Analyst Developer
18 46 (4.22%) Oracle Developer
19 39 (3.58%) Solutions Architect
20 36 (3.30%) MI Analyst
Libraries, Frameworks & Software Standards
1 165 (15.14%) MDX
2 119 (10.92%) .NET
3 83 (7.61%) XML
4 55 (5.05%) HTML
5 51 (4.68%) Web Services
6 42 (3.85%) ASP.NET
7 33 (3.03%) CSS
8 31 (2.84%) HTML5
9 25 (2.29%) Hibernate
10 24 (2.20%) ASP.NET MVC
11 22 (2.02%) Ajax
12 20 (1.83%) Oracle GoldenGate
12 20 (1.83%) Spring
13 19 (1.74%) jQuery
14 18 (1.65%) WCF
15 16 (1.47%) XSLT
16 15 (1.38%) LINQ
16 15 (1.38%) JPA
17 14 (1.28%) WSDL
18 13 (1.19%) Middleware
Miscellaneous
1 234 (21.47%) Analytical Skills
2 93 (8.53%) Visualisation
3 84 (7.71%) Computer Science
4 81 (7.43%) Data Integration
5 68 (6.24%) Replication
6 67 (6.15%) Data Structures
7 63 (5.78%) Management Information System
8 37 (3.39%) Mathematics
9 34 (3.12%) Statistics
10 32 (2.94%) Clustering
11 26 (2.39%) Data Conversion
12 21 (1.93%) Enterprise Software
13 19 (1.74%) Open Source
14 16 (1.47%) Hedge funds
15 15 (1.38%) Oracle Exalogic
16 14 (1.28%) Data Extraction
16 14 (1.28%) Economics
17 10 (0.92%) Oracle Exalytics
17 10 (0.92%) Reference Data
17 10 (0.92%) N-Tier
Operating Systems
1 85 (7.80%) UNIX
2 71 (6.51%) Windows
3 67 (6.15%) Linux
4 11 (1.01%) Android
5 7 (0.64%) Solaris
5 7 (0.64%) Windows Server 2008
6 4 (0.37%) Apple iOS
7 2 (0.18%) Windows Server 2012
8 1 (0.092%) Windows NT
8 1 (0.092%) Windows XP
Processes & Methodologies
1 833 (76.42%) Business Intelligence
2 625 (57.34%) ETL
3 314 (28.81%) Data Modelling
4 223 (20.46%) Agile Software Development
5 213 (19.54%) Analytics
6 137 (12.57%) Kimball Methodology
7 135 (12.39%) Performance Tuning
8 94 (8.62%) Project Management
9 84 (7.71%) ERP
10 83 (7.61%) Scrum
11 79 (7.25%) Data Architecture
11 79 (7.25%) Data Analysis
12 72 (6.61%) Data Management
13 70 (6.42%) CRM
14 67 (6.15%) Dimensional Modelling
15 60 (5.50%) E-Commerce
16 48 (4.40%) Information Management
16 48 (4.40%) Data Cleansing
17 47 (4.31%) Stakeholder Management
17 47 (4.31%) OO
Programming Languages
1 735 (67.43%) SQL
2 320 (29.36%) T-SQL
3 130 (11.93%) C#
4 120 (11.01%) PL/SQL
5 108 (9.91%) Java
6 55 (5.05%) JavaScript
7 52 (4.77%) Shell Script
8 46 (4.22%) VBA
9 29 (2.66%) PowerShell
10 28 (2.57%) R
11 20 (1.83%) VB.NET
12 18 (1.65%) VB
13 10 (0.92%) Python
13 10 (0.92%) ActionScript
13 10 (0.92%) C
14 5 (0.46%) Data Analysis Expressions (DAX)
15 4 (0.37%) MATLAB
15 4 (0.37%) Perl
16 2 (0.18%) Data Mining Extensions (DMX)
16 2 (0.18%) C++
Qualifications
1 192 (17.61%) Degree
2 35 (3.21%) Microsoft Certification
3 28 (2.57%) Security Cleared
4 22 (2.02%) SC Cleared
5 16 (1.47%) OCP
5 16 (1.47%) Oracle Certification
6 15 (1.38%) MCDBA
7 12 (1.10%) MCITP
8 10 (0.92%) IBM Certification
9 9 (0.83%) MCP
10 7 (0.64%) MCSE
10 7 (0.64%) MCSD
11 6 (0.55%) PMI Certification
12 4 (0.37%) HND
13 3 (0.28%) PMP
14 2 (0.18%) MBA
14 2 (0.18%) PhD
15 1 (0.092%) MCAD
Quality Assurance & Compliance
1 29 (2.66%) QA
2 13 (1.19%) Data Quality
3 9 (0.83%) ISO 9001
4 8 (0.73%) SLA
5 7 (0.64%) Solvency II
6 5 (0.46%) ISO/IEC 27001
7 3 (0.28%) Sarbanes-Oxley
7 3 (0.28%) PCI DSS
8 2 (0.18%) COBIT
8 2 (0.18%) ISO 14001
8 2 (0.18%) GxP
8 2 (0.18%) GAMP
System Software
1 20 (1.83%) Oracle RAC
2 11 (1.01%) VMware Infrastructure
3 9 (0.83%) Varnish
4 7 (0.64%) NFS
4 7 (0.64%) SRDF
5 5 (0.46%) Active Directory
6 3 (0.28%) Xen
6 3 (0.28%) VMware ESX
6 3 (0.28%) Hyper-V
6 3 (0.28%) KVM
7 1 (0.092%) HDFS
Systems Management
1 4 (0.37%) Data Guard
2 3 (0.28%) SCCM
3 2 (0.18%) Oracle RMAN
Vendors
1 408 (37.43%) Microsoft
2 344 (31.56%) Oracle
3 128 (11.74%) Tableau
4 119 (10.92%) Business Objects
5 115 (10.55%) Informatica
6 113 (10.37%) Cognos
7 105 (9.63%) SAP
8 76 (6.97%) IBM
9 67 (6.15%) Hyperion
10 54 (4.95%) Teradata
11 43 (3.94%) MicroStrategy
12 37 (3.39%) Ab Initio
13 36 (3.30%) Sybase
14 25 (2.29%) Hitachi
15 22 (2.02%) Netezza
16 19 (1.74%) Vertica
17 18 (1.65%) DataFlux
18 11 (1.01%) Siebel
18 11 (1.01%) VMware
19 10 (0.92%) Talend
Bristol, Avon
Churchill Frank
Salary: £35000 - £40000 per annum + Bonus + Pension + Benefits
Posted: 23 hours ago
London
PwC
Salary: Competitive + Benefits
Posted: Yesterday
London
PwC
Salary: Competitive + Benefits
Posted: Yesterday
West Midlands (County)
Spargonet Consulting Plc
Salary: £50000 per annum, Benefits Excellent Company Benefits
Posted: Yesterday
London
Exposed Solutions
Salary: £55000 - £65000 per annum
Posted: 2 days ago
London
Westbourne Partners
Salary: From £45,000 to £55,000 per annum
Posted: 2 days ago
London
Westbourne Partners
Salary: From £70,000 to £80,000 per annum plus bonus and benefits
Posted: 2 days ago
Cardiff, South Glamorgan
Randstad Technologies
Salary: £35000.00 - £40000.00 per annum
Posted: 3 days ago
Leeds, West Yorkshire
CoreCom Consulting
Salary: £35000 - £45000 per annum + Benefits
Posted: 3 days ago
Leeds, West Yorkshire
4it Recruitment Ltd
Salary: From £35,000 to £45,000 per annum plus excellent additional benefits
Posted: 3 days ago
City, London
Miller Maxwell Ltd
Salary: From £35,000 to £55,000 per annum +Bonus +Benefits
Posted: 3 days ago
City, London
Miller Maxwell Ltd
Salary: From £60,000 to £80,000 per annum +Bonus +Benefits
Posted: 3 days ago
London
Consulting Point
Salary: £55000 - £65000 per annum + Benefits + Bonus
Posted: 3 days ago
City, London
Nigel Frank International Ltd
Salary: £50000 - £60000 per annum
Posted: 3 days ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £30000 - £50000 per annum + Benefits
Posted: 3 days ago
Birmingham, West Midlands (County)
Nigel Frank International Ltd
Salary: £30000 - £45000 per annum + Training & Benefits
Posted: 3 days ago
London
Arrows Group
Salary: £50000.00 - £60000.00 per annum
Posted: 3 days ago
Maidstone, Kent
Proactive Appointments
Salary: From £30,000 to £35,000 per annum
Posted: 4 days ago
City, London
Lewis Paige
Salary: £45000 - £55000 per annum
Posted: 4 days ago
Wiltshire
Nigel Frank International Ltd
Salary: £35000 - £38000 per annum + Bonus
Posted: 4 days ago