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 October 2016 with a comparison to the same period over the previous 2 years.

3 months to
1 Oct 2016
Same period 2015 Same period 2014
Online Analytical Processing (OLAP)
Rank 606 490 441
Rank change year-on-year
-116 -49
Permanent jobs citing OLAP 279 516 675
As % of all permanent IT jobs located in England 0.32% 0.51% 0.63%
As % of the Database & Business Intelligence category 1.07% 1.64% 2.02%
Number of salaries quoted 230 401 578
Median salary £50,000 £48,045 £52,500
Median salary % change year-on-year
+4.07% -8.48%
90% offered a salary of more than £37,500 £35,000 £35,000
10% offered a salary of more than £80,000 £70,000 £70,000
UK excluding London median salary £50,000 £42,500 £42,500
% change year-on-year
+17.64% -
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
26090 31432 33494
As % of all permanent IT jobs located in England 29.51% 30.92% 31.39%
Number of salaries quoted 22418 26819 28374
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,500 £30,000
10% offered a salary of more than £75,000 £67,500 £72,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

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 October 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 October 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 -63 113 £65,000 +13.04% 9
South East +21 74 £50,000 +17.64% 2
Yorkshire +32 30 £45,000 - 3
North West -16 18 £45,000 +1.12% 5
South West -6 13 £50,000 +25.00% 2
East of England +25 12 £50,000 +11.11% 3
East Midlands +10 8 £37,500 -11.76%
West Midlands -55 6 £36,250 -9.37% 2
North East +9 4 £38,750 +19.23% 2
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 1 October 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 498 (75.45%) SQL
2 477 (72.27%) Business Intelligence
3 475 (71.97%) SQL Server
4 382 (57.88%) Data Warehouse
5 302 (45.76%) SQL Server Reporting Services
6 291 (44.09%) ETL
7 287 (43.48%) SQL Server Analysis Services
8 286 (43.33%) SQL Server Integration Services
9 273 (41.36%) Microsoft
10 224 (33.94%) T-SQL
11 213 (32.27%) OLAP Cube
12 192 (29.09%) Finance
13 191 (28.94%) Agile Software Development
14 187 (28.33%) OLTP
15 175 (26.52%) MS Excel
16 158 (23.94%) Oracle
16 158 (23.94%) Oracle OLAP
17 133 (20.15%) Analytical Skills
18 131 (19.85%) SQL Server 2012
19 125 (18.94%) Tableau
20 121 (18.33%) MDX
21 115 (17.42%) Data Modelling
21 115 (17.42%) Analytics
22 114 (17.27%) Performance Tuning
23 106 (16.06%) Kimball Methodology
24 102 (15.45%) Big Data
25 94 (14.24%) Hadoop
26 93 (14.09%) Relational Database
27 82 (12.42%) SQL Server 2008
28 73 (11.06%) Dimensional Modelling

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 47 (7.12%) SAS
2 40 (6.06%) SharePoint
3 26 (3.94%) IIS
4 25 (3.79%) Apache Spark
5 23 (3.48%) Apache
5 23 (3.48%) Tomcat
6 22 (3.33%) Oracle Coherence
6 22 (3.33%) WebSphere
7 21 (3.18%) Oracle HTTP Server
8 14 (2.12%) Apache Pig
9 6 (0.91%) Elasticsearch
10 3 (0.45%) Oracle Spatial
11 2 (0.30%) Jupyter
11 2 (0.30%) NetWeaver
11 2 (0.30%) Oracle Workflow
11 2 (0.30%) SharePoint 2013
11 2 (0.30%) SharePoint Server
12 1 (0.15%) Blackberry Enterprise Server
12 1 (0.15%) MS Exchange
Applications
1 175 (26.52%) MS Excel
2 9 (1.36%) MS Office
3 4 (0.61%) Gephi
4 3 (0.45%) MS Visio
5 2 (0.30%) MS PowerPoint
6 1 (0.15%) Acrobat
6 1 (0.15%) MS Project
6 1 (0.15%) Spreadsheet
6 1 (0.15%) SPSS
Business Applications
1 15 (2.27%) Cognos TM1
2 13 (1.97%) Cognos Business Intelligence
3 12 (1.82%) SAP Business One
4 11 (1.67%) Oracle EBS
5 9 (1.36%) Cognos Controller
6 6 (0.91%) SAP BPC
7 4 (0.61%) Dynamics NAV
7 4 (0.61%) Oracle Financials
8 3 (0.45%) SAP Oil and Gas
9 2 (0.30%) Dynamics AX
9 2 (0.30%) Dynamics CRM
9 2 (0.30%) HFM
9 2 (0.30%) Infor M3
9 2 (0.30%) Magento
9 2 (0.30%) Unica
10 1 (0.15%) Cognos Planning
10 1 (0.15%) FastStats
10 1 (0.15%) Hyperion Planning
10 1 (0.15%) JDE EnterpriseOne
10 1 (0.15%) Oracle Financial Analyzer
Cloud Services
1 42 (6.36%) Microsoft Azure
2 21 (3.18%) Amazon AWS
3 13 (1.97%) GitHub
4 7 (1.06%) Azure Machine Learning
4 7 (1.06%) Data Lake Analytics
4 7 (1.06%) IaaS
4 7 (1.06%) PaaS
5 6 (0.91%) SaaS
6 5 (0.76%) Amazon S3
7 3 (0.45%) Google Cloud Platform
8 1 (0.15%) Google Play
Communications & Networking
1 32 (4.85%) SAN
2 25 (3.79%) LAN
2 25 (3.79%) WAN
3 23 (3.48%) HTTP
4 21 (3.18%) FCoE
4 21 (3.18%) Fibre Channel
4 21 (3.18%) iSCSI
4 21 (3.18%) Multicast
4 21 (3.18%) NAS
5 12 (1.82%) Extranet
5 12 (1.82%) Intranet
6 11 (1.67%) Firewall
7 3 (0.45%) PBX
7 3 (0.45%) Skype
8 2 (0.30%) DHCP
8 2 (0.30%) DNS
8 2 (0.30%) TCP/IP
9 1 (0.15%) Ethernet
9 1 (0.15%) Internet
9 1 (0.15%) VoIP
Database & Business Intelligence
1 475 (71.97%) SQL Server
2 382 (57.88%) Data Warehouse
3 302 (45.76%) SQL Server Reporting Services
4 287 (43.48%) SQL Server Analysis Services
5 286 (43.33%) SQL Server Integration Services
6 213 (32.27%) OLAP Cube
7 187 (28.33%) OLTP
8 158 (23.94%) Oracle OLAP
9 131 (19.85%) SQL Server 2012
10 102 (15.45%) Big Data
11 94 (14.24%) Hadoop
12 93 (14.09%) Relational Database
13 82 (12.42%) SQL Server 2008
14 72 (10.91%) SQL Server 2014
15 68 (10.30%) Microsoft Analysis Services
16 56 (8.48%) NoSQL
17 55 (8.33%) MySQL
18 53 (8.03%) Power BI
18 53 (8.03%) QlikView
19 49 (7.42%) RDBMS
Development Applications
1 28 (4.24%) Team Foundation Server
2 25 (3.79%) JIRA
3 23 (3.48%) Visual Studio
4 11 (1.67%) Jenkins
4 11 (1.67%) SQL Server Management Studio (SSMS)
4 11 (1.67%) Talend Open Studio
5 9 (1.36%) Vagrant
6 7 (1.06%) Cucumber
6 7 (1.06%) ERwin
6 7 (1.06%) Visual Studio Tools for Office
7 6 (0.91%) tSQLt
8 4 (0.61%) Maven
9 3 (0.45%) Eclipse
10 2 (0.30%) Git (software)
10 2 (0.30%) Subversion
11 1 (0.15%) Gradle
11 1 (0.15%) TeamCity
11 1 (0.15%) Visual Studio Team System
General
1 192 (29.09%) Finance
2 50 (7.58%) Banking
3 39 (5.91%) Retail
4 30 (4.55%) Manufacturing
5 22 (3.33%) Games
5 22 (3.33%) Marketing
6 18 (2.73%) Legal
7 17 (2.58%) Telecoms
8 16 (2.42%) Investment Banking
9 14 (2.12%) Front Office
10 9 (1.36%) Publishing
11 6 (0.91%) Advertising
12 5 (0.76%) Back Office
13 4 (0.61%) Electronics
14 2 (0.30%) Billing
14 2 (0.30%) Financial Institution
14 2 (0.30%) Law
15 1 (0.15%) Automotive
Job Titles
1 342 (51.82%) Developer
2 232 (35.15%) Business Intelligence Developer
3 119 (18.03%) SQL Developer
4 90 (13.64%) Architect
5 68 (10.30%) DBA
6 64 (9.70%) SQL BI Developer
7 59 (8.94%) Analyst
8 53 (8.03%) SSAS Developer
8 53 (8.03%) SSIS Developer
9 52 (7.88%) SQL DBA
10 48 (7.27%) Data Architect
11 44 (6.67%) ETL Developer
11 44 (6.67%) Senior Developer
12 40 (6.06%) Consultant
13 38 (5.76%) SSRS Developer
14 37 (5.61%) SQL Server Developer
15 35 (5.30%) SQL Server DBA
16 29 (4.39%) Business Developer
16 29 (4.39%) Business Intelligence Consultant
17 28 (4.24%) Business Intelligence Lead
Libraries, Frameworks & Software Standards
1 121 (18.33%) MDX
2 50 (7.58%) .NET
3 33 (5.00%) XML
4 27 (4.09%) Web Services
5 22 (3.33%) Middleware
6 18 (2.73%) HTML
7 17 (2.58%) JSON
8 14 (2.12%) REST
9 12 (1.82%) D3.js
10 10 (1.52%) ASP.NET
10 10 (1.52%) HTML5
10 10 (1.52%) Oracle GoldenGate
11 8 (1.21%) jQuery
12 7 (1.06%) Akka
12 7 (1.06%) Leaflet
12 7 (1.06%) SOAP
13 6 (0.91%) .NET Framework
13 6 (0.91%) Django
14 5 (0.76%) CSS
15 4 (0.61%) Spring
Miscellaneous
1 133 (20.15%) Analytical Skills
2 71 (10.76%) Visualisation
3 54 (8.18%) Data Integration
4 37 (5.61%) Computer Science
4 37 (5.61%) Replication
5 36 (5.45%) Enterprise Software
6 30 (4.55%) Clustering
7 29 (4.39%) Management Information System
8 28 (4.24%) Data Extraction
9 21 (3.18%) Statistics
10 16 (2.42%) Fintech
11 11 (1.67%) Neural Network
12 10 (1.52%) Credit Risk
12 10 (1.52%) Data Conversion
12 10 (1.52%) Mathematics
13 8 (1.21%) Data Structures
14 7 (1.06%) iPad
14 7 (1.06%) Mobile App
15 6 (0.91%) Data Protection Act
16 5 (0.76%) Life Science
Operating Systems
1 70 (10.61%) Windows
2 59 (8.94%) Linux
3 30 (4.55%) Unix
4 21 (3.18%) Solaris
5 14 (2.12%) Windows Server
6 4 (0.61%) Oracle Linux
6 4 (0.61%) Windows Server 2008
6 4 (0.61%) Windows Server 2012
7 1 (0.15%) Android
7 1 (0.15%) Apple iOS
7 1 (0.15%) CentOS
7 1 (0.15%) Windows 7
7 1 (0.15%) Windows Vista
Processes & Methodologies
1 477 (72.27%) Business Intelligence
2 291 (44.09%) ETL
3 191 (28.94%) Agile Software Development
4 115 (17.42%) Analytics
4 115 (17.42%) Data Modelling
5 114 (17.27%) Performance Tuning
6 106 (16.06%) Kimball Methodology
7 73 (11.06%) Dimensional Modelling
8 67 (10.15%) Scrum
9 55 (8.33%) Data Management
10 53 (8.03%) Project Management
11 46 (6.97%) Business Analysis
12 45 (6.82%) Data Analysis
13 43 (6.52%) Data Analytics
13 43 (6.52%) SDLC
14 41 (6.21%) Migration
15 40 (6.06%) Data Architecture
16 35 (5.30%) Disaster Recovery
17 30 (4.55%) Risk Management
18 27 (4.09%) Data Visualisation
Programming Languages
1 498 (75.45%) SQL
2 224 (33.94%) T-SQL
3 51 (7.73%) C#
3 51 (7.73%) Java
4 45 (6.82%) PL/SQL
5 43 (6.52%) Data Analysis Expressions (DAX)
6 33 (5.00%) JavaScript
7 31 (4.70%) Python
8 27 (4.09%) PowerShell
9 21 (3.18%) VBA
10 18 (2.73%) R
11 15 (2.27%) C
12 11 (1.67%) Scala
12 11 (1.67%) Shell Script
12 11 (1.67%) VB.NET
13 9 (1.36%) PHP
14 4 (0.61%) VB
15 3 (0.45%) Bash Shell
15 3 (0.45%) XMLA
16 2 (0.30%) C++
Qualifications
1 69 (10.45%) Degree
2 34 (5.15%) Microsoft Certification
3 15 (2.27%) MCSE
4 12 (1.82%) MCITP
5 11 (1.67%) SC Cleared
5 11 (1.67%) Security Cleared
6 6 (0.91%) MCP
6 6 (0.91%) MCSA
7 4 (0.61%) ACCA
7 4 (0.61%) CIMA
8 3 (0.45%) IBM Certification
8 3 (0.45%) ISEB
9 2 (0.30%) Oracle Certification
10 1 (0.15%) AAT
10 1 (0.15%) CISSP
10 1 (0.15%) HND
10 1 (0.15%) ITIL Certification
10 1 (0.15%) Postgraduate
10 1 (0.15%) PRINCE2 Certification
Quality Assurance & Compliance
1 30 (4.55%) Data Quality
2 28 (4.24%) QA
3 3 (0.45%) PCI DSS
4 1 (0.15%) Basel III
4 1 (0.15%) Dodd-Frank
4 1 (0.15%) HIPAA
4 1 (0.15%) ISO/IEC 27001
4 1 (0.15%) SLA
4 1 (0.15%) SSAE 16
System Software
1 27 (4.09%) VMware Infrastructure
2 25 (3.79%) Oracle RAC
3 22 (3.33%) KVM
4 21 (3.18%) Hyper-V
4 21 (3.18%) NFS
4 21 (3.18%) SRDF
4 21 (3.18%) Xen
5 12 (1.82%) Virtual Machines
6 8 (1.21%) HDFS
7 5 (0.76%) VMware ESX
7 5 (0.76%) vSphere
8 3 (0.45%) Apache Flume
9 1 (0.15%) Active Directory
9 1 (0.15%) Firmware
9 1 (0.15%) Microsoft Virtual Server
9 1 (0.15%) Virtual Servers
9 1 (0.15%) VirtualBox
Systems Management
1 13 (1.97%) Microsoft Clustering
2 11 (1.67%) Puppet
3 4 (0.61%) Data Guard
3 4 (0.61%) Mesos
3 4 (0.61%) Oozie
3 4 (0.61%) Oracle Enterprise Manager
4 3 (0.45%) ITRS Geneos
Vendors
1 273 (41.36%) Microsoft
2 158 (23.94%) Oracle
3 125 (18.94%) Tableau
4 61 (9.24%) Cognos
5 46 (6.97%) IBM
6 40 (6.06%) VMware
7 38 (5.76%) SAP
8 26 (3.94%) NetApp
9 22 (3.33%) EMC
10 21 (3.18%) Cisco
10 21 (3.18%) Intel
11 15 (2.27%) Teradata
12 12 (1.82%) Netezza
13 11 (1.67%) Computacenter
13 11 (1.67%) Talend
14 10 (1.52%) Sybase
15 9 (1.36%) Google
15 9 (1.36%) Splunk
16 8 (1.21%) Informatica
16 8 (1.21%) MicroStrategy
Manchester, Lancashire
Erin Associates
Salary: £44000 - £45000 per annum + excellent benefits
Posted: 7 hours ago
Coventry, West Midlands (County)
Leidos
Posted: Yesterday
Manchester
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: Yesterday
City, London
Oxbridge Answers
Salary: 45,000-50,000
Posted: 2 days ago
City, London
Evolution Recruitment Solutions
Salary: 32,000 - 35,000 + Bonus
Posted: 3 days ago
North Yorkshire
Redrock Consulting Ltd
Salary: £30000 - £40000 per annum + Excellent Benefits
Posted: 2 days ago
Leeds, West Yorkshire
onezeero.
Salary: £45000 - £50000 per annum
Posted: 3 days ago
Leeds, West Yorkshire
Redrock Consulting Ltd
Salary: £40000 - £45000 per annum
Posted: 3 days ago
Manchester, Lancashire
Adria Solutions Ltd
Salary: £40000 - £50000 per annum + Benefits
Posted: 5 days ago
City, London
Asset Resourcing Ltd
Salary: £35000 - £36000 per annum + Brand new offices + Full Benefits
Posted: 2 days ago
North West
Lawrence Harvey Enterprise
Salary: £50000.00 - £60000.00 per annum + pension, health care, bonus
Posted: 4 days ago
West London
Hiring People
Salary: £60k - 80k per year
Posted: 5 days ago
Stratford-Upon-Avon, Warwickshire
Rebel Recruitment
Salary: From £40,000 to £55,000 per annum £40k - £50k + £5k benefits/cash alte
Posted: 2 days ago
Oxfordshire
Lawrence Harvey
Salary: £55000.00 - £60000.00 per annum + pension, bonus, health care
Posted: 10 days ago
London
RBC
Posted: 10 hours ago
Suffolk
Nigel Frank International Ltd
Salary: £30000 - £50000 per annum + Pension, Training
Posted: 19 days ago
Cambridge, Cambridgeshire
Cambridge University Press
Salary: From £42,000 to £45,000 per annum + benefits
Posted: 3 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 8 days ago
Manchester
Nigel Frank International Ltd
Salary: £60000 per annum
Posted: 25 days ago
Bristol
Hargreaves Lansdown
Salary: Competitive
Posted: 25 days ago
London
Client Server
Salary: £30k to £38k + bonus + benefits
Posted: 15 days ago
London
Lawrence Harvey
Salary: £50000.00 - £85000.00 per annum + bonus + benefits
Posted: 25 days ago
Luton, Bedfordshire
Tui (Ip) Ltd
Salary: Competitive Salary
Posted: 23 days ago