Period
to 19 January 2019

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

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
19 Jan 2019
Same period 2018 Same period 2017
Rank 3 5 12
Rank change year-on-year +2 +7 -5
Permanent jobs citing SQL 30 19 6
As % of all permanent IT jobs advertised in Livingston 30.61% 28.36% 11.11%
As % of the Programming Languages category 52.63% 39.58% 17.14%
Number of salaries quoted 16 13 6
Livingston median annual salary £42,500 £40,000 £34,500
Median salary % change year-on-year +6.25% +15.94% -1.43%
10th Percentile £36,250 £32,500 £25,250
90th Percentile £57,500 £45,000 £41,875
West Lothian median annual salary £42,500 £40,000 £36,250
% change year-on-year +6.25% +10.34% -3.33%

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 advertised in Livingston with a requirement for coding skills.

All Programming Languages
Livingston
Permanent vacancies with a requirement for coding skills 57 48 35
As % of all permanent IT jobs advertised in Livingston 58.16% 71.64% 64.81%
Number of salaries quoted 35 31 33
Livingston median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - +11.11%
10th Percentile £32,500 £29,250 £29,000
90th Percentile £54,950 £50,000 £47,500
West Lothian median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - -

SQL
Job Vacancy Trend in Livingston

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

Job vacancy trend for SQL in Livingston

SQL
Salary Trend in Livingston

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

Salary trend for SQL in Livingston

SQL
Salary Histogram in Livingston

The salary distribution of IT jobs citing SQL in Livingston over the 6 months to 19 January 2019.

Salary histogram for SQL in Livingston

For the 6 months to 19 January 2019, IT jobs citing 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 across the Livingston region with a requirement for SQL.

1 22 (73.33%) Oracle
2 21 (70.00%) PL/SQL
3 19 (63.33%) C#
4 18 (60.00%) Degree
5 17 (56.67%) Agile Software Development
5 17 (56.67%) Test Automation
5 17 (56.67%) Java
5 17 (56.67%) JavaScript
6 16 (53.33%) Software Engineering
6 16 (53.33%) Computer Science
7 15 (50.00%) Python
8 14 (46.67%) C
8 14 (46.67%) C++
8 14 (46.67%) Shell Script
8 14 (46.67%) Management Information System
8 14 (46.67%) Scrum
8 14 (46.67%) Kanban
8 14 (46.67%) Microservices
8 14 (46.67%) Scenario Testing
9 13 (43.33%) AngularJS
9 13 (43.33%) JSON
10 11 (36.67%) Refactoring
10 11 (36.67%) XML
10 11 (36.67%) Linux
11 9 (30.00%) Perl
11 9 (30.00%) Git (software)
12 8 (26.67%) Configuration Management
12 8 (26.67%) ClearCase
13 7 (23.33%) Apache
13 7 (23.33%) JBoss

