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

Location
3 months to
22 Aug 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 379 411 299
Rank change year-on-year
+32 -112
Permanent jobs citing OLAP 774 605 979
As % of all permanent IT jobs located in the UK 0.66% 0.56% 0.84%
As % of the Database & Business Intelligence category 2.14% 1.77% 2.70%
Number of salaries quoted 659 519 866
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 £72,500 £70,000 £67,500
UK excluding London average salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +6.25%

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
36164 34220 36263
As % of all permanent IT jobs located in the UK 30.87% 31.48% 30.95%
Number of salaries quoted 30535 29567 31917
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 £70,000 £65,000 £65,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 22 August 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 22 August 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 +43 727 £52,000 +4.00% 91
London +66 429 £55,000 - 49
City of London +56 144 £60,000 - 21
South East +10 114 £50,750 +12.77% 14
West Midlands +41 68 £40,000 +9.58% 3
Staffordshire +33 46 £40,000 +14.28%
East of England +19 37 £40,500 +24.61% 8
Yorkshire -44 34 £42,500 +13.33% 6
West Yorkshire -38 27 £42,500 +13.33% 4
North West -39 24 £45,000 -5.26% 12
Berkshire -14 23 £55,000 - 6
Surrey +18 22 £51,000 +13.33% 5
Cambridgeshire +17 22 £40,500 -10.00% 2
Cardiff +13 22 £37,500 +36.36% 3
Wales +12 22 £37,500 +15.38% 3
South Wales +8 22 £37,500 +15.38% 3
Hampshire +5 20 £31,250 -26.47% 1
West Sussex +8 18 £75,000 +36.36% 1
Manchester -27 17 £47,500 - 10
Crawley - 16 £75,000 - 1
Southampton - 16 £31,250 -
Bradford +11 15 £43,000 +14.66% 2
Burton-upon-Trent +3 15 £40,000 +14.28%
South West -17 13 £45,000 -5.26%
Reading +10 12 £55,000 - 2
Kent -10 12 £42,500 -4.49%
Warwickshire +18 10 £38,000 -12.64%
Peterborough - 10 £40,500 -
Scotland -39 9 £68,250 +26.38%
Suffolk - 9 £40,000 - 1

OLAP
Top 30 Related IT Skills

