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 30 January 2015 with a comparison to the same period in the previous 2 years.

Location
3 months to
30 Jan 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 478 350 338
Rank change year-on-year
-128 -12
Permanent jobs citing OLAP 475 772 837
As % of all permanent IT jobs located in the UK 0.45% 0.75% 0.77%
As % of the Database & Business Intelligence category 1.50% 2.37% 2.31%
Number of salaries quoted 393 646 754
Average salary £50,000 £50,000 £48,000
Average salary % change year-on-year
- +4.16%
90% offered a salary of more than £34,000 £35,000 £35,000
10% offered a salary of more than £74,500 £70,000 £67,500
UK excluding London average salary £40,000 £40,000 £45,000
% change year-on-year
- -11.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
31731 32609 36157
As % of all permanent IT jobs located in the UK 29.97% 31.79% 33.05%
Number of salaries quoted 27291 27655 32143
Average salary £45,000 £45,000 £42,500
Average salary % change year-on-year
- +5.88%
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%

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 30 January 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 30 January 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 -119 445 £50,000 - 101
London -76 270 £60,000 +9.09% 46
City of London -15 58 £68,750 +19.56% 17
North West -9 42 £35,000 -12.50% 11
South East -65 34 £55,000 +10.00% 8
South West -10 31 £40,000 -1.23% 8
Manchester -5 27 £34,000 -20.00% 6
East of England -41 25 £47,500 +26.66% 5
Yorkshire -26 18 £40,000 +1.26% 13
Wales -3 15 £36,500 +75.90% 5
West Midlands -22 15 £35,000 -6.66% 4
South Wales -3 14 £36,500 +75.90% 3
Hertfordshire +2 12 £47,500 +46.15% 1
West Yorkshire -3 12 £43,500 +8.75% 9
Cardiff -10 11 £38,500 +85.54% 2
Berkshire -42 11 £55,000 +12.82%
Gloucestershire - 11 £70,000 - 4
Wiltshire - 11 £37,500 - 1
Cheltenham - 11 £70,000 - 2
Coventry - 10 £35,000 -
Bedfordshire +4 9 £65,000 +136.36% 2
Cheshire -10 9 £35,000 -12.50% 3
Bristol -22 9 £40,000 -2.43% 2
West Sussex +3 8 £55,000 +15.78%
Surrey -11 8 £48,750 +2.63% 1
Leeds 0 6 £40,000 +23.07% 5
East Midlands -7 6 £37,500 -6.25% 2
Docklands, London - 6 £70,000 -
Potters Bar - 6 £47,500 -
North Yorkshire +12 5 £40,000 +2.56%

OLAP
Top 30 Related IT Skills

