Period
to 26 September 2018

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

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
26 Sep 2018
Same period 2017 Same period 2016
Rank 1 1 3
Rank change year-on-year 0 +2 -1
Permanent jobs citing SQL 30 29 17
As % of all permanent IT jobs advertised in Livingston 38.46% 44.62% 28.33%
As % of the Programming Languages category 58.82% 58.00% 38.64%
Number of salaries quoted 24 20 15
Livingston median annual salary £40,000 £33,000 £32,500
Median salary % change year-on-year +21.21% +1.54% -18.75%
10th Percentile £27,850 £24,000 £24,000
90th Percentile £51,825 £42,500 £47,500
West Lothian median annual salary £40,000 £31,250 £35,000
% change year-on-year +28.00% -10.71% -12.50%

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 51 50 44
As % of all permanent IT jobs advertised in Livingston 65.38% 76.92% 73.33%
Number of salaries quoted 36 37 34
Livingston median annual salary £40,000 £36,500 £36,750
Median salary % change year-on-year +9.59% -0.68% -8.13%
10th Percentile £31,000 £24,000 £25,075
90th Percentile £52,500 £54,850 £47,500
West Lothian median annual salary £40,000 £36,500 £37,500
% change year-on-year +9.59% -2.67% -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 26 September 2018.

Salary histogram for SQL in Livingston

