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

Location
3 months to
19 Sep 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 387 409 309
Rank change year-on-year
+22 -100
Permanent jobs citing OLAP 731 609 984
As % of all permanent IT jobs located in the UK 0.64% 0.57% 0.85%
As % of the Database & Business Intelligence category 2.10% 1.80% 2.73%
Number of salaries quoted 624 512 893
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 £70,000 £67,500
UK excluding London average salary £42,500 £40,000 £40,000
% change year-on-year
+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
34891 33759 35987
As % of all permanent IT jobs located in the UK 30.48% 31.64% 31.06%
Number of salaries quoted 29329 29231 31666
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 £65,000
UK excluding London average salary £40,000 £40,000 £39,500
% change year-on-year
- +1.26%

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 September 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 September 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 +26 684 £51,750 +3.50% 80
London +30 398 £55,000 - 38
City of London +66 134 £61,000 +1.66% 19
South East +12 105 £52,000 +15.55% 7
West Midlands +23 48 £38,000 +6.29% 4
East of England -7 41 £40,500 +23.66% 9
Staffordshire +18 38 £40,000 +23.07% 1
Yorkshire -41 36 £37,500 - 4
North West -15 32 £50,000 -8.25% 11
Berkshire -10 31 £55,000 - 2
West Yorkshire -35 28 £40,000 +6.66% 4
Manchester +1 27 £50,000 -9.09% 6
Surrey +24 25 £50,000 +5.26% 3
South Wales +19 22 £37,500 +15.38% 1
Cardiff +11 22 £37,500 -8.53% 1
Wales +10 22 £37,500 +15.38% 1
Cambridgeshire +11 19 £40,500 +10.20% 2
Reading +9 19 £50,000 -37.50% 2
Bradford +2 16 £42,500 +17.24% 1
Crawley +13 15 £55,000 +29.41%
West Sussex +1 15 £55,000 +29.41%
South West -16 14 £42,500 +13.33% 2
Peterborough +14 11 £40,500 +10.20% 1
Hampshire -1 11 £31,250 -26.47%
Burton-upon-Trent +2 10 £40,000 +23.07%
Hertfordshire -5 10 £42,500 +3.97% 1
Southampton - 10 £31,250 -
East Midlands -22 9 £42,500 +13.33% 3
Bristol +2 8 £48,000 +43.28% 2
Essex +11 7 £42,500 +15.64% 4

OLAP
Top 30 Related IT Skills

For the 6 months to 19 September 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 1052 (70.04%) Business Intelligence
2 1047 (69.71%) SQL
3 1017 (67.71%) SQL Server
4 884 (58.85%) Data Warehouse
5 791 (52.66%) SQL Server Integration Services
6 777 (51.73%) SQL Server Analysis Services
7 761 (50.67%) SQL Server Reporting Services
7 761 (50.67%) ETL
8 559 (37.22%) Microsoft
9 434 (28.89%) T-SQL
10 433 (28.83%) Finance
11 394 (26.23%) SQL Server 2008
12 388 (25.83%) MS Excel
13 382 (25.43%) Oracle
13 382 (25.43%) Oracle OLAP
14 334 (22.24%) Data Modelling
15 315 (20.97%) Agile Software Development
16 288 (19.17%) .NET
17 274 (18.24%) MDX
18 271 (18.04%) Analytical Skills
19 220 (14.65%) SQL Server 2012
20 219 (14.58%) C#
21 217 (14.45%) OLTP
22 216 (14.38%) Degree
23 204 (13.58%) SharePoint
23 204 (13.58%) Relational Database
24 198 (13.18%) Microsoft Analysis Services
25 182 (12.12%) Kimball Methodology
25 182 (12.12%) Analytics
26 169 (11.25%) Cognos

OLAP
Top Related IT Skills by Category

