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

SQL (Structured Query Language)
Scotland > West Lothian
6 months to
11 Dec 2018
Same period 2017 Same period 2016
Rank 5 3 7
Rank change year-on-year -2 +4 -4
Permanent jobs citing SQL 62 27 14
As % of all permanent IT jobs advertised in West Lothian 36.05% 31.40% 17.95%
As % of the Programming Languages category 62.00% 46.55% 31.82%
Number of salaries quoted 16 21 12
West Lothian median annual salary £42,500 £40,000 £33,250
Median salary % change year-on-year +6.25% +20.30% -8.28%
10th Percentile £26,125 £24,000 £24,000
90th Percentile £49,875 £45,000 £38,625
Scotland median annual salary £45,000 £40,000 £40,500
% change year-on-year +12.50% -1.23% +1.25%

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 100 58 44
As % of all permanent IT jobs advertised in West Lothian 58.14% 67.44% 56.41%
Number of salaries quoted 40 38 36
West Lothian median annual salary £42,500 £40,000 £37,500
Median salary % change year-on-year +6.25% +6.67% -6.25%
10th Percentile £19,500 £24,000 £25,125
90th Percentile £52,500 £48,250 £45,625
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 11 December 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 11 December 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
Linlithgow - 33 - -
Livingston 0 28 £42,500 +6.25% 5
SQL
Scotland