For the 6 months to 26 September 2018, 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 19 (63.33%) Oracle
2 16 (53.33%) PL/SQL
3 15 (50.00%) JavaScript
3 15 (50.00%) XML
4 13 (43.33%) HTML
4 13 (43.33%) jQuery
5 12 (40.00%) Oracle APEX
5 12 (40.00%) Ajax
5 12 (40.00%) Business Development
5 12 (40.00%) Retail
5 12 (40.00%) Toad
5 12 (40.00%) Finance
6 10 (33.33%) Team Foundation Server
7 9 (30.00%) Agile Software Development
8 8 (26.67%) Degree
9 7 (23.33%) Microsoft
9 7 (23.33%) C#
9 7 (23.33%) Windows
9 7 (23.33%) Linux
9 7 (23.33%) Windows Server
10 5 (16.67%) Perl
10 5 (16.67%) Scrum
10 5 (16.67%) Computer Science
10 5 (16.67%) Software Engineering
10 5 (16.67%) Test Automation
11 4 (13.33%) Business Intelligence
11 4 (13.33%) Configuration Management
11 4 (13.33%) IIS
11 4 (13.33%) Java
12 3 (10.00%) C++

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 4 (13.33%) IIS
2 3 (10.00%) Apache
2 3 (10.00%) JBoss
2 3 (10.00%) Oracle HTTP Server
3 2 (6.67%) SAS
Business Applications
1 1 (3.33%) Oracle Applications
1 1 (3.33%) Oracle EBS
1 1 (3.33%) Oracle ERP
Cloud Services
1 3 (10.00%) Microsoft Azure
Communications & Networking
1 3 (10.00%) Firewall
1 3 (10.00%) HTTP
1 3 (10.00%) TCP/IP
2 1 (3.33%) Internet
Database & Business Intelligence
1 3 (10.00%) Apache Cassandra
1 3 (10.00%) Oracle Reports
2 2 (6.67%) SQL Server
2 2 (6.67%) SQL Server Analysis Services
2 2 (6.67%) SQL Server Integration Services
2 2 (6.67%) SQL Server Reporting Services
3 1 (3.33%) Oracle Database
3 1 (3.33%) Relational Database
3 1 (3.33%) SQL Server 2008
3 1 (3.33%) SQL Server 2012
3 1 (3.33%) SQL Server 2014
Development Applications
1 12 (40.00%) Oracle APEX
1 12 (40.00%) Toad
2 10 (33.33%) Team Foundation Server
3 3 (10.00%) ClearCase
3 3 (10.00%) CppUnit
3 3 (10.00%) Git (software)
3 3 (10.00%) JUnit
3 3 (10.00%) ProC
4 2 (6.67%) HP UFT
4 2 (6.67%) Ranorex
4 2 (6.67%) SoapUI
4 2 (6.67%) Visual Studio
General
1 12 (40.00%) Finance
1 12 (40.00%) Retail
Job Titles
1 13 (43.33%) Developer
2 12 (40.00%) Oracle Developer
3 8 (26.67%) Analyst
4 5 (16.67%) SQL Analyst
5 3 (10.00%) PL/SQL Developer
5 3 (10.00%) Software Engineer
5 3 (10.00%) SQL Developer
5 3 (10.00%) Technical Analyst
6 2 (6.67%) Analytics Manager
6 2 (6.67%) Cloud Technical Analyst
6 2 (6.67%) Data Analytics Manager
6 2 (6.67%) Data Manager
6 2 (6.67%) Report Analyst
6 2 (6.67%) Software Test Engineer
6 2 (6.67%) SQL Reporting Analyst
6 2 (6.67%) Support Engineer
6 2 (6.67%) Test Engineer
7 1 (3.33%) IT Engineer
7 1 (3.33%) Oracle Business Analyst
7 1 (3.33%) SQL Support Analyst
Libraries, Frameworks & Software Standards
1 15 (50.00%) XML
2 13 (43.33%) HTML
2 13 (43.33%) jQuery
3 12 (40.00%) Ajax
4 3 (10.00%) AngularJS
4 3 (10.00%) JSON
4 3 (10.00%) Kafka
4 3 (10.00%) RESTful
4 3 (10.00%) SOAP
4 3 (10.00%) WebSockets
5 1 (3.33%) .NET
5 1 (3.33%) ASP.NET
5 1 (3.33%) WCF
5 1 (3.33%) Web Services
Miscellaneous
1 5 (16.67%) Computer Science
2 3 (10.00%) Management Information System
3 1 (3.33%) Analytical Skills
3 1 (3.33%) Fintech
Operating Systems
1 7 (23.33%) Linux
1 7 (23.33%) Windows
1 7 (23.33%) Windows Server
2 1 (3.33%) Unix
2 1 (3.33%) Windows Server 2008
2 1 (3.33%) Windows Server 2012
Processes & Methodologies
1 12 (40.00%) Business Development
2 9 (30.00%) Agile Software Development
3 5 (16.67%) Scrum
3 5 (16.67%) Software Engineering
3 5 (16.67%) Test Automation
4 4 (13.33%) Business Intelligence
4 4 (13.33%) Configuration Management
5 3 (10.00%) Deployment Automation
5 3 (10.00%) ITIL
5 3 (10.00%) Kanban
5 3 (10.00%) Microservices
5 3 (10.00%) Multithreaded Programming
5 3 (10.00%) Multithreading
5 3 (10.00%) Open Source
5 3 (10.00%) Refactoring
5 3 (10.00%) Scenario Testing
5 3 (10.00%) Web Application Development
6 2 (6.67%) Problem-Solving
6 2 (6.67%) Project Planning
6 2 (6.67%) Task Automation
Programming Languages
1 16 (53.33%) PL/SQL
2 15 (50.00%) JavaScript
3 7 (23.33%) C#
4 5 (16.67%) Perl
5 4 (13.33%) Java
6 3 (10.00%) C
6 3 (10.00%) C++
6 3 (10.00%) PowerShell
6 3 (10.00%) Python
6 3 (10.00%) Shell Script
6 3 (10.00%) T-SQL
7 2 (6.67%) VBScript
8 1 (3.33%) R
Qualifications
1 8 (26.67%) Degree
2 2 (6.67%) HND
Systems Management
1 3 (10.00%) Ansible
1 3 (10.00%) HP Quality Center
1 3 (10.00%) Kubernetes
1 3 (10.00%) Opscode Chef
Vendors
1 19 (63.33%) Oracle
2 7 (23.33%) Microsoft
3 2 (6.67%) Tableau
4 1 (3.33%) HP