Period
to 20 October 2018

The following table provides summary statistics for contract job vacancies 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 20 October 2018 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)
UK
6 months to
20 Oct 2018
Same period 2017 Same period 2016
Rank 769 804 751
Rank change year-on-year +35 -53 -24
Contract jobs citing OLTP 116 77 149
As % of all contract IT jobs advertised in the UK 0.11% 0.077% 0.14%
As % of the Database & Business Intelligence category 0.50% 0.35% 0.62%
Number of daily rates quoted 69 32 92
UK median daily rate £475 £515 £400
Median daily rate % change year-on-year -7.77% +28.75% -1.23%
10th Percentile £350 £369 £288
90th Percentile £700 £588 £636
UK excluding London median daily rate £425 £400 £365
% change year-on-year +6.25% +9.59% -8.75%
Number of hourly rates quoted 0 0 0
UK median hourly rate - - -
UK excluding London median hourly rate - - -

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 with a requirement for database or business intelligence skills.

All Database and Business Intelligence Skills
UK
Contract vacancies with a requirement for database or business intelligence skills 23,126 22,066 23,913
As % of all contract IT jobs advertised in the UK 22.60% 22.21% 22.50%
Number of daily rates quoted 16,128 14,922 15,919
UK median daily rate £475 £450 £425
Median daily rate % change year-on-year +5.56% +5.88% +6.25%
10th Percentile £313 £308 £281
90th Percentile £638 £625 £588
UK excluding London median daily rate £425 £400 £375
% change year-on-year +6.25% +6.67% -
Number of hourly rates quoted 227 276 393
UK median hourly rate £30.00 £30.00 £29.50
Median hourly rate % change year-on-year - +1.69% +5.36%
10th Percentile £12.37 £13.70 £11.05
90th Percentile £56.55 £54.38 £49.75
UK excluding London median hourly rate £33.00 £33.00 £28.50
% change year-on-year - +15.79% -0.33%

OLTP
Job Vacancy Trend

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

Job vacancy trend for OLTP in the UK

OLTP
Contractor Daily Rate Trend

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing OLTP.

Contractor daily rate trend for OLTP in the UK

OLTP
Contractor Daily Rate Histogram

The daily rate distribution of IT jobs citing OLTP over the 6 months to 20 October 2018.

Contractor daily rate histogram for OLTP in the UK

OLTP
Contractor Hourly Rate Trend

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing OLTP.

Contractor hourly rate trend for OLTP in the UK

OLTP
Top 12 Contract Locations

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing OLTP within the UK over the 6 months to 20 October 2018. 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +31 115 £475 -9.52% 31
London +20 74 £488 -7.14% 19
UK excluding London -11 42 £425 +6.25% 12
South East -5 17 £425 - 3
East of England - 12 £544 - 1
North of England -29 10 £363 -6.45% 3
Yorkshire -23 7 £390 +0.65% 1
North West -13 3 £338 -41.51% 2
Midlands -17 2 £743 - 5
East Midlands - 2 £743 - 4
Wales -19 1 £415 +3.75%
South West - 1 £700 -

For the 6 months to 20 October 2018, 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 with a requirement for OLTP.

