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

Location
3 months to
19 Dec 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 464 351 333
Rank change year-on-year
-113 -18
Permanent jobs citing OLAP 547 813 894
As % of all permanent IT jobs located in the UK 0.49% 0.74% 0.77%
As % of the Database & Business Intelligence category 1.64% 2.31% 2.36%
Number of salaries quoted 458 686 819
Average salary £47,500 £50,000 £45,000
Average salary % change year-on-year
-5.00% +11.11%
90% offered a salary of more than £32,500 £35,000 £32,500
10% offered a salary of more than £70,000 £75,000 £65,000
UK excluding London average salary £42,250 £40,000 £42,500
% change year-on-year
+5.62% -5.88%

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
33389 35123 37914
As % of all permanent IT jobs located in the UK 29.81% 32.08% 32.83%
Number of salaries quoted 28656 29917 33820
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 £62,500 £67,500
UK excluding London average salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%

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 19 December 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 19 December 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 -93 520 £47,500 -5.00% 73
London -86 277 £60,000 +9.09% 37
City of London +6 82 £63,750 +15.90% 18
South East -23 55 £55,000 +10.00% 6
North West +3 48 £42,500 +8.28% 10
East of England -30 43 £40,000 +6.66% 4
Manchester +3 40 £42,500 +16.43% 5
West Midlands -3 28 £36,000 -8.86% 1
Berkshire -20 25 £40,000 -27.27%
Yorkshire -27 25 £43,500 +8.75% 8
Hertfordshire -3 24 £47,500 +46.15% 1
South West +1 22 £37,500 - 5
West Yorkshire -3 20 £46,500 +16.25% 6
East Midlands +17 16 £45,000 +20.00% 2
South Wales +20 14 £36,500 +22.68% 1
Wales +17 14 £36,500 +22.68% 1
Coventry +2 14 £35,000 -11.94%
Bristol +3 12 £37,500 - 3
Surrey -2 12 £56,000 +24.44% 3
Reading +6 11 £38,750 -16.21%
Cardiff +10 9 £36,000 +71.42%
Docklands, London - 9 £70,000 -
Bedfordshire +5 8 £30,000 +9.09% 2
Northamptonshire - 8 £45,000 -
Potters Bar - 8 £47,500 -
Wiltshire - 8 £37,500 -
Nottinghamshire +7 7 £37,500 +1.35% 2
Nottingham +6 7 £37,500 +1.35% 2
West Sussex +4 7 £55,000 -10.20%
Leeds -4 7 £46,500 +16.25% 2

OLAP
Top 30 Related IT Skills

