Period
to 25 May 2018

The following table provides summary statistics for permanent job vacancies advertised in West Lothian 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 25 May 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Scotland > West Lothian
6 months to
25 May 2018
Same period 2017 Same period 2016
Rank 3 5 3
Rank change year-on-year +2 -2 0
Permanent jobs citing SQL 42 38 31
As % of all permanent IT jobs advertised in West Lothian 35.00% 34.86% 28.70%
As % of the Programming Languages category 51.22% 47.50% 52.54%
Number of salaries quoted 22 30 18
West Lothian median annual salary £40,000 £36,500 £38,750
Median salary % change year-on-year +9.59% -5.81% -0.64%
10th Percentile £31,000 £24,000 £31,250
90th Percentile £49,600 £45,000 £50,375
Scotland median annual salary £44,000 £40,000 £40,000
% change year-on-year +10.00% - -5.88%

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 West Lothian with a requirement for coding skills.

All Programming Languages
West Lothian
Permanent vacancies with a requirement for coding skills 82 80 59
As % of all permanent IT jobs advertised in West Lothian 68.33% 73.39% 54.63%
Number of salaries quoted 49 68 31
West Lothian median annual salary £42,500 £40,000 £38,500
Median salary % change year-on-year +6.25% +3.90% +8.45%
10th Percentile £32,250 £24,700 £31,250
90th Percentile £46,500 £52,500 £50,000
Scotland median annual salary £45,000 £42,500 £42,000
% change year-on-year +5.88% +1.19% -1.18%

SQL
Job Vacancy Trend in West Lothian

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

Job vacancy trend for SQL in West Lothian

SQL
Salary Trend in West Lothian

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

Salary trend for SQL in West Lothian

SQL
Salary Histogram in West Lothian

The salary distribution of IT jobs citing SQL in West Lothian over the 6 months to 25 May 2018.

Salary histogram for SQL in West Lothian

SQL
Job Locations in West Lothian

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL within the West Lothian region over the 6 months to 25 May 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
Livingston +6 23 £40,000 +17.65% 12
Linlithgow -6 9 - -
SQL
Scotland

For the 6 months to 25 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 West Lothian region with a requirement for SQL.

1 24 (57.14%) Agile Software Development
2 19 (45.24%) Degree
2 19 (45.24%) Oracle
3 18 (42.86%) Windows
4 16 (38.10%) C#
5 15 (35.71%) Test Automation
6 14 (33.33%) JIRA
7 13 (30.95%) Physics
7 13 (30.95%) PL/SQL
7 13 (30.95%) Python
7 13 (30.95%) Electronics
7 13 (30.95%) SDLC
8 12 (28.57%) Telecoms
9 11 (26.19%) JavaScript
10 10 (23.81%) XML
10 10 (23.81%) HTTP
10 10 (23.81%) Tcl
10 10 (23.81%) IPv4
10 10 (23.81%) IPv6
10 10 (23.81%) Bugzilla
10 10 (23.81%) Computer Science
10 10 (23.81%) VLAN
10 10 (23.81%) TDD
10 10 (23.81%) BDD
10 10 (23.81%) REST
10 10 (23.81%) Customer-Centricity
11 9 (21.43%) Finance
12 8 (19.05%) Microsoft
12 8 (19.05%) Oracle APEX
13 7 (16.67%) Microsoft Azure

