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

3 months to
25 Feb 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
UK / Scotland
Rank 130 150 -
Rank change year-on-year
+20 -
Permanent jobs citing OLTP 5 6 0
As % of all permanent IT jobs located in Scotland 0.22% 0.20% -
As % of the Database & Business Intelligence category 0.61% 0.64% -
Number of salaries quoted 4 1 0
Median salary £62,500 £40,000 -
Median salary % change year-on-year
+56.25% -
UK excluding London median salary £52,500 £47,500 £45,000
% change year-on-year
+10.52% +5.55%

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

Database & Business Intelligence Category
Scotland
Permanent IT job ads with a match in the
Database & Business Intelligence category
815 936 977
As % of all permanent IT jobs located in Scotland 36.35% 31.59% 30.72%
Number of salaries quoted 520 597 659
Median salary £42,500 £47,500 £40,000
Median salary % change year-on-year
-10.52% +18.75%
90% offered a salary of more than £31,000 £32,500 £32,500
10% offered a salary of more than £65,500 £55,000 £57,500
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

OLTP
Jobs Demand Trend in Scotland

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

OLTP Jobs Demand Trend in Scotland

OLTP
Salary Trend in Scotland

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

OLTP Salary Trend in Scotland

OLTP
Salary Histogram in Scotland

This chart provides a salary histogram for IT jobs citing OLTP across the Scotland region over the 3 months to 25 February 2017.

OLTP Salary Histogram in Scotland

OLTP
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing OLTP within the Scotland region over the 3 months to 25 February 2017. 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 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
Glasgow +30 5 £62,500 +56.25%
OLTP
UK

OLTP
Top 30 Related IT Skills in Scotland

For the 6 months to 25 February 2017, 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 Scotland region with a requirement for OLTP.

1 10 (83.33%) OLAP
2 6 (50.00%) Migration
2 6 (50.00%) UML
2 6 (50.00%) Data Modelling
2 6 (50.00%) MagicDraw
2 6 (50.00%) Data Architecture
2 6 (50.00%) Data Lake
3 5 (41.67%) Analytical Skills
3 5 (41.67%) ISO20022
3 5 (41.67%) Information Architecture
3 5 (41.67%) Data Quality
3 5 (41.67%) IBM
3 5 (41.67%) Data Warehouse
3 5 (41.67%) XML
3 5 (41.67%) ERwin
4 4 (33.33%) Back Office
4 4 (33.33%) Banking
4 4 (33.33%) Data Management
4 4 (33.33%) SQL
4 4 (33.33%) T-SQL
4 4 (33.33%) SQL Server
4 4 (33.33%) ETL
4 4 (33.33%) XML Schema
4 4 (33.33%) Star Schema
4 4 (33.33%) Metadata Management
4 4 (33.33%) Data Integration
4 4 (33.33%) Cash Management
4 4 (33.33%) Taxonomies
4 4 (33.33%) Ontologies
4 4 (33.33%) Degree

OLTP
Top Related IT Skills in Scotland 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 (8.33%) MS Excel
Cloud Services
1 2 (16.67%) Cloud Computing
2 1 (8.33%) Amazon AWS
2 1 (8.33%) Microsoft Azure
Database & Business Intelligence
1 10 (83.33%) OLAP
2 6 (50.00%) Data Lake
3 5 (41.67%) Data Warehouse
4 4 (33.33%) SQL Server
4 4 (33.33%) SQL Server 2005
4 4 (33.33%) SQL Server Integration Services
4 4 (33.33%) Star Schema
5 3 (25.00%) SQL Server 2012
6 2 (16.67%) NoSQL
7 1 (8.33%) DTS
7 1 (8.33%) InterSystems Cache
7 1 (8.33%) SQL Server 2016
Development Applications
1 6 (50.00%) MagicDraw
2 5 (41.67%) ERwin
General
1 4 (33.33%) Back Office
1 4 (33.33%) Banking
1 4 (33.33%) General Ledger
2 1 (8.33%) Finance
Job Titles
1 8 (66.67%) Architect
2 5 (41.67%) Information Architect
3 2 (16.67%) DBA
3 2 (16.67%) Developer
3 2 (16.67%) Senior Architect
3 2 (16.67%) Senior Developer
3 2 (16.67%) Senior SQL Developer
3 2 (16.67%) SQL Developer
3 2 (16.67%) Technical Architect
4 1 (8.33%) Administrator
4 1 (8.33%) Data Architect
4 1 (8.33%) Data Modeller
4 1 (8.33%) Senior Data Architect
4 1 (8.33%) Senior Data Modeller
4 1 (8.33%) Senior Information Architect
4 1 (8.33%) Senior SQL Server Developer
4 1 (8.33%) SQL DBA
4 1 (8.33%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 5 (41.67%) XML
2 4 (33.33%) XML Schema
Miscellaneous
1 5 (41.67%) Analytical Skills
2 4 (33.33%) Reference Data
2 4 (33.33%) Taxonomies
3 2 (16.67%) Clustering
3 2 (16.67%) Replication
Processes & Methodologies
1 6 (50.00%) Data Architecture
1 6 (50.00%) Data Modelling
1 6 (50.00%) Migration
1 6 (50.00%) UML
2 5 (41.67%) Information Architecture
3 4 (33.33%) Cash Management
3 4 (33.33%) Data Integration
3 4 (33.33%) Data Lineage
3 4 (33.33%) Data Management
3 4 (33.33%) Data Migration
3 4 (33.33%) ETL
3 4 (33.33%) Logical Data Model
3 4 (33.33%) Metadata Management
3 4 (33.33%) Ontologies
3 4 (33.33%) Physical Data Model
3 4 (33.33%) Reference Data Management
4 2 (16.67%) Agile Software Development
4 2 (16.67%) Data Mapping
4 2 (16.67%) E-Commerce
4 2 (16.67%) Technical Architecture
Programming Languages
1 4 (33.33%) SQL
1 4 (33.33%) T-SQL
2 1 (8.33%) C#
Qualifications
1 4 (33.33%) Degree
Quality Assurance & Compliance
1 5 (41.67%) Data Quality
1 5 (41.67%) ISO20022
Vendors
1 5 (41.67%) IBM
2 2 (16.67%) Microsoft