For the 6 months to 19 September 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 204 (13.58%) SharePoint
2 65 (4.33%) SAS
3 36 (2.40%) IIS
4 32 (2.13%) SharePoint 2010
5 29 (1.93%) BizTalk Server
6 26 (1.73%) Tomcat
7 20 (1.33%) WebSphere
8 14 (0.93%) Apache
9 12 (0.80%) WebLogic
10 11 (0.73%) Oracle Application Server
11 10 (0.67%) SharePoint Server
12 9 (0.60%) Oracle Workflow
12 9 (0.60%) Oracle 10gAS
12 9 (0.60%) Oracle Coherence
13 7 (0.47%) Apache Solr
14 4 (0.27%) ColdFusion
15 3 (0.20%) MS Exchange
16 2 (0.13%) Blackberry Enterprise Server
16 2 (0.13%) CICS
16 2 (0.13%) WebSphere Application Server
Applications
1 388 (25.83%) MS Excel
2 102 (6.79%) MS Office
3 69 (4.59%) PowerPivot
4 39 (2.60%) MS Project
5 22 (1.46%) MS PowerPoint
6 14 (0.93%) MS Visio
7 13 (0.87%) SPSS
8 12 (0.80%) Spreadsheet
9 7 (0.47%) S-PLUS
10 6 (0.40%) FastStats
11 3 (0.20%) Stata
Business Applications
1 62 (4.13%) Cognos TM1
2 52 (3.46%) Cognos Business Intelligence
3 19 (1.26%) HFM
4 15 (1.00%) Dynamics CRM
4 15 (1.00%) Dynamics AX
5 12 (0.80%) Oracle EBS
5 12 (0.80%) Hyperion Planning
6 7 (0.47%) Summit
6 7 (0.47%) Cognos Planning
7 5 (0.33%) Google Analytics
8 4 (0.27%) Line 500
8 4 (0.27%) Oracle General Ledger
8 4 (0.27%) Oracle ERP
9 3 (0.20%) SAP Oil and Gas
9 3 (0.20%) Dynamics NAV
10 2 (0.13%) Cognos Controller
10 2 (0.13%) Siebel Analytics
10 2 (0.13%) Adaptiv
10 2 (0.13%) Oracle CRM
10 2 (0.13%) Oracle Financials
Cloud Services
1 11 (0.73%) Office 365
2 9 (0.60%) Amazon EC2
2 9 (0.60%) SaaS
3 8 (0.53%) Microsoft Azure
4 6 (0.40%) Amazon AWS
5 1 (0.067%) Cloud Computing
Communications & Networking
1 40 (2.66%) Intranet
2 22 (1.46%) Internet
3 12 (0.80%) SAN
4 10 (0.67%) ATM
5 8 (0.53%) DNS
6 7 (0.47%) Extranet
7 6 (0.40%) DMZ
8 4 (0.27%) iSCSI
8 4 (0.27%) LDAP
8 4 (0.27%) LAN
8 4 (0.27%) WAN
8 4 (0.27%) Fibre Channel
9 3 (0.20%) InfiniBand
9 3 (0.20%) FCoE
9 3 (0.20%) Ethernet
9 3 (0.20%) FTP
9 3 (0.20%) Firewall
10 2 (0.13%) Broadband
10 2 (0.13%) NAS
11 1 (0.067%) HTTP
Database & Business Intelligence
1 1017 (67.71%) SQL Server
2 884 (58.85%) Data Warehouse
3 791 (52.66%) SQL Server Integration Services
4 777 (51.73%) SQL Server Analysis Services
5 761 (50.67%) SQL Server Reporting Services
6 394 (26.23%) SQL Server 2008
7 382 (25.43%) Oracle OLAP
8 220 (14.65%) SQL Server 2012
9 217 (14.45%) OLTP
10 204 (13.58%) Relational Database
11 198 (13.18%) Microsoft Analysis Services
12 158 (10.52%) RDBMS
13 157 (10.45%) SQL Server 2005
14 146 (9.72%) Oracle Database
15 120 (7.99%) Data Mining
16 110 (7.32%) Big Data
17 104 (6.92%) MySQL
18 67 (4.46%) DTS
18 67 (4.46%) Star Schema
19 65 (4.33%) DB2
Development Applications
1 61 (4.06%) Team Foundation Server
2 51 (3.40%) Visual Studio
3 31 (2.06%) Talend Open Studio
4 19 (1.26%) SQL Server Management Studio (SSMS)
4 19 (1.26%) JUnit
4 19 (1.26%) ERwin
5 15 (1.00%) Visual Studio Team System
5 15 (1.00%) Subversion
5 15 (1.00%) Eclipse
6 14 (0.93%) Maven
7 13 (0.87%) Oracle Forms
8 10 (0.67%) PowerDesigner
9 9 (0.60%) PVCS
9 9 (0.60%) MorphX
10 8 (0.53%) Selenium
10 8 (0.53%) Git (software)
11 7 (0.47%) NuGet
12 6 (0.40%) Oracle APEX
12 6 (0.40%) Toad
13 3 (0.20%) VSS/SourceSafe
General
1 433 (28.83%) Finance
2 129 (8.59%) Banking
3 66 (4.39%) Marketing
4 58 (3.86%) Investment Banking
5 57 (3.79%) Games
6 47 (3.13%) Retail
7 45 (3.00%) Advertising
8 41 (2.73%) Telecoms
9 28 (1.86%) Front Office
10 25 (1.66%) Law
11 16 (1.07%) Legal
12 11 (0.73%) Billing
13 9 (0.60%) Back Office
14 8 (0.53%) Publishing
15 7 (0.47%) Music Industry
16 6 (0.40%) International Banking
16 6 (0.40%) Pharmaceutical
16 6 (0.40%) Financial Institution
17 5 (0.33%) General Ledger
17 5 (0.33%) German Language
Job Titles
1 821 (54.66%) Developer
2 400 (26.63%) Business Intelligence Developer
3 206 (13.72%) SQL Developer
4 176 (11.72%) Analyst
5 160 (10.65%) Consultant
6 156 (10.39%) DBA
7 146 (9.72%) Business Developer
8 131 (8.72%) Senior Developer
9 101 (6.72%) Data Warehouse Developer
10 90 (5.99%) SQL Server Developer
10 90 (5.99%) Business Intelligence Consultant
11 84 (5.59%) Architect
12 80 (5.33%) SQL DBA
13 76 (5.06%) Business Intelligence Analyst
14 69 (4.59%) Administrator
15 63 (4.19%) Business Analyst
16 48 (3.20%) Senior Business Intelligence Developer
17 47 (3.13%) Database Developer
18 46 (3.06%) SQL Server DBA
19 41 (2.73%) Microsoft Developer
Libraries, Frameworks & Software Standards
1 288 (19.17%) .NET
2 274 (18.24%) MDX
3 163 (10.85%) XML
4 101 (6.72%) ASP.NET
5 81 (5.39%) Web Services
6 78 (5.19%) HTML
7 63 (4.19%) CSS
8 30 (2.00%) ASP.NET MVC
9 27 (1.80%) WCF
10 26 (1.73%) Ajax
11 25 (1.66%) jQuery
12 24 (1.60%) .NET Framework
13 22 (1.46%) Spring
14 21 (1.40%) NHibernate
14 21 (1.40%) HTML5
15 18 (1.20%) OOXML
16 17 (1.13%) WPF
16 17 (1.13%) CSS3
17 15 (1.00%) ADO.NET Entity Framework
18 14 (0.93%) SOAP
Miscellaneous
1 271 (18.04%) Analytical Skills
2 100 (6.66%) Computer Science
3 92 (6.13%) Management Information System
4 71 (4.73%) Replication
5 69 (4.59%) Data Integration
6 55 (3.66%) Clustering
7 49 (3.26%) Mathematics
7 49 (3.26%) Visualisation
8 38 (2.53%) Statistics
9 26 (1.73%) Online Games
10 25 (1.66%) Data Extraction
11 23 (1.53%) PMI
12 20 (1.33%) GIS
12 20 (1.33%) Credit Risk
13 19 (1.26%) iPad
13 19 (1.26%) Enterprise Software
14 18 (1.20%) Fixed Income
15 16 (1.07%) Data Conversion
15 16 (1.07%) Hedge funds
16 15 (1.00%) Kindle
Operating Systems
1 148 (9.85%) Windows
2 99 (6.59%) Linux
3 64 (4.26%) UNIX
4 23 (1.53%) Windows Server 2008
5 19 (1.26%) Android
6 18 (1.20%) Windows Server 2003
7 9 (0.60%) AIX
8 7 (0.47%) Oracle Linux
9 4 (0.27%) Solaris
9 4 (0.27%) Ubuntu
10 3 (0.20%) Red Hat Enterprise Linux
11 2 (0.13%) Apple iOS
11 2 (0.13%) zOS
12 1 (0.067%) MVS
12 1 (0.067%) Windows 7
12 1 (0.067%) CentOS
Processes & Methodologies
1 1052 (70.04%) Business Intelligence
2 761 (50.67%) ETL
3 334 (22.24%) Data Modelling
4 315 (20.97%) Agile Software Development
5 182 (12.12%) Kimball Methodology
5 182 (12.12%) Analytics
6 169 (11.25%) Dimensional Modelling
7 156 (10.39%) Scrum
8 154 (10.25%) Performance Tuning
9 138 (9.19%) Project Management
10 129 (8.59%) Data Management
11 89 (5.93%) E-Commerce
12 88 (5.86%) CRM
13 85 (5.66%) Business Analysis
14 80 (5.33%) Data Architecture
15 70 (4.66%) Data Analysis
16 63 (4.19%) Performance Management
17 61 (4.06%) Unit Testing
18 57 (3.79%) OO
19 54 (3.60%) ERP
Programming Languages
1 1047 (69.71%) SQL
2 434 (28.89%) T-SQL
3 219 (14.58%) C#
4 123 (8.19%) PL/SQL
5 110 (7.32%) Java
6 66 (4.39%) JavaScript
7 48 (3.20%) VBA
8 33 (2.20%) PowerShell
9 28 (1.86%) Python
10 27 (1.80%) Shell Script
11 26 (1.73%) VB.NET
12 22 (1.46%) VB
12 22 (1.46%) PHP
12 22 (1.46%) Data Mining Extensions (DMX)
13 21 (1.40%) R
14 19 (1.26%) Data Analysis Expressions (DAX)
15 17 (1.13%) C
16 11 (0.73%) Perl
17 9 (0.60%) X++
18 7 (0.47%) C++
Qualifications
1 216 (14.38%) Degree
2 92 (6.13%) Microsoft Certification
3 30 (2.00%) MCDBA
4 25 (1.66%) MCITP
5 24 (1.60%) PMI Certification
6 23 (1.53%) MCAD
7 20 (1.33%) Security Cleared
8 15 (1.00%) ACCA
9 11 (0.73%) Oracle Certification
10 9 (0.60%) MCTS
11 8 (0.53%) ITIL Certification
11 8 (0.53%) MCSE
11 8 (0.53%) CIMA
12 7 (0.47%) MCSD
13 4 (0.27%) SC Cleared
14 3 (0.20%) MCSA
14 3 (0.20%) SAS Certification
15 2 (0.13%) MBA
15 2 (0.13%) PhD
15 2 (0.13%) IIBA
Quality Assurance & Compliance
1 69 (4.59%) QA
2 24 (1.60%) ISO 9001
3 18 (1.20%) SLA
4 14 (0.93%) PCI DSS
5 7 (0.47%) Data Quality
6 6 (0.40%) GAAP
7 5 (0.33%) HL7
8 4 (0.27%) TickIT
8 4 (0.27%) ISO/IEC 27001
8 4 (0.27%) Sarbanes-Oxley
System Software
1 29 (1.93%) Oracle RAC
2 10 (0.67%) Active Directory
3 7 (0.47%) VMware Infrastructure
4 6 (0.40%) Oracle RMAN
4 6 (0.40%) HDFS
5 3 (0.20%) Hyper-V
6 2 (0.13%) XenApp
6 2 (0.13%) XenDesktop
6 2 (0.13%) VMware ESX
Systems Management
1 31 (2.06%) Data Guard
2 8 (0.53%) Oracle Enterprise Manager
3 5 (0.33%) Opscode Chef
4 4 (0.27%) Foglight
5 2 (0.13%) SCCM
5 2 (0.13%) MAINVIEW
6 1 (0.067%) Tivoli
Vendors
1 559 (37.22%) Microsoft
2 382 (25.43%) Oracle
3 169 (11.25%) Cognos
4 130 (8.66%) Business Objects
5 125 (8.32%) IBM
6 75 (4.99%) SAP
6 75 (4.99%) Informatica
6 75 (4.99%) MicroStrategy
7 61 (4.06%) Tableau
8 55 (3.66%) Sybase
9 40 (2.66%) Netezza
10 31 (2.06%) Teradata
10 31 (2.06%) Talend
11 24 (1.60%) Hyperion
12 23 (1.53%) Dundas
13 15 (1.00%) Vertica
14 13 (0.87%) DataSynapse
15 12 (0.80%) JD Edwards
16 11 (0.73%) Ab Initio
16 11 (0.73%) VMware
Croydon, Surrey
Lawrence Harvey Enterprise
Salary: £55000 - £70000 per annum + Benefits
Posted: 13 hours ago
London
Lawrence Harvey Enterprise
Salary: £45000 - £80000 per annum + Benefits
Posted: 13 hours ago
City, London
Lawrence Harvey Enterprise
Salary: £55000.00 - £70000 per annum + Bonus
Posted: Yesterday
City, London
Energon Technology
Salary: From £60,000 to £70,000 per annum + benefits + bonus
Posted: Yesterday
Surrey
Nakama
Salary: From £50,000 to £55,000 per annum
Posted: Yesterday
London
Information Technology Services
Salary: £60k - 65k per year + Benefits
Posted: Yesterday
London
Mortimer Spinks
Salary: £60000 - £75000 per annum + excellent
Posted: 2 days ago
Letchworth Garden City, Hertfordshire
Deerfoot IT Resources Ltd
Salary: £35000 - £40000 per annum
Posted: 2 days ago
London
Eutopia Solutions Ltd
Salary: £50000.00 per annum + benefits
Posted: 2 days ago
London
Lawrence Harvey Enterprise
Salary: Benefits
Posted: 2 days ago
City, London
Harrington Starr
Salary: £45000 - £85000 per annum + Bonus + benefits + training
Posted: 3 days ago
Derby, Derbyshire
Oscar Associates (UK) Ltd
Salary: £36000 - £42000 per annum + Comprehensive benefits package
Posted: 3 days ago
Croydon, Surrey
Harris Global
Posted: 3 days ago
Southend-On-Sea, Essex
Oscar Associates (UK) Ltd
Salary: £35000 - £45000 per annum
Posted: 3 days ago
City, London
Digitech Resourcing Ltd
Salary: From £20,000 to £60,000 per annum Great Benefits and Training
Posted: 4 days ago
City, London
Bridge Noble
Salary: £75 - £75000 per annum
Posted: 4 days ago
Essex
Oscar Associates (UK) Ltd
Salary: £45000 - £55000 per annum
Posted: 4 days ago
Manchester, Lancashire
Lorien Resourcing
Posted: 4 days ago
Cambridge, Cambridgeshire
Salt
Salary: £40000 - £60000 per annum + Bonus + Excellent Benefits
Posted: 4 days ago
South East
Venturi
Salary: £50000 - £85000 per annum + 15% bonus + Benefits
Posted: 4 days ago