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

SQL (Structured Query Language)
Scotland > West Lothian
6 months to
20 Aug 2018
Same period 2017 Same period 2016
Rank 4 4 2
Rank change year-on-year 0 -2 +1
Permanent jobs citing SQL 46 37 26
As % of all permanent IT jobs advertised in West Lothian 30.46% 39.78% 26.00%
As % of the Programming Languages category 48.42% 52.11% 50.00%
Number of salaries quoted 23 29 17
West Lothian median annual salary £40,000 £30,000 £35,000
Median salary % change year-on-year +33.33% -14.29% -12.50%
10th Percentile £27,400 £24,000 £24,000
90th Percentile £52,050 £42,500 £48,500
Scotland median annual salary £45,000 £40,000 £41,461
% change year-on-year +12.50% -3.52% -2.45%

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 95 71 52
As % of all permanent IT jobs advertised in West Lothian 62.91% 76.34% 52.00%
Number of salaries quoted 53 57 31
West Lothian median annual salary £42,500 £36,500 £37,500
Median salary % change year-on-year +16.44% -2.67% -6.25%
10th Percentile £25,900 £24,000 £25,250
90th Percentile £47,250 £53,400 £47,500
Scotland median annual salary £45,000 £42,500 £42,500
% change year-on-year +5.88% - +3.66%

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 August 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 August 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 +2 25 £40,000 +25.98% 9
Linlithgow - 11 - -
SQL
Scotland

