Period
to 6 August 2020

The following table provides summary statistics for permanent job vacancies advertised in the UK excluding London 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 6 August 2020 with a comparison to the same period in the previous 2 years.

Online Transaction Processing (OLTP)
UK > UK excluding London
6 months to
6 Aug 2020
Same period 2019 Same period 2018
Rank 522 818 761
Rank change year-on-year +296 -57 +39
Permanent jobs citing OLTP 69 50 155
As % of all permanent jobs advertised in the UK excluding London 0.19% 0.061% 0.16%
As % of the Database & Business Intelligence category 0.70% 0.23% 0.54%
Number of salaries quoted 56 45 140
Median annual salary £51,000 £52,500 £47,500
Median salary % change year-on-year -2.86% +10.53% +11.76%
10th Percentile £41,875 £36,250 £33,750
90th Percentile £77,000 £77,500 £71,375
UK median annual salary £52,500 £66,250 £55,000
% change year-on-year -20.75% +20.45% +4.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 advertised in the UK excluding London with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK excluding London
Permanent vacancies with a requirement for database or business intelligence skills 9,890 22,025 28,605
As % of all permanent IT jobs advertised in the UK excluding London 27.15% 26.75% 29.45%
Number of salaries quoted 8,125 17,919 23,944
Median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - +5.88%
10th Percentile £31,250 £29,000 £28,000
90th Percentile £70,000 £67,500 £65,000
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

OLTP
Job Vacancy Trend in the UK excluding London

Job postings citing OLTP as a proportion of all IT jobs advertised in the UK excluding London.

Job vacancy trend for OLTP in the UK excluding London

OLTP
Salary Trend in the UK excluding London

3-month moving average salary quoted in jobs citing OLTP in the UK excluding London.

Salary trend for OLTP in the UK excluding London

OLTP
Salary Histogram in the UK excluding London

Salary distribution for jobs citing OLTP in the UK excluding London over the 6 months to 6 August 2020.

Salary histogram for OLTP in the UK excluding London

OLTP
Job Locations in the UK excluding London

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the UK excluding London region over the 6 months to 6 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
Midlands +143 37 £51,000 +34.21% 3
West Midlands +101 21 £51,000 +37.65% 2
East Midlands +84 16 £55,000 -2.65% 1
North of England +164 12 £48,750 -
North West +116 11 £47,500 -6.86%
South East +185 8 £55,000 -21.43%
Wales - 7 £47,500 -
East of England +112 3 £76,000 +21.60%
Yorkshire +127 1 £57,500 +36.90%
South West +115 1 £42,500 -37.04%
Scotland +91 1 £40,000 -20.00%
OLTP
UK

For the 6 months to 6 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 across the UK excluding London region with a requirement for OLTP.

1 54 (78.26%) SQL Server
2 45 (65.22%) SQL
3 43 (62.32%) Data Modelling
4 38 (55.07%) Data Warehouse
5 35 (50.72%) Business Intelligence
6 31 (44.93%) T-SQL
7 26 (37.68%) Finance
7 26 (37.68%) SQL Server Integration Services
8 25 (36.23%) ETL
8 25 (36.23%) Analytical Skills
9 23 (33.33%) Oracle
10 22 (31.88%) OLAP
10 22 (31.88%) Agile Software Development
11 19 (27.54%) Performance Tuning
11 19 (27.54%) Visualisation
12 18 (26.09%) SQL Server Reporting Services
12 18 (26.09%) Microsoft
13 17 (24.64%) Data Management
14 16 (23.19%) SQL Server Analysis Services
14 16 (23.19%) Data Architecture
14 16 (23.19%) Data Governance
15 15 (21.74%) AWS
15 15 (21.74%) Data Analysis
16 14 (20.29%) Degree
16 14 (20.29%) ERwin
16 14 (20.29%) Azure
16 14 (20.29%) Tableau
17 13 (18.84%) Data Visualisation
17 13 (18.84%) Analytics
17 13 (18.84%) Logical Data Model

