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

3 months to
19 Feb 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
Scotland / Glasgow
Rank 80 105 -
Rank change year-on-year
+25 -
Permanent jobs citing OLTP 5 1 0
As % of all permanent IT jobs located in Glasgow 0.56% 0.073% -
As % of the Database & Business Intelligence category 1.31% 0.20% -
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 Glasgow region.

Database & Business Intelligence Category
Glasgow
Permanent IT job ads with a match in the
Database & Business Intelligence category
382 506 448
As % of all permanent IT jobs located in Glasgow 42.54% 36.91% 39.37%
Number of salaries quoted 229 277 295
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 £29,000 £32,500 £32,500
10% offered a salary of more than £58,000 £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 Glasgow

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

OLTP Jobs Demand Trend in Glasgow

OLTP
Salary Trend in Glasgow

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

OLTP Salary Trend in Glasgow

OLTP
Salary Histogram in Glasgow

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

OLTP Salary Histogram in Glasgow

OLTP
Top 30 Related IT Skills in Glasgow

For the 6 months to 19 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 Glasgow region with a requirement for OLTP.

1 11 (84.62%) OLAP
2 6 (46.15%) Migration
2 6 (46.15%) UML
2 6 (46.15%) Data Modelling
2 6 (46.15%) MagicDraw
2 6 (46.15%) Data Architecture
2 6 (46.15%) Data Lake
3 5 (38.46%) Analytical Skills
3 5 (38.46%) ISO20022
3 5 (38.46%) SQL Server 2005
3 5 (38.46%) SQL Server Integration Services
3 5 (38.46%) Information Architecture
3 5 (38.46%) Data Quality
3 5 (38.46%) ETL
3 5 (38.46%) IBM
3 5 (38.46%) Data Warehouse
3 5 (38.46%) XML
3 5 (38.46%) SQL
3 5 (38.46%) T-SQL
3 5 (38.46%) SQL Server
3 5 (38.46%) ERwin
4 4 (30.77%) Back Office
4 4 (30.77%) XML Schema
4 4 (30.77%) Star Schema
4 4 (30.77%) Metadata Management
4 4 (30.77%) Cash Management
4 4 (30.77%) Data Integration
4 4 (30.77%) Banking
4 4 (30.77%) Data Management
4 4 (30.77%) General Ledger

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