For the 6 months to 20 August 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 28 (60.87%) Agile Software Development
2 27 (58.70%) Oracle
3 25 (54.35%) Degree
4 24 (52.17%) PL/SQL
5 22 (47.83%) Finance
6 15 (32.61%) Windows
7 13 (28.26%) C#
8 12 (26.09%) HTML
8 12 (26.09%) JavaScript
8 12 (26.09%) XML
8 12 (26.09%) ERP
8 12 (26.09%) Oracle EBS
8 12 (26.09%) Oracle ERP
8 12 (26.09%) jQuery
8 12 (26.09%) Analytical Skills
9 11 (23.91%) SDLC
9 11 (23.91%) System Testing
9 11 (23.91%) Test Automation
9 11 (23.91%) Retail
9 11 (23.91%) Business Development
9 11 (23.91%) Computer Science
9 11 (23.91%) Oracle APEX
9 11 (23.91%) Ajax
9 11 (23.91%) HTTP
9 11 (23.91%) Toad
9 11 (23.91%) Python
10 10 (21.74%) Bugzilla
10 10 (21.74%) Electronics
10 10 (21.74%) Telecoms
10 10 (21.74%) IPv4

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 (8.70%) IIS
2 2 (4.35%) SAS
3 1 (2.17%) Apache
3 1 (2.17%) JBoss
3 1 (2.17%) Oracle HTTP Server
Business Applications
1 12 (26.09%) Oracle EBS
1 12 (26.09%) Oracle ERP
2 1 (2.17%) Oracle Applications
Cloud Services
1 3 (6.52%) Microsoft Azure
Communications & Networking
1 11 (23.91%) HTTP
2 10 (21.74%) IPv4
2 10 (21.74%) IPv6
2 10 (21.74%) VLAN
3 3 (6.52%) Firewall
4 1 (2.17%) Internet
4 1 (2.17%) TCP/IP
Database & Business Intelligence
1 2 (4.35%) Oracle Reports
1 2 (4.35%) SQL Server
1 2 (4.35%) SQL Server Analysis Services
1 2 (4.35%) SQL Server Integration Services
1 2 (4.35%) SQL Server Reporting Services
2 1 (2.17%) Apache Cassandra
2 1 (2.17%) Oracle Database
2 1 (2.17%) Relational Database
2 1 (2.17%) SQL Server 2008
2 1 (2.17%) SQL Server 2012
2 1 (2.17%) SQL Server 2014
Development Applications
1 11 (23.91%) Oracle APEX
1 11 (23.91%) Toad
2 10 (21.74%) Bugzilla
2 10 (21.74%) JIRA
3 9 (19.57%) Team Foundation Server
4 2 (4.35%) ProC
4 2 (4.35%) Visual Studio
5 1 (2.17%) ClearCase
5 1 (2.17%) CppUnit
5 1 (2.17%) Git (software)
5 1 (2.17%) JUnit
General
1 22 (47.83%) Finance
2 11 (23.91%) Retail
3 10 (21.74%) Electronics
3 10 (21.74%) Telecoms
Job Titles
1 19 (41.30%) Analyst
2 14 (30.43%) Technical Analyst
3 12 (26.09%) Business Analyst
3 12 (26.09%) Developer
4 11 (23.91%) Oracle Developer
4 11 (23.91%) Technical Business Analyst
5 10 (21.74%) Test Engineer
6 5 (10.87%) Product Engineer
6 5 (10.87%) Product Test Engineer
6 5 (10.87%) SQL Analyst
6 5 (10.87%) Systems Engineer
6 5 (10.87%) Systems Test Engineer
7 2 (4.35%) Analytics Manager
7 2 (4.35%) Cloud Technical Analyst
7 2 (4.35%) Data Analytics Manager
7 2 (4.35%) Data Manager
7 2 (4.35%) PL/SQL Developer
7 2 (4.35%) Report Analyst
7 2 (4.35%) SQL Developer
7 2 (4.35%) Support Engineer
Libraries, Frameworks & Software Standards
1 12 (26.09%) HTML
1 12 (26.09%) jQuery
1 12 (26.09%) XML
2 11 (23.91%) Ajax
3 10 (21.74%) REST
4 1 (2.17%) .NET
4 1 (2.17%) AngularJS
4 1 (2.17%) ASP.NET
4 1 (2.17%) JSON
4 1 (2.17%) Kafka
4 1 (2.17%) RESTful
4 1 (2.17%) SOAP
4 1 (2.17%) WCF
4 1 (2.17%) Web Services
4 1 (2.17%) WebSockets
Miscellaneous
1 12 (26.09%) Analytical Skills
2 11 (23.91%) Computer Science
3 1 (2.17%) Fintech
3 1 (2.17%) Management Information System
Operating Systems
1 15 (32.61%) Windows
2 5 (10.87%) Windows Server
3 3 (6.52%) Linux
4 1 (2.17%) Unix
4 1 (2.17%) Windows Server 2008
4 1 (2.17%) Windows Server 2012
Processes & Methodologies
1 28 (60.87%) Agile Software Development
2 12 (26.09%) ERP
3 11 (23.91%) Business Development
3 11 (23.91%) SDLC
3 11 (23.91%) System Testing
3 11 (23.91%) Test Automation
4 10 (21.74%) BDD
4 10 (21.74%) Customer-Centricity
4 10 (21.74%) Physics
4 10 (21.74%) TDD
5 4 (8.70%) Business Intelligence
6 3 (6.52%) Deployment Automation
6 3 (6.52%) ITIL
6 3 (6.52%) Scrum
6 3 (6.52%) Software Engineering
7 2 (4.35%) Analytics
7 2 (4.35%) Predictive Modelling
7 2 (4.35%) Problem-Solving
7 2 (4.35%) Software Deployment
7 2 (4.35%) Task Automation
Programming Languages
1 24 (52.17%) PL/SQL
2 13 (28.26%) C#
3 12 (26.09%) JavaScript
4 11 (23.91%) Python
5 10 (21.74%) Tcl
6 3 (6.52%) PowerShell
6 3 (6.52%) T-SQL
7 2 (4.35%) Java
8 1 (2.17%) C
8 1 (2.17%) C++
8 1 (2.17%) Perl
8 1 (2.17%) R
8 1 (2.17%) Shell Script
Qualifications
1 25 (54.35%) Degree
2 2 (4.35%) HND
Systems Management
1 3 (6.52%) Ansible
1 3 (6.52%) Opscode Chef
2 1 (2.17%) HP Quality Center
2 1 (2.17%) Kubernetes
Vendors
1 27 (58.70%) Oracle
2 7 (15.22%) Microsoft
3 2 (4.35%) Tableau
4 1 (2.17%) HP