For the 6 months to 30 January 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 817 (72.17%) Business Intelligence
2 803 (70.94%) SQL
3 730 (64.49%) SQL Server
4 665 (58.75%) Data Warehouse
5 603 (53.27%) ETL
6 594 (52.47%) SQL Server Integration Services
7 571 (50.44%) SQL Server Reporting Services
8 568 (50.18%) SQL Server Analysis Services
9 433 (38.25%) Microsoft
10 380 (33.57%) OLAP Cube
11 371 (32.77%) Finance
12 366 (32.33%) T-SQL
13 328 (28.98%) Oracle
14 326 (28.80%) Oracle OLAP
15 300 (26.50%) SQL Server 2008
16 270 (23.85%) MS Excel
17 256 (22.61%) Data Modelling
18 240 (21.20%) Analytical Skills
19 221 (19.52%) Agile Software Development
20 199 (17.58%) Degree
20 199 (17.58%) SQL Server 2012
21 187 (16.52%) SharePoint
22 186 (16.43%) .NET
23 181 (15.99%) Analytics
24 179 (15.81%) MDX
25 177 (15.64%) OLTP
26 169 (14.93%) C#
27 147 (12.99%) Business Objects
28 131 (11.57%) Microsoft Analysis Services
28 131 (11.57%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 30 January 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 187 (16.52%) SharePoint
2 80 (7.07%) SAS
3 47 (4.15%) SharePoint 2010
4 31 (2.74%) Tomcat
5 27 (2.39%) WebLogic
6 18 (1.59%) BizTalk Server
7 16 (1.41%) ColdFusion
8 12 (1.06%) WebSphere
9 11 (0.97%) Drupal
9 11 (0.97%) Oracle Coherence
9 11 (0.97%) OpenCms
9 11 (0.97%) CMS
10 9 (0.80%) Apache Spark
10 9 (0.80%) IIS
11 6 (0.53%) SharePoint Server
12 5 (0.44%) SharePoint 2013
12 5 (0.44%) JBoss
12 5 (0.44%) Apache
13 4 (0.35%) Apache Solr
14 3 (0.27%) Oracle HTTP Server
Applications
1 270 (23.85%) MS Excel
2 61 (5.39%) PowerPivot
3 54 (4.77%) MS Office
4 19 (1.68%) SPSS
5 14 (1.24%) MS Project
6 10 (0.88%) MS Visio
7 8 (0.71%) MS PowerPoint
8 1 (0.088%) FastStats
8 1 (0.088%) S-PLUS
Business Applications
1 52 (4.59%) Cognos TM1
2 40 (3.53%) Cognos Business Intelligence
3 32 (2.83%) Dynamics CRM
4 22 (1.94%) HFM
5 16 (1.41%) Hyperion Planning
6 15 (1.33%) Oracle ERP
7 13 (1.15%) Oracle EBS
8 9 (0.80%) Cognos Planning
9 5 (0.44%) Dynamics AX
10 3 (0.27%) Oracle EBS R12
10 3 (0.27%) Dynamics NAV
11 2 (0.18%) Summit
11 2 (0.18%) Oracle Financials
11 2 (0.18%) Oracle Procure-to-Pay
11 2 (0.18%) SAP BPC
11 2 (0.18%) Oracle General Ledger
11 2 (0.18%) Remedy ITSM
11 2 (0.18%) Google Analytics
12 1 (0.088%) SiteCatalyst
12 1 (0.088%) Infor M3
Cloud Services
1 9 (0.80%) Microsoft Azure
2 7 (0.62%) Office 365
3 6 (0.53%) SaaS
4 5 (0.44%) Amazon AWS
5 3 (0.27%) Cloud Computing
6 1 (0.088%) Amazon EC2
6 1 (0.088%) Amazon S3
Communications & Networking
1 10 (0.88%) SAN
2 7 (0.62%) Intranet
2 7 (0.62%) HTTP
2 7 (0.62%) DNS
3 5 (0.44%) TCP/IP
4 4 (0.35%) NAS
5 3 (0.27%) iSCSI
5 3 (0.27%) FCoE
5 3 (0.27%) Fibre Channel
5 3 (0.27%) Multicast
5 3 (0.27%) LAN
5 3 (0.27%) WAN
6 2 (0.18%) ATM
6 2 (0.18%) Broadband
6 2 (0.18%) LDAP
6 2 (0.18%) Internet
7 1 (0.088%) FTP
Database & Business Intelligence
1 730 (64.49%) SQL Server
2 665 (58.75%) Data Warehouse
3 594 (52.47%) SQL Server Integration Services
4 571 (50.44%) SQL Server Reporting Services
5 568 (50.18%) SQL Server Analysis Services
6 380 (33.57%) OLAP Cube
7 326 (28.80%) Oracle OLAP
8 300 (26.50%) SQL Server 2008
9 199 (17.58%) SQL Server 2012
10 177 (15.64%) OLTP
11 131 (11.57%) Microsoft Analysis Services
12 130 (11.48%) Relational Database
13 125 (11.04%) Oracle Database
14 109 (9.63%) SQL Server 2005
15 100 (8.83%) QlikView
16 96 (8.48%) Big Data
17 89 (7.86%) Data Mining
18 79 (6.98%) Oracle BI EE
19 76 (6.71%) Hadoop
20 62 (5.48%) Oracle ODI
Development Applications
1 60 (5.30%) Team Foundation Server
2 24 (2.12%) Visual Studio
3 16 (1.41%) Subversion
4 15 (1.33%) Talend Open Studio
4 15 (1.33%) Toad
5 13 (1.15%) Maven
6 12 (1.06%) Git (software)
7 11 (0.97%) ERwin
7 11 (0.97%) PowerDesigner
8 10 (0.88%) Oracle Forms
9 9 (0.80%) SQL Server Management Studio (SSMS)
10 5 (0.44%) JUnit
11 4 (0.35%) VSS/SourceSafe
12 2 (0.18%) JIRA
12 2 (0.18%) NuGet
12 2 (0.18%) MSBuild
12 2 (0.18%) TeamCity
13 1 (0.088%) Rational Functional Tester
13 1 (0.088%) Visual Studio Team System
13 1 (0.088%) QuickTest Pro
General
1 371 (32.77%) Finance
2 112 (9.89%) Banking
3 61 (5.39%) Marketing
4 37 (3.27%) Retail
5 25 (2.21%) Front Office
6 24 (2.12%) Advertising
7 20 (1.77%) Investment Banking
8 17 (1.50%) Law
9 16 (1.41%) Legal
10 15 (1.33%) Games
11 10 (0.88%) Financial Institution
12 9 (0.80%) Telecoms
12 9 (0.80%) General Ledger
13 8 (0.71%) Retail Banking
14 6 (0.53%) Back Office
15 5 (0.44%) Billing
16 3 (0.27%) Automotive
17 2 (0.18%) Pharmaceutical
18 1 (0.088%) Manufacturing
18 1 (0.088%) Publishing
Job Titles
1 570 (50.35%) Developer
2 287 (25.35%) Business Intelligence Developer
3 155 (13.69%) Consultant
4 145 (12.81%) Analyst
5 108 (9.54%) Business Developer
6 103 (9.10%) DBA
7 102 (9.01%) Business Intelligence Consultant
8 93 (8.22%) SQL Developer
9 83 (7.33%) Senior Developer
10 75 (6.63%) Business Intelligence Analyst
11 73 (6.45%) Architect
12 64 (5.65%) Business Analyst
13 60 (5.30%) SQL DBA
14 52 (4.59%) Data Warehouse Developer
15 45 (3.98%) Business Consultant
16 40 (3.53%) Senior Business Intelligence Developer
17 37 (3.27%) Microsoft Consultant
18 35 (3.09%) Java Developer
18 35 (3.09%) .NET Developer
18 35 (3.09%) Microsoft BI Consultant
Libraries, Frameworks & Software Standards
1 186 (16.43%) .NET
2 179 (15.81%) MDX
3 88 (7.77%) XML
4 62 (5.48%) ASP.NET
4 62 (5.48%) HTML
5 51 (4.51%) Web Services
6 36 (3.18%) HTML5
6 36 (3.18%) CSS
7 33 (2.92%) WCF
8 29 (2.56%) ASP.NET MVC
9 23 (2.03%) jQuery
10 22 (1.94%) LINQ
11 20 (1.77%) WSDL
12 19 (1.68%) Spring
13 18 (1.59%) Ajax
14 16 (1.41%) Flash
14 16 (1.41%) XML Schema
14 16 (1.41%) ASP.NET 2.0
15 15 (1.33%) .NET Framework
15 15 (1.33%) Hibernate
Miscellaneous
1 240 (21.20%) Analytical Skills
2 92 (8.13%) Computer Science
3 79 (6.98%) Visualisation
4 74 (6.54%) Data Integration
5 65 (5.74%) Management Information System
6 58 (5.12%) Data Structures
7 57 (5.04%) Mathematics
8 51 (4.51%) Replication
9 40 (3.53%) Clustering
10 19 (1.68%) Oracle Exalytics
11 17 (1.50%) User Experience
11 17 (1.50%) Fixed Income
12 16 (1.41%) Reference Data
13 15 (1.33%) PMI
13 15 (1.33%) Statistics
14 13 (1.15%) Data Conversion
14 13 (1.15%) Oracle Exalogic
15 11 (0.97%) Enterprise Software
16 10 (0.88%) iPad
16 10 (0.88%) Data Extraction
Operating Systems
1 65 (5.74%) UNIX
2 63 (5.57%) Windows
3 54 (4.77%) Linux
4 10 (0.88%) Android
5 9 (0.80%) Windows Server 2008
6 4 (0.35%) Windows Server 2003
6 4 (0.35%) Windows Server 2012
7 3 (0.27%) MVS
7 3 (0.27%) Solaris
8 2 (0.18%) zOS
9 1 (0.088%) CentOS
9 1 (0.088%) Oracle Linux
9 1 (0.088%) Windows NT
9 1 (0.088%) Windows XP
Processes & Methodologies
1 817 (72.17%) Business Intelligence
2 603 (53.27%) ETL
3 256 (22.61%) Data Modelling
4 221 (19.52%) Agile Software Development
5 181 (15.99%) Analytics
6 131 (11.57%) Kimball Methodology
7 112 (9.89%) Scrum
8 97 (8.57%) Project Management
9 93 (8.22%) Performance Tuning
10 85 (7.51%) Dimensional Modelling
11 83 (7.33%) CRM
11 83 (7.33%) Data Management
12 78 (6.89%) E-Commerce
13 71 (6.27%) Data Analysis
14 65 (5.74%) ERP
15 60 (5.30%) Data Architecture
16 55 (4.86%) Information Management
17 44 (3.89%) Unit Testing
18 43 (3.80%) Stakeholder Management
19 37 (3.27%) PRINCE2
Programming Languages
1 803 (70.94%) SQL
2 366 (32.33%) T-SQL
3 169 (14.93%) C#
4 94 (8.30%) PL/SQL
5 81 (7.16%) Java
6 55 (4.86%) JavaScript
7 42 (3.71%) VBA
8 31 (2.74%) Shell Script
8 31 (2.74%) PowerShell
9 25 (2.21%) VB.NET
10 18 (1.59%) Data Analysis Expressions (DAX)
11 17 (1.50%) R
12 16 (1.41%) ActionScript
13 13 (1.15%) VB
14 11 (0.97%) Python
15 10 (0.88%) Perl
16 5 (0.44%) C
16 5 (0.44%) VBScript
17 4 (0.35%) ABAP
17 4 (0.35%) C++
Qualifications
1 199 (17.58%) Degree
2 54 (4.77%) Microsoft Certification
3 27 (2.39%) MCDBA
4 16 (1.41%) PMI Certification
5 15 (1.33%) MCITP
6 14 (1.24%) MCSE
6 14 (1.24%) Security Cleared
7 13 (1.15%) MCSD
8 11 (0.97%) SC Cleared
9 9 (0.80%) IBM Certification
10 8 (0.71%) ACCA
11 7 (0.62%) MCP
12 2 (0.18%) MCAD
12 2 (0.18%) ISEB
12 2 (0.18%) OCP
12 2 (0.18%) Oracle Certification
12 2 (0.18%) SAS Certification
13 1 (0.088%) PMP
13 1 (0.088%) ISTQB
Quality Assurance & Compliance
1 32 (2.83%) QA
2 19 (1.68%) ISO 9001
3 13 (1.15%) Data Quality
4 9 (0.80%) Solvency II
5 7 (0.62%) SLA
6 2 (0.18%) COBIT
6 2 (0.18%) GAMP
6 2 (0.18%) GxP
6 2 (0.18%) ISO 14001
6 2 (0.18%) Sarbanes-Oxley
6 2 (0.18%) GAAP
6 2 (0.18%) PCI DSS
7 1 (0.088%) HL7
7 1 (0.088%) ISO/IEC 27001
System Software
1 30 (2.65%) Oracle RAC
2 11 (0.97%) Varnish
3 8 (0.71%) Active Directory
4 3 (0.27%) Hyper-V
4 3 (0.27%) SRDF
4 3 (0.27%) VMware Infrastructure
4 3 (0.27%) KVM
4 3 (0.27%) NFS
4 3 (0.27%) Xen
5 2 (0.18%) Oracle RMAN
6 1 (0.088%) HDFS
Systems Management
1 8 (0.71%) Data Guard
2 2 (0.18%) MAINVIEW
3 1 (0.088%) Oracle Enterprise Manager
3 1 (0.088%) Foglight
Vendors
1 433 (38.25%) Microsoft
2 328 (28.98%) Oracle
3 147 (12.99%) Business Objects
4 128 (11.31%) Cognos
5 109 (9.63%) Tableau
6 95 (8.39%) Informatica
7 94 (8.30%) SAP
8 69 (6.10%) IBM
9 55 (4.86%) Teradata
10 50 (4.42%) Hyperion
11 48 (4.24%) MicroStrategy
12 40 (3.53%) Sybase
13 29 (2.56%) Ab Initio
13 29 (2.56%) Netezza
14 20 (1.77%) Siebel
15 18 (1.59%) Hitachi
16 16 (1.41%) JD Edwards
17 15 (1.33%) Talend
18 13 (1.15%) Infor
19 12 (1.06%) Applix
Manchester, Lancashire
Circle Recruitment
Salary: £28000 - £35000 per annum + Bonus + Benefits
Posted: 5 hours ago
London
Venturi
Salary: £50000 - £85000 per annum + 15% bonus + Benefits
Posted: 7 hours ago
City, London
Ace European Group
Salary: Competitive
Posted: 8 hours ago
London
Spencer Rose
Salary: Up to £65,000 per annum Flexi-hours, 25 days holiday, pension (5%), me
Posted: 12 hours ago
London
Westbourne Partners
Salary: From £70,000 to £90,000 per annum
Posted: Yesterday
Luton, Bedfordshire
easyJet Airline
Posted: Yesterday
City, London
Ashdown IT
Salary: £70000 - £75000 per annum
Posted: Yesterday
City, London
Henderson Drake
Salary: From £45,000 to £60,000 per annum Bonus + Pension + Insurance + Dental
Posted: Yesterday
Luton, Bedfordshire
Easyjet
Posted: Yesterday
North West
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
North East
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
West Midlands
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
South West
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
South East
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
London
EMBS- People Transfer
Salary: Car Allow + Medical + Bens
Posted: Yesterday
London
Cognizant
Posted: Yesterday
City, London
Energon People
Salary: £0.00 per annum
Posted: 2 days ago
London
Digitech Resourcing Ltd
Salary: From £40,000 to £45,000 per annum + Bonus
Posted: 2 days ago
London
Resource Solutions - Man Group
Salary: Competitive
Posted: 2 days ago
Edinburgh, Midlothian
Search Consultancy
Salary: £30000 - £75000 per annum + benefits
Posted: 2 days ago