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

SQL (Structured Query Language)
Scotland > West Lothian
6 months to
20 Oct 2018
Same period 2017 Same period 2016
Rank 5 1 5
Rank change year-on-year -4 +4 +2
Permanent jobs citing SQL 60 30 19
As % of all permanent IT jobs advertised in West Lothian 32.43% 38.46% 20.65%
As % of the Programming Languages category 57.14% 55.56% 38.00%
Number of salaries quoted 26 24 17
West Lothian median annual salary £40,000 £32,500 £32,500
Median salary % change year-on-year +23.08% - -18.75%
10th Percentile £26,125 £24,000 £24,000
90th Percentile £46,875 £45,000 £40,250
Scotland median annual salary £45,000 £40,000 £40,500
% change year-on-year +12.50% -1.23% -4.40%

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 105 54 50
As % of all permanent IT jobs advertised in West Lothian 56.76% 69.23% 54.35%
Number of salaries quoted 47 41 41
West Lothian median annual salary £40,000 £40,000 £36,000
Median salary % change year-on-year - +11.11% -10.00%
10th Percentile £22,200 £24,000 £25,250
90th Percentile £52,500 £50,000 £46,250
Scotland median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +6.25%

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 20 October 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 20 October 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 0 33 £40,000 +21.21% 6
Linlithgow - 18 - -
SQL
Scotland

