The table below looks at the statistics for OLTP skills in IT jobs advertised for the City of London region. Included is a guide to the salaries offered in IT jobs that have cited OLTP over the 3 months to 29 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 May 2016
Same period 2015 Same period 2014
Online Transaction Processing (OLTP)
Rank 241 307 335
Rank change year-on-year
+66 +28
Permanent jobs citing OLTP 17 14 26
As % of all permanent IT jobs located in the City of London 0.26% 0.14% 0.20%
As % of the Database & Business Intelligence category 0.98% 0.45% 0.66%
Number of salaries quoted 17 14 16
Median salary £62,500 £62,500 £59,000
Median salary % change year-on-year
- +5.93%
90% offered a salary of more than £53,000 £46,500 £42,500
10% offered a salary of more than £85,000 £71,300 £62,500
UK excluding London median salary £47,500 £45,000 £48,750
% change year-on-year
+5.55% -7.69%
OLTP
London

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 City of London region.

Database & Business Intelligence Category
City of London
Permanent IT job ads with a match in the
Database & Business Intelligence category
1742 3099 3965
As % of all permanent IT jobs located in the City of London 26.69% 30.10% 30.80%
Number of salaries quoted 1583 2703 3465
Median salary £55,000 £57,500 £52,500
Median salary % change year-on-year
-4.34% +9.52%
90% offered a salary of more than £40,000 £39,500 £37,500
10% offered a salary of more than £77,500 £77,500 £75,000
UK excluding London median salary £42,500 £41,500 £40,000
% change year-on-year
+2.40% +3.75%

OLTP
Jobs Demand Trend in the City of London

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

OLTP Jobs Demand Trend in the City of London

OLTP
Salary Trend in the City of London

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

OLTP Salary Trend in the City of London

OLTP
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing OLTP across the City of London region over the 3 months to 29 May 2016.

OLTP Salary Histogram in the City of London

OLTP
Top 30 Related IT Skills in the City of London

For the 6 months to 29 May 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 City of London region with a requirement for OLTP.

1 25 (86.21%) OLAP
2 24 (82.76%) Business Intelligence
3 23 (79.31%) SQL Server Integration Services
4 21 (72.41%) SQL Server
5 18 (62.07%) SQL Server Reporting Services
6 17 (58.62%) ETL
7 16 (55.17%) Data Modelling
8 15 (51.72%) Microsoft
8 15 (51.72%) MS Excel
8 15 (51.72%) SQL Server Analysis Services
9 14 (48.28%) Analytics
10 13 (44.83%) MDX
10 13 (44.83%) Finance
11 12 (41.38%) SQL
12 11 (37.93%) Retail
12 11 (37.93%) Marketing
12 11 (37.93%) Marketing Analytics
13 10 (34.48%) Statistical Analysis
13 10 (34.48%) Microsoft Azure
13 10 (34.48%) Open Source
13 10 (34.48%) C#
13 10 (34.48%) .NET
13 10 (34.48%) E-Commerce
14 9 (31.03%) Agile Software Development
14 9 (31.03%) SDLC
15 8 (27.59%) Data Warehouse
16 7 (24.14%) T-SQL
16 7 (24.14%) Data Integration
16 7 (24.14%) SQL Server 2008
17 6 (20.69%) Dimensional Modelling