OLTP
Co-occurring IT Skills in the UK excluding London 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 3 (4.35%) Apache Spark
2 1 (1.45%) Oracle SOA Suite
Applications
1 1 (1.45%) Microsoft Excel
1 1 (1.45%) Microsoft PowerPoint
Business Applications
1 4 (5.80%) SAP IS-U
Cloud Services
1 15 (21.74%) AWS
2 14 (20.29%) Azure
3 12 (17.39%) Power Platform
4 6 (8.70%) GCP
Database & Business Intelligence
1 54 (78.26%) SQL Server
2 38 (55.07%) Data Warehouse
3 26 (37.68%) SQL Server Integration Services
4 22 (31.88%) OLAP
5 18 (26.09%) SQL Server Reporting Services
6 16 (23.19%) SQL Server Analysis Services
7 12 (17.39%) Big Data
7 12 (17.39%) Power BI
8 11 (15.94%) RDBMS
8 11 (15.94%) Relational Database
9 10 (14.49%) NoSQL
10 8 (11.59%) SAP BW
11 7 (10.14%) Oracle BI Publisher
11 7 (10.14%) PostgreSQL
11 7 (10.14%) SSDT
12 6 (8.70%) Azure SQL Data Warehouse
12 6 (8.70%) Hadoop
13 5 (7.25%) BusinessObjects
13 5 (7.25%) Enterprise Data Warehouse
13 5 (7.25%) Oracle Database 11g
Development Applications
1 14 (20.29%) ERwin
2 9 (13.04%) PowerDesigner
3 7 (10.14%) Visual Studio
4 6 (8.70%) ER Studio
General
1 26 (37.68%) Finance
2 5 (7.25%) Back Office
3 1 (1.45%) Law
3 1 (1.45%) Manufacturing
3 1 (1.45%) Marketing
Job Titles
1 38 (55.07%) Developer
2 25 (36.23%) SQL Developer
3 17 (24.64%) Architect
4 15 (21.74%) Business Intelligence Developer
5 14 (20.29%) Data Architect
6 9 (13.04%) T-SQL Developer
7 8 (11.59%) DBA
7 8 (11.59%) SQL DBA
8 7 (10.14%) Data Warehouse Architect
8 7 (10.14%) Database Architect
8 7 (10.14%) SQL BI Developer
8 7 (10.14%) SQL Server Developer
9 6 (8.70%) Data Modeller
9 6 (8.70%) Database Developer
9 6 (8.70%) Senior Developer
10 5 (7.25%) Oracle DBA
10 5 (7.25%) Senior SQL Developer
10 5 (7.25%) SSIS Developer
11 4 (5.80%) SSAS Developer
12 3 (4.35%) Business Intelligence Architect
Libraries, Frameworks & Software Standards
1 6 (8.70%) J2EE
1 6 (8.70%) JSP
1 6 (8.70%) Kafka
1 6 (8.70%) MDX
1 6 (8.70%) Servlets
2 3 (4.35%) FIX Protocol
2 3 (4.35%) JSON
2 3 (4.35%) XML
3 2 (2.90%) .NET
4 1 (1.45%) AngularJS
4 1 (1.45%) Ember.js
4 1 (1.45%) React
Miscellaneous
1 25 (36.23%) Analytical Skills
2 8 (11.59%) Management Information System
3 3 (4.35%) Reference Data
4 2 (2.90%) Driving Licence
5 1 (1.45%) Enterprise Software
5 1 (1.45%) FMCG
Operating Systems
1 6 (8.70%) Unix
2 5 (7.25%) Solaris
3 3 (4.35%) Linux
3 3 (4.35%) Windows
3 3 (4.35%) Windows Server
Processes & Methodologies
1 43 (62.32%) Data Modelling
2 35 (50.72%) Business Intelligence
3 25 (36.23%) ETL
4 22 (31.88%) Agile Software Development
5 19 (27.54%) Performance Tuning
5 19 (27.54%) Visualisation
6 17 (24.64%) Data Management
7 16 (23.19%) Data Architecture
7 16 (23.19%) Data Governance
8 15 (21.74%) Data Analysis
9 13 (18.84%) Analytics
9 13 (18.84%) Data Visualisation
9 13 (18.84%) Logical Data Model
9 13 (18.84%) Physical Data Model
10 12 (17.39%) Dimensional Modelling
10 12 (17.39%) SDLC
10 12 (17.39%) User Stories
11 11 (15.94%) Migration
11 11 (15.94%) Waterfall
12 10 (14.49%) Performance Monitoring
Programming Languages
1 45 (65.22%) SQL
2 31 (44.93%) T-SQL
3 11 (15.94%) Java
3 11 (15.94%) Python
4 7 (10.14%) PL/SQL
5 5 (7.25%) ABAP
6 3 (4.35%) Shell Script
7 2 (2.90%) C#
8 1 (1.45%) JavaScript
8 1 (1.45%) PHP
8 1 (1.45%) Ruby
Qualifications
1 14 (20.29%) Degree
2 9 (13.04%) Master's Degree
3 4 (5.80%) Microsoft Certification
4 3 (4.35%) AWS Certification
4 3 (4.35%) Computer Science Degree
5 1 (1.45%) MCSA
Quality Assurance & Compliance
1 12 (17.39%) GDPR
2 11 (15.94%) Data Quality
3 5 (7.25%) Sarbanes-Oxley
4 4 (5.80%) QA
5 1 (1.45%) PMO
5 1 (1.45%) SLA
System Software
1 3 (4.35%) Apache Flume
Systems Management
1 3 (4.35%) Oozie
Vendors
1 23 (33.33%) Oracle
2 18 (26.09%) Microsoft
3 14 (20.29%) Tableau
4 9 (13.04%) SAP
5 6 (8.70%) Google
5 6 (8.70%) Teradata
6 5 (7.25%) Sun
7 3 (4.35%) Birst
7 3 (4.35%) IBM
7 3 (4.35%) Infor
8 1 (1.45%) SolarWinds