For the 6 months to 20 October 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 42 (70.00%) Oracle
2 40 (66.67%) PL/SQL
3 38 (63.33%) Degree
4 36 (60.00%) Agile Software Development
5 32 (53.33%) Finance
6 21 (35.00%) JavaScript
7 20 (33.33%) C#
8 19 (31.67%) XML
8 19 (31.67%) ERP
8 19 (31.67%) Oracle ERP
8 19 (31.67%) Oracle EBS
8 19 (31.67%) Analytical Skills
9 18 (30.00%) System Testing
10 17 (28.33%) Test Automation
10 17 (28.33%) Computer Science
11 16 (26.67%) jQuery
12 15 (25.00%) Python
12 15 (25.00%) Windows
12 15 (25.00%) HTML
13 14 (23.33%) Toad
13 14 (23.33%) Business Development
13 14 (23.33%) Oracle APEX
13 14 (23.33%) Ajax
13 14 (23.33%) Retail
14 13 (21.67%) HTTP
15 12 (20.00%) Team Foundation Server
16 9 (15.00%) Software Engineering
16 9 (15.00%) Linux
16 9 (15.00%) Java
16 9 (15.00%) SDLC

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 5 (8.33%) Apache
1 5 (8.33%) JBoss
1 5 (8.33%) Oracle HTTP Server
2 4 (6.67%) IIS
Business Applications
1 19 (31.67%) Oracle EBS
1 19 (31.67%) Oracle ERP
2 1 (1.67%) Oracle Applications
Cloud Services
1 3 (5.00%) Microsoft Azure
Communications & Networking
1 13 (21.67%) HTTP
2 8 (13.33%) IPv4
2 8 (13.33%) IPv6
2 8 (13.33%) VLAN
3 5 (8.33%) TCP/IP
4 3 (5.00%) Firewall
5 1 (1.67%) Internet
Database & Business Intelligence
1 5 (8.33%) Apache Cassandra
1 5 (8.33%) Oracle Reports
2 2 (3.33%) SQL Server
2 2 (3.33%) SQL Server Analysis Services
2 2 (3.33%) SQL Server Integration Services
2 2 (3.33%) SQL Server Reporting Services
3 1 (1.67%) Relational Database
3 1 (1.67%) SQL Server 2008
3 1 (1.67%) SQL Server 2012
3 1 (1.67%) SQL Server 2014
Development Applications
1 14 (23.33%) Oracle APEX
1 14 (23.33%) Toad
2 12 (20.00%) Team Foundation Server
3 8 (13.33%) Bugzilla
3 8 (13.33%) JIRA
4 5 (8.33%) ClearCase
4 5 (8.33%) CppUnit
4 5 (8.33%) Git (software)
4 5 (8.33%) JUnit
4 5 (8.33%) ProC
5 2 (3.33%) HP UFT
5 2 (3.33%) Ranorex
5 2 (3.33%) SoapUI
5 2 (3.33%) Visual Studio
General
1 32 (53.33%) Finance
2 14 (23.33%) Retail
3 8 (13.33%) Electronics
3 8 (13.33%) Telecoms
Job Titles
1 25 (41.67%) Analyst
2 21 (35.00%) Technical Analyst
3 19 (31.67%) Business Analyst
3 19 (31.67%) Developer
4 18 (30.00%) Technical Business Analyst
5 14 (23.33%) Oracle Developer
6 10 (16.67%) Test Engineer
7 7 (11.67%) Software Engineer
8 5 (8.33%) PL/SQL Developer
8 5 (8.33%) SQL Analyst
8 5 (8.33%) SQL Developer
9 4 (6.67%) Product Engineer
9 4 (6.67%) Product Test Engineer
9 4 (6.67%) Software Developer
9 4 (6.67%) Systems Engineer
9 4 (6.67%) Systems Test Engineer
10 3 (5.00%) Developer/Software Engineer
11 2 (3.33%) Report Analyst
11 2 (3.33%) SQL Reporting Analyst
11 2 (3.33%) Support Engineer
Libraries, Frameworks & Software Standards
1 19 (31.67%) XML
2 16 (26.67%) jQuery
3 15 (25.00%) HTML
4 14 (23.33%) Ajax
5 8 (13.33%) REST
6 7 (11.67%) AngularJS
6 7 (11.67%) JSON
7 5 (8.33%) Kafka
7 5 (8.33%) RESTful
7 5 (8.33%) SOAP
7 5 (8.33%) WebSockets
8 2 (3.33%) .NET
8 2 (3.33%) WCF
9 1 (1.67%) ASP.NET
9 1 (1.67%) Web Services
Miscellaneous
1 19 (31.67%) Analytical Skills
2 17 (28.33%) Computer Science
3 7 (11.67%) Management Information System
4 2 (3.33%) Fintech
Operating Systems
1 15 (25.00%) Windows
2 9 (15.00%) Linux
3 7 (11.67%) Windows Server
4 1 (1.67%) Windows Server 2008
4 1 (1.67%) Windows Server 2012
Processes & Methodologies
1 36 (60.00%) Agile Software Development
2 19 (31.67%) ERP
3 18 (30.00%) System Testing
4 17 (28.33%) Test Automation
5 14 (23.33%) Business Development
6 9 (15.00%) SDLC
6 9 (15.00%) Software Engineering
7 8 (13.33%) BDD
7 8 (13.33%) Customer-Centricity
7 8 (13.33%) Physics
7 8 (13.33%) TDD
8 7 (11.67%) Kanban
8 7 (11.67%) Microservices
8 7 (11.67%) Refactoring
8 7 (11.67%) Scenario Testing
8 7 (11.67%) Scrum
9 6 (10.00%) Configuration Management
10 5 (8.33%) Multithreading
10 5 (8.33%) Open Source
10 5 (8.33%) Web Application Development
Programming Languages
1 40 (66.67%) PL/SQL
2 21 (35.00%) JavaScript
3 20 (33.33%) C#
4 15 (25.00%) Python
5 9 (15.00%) Java
6 8 (13.33%) Tcl
7 7 (11.67%) C
7 7 (11.67%) C++
7 7 (11.67%) Perl
7 7 (11.67%) Shell Script
8 3 (5.00%) PowerShell
8 3 (5.00%) T-SQL
9 2 (3.33%) R
9 2 (3.33%) VBScript
Qualifications
1 38 (63.33%) Degree
2 2 (3.33%) HND
Systems Management
1 5 (8.33%) Kubernetes
2 3 (5.00%) Ansible
2 3 (5.00%) Opscode Chef
3 2 (3.33%) HP Quality Center
Vendors
1 42 (70.00%) Oracle
2 7 (11.67%) Microsoft