The following table provides summary statistics for permanent job vacancies advertised in England with a requirement for OLAP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLAP over the 3 months to 26 June 2017 with a comparison to the same period in the previous 2 years.

Online Analytical Processing (OLAP)
UK / England
3 months to
26 Jun 2017
Same period 2016 Same period 2015
Rank 547 555 498
Rank change year-on-year +8 -57  
Permanent jobs citing OLAP 342 371 535
As % of all permanent IT jobs advertised in England 0.41% 0.41% 0.51%
As % of the Database & Business Intelligence category 1.32% 1.36% 1.58%
Number of salaries quoted 249 306 438
Median salary £50,000 £50,000 £50,000
90% offered a salary of more than £32,900 £40,000 £32,500
10% offered a salary of more than £70,000 £73,750 £72,500
UK excluding London median salary £42,500 £46,750 £40,000
% change year-on-year -9.09% +16.87%  

OLAP is in the database and business intelligence skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in England with a requirement for database and business intelligence skills.

Database & Business Intelligence Skills
England
Permanent job vacancies with a requirement for database and business intelligence skills 25855 27325 33931
As % of all permanent IT job vacancies advertised in England 30.75% 29.97% 32.64%
Number of salaries quoted 22007 23642 28951
Median salary £50,000 £50,000 £47,500
Median salary % change year-on-year - +5.26%  
90% offered a salary of more than £32,500 £32,500 £32,000
10% offered a salary of more than £75,000 £70,000 £75,000
UK excluding London median salary £42,500 £42,500 £41,500
% change year-on-year - +2.40%  

OLAP
Job Vacancy Trend in England

The job posting trend of jobs advertised in England citing OLAP as a proportion of all permanent or contract IT jobs with a match in the Database & Business Intelligence category.

Job vacancy trend for OLAP in England

OLAP
Salary Trend in England

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

Salary trend for OLAP in England

OLAP
Salary Histogram in England

The salary distribution of IT jobs citing OLAP in England over the 3 months to 26 June 2017.

Salary histogram for OLAP 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 26 June 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 +50 191 £60,000 - 10
South East +55 37 £60,000 +20.00% 4
East of England -3 31 £42,500 -12.82% 6
East Midlands +31 25 £36,500 -27.00% 1
South West -3 22 £32,500 -23.52% 2
North West -32 15 £45,000 +24.13% 1
West Midlands -29 10 £27,500 -38.88% 1
Yorkshire -19 8 £50,000 -23.07% 2
OLAP
UK

For the 6 months to 26 June 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 465 (76.86%) SQL
2 410 (67.77%) Business Intelligence
3 393 (64.96%) Data Warehouse
4 373 (61.65%) SQL Server
5 353 (58.35%) ETL
6 341 (56.36%) SQL Server Integration Services
7 319 (52.73%) SQL Server Analysis Services
8 291 (48.10%) SQL Server Reporting Services
9 260 (42.98%) Microsoft
10 217 (35.87%) T-SQL
11 206 (34.05%) OLAP Cube
12 154 (25.45%) Finance
13 141 (23.31%) Agile Software Development
14 136 (22.48%) Power BI
15 132 (21.82%) Relational Database
16 119 (19.67%) OLTP
17 117 (19.34%) MDX
18 116 (19.17%) Kimball Methodology
19 113 (18.68%) Data Modelling
20 110 (18.18%) Oracle
20 110 (18.18%) Oracle OLAP
21 103 (17.02%) Analytics
22 100 (16.53%) Analytical Skills
22 100 (16.53%) Dimensional Modelling
23 99 (16.36%) SQL Server 2012
24 83 (13.72%) SQL Server 2008
25 78 (12.89%) MySQL
26 77 (12.73%) Performance Tuning
27 73 (12.07%) PL/SQL
28 71 (11.74%) Tableau

