The first table below looks at the demand 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 11 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Location
3 months to
11 Jul 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 381 400 320
Rank change year-on-year
+19 -80
Permanent jobs citing OLAP 761 607 899
As % of all permanent IT jobs located in the UK 0.65% 0.56% 0.77%
As % of the Database & Business Intelligence category 2.09% 1.78% 2.47%
Number of salaries quoted 657 526 774
Average salary £50,000 £50,000 £46,000
Average salary % change year-on-year
- +8.69%
90% offered a salary of more than £35,850 £32,500 £32,500
10% offered a salary of more than £70,000 £70,000 £70,000
UK excluding London average salary £45,000 £44,000 £40,000
% change year-on-year
+2.27% +10.00%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36427 34168 36370
As % of all permanent IT jobs located in the UK 31.23% 31.32% 30.98%
Number of salaries quoted 31229 29587 32180
Average salary £45,000 £42,500 £42,500
Average salary % change year-on-year
+5.88% -
90% offered a salary of more than £30,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £65,000
UK excluding London average salary £40,000 £39,000 £38,000
% change year-on-year
+2.56% +2.63%

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 11 July 2014 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 11 July 2014. 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 +35 721 £51,750 +3.50% 95
London +38 417 £55,000 -4.34% 53
City of London +35 127 £58,500 -4.87% 27
South East +11 119 £51,750 +8.94% 11
West Midlands +45 64 £40,000 +9.58% 3
East of England +11 40 £40,500 -4.70% 1
Staffordshire +24 38 £40,000 +29.03% 3
Yorkshire -48 31 £35,000 -6.66% 5
Surrey +20 27 £52,000 +4.00%
Hampshire +16 24 £40,000 +5.26% 4
North West -24 22 £42,500 -5.55% 9
Berkshire -6 20 £55,000 +10.00% 5
Cambridgeshire +10 16 £40,500 -10.00% 1
Wales -8 16 £37,500 +15.38% 4
West Yorkshire -55 16 £43,250 +15.33% 4
Southampton - 16 £31,250 - 3
Suffolk +16 15 £40,000 -5.88%
Burton-upon-Trent +5 15 £40,000 +29.03% 2
North Yorkshire +2 14 £33,750 -12.90%
Cardiff +1 13 £41,980 +29.16% 4
South Wales -4 13 £41,980 +29.16% 4
Kent -9 13 £47,500 -
East Midlands -11 13 £55,000 +49.65% 9
South West -20 13 £45,000 -13.46% 4
Manchester -29 11 £47,500 - 5
Camberley - 11 £52,000 -
West Sussex +4 10 £75,000 +36.36%
Buckinghamshire -20 10 £50,000 +42.85%
Scotland -26 10 £45,000 -14.28% 1
Warwickshire +20 9 £35,000 -19.54%

OLAP
Top 30 Related IT Skills

