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

3 months to
23 Jan 2017
Same period 2016 Same period 2015
Online Transaction Processing (OLTP)
West Sussex / Crawley
Rank 51 57 -
Rank change year-on-year
+6 -
Permanent jobs citing OLTP 2 1 0
As % of all permanent IT jobs located in Crawley 0.51% 0.29% -
As % of the Database & Business Intelligence category 2.00% 0.67% -
Number of salaries quoted 2 1 0
Median salary £44,500 £40,000 -
Median salary % change year-on-year
+11.25% -
UK excluding London median salary £52,500 £47,500 £42,500
% change year-on-year
+10.52% +11.76%

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

Database & Business Intelligence Category
Crawley
Permanent IT job ads with a match in the
Database & Business Intelligence category
100 150 145
As % of all permanent IT jobs located in Crawley 25.32% 44.12% 35.11%
Number of salaries quoted 92 149 128
Median salary £50,000 £50,000 £42,500
Median salary % change year-on-year
- +17.64%
90% offered a salary of more than £40,000 £27,500 £26,500
10% offered a salary of more than £65,000 £62,500 £52,500
UK excluding London median salary £43,000 £42,500 £40,000
% change year-on-year
+1.17% +6.25%

OLTP
Jobs Demand Trend in Crawley

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

OLTP Jobs Demand Trend in Crawley

OLTP
Salary Trend in Crawley

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

OLTP Salary Trend in Crawley

OLTP
Salary Histogram in Crawley

This chart provides a salary histogram for IT jobs citing OLTP across the Crawley region over the 3 months to 23 January 2017.

OLTP Salary Histogram in Crawley

OLTP
Top 30 Related IT Skills in Crawley

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

1 4 (100.00%) SQL
1 4 (100.00%) OLAP
2 3 (75.00%) SQL Server
2 3 (75.00%) Business Intelligence
3 2 (50.00%) Microsoft
3 2 (50.00%) Advertising
3 2 (50.00%) MySQL
3 2 (50.00%) Oracle
3 2 (50.00%) CRM
3 2 (50.00%) Cognos
3 2 (50.00%) Scrum
3 2 (50.00%) Agile Software Development
3 2 (50.00%) SQL Server Reporting Services
3 2 (50.00%) SQL Server Integration Services
3 2 (50.00%) Oracle OLAP
3 2 (50.00%) SQL Server Analysis Services
3 2 (50.00%) Kanban
3 2 (50.00%) NoSQL
3 2 (50.00%) Big Data
3 2 (50.00%) Power BI
3 2 (50.00%) Kimball Methodology
3 2 (50.00%) ETL
4 1 (25.00%) Performance Tuning
4 1 (25.00%) Relational Database
4 1 (25.00%) Decision Quality
4 1 (25.00%) Talend
4 1 (25.00%) SQL Server 2012
4 1 (25.00%) Data Quality
4 1 (25.00%) Talend Open Studio
4 1 (25.00%) FastStats

OLTP
Top Related IT Skills in Crawley 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:

Business Applications
1 1 (25.00%) Dynamics CRM
1 1 (25.00%) Dynamics NAV
1 1 (25.00%) FastStats
Database & Business Intelligence
1 4 (100.00%) OLAP
2 3 (75.00%) SQL Server
3 2 (50.00%) Big Data
3 2 (50.00%) MySQL
3 2 (50.00%) NoSQL
3 2 (50.00%) Oracle OLAP
3 2 (50.00%) Power BI
3 2 (50.00%) SQL Server Analysis Services
3 2 (50.00%) SQL Server Integration Services
3 2 (50.00%) SQL Server Reporting Services
4 1 (25.00%) BusinessObjects
4 1 (25.00%) BusinessObjects XI
4 1 (25.00%) Data Warehouse
4 1 (25.00%) Hadoop
4 1 (25.00%) Oracle Reports
4 1 (25.00%) RDBMS
4 1 (25.00%) Relational Database
4 1 (25.00%) SQL Server 2012
Development Applications
1 1 (25.00%) JIRA
1 1 (25.00%) Talend Open Studio
General
1 2 (50.00%) Advertising
Job Titles
1 2 (50.00%) Analyst
2 1 (25.00%) Business Intelligence Analyst
2 1 (25.00%) Business Intelligence Lead
2 1 (25.00%) Project Leader
2 1 (25.00%) Report Analyst
2 1 (25.00%) SQL Analyst
2 1 (25.00%) SSIS Analyst
2 1 (25.00%) SSRS Analyst
Processes & Methodologies
1 3 (75.00%) Business Intelligence
2 2 (50.00%) Agile Software Development
2 2 (50.00%) CRM
2 2 (50.00%) ETL
2 2 (50.00%) Kanban
2 2 (50.00%) Kimball Methodology
2 2 (50.00%) Scrum
3 1 (25.00%) Decision Quality
3 1 (25.00%) Performance Tuning
3 1 (25.00%) Stakeholder Management
3 1 (25.00%) Time Management
Programming Languages
1 4 (100.00%) SQL
2 1 (25.00%) PL/SQL
Quality Assurance & Compliance
1 1 (25.00%) Data Quality
Vendors
1 2 (50.00%) Cognos
1 2 (50.00%) Microsoft
1 2 (50.00%) Oracle
2 1 (25.00%) Informatica
2 1 (25.00%) Talend