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 3 months to 25 March 2017 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.

3 months to
25 Mar 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK
Rank 545 574 553
Rank change year-on-year +29 -21  
Contract jobs citing OLTP 48 70 71
As % of all contract IT jobs advertised in the UK 0.11% 0.13% 0.13%
As % of the Database & Business Intelligence category 0.47% 0.59% 0.60%
Number of daily rates quoted 28 30 49
Median daily rate £425 £466 £375
Median daily rate % change year-on-year -8.84% +24.33%  
90% offered a daily rate of more than £200 £365 £298
10% offered a daily rate of more than £547 £541 £500
UK excluding London median daily rate £425 £419 £335
% change year-on-year +1.49% +25.00%  
Number of hourly rates quoted 0 4 1
Median hourly rate - £50.50 £37.50
Median hourly rate % change year-on-year - +34.66%  
UK excluding London median hourly rate - £50.50 £37.50
% change year-on-year - +34.66%  

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

Contract Database & Business Intelligence Skills
UK
Contract job vacancies with a requirement for database and business intelligence skills 10310 11780 11881
As % of all contract IT job vacancies advertised in the UK 22.76% 22.14% 22.46%
Number of daily rates quoted 6977 7896 7584
Median daily rate £438 £425 £400
Median daily rate % change year-on-year +2.94% +6.25%  
90% offered a daily rate of more than £300 £300 £275
10% offered a daily rate of more than £600 £600 £550
UK excluding London median daily rate £400 £388 £375
% change year-on-year +3.22% +3.33%  
Number of hourly rates quoted 130 189 157
Median hourly rate £30.50 £32.50 £32.10
Median hourly rate % change year-on-year -6.15% +1.24%  
90% offered a hourly rate of more than £11.75 £14.50 £15.35
10% offered a hourly rate of more than £47.00 £60.62 £46.94
UK excluding London median hourly rate £31.00 £32.50 £32.50
% change year-on-year -4.61% -  

OLTP
Job Vacancy Trend

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

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 3 months to 25 March 2017.

Contractor daily rate histogram for OLTP in the UK

OLTP
Contractor Hourly Rate Trend

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

Contractor hourly rate trend for OLTP in the UK

OLTP
Top 21 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 3 months to 25 March 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
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +8 44 £425 -9.57% 9
London +10 21 £400 -19.59% 5
South West - 7 £496 -
Dorset - 6 £498 -
Essex - 5 £456 -
Bournemouth - 5 £498 -
Yorkshire - 5 £463 -
East of England - 5 £456 - 3
South East +7 4 £425 +1.49% 1
West Yorkshire - 4 - -
City of London +2 2 £569 +56.89% 2
West Sussex - 2 £425 - 1
Bradford - 2 - -
Leeds - 2 - -
Berkshire +22 1 £350 -16.41%
West Midlands +11 1 £550 +41.93%
Wiltshire - 1 £315 -
Hampshire - 1 - -
Croydon - 1 £383 -
Reading - 1 £350 -
Farnborough - 1 - -

OLTP
Top 30 Related IT Skills

For the 6 months to 25 March 2017, IT contractor jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all contract ads with a requirement for OLTP.

1 76 (71.03%) SQL
2 58 (54.21%) Oracle
3 45 (42.06%) OLAP
4 43 (40.19%) SQL Server
5 38 (35.51%) Unix
6 37 (34.58%) Data Warehouse
7 35 (32.71%) ETL
8 31 (28.97%) Data Modelling
8 31 (28.97%) Business Intelligence
9 30 (28.04%) STL
9 30 (28.04%) C++
9 30 (28.04%) Oracle Database
10 28 (26.17%) SDLC
10 28 (26.17%) Release Management
10 28 (26.17%) Database Tuning
11 26 (24.30%) Software Engineering
12 25 (23.36%) Performance Tuning
13 24 (22.43%) SQL Server Integration Services
13 24 (22.43%) OO
14 22 (20.56%) Perl
14 22 (20.56%) Finance
15 21 (19.63%) Python
15 21 (19.63%) SQL Server Reporting Services
16 18 (16.82%) Agile Software Development
16 18 (16.82%) T-SQL
17 17 (15.89%) Data Integration
18 16 (14.95%) SQL Server Analysis Services
18 16 (14.95%) Hadoop
18 16 (14.95%) Migration
18 16 (14.95%) Analytical Skills

