Period
to 10 August 2020

The following table provides summary statistics for permanent job vacancies with a requirement for OLTP skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited OLTP over the 6 months to 10 August 2020 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK
6 months to
10 Aug 2020
Same period 2019 Same period 2018
Rank 659 965 905
Rank change year-on-year +306 -60 +82
Permanent jobs citing OLTP 118 139 285
As % of all permanent jobs advertised in the UK 0.18% 0.097% 0.17%
As % of the Database & Business Intelligence category 0.67% 0.35% 0.55%
Number of salaries quoted 89 129 242
Median annual salary £52,500 £65,000 £55,000
Median salary % change year-on-year -19.23% +18.18% +4.76%
10th Percentile £46,000 £41,150 £33,750
90th Percentile £80,700 £85,000 £83,375
UK excluding London median annual salary £51,000 £52,500 £47,500
% change year-on-year -2.86% +10.53% +11.76%

OLTP is in the Databases and Business Intelligence category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Permanent vacancies with a requirement for database or business intelligence skills 17,614 39,281 51,795
As % of all permanent IT jobs advertised in the UK 27.39% 27.34% 30.20%
Number of salaries quoted 14,328 32,219 42,200
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +5.26%
10th Percentile £32,500 £31,250 £31,250
90th Percentile £88,750 £85,000 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

OLTP
Job Vacancy Trend

Job postings citing OLTP as a proportion of all IT jobs advertised.

Job vacancy trend for OLTP in the UK

OLTP
Salary Trend

3-month moving average salary quoted in jobs citing OLTP.

Salary trend for OLTP in the UK

OLTP
Salary Histogram

Salary distribution for jobs citing OLTP over the 6 months to 10 August 2020.

Salary histogram for OLTP in the UK

OLTP
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK over the 6 months to 10 August 2020. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +323 112 £52,500 -25.00% 6
UK excluding London +285 65 £51,000 -2.86% 3
London +185 53 £58,750 -18.97% 3
Midlands +131 36 £51,000 +34.21% 3
West Midlands +111 21 £51,000 +37.65% 2
East Midlands +86 15 £62,500 +25.00% 1
North of England +154 12 £48,750 +2.63%
Work from Home - 12 £50,000 - 2
North West +132 11 £47,500 -5.00%
South East +179 7 £55,000 -21.43%
Wales - 6 £47,500 -
East of England +104 3 £76,000 +1.33%
Yorkshire +138 1 £57,500 +36.90%
South West +111 1 £42,500 -37.04%

For the 6 months to 10 August 2020, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for OLTP.

1 95 (80.51%) SQL Server
2 77 (65.25%) SQL
3 74 (62.71%) Data Warehouse
4 69 (58.47%) Data Modelling
5 68 (57.63%) Business Intelligence
6 58 (49.15%) SQL Server Integration Services
7 57 (48.31%) OLAP
8 53 (44.92%) ETL
9 52 (44.07%) Analytics
10 48 (40.68%) Agile Software Development
11 42 (35.59%) Microsoft
11 42 (35.59%) Azure
11 42 (35.59%) Performance Tuning
11 42 (35.59%) Power BI
11 42 (35.59%) Power Platform
12 40 (33.90%) SQL Server Analysis Services
12 40 (33.90%) SQL Server Reporting Services
13 39 (33.05%) Analytical Skills
14 36 (30.51%) AWS
14 36 (30.51%) Finance
15 32 (27.12%) Data Management
16 31 (26.27%) Oracle
16 31 (26.27%) T-SQL
16 31 (26.27%) NoSQL
17 29 (24.58%) Python
18 28 (23.73%) Problem-Solving
19 27 (22.88%) Relational Database
20 26 (22.03%) Tableau
20 26 (22.03%) Visualisation
20 26 (22.03%) XML

