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

3 months to
24 Jan 2017
Same period 2016 Same period 2015
Online Analytical Processing (OLAP)
UK / England
Rank 575 531 531
Rank change year-on-year
-44 0
Permanent jobs citing OLAP 273 402 435
As % of all permanent IT jobs located in England 0.35% 0.43% 0.45%
As % of the Database & Business Intelligence category 1.15% 1.35% 1.45%
Number of salaries quoted 239 345 365
Median salary £50,000 £52,500 £47,500
Median salary % change year-on-year
-4.76% +10.52%
90% offered a salary of more than £37,000 £35,200 £32,500
10% offered a salary of more than £65,900 £70,000 £72,500
UK excluding London median salary £45,000 £42,500 £40,000
% change year-on-year
+5.88% +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 in the England region.

Database & Business Intelligence Category
England
Permanent IT job ads with a match in the
Database & Business Intelligence category
23722 29742 29971
As % of all permanent IT jobs located in England 30.10% 32.18% 30.93%
Number of salaries quoted 20590 25485 25899
Median salary £50,000 £50,000 £45,000
Median salary % change year-on-year
- +11.11%
90% offered a salary of more than £32,500 £32,500 £31,000
10% offered a salary of more than £75,000 £70,000 £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 24 January 2017.

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 24 January 2017. 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 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 -37 100 £60,000 +4.34% 18
South East +84 77 £52,500 +16.66% 6
East of England +42 40 £43,000 -25.15% 3
West Midlands +8 24 £42,500 +21.42% 4
North West -48 14 £37,500 -21.05% 6
Yorkshire -24 9 £43,750 +2.94% 4
East Midlands +3 6 £45,000 -14.28% 3
OLAP
UK

OLAP
Top 30 Related IT Skills in England

