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

Location
3 months to
27 Mar 2015
Same period 2014 Same period 2013
Online Analytical Processing (OLAP)
Rank 455 404 326
Rank change year-on-year
-51 -78
Permanent jobs citing OLAP 543 689 869
As % of all permanent IT jobs located in the UK 0.50% 0.62% 0.80%
As % of the Database & Business Intelligence category 1.66% 1.95% 2.48%
Number of salaries quoted 414 556 752
Average salary £55,000 £47,500 £50,000
Average salary % change year-on-year
+15.78% -5.00%
90% offered a salary of more than £35,000 £31,500 £35,000
10% offered a salary of more than £75,000 £65,000 £70,000
UK excluding London average salary £42,500 £40,000 £45,000
% change year-on-year
+6.25% -11.11%

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
32706 35250 35078
As % of all permanent IT jobs located in the UK 30.40% 31.49% 32.23%
Number of salaries quoted 27756 29745 30420
Average salary £45,000 £45,000 £42,750
Average salary % change year-on-year
- +5.26%
90% offered a salary of more than £31,000 £30,000 £30,000
10% offered a salary of more than £70,000 £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 27 March 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 27 March 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 -36 513 £55,000 +13.40% 94
London +3 287 £62,500 +13.63% 39
South East -29 68 £42,000 -11.57% 15
City of London +1 65 £67,500 +22.72% 19
North West -10 43 £40,000 +14.28% 11
South West +1 42 £45,000 +12.50% 8
Gloucestershire - 28 £66,250 -
Berkshire +6 27 £65,000 +73.33%
Cheltenham - 27 £70,000 -
Manchester -3 23 £40,000 +14.28% 3
East of England -5 19 £65,000 +64.55% 1
Yorkshire -5 17 £40,000 +10.34% 8
Cheshire 0 16 £38,750 +19.23% 4
Bedfordshire +24 14 £77,500 +181.81% 1
West Midlands -56 14 £41,250 +10.00% 6
East Midlands +2 13 £41,250 +3.12% 4
West Yorkshire +1 13 £40,000 +18.51% 6
Bracknell -6 13 - -
Warrington +18 11 £40,000 -5.88% 2
West Sussex +14 11 £52,500 -30.00% 4
Wales - 11 £35,000 - 1
Buckinghamshire +5 9 £44,500 +11.25% 5
Cardiff - 9 £35,000 -
South Wales - 9 £35,000 -
Scotland -14 8 £52,500 +10.52% 3
Leeds +10 6 £40,000 +23.07% 5
Luton +1 6 £62,500 +127.27%
Milton Keynes -2 6 £42,000 +5.00% 1
Birmingham -9 6 £44,250 +33.08% 3
East Sussex -14 6 £40,000 -

OLAP
Top 30 Related IT Skills

For the 6 months to 27 March 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 800 (74.56%) Business Intelligence
2 725 (67.57%) SQL
3 684 (63.75%) SQL Server
4 617 (57.50%) Data Warehouse
5 606 (56.48%) ETL
6 546 (50.89%) SQL Server Integration Services
7 521 (48.56%) SQL Server Reporting Services
8 505 (47.06%) SQL Server Analysis Services
9 404 (37.65%) Microsoft
10 351 (32.71%) Finance
11 350 (32.62%) Oracle
12 330 (30.75%) T-SQL
13 329 (30.66%) Oracle OLAP
14 315 (29.36%) OLAP Cube
15 289 (26.93%) Data Modelling
16 251 (23.39%) SQL Server 2008
17 241 (22.46%) Analytical Skills
18 211 (19.66%) MS Excel
19 207 (19.29%) Agile Software Development
20 198 (18.45%) Analytics
21 194 (18.08%) Degree
22 168 (15.66%) Oracle Database
23 166 (15.47%) OLTP
24 158 (14.73%) MDX
25 153 (14.26%) SQL Server 2012
26 148 (13.79%) C#
27 147 (13.70%) Relational Database
28 135 (12.58%) SharePoint
29 134 (12.49%) .NET
30 131 (12.21%) Business Objects

OLAP
Top Related IT Skills by Category

