The first table below looks at the demand 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 29 July 2014 with a comparison to the same period in the previous 2 years. The second table is for comparison and provides aggregates for all of the Database & Business Intelligence category.

Location
3 months to
29 Jul 2014
Same period 2013 Same period 2012
Online Analytical Processing (OLAP)
Rank 368 421 310
Rank change year-on-year
+53 -111
Permanent jobs citing OLAP 779 576 949
As % of all permanent IT jobs located in the UK 0.67% 0.53% 0.80%
As % of the Database & Business Intelligence category 2.15% 1.69% 2.60%
Number of salaries quoted 665 495 822
Average salary £52,000 £50,000 £45,500
Average salary % change year-on-year
+4.00% +9.89%
90% offered a salary of more than £35,000 £32,500 £32,500
10% offered a salary of more than £70,000 £70,000 £70,000
UK excluding London average salary £45,000 £43,500 £40,000
% change year-on-year
+3.44% +8.75%
Database & Business Intelligence Category
UK
Permanent IT job ads with a match in the
Database & Business Intelligence category
36269 33995 36515
As % of all permanent IT jobs located in the UK 31.03% 31.27% 30.97%
Number of salaries quoted 30978 29341 32185
Average salary £45,000 £42,500 £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 £39,000 £38,000
% change year-on-year
+2.56% +2.63%

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 29 July 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 29 July 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 +37 743 £52,500 +5.00% 71
London +73 435 £57,500 - 34
City of London +45 142 £60,000 -4.00% 16
South East +36 123 £50,750 +12.77% 17
West Midlands +52 68 £40,000 +9.58% 3
Staffordshire +34 43 £40,000 +21.21% 2
East of England +11 39 £40,500 -4.70% 4
Yorkshire -48 31 £37,100 +9.11% 3
Hampshire +23 25 £31,250 -17.76% 3
Surrey +9 25 £52,000 +4.00% 1
North West -27 23 £42,500 -5.55% 4
West Yorkshire -44 22 £43,250 +27.20% 3
Berkshire -4 20 £55,000 - 6
Southampton - 20 £31,250 - 2
Cambridgeshire +16 18 £40,500 -10.00% 4
Burton-upon-Trent +9 17 £40,000 +21.21%
Wales -3 16 £37,500 +15.38% 3
Suffolk +13 14 £40,000 -5.88%
West Sussex +4 14 £75,000 +35.74% 3
Cardiff 0 13 £42,240 +53.60% 3
South Wales -3 13 £42,240 +29.96% 3
Crawley +21 12 £75,000 +35.13% 2
Kent -14 12 £42,500 - 1
South West -21 12 £45,000 -11.76% 1
Manchester -22 12 £51,250 +7.89% 2
Reading +3 11 £50,000 -9.09% 4
East Midlands +2 11 £55,000 +52.77% 6
Buckinghamshire -6 11 £50,000 +51.51%
Camberley - 11 £52,000 -
Warwickshire +18 10 £36,500 -16.09%

OLAP
Top 30 Related IT Skills

For the 6 months to 29 July 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 1044 (70.68%) Business Intelligence
2 1037 (70.21%) SQL
3 1015 (68.72%) SQL Server
4 847 (57.35%) Data Warehouse
5 803 (54.37%) SQL Server Integration Services
6 775 (52.47%) SQL Server Reporting Services
7 758 (51.32%) ETL
8 751 (50.85%) SQL Server Analysis Services
9 551 (37.31%) Microsoft
10 456 (30.87%) T-SQL
11 433 (29.32%) Finance
12 388 (26.27%) SQL Server 2008
13 385 (26.07%) MS Excel
14 353 (23.90%) Oracle
15 351 (23.76%) Oracle OLAP
16 303 (20.51%) Data Modelling
17 293 (19.84%) MDX
18 291 (19.70%) .NET
19 232 (15.71%) C#
20 228 (15.44%) Relational Database
21 208 (14.08%) Degree
22 206 (13.95%) Microsoft Analysis Services
23 205 (13.88%) OLTP
24 202 (13.68%) Analytics
25 201 (13.61%) SQL Server 2012
26 187 (12.66%) Dimensional Modelling
27 171 (11.58%) Cognos
28 169 (11.44%) SQL Server 2005
28 169 (11.44%) Performance Tuning
29 155 (10.49%) Kimball Methodology

