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

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
21 May 2018
Same period 2017 Same period 2016
Rank 1 8 3
Rank change year-on-year +7 -5 -2
Permanent jobs citing SQL 21 20 20
As % of all permanent IT jobs advertised in Livingston 40.38% 24.69% 27.03%
As % of the Programming Languages category 63.64% 35.09% 47.62%
Number of salaries quoted 20 14 13
Livingston median annual salary £40,000 £35,250 £35,000
Median salary % change year-on-year +13.48% +0.71% -
10th Percentile £31,000 £24,000 £31,250
90th Percentile £50,975 £40,750 £47,500
West Lothian median annual salary £40,000 £36,500 £38,750
% change year-on-year +9.59% -5.81% +4.73%

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 33 57 42
As % of all permanent IT jobs advertised in Livingston 63.46% 70.37% 56.76%
Number of salaries quoted 27 49 22
Livingston median annual salary £40,000 £40,000 £38,000
Median salary % change year-on-year - +5.26% +8.57%
10th Percentile £31,150 £24,000 £25,625
90th Percentile £47,850 £52,950 £47,500
West Lothian median annual salary £43,500 £40,000 £38,000
% change year-on-year +8.75% +5.26% +8.57%

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 21 May 2018.

Salary histogram for SQL in Livingston

For the 6 months to 21 May 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 9 (42.86%) Oracle
1 9 (42.86%) XML
2 8 (38.10%) Agile Software Development
3 7 (33.33%) .NET
3 7 (33.33%) Windows
3 7 (33.33%) Microsoft
4 6 (28.57%) SQL Server
4 6 (28.57%) C#
4 6 (28.57%) JavaScript
4 6 (28.57%) Microsoft Azure
5 5 (23.81%) Test Automation
5 5 (23.81%) Windows Server
5 5 (23.81%) Project Management
5 5 (23.81%) Software Engineering
6 4 (19.05%) Unix
6 4 (19.05%) HP
6 4 (19.05%) CRM
6 4 (19.05%) Ansible
6 4 (19.05%) Test Planning
6 4 (19.05%) API Testing
6 4 (19.05%) HP Quality Center
6 4 (19.05%) Waterfall
6 4 (19.05%) Functional Testing
6 4 (19.05%) Opscode Chef
6 4 (19.05%) Oracle Database
6 4 (19.05%) Degree
6 4 (19.05%) jQuery
6 4 (19.05%) Test Scripting
7 3 (14.29%) ISO/IEC 27001
7 3 (14.29%) Business Development

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 3 (14.29%) IIS
2 2 (9.52%) SAS
Applications
1 2 (9.52%) Microsoft Excel
Cloud Services
1 6 (28.57%) Microsoft Azure
2 1 (4.76%) SaaS
Communications & Networking
1 3 (14.29%) TCP/IP
2 1 (4.76%) Firewall
Database & Business Intelligence
1 6 (28.57%) SQL Server
2 4 (19.05%) Oracle Database
3 2 (9.52%) SQL Server 2008
3 2 (9.52%) SQL Server 2012
4 1 (4.76%) Relational Database
4 1 (4.76%) SQL Server 2005
4 1 (4.76%) SQL Server 2014
4 1 (4.76%) SQL Server 2016
4 1 (4.76%) SQL Server Integration Services
4 1 (4.76%) SQL Server Reporting Services
Development Applications
1 3 (14.29%) Oracle APEX
1 3 (14.29%) Team Foundation Server
1 3 (14.29%) Toad
General
1 3 (14.29%) Electronics
1 3 (14.29%) Finance
1 3 (14.29%) Manufacturing
1 3 (14.29%) Retail
2 2 (9.52%) Telecoms
Job Titles
1 6 (28.57%) Analyst
2 4 (19.05%) Developer
2 4 (19.05%) SQL Analyst
3 3 (14.29%) Applications Support
3 3 (14.29%) C Software Engineer
3 3 (14.29%) C/C++ Embedded Software Engineer
3 3 (14.29%) C/C++ Software Engineer
3 3 (14.29%) C++ Software Engineer
3 3 (14.29%) Embedded C Engineer
3 3 (14.29%) Embedded C Software Engineer
3 3 (14.29%) Embedded C/C++ Engineer
3 3 (14.29%) Embedded C/C++ Software Engineer
3 3 (14.29%) Embedded C++ Engineer
3 3 (14.29%) Embedded C++ Software Engineer
3 3 (14.29%) Embedded Engineer
3 3 (14.29%) Embedded Software Engineer
3 3 (14.29%) Functional Tester
3 3 (14.29%) Oracle Developer
3 3 (14.29%) Software Engineer
3 3 (14.29%) Tester
Libraries, Frameworks & Software Standards
1 9 (42.86%) XML
2 7 (33.33%) .NET
3 4 (19.05%) jQuery
4 3 (14.29%) Ajax
4 3 (14.29%) HTML
4 3 (14.29%) XML Messaging
5 1 (4.76%) ASP.NET
5 1 (4.76%) WCF
5 1 (4.76%) Web Services
Miscellaneous
1 3 (14.29%) Optoelectronics
2 2 (9.52%) PDA
3 1 (4.76%) Data Centre
3 1 (4.76%) Fintech
Operating Systems
1 7 (33.33%) Windows
2 5 (23.81%) Windows Server
3 4 (19.05%) Unix
4 2 (9.52%) Windows Server 2008
4 2 (9.52%) Windows Server 2012
Processes & Methodologies
1 8 (38.10%) Agile Software Development
2 5 (23.81%) Project Management
2 5 (23.81%) Software Engineering
2 5 (23.81%) Test Automation
3 4 (19.05%) API Testing
3 4 (19.05%) CRM
3 4 (19.05%) Functional Testing
3 4 (19.05%) Test Planning
3 4 (19.05%) Test Scripting
3 4 (19.05%) Waterfall
4 3 (14.29%) Business Development
4 3 (14.29%) Defect Tracking
4 3 (14.29%) ITIL
4 3 (14.29%) Physics
4 3 (14.29%) Release Management
4 3 (14.29%) SDLC
4 3 (14.29%) Validation
5 2 (9.52%) Data Management
5 2 (9.52%) DevOps
5 2 (9.52%) Project Planning
Programming Languages
1 6 (28.57%) C#
1 6 (28.57%) JavaScript
2 3 (14.29%) C
2 3 (14.29%) C++
2 3 (14.29%) PL/SQL
2 3 (14.29%) Python
3 2 (9.52%) PowerShell
3 2 (9.52%) T-SQL
Qualifications
1 4 (19.05%) Degree
Quality Assurance & Compliance
1 3 (14.29%) ISO 9001
1 3 (14.29%) ISO/IEC 27001
2 2 (9.52%) SLA
System Software
1 3 (14.29%) Firmware
Systems Management
1 4 (19.05%) Ansible
1 4 (19.05%) HP Quality Center
1 4 (19.05%) Opscode Chef
2 3 (14.29%) HP ALM
3 2 (9.52%) Munin
3 2 (9.52%) Nagios
3 2 (9.52%) Prometheus
Vendors
1 9 (42.86%) Oracle
2 7 (33.33%) Microsoft
3 4 (19.05%) HP
4 2 (9.52%) New Relic
4 2 (9.52%) Tableau