The table below looks at the statistics for OLAP skills in IT jobs advertised for the England region. Included is a guide to the salaries offered in IT jobs that have cited OLAP over the 3 months to 1 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
1 Jul 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 537 497 439
Rank change year-on-year
-40 -58
Permanent jobs citing OLAP 381 530 719
As % of all permanent IT jobs located in England 0.42% 0.51% 0.64%
As % of the Database & Business Intelligence category 1.40% 1.57% 1.98%
Number of salaries quoted 312 430 616
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £40,000 £32,500 £36,900
10% offered a salary of more than £77,250 £72,500 £70,000
UK excluding London median salary £46,750 £40,000 £42,624
% change year-on-year
+16.87% -6.15%
OLAP
UK

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
27285 33731 36311
As % of all permanent IT jobs located in England 29.89% 32.64% 32.28%
Number of salaries quoted 23609 28719 31425
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £32,500 £32,000 £30,500
10% offered a salary of more than £75,000 £70,000 £70,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLAP
Jobs Demand Trend in England

The demand trend of job ads across the England region citing OLAP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLAP Jobs Demand Trend in England

OLAP
Salary Trend in England

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLAP across the England region.

OLAP Salary Trend in England

OLAP
Salary Histogram in England

This chart provides a salary histogram for IT jobs citing OLAP across the England region over the 3 months to 1 July 2016.

OLAP Salary Histogram in England

OLAP
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLAP within the England region over the 3 months to 1 July 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
London -9 168 £60,000 - 12
West Midlands +13 52 £45,000 +14.64% 2
South East -46 49 £50,000 +25.00% 12
East of England +55 37 £45,000 - 4
Yorkshire -15 21 £71,250 +78.12% 2
East Midlands +14 17 £50,000 +25.00% 1
South West +9 16 £42,500 -5.55% 3
North West +9 14 £36,250 -9.37% 3
North East - 7 £40,000 -
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 1 July 2016, IT jobs citing OLAP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the England region with a requirement for OLAP.

1 542 (74.86%) Business Intelligence
2 508 (70.17%) SQL
3 488 (67.40%) SQL Server
4 426 (58.84%) Data Warehouse
5 373 (51.52%) SQL Server Reporting Services
6 361 (49.86%) SQL Server Integration Services
7 349 (48.20%) SQL Server Analysis Services
8 348 (48.07%) ETL
9 297 (41.02%) Microsoft
10 243 (33.56%) OLAP Cube
11 209 (28.87%) Finance
12 194 (26.80%) T-SQL
13 191 (26.38%) Agile Software Development
14 181 (25.00%) MS Excel
15 178 (24.59%) Oracle
15 178 (24.59%) Oracle OLAP
16 164 (22.65%) SQL Server 2012
17 163 (22.51%) OLTP
18 149 (20.58%) Analytical Skills
19 135 (18.65%) Data Modelling
20 122 (16.85%) Kimball Methodology
21 120 (16.57%) MDX
22 119 (16.44%) Analytics
23 115 (15.88%) Relational Database
24 111 (15.33%) SQL Server 2008
25 108 (14.92%) Tableau
26 100 (13.81%) Performance Tuning
27 83 (11.46%) PL/SQL
28 80 (11.05%) Dimensional Modelling
29 79 (10.91%) SQL Server 2014

