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 26 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
26 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 225 241 256
Rank change year-on-year
+16 +15
Permanent jobs citing OLTP 10 28 6
As % of all permanent IT jobs located in Yorkshire 0.18% 0.40% 0.086%
As % of the Database & Business Intelligence category 0.61% 1.18% 0.26%
Number of salaries quoted 9 24 3
Median salary £80,000 £62,500 £52,500
Median salary % change year-on-year
+28.00% +19.04%
90% offered a salary of more than £74,500 £32,000 £31,700
10% offered a salary of more than £85,000 £95,000 £58,500
UK excluding London median salary £43,000 £45,000 £47,750
% change year-on-year
-4.44% -5.75%
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
1644 2376 2279
As % of all permanent IT jobs located in Yorkshire 29.74% 34.31% 32.48%
Number of salaries quoted 1376 2035 1898
Median salary £41,500 £40,000 £38,000
Median salary % change year-on-year
+3.75% +5.26%
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £55,000 £50,000 £60,000
UK excluding London median salary £42,500 £42,000 £40,000
% change year-on-year
+1.19% +5.00%

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 26 July 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 26 July 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 +13 10 £80,000 +28.00%
OLTP
England

OLTP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 26 July 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 18 (90.00%) OLAP
2 16 (80.00%) Intranet
2 16 (80.00%) Extranet
2 16 (80.00%) Business Continuity
3 13 (65.00%) SOA
4 9 (45.00%) Stakeholder Management
5 8 (40.00%) Data Protection Act
5 8 (40.00%) Data Protection
5 8 (40.00%) XML
6 7 (35.00%) B2B
6 7 (35.00%) B2C
6 7 (35.00%) Finance
7 6 (30.00%) SQL Server
7 6 (30.00%) SOAP
7 6 (30.00%) WCF
7 6 (30.00%) Enterprise Architecture
7 6 (30.00%) REST
8 5 (25.00%) TOGAF
8 5 (25.00%) .NET
8 5 (25.00%) SQL
8 5 (25.00%) Microsoft
9 4 (20.00%) Firewall
9 4 (20.00%) Information Security
9 4 (20.00%) WF
9 4 (20.00%) Windows Identity Foundation
10 3 (15.00%) Coaching
10 3 (15.00%) SQL Server 2005
10 3 (15.00%) Business Intelligence
10 3 (15.00%) ETL
10 3 (15.00%) Data Warehouse

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 (5.00%) MS Excel
Business Applications
1 1 (5.00%) BASE24
Communications & Networking
1 16 (80.00%) Extranet
1 16 (80.00%) Intranet
2 4 (20.00%) Firewall
3 2 (10.00%) Skype
4 1 (5.00%) WebEx
Database & Business Intelligence
1 18 (90.00%) OLAP
2 6 (30.00%) SQL Server
3 3 (15.00%) Data Warehouse
3 3 (15.00%) SQL Server 2005
4 2 (10.00%) Enterprise Data Warehouse
5 1 (5.00%) Microsoft Analysis Services
5 1 (5.00%) MySQL
5 1 (5.00%) Relational Database
5 1 (5.00%) SQL Server 2008
5 1 (5.00%) SQL Server Analysis Services
5 1 (5.00%) SQL Server Integration Services
5 1 (5.00%) SQL Server Reporting Services
Development Applications
1 2 (10.00%) ERwin
2 1 (5.00%) Git (software)
2 1 (5.00%) Subversion
General
1 7 (35.00%) Finance
Job Titles
1 18 (90.00%) Architect
2 9 (45.00%) Infrastructure Architect
3 4 (20.00%) Infrastructure Solutions Architect
3 4 (20.00%) IT Architect
3 4 (20.00%) Security Architect
3 4 (20.00%) Solutions Architect
4 3 (15.00%) IT Infrastructure Architect
4 3 (15.00%) Technical Architect
5 2 (10.00%) Business Architect
5 2 (10.00%) Data Architect
5 2 (10.00%) Enterprise Architect
5 2 (10.00%) Infrastructure Technical Architect
5 2 (10.00%) Technical Infrastructure Architect
6 1 (5.00%) Domain Architect
6 1 (5.00%) Lead Architect
6 1 (5.00%) Presales Consultant
6 1 (5.00%) Product Consultant
6 1 (5.00%) SQL Developer
6 1 (5.00%) Technical Leader
6 1 (5.00%) Technical Solutions Architect
Libraries, Frameworks & Software Standards
1 8 (40.00%) XML
2 6 (30.00%) REST
2 6 (30.00%) SOAP
2 6 (30.00%) WCF
3 5 (25.00%) .NET
4 4 (20.00%) WF
4 4 (20.00%) Windows Identity Foundation
5 1 (5.00%) WSDL
Miscellaneous
1 8 (40.00%) Data Protection Act
2 1 (5.00%) Analytical Skills
2 1 (5.00%) CESG
2 1 (5.00%) Driving Licence
Processes & Methodologies
1 16 (80.00%) Business Continuity
2 13 (65.00%) SOA
3 9 (45.00%) Stakeholder Management
4 8 (40.00%) Data Protection
5 7 (35.00%) B2B
5 7 (35.00%) B2C
6 6 (30.00%) Enterprise Architecture
7 5 (25.00%) TOGAF
8 4 (20.00%) Information Security
9 3 (15.00%) Business Intelligence
9 3 (15.00%) Coaching
9 3 (15.00%) ETL
10 2 (10.00%) Business Transformation
10 2 (10.00%) Data Modelling
10 2 (10.00%) Enterprise Modelling
10 2 (10.00%) Performance Management
10 2 (10.00%) SDLC
10 2 (10.00%) Security Architecture
10 2 (10.00%) Stakeholder Engagement
11 1 (5.00%) Data Migration
Programming Languages
1 5 (25.00%) SQL
2 1 (5.00%) C#
2 1 (5.00%) C++
2 1 (5.00%) Java
2 1 (5.00%) Python
2 1 (5.00%) T-SQL
2 1 (5.00%) VB.NET
Qualifications
1 1 (5.00%) CISSP
1 1 (5.00%) Degree
Quality Assurance & Compliance
1 2 (10.00%) PCI DSS
Vendors
1 5 (25.00%) Microsoft
2 1 (5.00%) Oracle