1 69 (59.48%) SQL
2 61 (52.59%) SQL Server
3 45 (38.79%) Business Intelligence
4 38 (32.76%) Data Warehouse
5 37 (31.90%) Relational Database
6 36 (31.03%) Agile Software Development
7 34 (29.31%) Data Modelling
8 33 (28.45%) Oracle
9 31 (26.72%) T-SQL
10 27 (23.28%) OLAP
10 27 (23.28%) Unix
11 26 (22.41%) Microsoft
12 25 (21.55%) Performance Tuning
13 23 (19.83%) Big Data
14 22 (18.97%) SQL Server Integration Services
14 22 (18.97%) ETL
15 21 (18.10%) Finance
15 21 (18.10%) Kafka
16 20 (17.24%) Hadoop
16 20 (17.24%) Scrum
16 20 (17.24%) SQL Server Reporting Services
17 19 (16.38%) C++
17 19 (16.38%) Apache Spark
18 18 (15.52%) HDFS
18 18 (15.52%) Apache Hive
18 18 (15.52%) Linux
18 18 (15.52%) Stakeholder Management
19 17 (14.66%) Python
19 17 (14.66%) RDBMS
19 17 (14.66%) NoSQL

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 19 (16.38%) Apache Spark
2 11 (9.48%) Apache
3 8 (6.90%) Apache Pig
4 2 (1.72%) Cloud Foundry
4 2 (1.72%) GemFire
5 1 (0.86%) JBoss
Applications
1 2 (1.72%) Microsoft Excel
Business Applications
1 2 (1.72%) Dynamics AX
2 1 (0.86%) NetSuite
Cloud Services
1 12 (10.34%) Microsoft Azure
2 9 (7.76%) Amazon AWS
3 6 (5.17%) PaaS
4 4 (3.45%) IaaS
5 2 (1.72%) GitHub
6 1 (0.86%) Amazon EC2
6 1 (0.86%) Amazon Glacier
6 1 (0.86%) Amazon S3
6 1 (0.86%) Azure Data Factory
6 1 (0.86%) Dynamics 365
Communications & Networking
1 2 (1.72%) Internet
2 1 (0.86%) Extranet
2 1 (0.86%) Intranet
Database & Business Intelligence
1 61 (52.59%) SQL Server
2 38 (32.76%) Data Warehouse
3 37 (31.90%) Relational Database
4 27 (23.28%) OLAP
5 23 (19.83%) Big Data
6 22 (18.97%) SQL Server Integration Services
7 20 (17.24%) Hadoop
7 20 (17.24%) SQL Server Reporting Services
8 18 (15.52%) Apache Hive
9 17 (14.66%) NoSQL
9 17 (14.66%) RDBMS
10 16 (13.79%) Impala
10 16 (13.79%) Power BI
10 16 (13.79%) SQL Server 2008
11 13 (11.21%) MongoDB
11 13 (11.21%) Oracle Database
12 11 (9.48%) Data Lake
12 11 (9.48%) HBase
12 11 (9.48%) MySQL
13 10 (8.62%) SQL Server 2016
Development Applications
1 10 (8.62%) Git (software)
2 9 (7.76%) Team Foundation Server
3 8 (6.90%) Jenkins
3 8 (6.90%) JUnit
3 8 (6.90%) Visual Studio
4 3 (2.59%) ERwin
4 3 (2.59%) Visual Studio Team System
5 2 (1.72%) Eclipse
5 2 (1.72%) Gradle
5 2 (1.72%) IntelliJ
6 1 (0.86%) SQL Server Management Studio (SSMS)
General
1 21 (18.10%) Finance
2 12 (10.34%) Retail
3 9 (7.76%) Banking
4 7 (6.03%) Legal
5 6 (5.17%) Games
6 3 (2.59%) Investment Banking
7 2 (1.72%) Law
7 2 (1.72%) Pharmaceutical
8 1 (0.86%) Billing
8 1 (0.86%) Financial Institution
8 1 (0.86%) Retail Banking
Job Titles
1 60 (51.72%) Developer
2 32 (27.59%) Architect
3 25 (21.55%) SQL Developer
4 17 (14.66%) Data Architect
5 12 (10.34%) Big Data Architect
6 11 (9.48%) Business Intelligence Developer
6 11 (9.48%) DBA
7 10 (8.62%) SQL Server Developer
7 10 (8.62%) T-SQL Developer
8 9 (7.76%) C++ Developer
8 9 (7.76%) Power BI Developer
9 7 (6.03%) Data Warehouse Developer
9 7 (6.03%) Software Engineer
9 7 (6.03%) SQL DBA
10 6 (5.17%) ETL Developer
10 6 (5.17%) Oracle Data Warehouse Developer
10 6 (5.17%) Oracle Developer
10 6 (5.17%) Oracle ETL Developer
10 6 (5.17%) Technical Architect
11 5 (4.31%) C++ Software Engineer
Libraries, Frameworks & Software Standards
1 21 (18.10%) Kafka
2 11 (9.48%) STL
3 10 (8.62%) JSON
3 10 (8.62%) RabbitMQ
3 10 (8.62%) Spark Streaming
4 8 (6.90%) Web Services
4 8 (6.90%) XML
5 6 (5.17%) .NET
5 6 (5.17%) Oracle GoldenGate
6 5 (4.31%) RESTful
7 4 (3.45%) MDX
8 3 (2.59%) J2EE
9 2 (1.72%) JSON Schema
9 2 (1.72%) Middleware
9 2 (1.72%) Spring
9 2 (1.72%) Spring Boot
9 2 (1.72%) Spring Integration
10 1 (0.86%) React
10 1 (0.86%) REST
10 1 (0.86%) SOAP
Miscellaneous
1 12 (10.34%) Replication
2 10 (8.62%) Analytical Skills
3 7 (6.03%) N-Tier
4 4 (3.45%) Computer Science
4 4 (3.45%) Management Information System
5 3 (2.59%) Data Structures
5 3 (2.59%) Fixed Income
6 2 (1.72%) Enterprise Software
6 2 (1.72%) Fintech
6 2 (1.72%) Greenfield Project
6 2 (1.72%) Linux Command Line
6 2 (1.72%) Virtual Team
7 1 (0.86%) Data Centre
7 1 (0.86%) FMCG
7 1 (0.86%) Hedge funds
Operating Systems
1 27 (23.28%) Unix
2 18 (15.52%) Linux
3 7 (6.03%) Windows
4 3 (2.59%) Windows 10
4 3 (2.59%) Windows 7
Processes & Methodologies
1 45 (38.79%) Business Intelligence
2 36 (31.03%) Agile Software Development
3 34 (29.31%) Data Modelling
4 25 (21.55%) Performance Tuning
5 22 (18.97%) ETL
6 20 (17.24%) Scrum
7 18 (15.52%) Stakeholder Management
8 14 (12.07%) Data Analysis
8 14 (12.07%) Dimensional Modelling
9 12 (10.34%) Data Integration
9 12 (10.34%) Multithreading
10 11 (9.48%) Analytics
10 11 (9.48%) OO
10 11 (9.48%) Unit Testing
10 11 (9.48%) Validation
11 10 (8.62%) Data Engineering
11 10 (8.62%) Database Tuning
12 9 (7.76%) Kimball Methodology
12 9 (7.76%) Waterfall
13 8 (6.90%) Data Transformation
Programming Languages
1 69 (59.48%) SQL
2 31 (26.72%) T-SQL
3 19 (16.38%) C++
4 17 (14.66%) Python
5 16 (13.79%) Java
6 12 (10.34%) Shell Script
7 8 (6.90%) Scala
8 7 (6.03%) Data Analysis Expressions (DAX)
9 3 (2.59%) PowerShell
10 2 (1.72%) C#
10 2 (1.72%) Java 8
10 2 (1.72%) Perl
10 2 (1.72%) PL/SQL
11 1 (0.86%) VB.NET
11 1 (0.86%) VBA
11 1 (0.86%) VBScript
Qualifications
1 8 (6.90%) Microsoft Certification
2 7 (6.03%) MCSE
3 5 (4.31%) SC Cleared
3 5 (4.31%) Security Cleared
4 3 (2.59%) Degree
5 2 (1.72%) Computer Science Degree
6 1 (0.86%) CISSP
Quality Assurance & Compliance
1 4 (3.45%) Data Quality
1 4 (3.45%) GDPR
2 3 (2.59%) QA
System Software
1 18 (15.52%) HDFS
2 16 (13.79%) Apache Flume
3 10 (8.62%) Apache ZooKeeper
4 3 (2.59%) SRDF
4 3 (2.59%) Virtual Machines
Systems Management
1 8 (6.90%) Oozie
2 3 (2.59%) Failover Clustering
2 3 (2.59%) Microsoft Clustering
Vendors
1 33 (28.45%) Oracle
2 26 (22.41%) Microsoft
3 9 (7.76%) Cloudera
4 8 (6.90%) Hortonworks
4 8 (6.90%) MapR
5 6 (5.17%) EXASOL
6 5 (4.31%) MicroStrategy
7 3 (2.59%) EMC
8 2 (1.72%) RedGate
8 2 (1.72%) Salesforce.com
8 2 (1.72%) Tableau
9 1 (0.86%) Ab Initio
9 1 (0.86%) IBM
9 1 (0.86%) JD Edwards
9 1 (0.86%) SAP