Period
to 19 April 2018

The following table provides summary statistics for permanent job vacancies advertised in West Lothian with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 6 months to 19 April 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
Scotland > West Lothian
6 months to
19 Apr 2018
Same period 2017 Same period 2016
Rank 27 12 13
Rank change year-on-year -15 +1 +4
Permanent jobs citing T-SQL 2 19 15
As % of all permanent IT jobs advertised in West Lothian 2.13% 17.27% 11.03%
As % of the Programming Languages category 2.94% 23.46% 20.55%
Number of salaries quoted 1 15 7
West Lothian median annual salary £45,000 £36,500 £45,000
Median salary % change year-on-year +23.29% -18.89% +28.57%
Scotland median annual salary £40,000 £40,000 £40,000

T-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 68 81 73
As % of all permanent IT jobs advertised in West Lothian 72.34% 73.64% 53.68%
Number of salaries quoted 46 68 40
West Lothian median annual salary £45,000 £40,000 £36,000
Median salary % change year-on-year +12.50% +11.11% +2.86%
10th Percentile £32,500 £25,875 £30,650
90th Percentile £46,375 £50,750 £50,000
Scotland median annual salary £45,000 £42,500 £41,250
% change year-on-year +5.88% +3.03% +3.13%

T-SQL
Job Vacancy Trend in West Lothian

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

Job vacancy trend for T-SQL in West Lothian

T-SQL
Salary Trend in West Lothian

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

Salary trend for T-SQL in West Lothian

T-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 T-SQL within the West Lothian region over the 6 months to 19 April 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 -4 1 - -
T-SQL
Scotland

For the 6 months to 19 April 2018, IT jobs citing T-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 T-SQL.

1 2 (100.00%) SQL
1 2 (100.00%) .NET
1 2 (100.00%) SQL Server
1 2 (100.00%) SQL Server Reporting Services
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) High Availability
2 1 (50.00%) SQL Server 2012
2 1 (50.00%) Elasticsearch
2 1 (50.00%) Performance Tuning
2 1 (50.00%) Re-Platforming
2 1 (50.00%) SQL Optimisation
2 1 (50.00%) SQL Server 2016
2 1 (50.00%) SQL Server 2008
2 1 (50.00%) Test Automation
2 1 (50.00%) Microsoft Azure
2 1 (50.00%) SQL Server 2005
2 1 (50.00%) ASP.NET
2 1 (50.00%) C#

T-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 1 (50.00%) Elasticsearch
Cloud Services
1 1 (50.00%) Microsoft Azure
Database & Business Intelligence
1 2 (100.00%) SQL Server
1 2 (100.00%) SQL Server Integration Services
1 2 (100.00%) SQL Server Reporting Services
2 1 (50.00%) SQL Server 2005
2 1 (50.00%) SQL Server 2008
2 1 (50.00%) SQL Server 2012
2 1 (50.00%) SQL Server 2016
Job Titles
1 2 (100.00%) DBA
1 2 (100.00%) SQL DBA
2 1 (50.00%) Development DBA
2 1 (50.00%) SQL Server DBA
Libraries, Frameworks & Software Standards
1 2 (100.00%) .NET
2 1 (50.00%) ASP.NET
Processes & Methodologies
1 2 (100.00%) High Availability
2 1 (50.00%) Performance Tuning
2 1 (50.00%) Re-Platforming
2 1 (50.00%) SQL Optimisation
2 1 (50.00%) Test Automation
Programming Languages
1 2 (100.00%) SQL
2 1 (50.00%) C#