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 21 October 2014 with a comparison to the same period in the previous 2 years.

Location
3 months to
21 Oct 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 407 383 311
Rank change year-on-year
-24 -72
Permanent jobs citing OLAP 691 683 982
As % of all permanent IT jobs located in the UK 0.61% 0.63% 0.85%
As % of the Database & Business Intelligence category 2.02% 1.98% 2.72%
Number of salaries quoted 596 595 900
Average salary £50,000 £50,000 £45,000
Average salary % change year-on-year
- +11.11%
90% offered a salary of more than £35,000 £32,500 £32,500
10% offered a salary of more than £70,000 £75,000 £67,500
UK excluding London average salary £42,500 £40,000 £40,500
% change year-on-year
+6.25% -1.23%

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
34211 34563 36061
As % of all permanent IT jobs located in the UK 30.07% 31.95% 31.37%
Number of salaries quoted 28830 29898 31701
Average salary £45,000 £45,000 £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 £67,500 £65,000 £67,500
UK excluding London average salary £40,000 £40,000 £40,000

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 21 October 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 21 October 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 -17 644 £50,000 - 78
London -14 356 £57,500 +4.54% 31
City of London +31 119 £62,500 +13.63% 13
South East +3 92 £52,500 +16.66% 9
East of England -3 50 £40,000 +23.07% 7
North West -1 41 £44,000 -2.22% 9
Yorkshire -20 40 £41,250 +10.00% 7
Berkshire -1 39 £50,000 +11.11% 3
Manchester -9 37 £44,000 -7.36% 5
West Midlands -4 36 £38,000 +6.29% 5
West Yorkshire -22 32 £42,500 +13.33% 7
Reading +9 22 £50,000 -23.07% 2
Surrey +5 21 £52,500 +13.51%
Staffordshire +5 20 £32,500 -
South Wales +23 19 £37,500 -7.40% 4
Wales +12 19 £37,500 -7.40% 4
Cardiff +10 18 £37,500 -8.53% 2
Bradford +2 18 £43,625 +12.58% 1
Hertfordshire -3 18 £40,000 +24.03% 3
East Midlands -25 13 £45,000 +20.00% 3
West Sussex +7 11 £55,000 +29.41% 4
South West -12 11 £44,250 -4.32% 7
Cambridgeshire -7 10 £32,500 -11.47% 2
Crawley +6 9 £55,000 +29.41% 1
Essex +3 9 £42,500 -9.81% 2
Leeds -43 9 £35,000 -9.67% 2
Scotland -25 8 £80,000 +45.45% 2
Southend-on-Sea - 8 £42,500 -
Warwickshire +1 7 £39,000 +20.00%
Nottingham 0 6 £40,000 +23.07% 1

OLAP
Top 30 Related IT Skills

For the 6 months to 21 October 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 1021 (70.22%) Business Intelligence
2 1006 (69.19%) SQL
3 962 (66.16%) SQL Server
4 844 (58.05%) Data Warehouse
5 738 (50.76%) SQL Server Integration Services
6 732 (50.34%) ETL
7 722 (49.66%) SQL Server Analysis Services
8 699 (48.07%) SQL Server Reporting Services
9 522 (35.90%) Microsoft
10 417 (28.68%) Finance
11 411 (28.27%) T-SQL
12 396 (27.24%) Oracle
12 396 (27.24%) Oracle OLAP
13 367 (25.24%) SQL Server 2008
14 354 (24.35%) MS Excel
15 325 (22.35%) Data Modelling
16 316 (21.73%) Agile Software Development
17 272 (18.71%) Analytical Skills
18 270 (18.57%) .NET
19 245 (16.85%) MDX
20 227 (15.61%) SQL Server 2012
21 223 (15.34%) Degree
22 213 (14.65%) OLTP
23 211 (14.51%) C#
24 210 (14.44%) SharePoint
25 198 (13.62%) Relational Database
26 180 (12.38%) Analytics
27 173 (11.90%) Microsoft Analysis Services
28 169 (11.62%) Kimball Methodology
29 161 (11.07%) Cognos