For the 6 months to 11 July 2014, 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 1065 (72.01%) SQL
2 1048 (70.86%) Business Intelligence
3 1034 (69.91%) SQL Server
4 862 (58.28%) Data Warehouse
5 828 (55.98%) SQL Server Integration Services
6 797 (53.89%) SQL Server Reporting Services
7 767 (51.86%) ETL
8 764 (51.66%) SQL Server Analysis Services
9 569 (38.47%) Microsoft
10 478 (32.32%) T-SQL
11 421 (28.47%) Finance
12 404 (27.32%) SQL Server 2008
13 392 (26.50%) MS Excel
14 342 (23.12%) Oracle
15 340 (22.99%) Oracle OLAP
16 313 (21.16%) .NET
17 311 (21.03%) MDX
18 303 (20.49%) Data Modelling
19 247 (16.70%) C#
20 230 (15.55%) Relational Database
21 225 (15.21%) Microsoft Analysis Services
21 225 (15.21%) OLTP
22 213 (14.40%) Analytics
23 204 (13.79%) Degree
24 200 (13.52%) SQL Server 2012
25 195 (13.18%) Dimensional Modelling
26 176 (11.90%) SQL Server 2005
26 176 (11.90%) Performance Tuning
27 169 (11.43%) Cognos
28 165 (11.16%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 11 July 2014, 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 148 (10.01%) SharePoint
2 83 (5.61%) SAS
3 39 (2.64%) IIS
4 27 (1.83%) BizTalk Server
5 22 (1.49%) Tomcat
6 16 (1.08%) Apache
6 16 (1.08%) WebSphere
7 11 (0.74%) Oracle Application Server
8 9 (0.61%) Oracle 10gAS
9 8 (0.54%) SharePoint Server
9 8 (0.54%) FileNet
10 7 (0.47%) Oracle Workflow
11 5 (0.34%) SharePoint 2010
12 4 (0.27%) WebLogic
12 4 (0.27%) NetWeaver
12 4 (0.27%) MS Exchange
13 2 (0.14%) Blackberry Enterprise Server
13 2 (0.14%) Lync
13 2 (0.14%) Exchange Server 2010
13 2 (0.14%) Apache Pig
Applications
1 392 (26.50%) MS Excel
2 81 (5.48%) MS Office
3 53 (3.58%) PowerPivot
4 35 (2.37%) MS Project
5 17 (1.15%) MS PowerPoint
6 15 (1.01%) SPSS
7 14 (0.95%) Spreadsheet
8 8 (0.54%) MS Visio
9 5 (0.34%) S-PLUS
9 5 (0.34%) FastStats
10 3 (0.20%) Stata
11 1 (0.068%) InfoPath
Business Applications
1 57 (3.85%) Cognos Business Intelligence
2 47 (3.18%) Cognos TM1
3 21 (1.42%) HFM
4 16 (1.08%) Dynamics AX
5 14 (0.95%) Dynamics CRM
5 14 (0.95%) Oracle EBS
6 11 (0.74%) Hyperion Planning
7 4 (0.27%) Google Analytics
7 4 (0.27%) Summit
7 4 (0.27%) Siebel Analytics
7 4 (0.27%) Line 500
8 3 (0.20%) Dynamics NAV
9 2 (0.14%) SAP Oil and Gas
9 2 (0.14%) Oracle Financials
9 2 (0.14%) Oracle CRM
9 2 (0.14%) Oracle ERP
9 2 (0.14%) Oracle Applications
9 2 (0.14%) Magento
9 2 (0.14%) Oracle Procure-to-Pay
10 1 (0.068%) Visualfiles
Cloud Services
1 12 (0.81%) SaaS
2 9 (0.61%) Office 365
2 9 (0.61%) Amazon EC2
3 6 (0.41%) Microsoft Azure
3 6 (0.41%) Amazon AWS
4 1 (0.068%) Cloud Computing
Communications & Networking
1 31 (2.10%) Intranet
2 20 (1.35%) Internet
3 17 (1.15%) SAN
4 8 (0.54%) Extranet
5 7 (0.47%) ATM
6 6 (0.41%) LAN
6 6 (0.41%) WAN
6 6 (0.41%) DMZ
6 6 (0.41%) NAS
7 5 (0.34%) Firewall
8 4 (0.27%) iSCSI
8 4 (0.27%) Fibre Channel
9 3 (0.20%) FCoE
9 3 (0.20%) Ethernet
9 3 (0.20%) FTP
9 3 (0.20%) PPP
10 2 (0.14%) TCP/IP
10 2 (0.14%) DNS
10 2 (0.14%) HTTP
10 2 (0.14%) Wi-Fi
Database & Business Intelligence
1 1034 (69.91%) SQL Server
2 862 (58.28%) Data Warehouse
3 828 (55.98%) SQL Server Integration Services
4 797 (53.89%) SQL Server Reporting Services
5 764 (51.66%) SQL Server Analysis Services
6 404 (27.32%) SQL Server 2008
7 340 (22.99%) Oracle OLAP
8 230 (15.55%) Relational Database
9 225 (15.21%) Microsoft Analysis Services
9 225 (15.21%) OLTP
10 200 (13.52%) SQL Server 2012
11 176 (11.90%) SQL Server 2005
12 146 (9.87%) RDBMS
13 123 (8.32%) Oracle Database
14 118 (7.98%) Data Mining
15 100 (6.76%) Big Data
16 94 (6.36%) MySQL
17 81 (5.48%) DTS
18 65 (4.39%) DB2
19 61 (4.12%) QlikView
Development Applications
1 51 (3.45%) Team Foundation Server
2 45 (3.04%) Visual Studio
3 27 (1.83%) Talend Open Studio
4 24 (1.62%) SQL Server Management Studio (SSMS)
5 20 (1.35%) JUnit
5 20 (1.35%) Eclipse
5 20 (1.35%) ERwin
6 19 (1.28%) Maven
7 18 (1.22%) Git (software)
8 15 (1.01%) Selenium
9 14 (0.95%) Visual Studio Team System
10 13 (0.88%) Oracle Forms
11 10 (0.68%) Subversion
12 9 (0.61%) MorphX
12 9 (0.61%) PVCS
13 7 (0.47%) Toad
13 7 (0.47%) Oracle APEX
14 6 (0.41%) NuGet
15 4 (0.27%) PowerDesigner
15 4 (0.27%) Bugzilla
General
1 421 (28.47%) Finance
2 121 (8.18%) Banking
3 71 (4.80%) Marketing
4 59 (3.99%) Games
5 55 (3.72%) Retail
6 54 (3.65%) Advertising
7 50 (3.38%) Investment Banking
8 48 (3.25%) Telecoms
9 29 (1.96%) Law
10 26 (1.76%) Legal
11 20 (1.35%) Publishing
12 15 (1.01%) Front Office
13 14 (0.95%) Pharmaceutical
14 11 (0.74%) Financial Institution
15 9 (0.61%) Back Office
16 8 (0.54%) Billing
17 7 (0.47%) Music Industry
18 6 (0.41%) International Banking
19 5 (0.34%) French Language
19 5 (0.34%) German Language
Job Titles
1 809 (54.70%) Developer
2 395 (26.71%) Business Intelligence Developer
3 246 (16.63%) SQL Developer
4 193 (13.05%) Analyst
5 161 (10.89%) Consultant
6 156 (10.55%) DBA
7 148 (10.01%) Business Developer
8 110 (7.44%) Senior Developer
9 96 (6.49%) Business Intelligence Consultant
10 94 (6.36%) SQL Server Developer
11 93 (6.29%) Data Warehouse Developer
12 89 (6.02%) SQL DBA
13 82 (5.54%) Business Intelligence Analyst
14 76 (5.14%) Architect
15 69 (4.67%) Administrator
16 55 (3.72%) Microsoft Developer
17 51 (3.45%) Business Analyst
18 49 (3.31%) Database Developer
19 47 (3.18%) SQL Server DBA
20 41 (2.77%) Development Manager
Libraries, Frameworks & Software Standards
1 313 (21.16%) .NET
2 311 (21.03%) MDX
3 131 (8.86%) XML
4 113 (7.64%) ASP.NET
5 88 (5.95%) Web Services
6 72 (4.87%) HTML
7 69 (4.67%) CSS
8 36 (2.43%) jQuery
9 31 (2.10%) ASP.NET MVC
10 25 (1.69%) Ajax
10 25 (1.69%) NHibernate
11 24 (1.62%) HTML5
11 24 (1.62%) Spring
12 23 (1.56%) CSS3
13 22 (1.49%) .NET Framework
14 20 (1.35%) OOXML
14 20 (1.35%) WCF
15 17 (1.15%) WPF
16 16 (1.08%) Castle Windsor
17 15 (1.01%) Razor View Engine
Miscellaneous
1 95 (6.42%) Computer Science
2 91 (6.15%) Management Information System
3 90 (6.09%) Replication
4 67 (4.53%) Clustering
5 66 (4.46%) Data Integration
6 54 (3.65%) Visualisation
7 30 (2.03%) Mathematics
7 30 (2.03%) Statistics
8 25 (1.69%) Online Games
9 22 (1.49%) Data Extraction
9 22 (1.49%) Enterprise Software
10 20 (1.35%) Credit Risk
10 20 (1.35%) GIS
11 19 (1.28%) Data Conversion
12 18 (1.22%) iPad
13 17 (1.15%) Inversion of Control
13 17 (1.15%) Client/Server
14 14 (0.95%) Hedge funds
15 11 (0.74%) Mobile App
15 11 (0.74%) Digital Media
Operating Systems
1 146 (9.87%) Windows
2 119 (8.05%) Linux
3 60 (4.06%) UNIX
4 24 (1.62%) Windows Server 2008
5 18 (1.22%) Android
6 14 (0.95%) AIX
7 12 (0.81%) Windows Server 2003
8 4 (0.27%) Ubuntu
8 4 (0.27%) Solaris
8 4 (0.27%) Oracle Linux
9 3 (0.20%) CentOS
9 3 (0.20%) Red Hat Enterprise Linux
10 2 (0.14%) Apple iOS
10 2 (0.14%) VMS
11 1 (0.068%) Windows 8
11 1 (0.068%) Windows 7
11 1 (0.068%) Windows 2000 Server
Processes & Methodologies
1 1048 (70.86%) Business Intelligence
2 767 (51.86%) ETL
3 303 (20.49%) Data Modelling
4 213 (14.40%) Analytics
5 195 (13.18%) Dimensional Modelling
6 176 (11.90%) Performance Tuning
7 165 (11.16%) Kimball Methodology
8 155 (10.48%) Agile Software Development
9 121 (8.18%) Data Management
10 117 (7.91%) Scrum
11 115 (7.78%) Project Management
12 94 (6.36%) Business Analysis
13 88 (5.95%) E-Commerce
14 82 (5.54%) Data Analysis
15 74 (5.00%) CRM
15 74 (5.00%) Data Architecture
16 65 (4.39%) OO
16 65 (4.39%) Migration
17 55 (3.72%) MVC
18 54 (3.65%) Performance Management
Programming Languages
1 1065 (72.01%) SQL
2 478 (32.32%) T-SQL
3 247 (16.70%) C#
4 91 (6.15%) Java
5 89 (6.02%) PL/SQL
6 64 (4.33%) JavaScript
7 54 (3.65%) VBA
8 38 (2.57%) VB.NET
9 28 (1.89%) VB
9 28 (1.89%) Data Mining Extensions (DMX)
10 27 (1.83%) Python
11 25 (1.69%) PowerShell
12 20 (1.35%) PHP
13 19 (1.28%) Shell Script
14 16 (1.08%) R
15 12 (0.81%) C
16 9 (0.61%) X++
16 9 (0.61%) Data Analysis Expressions (DAX)
17 8 (0.54%) Perl
18 6 (0.41%) C++
Qualifications
1 204 (13.79%) Degree
2 80 (5.41%) Microsoft Certification
3 28 (1.89%) MCITP
4 22 (1.49%) MCAD
5 17 (1.15%) MCDBA
5 17 (1.15%) Security Cleared
6 14 (0.95%) MCTS
6 14 (0.95%) Oracle Certification
7 12 (0.81%) ITIL Certification
8 11 (0.74%) PMI Certification
9 8 (0.54%) ACCA
9 8 (0.54%) CIMA
10 7 (0.47%) ISEB
11 6 (0.41%) PhD
11 6 (0.41%) MCSE
11 6 (0.41%) ISTQB
12 4 (0.27%) MCSD
12 4 (0.27%) SAS Certification
13 3 (0.20%) HND
13 3 (0.20%) MCSA
Quality Assurance & Compliance
1 84 (5.68%) QA
2 20 (1.35%) ISO 9001
3 16 (1.08%) SLA
4 14 (0.95%) PCI DSS
5 11 (0.74%) TickIT
6 10 (0.68%) Data Quality
7 5 (0.34%) Sarbanes-Oxley
8 3 (0.20%) GAAP
8 3 (0.20%) ISO/IEC 27001
8 3 (0.20%) HL7
System Software
1 29 (1.96%) Oracle RAC
2 9 (0.61%) VMware Infrastructure
3 7 (0.47%) Active Directory
4 6 (0.41%) Oracle RMAN
5 5 (0.34%) HDFS
6 3 (0.20%) Hyper-V
7 2 (0.14%) XenApp
7 2 (0.14%) XenDesktop
7 2 (0.14%) VMware ESX
Systems Management
1 25 (1.69%) Data Guard
2 7 (0.47%) Oracle Enterprise Manager
3 5 (0.34%) Opscode Chef
4 3 (0.20%) Foglight
5 2 (0.14%) SCCM
5 2 (0.14%) OSSEC
5 2 (0.14%) Puppet
5 2 (0.14%) Red Hat Spacewalk
5 2 (0.14%) Nagios
6 1 (0.068%) Tivoli
Vendors
1 569 (38.47%) Microsoft
2 342 (23.12%) Oracle
3 169 (11.43%) Cognos
4 136 (9.20%) Business Objects
5 121 (8.18%) IBM
6 79 (5.34%) Informatica
7 68 (4.60%) SAP
8 61 (4.12%) MicroStrategy
8 61 (4.12%) Tableau
9 46 (3.11%) Teradata
10 44 (2.97%) Sybase
11 40 (2.70%) Netezza
12 28 (1.89%) Dundas
13 27 (1.83%) Hyperion
13 27 (1.83%) Talend
14 20 (1.35%) Sun
15 14 (0.95%) HP
15 14 (0.95%) JBoss
15 14 (0.95%) Red Gate
16 13 (0.88%) Vertica
London
Westbourne Partners Ltd
Salary: Excellent
Posted: 16 hours ago
London
Arrows Group
Salary: £40000 - £65000 per annum + Benefits
Posted: Yesterday
City, London
Arrows Group
Salary: £45000 - £55000 per annum + Benefits
Posted: Yesterday
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £40K + Excellent Benefits
Posted: Yesterday
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £40K + Excellent Benefits
Posted: Yesterday
City, London
Lawrence Harvey Enterprise
Salary: £70000 - £80000 per annum + Benefits
Posted: Yesterday
Stoke-On-Trent, Staffordshire
Experis Ltd
Salary: Excellent Salary and Packager
Posted: Yesterday
City, London
Client Server
Salary: £65k to £80k + bonus + benefits
Posted: Yesterday
Manchester, Lancashire
Adria Solutions Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: Yesterday
Reading, Berkshire
Oxbridge Answers
Salary: 45-75k
Posted: Yesterday
London
Avanade UK Ltd
Posted: 2 days ago
Teddington, Middlesex
Bluetownonline
Salary: £60k - 70k per year
Posted: 2 days ago
Kingston Upon Thames, Surrey
Avantia Insurance
Salary: Up to £65,000 per annum + Benefits
Posted: 2 days ago
Derbyshire
Oscar Associates (UK) Ltd
Salary: £30000 - £42000 per annum
Posted: 3 days ago
City, London
Nigel Frank International Ltd
Salary: £35000 per annum
Posted: 3 days ago
Wiltshire
Personnel IT
Salary: £40000.00 - £45000.00 per annum
Posted: 3 days ago
London
Salt
Salary: £45000 - £50000 per annum + Benefits
Posted: 3 days ago
City, London
Oliver James Associates
Salary: £57000 - £65000 per annum + Bonus + Benefits package
Posted: 3 days ago
City, London
Network Compucare Ltd
Salary: bonus
Posted: 3 days ago
City, London
IT Rockstars Recruitment
Salary: From £50,000 to £75,000 per annum 10% annual bonus offered
Posted: 3 days ago