Period
to 22 November 2017

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 22 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 1 9 7
Rank change year-on-year +8 -2 0
Permanent jobs citing SQL 26 9 12
As % of all permanent IT jobs advertised in Livingston 37.68% 15.79% 13.19%
As % of the Programming Languages category 49.06% 24.32% 31.58%
Number of salaries quoted 21 9 11
Livingston median annual salary £40,000 £28,500 £35,000
Median salary % change year-on-year +40.35% -18.57% +5.26%
10th Percentile £24,000 £24,000 £27,500
90th Percentile £45,000 £39,000 £52,500
West Lothian median annual salary £35,000 £32,500 £35,000
% change year-on-year +7.69% -7.14% -8.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 53 37 38
As % of all permanent IT jobs advertised in Livingston 76.81% 64.91% 41.76%
Number of salaries quoted 36 34 33
Livingston median annual salary £40,000 £38,750 £36,000
Median salary % change year-on-year +3.23% +7.64% +2.86%
10th Percentile £24,000 £25,075 £27,850
90th Percentile £48,750 £45,875 £53,500
West Lothian median annual salary £40,000 £37,500 £41,250
% change year-on-year +6.67% -9.09% +10.00%

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 22 November 2017.

Salary histogram for SQL in Livingston

For the 6 months to 22 November 2017, IT jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Livingston region with a requirement for SQL.

1 12 (46.15%) C#
1 12 (46.15%) .NET
2 11 (42.31%) C++
2 11 (42.31%) JavaScript
2 11 (42.31%) XML
2 11 (42.31%) Python
2 11 (42.31%) C
2 11 (42.31%) TCP/IP
2 11 (42.31%) Firmware
2 11 (42.31%) Manufacturing
2 11 (42.31%) Test Automation
2 11 (42.31%) Defect Tracking
2 11 (42.31%) Optoelectronics
3 8 (30.77%) Finance
4 7 (26.92%) Microsoft Excel
4 7 (26.92%) SQLBase
5 6 (23.08%) Software Engineering
5 6 (23.08%) Degree
5 6 (23.08%) Physics
5 6 (23.08%) Electronics
6 5 (19.23%) SLA
6 5 (19.23%) Microsoft
6 5 (19.23%) Computer Science
6 5 (19.23%) PDA
7 4 (15.38%) ISO/IEC 27001
7 4 (15.38%) Windows Server
7 4 (15.38%) Windows Server 2012
7 4 (15.38%) Windows Server 2008
7 4 (15.38%) ISO 9001
7 4 (15.38%) ITIL

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 (11.54%) SAS
2 1 (3.85%) IIS
Applications
1 7 (26.92%) Microsoft Excel
Communications & Networking
1 11 (42.31%) TCP/IP
Database & Business Intelligence
1 7 (26.92%) SQLBase
2 4 (15.38%) SQL Server
3 3 (11.54%) QlikView
4 2 (7.69%) SQL Server Reporting Services
Development Applications
1 2 (7.69%) Visual Studio
General
1 11 (42.31%) Manufacturing
2 8 (30.77%) Finance
3 6 (23.08%) Electronics
4 3 (11.54%) Banking
Job Titles
1 13 (50.00%) Analyst
2 10 (38.46%) Firmware Engineer
3 9 (34.62%) Support Analyst
4 7 (26.92%) SQL Analyst
4 7 (26.92%) SQL Support Analyst
5 6 (23.08%) Software Engineer
6 5 (19.23%) Applications Support
6 5 (19.23%) Applications Support Analyst
7 1 (3.85%) C Software Engineer
7 1 (3.85%) C# Developer
7 1 (3.85%) C/C++ Embedded Software Engineer
7 1 (3.85%) C/C++ Software Engineer
7 1 (3.85%) C++ Software Engineer
7 1 (3.85%) Embedded C Engineer
7 1 (3.85%) Embedded C Software Engineer
7 1 (3.85%) Embedded C/C++ Engineer
7 1 (3.85%) Embedded C/C++ Software Engineer
7 1 (3.85%) Embedded Engineer
7 1 (3.85%) Embedded Software Engineer
7 1 (3.85%) Report Analyst
Libraries, Frameworks & Software Standards
1 12 (46.15%) .NET
2 11 (42.31%) XML
3 1 (3.85%) ASP.NET
3 1 (3.85%) CSS
Miscellaneous
1 11 (42.31%) Optoelectronics
2 5 (19.23%) Computer Science
2 5 (19.23%) PDA
3 1 (3.85%) e-Learning
Operating Systems
1 4 (15.38%) Windows
1 4 (15.38%) Windows Server
1 4 (15.38%) Windows Server 2008
1 4 (15.38%) Windows Server 2012
Processes & Methodologies
1 11 (42.31%) Defect Tracking
1 11 (42.31%) Test Automation
2 6 (23.08%) Physics
2 6 (23.08%) Software Engineering
3 4 (15.38%) ITIL
4 3 (11.54%) Analytics
4 3 (11.54%) Data Strategy
4 3 (11.54%) Data Visualisation
4 3 (11.54%) Service Management
4 3 (11.54%) Visualisation
5 2 (7.69%) Data Analysis
6 1 (3.85%) Agile Software Development
6 1 (3.85%) MVC
6 1 (3.85%) Web Design
Programming Languages
1 12 (46.15%) C#
2 11 (42.31%) C
2 11 (42.31%) C++
2 11 (42.31%) JavaScript
2 11 (42.31%) Python
3 2 (7.69%) T-SQL
Qualifications
1 6 (23.08%) Degree
Quality Assurance & Compliance
1 5 (19.23%) SLA
2 4 (15.38%) ISO 9001
2 4 (15.38%) ISO/IEC 27001
System Software
1 11 (42.31%) Firmware
Vendors
1 5 (19.23%) Microsoft
2 3 (11.54%) Tableau