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

Location
3 months to
6 Jul 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 450 408 414
Rank change year-on-year
-42 +6
Permanent jobs citing OLAP 559 736 614
As % of all permanent IT jobs located in the UK 0.51% 0.62% 0.57%
As % of the Database & Business Intelligence category 1.62% 2.00% 1.80%
Number of salaries quoted 444 629 532
Average salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,500 £35,000 £32,500
10% offered a salary of more than £72,500 £70,000 £70,000
UK excluding London average salary £40,000 £44,000 £45,000
% change year-on-year
-9.09% -2.22%

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
34463 36769 34160
As % of all permanent IT jobs located in the UK 31.54% 31.22% 31.50%
Number of salaries quoted 29078 31563 29608
Average salary £47,500 £45,000 £42,500
Average salary % change year-on-year
+5.55% +5.88%
90% offered a salary of more than £32,000 £30,000 £30,000
10% offered a salary of more than £70,000 £65,000 £70,000
UK excluding London average salary £42,000 £40,000 £38,500
% change year-on-year
+5.00% +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 6 July 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 6 July 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 -41 520 £50,000 - 112
London -85 231 £60,000 +9.09% 47
South East +7 125 £38,000 -24.00% 13
City of London -18 57 £60,000 +3.44% 18
Yorkshire +19 46 £40,000 +14.28% 13
Kent +27 35 £32,500 -27.77%
West Midlands -28 33 £40,000 - 9
West Yorkshire +26 27 £45,000 +2.27% 11
Hampshire -2 25 £37,500 -6.25% 3
Berkshire +5 24 £54,000 -1.81% 6
Maidstone - 24 £32,500 -
Scotland +22 23 £41,750 -7.22% 4
North West +3 22 £40,000 -5.88% 11
Leeds +26 21 £42,500 -3.40% 9
East of England -8 21 £43,750 +4.16% 4
South West -4 16 £47,500 +5.55% 10
Birmingham +8 14 £55,000 - 7
East Midlands +3 14 £40,000 -23.80% 3
North Yorkshire -2 14 £32,000 -5.18%
Manchester +10 13 £40,000 -11.11% 11
Cambridgeshire +12 12 £32,500 -19.75% 2
York +10 12 £32,000 -8.57%
West Sussex +5 12 £43,000 -42.66% 1
Staffordshire -9 12 £36,750 -8.12% 1
Oxfordshire +15 11 £40,000 -22.33%
Oxford 0 11 £40,000 -22.33%
Midlands -3 11 £50,000 +11.11%
Derbyshire +6 10 £40,000 -27.27% 1
Surrey -4 10 £46,250 -11.05% 1
Stirling +3 8 - -

OLAP
Top 30 Related IT Skills

For the 6 months to 6 July 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 845 (74.58%) Business Intelligence
2 785 (69.29%) SQL
3 667 (58.87%) SQL Server
4 647 (57.11%) Data Warehouse
5 602 (53.13%) ETL
6 570 (50.31%) SQL Server Integration Services
7 503 (44.40%) SQL Server Reporting Services
8 468 (41.31%) SQL Server Analysis Services
9 417 (36.80%) Microsoft
10 377 (33.27%) Oracle
11 347 (30.63%) Finance
12 343 (30.27%) Oracle OLAP
13 313 (27.63%) Data Modelling
14 311 (27.45%) OLAP Cube
15 309 (27.27%) T-SQL
16 242 (21.36%) Agile Software Development
17 233 (20.56%) MS Excel
18 220 (19.42%) Analytics
19 209 (18.45%) Analytical Skills
20 185 (16.33%) SQL Server 2008
21 181 (15.98%) Oracle Database
22 166 (14.65%) Degree
23 163 (14.39%) Performance Tuning
24 160 (14.12%) MDX
25 151 (13.33%) OLTP
26 146 (12.89%) PL/SQL
27 134 (11.83%) Relational Database
28 132 (11.65%) Kimball Methodology
29 123 (10.86%) Tableau
30 121 (10.68%) SQL Server 2012

