Period
to 19 November 2017

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 November 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
Scotland > West Lothian
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 17 20 27
Rank change year-on-year +3 +7 -11
Permanent jobs citing T-SQL 7 3 2
As % of all permanent IT jobs advertised in West Lothian 7.87% 3.49% 1.30%
As % of the Programming Languages category 11.11% 6.25% 2.74%
Number of salaries quoted 6 3 2
West Lothian median annual salary £31,250 £35,000 £35,000
Median salary % change year-on-year -10.71% - -3.45%
10th Percentile £28,000 £31,500 £30,250
90th Percentile £36,250 £40,500 £39,750
Scotland median annual salary £40,000 £38,000 £40,500
% change year-on-year +5.26% -6.17% -4.71%

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 63 48 73
As % of all permanent IT jobs advertised in West Lothian 70.79% 55.81% 47.40%
Number of salaries quoted 43 43 50
West Lothian median annual salary £40,000 £37,500 £40,000
Median salary % change year-on-year +6.67% -6.25% +7.38%
10th Percentile £24,000 £25,250 £29,925
90th Percentile £47,500 £46,000 £60,625
Scotland median annual salary £42,500 £42,000 £40,000
% change year-on-year +1.19% +5.00% -

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 November 2017. 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 +2 3 £32,500 -
Livingston -3 2 £29,250 -19.31%
T-SQL
Scotland

For the 6 months to 19 November 2017, IT jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the West Lothian region with a requirement for T-SQL.

1 7 (100.00%) SQL
2 5 (71.43%) C#
2 5 (71.43%) .NET
3 4 (57.14%) MVC
3 4 (57.14%) jQuery
3 4 (57.14%) Test Automation
4 3 (42.86%) Unit Testing
4 3 (42.86%) AngularJS
4 3 (42.86%) Twitter Bootstrap
4 3 (42.86%) ASP.NET Web Forms
4 3 (42.86%) SQL Server Reporting Services
4 3 (42.86%) Web Development
4 3 (42.86%) WinForms
4 3 (42.86%) CSS
4 3 (42.86%) HTML
4 3 (42.86%) JavaScript
5 2 (28.57%) SQL Server
5 2 (28.57%) Visual Studio
5 2 (28.57%) ASP.NET
5 2 (28.57%) Data Analysis
6 1 (14.29%) SQL Server Integration Services
6 1 (14.29%) Degree
6 1 (14.29%) WCF
6 1 (14.29%) Agile Software Development
6 1 (14.29%) XML
6 1 (14.29%) Microsoft
6 1 (14.29%) Microsoft Certification
6 1 (14.29%) VB
6 1 (14.29%) SQL Optimisation
6 1 (14.29%) SQL Server 2014

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:

Database & Business Intelligence
1 3 (42.86%) SQL Server Reporting Services
2 2 (28.57%) SQL Server
3 1 (14.29%) SQL Server 2008
3 1 (14.29%) SQL Server 2012
3 1 (14.29%) SQL Server 2014
3 1 (14.29%) SQL Server Integration Services
Development Applications
1 2 (28.57%) Visual Studio
Job Titles
1 5 (71.43%) Developer
2 3 (42.86%) .NET Developer
3 2 (28.57%) Analyst
4 1 (14.29%) ASP.NET Developer
4 1 (14.29%) ASP.NET MVC Developer
4 1 (14.29%) C# .NET Developer
4 1 (14.29%) C# ASP.NET Developer
4 1 (14.29%) C# Developer
4 1 (14.29%) DBA
4 1 (14.29%) Junior
4 1 (14.29%) Junior .NET Developer
4 1 (14.29%) Junior Developer
4 1 (14.29%) Report Analyst
4 1 (14.29%) Software Developer
4 1 (14.29%) SQL DBA
4 1 (14.29%) SQL Developer
4 1 (14.29%) SQL Server DBA
4 1 (14.29%) SQL Server Developer
4 1 (14.29%) SQL Support Analyst
4 1 (14.29%) Support Analyst
Libraries, Frameworks & Software Standards
1 5 (71.43%) .NET
2 4 (57.14%) jQuery
3 3 (42.86%) AngularJS
3 3 (42.86%) ASP.NET Web Forms
3 3 (42.86%) CSS
3 3 (42.86%) HTML
3 3 (42.86%) Twitter Bootstrap
3 3 (42.86%) WinForms
4 2 (28.57%) ASP.NET
5 1 (14.29%) WCF
5 1 (14.29%) XML
Processes & Methodologies
1 4 (57.14%) MVC
1 4 (57.14%) Test Automation
2 3 (42.86%) Unit Testing
2 3 (42.86%) Web Development
3 2 (28.57%) Data Analysis
4 1 (14.29%) Agile Software Development
4 1 (14.29%) High Availability
4 1 (14.29%) SQL Optimisation
Programming Languages
1 7 (100.00%) SQL
2 5 (71.43%) C#
3 3 (42.86%) JavaScript
4 1 (14.29%) VB
Qualifications
1 1 (14.29%) Degree
1 1 (14.29%) Microsoft Certification
Vendors
1 1 (14.29%) Microsoft