OLTP
Top Related IT Skills in the City of London 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 15 (51.72%) MS Excel
2 1 (3.45%) MS PowerPoint
2 1 (3.45%) Spreadsheet
Business Applications
1 4 (13.79%) Cognos Business Intelligence
2 1 (3.45%) MetaTrader
Cloud Services
1 10 (34.48%) Microsoft Azure
Database & Business Intelligence
1 25 (86.21%) OLAP
2 23 (79.31%) SQL Server Integration Services
3 21 (72.41%) SQL Server
4 18 (62.07%) SQL Server Reporting Services
5 15 (51.72%) SQL Server Analysis Services
6 8 (27.59%) Data Warehouse
7 7 (24.14%) SQL Server 2008
8 4 (13.79%) Microsoft Analysis Services
8 4 (13.79%) PowerPivot
8 4 (13.79%) Relational Database
9 3 (10.34%) Big Data
9 3 (10.34%) BusinessObjects
9 3 (10.34%) Cognos Event Studio
9 3 (10.34%) Cognos Metric Studio
9 3 (10.34%) Data Mining
9 3 (10.34%) DataStage
9 3 (10.34%) DB2
9 3 (10.34%) MS Access
9 3 (10.34%) Oracle ODI
9 3 (10.34%) SQL Server 2012
Development Applications
1 4 (13.79%) Team Foundation Server
2 1 (3.45%) Subversion
2 1 (3.45%) Visual Studio
General
1 13 (44.83%) Finance
2 11 (37.93%) Marketing
2 11 (37.93%) Retail
3 3 (10.34%) Back Office
3 3 (10.34%) Banking
3 3 (10.34%) Legal
4 2 (6.90%) Financial Institution
5 1 (3.45%) Advertising
Job Titles
1 23 (79.31%) Developer
2 13 (44.83%) SSAS Developer
2 13 (44.83%) SSIS Developer
2 13 (44.83%) SSRS Developer
3 10 (34.48%) Azure Developer
3 10 (34.48%) Business Intelligence Developer
3 10 (34.48%) Database Developer
3 10 (34.48%) Marketing Database Developer
3 10 (34.48%) Senior Database Developer
3 10 (34.48%) Senior Developer
4 4 (13.79%) Business Intelligence Lead
4 4 (13.79%) Cognos BI Developer
4 4 (13.79%) Cognos Developer
4 4 (13.79%) Lead Developer
5 3 (10.34%) DBA
5 3 (10.34%) Head of Business Intelligence
5 3 (10.34%) OLAP Developer
5 3 (10.34%) SQL Developer
6 2 (6.90%) SQL DBA
6 2 (6.90%) Team Leader
Libraries, Frameworks & Software Standards
1 13 (44.83%) MDX
2 10 (34.48%) .NET
3 3 (10.34%) ODBC
4 2 (6.90%) Django
Miscellaneous
1 7 (24.14%) Data Integration
2 3 (10.34%) Analytical Skills
3 2 (6.90%) Blackberry
3 2 (6.90%) Data Structures
4 1 (3.45%) Computer Science
4 1 (3.45%) Contract for Difference
4 1 (3.45%) Economics
4 1 (3.45%) Mathematics
4 1 (3.45%) Spread Betting
Processes & Methodologies
1 24 (82.76%) Business Intelligence
2 17 (58.62%) ETL
3 16 (55.17%) Data Modelling
4 14 (48.28%) Analytics
5 11 (37.93%) Marketing Analytics
6 10 (34.48%) E-Commerce
6 10 (34.48%) Open Source
6 10 (34.48%) Statistical Analysis
7 9 (31.03%) Agile Software Development
7 9 (31.03%) SDLC
8 6 (20.69%) Dimensional Modelling
9 4 (13.79%) Business Analytics
9 4 (13.79%) Data Analytics
9 4 (13.79%) Mentoring
10 3 (10.34%) Data Architecture
10 3 (10.34%) Data Governance
10 3 (10.34%) Kimball Methodology
10 3 (10.34%) Performance Management
10 3 (10.34%) User Acceptance Testing
10 3 (10.34%) Waterfall
Programming Languages
1 12 (41.38%) SQL
2 10 (34.48%) C#
3 7 (24.14%) T-SQL
4 3 (10.34%) Data Analysis Expressions (DAX)
5 2 (6.90%) JavaScript
5 2 (6.90%) Python
6 1 (3.45%) C
Qualifications
1 3 (10.34%) Degree
1 3 (10.34%) IBM Certification
2 1 (3.45%) MBA
Quality Assurance & Compliance
1 3 (10.34%) QA
2 2 (6.90%) Data Quality
3 1 (3.45%) SLA
Vendors
1 15 (51.72%) Microsoft
2 6 (20.69%) IBM
3 5 (17.24%) Tableau
4 4 (13.79%) Cognos
5 3 (10.34%) Alteryx
5 3 (10.34%) Informatica
5 3 (10.34%) Oracle
5 3 (10.34%) SAP
5 3 (10.34%) Sybase