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

ANSI SQL
UK
6 months to
20 Oct 2018
Same period 2017 Same period 2016
Rank 1104 1166 1198
Rank change year-on-year +62 +32 +105
Permanent jobs citing ANSI SQL 44 21 40
As % of all permanent IT jobs advertised in the UK 0.027% 0.012% 0.021%
As % of the Programming Languages category 0.048% 0.022% 0.040%
Number of salaries quoted 23 19 30
UK median annual salary £60,000 £37,500 £46,000
Median salary % change year-on-year +60.00% -18.48% +15.00%
10th Percentile £40,900 £27,500 £42,500
90th Percentile £72,500 £51,550 £115,000
UK excluding London median annual salary £60,000 £37,500 £45,000
% change year-on-year +60.00% -16.67% +12.50%

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 90,813 96,397 100,753
As % of all permanent IT jobs advertised in the UK 55.55% 55.28% 52.77%
Number of salaries quoted 75,559 79,020 86,880
UK median annual salary £50,000 £48,500 £47,500
Median salary % change year-on-year +3.09% +2.11% +5.56%
10th Percentile £31,250 £29,000 £28,500
90th Percentile £82,500 £77,500 £76,250
UK excluding London median annual salary £45,000 £42,500 £41,000
% change year-on-year +5.88% +3.66% +2.50%

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 20 October 2018.

Salary histogram for ANSI SQL in the UK

ANSI SQL
Top 9 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 20 October 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 +43 43 £60,000 +60.00% 15
London - 23 £70,000 - 4
UK excluding London +17 21 £60,000 +60.00% 11
South West - 9 £50,000 - 5
East of England +23 8 £60,000 +118.18% 1
South East +1 2 £45,000 -1.64% 5
Scotland - 1 £55,000 -
West Midlands - 1 - -
Midlands - 1 - -

