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

3 months to
25 Jul 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 48 26 43
Rank change year-on-year
-22 +17
Permanent jobs citing OLTP 7 17 1
As % of all permanent IT jobs located in Stoke-on-Trent 2.13% 8.13% 0.35%
As % of the Database & Business Intelligence category 4.32% 17.17% 0.70%
Number of salaries quoted 6 14 1
Median salary £46,250 £31,250 £45,000
Median salary % change year-on-year
+48.00% -30.55%
UK excluding London median salary £44,000 £45,000 £47,750
% change year-on-year
-2.22% -5.75%
OLTP
Staffordshire

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 Stoke-on-Trent region.

Database & Business Intelligence Category
Stoke-on-Trent
Permanent IT job ads with a match in the
Database & Business Intelligence category
162 99 143
As % of all permanent IT jobs located in Stoke-on-Trent 49.24% 47.37% 50.00%
Number of salaries quoted 149 82 88
Median salary £35,000 £37,500 £32,500
Median salary % change year-on-year
-6.66% +15.38%
90% offered a salary of more than £25,000 £25,000 £19,500
10% offered a salary of more than £50,000 £55,000 £55,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 Stoke-on-Trent

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

OLTP Jobs Demand Trend in Stoke-on-Trent

OLTP
Salary Trend in Stoke-on-Trent

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

OLTP Salary Trend in Stoke-on-Trent

OLTP
Top 18 Related IT Skills in Stoke-on-Trent

For the 6 months to 25 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 Stoke-on-Trent region with a requirement for OLTP.

1 8 (100.00%) SQL Server
1 8 (100.00%) SQL
1 8 (100.00%) SQL Server Reporting Services
2 7 (87.50%) SQL Server Integration Services
2 7 (87.50%) SQL Server 2008
2 7 (87.50%) T-SQL
3 5 (62.50%) Data Modelling
3 5 (62.50%) ETL
3 5 (62.50%) ETL Development
4 4 (50.00%) Performance Monitoring
4 4 (50.00%) Business Intelligence
4 4 (50.00%) Analytical Skills
5 3 (37.50%) Microsoft
5 3 (37.50%) Performance Tuning
5 3 (37.50%) SQL Server Analysis Services
6 2 (25.00%) Enterprise Software
6 2 (25.00%) Finance
7 1 (12.50%) Games

OLTP
Top Related IT Skills in Stoke-on-Trent 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:

Database & Business Intelligence
1 8 (100.00%) SQL Server
1 8 (100.00%) SQL Server Reporting Services
2 7 (87.50%) SQL Server 2008
2 7 (87.50%) SQL Server Integration Services
3 3 (37.50%) SQL Server Analysis Services
General
1 2 (25.00%) Finance
2 1 (12.50%) Games
Job Titles
1 5 (62.50%) Developer
1 5 (62.50%) SQL Developer
2 4 (50.00%) SQL Server Developer
3 3 (37.50%) DBA
3 3 (37.50%) Junior
3 3 (37.50%) Junior Developer
3 3 (37.50%) Junior SQL Developer
3 3 (37.50%) Junior SQL Server Developer
3 3 (37.50%) Senior Developer
3 3 (37.50%) Senior SQL Developer
3 3 (37.50%) Senior SQL Server Developer
3 3 (37.50%) SQL DBA
4 2 (25.00%) SQL Server DBA
5 1 (12.50%) Administrator
5 1 (12.50%) Business Intelligence Developer
5 1 (12.50%) MIS Developer
5 1 (12.50%) Report Developer
5 1 (12.50%) SQL BI Developer
5 1 (12.50%) SQL Server BI Developer
5 1 (12.50%) SSRS Developer
Miscellaneous
1 4 (50.00%) Analytical Skills
2 2 (25.00%) Enterprise Software
Processes & Methodologies
1 5 (62.50%) Data Modelling
1 5 (62.50%) ETL
1 5 (62.50%) ETL Development
2 4 (50.00%) Business Intelligence
2 4 (50.00%) Performance Monitoring
3 3 (37.50%) Performance Tuning
Programming Languages
1 8 (100.00%) SQL
2 7 (87.50%) T-SQL
Vendors
1 3 (37.50%) Microsoft