OLTP
Co-occurring IT Skills 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 5 (4.24%) Apache Airflow
1 5 (4.24%) Elasticsearch
2 4 (3.39%) Apache Spark
3 1 (0.85%) Oracle SOA Suite
Applications
1 15 (12.71%) Microsoft Excel
2 1 (0.85%) Microsoft PowerPoint
Business Applications
1 4 (3.39%) SAP IS-U
Cloud Services
1 42 (35.59%) Azure
1 42 (35.59%) Power Platform
2 36 (30.51%) AWS
3 8 (6.78%) Azure Data Factory
4 6 (5.08%) Cloud Computing
4 6 (5.08%) GCP
5 5 (4.24%) Azure Stack
5 5 (4.24%) IaaS
5 5 (4.24%) PaaS
6 2 (1.69%) SaaS
7 1 (0.85%) Serverless
Database & Business Intelligence
1 95 (80.51%) SQL Server
2 74 (62.71%) Data Warehouse
3 58 (49.15%) SQL Server Integration Services
4 57 (48.31%) OLAP
5 42 (35.59%) Power BI
6 40 (33.90%) SQL Server Analysis Services
6 40 (33.90%) SQL Server Reporting Services
7 31 (26.27%) NoSQL
8 27 (22.88%) Relational Database
9 25 (21.19%) Azure SQL Data Warehouse
10 20 (16.95%) RDBMS
11 19 (16.10%) Snowflake Schema
12 17 (14.41%) Apache Cassandra
13 14 (11.86%) OLAP Cube
14 13 (11.02%) Big Data
14 13 (11.02%) Oracle OLAP
15 12 (10.17%) Amazon DynamoDB
15 12 (10.17%) CouchDB
15 12 (10.17%) MongoDB
16 11 (9.32%) PostgreSQL
Development Applications
1 23 (19.49%) ERwin
2 18 (15.25%) PowerDesigner
3 7 (5.93%) Visual Studio
4 6 (5.08%) ER Studio
5 4 (3.39%) Flyway
5 4 (3.39%) Jenkins
5 4 (3.39%) Liquibase
General
1 36 (30.51%) Finance
2 5 (4.24%) Back Office
3 1 (0.85%) Law
3 1 (0.85%) Manufacturing
3 1 (0.85%) Marketing
Job Titles
1 59 (50.00%) Developer
2 43 (36.44%) SQL Developer
3 35 (29.66%) Business Intelligence Developer
4 27 (22.88%) Architect
5 24 (20.34%) Data Architect
5 24 (20.34%) SQL BI Developer
6 23 (19.49%) SQL Server Developer
7 21 (17.80%) SSAS Developer
7 21 (17.80%) SSIS Developer
8 18 (15.25%) OLAP Developer
9 15 (12.71%) Data Warehouse Developer
10 14 (11.86%) Azure Developer
10 14 (11.86%) Excel Developer
10 14 (11.86%) Microsoft BI Developer
10 14 (11.86%) SQL Server BI Developer
11 13 (11.02%) DBA
11 13 (11.02%) ETL Developer
12 12 (10.17%) SQL Server Data Warehouse Developer
13 9 (7.63%) Administrator
13 9 (7.63%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 26 (22.03%) JSON
1 26 (22.03%) XML
2 16 (13.56%) Kafka
3 14 (11.86%) REST
3 14 (11.86%) SOAP
4 12 (10.17%) FIX Protocol
5 8 (6.78%) MDX
6 5 (4.24%) Apache NiFi
6 5 (4.24%) J2EE
6 5 (4.24%) JSP
6 5 (4.24%) Servlets
7 1 (0.85%) .NET
7 1 (0.85%) AngularJS
7 1 (0.85%) Ember.js
7 1 (0.85%) React
Miscellaneous
1 39 (33.05%) Analytical Skills
2 17 (14.41%) Management Information System
3 12 (10.17%) Reference Data
4 9 (7.63%) Foreign Exchange (FX)
5 6 (5.08%) CMDB
6 3 (2.54%) Self-Motivation
7 2 (1.69%) Data Structures
7 2 (1.69%) Greenfield Project
7 2 (1.69%) User Experience
8 1 (0.85%) Cloud Native
8 1 (0.85%) Driving Licence
8 1 (0.85%) Enterprise Software
8 1 (0.85%) FMCG
8 1 (0.85%) Public Cloud
Operating Systems
1 6 (5.08%) Unix
2 5 (4.24%) Solaris
3 3 (2.54%) Linux
3 3 (2.54%) Windows
3 3 (2.54%) Windows Server
Processes & Methodologies
1 69 (58.47%) Data Modelling
2 68 (57.63%) Business Intelligence
3 53 (44.92%) ETL
4 52 (44.07%) Analytics
5 48 (40.68%) Agile Software Development
6 42 (35.59%) Performance Tuning
7 32 (27.12%) Data Management
8 28 (23.73%) Problem-Solving
9 26 (22.03%) Visualisation
10 25 (21.19%) Data Architecture
10 25 (21.19%) Data Governance
10 25 (21.19%) DevOps
11 22 (18.64%) Data Analytics
11 22 (18.64%) Migration
12 19 (16.10%) Data Migration
12 19 (16.10%) Data Visualisation
13 17 (14.41%) Requirements Analysis
14 16 (13.56%) Stakeholder Management
15 15 (12.71%) Data Analysis
15 15 (12.71%) Technical Architecture
Programming Languages
1 77 (65.25%) SQL
2 31 (26.27%) T-SQL
3 29 (24.58%) Python
4 23 (19.49%) Java
5 7 (5.93%) C#
6 6 (5.08%) PL/SQL
7 5 (4.24%) ABAP
7 5 (4.24%) R
7 5 (4.24%) Scala
8 3 (2.54%) Shell Script
9 1 (0.85%) JavaScript
9 1 (0.85%) PHP
9 1 (0.85%) Ruby
Qualifications
1 26 (22.03%) Degree
2 18 (15.25%) Master's Degree
3 12 (10.17%) AWS Certification
3 12 (10.17%) Computer Science Degree
4 4 (3.39%) Microsoft Certification
5 1 (0.85%) MCSA
Quality Assurance & Compliance
1 20 (16.95%) Data Quality
2 13 (11.02%) QA
3 12 (10.17%) GDPR
4 5 (4.24%) Sarbanes-Oxley
5 1 (0.85%) PMO
5 1 (0.85%) SLA
System Software
1 5 (4.24%) Docker
2 3 (2.54%) Apache Flume
Systems Management
1 5 (4.24%) Terraform
2 3 (2.54%) Oozie
Vendors
1 42 (35.59%) Microsoft
2 31 (26.27%) Oracle
3 26 (22.03%) Tableau
4 11 (9.32%) Google
5 9 (7.63%) SAP
6 6 (5.08%) Teradata
7 5 (4.24%) SnapLogic
7 5 (4.24%) Sun
8 3 (2.54%) Birst
8 3 (2.54%) IBM
8 3 (2.54%) Infor
9 2 (1.69%) Databricks
10 1 (0.85%) SolarWinds