For the 6 months to 22 August 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 1048 (71.05%) Business Intelligence
2 1025 (69.49%) SQL
3 1003 (68.00%) SQL Server
4 871 (59.05%) Data Warehouse
5 790 (53.56%) SQL Server Integration Services
6 757 (51.32%) SQL Server Reporting Services
7 755 (51.19%) SQL Server Analysis Services
8 750 (50.85%) ETL
9 544 (36.88%) Microsoft
10 438 (29.69%) T-SQL
11 415 (28.14%) Finance
12 391 (26.51%) SQL Server 2008
13 388 (26.31%) MS Excel
14 360 (24.41%) Oracle
15 358 (24.27%) Oracle OLAP
16 313 (21.22%) Data Modelling
17 289 (19.59%) MDX
18 286 (19.39%) .NET
19 219 (14.85%) C#
19 219 (14.85%) SQL Server 2012
20 213 (14.44%) Relational Database
21 208 (14.10%) Degree
22 205 (13.90%) Microsoft Analysis Services
23 200 (13.56%) OLTP
24 194 (13.15%) Analytics
25 178 (12.07%) Dimensional Modelling
26 176 (11.93%) SharePoint
27 169 (11.46%) Cognos
28 167 (11.32%) SQL Server 2005
28 167 (11.32%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 22 August 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 176 (11.93%) SharePoint
2 62 (4.20%) SAS
3 40 (2.71%) IIS
4 31 (2.10%) BizTalk Server
5 24 (1.63%) Tomcat
6 20 (1.36%) WebSphere
7 17 (1.15%) SharePoint 2010
8 15 (1.02%) Apache
9 11 (0.75%) Oracle Application Server
10 10 (0.68%) Oracle Workflow
11 9 (0.61%) Oracle 10gAS
12 8 (0.54%) SharePoint Server
12 8 (0.54%) WebLogic
13 6 (0.41%) Apache Solr
13 6 (0.41%) Oracle Coherence
14 4 (0.27%) NetWeaver
15 3 (0.20%) MS Exchange
15 3 (0.20%) FileNet
16 2 (0.14%) ColdFusion
16 2 (0.14%) Blackberry Enterprise Server
Applications
1 388 (26.31%) MS Excel
2 92 (6.24%) MS Office
3 59 (4.00%) PowerPivot
4 42 (2.85%) MS Project
5 21 (1.42%) MS PowerPoint
6 14 (0.95%) SPSS
6 14 (0.95%) Spreadsheet
7 10 (0.68%) MS Visio
8 7 (0.47%) S-PLUS
9 6 (0.41%) FastStats
10 3 (0.20%) Stata
Business Applications
1 60 (4.07%) Cognos TM1
2 54 (3.66%) Cognos Business Intelligence
3 16 (1.08%) Dynamics AX
4 15 (1.02%) HFM
5 13 (0.88%) Dynamics CRM
6 9 (0.61%) Oracle EBS
7 8 (0.54%) Hyperion Planning
8 7 (0.47%) Summit
9 5 (0.34%) Google Analytics
10 4 (0.27%) Dynamics NAV
10 4 (0.27%) Line 500
10 4 (0.27%) Oracle General Ledger
11 3 (0.20%) Cognos Planning
11 3 (0.20%) SAP Oil and Gas
12 2 (0.14%) Oracle CRM
12 2 (0.14%) Oracle ERP
12 2 (0.14%) Adaptiv
12 2 (0.14%) Cognos Controller
12 2 (0.14%) Oracle Financials
12 2 (0.14%) Magento
Cloud Services
1 11 (0.75%) Office 365
2 10 (0.68%) SaaS
3 9 (0.61%) Amazon EC2
4 6 (0.41%) Microsoft Azure
4 6 (0.41%) Amazon AWS
5 1 (0.068%) Cloud Computing
Communications & Networking
1 36 (2.44%) Intranet
2 22 (1.49%) Internet
3 13 (0.88%) SAN
4 10 (0.68%) ATM
5 8 (0.54%) Extranet
6 6 (0.41%) DNS
6 6 (0.41%) DMZ
7 5 (0.34%) LAN
7 5 (0.34%) WAN
8 4 (0.27%) Firewall
8 4 (0.27%) Fibre Channel
8 4 (0.27%) iSCSI
9 3 (0.20%) InfiniBand
9 3 (0.20%) NAS
9 3 (0.20%) FCoE
9 3 (0.20%) Broadband
9 3 (0.20%) Ethernet
9 3 (0.20%) FTP
9 3 (0.20%) LDAP
10 2 (0.14%) Wi-Fi
Database & Business Intelligence
1 1003 (68.00%) SQL Server
2 871 (59.05%) Data Warehouse
3 790 (53.56%) SQL Server Integration Services
4 757 (51.32%) SQL Server Reporting Services
5 755 (51.19%) SQL Server Analysis Services
6 391 (26.51%) SQL Server 2008
7 358 (24.27%) Oracle OLAP
8 219 (14.85%) SQL Server 2012
9 213 (14.44%) Relational Database
10 205 (13.90%) Microsoft Analysis Services
11 200 (13.56%) OLTP
12 167 (11.32%) SQL Server 2005
13 159 (10.78%) RDBMS
14 133 (9.02%) Oracle Database
15 114 (7.73%) Data Mining
16 108 (7.32%) Big Data
17 105 (7.12%) MySQL
18 71 (4.81%) DTS
19 68 (4.61%) Star Schema
20 63 (4.27%) DB2
Development Applications
1 54 (3.66%) Team Foundation Server
2 50 (3.39%) Visual Studio
3 28 (1.90%) Talend Open Studio
4 20 (1.36%) JUnit
4 20 (1.36%) SQL Server Management Studio (SSMS)
5 18 (1.22%) ERwin
6 17 (1.15%) Eclipse
7 15 (1.02%) Visual Studio Team System
7 15 (1.02%) Maven
8 13 (0.88%) Oracle Forms
9 11 (0.75%) Subversion
10 9 (0.61%) MorphX
10 9 (0.61%) Git (software)
10 9 (0.61%) PVCS
11 8 (0.54%) Selenium
12 7 (0.47%) NuGet
12 7 (0.47%) Oracle APEX
13 6 (0.41%) PowerDesigner
14 4 (0.27%) Toad
15 3 (0.20%) WiX
General
1 415 (28.14%) Finance
2 132 (8.95%) Banking
3 67 (4.54%) Marketing
4 61 (4.14%) Investment Banking
5 56 (3.80%) Games
6 52 (3.53%) Advertising
6 52 (3.53%) Retail
7 42 (2.85%) Telecoms
8 24 (1.63%) Law
9 23 (1.56%) Front Office
10 17 (1.15%) Legal
11 12 (0.81%) Billing
12 11 (0.75%) Back Office
12 11 (0.75%) Publishing
13 10 (0.68%) Pharmaceutical
14 8 (0.54%) Financial Institution
15 7 (0.47%) Music Industry
16 6 (0.41%) International Banking
16 6 (0.41%) German Language
17 5 (0.34%) French Language
Job Titles
1 808 (54.78%) Developer
2 391 (26.51%) Business Intelligence Developer
3 218 (14.78%) SQL Developer
4 173 (11.73%) Analyst
5 155 (10.51%) Consultant
6 150 (10.17%) DBA
7 146 (9.90%) Business Developer
8 122 (8.27%) Senior Developer
9 98 (6.64%) Data Warehouse Developer
10 90 (6.10%) SQL Server Developer
11 89 (6.03%) Business Intelligence Consultant
12 86 (5.83%) Architect
13 77 (5.22%) SQL DBA
14 75 (5.08%) Business Intelligence Analyst
15 64 (4.34%) Administrator
16 52 (3.53%) Business Analyst
17 46 (3.12%) SQL Server DBA
18 45 (3.05%) Microsoft Developer
19 42 (2.85%) Development Manager
20 41 (2.78%) Database Developer
Libraries, Frameworks & Software Standards
1 289 (19.59%) MDX
2 286 (19.39%) .NET
3 152 (10.31%) XML
4 102 (6.92%) ASP.NET
5 88 (5.97%) Web Services
6 76 (5.15%) HTML
7 65 (4.41%) CSS
8 29 (1.97%) ASP.NET MVC
9 28 (1.90%) jQuery
10 25 (1.69%) Ajax
10 25 (1.69%) Spring
11 24 (1.63%) WCF
12 23 (1.56%) .NET Framework
13 21 (1.42%) NHibernate
14 20 (1.36%) HTML5
14 20 (1.36%) OOXML
15 18 (1.22%) WPF
16 17 (1.15%) CSS3
17 15 (1.02%) ADO.NET Entity Framework
18 14 (0.95%) ADO.NET
Miscellaneous
1 100 (6.78%) Computer Science
2 88 (5.97%) Management Information System
3 77 (5.22%) Replication
4 63 (4.27%) Data Integration
5 60 (4.07%) Clustering
6 53 (3.59%) Visualisation
7 40 (2.71%) Mathematics
8 35 (2.37%) Statistics
9 24 (1.63%) Online Games
10 23 (1.56%) Enterprise Software
11 21 (1.42%) Data Extraction
12 20 (1.36%) GIS
12 20 (1.36%) PMI
12 20 (1.36%) Credit Risk
13 16 (1.08%) iPad
14 15 (1.02%) Hedge funds
14 15 (1.02%) Kindle
14 15 (1.02%) Fixed Income
15 14 (0.95%) Open Source
16 13 (0.88%) Data Conversion
Operating Systems
1 150 (10.17%) Windows
2 100 (6.78%) Linux
3 58 (3.93%) UNIX
4 27 (1.83%) Windows Server 2008
5 17 (1.15%) Windows Server 2003
6 16 (1.08%) Android
7 11 (0.75%) AIX
8 6 (0.41%) Oracle Linux
9 4 (0.27%) Ubuntu
9 4 (0.27%) Solaris
10 3 (0.20%) Red Hat Enterprise Linux
11 2 (0.14%) Apple iOS
11 2 (0.14%) CentOS
12 1 (0.068%) Windows 7
12 1 (0.068%) VMS
Processes & Methodologies
1 1048 (71.05%) Business Intelligence
2 750 (50.85%) ETL
3 313 (21.22%) Data Modelling
4 194 (13.15%) Analytics
5 178 (12.07%) Dimensional Modelling
6 167 (11.32%) Kimball Methodology
7 159 (10.78%) Performance Tuning
8 155 (10.51%) Agile Software Development
9 141 (9.56%) Scrum
10 131 (8.88%) Project Management
11 121 (8.20%) Data Management
12 87 (5.90%) Business Analysis
13 84 (5.69%) E-Commerce
14 80 (5.42%) Data Architecture
15 77 (5.22%) CRM
16 73 (4.95%) Data Analysis
17 59 (4.00%) OO
18 58 (3.93%) Performance Management
19 57 (3.86%) Unit Testing
20 54 (3.66%) Change Management
Programming Languages
1 1025 (69.49%) SQL
2 438 (29.69%) T-SQL
3 219 (14.85%) C#
4 109 (7.39%) Java
4 109 (7.39%) PL/SQL
5 70 (4.75%) JavaScript
6 42 (2.85%) VBA
7 28 (1.90%) Python
7 28 (1.90%) VB.NET
7 28 (1.90%) PowerShell
8 27 (1.83%) Data Mining Extensions (DMX)
9 24 (1.63%) Shell Script
10 22 (1.49%) VB
11 21 (1.42%) PHP
12 17 (1.15%) Data Analysis Expressions (DAX)
13 16 (1.08%) C
13 16 (1.08%) R
14 10 (0.68%) Perl
15 9 (0.61%) X++
16 6 (0.41%) C++
Qualifications
1 208 (14.10%) Degree
2 92 (6.24%) Microsoft Certification
3 28 (1.90%) MCITP
4 27 (1.83%) MCDBA
5 25 (1.69%) MCAD
6 22 (1.49%) PMI Certification
7 19 (1.29%) Security Cleared
8 13 (0.88%) Oracle Certification
9 12 (0.81%) MCTS
10 11 (0.75%) ITIL Certification
11 10 (0.68%) ACCA
12 9 (0.61%) CIMA
13 7 (0.47%) MCSD
14 6 (0.41%) MCSE
15 3 (0.20%) PhD
15 3 (0.20%) MCSA
15 3 (0.20%) HND
16 2 (0.14%) MBA
16 2 (0.14%) ISTQB
16 2 (0.14%) ISEB
Quality Assurance & Compliance
1 70 (4.75%) QA
2 22 (1.49%) ISO 9001
3 18 (1.22%) SLA
4 14 (0.95%) PCI DSS
5 8 (0.54%) Data Quality
6 6 (0.41%) TickIT
6 6 (0.41%) GAAP
7 5 (0.34%) HL7
8 4 (0.27%) ISO/IEC 27001
8 4 (0.27%) Sarbanes-Oxley
System Software
1 31 (2.10%) Oracle RAC
2 8 (0.54%) VMware Infrastructure
3 6 (0.41%) Oracle RMAN
3 6 (0.41%) Active Directory
3 6 (0.41%) HDFS
4 3 (0.20%) Hyper-V
5 2 (0.14%) VMware ESX
5 2 (0.14%) XenApp
5 2 (0.14%) XenDesktop
Systems Management
1 30 (2.03%) 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
6 1 (0.068%) Red Hat Spacewalk
6 1 (0.068%) OSSEC
6 1 (0.068%) Puppet
6 1 (0.068%) Tivoli
6 1 (0.068%) Nagios
Vendors
1 544 (36.88%) Microsoft
2 360 (24.41%) Oracle
3 169 (11.46%) Cognos
4 125 (8.47%) IBM
5 124 (8.41%) Business Objects
6 75 (5.08%) MicroStrategy
7 74 (5.02%) SAP
8 71 (4.81%) Informatica
9 52 (3.53%) Tableau
10 51 (3.46%) Sybase
11 44 (2.98%) Netezza
12 37 (2.51%) Teradata
13 28 (1.90%) Talend
14 25 (1.69%) Dundas
15 18 (1.22%) Hyperion
16 17 (1.15%) Vertica
17 13 (0.88%) Red Gate
18 12 (0.81%) VMware
18 12 (0.81%) Sun
19 9 (0.61%) HP
Manchester, Lancashire
Experis Ltd
Salary: £60000 - £80000 per annum + excellent benefits
Posted: 16 hours ago
Manchester, Lancashire
SearchBi
Salary: Up to £45,000 per annum plus bens
Posted: 16 hours ago
London
SearchBi
Salary: From £40,000 to £45,000 per annum plus great benefits
Posted: 16 hours ago
South East
Venturi
Salary: £50000 - £85000 per annum + 15% bonus + Benefits
Posted: 17 hours ago
London
Connectus
Salary: £45000 - £55000 per annum
Posted: 17 hours ago
Sutton, Surrey
Reed Business Information Ltd
Salary: From £45,000 to £55,000 per annum + 29 days + Share Ops + Pension + mo
Posted: 19 hours ago
Epsom, Surrey
Acuro (MaxAd Ltd)
Salary: £55000.00 - £65000.00 per annum
Posted: 21 hours ago
London
Austin Fraser
Salary: £40000.00 - £50000.00 per annum + Bens
Posted: Yesterday
Surrey
Venturi
Salary: £60000 - £70000.00 per annum + bonus & full benefits
Posted: Yesterday
London
Vertical IT
Salary: £45000 - £70000 per annum + Benefits
Posted: Yesterday
Manchester, Lancashire
Adria Solutions Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: Yesterday
Manchester, Lancashire
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: Yesterday
UK
ANSON MCCADE
Salary: From £60,000 to £80,000 per annum + attractive benefits and extensive
Posted: Yesterday
UK
ANSON MCCADE
Salary: From £40,000 to £65,000 per annum plus attractive benefits and extensi
Posted: Yesterday
UK
ANSON MCCADE
Salary: From £35,000 to £65,000 per annum + attractive benefits and extensive
Posted: Yesterday
London
ComputerWorld Personnel Ltd
Salary: £40000 - £48000 per annum + bonus
Posted: Yesterday
City, London
Quant Capital
Salary: Up to £90,000 per annum 10% Bonus
Posted: Yesterday
Teddington, Middlesex
Bluetownonline
Salary: £60k - 70k per year
Posted: Yesterday
City, London
Oliver James Associates
Salary: £45000 - £50000 per annum + Bonus + Benefits package
Posted: 2 days ago
London
I3
Salary: £38000 - £48000 per annum
Posted: 2 days ago