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

Location
3 months to
13 Feb 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 558 524 408
Rank change year-on-year
-34 -116
Permanent jobs citing OLAP 405 490 734
As % of all permanent IT jobs located in the UK 0.40% 0.47% 0.70%
As % of the Database & Business Intelligence category 1.28% 1.51% 2.13%
Number of salaries quoted 332 396 606
Average salary £52,500 £50,000 £50,000
Average salary % change year-on-year
+5.00% -
90% offered a salary of more than £36,100 £34,750 £32,500
10% offered a salary of more than £70,000 £75,000 £70,000
UK excluding London average salary £43,000 £40,000 £40,000
% change year-on-year
+7.50% -

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
31749 32557 34481
As % of all permanent IT jobs located in the UK 31.67% 31.02% 32.67%
Number of salaries quoted 26906 27945 29142
Average salary £47,500 £45,000 £45,000
Average salary % change year-on-year
+5.55% -
90% offered a salary of more than £32,500 £31,000 £30,000
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+6.25% -

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 13 February 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 average salaries quoted in IT jobs citing OLAP within the UK over the 3 months to 13 February 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
(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 -37 369 £52,500 +5.00% 69
London -42 187 £57,500 -8.00% 38
South East +18 53 £50,000 - 9
City of London +59 49 £55,000 -21.42% 8
Yorkshire +41 48 £42,500 +6.25% 5
West Yorkshire +39 44 £42,500 +6.25% 2
Leeds +35 36 £40,000 - 2
North West +18 27 £45,000 +28.57% 7
West Midlands -20 21 £43,000 +14.66% 3
Manchester +16 17 £45,000 +32.35% 5
Wales +6 16 £37,500 +2.73% 2
South Wales -1 16 £37,500 +2.73% 2
Surrey +20 15 £55,000 +14.58% 1
East of England -6 14 £60,000 +9.09% 3
Egham - 14 £55,000 - 1
Cardiff -5 12 £38,000 +2.70% 1
Berkshire -2 11 £45,000 -25.00%
East Midlands +5 10 £52,500 +45.83% 3
Kent - 10 £37,500 -
Edinburgh +15 9 £42,500 -19.04% 6
Scotland +3 9 £42,500 -19.04% 8
Hertfordshire +2 9 £57,500 +21.05% 1
Birmingham -1 7 £35,000 -23.91%
South West -35 7 £38,750 -3.12% 1
Hampshire +24 6 £46,250 +15.62%
Bracknell +2 6 £40,000 -
Bristol -8 6 £37,500 -6.25% 1
Cheshire +22 5 £40,000 +14.28%
Reading +4 5 £50,000 -32.20%
Bradford 0 5 £65,000 +36.84%

OLAP
Top 30 Related IT Skills

For the 6 months to 13 February 2016, 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 716 (73.21%) SQL
2 701 (71.68%) Business Intelligence
3 641 (65.54%) SQL Server
4 596 (60.94%) SQL Server Integration Services
5 577 (59.00%) SQL Server Analysis Services
6 553 (56.54%) Data Warehouse
7 532 (54.40%) SQL Server Reporting Services
8 478 (48.88%) ETL
9 399 (40.80%) Microsoft
10 338 (34.56%) T-SQL
11 324 (33.13%) OLAP Cube
12 294 (30.06%) Finance
13 246 (25.15%) MS Excel
13 246 (25.15%) Agile Software Development
14 233 (23.82%) MDX
15 226 (23.11%) SQL Server 2008
16 224 (22.90%) Data Modelling
17 185 (18.92%) OLTP
18 180 (18.40%) SQL Server 2012
19 170 (17.38%) Analytics
20 167 (17.08%) Oracle
21 164 (16.77%) Oracle OLAP
22 161 (16.46%) Kimball Methodology
23 154 (15.75%) Relational Database
24 145 (14.83%) Analytical Skills
25 137 (14.01%) .NET
26 125 (12.78%) Performance Tuning
27 117 (11.96%) Tableau
28 116 (11.86%) C#
29 100 (10.22%) SharePoint

OLAP
Top Related IT Skills by Category

For the 6 months to 13 February 2016, 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 100 (10.22%) SharePoint
2 69 (7.06%) SAS
3 14 (1.43%) Apache Spark
3 14 (1.43%) BizTalk Server
3 14 (1.43%) Tomcat
4 13 (1.33%) SharePoint 2013
5 12 (1.23%) GemFire
6 11 (1.12%) IIS
7 10 (1.02%) Confluence
8 9 (0.92%) JBoss
8 9 (0.92%) SharePoint 2010
9 5 (0.51%) Apache
9 5 (0.51%) Node.js
10 4 (0.41%) Oracle Workflow
10 4 (0.41%) SharePoint Server
11 3 (0.31%) CMS
11 3 (0.31%) Drupal
11 3 (0.31%) Joomla!
11 3 (0.31%) Oracle Spatial
11 3 (0.31%) WordPress
Applications
1 246 (25.15%) MS Excel
2 30 (3.07%) MS Office
3 26 (2.66%) MS Visio
4 8 (0.82%) SPSS
5 1 (0.10%) MS PowerPoint
Business Applications
1 19 (1.94%) Dynamics AX
2 14 (1.43%) Cognos Business Intelligence
3 11 (1.12%) Cognos TM1
3 11 (1.12%) HFM
4 10 (1.02%) Cognos Controller
5 8 (0.82%) Dynamics NAV
6 7 (0.72%) Dynamics CRM
7 4 (0.41%) Hyperion Planning
7 4 (0.41%) SAP Oil and Gas
8 2 (0.20%) Cerner Millennium
9 1 (0.10%) JDE OneWorld
9 1 (0.10%) Oracle EBS
9 1 (0.10%) Oracle Financials
9 1 (0.10%) SAP BPC
9 1 (0.10%) Unica
Cloud Services
1 55 (5.62%) Microsoft Azure
2 19 (1.94%) Amazon AWS
3 12 (1.23%) Office 365
4 7 (0.72%) Cloud Computing
5 6 (0.61%) Azure Machine Learning
5 6 (0.61%) IaaS
5 6 (0.61%) PaaS
6 4 (0.41%) SaaS
7 3 (0.31%) GitHub
Communications & Networking
1 10 (1.02%) LAN
1 10 (1.02%) WAN
2 7 (0.72%) Extranet
2 7 (0.72%) Internet
2 7 (0.72%) Intranet
3 5 (0.51%) HTTP
4 4 (0.41%) TCP/IP
5 2 (0.20%) Firewall
6 1 (0.10%) GPRS
6 1 (0.10%) RTP
6 1 (0.10%) SAN
Database & Business Intelligence
1 641 (65.54%) SQL Server
2 596 (60.94%) SQL Server Integration Services
3 577 (59.00%) SQL Server Analysis Services
4 553 (56.54%) Data Warehouse
5 532 (54.40%) SQL Server Reporting Services
6 324 (33.13%) OLAP Cube
7 226 (23.11%) SQL Server 2008
8 185 (18.92%) OLTP
9 180 (18.40%) SQL Server 2012
10 164 (16.77%) Oracle OLAP
11 154 (15.75%) Relational Database
12 90 (9.20%) Microsoft Analysis Services
13 88 (9.00%) Data Mining
14 82 (8.38%) SQL Server 2014
15 72 (7.36%) QlikView
15 72 (7.36%) RDBMS
16 69 (7.06%) Hadoop
16 69 (7.06%) SQL Server 2005
17 60 (6.13%) PowerPivot
18 57 (5.83%) Power BI
Development Applications
1 32 (3.27%) Team Foundation Server
2 25 (2.56%) Git (software)
3 20 (2.04%) Maven
3 20 (2.04%) Visual Studio
4 15 (1.53%) JIRA
5 13 (1.33%) ERwin
6 12 (1.23%) Jenkins
7 11 (1.12%) PowerDesigner
8 8 (0.82%) SQL Server Management Studio (SSMS)
9 7 (0.72%) Visual Studio Tools for Office
10 6 (0.61%) Eclipse
10 6 (0.61%) Oracle Forms
10 6 (0.61%) Subversion
10 6 (0.61%) Talend Open Studio
11 5 (0.51%) JUnit
12 4 (0.41%) VSS/SourceSafe
13 3 (0.31%) Toad
General
1 294 (30.06%) Finance
2 76 (7.77%) Retail
3 63 (6.44%) Banking
4 54 (5.52%) Marketing
5 40 (4.09%) Investment Banking
6 37 (3.78%) Legal
7 35 (3.58%) Games
8 24 (2.45%) Telecoms
9 16 (1.64%) Financial Institution
10 15 (1.53%) Front Office
11 11 (1.12%) Advertising
12 8 (0.82%) Manufacturing
13 7 (0.72%) Publishing
14 4 (0.41%) Electronics
14 4 (0.41%) Pharmaceutical
15 3 (0.31%) Law
16 2 (0.20%) Back Office
17 1 (0.10%) Billing
17 1 (0.10%) General Ledger
17 1 (0.10%) Military
Job Titles
1 589 (60.22%) Developer
2 352 (35.99%) Business Intelligence Developer
3 257 (26.28%) SQL Developer
4 151 (15.44%) SQL BI Developer
5 134 (13.70%) Senior Developer
6 125 (12.78%) Analyst
7 117 (11.96%) DBA
8 103 (10.53%) Business Developer
9 93 (9.51%) SQL Server Developer
10 74 (7.57%) Consultant
11 70 (7.16%) Senior Business Intelligence Developer
12 67 (6.85%) Data Warehouse Developer
12 67 (6.85%) SQL DBA
13 66 (6.75%) SQL Server BI Developer
14 63 (6.44%) Business Intelligence Analyst
14 63 (6.44%) Senior SQL Developer
15 49 (5.01%) Architect
15 49 (5.01%) OLAP Developer
16 45 (4.60%) Microsoft BI Developer
17 44 (4.50%) Analyst Developer
Libraries, Frameworks & Software Standards
1 233 (23.82%) MDX
2 137 (14.01%) .NET
3 61 (6.24%) XML
4 36 (3.68%) HTML
5 32 (3.27%) Web Services
6 28 (2.86%) Oracle GoldenGate
7 22 (2.25%) CSS
8 20 (2.04%) ASP.NET
8 20 (2.04%) Spring
9 15 (1.53%) jQuery
10 12 (1.23%) JMS
10 12 (1.23%) Spring Batch
10 12 (1.23%) Spring XD
11 11 (1.12%) SOAP
12 10 (1.02%) J2EE
12 10 (1.02%) REST
12 10 (1.02%) RESTful
13 9 (0.92%) Ext JS
13 9 (0.92%) J2SE
13 9 (0.92%) XSL
Miscellaneous
1 145 (14.83%) Analytical Skills
2 66 (6.75%) Replication
3 64 (6.54%) Visualisation
4 54 (5.52%) Data Integration
5 43 (4.40%) Computer Science
6 42 (4.29%) Management Information System
7 39 (3.99%) Mathematics
8 37 (3.78%) Statistics
9 36 (3.68%) Credit Risk
10 34 (3.48%) Clustering
11 25 (2.56%) Online Games
12 18 (1.84%) Equities
13 17 (1.74%) Data Extraction
14 16 (1.64%) Data Structures
14 16 (1.64%) Fixed Income
15 15 (1.53%) Data Protection Act
16 12 (1.23%) Market Risk
17 11 (1.12%) Enterprise Software
17 11 (1.12%) Neural Network
17 11 (1.12%) Reinsurance
Operating Systems
1 44 (4.50%) Linux
2 43 (4.40%) Unix
3 31 (3.17%) Windows
4 9 (0.92%) Windows Server
5 7 (0.72%) Oracle Linux
6 5 (0.51%) Windows Server 2008
6 5 (0.51%) Windows Server 2012
7 3 (0.31%) AIX
8 1 (0.10%) Android
8 1 (0.10%) Red Hat Enterprise Linux
8 1 (0.10%) Windows 7
8 1 (0.10%) zOS
Processes & Methodologies
1 701 (71.68%) Business Intelligence
2 478 (48.88%) ETL
3 246 (25.15%) Agile Software Development
4 224 (22.90%) Data Modelling
5 170 (17.38%) Analytics
6 161 (16.46%) Kimball Methodology
7 125 (12.78%) Performance Tuning
8 90 (9.20%) Dimensional Modelling
9 83 (8.49%) Data Management
10 60 (6.13%) SDLC
11 57 (5.83%) Disaster Recovery
12 53 (5.42%) E-Commerce
13 52 (5.32%) Business Analysis
14 50 (5.11%) ETL Development
15 49 (5.01%) Migration
16 48 (4.91%) Scrum
17 43 (4.40%) ITIL
18 40 (4.09%) Data Analysis
19 35 (3.58%) High Availability
19 35 (3.58%) Inmon Methodology
Programming Languages
1 716 (73.21%) SQL
2 338 (34.56%) T-SQL
3 116 (11.86%) C#
4 70 (7.16%) PL/SQL
5 65 (6.65%) Java
6 50 (5.11%) JavaScript
7 48 (4.91%) VBA
8 34 (3.48%) C
9 32 (3.27%) VB
10 26 (2.66%) VB.NET
11 22 (2.25%) R
12 21 (2.15%) Data Analysis Expressions (DAX)
13 12 (1.23%) Shell Script
14 10 (1.02%) C++
14 10 (1.02%) Python
15 8 (0.82%) Perl
16 7 (0.72%) PHP
16 7 (0.72%) PowerShell
16 7 (0.72%) SAS Macro
17 6 (0.61%) X++
Qualifications
1 91 (9.30%) Degree
2 18 (1.84%) Security Cleared
3 15 (1.53%) Microsoft Certification
4 11 (1.12%) Oracle Certification
5 9 (0.92%) ACCA
5 9 (0.92%) CIMA
6 5 (0.51%) MCDBA
7 2 (0.20%) APMP
7 2 (0.20%) IBM Certification
7 2 (0.20%) ISEB
7 2 (0.20%) MCAD
7 2 (0.20%) MCITP
7 2 (0.20%) SC Cleared
8 1 (0.10%) CIPFA
8 1 (0.10%) PhD
Quality Assurance & Compliance
1 41 (4.19%) Data Quality
2 22 (2.25%) QA
3 13 (1.33%) PCI DSS
4 6 (0.61%) Sarbanes-Oxley
4 6 (0.61%) SLA
5 3 (0.31%) COBIT
6 2 (0.20%) HL7
System Software
1 8 (0.82%) Oracle RAC
2 7 (0.72%) VMware Infrastructure
2 7 (0.72%) XenApp
3 5 (0.51%) Active Directory
4 4 (0.41%) Hyper-V
4 4 (0.41%) VMware ESX
5 3 (0.31%) Varnish
6 1 (0.10%) Docker
Systems Management
1 17 (1.74%) Data Guard
2 11 (1.12%) Oracle Enterprise Manager
3 10 (1.02%) Puppet
4 6 (0.61%) OpenView
5 5 (0.51%) SCCM
6 3 (0.31%) Oracle RMAN
7 1 (0.10%) Mesos
7 1 (0.10%) SCOM
7 1 (0.10%) SCVMM
Vendors
1 399 (40.80%) Microsoft
2 167 (17.08%) Oracle
3 117 (11.96%) Tableau
4 43 (4.40%) Cognos
5 36 (3.68%) IBM
6 30 (3.07%) SAP
7 23 (2.35%) Splunk
8 22 (2.25%) Sybase
9 19 (1.94%) Hyperion
10 17 (1.74%) Vertica
11 14 (1.43%) MicroStrategy
11 14 (1.43%) Teradata
12 13 (1.33%) Netezza
13 11 (1.12%) hybris
13 11 (1.12%) Informatica
14 10 (1.02%) Adobe
15 9 (0.92%) PTC
15 9 (0.92%) Symantec
16 8 (0.82%) Hitachi
17 7 (0.72%) Citrix
Edinburgh, Midlothian
Oho Group Ltd.
Salary: £40k - 60k per year + Benefits
Posted: 19 hours ago
Edinburgh, Midlothian
McGregor Boyall
Salary: £40000 - £50000 per annum
Posted: 19 hours ago
Central London / West End
Maclean Moore Consulting
Salary: From £40,000 to £60,000 per annum
Posted: 19 hours ago
Glasgow, Lanarkshire
Net Talent
Posted: Yesterday
London
Joseph Harry Ltd
Salary: £50000 - £65000 per annum + 10% Pension + c.25% Bonus
Posted: Yesterday
Glamorgan
TRG
Salary: Plus Excellent Benefits
Posted: Yesterday
London
SLS Services Limited
Posted: Yesterday
Leeds, West Yorkshire
Churchill Frank
Salary: £40000 - £45000 per annum + Lifestyle/Negotiable
Posted: Yesterday
Ipswich, Suffolk
Salt
Salary: £65000 - £75000 per annum + Benefits
Posted: 2 days ago
Central London / West End
Digital Vision Search Ltd
Salary: From £65,000 to £75,000 per annum + Shares + Private Healthcare
Posted: 2 days ago
London
Venturi
Salary: £25000.00 - £30000.00 per annum + bonus and benefits
Posted: 2 days ago
London
Lawrence Harvey Enterprise
Salary: £48000.00 - £53000.00 per annum + benefits
Posted: 2 days ago
Egham, Surrey
Spargonet Consulting Plc
Salary: £50000 - £60000 per annum, Benefits Excellent Company Benefits
Posted: 3 days ago
West Midlands (County)
Spargonet Consulting Plc
Salary: £50000 - £55000 per annum, Benefits Excellent Benefits
Posted: 3 days ago
York, North Yorkshire
Spring Technology
Salary: £40000.00 - £45000.00 per annum
Posted: 3 days ago
Leeds, West Yorkshire
4it Recruitment Ltd
Salary: £Excellent Salary + Benefits
Posted: 3 days ago
City, London
ANSON MCCADE
Salary: £35k - £60k plus attractive benefits and extensive career progression
Posted: 3 days ago
City, London
ANSON MCCADE
Salary: £40k - £55k plus attractive benefits
Posted: 3 days ago
Edinburgh & Lothians
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 3 days ago
Manchester, Lancashire
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 3 days ago
Central London / West End
ANSON MCCADE
Salary: £40,000 - £80,000 (Depending on Experience)
Posted: 3 days ago
Middlesex
Spring Technology
Posted: 3 days ago
Manchester, Lancashire
Vertical IT
Salary: £30000 - £37500 per annum + Excellent Benefits (listed)
Posted: 3 days ago
City, London
Hitachi Consulting UK
Salary: From £75,000 to £95,000 per annum Incl Benefits + Bonus
Posted: 4 days ago
London
Bridge Noble
Salary: £45000 - £70000 per annum + stock options
Posted: 4 days ago
London
Hitachi Consulting UK
Salary: From £35,000 to £80,000 per annum Incl Benefits + Bonus
Posted: 5 days ago
Cardiff, South Glamorgan
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: Plus Excellent Benefits
Posted: 5 days ago
Bristol, Avon
Total Recruitment Specialists Limited / TRG / Total recruitment group
Salary: Plus Excellent Benefits
Posted: 5 days ago
Nottingham, Nottinghamshire
ComputaCenter
Salary: Competitive
Posted: 11 days ago
Northampton, Northamptonshire
St Andrew's Healthcare
Salary: From £0 to £50,000 per annum
Posted: 25 days ago