For the 6 months to 20 October 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 44 (100.00%) SQL
2 38 (86.36%) SQL Server
3 32 (72.73%) JavaScript
4 26 (59.09%) HTML
5 23 (52.27%) Java
5 23 (52.27%) Unix
5 23 (52.27%) Windows
6 22 (50.00%) Finance
6 22 (50.00%) Agile Software Development
7 20 (45.45%) C#
8 19 (43.18%) .NET
9 18 (40.91%) OO
9 18 (40.91%) CSS
9 18 (40.91%) Hibernate
9 18 (40.91%) MVC
9 18 (40.91%) ASP.NET Web API
10 17 (38.64%) Windows Server
10 17 (38.64%) Retail
11 16 (36.36%) Data Modelling
11 16 (36.36%) OOD
11 16 (36.36%) Relational Database
12 15 (34.09%) RDBMS
12 15 (34.09%) Shell Script
12 15 (34.09%) JBoss
12 15 (34.09%) Java EE
13 14 (31.82%) WebSphere
13 14 (31.82%) Zachman Framework
13 14 (31.82%) TOGAF
13 14 (31.82%) SC Cleared
13 14 (31.82%) Security Cleared

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 15 (34.09%) JBoss
2 14 (31.82%) WebSphere
3 9 (20.45%) WebLogic
4 8 (18.18%) Elasticsearch
5 6 (13.64%) Tomcat
6 1 (2.27%) Oracle 10gAS
6 1 (2.27%) Oracle Application Server
6 1 (2.27%) Oracle Workflow
Cloud Services
1 2 (4.55%) Amazon AWS
1 2 (4.55%) Google Cloud Platform
1 2 (4.55%) Microsoft Azure
2 1 (2.27%) Amazon CloudWatch
2 1 (2.27%) Datadog
2 1 (2.27%) Stackdriver
Communications & Networking
1 8 (18.18%) AMQP
Database & Business Intelligence
1 38 (86.36%) SQL Server
2 16 (36.36%) Relational Database
3 15 (34.09%) RDBMS
4 8 (18.18%) MongoDB
5 6 (13.64%) SQL Server 2012
5 6 (13.64%) SQL Server 2014
6 5 (11.36%) Data Warehouse
7 4 (9.09%) BusinessObjects
7 4 (9.09%) BusinessObjects Web Intelligence
7 4 (9.09%) BusinessObjects XI
7 4 (9.09%) Crystal Reports
7 4 (9.09%) Oracle Reports
8 3 (6.82%) MySQL
8 3 (6.82%) Oracle Database
9 2 (4.55%) Amazon DynamoDB
9 2 (4.55%) Apache Cassandra
9 2 (4.55%) Oracle Database 10g
9 2 (4.55%) Oracle Database 11g
9 2 (4.55%) PostgreSQL
9 2 (4.55%) Redis
Development Applications
1 10 (22.73%) Git (software)
2 8 (18.18%) Atlassian Bamboo
2 8 (18.18%) Bitbucket
2 8 (18.18%) Maven
2 8 (18.18%) Subversion
3 2 (4.55%) Jenkins
3 2 (4.55%) Octopus Deploy
3 2 (4.55%) TeamCity
4 1 (2.27%) ClearCase
4 1 (2.27%) Microsoft Blend
4 1 (2.27%) Moq
4 1 (2.27%) Oracle APEX
4 1 (2.27%) Oracle Forms
4 1 (2.27%) SQL Server Management Studio (SSMS)
4 1 (2.27%) Visual Studio
4 1 (2.27%) Visual Studio Team System
4 1 (2.27%) VSS/SourceSafe
General
1 22 (50.00%) Finance
2 17 (38.64%) Retail
3 7 (15.91%) Banking
4 6 (13.64%) Investment Banking
5 3 (6.82%) Local Government
6 1 (2.27%) Financial Institution
6 1 (2.27%) Marketing
6 1 (2.27%) Publishing
Job Titles
1 21 (47.73%) Analyst
2 19 (43.18%) Developer
3 16 (36.36%) .NET Developer
3 16 (36.36%) Systems Analyst
4 10 (22.73%) SQL Analyst
5 8 (18.18%) Development Analyst
5 8 (18.18%) Development Support Analyst
5 8 (18.18%) Senior Analyst
5 8 (18.18%) Senior Development Analyst
5 8 (18.18%) Senior Support Analyst
5 8 (18.18%) Senior Systems Analyst
5 8 (18.18%) Software Analyst
5 8 (18.18%) Software Development Analyst
5 8 (18.18%) Software Support Analyst
5 8 (18.18%) Systems Development Analyst
5 8 (18.18%) Systems Support
5 8 (18.18%) Systems Support Analyst
6 6 (13.64%) C# .NET Developer
6 6 (13.64%) C# Developer
7 4 (9.09%) Support Analyst
Libraries, Frameworks & Software Standards
1 26 (59.09%) HTML
2 19 (43.18%) .NET
3 18 (40.91%) ASP.NET Web API
3 18 (40.91%) CSS
3 18 (40.91%) Hibernate
4 15 (34.09%) Java EE
5 10 (22.73%) AngularJS
6 8 (18.18%) Ember.js
6 8 (18.18%) FIX Protocol
6 8 (18.18%) HTML5
6 8 (18.18%) JSON
6 8 (18.18%) RabbitMQ
6 8 (18.18%) React
6 8 (18.18%) REST
6 8 (18.18%) SOAP
6 8 (18.18%) Spring
6 8 (18.18%) Spring Boot
6 8 (18.18%) Spring Security
6 8 (18.18%) Web Services
6 8 (18.18%) XML
Miscellaneous
1 14 (31.82%) Fintech
2 11 (25.00%) Analytical Skills
3 2 (4.55%) Computer Science
3 2 (4.55%) Greenfield Project
4 1 (2.27%) LIMS
4 1 (2.27%) N-Tier
4 1 (2.27%) Online Banking
Operating Systems
1 23 (52.27%) Unix
1 23 (52.27%) Windows
2 17 (38.64%) Windows Server
3 12 (27.27%) Linux
Processes & Methodologies
1 22 (50.00%) Agile Software Development
2 18 (40.91%) MVC
2 18 (40.91%) OO
3 16 (36.36%) Data Modelling
3 16 (36.36%) OOD
4 14 (31.82%) TOGAF
4 14 (31.82%) Zachman Framework
5 12 (27.27%) Performance Tuning
6 11 (25.00%) Problem-Solving
7 10 (22.73%) Release Management
8 9 (20.45%) SOA
8 9 (20.45%) TDD
9 8 (18.18%) OOA/OOD
9 8 (18.18%) Performance Improvement
9 8 (18.18%) Presales
9 8 (18.18%) Wealth Management
10 7 (15.91%) SDLC
11 6 (13.64%) ETL
11 6 (13.64%) UML
11 6 (13.64%) Web Application Development
Programming Languages
1 44 (100.00%) SQL
2 32 (72.73%) JavaScript
3 23 (52.27%) Java
4 20 (45.45%) C#
5 15 (34.09%) Shell Script
6 5 (11.36%) Perl
7 3 (6.82%) Bash Shell
7 3 (6.82%) PowerShell
8 2 (4.55%) C
8 2 (4.55%) Python
9 1 (2.27%) Java 8
9 1 (2.27%) PL/SQL
9 1 (2.27%) T-SQL
9 1 (2.27%) VB
9 1 (2.27%) VB.NET
9 1 (2.27%) VB6
9 1 (2.27%) XAML
Qualifications
1 14 (31.82%) SC Cleared
1 14 (31.82%) Security Cleared
2 1 (2.27%) Degree
Quality Assurance & Compliance
1 1 (2.27%) PMO
System Software
1 2 (4.55%) Docker
2 1 (2.27%) VMware Infrastructure
Systems Management
1 4 (9.09%) Control-M
2 2 (4.55%) Kubernetes
2 2 (4.55%) Terraform
3 1 (2.27%) logstash
3 1 (2.27%) Oracle RMAN
Vendors
1 11 (25.00%) Sybase
2 8 (18.18%) Oracle
3 5 (11.36%) Informatica
4 4 (9.09%) Civica
4 4 (9.09%) Microsoft
5 2 (4.55%) Google
5 2 (4.55%) IBM
6 1 (2.27%) New Relic
6 1 (2.27%) Remedy
6 1 (2.27%) VMware