Period
to 22 July 2018

The following table provides summary statistics for permanent job vacancies with a requirement for ANSI SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited ANSI SQL over the 6 months to 22 July 2018 with a comparison to the same period in the previous 2 years.

ANSI SQL
UK
6 months to
22 Jul 2018
Same period 2017 Same period 2016
Rank 1140 1175 1237
Rank change year-on-year +35 +62 +37
Permanent jobs citing ANSI SQL 27 29 46
As % of all permanent IT jobs advertised in the UK 0.016% 0.016% 0.023%
As % of the Programming Languages category 0.028% 0.029% 0.043%
Number of salaries quoted 22 22 41
UK median annual salary £65,000 £31,500 £50,000
Median salary % change year-on-year +106.35% -37.00% +17.65%
10th Percentile £41,575 £27,675 £42,500
90th Percentile £74,750 £89,000 £60,000
UK excluding London median annual salary £52,500 £30,500 £46,250
% change year-on-year +72.13% -34.05% +12.80%

ANSI SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies with a requirement for coding skills.

All Programming Languages
UK
Permanent vacancies with a requirement for coding skills 96,936 99,071 105,972
As % of all permanent IT jobs advertised in the UK 55.90% 55.44% 52.35%
Number of salaries quoted 80,564 82,705 91,646
UK median annual salary £50,000 £47,500 £47,500
Median salary % change year-on-year +5.26% - +5.56%
10th Percentile £30,500 £28,750 £28,250
90th Percentile £80,000 £77,500 £75,000
UK excluding London median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

ANSI SQL
Job Vacancy Trend

Job postings citing ANSI SQL as a percentage of all IT jobs advertised.

Job vacancy trend for ANSI SQL in the UK

ANSI SQL
Salary Trend

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing ANSI SQL.

Salary trend for ANSI SQL in the UK

ANSI SQL
Salary Histogram

The salary distribution of IT jobs citing ANSI SQL over the 6 months to 22 July 2018.

Salary histogram for ANSI SQL in the UK

ANSI SQL
Top 10 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing ANSI SQL within the UK over the 6 months to 22 July 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
England +32 26 £70,000 +122.22%
London +22 16 £70,000 -22.22%
UK excluding London -10 11 £52,500 +72.13%
South East +3 4 £52,500 +14.75%
East of England +11 3 £60,000 +118.18%
Yorkshire +23 2 £36,400 -
North of England -11 2 £36,400 +19.34%
Scotland - 1 £55,000 -
Midlands - 1 - -
West Midlands - 1 - -

For the 6 months to 22 July 2018, IT jobs citing ANSI SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for ANSI SQL.

1 27 (100.00%) SQL
2 23 (85.19%) SQL Server
3 18 (66.67%) Java
4 16 (59.26%) Unix
4 16 (59.26%) Finance
4 16 (59.26%) Agile Software Development
5 15 (55.56%) Hibernate
5 15 (55.56%) OO
6 14 (51.85%) SOA
6 14 (51.85%) Windows
6 14 (51.85%) Retail
6 14 (51.85%) Relational Database
7 13 (48.15%) OOA/OOD
8 12 (44.44%) Data Modelling
8 12 (44.44%) OOD
9 11 (40.74%) Web Services
9 11 (40.74%) Windows Server
9 11 (40.74%) Git (software)
9 11 (40.74%) Release Management
10 10 (37.04%) Fintech
10 10 (37.04%) Problem-Solving
10 10 (37.04%) Oracle
10 10 (37.04%) JBoss
10 10 (37.04%) JavaScript
10 10 (37.04%) Shell Script
10 10 (37.04%) WebSphere
10 10 (37.04%) Java EE
11 9 (33.33%) JSON
11 9 (33.33%) FIX Protocol
11 9 (33.33%) Zachman Framework

ANSI SQL
Co-occurring IT Skills 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:

Application Platforms
1 10 (37.04%) JBoss
1 10 (37.04%) WebSphere
2 9 (33.33%) Elasticsearch
2 9 (33.33%) WebLogic
3 4 (14.81%) Oracle SOA Suite
4 1 (3.70%) Tomcat
Applications
1 4 (14.81%) Microsoft Excel
1 4 (14.81%) Microsoft Office
1 4 (14.81%) MS Visio
Cloud Services
1 3 (11.11%) Amazon AWS
1 3 (11.11%) Amazon CloudWatch
1 3 (11.11%) Datadog
1 3 (11.11%) Google Cloud Platform
1 3 (11.11%) Microsoft Azure
1 3 (11.11%) Stackdriver
Communications & Networking
1 8 (29.63%) AMQP
Database & Business Intelligence
1 23 (85.19%) SQL Server
2 14 (51.85%) Relational Database
3 9 (33.33%) MongoDB
3 9 (33.33%) RDBMS
4 5 (18.52%) BusinessObjects
4 5 (18.52%) Oracle Database
4 5 (18.52%) SQL Server 2000
5 4 (14.81%) Oracle Database 10g
6 3 (11.11%) Amazon DynamoDB
6 3 (11.11%) Apache Cassandra
6 3 (11.11%) BusinessObjects Web Intelligence
6 3 (11.11%) BusinessObjects XI
6 3 (11.11%) Cosmos DB
6 3 (11.11%) CouchDB
6 3 (11.11%) Data Warehouse
6 3 (11.11%) MySQL
6 3 (11.11%) NoSQL
6 3 (11.11%) PostgreSQL
6 3 (11.11%) Redis
7 2 (7.41%) SAP Data Services
Development Applications
1 11 (40.74%) Git (software)
2 8 (29.63%) Atlassian Bamboo
2 8 (29.63%) Bitbucket
2 8 (29.63%) Maven
2 8 (29.63%) Subversion
3 5 (18.52%) Microsoft Blend
3 5 (18.52%) Visual Studio
3 5 (18.52%) VSS/SourceSafe
4 3 (11.11%) Jenkins
4 3 (11.11%) Octopus Deploy
4 3 (11.11%) TeamCity
5 1 (3.70%) Moq
5 1 (3.70%) Visual Studio Team System
General
1 16 (59.26%) Finance
2 14 (51.85%) Retail
3 6 (22.22%) Banking
3 6 (22.22%) Investment Banking
4 1 (3.70%) Financial Institution
4 1 (3.70%) Legal
4 1 (3.70%) Marketing
Job Titles
1 15 (55.56%) Analyst
2 12 (44.44%) Systems Analyst
3 9 (33.33%) Developer
4 8 (29.63%) Senior Analyst
4 8 (29.63%) Senior Support Analyst
4 8 (29.63%) Senior Systems Analyst
4 8 (29.63%) Systems Support
4 8 (29.63%) Systems Support Analyst
5 7 (25.93%) Software Analyst
6 6 (22.22%) Development Analyst
6 6 (22.22%) Development Support Analyst
6 6 (22.22%) Senior Development Analyst
6 6 (22.22%) Software Development Analyst
6 6 (22.22%) Software Support Analyst
6 6 (22.22%) Systems Development Analyst
7 5 (18.52%) .NET Developer
7 5 (18.52%) .NET Team Leader
7 5 (18.52%) Lead Developer
7 5 (18.52%) SQL Analyst
7 5 (18.52%) Team Leader
Libraries, Frameworks & Software Standards
1 15 (55.56%) Hibernate
2 11 (40.74%) Web Services
3 10 (37.04%) Java EE
4 9 (33.33%) .NET
4 9 (33.33%) FIX Protocol
4 9 (33.33%) HTML
4 9 (33.33%) J2EE
4 9 (33.33%) JSON
4 9 (33.33%) REST
4 9 (33.33%) SOAP
4 9 (33.33%) Spring
4 9 (33.33%) XML
5 8 (29.63%) .NET Framework
5 8 (29.63%) AngularJS
5 8 (29.63%) Ember.js
5 8 (29.63%) HTML5
5 8 (29.63%) RabbitMQ
5 8 (29.63%) React
5 8 (29.63%) Spring Boot
5 8 (29.63%) Spring Security
Miscellaneous
1 10 (37.04%) Fintech
2 6 (22.22%) Analytical Skills
3 3 (11.11%) Computer Science
3 3 (11.11%) Greenfield Project
4 2 (7.41%) Management Information System
4 2 (7.41%) N-Tier
4 2 (7.41%) Online Banking
5 1 (3.70%) LIMS
Operating Systems
1 16 (59.26%) Unix
2 14 (51.85%) Windows
3 11 (40.74%) Windows Server
4 2 (7.41%) Linux
Processes & Methodologies
1 16 (59.26%) Agile Software Development
2 15 (55.56%) OO
3 14 (51.85%) SOA
4 13 (48.15%) OOA/OOD
5 12 (44.44%) Data Modelling
5 12 (44.44%) OOD
6 11 (40.74%) Release Management
7 10 (37.04%) Problem-Solving
8 9 (33.33%) Presales
8 9 (33.33%) TOGAF
8 9 (33.33%) Zachman Framework
9 6 (22.22%) ETL
9 6 (22.22%) Wealth Management
10 5 (18.52%) Mentoring
10 5 (18.52%) Performance Tuning
10 5 (18.52%) TDD
10 5 (18.52%) UML
11 4 (14.81%) Microservices
11 4 (14.81%) Scrum
11 4 (14.81%) Software Engineering
Programming Languages
1 27 (100.00%) SQL
2 18 (66.67%) Java
3 10 (37.04%) JavaScript
3 10 (37.04%) Shell Script
4 9 (33.33%) C#
5 5 (18.52%) PL/SQL
5 5 (18.52%) T-SQL
5 5 (18.52%) VB
5 5 (18.52%) VB.NET
5 5 (18.52%) VB6
5 5 (18.52%) XAML
6 3 (11.11%) C
6 3 (11.11%) Java 8
6 3 (11.11%) Perl
6 3 (11.11%) Python
7 2 (7.41%) Bash Shell
7 2 (7.41%) PowerShell
Qualifications
1 1 (3.70%) SC Cleared
1 1 (3.70%) Security Cleared
Quality Assurance & Compliance
1 3 (11.11%) GCP
2 1 (3.70%) PMO
System Software
1 3 (11.11%) Docker
Systems Management
1 3 (11.11%) Kubernetes
1 3 (11.11%) logstash
1 3 (11.11%) Terraform
2 2 (7.41%) Control-M
Vendors
1 10 (37.04%) Oracle
2 8 (29.63%) Microsoft
3 4 (14.81%) Sybase
4 3 (11.11%) Google
4 3 (11.11%) IBM
4 3 (11.11%) Informatica
4 3 (11.11%) New Relic
5 2 (7.41%) SAP
6 1 (3.70%) Capita