OLAP
Top Related IT Skills by Category

For the 6 months to 21 October 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 210 (14.44%) SharePoint
2 75 (5.16%) SAS
3 35 (2.41%) SharePoint 2010
4 26 (1.79%) IIS
5 24 (1.65%) Tomcat
6 22 (1.51%) BizTalk Server
6 22 (1.51%) WebLogic
7 18 (1.24%) WebSphere
8 14 (0.96%) Apache
9 10 (0.69%) Oracle Application Server
10 9 (0.62%) SharePoint Server
10 9 (0.62%) Oracle 10gAS
10 9 (0.62%) Oracle Coherence
10 9 (0.62%) Apache Spark
11 8 (0.55%) Apache Solr
11 8 (0.55%) ColdFusion
11 8 (0.55%) Oracle Workflow
12 5 (0.34%) JBoss
13 4 (0.28%) SharePoint 2013
14 3 (0.21%) CMS
Applications
1 354 (24.35%) MS Excel
2 98 (6.74%) MS Office
3 69 (4.75%) PowerPivot
4 24 (1.65%) MS Project
5 23 (1.58%) MS PowerPoint
6 20 (1.38%) SPSS
7 15 (1.03%) MS Visio
8 7 (0.48%) S-PLUS
8 7 (0.48%) Spreadsheet
9 6 (0.41%) FastStats
10 3 (0.21%) Stata
Business Applications
1 53 (3.65%) Cognos TM1
2 47 (3.23%) Cognos Business Intelligence
3 25 (1.72%) HFM
4 20 (1.38%) Dynamics CRM
5 15 (1.03%) Dynamics AX
6 11 (0.76%) Oracle EBS
7 10 (0.69%) Hyperion Planning
7 10 (0.69%) Oracle ERP
8 7 (0.48%) Summit
8 7 (0.48%) Cognos Planning
9 6 (0.41%) Google Analytics
10 4 (0.28%) Oracle General Ledger
10 4 (0.28%) Line 500
11 2 (0.14%) Remedy ITSM
11 2 (0.14%) Cognos Controller
11 2 (0.14%) Adaptiv
12 1 (0.069%) Khalix
12 1 (0.069%) SAP Oil and Gas
12 1 (0.069%) Dynamics GP
12 1 (0.069%) Dynamics NAV
Cloud Services
1 10 (0.69%) Office 365
1 10 (0.69%) SaaS
2 9 (0.62%) Amazon EC2
3 7 (0.48%) Microsoft Azure
3 7 (0.48%) Amazon AWS
4 1 (0.069%) Cloud Computing
Communications & Networking
1 40 (2.75%) Intranet
2 22 (1.51%) Internet
3 12 (0.83%) SAN
4 10 (0.69%) ATM
5 9 (0.62%) DNS
6 4 (0.28%) Fibre Channel
6 4 (0.28%) iSCSI
6 4 (0.28%) DMZ
6 4 (0.28%) LAN
6 4 (0.28%) WAN
7 3 (0.21%) Ethernet
7 3 (0.21%) LDAP
7 3 (0.21%) Firewall
7 3 (0.21%) FCoE
7 3 (0.21%) InfiniBand
8 2 (0.14%) Broadband
8 2 (0.14%) FTP
9 1 (0.069%) HTTP
9 1 (0.069%) Extranet
9 1 (0.069%) Cisco ASA
Database & Business Intelligence
1 962 (66.16%) SQL Server
2 844 (58.05%) Data Warehouse
3 738 (50.76%) SQL Server Integration Services
4 722 (49.66%) SQL Server Analysis Services
5 699 (48.07%) SQL Server Reporting Services
6 396 (27.24%) Oracle OLAP
7 367 (25.24%) SQL Server 2008
8 227 (15.61%) SQL Server 2012
9 213 (14.65%) OLTP
10 198 (13.62%) Relational Database
11 173 (11.90%) Microsoft Analysis Services
12 152 (10.45%) Oracle Database
13 148 (10.18%) RDBMS
14 135 (9.28%) SQL Server 2005
15 114 (7.84%) Big Data
16 109 (7.50%) Data Mining
17 87 (5.98%) MySQL
18 76 (5.23%) Oracle Database 11g
19 70 (4.81%) QlikView
20 69 (4.75%) Oracle ODI
Development Applications
1 66 (4.54%) Team Foundation Server
2 51 (3.51%) Visual Studio
3 31 (2.13%) Talend Open Studio
4 17 (1.17%) ERwin
5 16 (1.10%) JUnit
6 15 (1.03%) Visual Studio Team System
7 14 (0.96%) Oracle Forms
8 13 (0.89%) SQL Server Management Studio (SSMS)
9 12 (0.83%) Subversion
9 12 (0.83%) Maven
10 10 (0.69%) Toad
11 9 (0.62%) PVCS
11 9 (0.62%) Eclipse
11 9 (0.62%) PowerDesigner
11 9 (0.62%) MorphX
12 8 (0.55%) NuGet
12 8 (0.55%) Git (software)
13 6 (0.41%) Selenium
14 4 (0.28%) VSS/SourceSafe
15 3 (0.21%) Oracle APEX
General
1 417 (28.68%) Finance
2 137 (9.42%) Banking
3 66 (4.54%) Marketing
4 50 (3.44%) Investment Banking
5 46 (3.16%) Games
6 34 (2.34%) Advertising
6 34 (2.34%) Telecoms
7 33 (2.27%) Retail
8 29 (1.99%) Law
9 28 (1.93%) Front Office
10 19 (1.31%) Legal
11 11 (0.76%) Billing
12 9 (0.62%) Back Office
13 7 (0.48%) Music Industry
13 7 (0.48%) Publishing
14 6 (0.41%) Financial Institution
14 6 (0.41%) International Banking
15 5 (0.34%) General Ledger
15 5 (0.34%) Pharmaceutical
16 2 (0.14%) German Language
Job Titles
1 815 (56.05%) Developer
2 412 (28.34%) Business Intelligence Developer
3 190 (13.07%) SQL Developer
4 185 (12.72%) Analyst
5 151 (10.39%) Consultant
6 149 (10.25%) Business Developer
7 147 (10.11%) DBA
8 135 (9.28%) Senior Developer
9 91 (6.26%) Data Warehouse Developer
10 88 (6.05%) Business Intelligence Analyst
11 86 (5.91%) Business Intelligence Consultant
12 80 (5.50%) SQL Server Developer
13 74 (5.09%) Business Analyst
14 71 (4.88%) SQL DBA
15 69 (4.75%) Architect
16 61 (4.20%) Administrator
17 58 (3.99%) Senior Business Intelligence Developer
18 47 (3.23%) Database Developer
19 41 (2.82%) .NET Developer
20 37 (2.54%) Analyst Developer
Libraries, Frameworks & Software Standards
1 270 (18.57%) .NET
2 245 (16.85%) MDX
3 138 (9.49%) XML
4 99 (6.81%) ASP.NET
5 84 (5.78%) HTML
6 79 (5.43%) Web Services
7 66 (4.54%) CSS
8 36 (2.48%) ASP.NET MVC
9 35 (2.41%) WCF
10 30 (2.06%) jQuery
11 28 (1.93%) HTML5
12 24 (1.65%) Ajax
13 23 (1.58%) .NET Framework
14 21 (1.44%) Spring
15 20 (1.38%) CSS3
15 20 (1.38%) NHibernate
16 15 (1.03%) ADO.NET
16 15 (1.03%) WPF
16 15 (1.03%) ADO.NET Entity Framework
17 14 (0.96%) SOAP
Miscellaneous
1 272 (18.71%) Analytical Skills
2 101 (6.95%) Computer Science
3 89 (6.12%) Management Information System
4 85 (5.85%) Data Structures
5 66 (4.54%) Data Integration
6 65 (4.47%) Visualisation
7 60 (4.13%) Replication
8 54 (3.71%) Clustering
9 51 (3.51%) Mathematics
10 36 (2.48%) Statistics
11 25 (1.72%) Online Games
12 22 (1.51%) PMI
13 18 (1.24%) Data Extraction
13 18 (1.24%) iPad
14 17 (1.17%) Fixed Income
14 17 (1.17%) Hedge funds
14 17 (1.17%) Kindle
15 16 (1.10%) Credit Risk
15 16 (1.10%) Reference Data
15 16 (1.10%) GIS
Operating Systems
1 129 (8.87%) Windows
2 91 (6.26%) Linux
3 63 (4.33%) UNIX
4 21 (1.44%) Windows Server 2008
5 19 (1.31%) Windows Server 2003
6 18 (1.24%) Android
7 9 (0.62%) AIX
8 7 (0.48%) Oracle Linux
9 4 (0.28%) Windows Server 2012
9 4 (0.28%) Ubuntu
10 3 (0.21%) Solaris
10 3 (0.21%) MVS
11 2 (0.14%) CentOS
11 2 (0.14%) Red Hat Enterprise Linux
11 2 (0.14%) zOS
12 1 (0.069%) Windows 7
12 1 (0.069%) Apple iOS
Processes & Methodologies
1 1021 (70.22%) Business Intelligence
2 732 (50.34%) ETL
3 325 (22.35%) Data Modelling
4 316 (21.73%) Agile Software Development
5 180 (12.38%) Analytics
6 169 (11.62%) Kimball Methodology
7 156 (10.73%) Scrum
8 138 (9.49%) Dimensional Modelling
9 126 (8.67%) Performance Tuning
10 116 (7.98%) Project Management
11 115 (7.91%) Data Management
12 95 (6.53%) CRM
13 80 (5.50%) E-Commerce
14 69 (4.75%) Data Architecture
15 66 (4.54%) Unit Testing
16 58 (3.99%) Data Analysis
17 57 (3.92%) ERP
18 54 (3.71%) Business Analysis
19 53 (3.65%) Performance Management
20 51 (3.51%) MVC
Programming Languages
1 1006 (69.19%) SQL
2 411 (28.27%) T-SQL
3 211 (14.51%) C#
4 132 (9.08%) PL/SQL
5 94 (6.46%) Java
6 80 (5.50%) JavaScript
7 40 (2.75%) VBA
8 31 (2.13%) PowerShell
9 30 (2.06%) VB.NET
10 25 (1.72%) Shell Script
11 21 (1.44%) Data Analysis Expressions (DAX)
12 20 (1.38%) R
12 20 (1.38%) PHP
12 20 (1.38%) Python
13 17 (1.17%) VB
14 13 (0.89%) C
15 12 (0.83%) Data Mining Extensions (DMX)
16 9 (0.62%) Perl
16 9 (0.62%) X++
17 8 (0.55%) ActionScript
Qualifications
1 223 (15.34%) Degree
2 74 (5.09%) Microsoft Certification
3 28 (1.93%) MCDBA
4 22 (1.51%) PMI Certification
5 18 (1.24%) Security Cleared
5 18 (1.24%) MCAD
6 15 (1.03%) ACCA
7 12 (0.83%) Oracle Certification
7 12 (0.83%) MCSE
7 12 (0.83%) MCITP
8 10 (0.69%) MCSD
9 7 (0.48%) CIMA
10 5 (0.34%) ITIL Certification
11 3 (0.21%) MCSA
11 3 (0.21%) ISEB
11 3 (0.21%) SC Cleared
12 2 (0.14%) IIBA
12 2 (0.14%) SAS Certification
12 2 (0.14%) PhD
12 2 (0.14%) ISTQB
Quality Assurance & Compliance
1 68 (4.68%) QA
2 23 (1.58%) ISO 9001
3 14 (0.96%) SLA
4 6 (0.41%) Data Quality
4 6 (0.41%) PCI DSS
4 6 (0.41%) GAAP
5 5 (0.34%) HL7
6 4 (0.28%) ISO/IEC 27001
6 4 (0.28%) Sarbanes-Oxley
System Software
1 38 (2.61%) Oracle RAC
2 11 (0.76%) Active Directory
3 7 (0.48%) VMware Infrastructure
3 7 (0.48%) HDFS
4 5 (0.34%) Oracle RMAN
5 3 (0.21%) Hyper-V
6 2 (0.14%) Varnish
6 2 (0.14%) XenApp
6 2 (0.14%) XenDesktop
7 1 (0.069%) VMware ESX
Systems Management
1 31 (2.13%) Data Guard
2 7 (0.48%) Oracle Enterprise Manager
3 5 (0.34%) Opscode Chef
4 4 (0.28%) Foglight
5 2 (0.14%) SCCM
5 2 (0.14%) MAINVIEW
6 1 (0.069%) Tivoli
Vendors
1 522 (35.90%) Microsoft
2 396 (27.24%) Oracle
3 161 (11.07%) Cognos
4 139 (9.56%) Business Objects
5 116 (7.98%) IBM
6 83 (5.71%) Informatica
7 77 (5.30%) SAP
8 76 (5.23%) Tableau
9 73 (5.02%) MicroStrategy
10 53 (3.65%) Sybase
11 39 (2.68%) Netezza
12 36 (2.48%) Teradata
13 31 (2.13%) Talend
14 30 (2.06%) Hyperion
15 15 (1.03%) Ab Initio
16 13 (0.89%) DataSynapse
17 11 (0.76%) JD Edwards
18 10 (0.69%) VMware
18 10 (0.69%) Endeca
19 9 (0.62%) Serena
London
McGregor Boyall
Posted: 7 hours ago
Potters Bar, Hertfordshire
Understanding Recruitment
Salary: £40000 - £55000 per annum + Benefits
Posted: 8 hours ago
West London
Talent International
Salary: £50000.00 - £55000.00 per annum
Posted: 16 hours ago
Central London / West End
X4 Group
Salary: £30k - 40k per year
Posted: 19 hours ago
London
TEKsystems
Salary: £75000 - £85000 per annum + Excellent Bonus + Benefits
Posted: 20 hours ago
Birmingham, West Midlands (County)
X4 Group
Salary: £25k - 35k per year
Posted: Yesterday
Manchester, Lancashire
Circle Recruitment
Salary: £28000 - £35000 per annum + Bonus + Benefits
Posted: Yesterday
Cardiff, South Glamorgan
Opus Recruitment Solutions Ltd
Salary: £35000 to £40000 per annum
Posted: Yesterday
Petersfield, Hampshire
Evolution Recruitment Solutions
Salary: c35k+Bens
Posted: Yesterday
Aberdeen, Aberdeenshire
Informatiq Consulting
Salary: Excellent salary
Posted: Yesterday
West Yorkshire
ReThink Recruitment
Salary: negotiable, generous benefits
Posted: Yesterday
North London
Deerfoot IT Resources Ltd
Salary: £45000 - £50000 per annum + 23 days holiday, pension scheme
Posted: Yesterday
London
Nexere Consulting Limited
Salary: Excellent Benefits
Posted: Yesterday
West Midlands
ReThink Recruitment
Salary: £40000.00 - £45000.00 per annum + BENEFITS
Posted: Yesterday
Bristol, Avon
Redrock Consulting Ltd
Salary: £50000 - £70000 per annum + Benefits
Posted: Yesterday
Leeds, West Yorkshire
Staffline Group PLC
Salary: £25000 - £45000 per annum + Basic salary negotiable + OTE
Posted: 3 days ago
Nottingham, Nottinghamshire
Exposed Solutions
Salary: £40000 to £50000 per annum
Posted: 4 days ago
London
Technology Leaders
Salary: + benefits
Posted: 4 days ago
City, London
Quant Capital
Salary: Up to £100,000 per annum Bonus Medical Pension (8%)
Posted: 4 days ago
Wokingham, Berkshire
Coneqt
Salary: From £45,000 to £48,000 per annum
Posted: 4 days ago