For the 6 months to 11 December 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 55 (88.71%) Oracle
2 49 (79.03%) PL/SQL
3 36 (58.06%) Finance
4 31 (50.00%) Agile Software Development
5 29 (46.77%) Degree
5 29 (46.77%) Analytical Skills
6 28 (45.16%) Oracle EBS
6 28 (45.16%) Oracle ERP
6 28 (45.16%) ERP
7 25 (40.32%) JavaScript
8 22 (35.48%) Scrum
9 19 (30.65%) Java
9 19 (30.65%) Test Automation
10 18 (29.03%) System Testing
11 17 (27.42%) C#
11 17 (27.42%) ITIL
12 15 (24.19%) Oracle Reports
13 14 (22.58%) XML
13 14 (22.58%) Computer Science
13 14 (22.58%) Software Engineering
14 13 (20.97%) Oracle APEX
15 12 (19.35%) Kanban
15 12 (19.35%) JSON
15 12 (19.35%) Business Intelligence
15 12 (19.35%) Shell Script
15 12 (19.35%) Management Information System
15 12 (19.35%) Python
15 12 (19.35%) C++
15 12 (19.35%) C
15 12 (19.35%) AngularJS

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 11 (17.74%) Confluence
2 6 (9.68%) Apache
2 6 (9.68%) JBoss
2 6 (9.68%) Oracle HTTP Server
3 1 (1.61%) IIS
Applications
1 1 (1.61%) MS Visio
Business Applications
1 28 (45.16%) Oracle EBS
1 28 (45.16%) Oracle ERP
Communications & Networking
1 6 (9.68%) HTTP
1 6 (9.68%) TCP/IP
2 2 (3.23%) Firewall
3 1 (1.61%) Broadband
3 1 (1.61%) Internet
Database & Business Intelligence
1 15 (24.19%) Oracle Reports
2 10 (16.13%) Oracle BI Publisher
2 10 (16.13%) Oracle Discoverer
3 6 (9.68%) Apache Cassandra
4 5 (8.06%) Oracle BI EE
4 5 (8.06%) Oracle OWB
5 2 (3.23%) SQL Server Analysis Services
5 2 (3.23%) SQL Server Integration Services
5 2 (3.23%) SQL Server Reporting Services
6 1 (1.61%) SQL Server
6 1 (1.61%) SQL Server 2008
Development Applications
1 13 (20.97%) Oracle APEX
2 11 (17.74%) JIRA
3 8 (12.90%) Toad
4 6 (9.68%) ClearCase
4 6 (9.68%) CppUnit
4 6 (9.68%) Git (software)
4 6 (9.68%) JUnit
4 6 (9.68%) Team Foundation Server
5 5 (8.06%) Oracle Forms
5 5 (8.06%) ProC
6 2 (3.23%) HP UFT
6 2 (3.23%) Ranorex
6 2 (3.23%) SoapUI
6 2 (3.23%) Visual Studio
7 1 (1.61%) Balsamiq Mockups
General
1 36 (58.06%) Finance
2 8 (12.90%) Retail
Job Titles
1 26 (41.94%) Analyst
2 18 (29.03%) Business Analyst
2 18 (29.03%) Developer
3 14 (22.58%) Technical Analyst
4 13 (20.97%) Oracle Developer
4 13 (20.97%) Technical Business Analyst
5 12 (19.35%) Software Engineer
6 10 (16.13%) Oracle Analyst
7 5 (8.06%) ERP Analyst
7 5 (8.06%) Oracle Business Analyst
7 5 (8.06%) Oracle Specialist
7 5 (8.06%) PL/SQL Developer
7 5 (8.06%) Report Specialist
7 5 (8.06%) SQL Developer
7 5 (8.06%) Test Analyst
8 4 (6.45%) Embedded Engineer
8 4 (6.45%) Embedded Software Engineer
9 3 (4.84%) Developer/Software Engineer
9 3 (4.84%) Software Developer
10 2 (3.23%) SQL Analyst
Libraries, Frameworks & Software Standards
1 14 (22.58%) XML
2 12 (19.35%) AngularJS
2 12 (19.35%) JSON
3 10 (16.13%) jQuery
4 9 (14.52%) HTML
5 8 (12.90%) Ajax
6 6 (9.68%) Kafka
6 6 (9.68%) RESTful
6 6 (9.68%) SOAP
6 6 (9.68%) WebSockets
7 2 (3.23%) .NET
7 2 (3.23%) WCF
8 1 (1.61%) .NET Framework
8 1 (1.61%) ASP.NET
8 1 (1.61%) Web Services
Miscellaneous
1 29 (46.77%) Analytical Skills
2 12 (19.35%) Management Information System
3 2 (3.23%) Embedded Systems
4 1 (1.61%) Fintech
Operating Systems
1 10 (16.13%) Linux
2 3 (4.84%) Windows Server
3 2 (3.23%) Windows
Processes & Methodologies
1 31 (50.00%) Agile Software Development
2 28 (45.16%) ERP
3 22 (35.48%) Scrum
4 19 (30.65%) Test Automation
5 18 (29.03%) System Testing
6 17 (27.42%) ITIL
7 14 (22.58%) Computer Science
7 14 (22.58%) Software Engineering
8 12 (19.35%) Business Intelligence
8 12 (19.35%) Kanban
8 12 (19.35%) Microservices
8 12 (19.35%) Scenario Testing
9 11 (17.74%) Refactoring
10 8 (12.90%) Business Development
11 6 (9.68%) Configuration Management
11 6 (9.68%) Multithreaded Programming
11 6 (9.68%) Multithreading
11 6 (9.68%) Open Source
11 6 (9.68%) Web Application Development
12 5 (8.06%) Functional Testing
Programming Languages
1 49 (79.03%) PL/SQL
2 25 (40.32%) JavaScript
3 19 (30.65%) Java
4 17 (27.42%) C#
5 12 (19.35%) C
5 12 (19.35%) C++
5 12 (19.35%) Python
5 12 (19.35%) Shell Script
6 8 (12.90%) Perl
7 3 (4.84%) T-SQL
8 2 (3.23%) R
8 2 (3.23%) VBScript
Qualifications
1 29 (46.77%) Degree
2 2 (3.23%) HND
Quality Assurance & Compliance
1 5 (8.06%) QA
Systems Management
1 6 (9.68%) Kubernetes
2 2 (3.23%) HP Quality Center
Vendors
1 55 (88.71%) Oracle
2 5 (8.06%) Atlassian
2 5 (8.06%) Microsoft