OLAP
Top Related IT Skills in England by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 43 (5.94%) SharePoint
2 41 (5.66%) SAS
3 14 (1.93%) Apache
3 14 (1.93%) Tomcat
4 13 (1.80%) IIS
5 11 (1.52%) WebSphere
6 10 (1.38%) Oracle Coherence
6 10 (1.38%) Oracle HTTP Server
7 8 (1.10%) Apache Spark
8 6 (0.83%) Confluence
9 5 (0.69%) Apache Pig
9 5 (0.69%) Elasticsearch
9 5 (0.69%) Oracle Spatial
9 5 (0.69%) Oracle Workflow
10 4 (0.55%) BizTalk Server
11 2 (0.28%) SharePoint 2013
12 1 (0.14%) Blackberry Enterprise Server
12 1 (0.14%) MS Exchange
12 1 (0.14%) NetWeaver
Applications
1 181 (25.00%) MS Excel
2 23 (3.18%) MS Office
3 18 (2.49%) MS Visio
4 3 (0.41%) MS PowerPoint
4 3 (0.41%) SPSS
5 2 (0.28%) Spreadsheet
6 1 (0.14%) Acrobat
6 1 (0.14%) MS Project
Business Applications
1 12 (1.66%) SAP Business One
2 8 (1.10%) Cognos Business Intelligence
3 7 (0.97%) Cognos TM1
4 5 (0.69%) HFM
4 5 (0.69%) SAP BPC
4 5 (0.69%) Unica
5 4 (0.55%) Oracle Financials
6 3 (0.41%) Dynamics NAV
6 3 (0.41%) SAP Oil and Gas
7 2 (0.28%) Cognos Planning
7 2 (0.28%) Dynamics AX
7 2 (0.28%) Hyperion Planning
7 2 (0.28%) JDE OneWorld
7 2 (0.28%) Oracle EBS
8 1 (0.14%) Cognos Controller
8 1 (0.14%) Oracle Applications
8 1 (0.14%) Oracle Financial Analyzer
Cloud Services
1 44 (6.08%) Microsoft Azure
2 16 (2.21%) Amazon AWS
3 5 (0.69%) SaaS
4 2 (0.28%) Azure Machine Learning
4 2 (0.28%) IaaS
4 2 (0.28%) PaaS
5 1 (0.14%) GitHub
Communications & Networking
1 18 (2.49%) Intranet
2 16 (2.21%) Extranet
3 14 (1.93%) SAN
4 13 (1.80%) HTTP
4 13 (1.80%) LAN
4 13 (1.80%) WAN
5 10 (1.38%) FCoE
5 10 (1.38%) Fibre Channel
5 10 (1.38%) iSCSI
5 10 (1.38%) Multicast
5 10 (1.38%) NAS
6 5 (0.69%) Firewall
7 2 (0.28%) DHCP
7 2 (0.28%) DNS
7 2 (0.28%) Skype
7 2 (0.28%) TCP/IP
8 1 (0.14%) PABX
8 1 (0.14%) PBX
8 1 (0.14%) Remote Desktop
8 1 (0.14%) VoIP
Database & Business Intelligence
1 488 (67.40%) SQL Server
2 426 (58.84%) Data Warehouse
3 373 (51.52%) SQL Server Reporting Services
4 361 (49.86%) SQL Server Integration Services
5 349 (48.20%) SQL Server Analysis Services
6 243 (33.56%) OLAP Cube
7 178 (24.59%) Oracle OLAP
8 164 (22.65%) SQL Server 2012
9 163 (22.51%) OLTP
10 115 (15.88%) Relational Database
11 111 (15.33%) SQL Server 2008
12 79 (10.91%) SQL Server 2014
13 69 (9.53%) Hadoop
14 66 (9.12%) BusinessObjects
15 65 (8.98%) Big Data
16 56 (7.73%) Microsoft Analysis Services
16 56 (7.73%) PowerPivot
17 55 (7.60%) SQL Server 2005
18 51 (7.04%) QlikView
19 50 (6.91%) RDBMS
Development Applications
1 21 (2.90%) Team Foundation Server
2 17 (2.35%) Git (software)
3 11 (1.52%) JIRA
4 10 (1.38%) Visual Studio
5 9 (1.24%) Jenkins
6 7 (0.97%) Eclipse
7 6 (0.83%) ERwin
8 5 (0.69%) SQL Server Management Studio (SSMS)
9 4 (0.55%) Subversion
9 4 (0.55%) tSQLt
10 2 (0.28%) Visual Studio Tools for Office
11 1 (0.14%) JUnit
11 1 (0.14%) Maven
11 1 (0.14%) Oracle Forms
11 1 (0.14%) Talend Open Studio
General
1 209 (28.87%) Finance
2 53 (7.32%) Banking
3 45 (6.22%) Marketing
4 38 (5.25%) Games
5 37 (5.11%) Retail
6 27 (3.73%) Investment Banking
6 27 (3.73%) Telecoms
7 23 (3.18%) Legal
8 17 (2.35%) Front Office
8 17 (2.35%) Manufacturing
9 8 (1.10%) Advertising
9 8 (1.10%) Publishing
10 6 (0.83%) Back Office
11 3 (0.41%) Electronics
12 2 (0.28%) Financial Institution
12 2 (0.28%) Law
13 1 (0.14%) Automotive
13 1 (0.14%) Billing
13 1 (0.14%) Military
13 1 (0.14%) Pharmaceutical
Job Titles
1 397 (54.83%) Developer
2 250 (34.53%) Business Intelligence Developer
3 176 (24.31%) SQL Developer
4 104 (14.36%) SSAS Developer
5 98 (13.54%) SQL BI Developer
6 86 (11.88%) SSIS Developer
7 84 (11.60%) Analyst
8 83 (11.46%) SQL Server Developer
9 81 (11.19%) Architect
10 72 (9.94%) SSRS Developer
11 64 (8.84%) Senior Developer
12 62 (8.56%) Consultant
13 51 (7.04%) SQL Server BI Developer
14 48 (6.63%) DBA
15 45 (6.22%) Oracle Developer
16 42 (5.80%) Business Intelligence Consultant
17 41 (5.66%) Data Architect
18 38 (5.25%) Business Intelligence Lead
19 36 (4.97%) Business Developer
20 35 (4.83%) Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 120 (16.57%) MDX
2 67 (9.25%) .NET
3 44 (6.08%) XML
4 30 (4.14%) HTML
5 19 (2.62%) Web Services
6 16 (2.21%) Oracle GoldenGate
7 12 (1.66%) jQuery
8 11 (1.52%) Middleware
8 11 (1.52%) SOAP
9 10 (1.38%) REST
10 8 (1.10%) CSS
11 7 (0.97%) ASP.NET
11 7 (0.97%) JSON
11 7 (0.97%) WCF
12 6 (0.83%) Django
13 5 (0.69%) WF
13 5 (0.69%) Windows Identity Foundation
14 4 (0.55%) AngularJS
14 4 (0.55%) HTML5
14 4 (0.55%) Node.js
Miscellaneous
1 149 (20.58%) Analytical Skills
2 61 (8.43%) Visualisation
3 58 (8.01%) Data Integration
4 45 (6.22%) Enterprise Software
5 42 (5.80%) Replication
6 41 (5.66%) Computer Science
7 36 (4.97%) Management Information System
8 30 (4.14%) Statistics
9 26 (3.59%) Data Extraction
10 22 (3.04%) Credit Risk
11 19 (2.62%) Clustering
12 18 (2.49%) Online Games
13 16 (2.21%) Fintech
14 13 (1.80%) Mathematics
15 11 (1.52%) Data Structures
15 11 (1.52%) Economics
16 10 (1.38%) Data Protection Act
17 9 (1.24%) Data Conversion
18 6 (0.83%) Freedom of Information
18 6 (0.83%) iPad
Operating Systems
1 45 (6.22%) Linux
2 39 (5.39%) Windows
3 36 (4.97%) Unix
4 10 (1.38%) Oracle Linux
4 10 (1.38%) Solaris
5 7 (0.97%) Windows Server 2012
6 6 (0.83%) Windows Server
6 6 (0.83%) Windows Server 2008
7 2 (0.28%) Windows 7
8 1 (0.14%) CentOS
8 1 (0.14%) Windows Vista
Processes & Methodologies
1 542 (74.86%) Business Intelligence
2 348 (48.07%) ETL
3 191 (26.38%) Agile Software Development
4 135 (18.65%) Data Modelling
5 122 (16.85%) Kimball Methodology
6 119 (16.44%) Analytics
7 100 (13.81%) Performance Tuning
8 80 (11.05%) Dimensional Modelling
9 62 (8.56%) Business Analysis
10 56 (7.73%) Scrum
11 55 (7.60%) Data Management
12 54 (7.46%) Data Analysis
13 51 (7.04%) SDLC
14 39 (5.39%) ITIL
15 38 (5.25%) Data Architecture
16 36 (4.97%) Data Analytics
17 34 (4.70%) Project Management
18 30 (4.14%) DNA
19 29 (4.01%) E-Commerce
20 28 (3.87%) SOA
Programming Languages
1 508 (70.17%) SQL
2 194 (26.80%) T-SQL
3 83 (11.46%) PL/SQL
4 65 (8.98%) C#
5 42 (5.80%) Java
6 39 (5.39%) JavaScript
7 33 (4.56%) VBA
8 27 (3.73%) Python
9 22 (3.04%) C
10 21 (2.90%) Data Analysis Expressions (DAX)
11 13 (1.80%) VB.NET
12 12 (1.66%) PHP
13 11 (1.52%) PowerShell
14 10 (1.38%) R
14 10 (1.38%) Shell Script
15 9 (1.24%) C++
16 7 (0.97%) VB
17 6 (0.83%) Perl
18 5 (0.69%) Ruby
18 5 (0.69%) Scala
Qualifications
1 76 (10.50%) Degree
2 23 (3.18%) Microsoft Certification
3 8 (1.10%) ACCA
3 8 (1.10%) CIMA
4 7 (0.97%) MCSE
5 4 (0.55%) MCITP
5 4 (0.55%) MCP
5 4 (0.55%) MCSA
5 4 (0.55%) Oracle Certification
6 3 (0.41%) IBM Certification
6 3 (0.41%) MCAD
6 3 (0.41%) SC Cleared
6 3 (0.41%) Security Cleared
7 2 (0.28%) AAT
7 2 (0.28%) ISEB
8 1 (0.14%) CISSP
8 1 (0.14%) HND
8 1 (0.14%) ITIL Certification
8 1 (0.14%) MBA
8 1 (0.14%) MCDBA
Quality Assurance & Compliance
1 47 (6.49%) Data Quality
2 27 (3.73%) QA
3 10 (1.38%) PCI DSS
4 4 (0.55%) Basel II
5 3 (0.41%) Sarbanes-Oxley
5 3 (0.41%) SLA
System Software
1 20 (2.76%) Oracle RAC
2 11 (1.52%) KVM
2 11 (1.52%) VMware Infrastructure
3 10 (1.38%) Hyper-V
3 10 (1.38%) NFS
3 10 (1.38%) SRDF
3 10 (1.38%) Xen
4 2 (0.28%) Virtual Machines
5 1 (0.14%) Active Directory
5 1 (0.14%) Docker
5 1 (0.14%) Microsoft Virtual Server
5 1 (0.14%) Virtual Servers
5 1 (0.14%) VirtualBox
Systems Management
1 11 (1.52%) Data Guard
2 10 (1.38%) Oracle Enterprise Manager
3 5 (0.69%) Mesos
3 5 (0.69%) Microsoft Clustering
4 4 (0.55%) OpenView
5 3 (0.41%) Puppet
6 2 (0.28%) Cisco IPCC
7 1 (0.14%) ITRS Geneos
7 1 (0.14%) Oozie
Vendors
1 297 (41.02%) Microsoft
2 178 (24.59%) Oracle
3 108 (14.92%) Tableau
4 51 (7.04%) Cognos
4 51 (7.04%) SAP
5 28 (3.87%) IBM
6 24 (3.31%) Teradata
7 23 (3.18%) Netezza
8 16 (2.21%) VMware
9 12 (1.66%) MicroStrategy
10 10 (1.38%) Cisco
10 10 (1.38%) EMC
10 10 (1.38%) Intel
10 10 (1.38%) NetApp
10 10 (1.38%) Splunk
10 10 (1.38%) Sybase
11 8 (1.10%) Vertica
12 7 (0.97%) Hitachi
12 7 (0.97%) Hyperion
12 7 (0.97%) Informatica
Slough, Berkshire
Nigel Frank International Ltd
Salary: £50000 - £55000 per annum
Posted: 8 hours ago
Bath, Avon
Opus Recruitment Solutions Ltd
Salary: £30000 per annum
Posted: 11 hours ago
London
Burns Sheehan
Salary: £0.00 - £65000 per annum
Posted: 1 hour ago
City, London
HAYS INFORMATION TECHNOLOGY
Salary: £45000.00 - £55000.00 per annum
Posted: 2 days ago
Slough, Berkshire
Oscar
Salary: £45000 - £55000 per annum + Benefits
Posted: Yesterday
City, London
ANSON MCCADE
Salary: £60,000 to £73,500 basic (+ superb package!!!)
Posted: Yesterday
Birmingham, West Midlands (County)
Rullion IT Plus
Salary: £35000 - £50000 per annum + 10% bonus & more
Posted: Yesterday
Yorkshire
Lawrence Harvey
Salary: £40000 - £55000 per annum
Posted: 3 days ago
Slough, Berkshire
X4 Group
Salary: £45k - 55k per year
Posted: 2 days ago
North Yorkshire
Lawrence Harvey Enterprise
Salary: £40000 - £55000 per annum
Posted: 3 days ago
Tunbridge Wells, Kent
Evolution Recruitment Solutions
Salary: 20,000 - 25,000
Posted: 3 days ago
City, London
ANSON MCCADE
Salary: £50,000 - £75,000
Posted: 4 days ago
Liverpool, Merseyside
Search Consultancy
Salary: Benefits
Posted: 3 days ago
City, London
Searchability
Salary: £25000 - £30000 per annum + benefits
Posted: 4 days ago
City, London
ANSON MCCADE
Salary: £65,000 - £75,000
Posted: 3 days ago
City, London
ANSON MCCADE
Salary: £50,000 - £75,000
Posted: 3 days ago
Camborne
Recruitment Genius Ltd
Salary: £45000 - £55000 per annum
Posted: 4 days ago
Southampton, Hampshire
Go IT Recruitment Ltd
Salary: From £35,000 to £50,000 per annum + 25 days Holiday + Great career pro
Posted: 4 days ago
London
Logic Engagements Ltd
Salary: £75000 - £85000 per annum + Car allowance + bonus ++
Posted: 3 days ago
Scunthorpe, South Humberside
HAYS INFORMATION TECHNOLOGY
Salary: £35000.00 - £40000.00 per annum + Car
Posted: 2 days ago
London
Optima Connections
Salary: Up to £50,000 per annum Bonus + Benefits
Posted: 4 days ago
Milton Keynes, Buckinghamshire, United Kingdom
White Clarke Group
Salary: £28 - £42k + Excellent Benefits
Posted: 9 days ago
Basingstoke
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: 4 days ago
Crewe
OCC Computer Personnel
Salary: £25k - 32k per year + Benefits
Posted: 4 days ago
Abingdon
Sophos
Salary: Highly Competitive + bonus & benefits
Posted: 4 days ago
Liverpool
Computer Futures
Salary: competitive
Posted: 10 days ago
Cambridgeshire
Lawrence Harvey
Salary: £45000.00 - £55000.00 per annum + pension, bonus etc
Posted: 14 days ago
Southampton
Hays Specialist Recruitment Ltd
Salary: £30000 - £50000 per annum + Package
Posted: 14 days ago
London
TDA Group
Salary: £65000 per annum + Benefits & Bonus
Posted: 8 days ago
Southampton
Spectrum IT
Salary: £45000 - £55000 per annum + benefits
Posted: 10 days ago