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

3 months to
27 Sep 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 42 27 38
Rank change year-on-year
-15 +11
Permanent jobs citing OLTP 4 13 5
As % of all permanent IT jobs located in Stoke-on-Trent 1.57% 7.47% 1.74%
As % of the Database & Business Intelligence category 3.15% 14.61% 3.21%
Number of salaries quoted 4 8 0
Median salary £50,000 £41,750 -
Median salary % change year-on-year
+19.76% -
UK excluding London median salary £50,000 £50,000 £45,000
% change year-on-year
- +11.11%
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
127 89 156
As % of all permanent IT jobs located in Stoke-on-Trent 50.00% 51.15% 54.36%
Number of salaries quoted 113 80 92
Median salary £37,500 £31,000 £32,500
Median salary % change year-on-year
+20.96% -4.61%
90% offered a salary of more than £25,000 £24,000 £23,500
10% offered a salary of more than £52,500 £55,000 £55,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

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 17 Related IT Skills in Stoke-on-Trent

For the 6 months to 27 September 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
1 8 (100.00%) T-SQL
1 8 (100.00%) SQL Server
1 8 (100.00%) SQL Server Reporting Services
1 8 (100.00%) SQL Server Integration Services
1 8 (100.00%) SQL Server 2008
2 5 (62.50%) Business Intelligence
3 4 (50.00%) Microsoft
3 4 (50.00%) Data Modelling
3 4 (50.00%) ETL
3 4 (50.00%) SQL Server Analysis Services
3 4 (50.00%) Performance Tuning
3 4 (50.00%) Performance Monitoring
3 4 (50.00%) ETL Development
4 3 (37.50%) Analytical Skills
4 3 (37.50%) Enterprise Software
5 1 (12.50%) Finance

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