The table below looks at the statistics for OLTP skills in IT jobs advertised for the Yorkshire region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 27 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
27 May 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 243 244 260
Rank change year-on-year
+1 +16
Permanent jobs citing OLTP 8 10 1
As % of all permanent IT jobs located in Yorkshire 0.14% 0.15% 0.014%
As % of the Database & Business Intelligence category 0.42% 0.46% 0.042%
Number of salaries quoted 7 10 0
Median salary £65,000 £32,000 -
Median salary % change year-on-year
+103.12% -
UK excluding London median salary £47,500 £45,000 £52,500
% change year-on-year
+5.55% -14.28%
OLTP
England

The following table is for comparison with the above and provides statistics for the entire Database & Business Intelligence category in permanent jobs advertised in the Yorkshire region.

Database & Business Intelligence Category
Yorkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1885 2192 2359
As % of all permanent IT jobs located in Yorkshire 31.92% 33.09% 32.85%
Number of salaries quoted 1534 1858 2007
Median salary £40,000 £39,500 £37,500
Median salary % change year-on-year
+1.26% +5.33%
90% offered a salary of more than £30,000 £30,000 £28,000
10% offered a salary of more than £55,000 £50,000 £55,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLTP
Jobs Demand Trend in Yorkshire

The demand trend of job ads across the Yorkshire region citing OLTP as a proportion of all IT jobs with a match in the Database & Business Intelligence category.

OLTP Jobs Demand Trend in Yorkshire

OLTP
Salary Trend in Yorkshire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing OLTP across the Yorkshire region.

OLTP Salary Trend in Yorkshire

OLTP
Salary Histogram in Yorkshire

This chart provides a salary histogram for IT jobs citing OLTP across the Yorkshire region over the 3 months to 27 May 2016.

OLTP Salary Histogram in Yorkshire

OLTP
Job Locations in Yorkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Yorkshire region over the 3 months to 27 May 2016. 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
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
West Yorkshire - 7 £65,000 -
North Yorkshire +1 1 £40,500 +26.56%
OLTP
England

OLTP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 27 May 2016, IT jobs citing OLTP also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Yorkshire region with a requirement for OLTP.

1 13 (86.67%) OLAP
2 11 (73.33%) Intranet
2 11 (73.33%) Extranet
2 11 (73.33%) Business Continuity
2 11 (73.33%) SOA
3 9 (60.00%) XML
4 8 (53.33%) SQL
5 7 (46.67%) SOAP
5 7 (46.67%) Stakeholder Management
5 7 (46.67%) SQL Server
5 7 (46.67%) WCF
5 7 (46.67%) REST
6 6 (40.00%) Microsoft
6 6 (40.00%) .NET
7 5 (33.33%) Windows Identity Foundation
7 5 (33.33%) WF
7 5 (33.33%) TOGAF
8 4 (26.67%) Enterprise Architecture
8 4 (26.67%) Data Protection Act
8 4 (26.67%) Data Protection
8 4 (26.67%) Finance
9 3 (20.00%) Business Intelligence
9 3 (20.00%) ETL
9 3 (20.00%) Data Warehouse
9 3 (20.00%) Coaching
9 3 (20.00%) Performance Management
10 2 (13.33%) SDLC
10 2 (13.33%) Enterprise Data Warehouse
10 2 (13.33%) Enterprise Modelling
10 2 (13.33%) Data Modelling

OLTP
Top Related IT Skills in Yorkshire 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:

Applications
1 1 (6.67%) MS Excel
Business Applications
1 1 (6.67%) BASE24
Communications & Networking
1 11 (73.33%) Extranet
1 11 (73.33%) Intranet
2 1 (6.67%) SAN
2 1 (6.67%) WebEx
Database & Business Intelligence
1 13 (86.67%) OLAP
2 7 (46.67%) SQL Server
3 3 (20.00%) Data Warehouse
4 2 (13.33%) Enterprise Data Warehouse
5 1 (6.67%) Microsoft Analysis Services
5 1 (6.67%) MySQL
5 1 (6.67%) Relational Database
5 1 (6.67%) SQL Server 2005
5 1 (6.67%) SQL Server 2008
5 1 (6.67%) SQL Server Analysis Services
5 1 (6.67%) SQL Server Integration Services
5 1 (6.67%) SQL Server Reporting Services
Development Applications
1 2 (13.33%) ERwin
2 1 (6.67%) Git (software)
2 1 (6.67%) Subversion
General
1 4 (26.67%) Finance
Job Titles
1 13 (86.67%) Architect
2 11 (73.33%) Infrastructure Architect
3 4 (26.67%) Infrastructure Solutions Architect
3 4 (26.67%) Solutions Architect
4 3 (20.00%) IT Architect
4 3 (20.00%) IT Infrastructure Architect
5 2 (13.33%) Data Architect
6 1 (6.67%) Consultant
6 1 (6.67%) Developer
6 1 (6.67%) Infrastructure Technical Architect
6 1 (6.67%) Presales Consultant
6 1 (6.67%) Product Consultant
6 1 (6.67%) SQL Developer
6 1 (6.67%) Technical Architect
6 1 (6.67%) Technical Infrastructure Architect
6 1 (6.67%) Technical Solutions Architect
Libraries, Frameworks & Software Standards
1 9 (60.00%) XML
2 7 (46.67%) REST
2 7 (46.67%) SOAP
2 7 (46.67%) WCF
3 6 (40.00%) .NET
4 5 (33.33%) WF
4 5 (33.33%) Windows Identity Foundation
5 1 (6.67%) WSDL
Miscellaneous
1 4 (26.67%) Data Protection Act
2 1 (6.67%) Analytical Skills
2 1 (6.67%) Driving Licence
Processes & Methodologies
1 11 (73.33%) Business Continuity
1 11 (73.33%) SOA
2 7 (46.67%) Stakeholder Management
3 5 (33.33%) TOGAF
4 4 (26.67%) Data Protection
4 4 (26.67%) Enterprise Architecture
5 3 (20.00%) Business Intelligence
5 3 (20.00%) Coaching
5 3 (20.00%) ETL
5 3 (20.00%) Performance Management
6 2 (13.33%) Data Modelling
6 2 (13.33%) Enterprise Modelling
6 2 (13.33%) SDLC
7 1 (6.67%) Data Migration
7 1 (6.67%) Kimball Methodology
7 1 (6.67%) Migration
7 1 (6.67%) OO
7 1 (6.67%) OOP
7 1 (6.67%) Presales
Programming Languages
1 8 (53.33%) SQL
2 1 (6.67%) C#
2 1 (6.67%) C++
2 1 (6.67%) Java
2 1 (6.67%) Python
2 1 (6.67%) T-SQL
2 1 (6.67%) VB.NET
Vendors
1 6 (40.00%) Microsoft
2 1 (6.67%) Oracle