OLAP
Co-occurring 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 38 (6.28%) SharePoint
2 29 (4.79%) Apache Spark
2 29 (4.79%) Elasticsearch
3 18 (2.98%) Apache
4 17 (2.81%) Apache Airflow
5 10 (1.65%) IIS
6 5 (0.83%) Oracle SOA Suite
7 4 (0.66%) Oracle Service Bus
7 4 (0.66%) Tomcat
7 4 (0.66%) WebSphere
8 3 (0.50%) Apache Pig
8 3 (0.50%) SAS
9 2 (0.33%) GemFire
9 2 (0.33%) SharePoint 2010
9 2 (0.33%) SharePoint 2013
10 1 (0.17%) Apache Solr
10 1 (0.17%) BizTalk Server
10 1 (0.17%) OpenStack
10 1 (0.17%) Oracle Coherence
Applications
1 51 (8.43%) Microsoft Excel
2 33 (5.45%) MS Visio
3 4 (0.66%) Microsoft PowerPoint
4 3 (0.50%) Microsoft Office
5 1 (0.17%) SPSS
Business Applications
1 22 (3.64%) Cognos TM1
2 13 (2.15%) Cognos Business Intelligence
3 11 (1.82%) Infor SunSystems
4 10 (1.65%) Dynamics CRM
5 5 (0.83%) Dynamics AX
5 5 (0.83%) Hyperion Planning
5 5 (0.83%) SAP BPC
6 4 (0.66%) Oracle Applications
7 1 (0.17%) Cognos Planning
7 1 (0.17%) Dynamics NAV
7 1 (0.17%) FastStats
7 1 (0.17%) ION MarketView
7 1 (0.17%) PeopleSoft HRMS
7 1 (0.17%) SAP ERP
Cloud Services
1 36 (5.95%) Amazon AWS
2 31 (5.12%) Microsoft Azure
3 17 (2.81%) Amazon Kinesis
4 7 (1.16%) GitHub
5 5 (0.83%) IaaS
5 5 (0.83%) SaaS
6 3 (0.50%) Azure Data Factory
6 3 (0.50%) Office 365
7 2 (0.33%) Google Cloud Platform
8 1 (0.17%) Adobe Analytics
8 1 (0.17%) Cloud Computing
8 1 (0.17%) Data Lake Analytics
8 1 (0.17%) Datadog
8 1 (0.17%) Dynamics 365
8 1 (0.17%) Google Analytics
8 1 (0.17%) PaaS
Communications & Networking
1 16 (2.64%) Intranet
2 7 (1.16%) SAN
3 4 (0.66%) Extranet
4 3 (0.50%) Ethernet
4 3 (0.50%) Kerberos
4 3 (0.50%) NAS
5 1 (0.17%) FTP
5 1 (0.17%) HTTP
5 1 (0.17%) Internet
5 1 (0.17%) LAN
5 1 (0.17%) Modbus
5 1 (0.17%) RS-485
5 1 (0.17%) WAN
Database & Business Intelligence
1 393 (64.96%) Data Warehouse
2 373 (61.65%) SQL Server
3 341 (56.36%) SQL Server Integration Services
4 319 (52.73%) SQL Server Analysis Services
5 291 (48.10%) SQL Server Reporting Services
6 206 (34.05%) OLAP Cube
7 136 (22.48%) Power BI
8 132 (21.82%) Relational Database
9 119 (19.67%) OLTP
10 110 (18.18%) Oracle OLAP
11 99 (16.36%) SQL Server 2012
12 83 (13.72%) SQL Server 2008
13 78 (12.89%) MySQL
14 69 (11.40%) Big Data
15 66 (10.91%) QlikView
16 64 (10.58%) RDBMS
17 59 (9.75%) SQL Server 2014
18 50 (8.26%) Hadoop
18 50 (8.26%) Microsoft Analysis Services
19 45 (7.44%) BusinessObjects
Development Applications
1 36 (5.95%) Visual Studio
2 25 (4.13%) PowerDesigner
3 23 (3.80%) Team Foundation Server
4 16 (2.64%) JIRA
5 10 (1.65%) Eclipse
6 8 (1.32%) Talend Open Studio
7 7 (1.16%) Visual Studio Team System
8 6 (0.99%) tSQLt
9 5 (0.83%) JUnit
9 5 (0.83%) Maven
10 4 (0.66%) Git (software)
10 4 (0.66%) Octopus Deploy
11 3 (0.50%) Liquibase
12 2 (0.33%) TeamCity
13 1 (0.17%) ERwin
13 1 (0.17%) MagicDraw
13 1 (0.17%) MSTest
13 1 (0.17%) TestNG
13 1 (0.17%) TortoiseSVN
13 1 (0.17%) Xcode
General
1 154 (25.45%) Finance
2 52 (8.60%) Banking
3 49 (8.10%) Retail
4 41 (6.78%) Advertising
5 39 (6.45%) Marketing
6 34 (5.62%) Investment Banking
7 29 (4.79%) Legal
8 22 (3.64%) Retail Banking
9 12 (1.98%) Manufacturing
10 11 (1.82%) Front Office
11 8 (1.32%) Financial Institution
12 7 (1.16%) French Language
12 7 (1.16%) German Language
12 7 (1.16%) Spanish Language
13 6 (0.99%) Law
14 5 (0.83%) Dutch Language
14 5 (0.83%) Italian Language
15 4 (0.66%) Publishing
16 3 (0.50%) Electronics
17 2 (0.33%) Telecoms
Job Titles
1 311 (51.40%) Developer
2 172 (28.43%) Business Intelligence Developer
3 115 (19.01%) SQL Developer
4 112 (18.51%) Analyst
5 73 (12.07%) DBA
6 64 (10.58%) Business Intelligence Analyst
6 64 (10.58%) Senior Developer
7 62 (10.25%) SSAS Developer
8 61 (10.08%) Data Warehouse Developer
8 61 (10.08%) SQL BI Developer
9 53 (8.76%) SQL Analyst
10 49 (8.10%) SSIS Developer
11 46 (7.60%) Senior Business Intelligence Developer
12 43 (7.11%) SSRS Developer
13 40 (6.61%) SQL DBA
14 37 (6.12%) Administrator
14 37 (6.12%) Architect
15 35 (5.79%) SQL Server Developer
16 33 (5.45%) Business Developer
16 33 (5.45%) OLAP Developer
Libraries, Frameworks & Software Standards
1 117 (19.34%) MDX
2 66 (10.91%) .NET
3 33 (5.45%) XML
4 32 (5.29%) HTML
5 29 (4.79%) Web Services
6 23 (3.80%) Oracle GoldenGate
7 17 (2.81%) Kafka
7 17 (2.81%) Scrapy
8 13 (2.15%) GraphX
8 13 (2.15%) Serverless Framework
9 10 (1.65%) XSD
10 9 (1.49%) REST
11 8 (1.32%) ASP.NET
11 8 (1.32%) CSS
11 8 (1.32%) HTML5
11 8 (1.32%) SOAP
12 7 (1.16%) .NET Framework
12 7 (1.16%) WSDL
12 7 (1.16%) XML Messaging
13 6 (0.99%) Ajax
Miscellaneous
1 100 (16.53%) Analytical Skills
2 50 (8.26%) Management Information System
3 31 (5.12%) Replication
4 25 (4.13%) Data Structures
4 25 (4.13%) Enterprise Software
5 23 (3.80%) Computer Science
6 20 (3.31%) Fintech
7 17 (2.81%) Clustering
7 17 (2.81%) Greenfield Project
8 8 (1.32%) Foreign Exchange (FX)
8 8 (1.32%) iPad
9 4 (0.66%) Data Protection Act
9 4 (0.66%) Mobile App
9 4 (0.66%) NHS
10 3 (0.50%) Client/Server
10 3 (0.50%) Credit Risk
10 3 (0.50%) N-Tier
10 3 (0.50%) User Experience
11 2 (0.33%) Market Risk
11 2 (0.33%) Social Media
Operating Systems
1 44 (7.27%) Windows
2 40 (6.61%) Unix
3 24 (3.97%) Linux
4 14 (2.31%) Windows Server
5 12 (1.98%) Solaris
5 12 (1.98%) Windows Server 2008
5 12 (1.98%) Windows Server 2012
Processes & Methodologies
1 410 (67.77%) Business Intelligence
2 353 (58.35%) ETL
3 141 (23.31%) Agile Software Development
4 116 (19.17%) Kimball Methodology
5 113 (18.68%) Data Modelling
6 103 (17.02%) Analytics
7 100 (16.53%) Dimensional Modelling
8 77 (12.73%) Performance Tuning
9 61 (10.08%) Visualisation
10 60 (9.92%) ITIL
11 52 (8.60%) Data Analysis
11 52 (8.60%) SDLC
12 46 (7.60%) Data Management
13 45 (7.44%) Data Visualisation
14 40 (6.61%) Data Analytics
14 40 (6.61%) Scrum
15 38 (6.28%) SOA
16 37 (6.12%) ETL Development
16 37 (6.12%) Stakeholder Management
17 34 (5.62%) Disaster Recovery
Programming Languages
1 465 (76.86%) SQL
2 217 (35.87%) T-SQL
3 73 (12.07%) PL/SQL
4 64 (10.58%) Java
5 61 (10.08%) C#
6 54 (8.93%) Python
7 31 (5.12%) R
8 23 (3.80%) C++
8 23 (3.80%) Data Analysis Expressions (DAX)
8 23 (3.80%) Perl
9 17 (2.81%) JavaScript
9 17 (2.81%) VB.NET
10 14 (2.31%) PowerShell
11 10 (1.65%) PHP
12 8 (1.32%) VBA
13 5 (0.83%) C
14 4 (0.66%) ABAP
14 4 (0.66%) Scala
14 4 (0.66%) Shell Script
14 4 (0.66%) VBScript
Qualifications
1 65 (10.74%) Degree
2 16 (2.64%) Microsoft Certification
3 9 (1.49%) Computer Science Degree
4 8 (1.32%) ITIL Certification
5 7 (1.16%) MCSE
6 6 (0.99%) Oracle Certification
6 6 (0.99%) SC Cleared
6 6 (0.99%) Security Cleared
7 4 (0.66%) MCITP
8 3 (0.50%) CIMA
9 2 (0.33%) Master's Degree
10 1 (0.17%) PMI Certification
10 1 (0.17%) Postgraduate
Quality Assurance & Compliance
1 65 (10.74%) Data Quality
2 46 (7.60%) QA
3 3 (0.50%) GDPR
3 3 (0.50%) PMO
3 3 (0.50%) SLA
4 2 (0.33%) PCI DSS
5 1 (0.17%) Basel III
5 1 (0.17%) Dodd-Frank
5 1 (0.17%) EFQM
5 1 (0.17%) GCP
5 1 (0.17%) IFRS
5 1 (0.17%) IFRS 9
5 1 (0.17%) Sarbanes-Oxley
System Software
1 10 (1.65%) Oracle RAC
2 9 (1.49%) KVM
2 9 (1.49%) VMware Infrastructure
3 6 (0.99%) Active Directory
4 3 (0.50%) Firmware
5 2 (0.33%) HDFS
6 1 (0.17%) Apache Flume
6 1 (0.17%) Apache ZooKeeper
6 1 (0.17%) Docker
Systems Management
1 18 (2.98%) Kibana
2 5 (0.83%) Oozie
2 5 (0.83%) Puppet
3 4 (0.66%) Enterprise Manager Cloud Control
3 4 (0.66%) Opscode Chef
3 4 (0.66%) Oracle Enterprise Manager
3 4 (0.66%) Oracle RMAN
4 3 (0.50%) Ansible
5 2 (0.33%) Perfmon
6 1 (0.17%) Cobbler
6 1 (0.17%) Control-M
6 1 (0.17%) Hadoop YARN
6 1 (0.17%) Kubernetes
6 1 (0.17%) Nagios
6 1 (0.17%) PowerCLI
6 1 (0.17%) Rundeck
6 1 (0.17%) Systems Management Server (SMS)
6 1 (0.17%) ZABBIX
Vendors
1 260 (42.98%) Microsoft
2 110 (18.18%) Oracle
3 71 (11.74%) Tableau
4 52 (8.60%) Cognos
5 32 (5.29%) SAP
6 25 (4.13%) Sybase
7 22 (3.64%) MicroStrategy
8 21 (3.47%) VMware
9 15 (2.48%) IBM
10 13 (2.15%) Hyperion
10 13 (2.15%) Infor
10 13 (2.15%) Informatica
11 12 (1.98%) NetApp
12 11 (1.82%) Jedox
12 11 (1.82%) RedGate
13 9 (1.49%) Percona
14 8 (1.32%) Talend
15 7 (1.16%) Callidus
15 7 (1.16%) Guidewire
15 7 (1.16%) Sun
Essex
Nigel Frank International
Salary: £30000 - £45000 per annum + Health, Benefits
Posted: Yesterday
Wellingborough, Northamptonshire
Latcom Ltd
Salary: From £25,000 to £25,000 per annum + Training + Excellent Pension + Ben
Posted: 18 hours ago
London
Venturi
Salary: £40000.00 - £55000.00 per annum + Bonus & Benefits
Posted: 22 hours ago
Bath, Avon
Optima Connections
Salary: From £30,000 to £35,000 per annum + Benefits
Posted: 21 hours ago
Surrey
Venturi
Salary: £40000.00 - £55000.00 per annum + Bonus & Benefits
Posted: 2 days ago
York, North Yorkshire
onezeero.
Salary: £25000 - £40000 per annum
Posted: 5 days ago
City, London
Evolution Recruitment Solutions
Salary: 45,000 - 55,000
Posted: 5 days ago
Colchester
Nigel Frank International
Salary: £35000 - £45000 per annum + Benefits
Posted: 6 days ago
Surrey
Venturi
Salary: £40000.00 - £50000.00 per annum + Bonus & Benefits
Posted: 2 days ago
London
Talent Spa
Salary: £70k per year
Posted: 3 days ago
Birmingham, West Midlands (County)
Colossus Associates
Salary: £40000 - £60000 per annum, Benefits 0
Posted: 4 days ago
Brentwood, Essex
Shawbrook
Posted: 3 days ago
Central London / West End
The Workshop
Posted: 3 days ago
Bristol, Avon
Sanderson
Salary: £60000 - £75000 per annum
Posted: 6 days ago
London
onezeero.
Salary: £50000 - £65000 per annum
Posted: 6 days ago
Colchester
Nigel Frank International
Salary: £30000 - £40000 per annum + Benefits, Pension
Posted: 11 days ago
London
Opus Recruitment Solutions Ltd
Salary: £100000 - £150000 per annum
Posted: 19 hours ago
City, London
Charles Taylor plc
Salary: Market related
Posted: 11 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 7 days ago
Southampton, Hampshire
Red Funnel Group
Salary: £44,000 per annum including annual bonus and great benefits scheme
Posted: 18 days ago
East London
Cognizant
Salary: Competitive
Posted: 6 days ago
Milton Keynes
Mint
Posted: 26 days ago
Preston, Lancashire
Oscar
Salary: £25000 - £40000 per annum
Posted: 4 days ago
Luton
TUI Group Careers
Salary: Competitive
Posted: 18 days ago