OLAP
Top Related IT Skills by Category

For the 6 months to 29 July 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 151 (10.22%) SharePoint
2 76 (5.15%) SAS
3 41 (2.78%) IIS
4 28 (1.90%) BizTalk Server
5 22 (1.49%) Tomcat
6 17 (1.15%) WebSphere
7 16 (1.08%) Apache
8 11 (0.74%) Oracle Application Server
9 9 (0.61%) Oracle 10gAS
10 8 (0.54%) FileNet
10 8 (0.54%) Oracle Workflow
11 7 (0.47%) SharePoint Server
11 7 (0.47%) SharePoint 2010
12 6 (0.41%) WebLogic
13 5 (0.34%) Apache Solr
14 4 (0.27%) NetWeaver
15 3 (0.20%) MS Exchange
15 3 (0.20%) Oracle Coherence
16 2 (0.14%) Blackberry Enterprise Server
16 2 (0.14%) SharePoint 2013
Applications
1 385 (26.07%) MS Excel
2 85 (5.75%) MS Office
3 50 (3.39%) PowerPivot
4 38 (2.57%) MS Project
5 19 (1.29%) MS PowerPoint
6 14 (0.95%) Spreadsheet
7 13 (0.88%) SPSS
8 9 (0.61%) MS Visio
9 6 (0.41%) FastStats
10 5 (0.34%) S-PLUS
11 3 (0.20%) Stata
Business Applications
1 60 (4.06%) Cognos Business Intelligence
2 56 (3.79%) Cognos TM1
3 20 (1.35%) HFM
4 14 (0.95%) Oracle EBS
4 14 (0.95%) Dynamics AX
5 11 (0.74%) Dynamics CRM
6 10 (0.68%) Hyperion Planning
7 5 (0.34%) Google Analytics
7 5 (0.34%) Summit
8 4 (0.27%) Siebel Analytics
8 4 (0.27%) Line 500
9 3 (0.20%) Dynamics NAV
10 2 (0.14%) SAP Oil and Gas
10 2 (0.14%) Oracle Financials
10 2 (0.14%) Adaptiv
10 2 (0.14%) Oracle CRM
10 2 (0.14%) Oracle ERP
10 2 (0.14%) Oracle Applications
10 2 (0.14%) Cognos Controller
10 2 (0.14%) Oracle General Ledger
Cloud Services
1 11 (0.74%) SaaS
2 10 (0.68%) Office 365
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 33 (2.23%) Intranet
2 20 (1.35%) Internet
3 16 (1.08%) SAN
4 8 (0.54%) Extranet
4 8 (0.54%) ATM
5 6 (0.41%) LAN
5 6 (0.41%) WAN
5 6 (0.41%) DMZ
6 5 (0.34%) Firewall
6 5 (0.34%) NAS
7 4 (0.27%) Fibre Channel
7 4 (0.27%) iSCSI
7 4 (0.27%) DNS
8 3 (0.20%) Ethernet
8 3 (0.20%) FTP
8 3 (0.20%) PPP
8 3 (0.20%) InfiniBand
8 3 (0.20%) FCoE
9 2 (0.14%) Wi-Fi
9 2 (0.14%) TCP/IP
Database & Business Intelligence
1 1015 (68.72%) SQL Server
2 847 (57.35%) Data Warehouse
3 803 (54.37%) SQL Server Integration Services
4 775 (52.47%) SQL Server Reporting Services
5 751 (50.85%) SQL Server Analysis Services
6 388 (26.27%) SQL Server 2008
7 351 (23.76%) Oracle OLAP
8 228 (15.44%) Relational Database
9 206 (13.95%) Microsoft Analysis Services
10 205 (13.88%) OLTP
11 201 (13.61%) SQL Server 2012
12 169 (11.44%) SQL Server 2005
13 152 (10.29%) RDBMS
14 132 (8.94%) Oracle Database
15 118 (7.99%) Data Mining
16 103 (6.97%) Big Data
17 101 (6.84%) MySQL
18 76 (5.15%) DTS
19 61 (4.13%) Star Schema
20 59 (3.99%) DB2
Development Applications
1 51 (3.45%) Team Foundation Server
2 44 (2.98%) Visual Studio
3 26 (1.76%) Talend Open Studio
4 21 (1.42%) SQL Server Management Studio (SSMS)
4 21 (1.42%) JUnit
5 20 (1.35%) ERwin
6 19 (1.29%) Eclipse
7 18 (1.22%) Maven
8 15 (1.02%) Git (software)
9 14 (0.95%) Visual Studio Team System
10 13 (0.88%) Selenium
11 11 (0.74%) Oracle Forms
12 9 (0.61%) MorphX
12 9 (0.61%) Subversion
12 9 (0.61%) PVCS
13 7 (0.47%) Toad
13 7 (0.47%) Oracle APEX
13 7 (0.47%) NuGet
14 5 (0.34%) PowerDesigner
15 3 (0.20%) WiX
General
1 433 (29.32%) Finance
2 124 (8.40%) Banking
3 72 (4.87%) Marketing
4 57 (3.86%) Games
5 55 (3.72%) Advertising
5 55 (3.72%) Investment Banking
6 53 (3.59%) Retail
7 46 (3.11%) Telecoms
8 32 (2.17%) Law
9 29 (1.96%) Legal
10 16 (1.08%) Front Office
11 14 (0.95%) Publishing
12 13 (0.88%) Pharmaceutical
13 11 (0.74%) Financial Institution
14 10 (0.68%) Back Office
15 7 (0.47%) Billing
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 806 (54.57%) Developer
2 392 (26.54%) Business Intelligence Developer
3 234 (15.84%) SQL Developer
4 185 (12.53%) Analyst
5 158 (10.70%) Consultant
6 154 (10.43%) DBA
7 152 (10.29%) Business Developer
8 108 (7.31%) Senior Developer
9 95 (6.43%) Business Intelligence Consultant
10 89 (6.03%) Data Warehouse Developer
11 87 (5.89%) SQL Server Developer
12 83 (5.62%) Architect
13 82 (5.55%) SQL DBA
14 76 (5.15%) Business Intelligence Analyst
15 68 (4.60%) Administrator
16 52 (3.52%) Business Analyst
17 51 (3.45%) Microsoft Developer
18 45 (3.05%) Database Developer
19 42 (2.84%) SQL Server DBA
20 41 (2.78%) Development Manager
Libraries, Frameworks & Software Standards
1 293 (19.84%) MDX
2 291 (19.70%) .NET
3 135 (9.14%) XML
4 108 (7.31%) ASP.NET
5 88 (5.96%) Web Services
6 73 (4.94%) HTML
7 68 (4.60%) CSS
8 33 (2.23%) jQuery
9 29 (1.96%) ASP.NET MVC
10 25 (1.69%) Spring
10 25 (1.69%) Ajax
11 23 (1.56%) NHibernate
12 22 (1.49%) .NET Framework
12 22 (1.49%) HTML5
13 21 (1.42%) CSS3
14 20 (1.35%) OOXML
14 20 (1.35%) WCF
15 17 (1.15%) WPF
16 14 (0.95%) Castle Windsor
17 13 (0.88%) Razor View Engine
Miscellaneous
1 94 (6.36%) Management Information System
1 94 (6.36%) Computer Science
2 83 (5.62%) Replication
3 67 (4.54%) Data Integration
4 64 (4.33%) Clustering
5 52 (3.52%) Visualisation
6 34 (2.30%) Statistics
7 31 (2.10%) Mathematics
8 24 (1.62%) Online Games
9 21 (1.42%) Data Extraction
9 21 (1.42%) Enterprise Software
10 20 (1.35%) GIS
11 19 (1.29%) Data Conversion
11 19 (1.29%) Credit Risk
12 17 (1.15%) iPad
13 16 (1.08%) Hedge funds
13 16 (1.08%) Client/Server
14 15 (1.02%) Kindle
14 15 (1.02%) Inversion of Control
15 13 (0.88%) Open Source
Operating Systems
1 143 (9.68%) Windows
2 114 (7.72%) Linux
3 59 (3.99%) UNIX
4 28 (1.90%) Windows Server 2008
5 17 (1.15%) Android
5 17 (1.15%) Windows Server 2003
6 14 (0.95%) AIX
7 6 (0.41%) Oracle Linux
8 4 (0.27%) Solaris
8 4 (0.27%) Ubuntu
9 3 (0.20%) CentOS
9 3 (0.20%) Red Hat Enterprise Linux
10 2 (0.14%) Apple iOS
10 2 (0.14%) VMS
11 1 (0.068%) Windows 7
Processes & Methodologies
1 1044 (70.68%) Business Intelligence
2 758 (51.32%) ETL
3 303 (20.51%) Data Modelling
4 202 (13.68%) Analytics
5 187 (12.66%) Dimensional Modelling
6 169 (11.44%) Performance Tuning
7 155 (10.49%) Kimball Methodology
8 150 (10.16%) Agile Software Development
9 124 (8.40%) Project Management
10 121 (8.19%) Data Management
11 120 (8.12%) Scrum
12 90 (6.09%) Business Analysis
13 88 (5.96%) E-Commerce
14 77 (5.21%) Data Analysis
14 77 (5.21%) Data Architecture
15 72 (4.87%) CRM
16 66 (4.47%) OO
17 62 (4.20%) Migration
18 57 (3.86%) Performance Management
19 54 (3.66%) Change Management
Programming Languages
1 1037 (70.21%) SQL
2 456 (30.87%) T-SQL
3 232 (15.71%) C#
4 99 (6.70%) Java
5 94 (6.36%) PL/SQL
6 67 (4.54%) JavaScript
7 51 (3.45%) VBA
8 36 (2.44%) VB.NET
9 28 (1.90%) Data Mining Extensions (DMX)
10 27 (1.83%) Python
11 26 (1.76%) PowerShell
12 24 (1.62%) VB
13 21 (1.42%) Shell Script
14 20 (1.35%) PHP
15 15 (1.02%) R
16 13 (0.88%) C
17 9 (0.61%) Perl
17 9 (0.61%) X++
17 9 (0.61%) Data Analysis Expressions (DAX)
18 7 (0.47%) C++
Qualifications
1 208 (14.08%) Degree
2 87 (5.89%) Microsoft Certification
3 28 (1.90%) MCITP
4 23 (1.56%) MCDBA
4 23 (1.56%) MCAD
5 19 (1.29%) Security Cleared
6 14 (0.95%) MCTS
7 13 (0.88%) Oracle Certification
7 13 (0.88%) ITIL Certification
7 13 (0.88%) PMI Certification
8 10 (0.68%) ACCA
8 10 (0.68%) CIMA
9 6 (0.41%) MCSE
10 5 (0.34%) MCSD
10 5 (0.34%) PhD
11 4 (0.27%) SAS Certification
12 3 (0.20%) HND
12 3 (0.20%) MCSA
12 3 (0.20%) ISEB
12 3 (0.20%) ISTQB
Quality Assurance & Compliance
1 78 (5.28%) QA
2 23 (1.56%) ISO 9001
3 16 (1.08%) SLA
4 14 (0.95%) PCI DSS
5 10 (0.68%) Data Quality
6 8 (0.54%) TickIT
7 5 (0.34%) Sarbanes-Oxley
8 4 (0.27%) GAAP
8 4 (0.27%) HL7
9 3 (0.20%) ISO/IEC 27001
System Software
1 29 (1.96%) Oracle RAC
2 9 (0.61%) VMware Infrastructure
3 7 (0.47%) Active Directory
4 6 (0.41%) Oracle RMAN
4 6 (0.41%) HDFS
5 3 (0.20%) Hyper-V
6 2 (0.14%) XenApp
6 2 (0.14%) XenDesktop
6 2 (0.14%) VMware ESX
Systems Management
1 29 (1.96%) 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
5 2 (0.14%) OSSEC
5 2 (0.14%) Puppet
5 2 (0.14%) Red Hat Spacewalk
5 2 (0.14%) Nagios
6 1 (0.068%) Tivoli
Vendors
1 551 (37.31%) Microsoft
2 353 (23.90%) Oracle
3 171 (11.58%) Cognos
4 128 (8.67%) Business Objects
5 118 (7.99%) IBM
6 74 (5.01%) Informatica
7 70 (4.74%) SAP
8 60 (4.06%) MicroStrategy
9 55 (3.72%) Tableau
10 48 (3.25%) Teradata
11 45 (3.05%) Sybase
12 41 (2.78%) Netezza
13 26 (1.76%) Talend
13 26 (1.76%) Dundas
14 22 (1.49%) Hyperion
15 17 (1.15%) Vertica
16 16 (1.08%) Sun
17 14 (0.95%) Red Gate
18 13 (0.88%) VMware
18 13 (0.88%) JBoss
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £45K + Excellent Benefits
Posted: 3 hours ago
Cardiff, South Glamorgan
Computer Recruiter Ltd
Salary: To £40K + Excellent Benefits
Posted: 3 hours ago
West Sussex
Oscar Associates (UK) Ltd
Salary: £25000 - £40000 per annum
Posted: 4 hours ago
City, London
Lawrence Harvey Enterprise
Salary: £60000.00 - £85000 per annum + Bonus
Posted: 17 hours ago
London
Exposed Solutions
Salary: £50000 to £70000 per annum - Excellent Benefits & Bonus
Posted: 18 hours ago
City, London
Venturi
Salary: £60000 - £65000 per annum + full benefits
Posted: 21 hours ago
Crawley, West Sussex
Comtecs
Salary: £70000 - £80000 Per Annum + Excellent Benefits
Posted: Yesterday
Staffordshire
SmartSourcing plc
Salary: highly negotiable + car and bonus
Posted: Yesterday
Cambridge, Cambridgeshire
Circle Recruitment
Salary: £30000 - £35000 per annum + bens
Posted: Yesterday
Staffordshire
SmartSourcing plc
Salary: ''s highly negotiable + Bonus + Benefits
Posted: Yesterday
London
Harnham
Salary: £45000 - £65000 per annum + Bonus, Pension and More
Posted: Yesterday
City, London
Energon Technology
Salary: From £45,000 to £60,000 per annum + bonus + benefits
Posted: 2 days ago
Croydon, Surrey
Energon Technology
Salary: Up to £55,000 per annum + benefits + bonus
Posted: 3 days ago
City, London
Ortolan Group
Posted: 3 days ago
London
Salt
Salary: £45000 - £50000 per annum + Benefits
Posted: 3 days ago
Cambridge, Cambridgeshire
Circle Recruitment
Salary: £30000 - £35000 per annum + bens
Posted: 3 days ago
London
Arrows Group
Salary: £50000 - £65000 per annum + Benefits
Posted: 4 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 40-60k
Posted: 4 days ago
Reading, Berkshire
Oxbridge Answers
Salary: 60-75k
Posted: 4 days ago
Derbyshire
Oscar Associates (UK) Ltd
Salary: £30000 - £42000 per annum
Posted: 4 days ago