For the 6 months to 27 March 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 135 (12.58%) SharePoint
2 69 (6.43%) SAS
3 34 (3.17%) WebLogic
4 28 (2.61%) Tomcat
5 26 (2.42%) SharePoint 2010
6 21 (1.96%) BizTalk Server
7 14 (1.30%) ColdFusion
8 12 (1.12%) IIS
9 11 (1.03%) OpenCms
9 11 (1.03%) CMS
9 11 (1.03%) Drupal
10 10 (0.93%) JBoss
11 8 (0.75%) Oracle Workflow
12 7 (0.65%) Apache
12 7 (0.65%) Oracle Coherence
13 6 (0.56%) SharePoint 2013
13 6 (0.56%) WebSphere
14 5 (0.47%) Apache Spark
15 3 (0.28%) Apache Solr
15 3 (0.28%) Oracle HTTP Server
Applications
1 211 (19.66%) MS Excel
2 48 (4.47%) PowerPivot
3 21 (1.96%) SPSS
4 20 (1.86%) MS Office
5 16 (1.49%) MS Visio
6 11 (1.03%) MS Project
7 4 (0.37%) MS PowerPoint
8 1 (0.093%) FastStats
Business Applications
1 38 (3.54%) Cognos TM1
2 33 (3.08%) Dynamics CRM
2 33 (3.08%) Cognos Business Intelligence
3 29 (2.70%) Oracle ERP
4 22 (2.05%) HFM
5 21 (1.96%) Oracle EBS
6 13 (1.21%) Oracle EBS R12
7 12 (1.12%) Hyperion Planning
8 7 (0.65%) Dynamics NAV
9 5 (0.47%) RMDS
10 4 (0.37%) Oracle Applications
10 4 (0.37%) Oracle Financials
11 2 (0.19%) Cognos Planning
11 2 (0.19%) ION MarketView
11 2 (0.19%) SiteCatalyst
11 2 (0.19%) Oracle Procure-to-Pay
12 1 (0.093%) Oracle Cash Management
12 1 (0.093%) Infor M3
12 1 (0.093%) Workday HCM
12 1 (0.093%) SAP BPC
Cloud Services
1 7 (0.65%) Microsoft Azure
2 6 (0.56%) Office 365
3 5 (0.47%) Amazon AWS
3 5 (0.47%) SaaS
4 3 (0.28%) Cloud Computing
5 1 (0.093%) Amazon EC2
5 1 (0.093%) Amazon S3
Communications & Networking
1 13 (1.21%) SAN
2 9 (0.84%) NAS
3 7 (0.65%) DNS
3 7 (0.65%) HTTP
4 5 (0.47%) TCP/IP
5 3 (0.28%) LAN
5 3 (0.28%) WAN
5 3 (0.28%) Internet
5 3 (0.28%) iSCSI
5 3 (0.28%) FCoE
5 3 (0.28%) Fibre Channel
5 3 (0.28%) Multicast
6 2 (0.19%) Intranet
Database & Business Intelligence
1 684 (63.75%) SQL Server
2 617 (57.50%) Data Warehouse
3 546 (50.89%) SQL Server Integration Services
4 521 (48.56%) SQL Server Reporting Services
5 505 (47.06%) SQL Server Analysis Services
6 329 (30.66%) Oracle OLAP
7 315 (29.36%) OLAP Cube
8 251 (23.39%) SQL Server 2008
9 168 (15.66%) Oracle Database
10 166 (15.47%) OLTP
11 153 (14.26%) SQL Server 2012
12 147 (13.70%) Relational Database
13 106 (9.88%) QlikView
14 102 (9.51%) Data Mining
15 97 (9.04%) Oracle BI EE
16 93 (8.67%) Microsoft Analysis Services
17 91 (8.48%) Big Data
18 72 (6.71%) Hadoop
19 71 (6.62%) SQL Server 2005
19 71 (6.62%) SQL Server 2000
Development Applications
1 47 (4.38%) Team Foundation Server
2 26 (2.42%) Toad
3 17 (1.58%) Oracle Forms
4 16 (1.49%) Visual Studio
4 16 (1.49%) PowerDesigner
5 12 (1.12%) Maven
5 12 (1.12%) Git (software)
6 11 (1.03%) Talend Open Studio
6 11 (1.03%) Subversion
7 9 (0.84%) ERwin
8 3 (0.28%) MSBuild
8 3 (0.28%) TeamCity
9 2 (0.19%) NuGet
10 1 (0.093%) SQL Server Management Studio (SSMS)
10 1 (0.093%) Ant
10 1 (0.093%) JIRA
10 1 (0.093%) ClearQuest
10 1 (0.093%) CruiseControl
10 1 (0.093%) VSS/SourceSafe
10 1 (0.093%) ClearCase
General
1 351 (32.71%) Finance
2 101 (9.41%) Banking
3 62 (5.78%) Retail
4 61 (5.68%) Marketing
5 26 (2.42%) Front Office
6 18 (1.68%) Advertising
6 18 (1.68%) Telecoms
6 18 (1.68%) Games
7 16 (1.49%) Investment Banking
8 12 (1.12%) General Ledger
8 12 (1.12%) Law
8 12 (1.12%) Legal
9 9 (0.84%) Financial Institution
10 8 (0.75%) Back Office
10 8 (0.75%) Retail Banking
11 6 (0.56%) Manufacturing
12 4 (0.37%) Pharmaceutical
12 4 (0.37%) Billing
13 2 (0.19%) Publishing
13 2 (0.19%) Automotive
Job Titles
1 502 (46.78%) Developer
2 245 (22.83%) Business Intelligence Developer
3 186 (17.33%) Consultant
4 154 (14.35%) Analyst
5 132 (12.30%) Business Intelligence Consultant
6 100 (9.32%) Business Developer
7 91 (8.48%) DBA
8 86 (8.01%) Architect
9 82 (7.64%) Senior Developer
10 76 (7.08%) Business Intelligence Analyst
11 69 (6.43%) SQL Developer
12 61 (5.68%) Business Consultant
13 57 (5.31%) Microsoft Consultant
14 55 (5.13%) SQL DBA
14 55 (5.13%) Microsoft BI Consultant
15 54 (5.03%) Business Analyst
16 46 (4.29%) Analyst Developer
17 35 (3.26%) Solutions Architect
18 34 (3.17%) Java Developer
19 33 (3.08%) Oracle Developer
Libraries, Frameworks & Software Standards
1 158 (14.73%) MDX
2 134 (12.49%) .NET
3 80 (7.46%) XML
4 60 (5.59%) HTML
5 58 (5.41%) ASP.NET
6 52 (4.85%) Web Services
7 41 (3.82%) CSS
8 35 (3.26%) HTML5
9 27 (2.52%) ASP.NET MVC
10 26 (2.42%) Hibernate
11 25 (2.33%) WCF
12 24 (2.24%) jQuery
13 20 (1.86%) Spring
13 20 (1.86%) Oracle GoldenGate
14 18 (1.68%) LINQ
14 18 (1.68%) Ajax
14 18 (1.68%) WSDL
15 14 (1.30%) XML Schema
15 14 (1.30%) Flash
15 14 (1.30%) ASP.NET 2.0
Miscellaneous
1 241 (22.46%) Analytical Skills
2 98 (9.13%) Visualisation
3 88 (8.20%) Computer Science
4 79 (7.36%) Data Integration
5 69 (6.43%) Replication
6 62 (5.78%) Management Information System
7 58 (5.41%) Data Structures
8 43 (4.01%) Clustering
9 41 (3.82%) Mathematics
10 21 (1.96%) Data Conversion
11 18 (1.68%) Enterprise Software
12 17 (1.58%) Open Source
13 15 (1.40%) Statistics
14 14 (1.30%) Oracle Exalogic
15 13 (1.21%) Hedge funds
15 13 (1.21%) Reference Data
16 12 (1.12%) Oracle Exalytics
17 11 (1.03%) User Experience
18 10 (0.93%) Economics
18 10 (0.93%) Equities
Operating Systems
1 81 (7.55%) UNIX
2 56 (5.22%) Linux
3 47 (4.38%) Windows
4 12 (1.12%) Android
5 10 (0.93%) Windows Server 2008
6 5 (0.47%) Windows Server 2012
7 4 (0.37%) Apple iOS
8 3 (0.28%) Windows Server 2003
8 3 (0.28%) Solaris
9 2 (0.19%) MVS
10 1 (0.093%) CentOS
10 1 (0.093%) Windows NT
10 1 (0.093%) Windows XP
Processes & Methodologies
1 800 (74.56%) Business Intelligence
2 606 (56.48%) ETL
3 289 (26.93%) Data Modelling
4 207 (19.29%) Agile Software Development
5 198 (18.45%) Analytics
6 126 (11.74%) Kimball Methodology
7 108 (10.07%) Performance Tuning
8 81 (7.55%) ERP
9 79 (7.36%) Scrum
10 78 (7.27%) CRM
10 78 (7.27%) Project Management
11 72 (6.71%) E-Commerce
12 71 (6.62%) Dimensional Modelling
13 69 (6.43%) Data Architecture
14 64 (5.96%) Data Management
15 58 (5.41%) Data Analysis
16 48 (4.47%) Information Management
16 48 (4.47%) Stakeholder Management
17 41 (3.82%) PRINCE2
18 40 (3.73%) OO
Programming Languages
1 725 (67.57%) SQL
2 330 (30.75%) T-SQL
3 148 (13.79%) C#
4 99 (9.23%) PL/SQL
5 92 (8.57%) Java
6 55 (5.13%) JavaScript
7 51 (4.75%) Shell Script
8 39 (3.63%) VBA
9 28 (2.61%) PowerShell
10 20 (1.86%) VB.NET
11 17 (1.58%) R
12 14 (1.30%) ActionScript
13 13 (1.21%) VB
14 12 (1.12%) Python
15 7 (0.65%) Perl
16 5 (0.47%) C
17 4 (0.37%) SAPscript
17 4 (0.37%) MATLAB
17 4 (0.37%) ABAP
17 4 (0.37%) Data Analysis Expressions (DAX)
Qualifications
1 194 (18.08%) Degree
2 41 (3.82%) Microsoft Certification
3 28 (2.61%) Security Cleared
4 23 (2.14%) SC Cleared
5 20 (1.86%) MCDBA
6 16 (1.49%) MCITP
7 11 (1.03%) IBM Certification
7 11 (1.03%) MCSD
7 11 (1.03%) MCSE
8 9 (0.84%) MCP
9 8 (0.75%) OCP
9 8 (0.75%) Oracle Certification
10 5 (0.47%) PMI Certification
11 4 (0.37%) HND
12 3 (0.28%) PMP
13 2 (0.19%) PhD
14 1 (0.093%) ISEB
14 1 (0.093%) ACCA
14 1 (0.093%) SAS Certification
Quality Assurance & Compliance
1 28 (2.61%) QA
2 15 (1.40%) Data Quality
3 13 (1.21%) ISO 9001
4 9 (0.84%) Solvency II
5 6 (0.56%) SLA
6 5 (0.47%) ISO/IEC 27001
7 3 (0.28%) PCI DSS
7 3 (0.28%) Sarbanes-Oxley
8 2 (0.19%) ISO 14001
8 2 (0.19%) GxP
8 2 (0.19%) COBIT
8 2 (0.19%) GAMP
System Software
1 28 (2.61%) Oracle RAC
2 11 (1.03%) Varnish
3 5 (0.47%) VMware Infrastructure
4 3 (0.28%) Hyper-V
4 3 (0.28%) SRDF
4 3 (0.28%) KVM
4 3 (0.28%) NFS
4 3 (0.28%) Xen
5 2 (0.19%) HDFS
6 1 (0.093%) Active Directory
Systems Management
1 4 (0.37%) Data Guard
2 2 (0.19%) Oracle RMAN
Vendors
1 404 (37.65%) Microsoft
2 350 (32.62%) Oracle
3 131 (12.21%) Business Objects
4 125 (11.65%) Tableau
5 123 (11.46%) Informatica
6 102 (9.51%) Cognos
7 99 (9.23%) SAP
8 67 (6.24%) Hyperion
9 59 (5.50%) Teradata
10 56 (5.22%) IBM
11 36 (3.36%) Sybase
12 34 (3.17%) MicroStrategy
13 33 (3.08%) Ab Initio
14 23 (2.14%) Hitachi
14 23 (2.14%) Netezza
15 16 (1.49%) Siebel
16 13 (1.21%) DataFlux
17 11 (1.03%) Vertica
17 11 (1.03%) Talend
18 10 (0.93%) Applix
Oxford, Oxfordshire
Spectrum IT Recruitment (South) Ltd
Salary: Benefits
Posted: 16 hours ago
Buckinghamshire
Circle Recruitment
Salary: Negotiable
Posted: 16 hours ago
West London
Randstad Technologies
Salary: £45000.00 - £55000.00 per annum
Posted: 23 hours ago
Newcastle Upon Tyne, Tyne and Wear
Solutions Recruitment
Salary: From £30,000 to £40,000 per annum
Posted: Yesterday
City, London
Ace European Group
Salary: Competitive
Posted: Yesterday
Sheffield, South Yorkshire
The Bridge Ltd
Salary: From £20,000 to £30,000 per annum +excellent benefits and bonus
Posted: Yesterday
Scotland
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
South West
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
East Midlands
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
North West
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
South East
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
London
ANSON MCCADE
Salary: £35k-£60k+benefits+ career progression opportunities
Posted: Yesterday
London
Venturi
Salary: £55000 - £85000 per annum + 15% bonus + Benefits
Posted: Yesterday
North West
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
South West
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
East Midlands
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
South East
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
London
ANSON MCCADE
Salary: £40k-£55k+benefits, progession +package
Posted: Yesterday
London
Exposed Solutions
Salary: £50000 - £70000 per annum, Benefits Excellent Benefits & Bonus
Posted: 2 days ago
Liverpool, Merseyside
Rullion IT Plus
Salary: £3000 - £45000 per annum + Benefits
Posted: 2 days ago