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

3 months to
24 Jun 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 231 249 261
Rank change year-on-year
+18 +12
Permanent jobs citing OLTP 10 18 2
As % of all permanent IT jobs located in Yorkshire 0.18% 0.26% 0.028%
As % of the Database & Business Intelligence category 0.57% 0.76% 0.086%
Number of salaries quoted 9 17 1
Median salary £77,500 £32,000 £60,000
Median salary % change year-on-year
+142.18% -46.66%
UK excluding London median salary £45,000 £45,000 £45,000
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
1746 2371 2324
As % of all permanent IT jobs located in Yorkshire 30.76% 34.82% 32.32%
Number of salaries quoted 1435 2048 1949
Median salary £40,000 £40,000 £37,500
Median salary % change year-on-year
- +6.66%
90% offered a salary of more than £30,000 £30,000 £27,500
10% offered a salary of more than £56,500 £50,000 £57,500
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 24 June 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 24 June 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 +14 10 £77,500 - 2
OLTP
England

OLTP
Top 30 Related IT Skills in Yorkshire

For the 6 months to 24 June 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 16 (88.89%) OLAP
2 14 (77.78%) Intranet
2 14 (77.78%) Extranet
2 14 (77.78%) SOA
2 14 (77.78%) Business Continuity
3 9 (50.00%) XML
4 7 (38.89%) SOAP
4 7 (38.89%) SQL Server
4 7 (38.89%) Finance
4 7 (38.89%) Stakeholder Management
4 7 (38.89%) Data Protection Act
4 7 (38.89%) WCF
4 7 (38.89%) Data Protection
4 7 (38.89%) REST
5 6 (33.33%) Microsoft
5 6 (33.33%) .NET
5 6 (33.33%) SQL
6 5 (27.78%) WF
6 5 (27.78%) TOGAF
6 5 (27.78%) Windows Identity Foundation
7 4 (22.22%) Information Security
7 4 (22.22%) Enterprise Architecture
7 4 (22.22%) B2B
7 4 (22.22%) B2C
7 4 (22.22%) Firewall
8 3 (16.67%) Business Intelligence
8 3 (16.67%) ETL
8 3 (16.67%) Data Warehouse
8 3 (16.67%) SQL Server 2005
8 3 (16.67%) Coaching

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.56%) MS Excel
Business Applications
1 1 (5.56%) BASE24
Communications & Networking
1 14 (77.78%) Extranet
1 14 (77.78%) Intranet
2 4 (22.22%) Firewall
3 2 (11.11%) Skype
4 1 (5.56%) WebEx
Database & Business Intelligence
1 16 (88.89%) OLAP
2 7 (38.89%) SQL Server
3 3 (16.67%) Data Warehouse
3 3 (16.67%) SQL Server 2005
4 2 (11.11%) Enterprise Data Warehouse
5 1 (5.56%) Microsoft Analysis Services
5 1 (5.56%) MySQL
5 1 (5.56%) Relational Database
5 1 (5.56%) SQL Server 2008
5 1 (5.56%) SQL Server Analysis Services
5 1 (5.56%) SQL Server Integration Services
5 1 (5.56%) SQL Server Reporting Services
Development Applications
1 2 (11.11%) ERwin
2 1 (5.56%) Git (software)
2 1 (5.56%) Subversion
General
1 7 (38.89%) Finance
Job Titles
1 16 (88.89%) Architect
2 10 (55.56%) Infrastructure Architect
3 4 (22.22%) Infrastructure Solutions Architect
3 4 (22.22%) IT Architect
3 4 (22.22%) Security Architect
3 4 (22.22%) Solutions Architect
4 3 (16.67%) IT Infrastructure Architect
5 2 (11.11%) Data Architect
5 2 (11.11%) Infrastructure Technical Architect
5 2 (11.11%) Technical Architect
5 2 (11.11%) Technical Infrastructure Architect
6 1 (5.56%) Consultant
6 1 (5.56%) Developer
6 1 (5.56%) Domain Architect
6 1 (5.56%) IT Security Architect
6 1 (5.56%) Presales Consultant
6 1 (5.56%) Product Consultant
6 1 (5.56%) SQL Developer
6 1 (5.56%) Technical Solutions Architect
Libraries, Frameworks & Software Standards
1 9 (50.00%) XML
2 7 (38.89%) REST
2 7 (38.89%) SOAP
2 7 (38.89%) WCF
3 6 (33.33%) .NET
4 5 (27.78%) WF
4 5 (27.78%) Windows Identity Foundation
5 1 (5.56%) WSDL
Miscellaneous
1 7 (38.89%) Data Protection Act
2 1 (5.56%) Analytical Skills
2 1 (5.56%) CESG
2 1 (5.56%) Driving Licence
Processes & Methodologies
1 14 (77.78%) Business Continuity
1 14 (77.78%) SOA
2 7 (38.89%) Data Protection
2 7 (38.89%) Stakeholder Management
3 5 (27.78%) TOGAF
4 4 (22.22%) B2B
4 4 (22.22%) B2C
4 4 (22.22%) Enterprise Architecture
4 4 (22.22%) Information Security
5 3 (16.67%) Business Intelligence
5 3 (16.67%) Coaching
5 3 (16.67%) ETL
6 2 (11.11%) Data Modelling
6 2 (11.11%) Enterprise Modelling
6 2 (11.11%) Performance Management
6 2 (11.11%) SDLC
6 2 (11.11%) Security Architecture
7 1 (5.56%) Data Migration
7 1 (5.56%) Migration
7 1 (5.56%) Technical Architecture
Programming Languages
1 6 (33.33%) SQL
2 1 (5.56%) C#
2 1 (5.56%) C++
2 1 (5.56%) Java
2 1 (5.56%) Python
2 1 (5.56%) T-SQL
2 1 (5.56%) VB.NET
Qualifications
1 1 (5.56%) CISSP
1 1 (5.56%) Degree
Quality Assurance & Compliance
1 2 (11.11%) PCI DSS
Vendors
1 6 (33.33%) Microsoft
2 1 (5.56%) Oracle
Bradford, West Yorkshire
Rullion IT Plus
Salary: £85000 per annum + benefits
Posted: 16 hours ago
Bradford, West Yorkshire
Fruition IT Resources Limited
Salary: £75000 - £85000 per annum + car, pension, bonus etc
Posted: Yesterday