SQL
Co-occurring IT Skills in West Lothian 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 (9.52%) Confluence
1 4 (9.52%) IIS
2 2 (4.76%) SAS
Applications
1 2 (4.76%) Microsoft Excel
Business Applications
1 5 (11.90%) Oracle EBS
1 5 (11.90%) Oracle ERP
Cloud Services
1 7 (16.67%) Microsoft Azure
2 1 (2.38%) SaaS
Communications & Networking
1 10 (23.81%) HTTP
1 10 (23.81%) IPv4
1 10 (23.81%) IPv6
1 10 (23.81%) VLAN
2 3 (7.14%) TCP/IP
3 1 (2.38%) Firewall
Database & Business Intelligence
1 6 (14.29%) SQL Server
2 4 (9.52%) Oracle BI EE
2 4 (9.52%) Oracle BI Publisher
2 4 (9.52%) Oracle Database
2 4 (9.52%) Oracle Discoverer
2 4 (9.52%) Oracle OWB
2 4 (9.52%) Oracle Reports
3 2 (4.76%) SQL Server 2008
3 2 (4.76%) SQL Server 2012
4 1 (2.38%) Relational Database
4 1 (2.38%) SQL Server 2005
4 1 (2.38%) SQL Server 2014
4 1 (2.38%) SQL Server 2016
4 1 (2.38%) SQL Server Integration Services
4 1 (2.38%) SQL Server Reporting Services
Development Applications
1 14 (33.33%) JIRA
2 10 (23.81%) Bugzilla
3 8 (19.05%) Oracle APEX
4 4 (9.52%) Oracle Forms
4 4 (9.52%) Team Foundation Server
4 4 (9.52%) Toad
General
1 13 (30.95%) Electronics
2 12 (28.57%) Telecoms
3 9 (21.43%) Finance
4 4 (9.52%) Retail
5 3 (7.14%) Manufacturing
Job Titles
1 12 (28.57%) Analyst
2 10 (23.81%) Test Engineer
3 9 (21.43%) Developer
4 8 (19.05%) Oracle Developer
4 8 (19.05%) Technical Analyst
5 5 (11.90%) Business Analyst
5 5 (11.90%) Product Engineer
5 5 (11.90%) Product Test Engineer
5 5 (11.90%) Systems Engineer
5 5 (11.90%) Systems Test Engineer
5 5 (11.90%) Technical Business Analyst
6 4 (9.52%) SQL Analyst
7 3 (7.14%) C Software Engineer
7 3 (7.14%) C/C++ Embedded Software Engineer
7 3 (7.14%) C/C++ Software Engineer
7 3 (7.14%) Embedded C Engineer
7 3 (7.14%) Embedded C Software Engineer
7 3 (7.14%) Embedded C/C++ Engineer
7 3 (7.14%) Embedded Engineer
7 3 (7.14%) Functional Tester
Libraries, Frameworks & Software Standards
1 10 (23.81%) REST
1 10 (23.81%) XML
2 7 (16.67%) .NET
3 5 (11.90%) jQuery
4 4 (9.52%) Ajax
4 4 (9.52%) HTML
5 3 (7.14%) XML Messaging
6 1 (2.38%) ASP.NET
6 1 (2.38%) WCF
6 1 (2.38%) Web Services
Miscellaneous
1 10 (23.81%) Computer Science
2 5 (11.90%) Analytical Skills
3 3 (7.14%) Optoelectronics
4 2 (4.76%) PDA
5 1 (2.38%) Data Centre
5 1 (2.38%) Fintech
Operating Systems
1 18 (42.86%) Windows
2 6 (14.29%) Windows Server
3 4 (9.52%) Unix
4 2 (4.76%) Windows Server 2008
4 2 (4.76%) Windows Server 2012
Processes & Methodologies
1 24 (57.14%) Agile Software Development
2 15 (35.71%) Test Automation
3 13 (30.95%) Physics
3 13 (30.95%) SDLC
4 10 (23.81%) BDD
4 10 (23.81%) Customer-Centricity
4 10 (23.81%) TDD
5 7 (16.67%) ITIL
6 6 (14.29%) Business Intelligence
6 6 (14.29%) Scrum
7 5 (11.90%) ERP
7 5 (11.90%) Project Management
7 5 (11.90%) Software Engineering
7 5 (11.90%) System Testing
8 4 (9.52%) Business Development
8 4 (9.52%) CRM
8 4 (9.52%) Functional Testing
8 4 (9.52%) Presales
8 4 (9.52%) Test Scripting
8 4 (9.52%) Waterfall
Programming Languages
1 16 (38.10%) C#
2 13 (30.95%) PL/SQL
2 13 (30.95%) Python
3 11 (26.19%) JavaScript
4 10 (23.81%) Tcl
5 4 (9.52%) Java
6 3 (7.14%) C
6 3 (7.14%) C++
6 3 (7.14%) PowerShell
7 2 (4.76%) T-SQL
Qualifications
1 19 (45.24%) Degree
Quality Assurance & Compliance
1 3 (7.14%) ISO 9001
1 3 (7.14%) ISO/IEC 27001
2 2 (4.76%) SLA
System Software
1 3 (7.14%) Firmware
Systems Management
1 5 (11.90%) Ansible
1 5 (11.90%) Opscode Chef
2 4 (9.52%) HP Quality Center
3 3 (7.14%) HP ALM
4 2 (4.76%) Munin
4 2 (4.76%) Nagios
4 2 (4.76%) Prometheus
Vendors
1 19 (45.24%) Oracle
2 8 (19.05%) Microsoft
3 4 (9.52%) HP
4 2 (4.76%) New Relic
4 2 (4.76%) Tableau