Period
to 19 April 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 19 April 2018 with a comparison to the same period in the previous 2 years.

ANSI SQL
UK
6 months to
19 Apr 2018
Same period 2017 Same period 2016
Rank 1181 1138 1231
Rank change year-on-year -43 +93 +39
Permanent jobs citing ANSI SQL 14 43 59
As % of all permanent IT jobs advertised in the UK 0.008% 0.025% 0.029%
As % of the Programming Languages category 0.014% 0.046% 0.055%
Number of salaries quoted 14 36 55
UK median annual salary £52,500 £30,500 £47,500
Median salary % change year-on-year +72.13% -35.79% +11.76%
10th Percentile £36,090 £29,250 £41,250
90th Percentile £74,250 £90,000 £58,750
UK excluding London median annual salary £52,500 £30,500 £45,000
% change year-on-year +72.13% -32.22% +16.13%

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 99,433 93,828 106,577
As % of all permanent IT jobs advertised in the UK 56.08% 54.55% 52.00%
Number of salaries quoted 83,625 80,109 91,971
UK median annual salary £50,000 £47,500 £46,000
Median salary % change year-on-year +5.26% +3.26% +2.22%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £78,750 £76,250 £75,000
UK excluding London median annual salary £44,000 £42,500 £40,000
% change year-on-year +3.53% +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 19 April 2018.

Salary histogram for ANSI SQL in the UK

ANSI SQL
Top 6 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 19 April 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 -12 14 £52,500 +72.13% 2
London +12 7 £70,000 -24.32% 2
UK excluding London -51 7 £52,500 +72.13%
South East -27 5 £52,500 +16.67%
Yorkshire +15 2 £36,400 -9.00%
North of England -18 2 £36,400 +19.34%

