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

Transact-SQL
Scotland > West Lothian
6 months to
23 Jan 2018
Same period 2017 Same period 2016
Rank 21 19 21
Rank change year-on-year -2 +2 +2
Permanent jobs citing T-SQL 5 3 6
As % of all permanent IT jobs advertised in West Lothian 5.62% 3.80% 4.03%
As % of the Programming Languages category 8.77% 6.25% 8.11%
Number of salaries quoted 3 3 2
West Lothian median annual salary £37,500 £32,500 £35,000
Median salary % change year-on-year +15.38% -7.14% -6.67%
10th Percentile £29,250 £29,250 £30,250
90th Percentile £43,750 £37,250 £39,750
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 57 48 74
As % of all permanent IT jobs advertised in West Lothian 64.04% 60.76% 49.66%
Number of salaries quoted 36 42 49
West Lothian median annual salary £40,000 £40,000 £38,500
Median salary % change year-on-year - +3.90% +10.00%
10th Percentile £28,375 £30,000 £29,500
90th Percentile £48,750 £47,425 £54,750
Scotland median annual salary £42,500 £42,500 £40,000
% change year-on-year - +6.25% -

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
Salary Histogram in West Lothian

The salary distribution of IT jobs citing T-SQL in West Lothian over the 6 months to 23 January 2018.

Salary histogram 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 23 January 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
Bathgate +3 1 £30,000 -7.69%
Livingston -4 1 - -
T-SQL
Scotland

For the 6 months to 23 January 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 5 (100.00%) .NET
1 5 (100.00%) SQL
2 4 (80.00%) C#
2 4 (80.00%) SQL Server
3 3 (60.00%) ASP.NET
3 3 (60.00%) SQL Server Integration Services
3 3 (60.00%) SQL Server Reporting Services
3 3 (60.00%) Test Automation
3 3 (60.00%) High Availability
4 2 (40.00%) jQuery
4 2 (40.00%) MVC
4 2 (40.00%) SQL Server 2012
4 2 (40.00%) SQL Optimisation
4 2 (40.00%) SQL Server 2008
5 1 (20.00%) SQL Server 2014
5 1 (20.00%) SQL Server 2016
5 1 (20.00%) AngularJS
5 1 (20.00%) Twitter Bootstrap
5 1 (20.00%) Elasticsearch
5 1 (20.00%) Performance Tuning
5 1 (20.00%) ASP.NET Web Forms
5 1 (20.00%) Re-Platforming
5 1 (20.00%) WinForms
5 1 (20.00%) HTML
5 1 (20.00%) JavaScript
5 1 (20.00%) VB
5 1 (20.00%) CSS
5 1 (20.00%) XML
5 1 (20.00%) Microsoft
5 1 (20.00%) Microsoft Certification

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 (20.00%) Elasticsearch
Cloud Services
1 1 (20.00%) Microsoft Azure
Database & Business Intelligence
1 4 (80.00%) SQL Server
2 3 (60.00%) SQL Server Integration Services
2 3 (60.00%) SQL Server Reporting Services
3 2 (40.00%) SQL Server 2008
3 2 (40.00%) SQL Server 2012
4 1 (20.00%) SQL Server 2005
4 1 (20.00%) SQL Server 2014
4 1 (20.00%) SQL Server 2016
Job Titles
1 3 (60.00%) DBA
1 3 (60.00%) Developer
1 3 (60.00%) SQL DBA
2 2 (40.00%) SQL Server DBA
3 1 (20.00%) .NET Developer
3 1 (20.00%) .NET Software Developer
3 1 (20.00%) ASP.NET Developer
3 1 (20.00%) ASP.NET MVC Developer
3 1 (20.00%) C# .NET Developer
3 1 (20.00%) C# ASP.NET Developer
3 1 (20.00%) C# Developer
3 1 (20.00%) C# Software Developer
3 1 (20.00%) Development DBA
3 1 (20.00%) Software Developer
3 1 (20.00%) SQL Developer
3 1 (20.00%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 5 (100.00%) .NET
2 3 (60.00%) ASP.NET
3 2 (40.00%) jQuery
4 1 (20.00%) AngularJS
4 1 (20.00%) ASP.NET Web Forms
4 1 (20.00%) CSS
4 1 (20.00%) HTML
4 1 (20.00%) Twitter Bootstrap
4 1 (20.00%) WCF
4 1 (20.00%) WinForms
4 1 (20.00%) XML
Processes & Methodologies
1 3 (60.00%) High Availability
1 3 (60.00%) Test Automation
2 2 (40.00%) MVC
2 2 (40.00%) SQL Optimisation
3 1 (20.00%) Agile Software Development
3 1 (20.00%) Performance Tuning
3 1 (20.00%) Re-Platforming
3 1 (20.00%) Unit Testing
3 1 (20.00%) Web Development
Programming Languages
1 5 (100.00%) SQL
2 4 (80.00%) C#
3 1 (20.00%) JavaScript
3 1 (20.00%) VB
Qualifications
1 1 (20.00%) Degree
1 1 (20.00%) Microsoft Certification
Vendors
1 1 (20.00%) Microsoft