OLAP
Top Related IT Skills by Category

For the 6 months to 6 July 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 95 (8.38%) SharePoint
2 84 (7.41%) SAS
3 44 (3.88%) IIS
4 39 (3.44%) Apache
5 34 (3.00%) WebLogic
6 28 (2.47%) Tomcat
7 18 (1.59%) BizTalk Server
8 17 (1.50%) SharePoint 2010
9 16 (1.41%) WebSphere
10 15 (1.32%) Oracle HTTP Server
11 13 (1.15%) JBoss
12 11 (0.97%) Oracle Workflow
12 11 (0.97%) Oracle Coherence
12 11 (0.97%) Apache Spark
13 10 (0.88%) SharePoint 2013
14 5 (0.44%) Drupal
14 5 (0.44%) ColdFusion
15 4 (0.35%) WebSphere Application Server
16 3 (0.26%) IBM HTTP Server
16 3 (0.26%) WebSphere Process Server
Applications
1 233 (20.56%) MS Excel
2 67 (5.91%) PowerPivot
3 38 (3.35%) SPSS
4 17 (1.50%) MS Visio
4 17 (1.50%) MS Office
5 6 (0.53%) MS Project
6 2 (0.18%) MS PowerPoint
6 2 (0.18%) Spreadsheet
7 1 (0.088%) FastStats
7 1 (0.088%) Gephi
Business Applications
1 33 (2.91%) Oracle ERP
2 29 (2.56%) HFM
3 22 (1.94%) Oracle EBS
4 17 (1.50%) Dynamics CRM
5 16 (1.41%) Cognos TM1
6 12 (1.06%) Cognos Business Intelligence
6 12 (1.06%) Oracle EBS R12
7 11 (0.97%) Dynamics AX
7 11 (0.97%) RMDS
8 9 (0.79%) Hyperion Planning
9 8 (0.71%) Oracle Applications
10 6 (0.53%) Dynamics NAV
11 5 (0.44%) SAP BPC
12 3 (0.26%) SAP Oil and Gas
13 2 (0.18%) Cognos Controller
13 2 (0.18%) Oracle Financials
13 2 (0.18%) WebTrends
13 2 (0.18%) Unica
13 2 (0.18%) ION MarketView
14 1 (0.088%) Siebel Analytics
Cloud Services
1 15 (1.32%) Amazon AWS
2 12 (1.06%) Microsoft Azure
3 8 (0.71%) Cloud Computing
4 2 (0.18%) Google Analytics
4 2 (0.18%) SmartFocus
4 2 (0.18%) Adobe Analytics
5 1 (0.088%) SaaS
Communications & Networking
1 21 (1.85%) HTTP
2 18 (1.59%) SAN
2 18 (1.59%) NAS
3 13 (1.15%) LAN
3 13 (1.15%) WAN
4 12 (1.06%) FCoE
4 12 (1.06%) Fibre Channel
4 12 (1.06%) Multicast
5 10 (0.88%) LDAP
6 8 (0.71%) DNS
6 8 (0.71%) Internet
7 6 (0.53%) Cisco IOS
7 6 (0.53%) iSCSI
8 5 (0.44%) TCP/IP
9 4 (0.35%) WebEx
10 3 (0.26%) DMZ
10 3 (0.26%) Intranet
10 3 (0.26%) Firewall
10 3 (0.26%) BIG-IP
10 3 (0.26%) F5 BIG-IP LTM
Database & Business Intelligence
1 667 (58.87%) SQL Server
2 647 (57.11%) Data Warehouse
3 570 (50.31%) SQL Server Integration Services
4 503 (44.40%) SQL Server Reporting Services
5 468 (41.31%) SQL Server Analysis Services
6 343 (30.27%) Oracle OLAP
7 311 (27.45%) OLAP Cube
8 185 (16.33%) SQL Server 2008
9 181 (15.98%) Oracle Database
10 151 (13.33%) OLTP
11 134 (11.83%) Relational Database
12 121 (10.68%) SQL Server 2012
13 114 (10.06%) Big Data
13 114 (10.06%) Data Mining
14 111 (9.80%) QlikView
15 109 (9.62%) Oracle BI EE
16 94 (8.30%) Oracle Database 11g
16 94 (8.30%) Hadoop
17 90 (7.94%) Oracle Reports
18 79 (6.97%) Microsoft Analysis Services
Development Applications
1 29 (2.56%) Toad
1 29 (2.56%) Team Foundation Server
2 18 (1.59%) Subversion
3 17 (1.50%) PowerDesigner
4 14 (1.24%) Oracle Forms
4 14 (1.24%) Visual Studio
5 11 (0.97%) TeamCity
5 11 (0.97%) SQL Server Management Studio (SSMS)
6 9 (0.79%) Talend Open Studio
7 8 (0.71%) Maven
8 6 (0.53%) VSS/SourceSafe
8 6 (0.53%) Ant
9 4 (0.35%) NUnit
9 4 (0.35%) Git (software)
9 4 (0.35%) Moq
10 3 (0.26%) MSBuild
10 3 (0.26%) JIRA
11 2 (0.18%) CruiseControl
11 2 (0.18%) ClearQuest
11 2 (0.18%) JUnit
General
1 347 (30.63%) Finance
2 76 (6.71%) Banking
3 65 (5.74%) Retail
4 57 (5.03%) Marketing
5 35 (3.09%) Front Office
6 27 (2.38%) Investment Banking
7 26 (2.29%) Telecoms
8 21 (1.85%) Advertising
9 19 (1.68%) Legal
10 13 (1.15%) Games
11 12 (1.06%) Manufacturing
12 11 (0.97%) Law
13 10 (0.88%) Back Office
14 7 (0.62%) Automotive
15 6 (0.53%) Billing
16 5 (0.44%) General Ledger
17 3 (0.26%) Publishing
17 3 (0.26%) Electronics
17 3 (0.26%) Pharmaceutical
18 2 (0.18%) Financial Institution
Job Titles
1 591 (52.16%) Developer
2 304 (26.83%) Business Intelligence Developer
3 168 (14.83%) Analyst
4 159 (14.03%) Consultant
5 125 (11.03%) Business Intelligence Consultant
6 121 (10.68%) Senior Developer
7 118 (10.41%) SQL Developer
8 104 (9.18%) Business Developer
9 85 (7.50%) Architect
10 78 (6.88%) DBA
11 69 (6.09%) Business Intelligence Analyst
12 57 (5.03%) Analyst Developer
13 54 (4.77%) MI Analyst
14 53 (4.68%) SQL DBA
15 52 (4.59%) Oracle Developer
16 51 (4.50%) Business Consultant
17 45 (3.97%) Business Analyst
18 44 (3.88%) Microsoft Consultant
18 44 (3.88%) Microsoft BI Consultant
19 38 (3.35%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 160 (14.12%) MDX
2 119 (10.50%) .NET
3 88 (7.77%) XML
4 64 (5.65%) Web Services
5 57 (5.03%) HTML
6 45 (3.97%) ASP.NET
7 36 (3.18%) CSS
8 23 (2.03%) Middleware
9 22 (1.94%) Hibernate
10 21 (1.85%) ASP.NET MVC
11 20 (1.77%) HTML5
11 20 (1.77%) JMS
12 19 (1.68%) Ajax
12 19 (1.68%) XSLT
12 19 (1.68%) JPA
13 17 (1.50%) Spring
14 15 (1.32%) J2EE
14 15 (1.32%) jQuery
15 14 (1.24%) WCF
15 14 (1.24%) XSL
Miscellaneous
1 209 (18.45%) Analytical Skills
2 105 (9.27%) Visualisation
3 79 (6.97%) Data Integration
4 69 (6.09%) Computer Science
5 68 (6.00%) Data Structures
6 66 (5.83%) Management Information System
7 48 (4.24%) Replication
8 37 (3.27%) Statistics
9 31 (2.74%) Data Conversion
10 26 (2.29%) Enterprise Software
11 21 (1.85%) Mathematics
12 17 (1.50%) Data Extraction
12 17 (1.50%) Clustering
12 17 (1.50%) N-Tier
12 17 (1.50%) Hedge funds
13 15 (1.32%) Oracle Exalogic
14 13 (1.15%) Economics
15 9 (0.79%) Oracle Exalytics
16 8 (0.71%) Cybercrime
17 6 (0.53%) Reference Data
Operating Systems
1 96 (8.47%) UNIX
2 93 (8.21%) Windows
3 75 (6.62%) Linux
4 9 (0.79%) Android
4 9 (0.79%) Solaris
5 7 (0.62%) Windows Server 2008
6 4 (0.35%) Red Hat Enterprise Linux
6 4 (0.35%) Apple iOS
6 4 (0.35%) Windows Server 2012
7 3 (0.26%) SUSE Linux Enterprise Server
7 3 (0.26%) CentOS
7 3 (0.26%) AIX
7 3 (0.26%) SUSE
7 3 (0.26%) Debian
7 3 (0.26%) Ubuntu
8 1 (0.088%) Windows NT
8 1 (0.088%) Windows XP
8 1 (0.088%) Windows Server 2003
8 1 (0.088%) Windows 7
8 1 (0.088%) Windows 8
Processes & Methodologies
1 845 (74.58%) Business Intelligence
2 602 (53.13%) ETL
3 313 (27.63%) Data Modelling
4 242 (21.36%) Agile Software Development
5 220 (19.42%) Analytics
6 163 (14.39%) Performance Tuning
7 132 (11.65%) Kimball Methodology
8 102 (9.00%) Data Analysis
9 94 (8.30%) Project Management
10 83 (7.33%) ERP
11 80 (7.06%) Scrum
12 79 (6.97%) Data Architecture
13 69 (6.09%) Data Management
14 60 (5.30%) Dimensional Modelling
15 58 (5.12%) Dashboard Development
16 56 (4.94%) CRM
17 55 (4.85%) OO
18 53 (4.68%) ETL Development
19 46 (4.06%) Data Mapping
20 45 (3.97%) Master Data Management
Programming Languages
1 785 (69.29%) SQL
2 309 (27.27%) T-SQL
3 146 (12.89%) PL/SQL
4 118 (10.41%) Java
5 117 (10.33%) C#
6 66 (5.83%) JavaScript
7 60 (5.30%) Shell Script
8 44 (3.88%) VBA
9 29 (2.56%) R
10 27 (2.38%) PowerShell
11 21 (1.85%) Python
12 17 (1.50%) VB
12 17 (1.50%) VB.NET
13 15 (1.32%) C
14 12 (1.06%) ANSI SQL
15 10 (0.88%) Data Analysis Expressions (DAX)
16 6 (0.53%) X++
17 5 (0.44%) ActionScript
18 4 (0.35%) Bash Shell
18 4 (0.35%) Perl
Qualifications
1 166 (14.65%) Degree
2 25 (2.21%) Microsoft Certification
3 20 (1.77%) Security Cleared
3 20 (1.77%) Oracle Certification
4 19 (1.68%) OCP
5 15 (1.32%) SC Cleared
6 9 (0.79%) MCDBA
7 7 (0.62%) MCITP
8 5 (0.44%) PMI Certification
9 4 (0.35%) IBM Certification
9 4 (0.35%) HND
10 3 (0.26%) MCP
11 2 (0.18%) MCAD
11 2 (0.18%) PhD
11 2 (0.18%) MBA
11 2 (0.18%) PMP
12 1 (0.088%) MCSD
12 1 (0.088%) MCSE
Quality Assurance & Compliance
1 36 (3.18%) QA
2 5 (0.44%) SLA
2 5 (0.44%) ISO/IEC 27001
3 4 (0.35%) Data Quality
4 2 (0.18%) PCI DSS
5 1 (0.088%) Sarbanes-Oxley
System Software
1 17 (1.50%) Oracle RAC
1 17 (1.50%) VMware Infrastructure
2 12 (1.06%) NFS
2 12 (1.06%) SRDF
3 6 (0.53%) Active Directory
4 4 (0.35%) VMware ESX
5 3 (0.26%) Xen
5 3 (0.26%) XenServer
5 3 (0.26%) VMware Server
5 3 (0.26%) vSphere
5 3 (0.26%) VMware ESXi
5 3 (0.26%) pfSense
5 3 (0.26%) KVM
6 2 (0.18%) Varnish
7 1 (0.088%) Docker
7 1 (0.088%) HDFS
Systems Management
1 4 (0.35%) SCCM
2 2 (0.18%) Data Guard
2 2 (0.18%) Oracle RMAN
Vendors
1 417 (36.80%) Microsoft
2 377 (33.27%) Oracle
3 123 (10.86%) Tableau
4 108 (9.53%) Business Objects
5 106 (9.36%) Informatica
6 104 (9.18%) Cognos
7 95 (8.38%) SAP
8 89 (7.86%) IBM
9 68 (6.00%) Hyperion
10 50 (4.41%) MicroStrategy
11 45 (3.97%) Teradata
12 42 (3.71%) Ab Initio
13 31 (2.74%) Sybase
14 30 (2.65%) DataFlux
15 27 (2.38%) Vertica
16 23 (2.03%) Netezza
17 18 (1.59%) Cisco
18 17 (1.50%) VMware
19 16 (1.41%) Hitachi
20 13 (1.15%) NetApp
City, London
Oscar Associates (UK) Ltd
Salary: £50000 - £60000 per annum + Benefits
Posted: 2 hours ago
Manchester, Lancashire
ANSON MCCADE
Salary: £35,000 -£85,000, with excellent benefits
Posted: 4 hours ago
Central London / West End
ANSON MCCADE
Salary: £35,000 -£85,000, with excellent benefits
Posted: 4 hours ago
London
ASOS.Com
Posted: 17 hours ago
London
Lawrence Harvey Enterprise
Salary: £60000.00 - £70000.00 per annum + 10% Bonus and Benefits
Posted: Yesterday
London
Exposed Solutions
Salary: £55000 - £65000 per annum
Posted: 2 days ago
Staffordshire
Computer People
Salary: £35000 - £42000 per annum + bonus, 25 days, pension
Posted: 2 days ago
Chesterfield, Derbyshire
HAYS INFORMATION TECHNOLOGY
Salary: £40000.00 - £45000.00 per annum
Posted: 2 days ago
London
C4 Commerce
Salary: From £40,000 to £45,000 per annum 15% Bonus and benefit package
Posted: 2 days ago
London
Digitech Resourcing Ltd
Salary: From £40,000 to £45,000 per annum + Benefits
Posted: 3 days ago
Cambridge, Cambridgeshire
Computer People
Salary: £35000.00 - £40000.00 per annum
Posted: 3 days ago
Fareham, Hampshire
Connectus
Salary: £50000 per annum
Posted: 3 days ago
London
Resource Solutions - Nomura
Salary: Market Rate
Posted: 3 days ago
West Sussex
Venturi
Salary: £45000 - £55000 per annum + full bens
Posted: 3 days ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £30000 - £45000 per annum + Benefits
Posted: 4 days ago
Salisbury, Wiltshire
Sopra Steria Recruitment
Salary: From £28,000 to £32,000 per annum Flexible Benefits
Posted: 4 days ago
UK
Careerwise UK Limited
Salary: £50000 - £75000 per annum + benefits
Posted: 4 days ago
Birmingham, West Midlands (County)
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 4 days ago
Greater Manchester
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 4 days ago
Bristol Area
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: 4 days ago