For the 6 months to 19 December 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 920 (71.99%) Business Intelligence
2 890 (69.64%) SQL
3 825 (64.55%) SQL Server
4 754 (59.00%) Data Warehouse
5 656 (51.33%) ETL
6 648 (50.70%) SQL Server Integration Services
7 622 (48.67%) SQL Server Analysis Services
8 615 (48.12%) SQL Server Reporting Services
9 445 (34.82%) Microsoft
10 418 (32.71%) OLAP Cube
11 404 (31.61%) Finance
12 378 (29.58%) T-SQL
13 363 (28.40%) Oracle
13 363 (28.40%) Oracle OLAP
14 328 (25.67%) SQL Server 2008
15 289 (22.61%) MS Excel
16 288 (22.54%) Data Modelling
17 273 (21.36%) Analytical Skills
18 248 (19.41%) Agile Software Development
19 220 (17.21%) SQL Server 2012
20 208 (16.28%) .NET
21 203 (15.88%) SharePoint
22 199 (15.57%) Degree
23 197 (15.41%) MDX
24 192 (15.02%) OLTP
25 188 (14.71%) C#
26 173 (13.54%) Analytics
27 154 (12.05%) Relational Database
28 148 (11.58%) Cognos
29 138 (10.80%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 19 December 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 203 (15.88%) SharePoint
2 73 (5.71%) SAS
3 47 (3.68%) SharePoint 2010
4 27 (2.11%) WebLogic
5 25 (1.96%) Tomcat
6 21 (1.64%) BizTalk Server
7 14 (1.10%) ColdFusion
7 14 (1.10%) WebSphere
8 12 (0.94%) IIS
9 10 (0.78%) Oracle Coherence
10 9 (0.70%) Apache Solr
10 9 (0.70%) Apache Spark
11 8 (0.63%) CMS
12 7 (0.55%) OpenCms
12 7 (0.55%) Drupal
13 6 (0.47%) SharePoint 2013
14 5 (0.39%) SharePoint Server
14 5 (0.39%) Oracle Workflow
15 4 (0.31%) JBoss
16 3 (0.23%) Apache
Applications
1 289 (22.61%) MS Excel
2 73 (5.71%) MS Office
3 57 (4.46%) PowerPivot
4 17 (1.33%) SPSS
5 16 (1.25%) MS Project
6 14 (1.10%) MS Visio
6 14 (1.10%) MS PowerPoint
7 5 (0.39%) S-PLUS
8 4 (0.31%) FastStats
9 1 (0.078%) Stata
9 1 (0.078%) Spreadsheet
Business Applications
1 61 (4.77%) Cognos TM1
2 51 (3.99%) Cognos Business Intelligence
3 25 (1.96%) Dynamics CRM
4 19 (1.49%) HFM
5 12 (0.94%) Hyperion Planning
6 11 (0.86%) Oracle EBS
6 11 (0.86%) Oracle ERP
7 8 (0.63%) Cognos Planning
8 6 (0.47%) Dynamics AX
9 5 (0.39%) Summit
9 5 (0.39%) Google Analytics
10 4 (0.31%) Oracle General Ledger
11 2 (0.16%) Remedy ITSM
11 2 (0.16%) Adaptiv
11 2 (0.16%) Dynamics NAV
11 2 (0.16%) Cognos Controller
12 1 (0.078%) Siebel Analytics
12 1 (0.078%) Dynamics GP
12 1 (0.078%) SAP Oil and Gas
12 1 (0.078%) Khalix
Cloud Services
1 13 (1.02%) Office 365
2 8 (0.63%) Microsoft Azure
3 6 (0.47%) SaaS
4 3 (0.23%) Cloud Computing
5 2 (0.16%) Amazon AWS
6 1 (0.078%) Amazon EC2
6 1 (0.078%) Amazon S3
Communications & Networking
1 12 (0.94%) Intranet
2 9 (0.70%) DNS
2 9 (0.70%) SAN
3 5 (0.39%) ATM
3 5 (0.39%) Internet
3 5 (0.39%) TCP/IP
4 3 (0.23%) LDAP
4 3 (0.23%) HTTP
5 2 (0.16%) Broadband
6 1 (0.078%) LAN
6 1 (0.078%) WAN
6 1 (0.078%) FTP
6 1 (0.078%) iSCSI
6 1 (0.078%) NAS
6 1 (0.078%) FCoE
6 1 (0.078%) Fibre Channel
6 1 (0.078%) Multicast
Database & Business Intelligence
1 825 (64.55%) SQL Server
2 754 (59.00%) Data Warehouse
3 648 (50.70%) SQL Server Integration Services
4 622 (48.67%) SQL Server Analysis Services
5 615 (48.12%) SQL Server Reporting Services
6 418 (32.71%) OLAP Cube
7 363 (28.40%) Oracle OLAP
8 328 (25.67%) SQL Server 2008
9 220 (17.21%) SQL Server 2012
10 192 (15.02%) OLTP
11 154 (12.05%) Relational Database
12 136 (10.64%) Oracle Database
13 135 (10.56%) Microsoft Analysis Services
14 127 (9.94%) SQL Server 2005
15 100 (7.82%) Big Data
16 95 (7.43%) Data Mining
17 90 (7.04%) RDBMS
17 90 (7.04%) QlikView
18 70 (5.48%) MySQL
19 67 (5.24%) Oracle ODI
Development Applications
1 72 (5.63%) Team Foundation Server
2 31 (2.43%) Visual Studio
3 18 (1.41%) Talend Open Studio
4 15 (1.17%) ERwin
5 13 (1.02%) Subversion
6 12 (0.94%) PowerDesigner
7 11 (0.86%) Git (software)
7 11 (0.86%) Maven
7 11 (0.86%) Toad
8 9 (0.70%) JUnit
8 9 (0.70%) SQL Server Management Studio (SSMS)
9 7 (0.55%) Oracle Forms
10 4 (0.31%) VSS/SourceSafe
11 3 (0.23%) Selenium
11 3 (0.23%) NuGet
12 2 (0.16%) JIRA
12 2 (0.16%) Ant
12 2 (0.16%) Eclipse
13 1 (0.078%) QuickTest Pro
13 1 (0.078%) Visual Studio Team System
General
1 404 (31.61%) Finance
2 130 (10.17%) Banking
3 61 (4.77%) Marketing
4 38 (2.97%) Retail
5 31 (2.43%) Investment Banking
6 30 (2.35%) Law
7 27 (2.11%) Games
8 26 (2.03%) Advertising
9 24 (1.88%) Front Office
10 18 (1.41%) Legal
11 12 (0.94%) Telecoms
11 12 (0.94%) General Ledger
12 9 (0.70%) Back Office
13 8 (0.63%) Retail Banking
14 7 (0.55%) Financial Institution
15 6 (0.47%) Billing
16 5 (0.39%) Publishing
17 2 (0.16%) Pharmaceutical
17 2 (0.16%) Manufacturing
17 2 (0.16%) Automotive
Job Titles
1 679 (53.13%) Developer
2 347 (27.15%) Business Intelligence Developer
3 164 (12.83%) Analyst
4 159 (12.44%) Consultant
5 131 (10.25%) Business Developer
6 128 (10.02%) SQL Developer
7 110 (8.61%) DBA
8 105 (8.22%) Senior Developer
9 99 (7.75%) Business Intelligence Consultant
10 78 (6.10%) Business Intelligence Analyst
11 67 (5.24%) Architect
12 66 (5.16%) Business Analyst
13 63 (4.93%) Data Warehouse Developer
14 50 (3.91%) Senior Business Intelligence Developer
15 49 (3.83%) SQL DBA
16 42 (3.29%) SQL Server Developer
17 40 (3.13%) Database Developer
18 38 (2.97%) Business Consultant
19 37 (2.90%) Administrator
20 35 (2.74%) .NET Developer
Libraries, Frameworks & Software Standards
1 208 (16.28%) .NET
2 197 (15.41%) MDX
3 103 (8.06%) XML
4 67 (5.24%) ASP.NET
5 61 (4.77%) HTML
6 54 (4.23%) Web Services
7 39 (3.05%) CSS
8 31 (2.43%) WCF
8 31 (2.43%) ASP.NET MVC
9 29 (2.27%) HTML5
10 20 (1.56%) jQuery
11 18 (1.41%) LINQ
11 18 (1.41%) Spring
12 16 (1.25%) WSDL
13 15 (1.17%) Ajax
14 14 (1.10%) XML Schema
14 14 (1.10%) Flash
14 14 (1.10%) .NET Framework
14 14 (1.10%) ASP.NET 2.0
15 13 (1.02%) CSS3
Miscellaneous
1 273 (21.36%) Analytical Skills
2 87 (6.81%) Computer Science
3 69 (5.40%) Data Integration
4 67 (5.24%) Visualisation
5 65 (5.09%) Management Information System
6 61 (4.77%) Data Structures
7 53 (4.15%) Mathematics
8 45 (3.52%) Replication
9 43 (3.36%) Clustering
10 22 (1.72%) Statistics
11 19 (1.49%) Fixed Income
12 18 (1.41%) PMI
12 18 (1.41%) Oracle Exalytics
13 17 (1.33%) User Experience
13 17 (1.33%) Reference Data
14 15 (1.17%) Online Games
15 14 (1.10%) Data Extraction
15 14 (1.10%) Kindle
16 13 (1.02%) Enterprise Software
16 13 (1.02%) iPad
Operating Systems
1 80 (6.26%) Windows
2 64 (5.01%) Linux
3 60 (4.69%) UNIX
4 19 (1.49%) Windows Server 2008
5 14 (1.10%) Windows Server 2003
6 13 (1.02%) Android
7 7 (0.55%) Oracle Linux
8 4 (0.31%) Windows Server 2012
8 4 (0.31%) AIX
9 3 (0.23%) MVS
10 2 (0.16%) zOS
11 1 (0.078%) Solaris
11 1 (0.078%) CentOS
Processes & Methodologies
1 920 (71.99%) Business Intelligence
2 656 (51.33%) ETL
3 288 (22.54%) Data Modelling
4 248 (19.41%) Agile Software Development
5 173 (13.54%) Analytics
6 138 (10.80%) Kimball Methodology
7 129 (10.09%) Scrum
8 106 (8.29%) Project Management
9 99 (7.75%) Dimensional Modelling
10 95 (7.43%) Performance Tuning
11 90 (7.04%) CRM
11 90 (7.04%) Data Management
12 82 (6.42%) E-Commerce
13 69 (5.40%) Data Analysis
14 65 (5.09%) Data Architecture
15 54 (4.23%) Unit Testing
16 53 (4.15%) ERP
17 48 (3.76%) Information Management
18 43 (3.36%) Mentoring
19 41 (3.21%) Waterfall
Programming Languages
1 890 (69.64%) SQL
2 378 (29.58%) T-SQL
3 188 (14.71%) C#
4 111 (8.69%) PL/SQL
5 86 (6.73%) Java
6 52 (4.07%) JavaScript
7 32 (2.50%) VBA
8 28 (2.19%) PowerShell
9 25 (1.96%) VB.NET
10 24 (1.88%) Shell Script
11 18 (1.41%) Data Analysis Expressions (DAX)
12 17 (1.33%) R
13 16 (1.25%) VB
14 14 (1.10%) ActionScript
15 10 (0.78%) Perl
16 9 (0.70%) Python
17 7 (0.55%) C
18 5 (0.39%) C++
18 5 (0.39%) VBScript
19 4 (0.31%) ABAP
Qualifications
1 199 (15.57%) Degree
2 59 (4.62%) Microsoft Certification
3 32 (2.50%) MCDBA
4 23 (1.80%) Security Cleared
5 19 (1.49%) PMI Certification
6 15 (1.17%) MCSD
7 13 (1.02%) MCSE
8 12 (0.94%) MCITP
9 11 (0.86%) SC Cleared
10 10 (0.78%) ACCA
11 7 (0.55%) Oracle Certification
11 7 (0.55%) MCAD
12 6 (0.47%) MCP
12 6 (0.47%) IBM Certification
13 2 (0.16%) CIMA
13 2 (0.16%) SAS Certification
13 2 (0.16%) ISEB
13 2 (0.16%) OCP
13 2 (0.16%) IIBA
14 1 (0.078%) ISTQB
Quality Assurance & Compliance
1 44 (3.44%) QA
2 28 (2.19%) ISO 9001
3 11 (0.86%) SLA
4 10 (0.78%) Data Quality
5 9 (0.70%) Solvency II
6 4 (0.31%) GAAP
7 3 (0.23%) HL7
8 2 (0.16%) ISO 14001
8 2 (0.16%) GAMP
8 2 (0.16%) COBIT
8 2 (0.16%) Sarbanes-Oxley
8 2 (0.16%) GxP
9 1 (0.078%) ISO/IEC 27001
System Software
1 35 (2.74%) Oracle RAC
2 9 (0.70%) Active Directory
3 7 (0.55%) Varnish
4 5 (0.39%) HDFS
5 2 (0.16%) Oracle RMAN
5 2 (0.16%) VMware Infrastructure
6 1 (0.078%) Hyper-V
6 1 (0.078%) SRDF
6 1 (0.078%) Xen
6 1 (0.078%) KVM
6 1 (0.078%) NFS
Systems Management
1 22 (1.72%) Data Guard
2 6 (0.47%) Oracle Enterprise Manager
3 4 (0.31%) Foglight
4 2 (0.16%) MAINVIEW
Vendors
1 445 (34.82%) Microsoft
2 363 (28.40%) Oracle
3 148 (11.58%) Cognos
4 136 (10.64%) Business Objects
5 93 (7.28%) IBM
6 92 (7.20%) Informatica
7 90 (7.04%) SAP
7 90 (7.04%) Tableau
8 63 (4.93%) MicroStrategy
9 52 (4.07%) Teradata
10 49 (3.83%) Sybase
11 38 (2.97%) Hyperion
12 37 (2.90%) Netezza
13 21 (1.64%) Ab Initio
14 20 (1.56%) Siebel
15 18 (1.41%) Talend
16 16 (1.25%) JD Edwards
17 13 (1.02%) DataSynapse
17 13 (1.02%) Applix
18 12 (0.94%) Sun
City, London
Westbourne Partners
Salary: From £30,000 to £40,000 per annum
Posted: 1 hour ago
South East
Intapeople
Salary: £42000 - £50000 per annum
Posted: 5 hours ago
Warrington, Cheshire
Actis Recruitment.
Salary: From £25,000 to £35,000 per annum + bonus + bens
Posted: 5 hours ago
London
Search Consultancy
Salary: Benefits
Posted: Yesterday
Leeds, West Yorkshire
Head Resourcing
Salary: £35000 - £45000 per annum + benefits package inc pension
Posted: Yesterday
City, London
Networking People
Posted: Yesterday
Southampton, Hampshire
Acceler-IT
Salary: From £40,000 to £55,000 per annum +superb benefits.and bonus
Posted: Yesterday
Skipton, North Yorkshire
Lorien Resourcing
Salary: £30000 - £40000 per annum
Posted: Yesterday
London
Hitachi Consulting UK
Salary: From £50,000 to £75,000 per annum + Bonus + Benefits
Posted: Yesterday
City, London
Connectus
Salary: £65000 - £80000 per annum + benefits
Posted: 2 days ago
City, London
Connectus
Salary: £65000 - £80000 per annum + benefits
Posted: 2 days ago
Manchester, Lancashire
Circle Recruitment
Salary: £28000 - £35000 per annum + Bonus + Benefits
Posted: 2 days ago
London
DataSciences Consulting
Posted: 2 days ago
City, London
E-synergy Solutions
Salary: £70000 - £75000 per annum + Excellent benefits package
Posted: 2 days ago
London
Venturi
Salary: £50000 - £85000 per annum + 15% bonus + Benefits
Posted: 2 days ago
Croydon, Surrey
Lawrence Harvey Enterprise
Salary: £55000 - £70000 per annum + Benefits
Posted: 3 days ago
Woolston, Warrington
Actis Recruitment
Posted: 3 days ago
Manchester, Lancashire
Rullion IT Plus
Salary: £35000 - £50000 per annum + Benefits
Posted: 3 days ago
Luton, Bedfordshire
CPS Group UK
Salary: £60000 - £65000 per annum + Pension & Benefits
Posted: 3 days ago
London
Computer People
Salary: £50000.00 - £60000.00 per annum
Posted: 3 days ago