SQL
Co-occurring IT Skills in Livingston 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 7 (23.33%) Apache
1 7 (23.33%) JBoss
1 7 (23.33%) Oracle HTTP Server
2 3 (10.00%) Confluence
3 2 (6.67%) IIS
4 1 (3.33%) Apache Spark
Applications
1 3 (10.00%) MS Visio
Communications & Networking
1 7 (23.33%) HTTP
1 7 (23.33%) TCP/IP
2 2 (6.67%) Firewall
3 1 (3.33%) Broadband
3 1 (3.33%) Internet
Database & Business Intelligence
1 7 (23.33%) Apache Cassandra
2 4 (13.33%) Oracle Reports
3 3 (10.00%) SQL Server
4 2 (6.67%) Data Warehouse
4 2 (6.67%) SQL Server 2008
5 1 (3.33%) DB2
Development Applications
1 9 (30.00%) Git (software)
2 8 (26.67%) ClearCase
3 7 (23.33%) CppUnit
3 7 (23.33%) JUnit
4 4 (13.33%) Oracle APEX
4 4 (13.33%) ProC
4 4 (13.33%) Team Foundation Server
4 4 (13.33%) Toad
5 3 (10.00%) Balsamiq Mockups
5 3 (10.00%) JIRA
6 2 (6.67%) HP UFT
6 2 (6.67%) Ranorex
6 2 (6.67%) SoapUI
7 1 (3.33%) Cucumber
7 1 (3.33%) Jenkins
7 1 (3.33%) Maven
7 1 (3.33%) Selenium
General
1 4 (13.33%) Finance
1 4 (13.33%) Retail
2 3 (10.00%) Telecoms
Job Titles
1 14 (46.67%) Software Engineer
2 9 (30.00%) Developer
3 4 (13.33%) Embedded Engineer
3 4 (13.33%) Embedded Software Engineer
3 4 (13.33%) Oracle Developer
3 4 (13.33%) PL/SQL Developer
3 4 (13.33%) SQL Developer
4 3 (10.00%) Analyst
4 3 (10.00%) C++ Software Engineer
4 3 (10.00%) Developer/Software Engineer
4 3 (10.00%) Software Developer
4 3 (10.00%) Technical Analyst
4 3 (10.00%) Test Engineer
5 2 (6.67%) .NET Developer
5 2 (6.67%) C Software Engineer
5 2 (6.67%) C/C++ Software Engineer
5 2 (6.67%) Data Engineer
5 2 (6.67%) Software Test Engineer
5 2 (6.67%) Support Engineer
5 2 (6.67%) Telecoms Analyst
Libraries, Frameworks & Software Standards
1 13 (43.33%) AngularJS
1 13 (43.33%) JSON
2 11 (36.67%) XML
3 7 (23.33%) Kafka
3 7 (23.33%) RESTful
3 7 (23.33%) SOAP
3 7 (23.33%) WebSockets
4 6 (20.00%) jQuery
5 5 (16.67%) HTML
6 4 (13.33%) Ajax
7 2 (6.67%) .NET
7 2 (6.67%) .NET Framework
7 2 (6.67%) ASP.NET
7 2 (6.67%) WCF
7 2 (6.67%) Web Services
Miscellaneous
1 14 (46.67%) Management Information System
2 2 (6.67%) Embedded Systems
3 1 (3.33%) Analytical Skills
Operating Systems
1 11 (36.67%) Linux
2 4 (13.33%) Windows Server
3 2 (6.67%) Unix
3 2 (6.67%) Windows
Processes & Methodologies
1 17 (56.67%) Agile Software Development
1 17 (56.67%) Test Automation
2 16 (53.33%) Computer Science
2 16 (53.33%) Software Engineering
3 14 (46.67%) Kanban
3 14 (46.67%) Microservices
3 14 (46.67%) Scenario Testing
3 14 (46.67%) Scrum
4 11 (36.67%) Refactoring
5 8 (26.67%) Configuration Management
6 7 (23.33%) Multithreaded Programming
6 7 (23.33%) Multithreading
6 7 (23.33%) Open Source
6 7 (23.33%) Web Application Development
7 4 (13.33%) Business Development
8 3 (10.00%) Business Analysis
8 3 (10.00%) Embedded Software Development
8 3 (10.00%) Requirements Management
8 3 (10.00%) User Stories
8 3 (10.00%) Waterfall
Programming Languages
1 21 (70.00%) PL/SQL
2 19 (63.33%) C#
3 17 (56.67%) Java
3 17 (56.67%) JavaScript
4 15 (50.00%) Python
5 14 (46.67%) C
5 14 (46.67%) C++
5 14 (46.67%) Shell Script
6 9 (30.00%) Perl
7 2 (6.67%) R
7 2 (6.67%) T-SQL
7 2 (6.67%) VBScript
Qualifications
1 18 (60.00%) Degree
2 2 (6.67%) HND
Quality Assurance & Compliance
1 1 (3.33%) Data Quality
Systems Management
1 7 (23.33%) Kubernetes
2 2 (6.67%) HP Quality Center
Vendors
1 22 (73.33%) Oracle
2 4 (13.33%) Microsoft
3 2 (6.67%) Netezza
4 1 (3.33%) Ab Initio
4 1 (3.33%) Informatica
4 1 (3.33%) Teradata