The table below looks at the statistics for OLTP skills in IT jobs advertised for the Berkshire 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 202 191 215
Rank change year-on-year
-11 +24
Permanent jobs citing OLTP 8 27 5
As % of all permanent IT jobs located in Berkshire 0.18% 0.54% 0.090%
As % of the Database & Business Intelligence category 0.66% 1.94% 0.38%
Number of salaries quoted 8 9 5
Median salary £52,500 £47,500 £60,000
Median salary % change year-on-year
+10.52% -20.83%
90% offered a salary of more than £41,750 £44,700 £57,000
10% offered a salary of more than £56,500 £54,500 £63,000
UK excluding London median salary £43,000 £45,000 £47,750
% change year-on-year
-4.44% -5.75%
OLTP
South East

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 Berkshire region.

Database & Business Intelligence Category
Berkshire
Permanent IT job ads with a match in the
Database & Business Intelligence category
1209 1393 1321
As % of all permanent IT jobs located in Berkshire 27.29% 27.84% 23.91%
Number of salaries quoted 1065 1111 1101
Median salary £50,000 £47,500 £45,000
Median salary % change year-on-year
+5.26% +5.55%
90% offered a salary of more than £35,000 £32,500 £30,000
10% offered a salary of more than £65,000 £62,500 £65,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 Berkshire

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

OLTP Jobs Demand Trend in Berkshire

OLTP
Salary Trend in Berkshire

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

OLTP Salary Trend in Berkshire

OLTP
Salary Histogram in Berkshire

This chart provides a salary histogram for IT jobs citing OLTP across the Berkshire region over the 3 months to 26 July 2016.

OLTP Salary Histogram in Berkshire

OLTP
Job Locations in Berkshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Berkshire 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
Slough +15 5 £55,000 +24.29%
Bracknell -4 3 £42,500 -
OLTP
South East

OLTP
Top 30 Related IT Skills in Berkshire

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 Berkshire region with a requirement for OLTP.

1 9 (100.00%) SQL
1 9 (100.00%) SQL Server
2 8 (88.89%) T-SQL
2 8 (88.89%) ETL
2 8 (88.89%) Business Intelligence
2 8 (88.89%) SQL Server Integration Services
2 8 (88.89%) SQL Server 2012
2 8 (88.89%) SQL Server 2014
3 5 (55.56%) SQL Server Reporting Services
3 5 (55.56%) Data Warehouse
3 5 (55.56%) Data Modelling
3 5 (55.56%) PL/SQL
3 5 (55.56%) OLAP
3 5 (55.56%) Data Analysis Expressions (DAX)
3 5 (55.56%) MDX
4 4 (44.44%) JIRA
4 4 (44.44%) Release Management
4 4 (44.44%) Business Intelligence Development Studio
4 4 (44.44%) SQL Server Management Studio (SSMS)
4 4 (44.44%) Visual Studio
4 4 (44.44%) MySQL
4 4 (44.44%) MS Excel
4 4 (44.44%) Microsoft
5 3 (33.33%) Security Management
5 3 (33.33%) Data Management
5 3 (33.33%) Analytical Skills
5 3 (33.33%) SQL Server Analysis Services
5 3 (33.33%) Performance Management
5 3 (33.33%) NoSQL
5 3 (33.33%) SQL Server 2016

OLTP
Top Related IT Skills in Berkshire 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 4 (44.44%) MS Excel
Database & Business Intelligence
1 9 (100.00%) SQL Server
2 8 (88.89%) SQL Server 2012
2 8 (88.89%) SQL Server 2014
2 8 (88.89%) SQL Server Integration Services
3 5 (55.56%) Data Warehouse
3 5 (55.56%) OLAP
3 5 (55.56%) SQL Server Reporting Services
4 4 (44.44%) Business Intelligence Development Studio
4 4 (44.44%) MySQL
5 3 (33.33%) NoSQL
5 3 (33.33%) Relational Database
5 3 (33.33%) SQL Server 2016
5 3 (33.33%) SQL Server Analysis Services
6 1 (11.11%) Data Mart
6 1 (11.11%) SQL Server 2005
Development Applications
1 4 (44.44%) JIRA
1 4 (44.44%) SQL Server Management Studio (SSMS)
1 4 (44.44%) Visual Studio
Job Titles
1 6 (66.67%) Business Intelligence Developer
1 6 (66.67%) Developer
2 4 (44.44%) DBA
2 4 (44.44%) SQL DBA
2 4 (44.44%) SQL Server DBA
3 3 (33.33%) SQL BI Developer
3 3 (33.33%) SQL Developer
4 2 (22.22%) MySQL Developer
4 2 (22.22%) Senior Business Intelligence Developer
4 2 (22.22%) Senior Developer
4 2 (22.22%) SSIS Developer
4 2 (22.22%) T-SQL Developer
5 1 (11.11%) Microsoft BI Developer
5 1 (11.11%) Microsoft Developer
5 1 (11.11%) SQL Server BI Developer
5 1 (11.11%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 5 (55.56%) MDX
Miscellaneous
1 3 (33.33%) Analytical Skills
2 2 (22.22%) Statistics
Operating Systems
1 1 (11.11%) Linux
1 1 (11.11%) Solaris
1 1 (11.11%) Windows
Processes & Methodologies
1 8 (88.89%) Business Intelligence
1 8 (88.89%) ETL
2 5 (55.56%) Data Modelling
3 4 (44.44%) Release Management
4 3 (33.33%) Data Management
4 3 (33.33%) Data Transformation
4 3 (33.33%) Performance Management
4 3 (33.33%) Performance Tuning
4 3 (33.33%) Security Management
5 2 (22.22%) E-Commerce
5 2 (22.22%) Kimball Methodology
5 2 (22.22%) Logical Data Model
5 2 (22.22%) Physical Data Model
6 1 (11.11%) Analytics
6 1 (11.11%) Capacity Management
6 1 (11.11%) Configuration Management
6 1 (11.11%) Data Analysis
6 1 (11.11%) High Availability
6 1 (11.11%) Translating Business Requirements
Programming Languages
1 9 (100.00%) SQL
2 8 (88.89%) T-SQL
3 5 (55.56%) Data Analysis Expressions (DAX)
3 5 (55.56%) PL/SQL
4 1 (11.11%) Perl
Systems Management
1 1 (11.11%) Oracle RMAN
Vendors
1 4 (44.44%) Microsoft