For the 6 months to 19 April 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 14 (100.00%) SQL
1 14 (100.00%) SQL Server
2 10 (71.43%) OOA/OOD
2 10 (71.43%) SOA
3 9 (64.29%) Agile Software Development
3 9 (64.29%) Relational Database
4 7 (50.00%) Problem-Solving
4 7 (50.00%) .NET Framework
4 7 (50.00%) Microsoft
4 7 (50.00%) Finance
4 7 (50.00%) Hibernate
4 7 (50.00%) OO
4 7 (50.00%) Web Services
4 7 (50.00%) Oracle
4 7 (50.00%) .NET
4 7 (50.00%) C#
4 7 (50.00%) Java
5 6 (42.86%) Retail
5 6 (42.86%) Git (software)
6 5 (35.71%) Microsoft Blend
6 5 (35.71%) JSON
6 5 (35.71%) FIX Protocol
6 5 (35.71%) WCF
6 5 (35.71%) WPF
6 5 (35.71%) Release Management
6 5 (35.71%) Spring
6 5 (35.71%) Java EE
6 5 (35.71%) WebSphere
6 5 (35.71%) VB6
6 5 (35.71%) XAML

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 5 (35.71%) Elasticsearch
1 5 (35.71%) JBoss
1 5 (35.71%) Oracle SOA Suite
1 5 (35.71%) WebLogic
1 5 (35.71%) WebSphere
Applications
1 5 (35.71%) Microsoft Excel
1 5 (35.71%) Microsoft Office
1 5 (35.71%) MS Visio
Cloud Services
1 2 (14.29%) Amazon AWS
1 2 (14.29%) Amazon CloudWatch
1 2 (14.29%) Datadog
1 2 (14.29%) Google Cloud Platform
1 2 (14.29%) Microsoft Azure
1 2 (14.29%) Stackdriver
Communications & Networking
1 4 (28.57%) AMQP
Database & Business Intelligence
1 14 (100.00%) SQL Server
2 9 (64.29%) Relational Database
3 5 (35.71%) MongoDB
3 5 (35.71%) Oracle Database
3 5 (35.71%) Oracle Database 10g
3 5 (35.71%) SQL Server 2000
4 4 (28.57%) RDBMS
5 2 (14.29%) Amazon DynamoDB
5 2 (14.29%) Apache Cassandra
5 2 (14.29%) BusinessObjects
5 2 (14.29%) Cosmos DB
5 2 (14.29%) CouchDB
5 2 (14.29%) MySQL
5 2 (14.29%) NoSQL
5 2 (14.29%) PostgreSQL
5 2 (14.29%) Redis
5 2 (14.29%) SAP Data Services
Development Applications
1 6 (42.86%) Git (software)
2 5 (35.71%) Microsoft Blend
2 5 (35.71%) Visual Studio
2 5 (35.71%) VSS/SourceSafe
3 4 (28.57%) Atlassian Bamboo
3 4 (28.57%) Bitbucket
3 4 (28.57%) Maven
3 4 (28.57%) Subversion
4 2 (14.29%) Jenkins
4 2 (14.29%) Octopus Deploy
4 2 (14.29%) TeamCity
General
1 7 (50.00%) Finance
2 6 (42.86%) Retail
3 2 (14.29%) Banking
3 2 (14.29%) Investment Banking
4 1 (7.14%) Legal
Job Titles
1 9 (64.29%) Developer
2 6 (42.86%) Lead Developer
3 5 (35.71%) .NET Developer
3 5 (35.71%) .NET Software Developer
3 5 (35.71%) .NET Team Leader
3 5 (35.71%) Analyst
3 5 (35.71%) C# .NET Developer
3 5 (35.71%) C# Developer
3 5 (35.71%) C# Software Developer
3 5 (35.71%) C# VB.NET Developer
3 5 (35.71%) Lead .NET Developer
3 5 (35.71%) Lead C# Developer
3 5 (35.71%) Lead Software Developer
3 5 (35.71%) Software Developer
3 5 (35.71%) Software Team Leader
3 5 (35.71%) Systems Analyst
3 5 (35.71%) Team Leader
3 5 (35.71%) VB.NET Developer
3 5 (35.71%) VB.NET Team Leader
4 4 (28.57%) Systems Support
Libraries, Frameworks & Software Standards
1 7 (50.00%) .NET
1 7 (50.00%) .NET Framework
1 7 (50.00%) Hibernate
1 7 (50.00%) Web Services
2 5 (35.71%) ADO
2 5 (35.71%) FIX Protocol
2 5 (35.71%) J2EE
2 5 (35.71%) Java EE
2 5 (35.71%) JSON
2 5 (35.71%) REST
2 5 (35.71%) SOAP
2 5 (35.71%) Spring
2 5 (35.71%) WCF
2 5 (35.71%) WinForms
2 5 (35.71%) WPF
2 5 (35.71%) XML
3 4 (28.57%) AngularJS
3 4 (28.57%) Ember.js
3 4 (28.57%) HTML
3 4 (28.57%) React
Miscellaneous
1 5 (35.71%) Fintech
2 2 (14.29%) Analytical Skills
2 2 (14.29%) Computer Science
2 2 (14.29%) Greenfield Project
2 2 (14.29%) Management Information System
3 1 (7.14%) N-Tier
3 1 (7.14%) Online Banking
Operating Systems
1 5 (35.71%) Unix
2 4 (28.57%) Windows
2 4 (28.57%) Windows Server
Processes & Methodologies
1 10 (71.43%) OOA/OOD
1 10 (71.43%) SOA
2 9 (64.29%) Agile Software Development
3 7 (50.00%) OO
3 7 (50.00%) Problem-Solving
4 5 (35.71%) Data Modelling
4 5 (35.71%) Mentoring
4 5 (35.71%) OOD
4 5 (35.71%) Presales
4 5 (35.71%) Release Management
4 5 (35.71%) UML
5 4 (28.57%) TOGAF
5 4 (28.57%) Zachman Framework
6 3 (21.43%) Data Conversion
6 3 (21.43%) Systems Analysis
6 3 (21.43%) Wealth Management
7 2 (14.29%) DevOps
7 2 (14.29%) Mathematics
7 2 (14.29%) Microservices
7 2 (14.29%) System Testing
Programming Languages
1 14 (100.00%) SQL
2 7 (50.00%) C#
2 7 (50.00%) Java
3 5 (35.71%) PL/SQL
3 5 (35.71%) Shell Script
3 5 (35.71%) T-SQL
3 5 (35.71%) VB
3 5 (35.71%) VB.NET
3 5 (35.71%) VB6
3 5 (35.71%) XAML
4 4 (28.57%) JavaScript
5 2 (14.29%) C
5 2 (14.29%) Java 8
5 2 (14.29%) Python
Quality Assurance & Compliance
1 2 (14.29%) GCP
System Software
1 2 (14.29%) Docker
Systems Management
1 2 (14.29%) Kubernetes
1 2 (14.29%) logstash
1 2 (14.29%) Terraform
Vendors
1 7 (50.00%) Microsoft
1 7 (50.00%) Oracle
2 2 (14.29%) Google
2 2 (14.29%) IBM
2 2 (14.29%) New Relic
2 2 (14.29%) SAP