Period
to 28 January 2022

The following table provides summary statistics for contract job vacancies advertised in the City of London with a requirement for OLTP skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited OLTP over the 6 months to 28 January 2022 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Online Transaction Processing (OLTP)
Central London > City of London
6 months to
28 Jan 2022
Same period 2021 Same period 2020
Rank 184 127 205
Rank change year-on-year -57 +78 +50
Contract jobs citing OLTP 4 6 1
As % of all contract jobs advertised in the City of London 0.100% 0.28% 0.020%
As % of the Database & Business Intelligence category 0.42% 1.28% 0.088%
Number of daily rates quoted 4 5 1
10th Percentile - £590 -
25th Percentile £508 £613 £463
Median daily rate (50th Percentile) £520 £625 £475
Median % change year-on-year -16.80% +31.58% +46.15%
75th Percentile £538 £638 £488
90th Percentile - - -
Central London median daily rate £520 £625 £600
% change year-on-year -16.80% +4.17% +84.62%

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

All Database and Business Intelligence Skills
City of London
Contract vacancies with a requirement for database or business intelligence skills 948 470 1,132
As % of all contract IT jobs advertised in the City of London 23.62% 22.23% 23.10%
Number of daily rates quoted 754 353 885
10th Percentile £369 £326 £369
25th Percentile £482 £425 £425
Median daily rate (50th Percentile) £570 £525 £513
Median % change year-on-year +8.57% +2.44% -2.38%
75th Percentile £675 £638 £600
90th Percentile £775 £688 £675
Central London median daily rate £570 £525 £500
% change year-on-year +8.57% +5.00% -4.76%
Number of hourly rates quoted 6 0 4
10th Percentile £34.75 - £22.17
25th Percentile £39.00 - £23.67
Median hourly rate £53.25 - £25.00
Median % change year-on-year - - -32.60%
75th Percentile £61.56 - £33.00
90th Percentile £69.63 - £46.50
Central London median hourly rate £53.25 £62.50 £25.00
% change year-on-year -14.80% +150.00% -32.60%

OLTP
Job Vacancy Trend in the City of London

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

Job vacancy trend for OLTP in the City of London

OLTP
Contractor Daily Rate Trend in the City of London

3-month moving average daily rate quoted in jobs citing OLTP in the City of London.

Daily rate trend for OLTP in the City of London

For the 6 months to 28 January 2022, IT contractor 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 contract job ads across the City of London region with a requirement for OLTP.

1 4 (100.00%) SQL
2 2 (50.00%) SQL Server
2 2 (50.00%) OLAP
2 2 (50.00%) Microsoft Excel
2 2 (50.00%) Data Warehouse
2 2 (50.00%) ETL
2 2 (50.00%) SAS
2 2 (50.00%) RDBMS
2 2 (50.00%) Microsoft
2 2 (50.00%) Service Delivery
2 2 (50.00%) Financial Institution
2 2 (50.00%) Security Management
2 2 (50.00%) Finance
2 2 (50.00%) Banking
2 2 (50.00%) Investment Banking
2 2 (50.00%) Data Mart
2 2 (50.00%) Microsoft PowerPoint
2 2 (50.00%) SQL Server Integration Services
2 2 (50.00%) Corporate Banking
2 2 (50.00%) QA
2 2 (50.00%) User Acceptance Testing
2 2 (50.00%) Performance Management
2 2 (50.00%) SQL Server 2008
2 2 (50.00%) Capacity Planning
2 2 (50.00%) Tableau
2 2 (50.00%) Data Analytics
2 2 (50.00%) SQL Server 2012
2 2 (50.00%) Analytics
2 2 (50.00%) Relational Database
2 2 (50.00%) Kalman Filter

OLTP
Co-occurring IT Skills in the City of 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 2 (50.00%) SAS
Applications
1 2 (50.00%) Microsoft Excel
1 2 (50.00%) Microsoft PowerPoint
Database & Business Intelligence
1 2 (50.00%) Data Mart
1 2 (50.00%) Data Warehouse
1 2 (50.00%) OLAP
1 2 (50.00%) RDBMS
1 2 (50.00%) Relational Database
1 2 (50.00%) SQL Server
1 2 (50.00%) SQL Server 2008
1 2 (50.00%) SQL Server 2012
1 2 (50.00%) SQL Server 2014
1 2 (50.00%) SQL Server Integration Services
1 2 (50.00%) Tableau
General
1 2 (50.00%) Banking
1 2 (50.00%) Corporate Banking
1 2 (50.00%) Finance
1 2 (50.00%) Financial Institution
1 2 (50.00%) Investment Banking
Job Titles
1 2 (50.00%) Analyst
1 2 (50.00%) DBA
1 2 (50.00%) QA Analyst
Processes & Methodologies
1 2 (50.00%) Analytics
1 2 (50.00%) Capacity Planning
1 2 (50.00%) Data Analytics
1 2 (50.00%) ETL
1 2 (50.00%) Kalman Filter
1 2 (50.00%) Performance Management
1 2 (50.00%) Security Management
1 2 (50.00%) Service Delivery
1 2 (50.00%) User Acceptance Testing
Programming Languages
1 4 (100.00%) SQL
Quality Assurance & Compliance
1 2 (50.00%) QA
Vendors
1 2 (50.00%) Microsoft