OLTP
Top Related 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 8 (7.48%) Oracle SOA Suite
2 6 (5.61%) Apache Pig
2 6 (5.61%) Apache Solr
2 6 (5.61%) SharePoint
3 4 (3.74%) Adobe Experience Manager
4 3 (2.80%) Apache
4 3 (2.80%) Tomcat
5 2 (1.87%) Apache Spark
5 2 (1.87%) Cloud Foundry
5 2 (1.87%) GemFire
5 2 (1.87%) WebLogic
6 1 (0.93%) Confluence
6 1 (0.93%) Elasticsearch
6 1 (0.93%) JBoss
Applications
1 10 (9.35%) MS Excel
2 5 (4.67%) MS Visio
Business Applications
1 4 (3.74%) Adobe Campaign
2 2 (1.87%) Dynamics CRM
3 1 (0.93%) BPCS
Cloud Services
1 7 (6.54%) Microsoft Azure
2 5 (4.67%) IBM Cloud
2 5 (4.67%) SaaS
3 4 (3.74%) Adobe Analytics
4 2 (1.87%) GitHub
4 2 (1.87%) PaaS
5 1 (0.93%) Amazon AWS
5 1 (0.93%) Google Analytics
Communications & Networking
1 8 (7.48%) Intranet
2 4 (3.74%) Extranet
Database & Business Intelligence
1 45 (42.06%) OLAP
2 43 (40.19%) SQL Server
3 37 (34.58%) Data Warehouse
4 30 (28.04%) Oracle Database
5 24 (22.43%) SQL Server Integration Services
6 21 (19.63%) SQL Server Reporting Services
7 16 (14.95%) Hadoop
7 16 (14.95%) SQL Server Analysis Services
8 14 (13.08%) Big Data
8 14 (13.08%) Oracle OLAP
8 14 (13.08%) SQL Server 2012
9 12 (11.21%) SQL Server 2014
10 11 (10.28%) Data Mining
11 9 (8.41%) SQL Server 2008
12 8 (7.48%) Apache Hive
12 8 (7.48%) HBase
13 7 (6.54%) Data Mart
13 7 (6.54%) DB2
13 7 (6.54%) Oracle ODI
14 6 (5.61%) Snowflake Schema
Development Applications
1 9 (8.41%) Git (software)
2 8 (7.48%) Team Foundation Server
3 7 (6.54%) JIRA
4 6 (5.61%) Talend Open Studio
5 5 (4.67%) ERwin
5 5 (4.67%) MagicDraw
6 3 (2.80%) Jenkins
7 2 (1.87%) Eclipse
7 2 (1.87%) Gradle
7 2 (1.87%) JUnit
8 1 (0.93%) IntelliJ
8 1 (0.93%) Sonatype Nexus
8 1 (0.93%) SQL Server Management Studio (SSMS)
8 1 (0.93%) Toad
8 1 (0.93%) Visual Studio
General
1 22 (20.56%) Finance
2 9 (8.41%) Banking
3 7 (6.54%) Retail
4 4 (3.74%) Marketing
4 4 (3.74%) Publishing
5 2 (1.87%) Advertising
5 2 (1.87%) Wholesale Banking
6 1 (0.93%) Back Office
6 1 (0.93%) Billing
6 1 (0.93%) French Language
6 1 (0.93%) Investment Banking
6 1 (0.93%) Legal
Job Titles
1 62 (57.94%) Developer
2 31 (28.97%) Architect
3 30 (28.04%) C++ Developer
4 21 (19.63%) Data Architect
5 13 (12.15%) DBA
6 11 (10.28%) ETL Developer
7 8 (7.48%) Business Intelligence Developer
8 7 (6.54%) SQL Developer
9 5 (4.67%) DB2 DBA
9 5 (4.67%) OLAP Developer
9 5 (4.67%) SQL DBA
10 4 (3.74%) Administrator
10 4 (3.74%) DB2 Administrator
10 4 (3.74%) Java Developer
10 4 (3.74%) MySQL Developer
10 4 (3.74%) Oracle Developer
10 4 (3.74%) Solutions Architect
11 3 (2.80%) Information Architect
11 3 (2.80%) Oracle Architect
11 3 (2.80%) Senior Developer
Libraries, Frameworks & Software Standards
1 30 (28.04%) STL
2 12 (11.21%) .NET
3 8 (7.48%) XML
4 5 (4.67%) Lucene
5 4 (3.74%) JSON
6 3 (2.80%) Web Services
7 2 (1.87%) Kafka
7 2 (1.87%) MDX
7 2 (1.87%) Middleware
7 2 (1.87%) Spark Streaming
7 2 (1.87%) Spring
7 2 (1.87%) Spring Boot
7 2 (1.87%) Spring Integration
7 2 (1.87%) XML Schema
8 1 (0.93%) Apache Camel
8 1 (0.93%) REST
8 1 (0.93%) RESTful
8 1 (0.93%) SAML
8 1 (0.93%) XSD
8 1 (0.93%) XSL
Miscellaneous
1 16 (14.95%) Analytical Skills
2 7 (6.54%) Data Structures
2 7 (6.54%) Replication
3 5 (4.67%) HACMP
3 5 (4.67%) Reference Data
3 5 (4.67%) Taxonomies
4 4 (3.74%) Management Information System
5 3 (2.80%) Computer Science
6 2 (1.87%) Clustering
6 2 (1.87%) Linux Command Line
6 2 (1.87%) Mainframe
6 2 (1.87%) SWIFT
7 1 (0.93%) Algorithms
7 1 (0.93%) Equities
7 1 (0.93%) Fintech
7 1 (0.93%) Fixed Income
7 1 (0.93%) Mobile App
7 1 (0.93%) N-Tier
7 1 (0.93%) PKI
7 1 (0.93%) Virtual Team
Operating Systems
1 38 (35.51%) Unix
2 8 (7.48%) Windows
3 5 (4.67%) Linux
4 3 (2.80%) Windows Server
5 2 (1.87%) Red Hat Enterprise Linux
6 1 (0.93%) Solaris
Processes & Methodologies
1 35 (32.71%) ETL
2 31 (28.97%) Business Intelligence
2 31 (28.97%) Data Modelling
3 28 (26.17%) Database Tuning
3 28 (26.17%) Release Management
3 28 (26.17%) SDLC
4 26 (24.30%) Software Engineering
5 25 (23.36%) Performance Tuning
6 24 (22.43%) OO
7 18 (16.82%) Agile Software Development
8 17 (15.89%) Data Integration
9 16 (14.95%) Migration
10 15 (14.02%) Data Architecture
11 14 (13.08%) SOA
12 11 (10.28%) Data Management
12 11 (10.28%) Unit Testing
13 9 (8.41%) Data Migration
13 9 (8.41%) Microservices
13 9 (8.41%) Validation
14 7 (6.54%) Logical Data Model
Programming Languages
1 76 (71.03%) SQL
2 30 (28.04%) C++
3 22 (20.56%) Perl
4 21 (19.63%) Python
5 18 (16.82%) T-SQL
6 12 (11.21%) C#
7 9 (8.41%) Shell Script
8 6 (5.61%) Java
9 5 (4.67%) AWK
9 5 (4.67%) PL/SQL
9 5 (4.67%) R
9 5 (4.67%) VBScript
10 4 (3.74%) VB
11 3 (2.80%) VB.NET
12 2 (1.87%) SPARQL
13 1 (0.93%) COBOL
13 1 (0.93%) Korn
13 1 (0.93%) VBA
Qualifications
1 9 (8.41%) Degree
2 5 (4.67%) Microsoft Certification
3 2 (1.87%) MCITP
Quality Assurance & Compliance
1 11 (10.28%) Data Quality
2 4 (3.74%) QA
3 3 (2.80%) IFRS
3 3 (2.80%) IFRS 9
System Software
1 2 (1.87%) HDFS
2 1 (0.93%) Apache ZooKeeper
Systems Management
1 5 (4.67%) Tivoli Storage Manager
2 2 (1.87%) SQL Sentry
3 1 (0.93%) Ansible
3 1 (0.93%) Opscode Chef
3 1 (0.93%) Oracle Enterprise Manager
3 1 (0.93%) Puppet
3 1 (0.93%) Tivoli
Vendors
1 58 (54.21%) Oracle
2 14 (13.08%) Microsoft
3 7 (6.54%) Tableau
4 6 (5.61%) IBM
4 6 (5.61%) Salesforce.com
4 6 (5.61%) Talend
5 5 (4.67%) Informatica
5 5 (4.67%) NetApp
5 5 (4.67%) Teradata
6 4 (3.74%) Adobe
6 4 (3.74%) Cisco
6 4 (3.74%) Cognos
7 2 (1.87%) MapR
7 2 (1.87%) Red Hat
7 2 (1.87%) RedGate
7 2 (1.87%) Sybase
8 1 (0.93%) Guidewire
8 1 (0.93%) SaltStack
8 1 (0.93%) TARGIT
8 1 (0.93%) WorldPay
West London
Michael Bailey Associates
Rate: Market Rates
Posted: 3 days ago
City, London
onezeero.
Rate: £400 - £500 per day
Posted: 5 days ago