For the 6 months to 24 January 2017, 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 418 (79.02%) SQL
2 378 (71.46%) SQL Server
3 375 (70.89%) Business Intelligence
4 304 (57.47%) Data Warehouse
5 286 (54.06%) SQL Server Integration Services
6 276 (52.17%) SQL Server Analysis Services
7 271 (51.23%) SQL Server Reporting Services
8 260 (49.15%) Microsoft
9 254 (48.02%) ETL
10 211 (39.89%) T-SQL
11 173 (32.70%) Agile Software Development
12 161 (30.43%) OLTP
13 144 (27.22%) OLAP Cube
14 141 (26.65%) MS Excel
15 134 (25.33%) Oracle
15 134 (25.33%) Oracle OLAP
16 124 (23.44%) Finance
17 114 (21.55%) Data Modelling
18 113 (21.36%) Big Data
19 110 (20.79%) MDX
20 108 (20.42%) Power BI
21 107 (20.23%) SQL Server 2012
22 101 (19.09%) Hadoop
23 99 (18.71%) Analytics
23 99 (18.71%) Performance Tuning
24 96 (18.15%) Kimball Methodology
24 96 (18.15%) SQL Server 2008
25 92 (17.39%) Relational Database
26 84 (15.88%) Tableau
27 83 (15.69%) .NET

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 46 (8.70%) SharePoint
2 31 (5.86%) IIS
3 25 (4.73%) Apache
4 21 (3.97%) Apache Pig
4 21 (3.97%) SAS
5 20 (3.78%) Oracle Coherence
6 19 (3.59%) Apache Spark
6 19 (3.59%) Oracle HTTP Server
6 19 (3.59%) Tomcat
6 19 (3.59%) WebSphere
7 7 (1.32%) Oracle SOA Suite
8 5 (0.95%) Jupyter
9 3 (0.57%) Elasticsearch
9 3 (0.57%) Oracle Service Bus
9 3 (0.57%) SharePoint Server
10 2 (0.38%) SharePoint 2013
11 1 (0.19%) Apache Airflow
11 1 (0.19%) Apache Solr
Applications
1 141 (26.65%) MS Excel
2 7 (1.32%) MS Office
2 7 (1.32%) MS Visio
3 2 (0.38%) Gephi
4 1 (0.19%) MS PowerPoint
4 1 (0.19%) SPSS
Business Applications
1 8 (1.51%) SAP BPC
2 7 (1.32%) Cognos TM1
3 6 (1.13%) FastStats
4 5 (0.95%) Dynamics CRM
4 5 (0.95%) Dynamics NAV
5 4 (0.76%) Dynamics AX
6 2 (0.38%) Adobe Campaign
6 2 (0.38%) Cognos Business Intelligence
6 2 (0.38%) Cognos Controller
6 2 (0.38%) Eloqua
6 2 (0.38%) HFM
6 2 (0.38%) Infor M3
6 2 (0.38%) Magento
6 2 (0.38%) Oracle EBS
6 2 (0.38%) Unica
7 1 (0.19%) OPENHousing
7 1 (0.19%) Oracle Applications
7 1 (0.19%) Oracle CRM
7 1 (0.19%) SAP CRM
7 1 (0.19%) SAP SD
Cloud Services
1 50 (9.45%) Microsoft Azure
2 21 (3.97%) Amazon AWS
2 21 (3.97%) GitHub
3 7 (1.32%) Google Cloud Platform
4 6 (1.13%) Azure Machine Learning
4 6 (1.13%) Data Lake Analytics
4 6 (1.13%) SaaS
5 5 (0.95%) Amazon S3
6 3 (0.57%) IaaS
7 2 (0.38%) PaaS
7 2 (0.38%) Responsys
8 1 (0.19%) Amazon Kinesis
8 1 (0.19%) Google Play
Communications & Networking
1 24 (4.54%) SAN
2 23 (4.35%) Intranet
3 19 (3.59%) FCoE
3 19 (3.59%) Fibre Channel
3 19 (3.59%) HTTP
3 19 (3.59%) iSCSI
3 19 (3.59%) LAN
3 19 (3.59%) Multicast
3 19 (3.59%) NAS
3 19 (3.59%) WAN
4 3 (0.57%) Firewall
4 3 (0.57%) Internet
4 3 (0.57%) SSL
5 2 (0.38%) Ethernet
5 2 (0.38%) Extranet
6 1 (0.19%) GPRS
6 1 (0.19%) Skype
Database & Business Intelligence
1 378 (71.46%) SQL Server
2 304 (57.47%) Data Warehouse
3 286 (54.06%) SQL Server Integration Services
4 276 (52.17%) SQL Server Analysis Services
5 271 (51.23%) SQL Server Reporting Services
6 161 (30.43%) OLTP
7 144 (27.22%) OLAP Cube
8 134 (25.33%) Oracle OLAP
9 113 (21.36%) Big Data
10 108 (20.42%) Power BI
11 107 (20.23%) SQL Server 2012
12 101 (19.09%) Hadoop
13 96 (18.15%) SQL Server 2008
14 92 (17.39%) Relational Database
15 74 (13.99%) MySQL
16 71 (13.42%) NoSQL
17 70 (13.23%) SQL Server 2014
18 66 (12.48%) Microsoft Analysis Services
19 63 (11.91%) QlikView
20 58 (10.96%) SQL Server 2005
Development Applications
1 52 (9.83%) Visual Studio
2 51 (9.64%) JIRA
3 42 (7.94%) Team Foundation Server
4 25 (4.73%) Talend Open Studio
5 15 (2.84%) Visual Studio Team System
6 10 (1.89%) Git (software)
6 10 (1.89%) Jenkins
7 9 (1.70%) Vagrant
8 8 (1.51%) SQL Server Management Studio (SSMS)
9 7 (1.32%) Cucumber
9 7 (1.32%) git-flow
10 6 (1.13%) ERwin
11 5 (0.95%) Maven
12 4 (0.76%) PowerDesigner
13 2 (0.38%) JUnit
13 2 (0.38%) Oracle Forms
13 2 (0.38%) TestNG
14 1 (0.19%) Eclipse
14 1 (0.19%) TeamCity
14 1 (0.19%) Visual Studio Tools for Office
General
1 124 (23.44%) Finance
2 29 (5.48%) Banking
3 28 (5.29%) Advertising
4 23 (4.35%) Legal
5 22 (4.16%) Manufacturing
6 18 (3.40%) Retail
7 12 (2.27%) Investment Banking
8 10 (1.89%) Marketing
9 7 (1.32%) Games
10 6 (1.13%) Financial Institution
11 5 (0.95%) German Language
11 5 (0.95%) Spanish Language
12 4 (0.76%) Automotive
12 4 (0.76%) Billing
12 4 (0.76%) Publishing
13 3 (0.57%) Music Industry
13 3 (0.57%) Telecoms
14 2 (0.38%) Electronics
14 2 (0.38%) Front Office
15 1 (0.19%) Pharmaceutical
Job Titles
1 277 (52.36%) Developer
2 167 (31.57%) Business Intelligence Developer
3 79 (14.93%) SQL Developer
4 72 (13.61%) Analyst
4 72 (13.61%) DBA
5 62 (11.72%) Senior Developer
5 62 (11.72%) SSIS Developer
6 54 (10.21%) ETL Developer
7 49 (9.26%) SQL DBA
8 41 (7.75%) Architect
9 40 (7.56%) SSRS Developer
10 38 (7.18%) SSAS Developer
11 36 (6.81%) SQL BI Developer
12 34 (6.43%) Administrator
13 33 (6.24%) Business Intelligence Analyst
14 31 (5.86%) Business Developer
14 31 (5.86%) SQL Server DBA
15 29 (5.48%) Consultant
16 27 (5.10%) Data Warehouse Developer
17 26 (4.91%) Senior Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 110 (20.79%) MDX
2 83 (15.69%) .NET
3 39 (7.37%) XML
4 32 (6.05%) Web Services
5 23 (4.35%) Middleware
6 20 (3.78%) JSON
7 15 (2.84%) Oracle GoldenGate
8 14 (2.65%) HTML
9 13 (2.46%) ASP.NET
10 11 (2.08%) REST
11 10 (1.89%) Akka
12 8 (1.51%) SOAP
12 8 (1.51%) Spring
13 7 (1.32%) .NET Framework
14 6 (1.13%) jQuery
15 5 (0.95%) D3.js
16 4 (0.76%) CSS
17 3 (0.57%) HTML5
17 3 (0.57%) J2EE
17 3 (0.57%) WSDL
Miscellaneous
1 71 (13.42%) Analytical Skills
2 49 (9.26%) Data Integration
2 49 (9.26%) Visualisation
3 46 (8.70%) Management Information System
4 41 (7.75%) Replication
5 27 (5.10%) Clustering
6 26 (4.91%) Statistics
7 18 (3.40%) Computer Science
8 15 (2.84%) Fintech
9 11 (2.08%) Data Extraction
10 9 (1.70%) Physics
11 8 (1.51%) Mathematics
12 7 (1.32%) Mobile App
13 6 (1.13%) Economics
13 6 (1.13%) NHS
14 4 (0.76%) Data Centre
14 4 (0.76%) Data Structures
14 4 (0.76%) Derivative
15 3 (0.57%) Enterprise Software
15 3 (0.57%) Neural Network
Operating Systems
1 62 (11.72%) Windows
2 44 (8.32%) Linux
3 19 (3.59%) Solaris
3 19 (3.59%) Unix
4 12 (2.27%) Windows Server 2008
4 12 (2.27%) Windows Server 2012
5 11 (2.08%) Windows Server
6 1 (0.19%) Android
6 1 (0.19%) Apple iOS
Processes & Methodologies
1 375 (70.89%) Business Intelligence
2 254 (48.02%) ETL
3 173 (32.70%) Agile Software Development
4 114 (21.55%) Data Modelling
5 99 (18.71%) Analytics
5 99 (18.71%) Performance Tuning
6 96 (18.15%) Kimball Methodology
7 67 (12.67%) Scrum
8 62 (11.72%) Dimensional Modelling
9 46 (8.70%) Time Management
10 36 (6.81%) Data Visualisation
11 34 (6.43%) SDLC
12 33 (6.24%) Disaster Recovery
12 33 (6.24%) Project Management
13 32 (6.05%) Data Management
14 31 (5.86%) Migration
15 27 (5.10%) Kanban
15 27 (5.10%) Mentoring
16 25 (4.73%) Business Analysis
16 25 (4.73%) Data Analytics
Programming Languages
1 418 (79.02%) SQL
2 211 (39.89%) T-SQL
3 56 (10.59%) C#
4 49 (9.26%) Data Analysis Expressions (DAX)
5 48 (9.07%) PL/SQL
6 44 (8.32%) Java
7 22 (4.16%) PowerShell
8 21 (3.97%) JavaScript
9 19 (3.59%) Python
10 16 (3.02%) R
11 12 (2.27%) Scala
11 12 (2.27%) VBA
12 10 (1.89%) Shell Script
13 9 (1.70%) C
14 8 (1.51%) VB.NET
15 6 (1.13%) PHP
16 5 (0.95%) C++
17 3 (0.57%) Data Mining Extensions (DMX)
17 3 (0.57%) XMLA
18 2 (0.38%) VBScript
Qualifications
1 51 (9.64%) Degree
2 33 (6.24%) Microsoft Certification
3 13 (2.46%) MCITP
4 11 (2.08%) SC Cleared
4 11 (2.08%) Security Cleared
5 9 (1.70%) MCSE
6 3 (0.57%) CIMA
7 2 (0.38%) MCTS
8 1 (0.19%) ACCA
8 1 (0.19%) Postgraduate
8 1 (0.19%) PRINCE2 Certification
Quality Assurance & Compliance
1 34 (6.43%) Data Quality
2 19 (3.59%) QA
3 12 (2.27%) SLA
4 3 (0.57%) PCI DSS
5 1 (0.19%) Basel III
5 1 (0.19%) Dodd-Frank
5 1 (0.19%) HIPAA
5 1 (0.19%) ISO/IEC 27001
5 1 (0.19%) SSAE 16
System Software
1 22 (4.16%) Oracle RAC
2 21 (3.97%) VMware Infrastructure
3 19 (3.59%) Hyper-V
3 19 (3.59%) KVM
3 19 (3.59%) NFS
3 19 (3.59%) SRDF
3 19 (3.59%) Xen
4 10 (1.89%) HDFS
5 7 (1.32%) Active Directory
6 3 (0.57%) Apache Flume
6 3 (0.57%) Virtual Machines
7 2 (0.38%) Apache ZooKeeper
7 2 (0.38%) Firmware
7 2 (0.38%) VMware ESX
7 2 (0.38%) vSphere
Systems Management
1 21 (3.97%) Puppet
2 6 (1.13%) Microsoft Clustering
3 4 (0.76%) Oozie
4 3 (0.57%) Enterprise Manager Cloud Control
4 3 (0.57%) Oracle Enterprise Manager
4 3 (0.57%) Oracle RMAN
5 2 (0.38%) Hadoop YARN
5 2 (0.38%) ITRS Geneos
6 1 (0.19%) Kibana
Vendors
1 260 (49.15%) Microsoft
2 134 (25.33%) Oracle
3 84 (15.88%) Tableau
4 56 (10.59%) Cognos
5 28 (5.29%) IBM
6 27 (5.10%) VMware
7 25 (4.73%) Talend
8 22 (4.16%) Cisco
9 21 (3.97%) EMC
9 21 (3.97%) NetApp
10 19 (3.59%) Intel
11 14 (2.65%) SAP
12 12 (2.27%) Google
12 12 (2.27%) Splunk
13 10 (1.89%) Actian
13 10 (1.89%) Computacenter
14 9 (1.70%) SolarWinds
15 8 (1.51%) Informatica
15 8 (1.51%) MicroStrategy
16 7 (1.32%) Sybase
Lymm
Nigel Frank International
Salary: £30000 - £40000 per annum + company bonus and benefits
Posted: 2 hours ago
Surrey
Venturi
Salary: £50000 - £60000 per annum + company benefits
Posted: 4 hours ago
Poole
Nigel Frank International
Salary: £50000 - £55000 per annum + Benefits
Posted: 2 hours ago
London
Understanding Recruitment
Salary: £50000.00 - £60000.00 per annum + Benefits
Posted: Yesterday
Manchester
Nigel Frank International
Salary: £25000 - £35000 per annum + company benefits
Posted: Yesterday
Bournemouth
Nigel Frank International
Salary: £50000 - £55000 per annum + Benefits
Posted: Yesterday
City, London
I3
Salary: £65000 - £70000 per annum + benefits + bonus
Posted: 23 hours ago
London
Opus Recruitment Solutions Ltd
Salary: £0 - £60000 per annum
Posted: 20 hours ago
City, London
ANSON MCCADE
Salary: £45,000 - £70,000 + extensive benefits package
Posted: 4 hours ago
Manchester, Lancashire
Energize Recruitment Solutions Ltd
Salary: £30000 - £40000 per annum + benefits
Posted: 3 days ago
Birmingham, West Midlands (County)
Harvey Nash plc
Salary: £30000 - £35000 per annum + Package
Posted: 4 days ago
London
onezeero.
Salary: £70000 - £80000 per annum + benefits
Posted: 4 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + equity, benefits
Posted: Yesterday
London
HFG
Salary: £40000 - £60000 per annum, Benefits + bonus + benefits
Posted: 6 days ago
Solihull, West Midlands (County)
Modis International
Salary: £30000.00 - £36000.00 per annum + Benefits package
Posted: 5 days ago
Leatherhead, Surrey
NCC Group
Posted: 22 hours ago
Greater Manchester
Verticality Ltd
Salary: £34k-£38k DOE + Bonus + Benefits
Posted: 6 days ago
Bristol, Avon
Redrock Consulting Ltd
Salary: £60000 - £80000 per annum + Great Benefits/Home Working
Posted: 5 days ago
West Yorkshire
Rullion IT Plus
Salary: £60000 - £80000 per annum + Bonus + Pension + Health
Posted: 3 days ago
Bury St. Edmunds, Suffolk
Proactive Appointments
Salary: £40000 - £46000 per annum + great benefits
Posted: 5 days ago
Cambridgeshire
Lawrence Harvey
Salary: £35000.00 - £50000.00 per annum
Posted: 8 days ago
West Midlands
Austin Fraser
Salary: £40000.00 - £50000 per annum + Benefits
Posted: 6 days ago
Milton Keynes, Buckinghamshire
Robert Walters
Salary: £80000 - £94000 per annum + 10% Bonus, Car Allowance
Posted: 3 days ago
Manchester, Lancashire
Jagger Talent
Salary: From £25,000 to £30,000 per annum upto 30K + Benefits
Posted: 5 days ago
Folkestone
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits
Posted: 13 days ago
West Malling, Kent
Anthony James Consulting
Salary: From £60,000 to £70,000 per annum
Posted: 5 days ago
Ipswich
Nigel Frank International
Salary: £35000 - £50000 per annum
Posted: 15 days ago
Hampshire
Hays Specialist Recruitment Ltd
Salary: £40000.00 - £50000.00 per annum + bens
Posted: 19 days ago
London
Engage PSG
Salary: £65000 - £75000 per annum + stock options
Posted: 5 days ago
City of London
Venturi
Salary: £40000 - £50000 per annum + company benefits
Posted: 13 days ago