Period
to 24 June 2018

The following table provides summary statistics for permanent job vacancies advertised in Livingston 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 24 June 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
West Lothian > Livingston
6 months to
24 Jun 2018
Same period 2017 Same period 2016
Rank 18 13 5
Rank change year-on-year -5 -8 +5
Permanent jobs citing T-SQL 2 15 12
As % of all permanent IT jobs advertised in Livingston 3.39% 17.44% 20.34%
As % of the Programming Languages category 4.65% 23.44% 34.29%
Number of salaries quoted 2 12 6
Livingston median annual salary £29,750 £35,250 £45,000
Median salary % change year-on-year -15.60% -21.67% +28.57%
10th Percentile £26,975 £28,750 £38,125
90th Percentile £33,125 £40,750 £48,750
West Lothian median annual salary £29,750 £33,500 £45,000
% change year-on-year -11.19% -25.56% +28.57%

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 Livingston with a requirement for coding skills.

All Programming Languages
Livingston
Permanent vacancies with a requirement for coding skills 43 64 35
As % of all permanent IT jobs advertised in Livingston 72.88% 74.42% 59.32%
Number of salaries quoted 37 54 19
Livingston median annual salary £40,000 £36,500 £37,500
Median salary % change year-on-year +9.59% -2.67% -
10th Percentile £31,000 £24,000 £30,000
90th Percentile £47,850 £52,500 £48,000
West Lothian median annual salary £42,500 £37,500 £37,500
% change year-on-year +13.33% - -

T-SQL
Job Vacancy Trend in Livingston

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

Job vacancy trend for T-SQL in Livingston

T-SQL
Salary Trend in Livingston

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

Salary trend for T-SQL in Livingston

For the 6 months to 24 June 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 Livingston region with a requirement for T-SQL.

1 2 (100.00%) Microsoft
1 2 (100.00%) SQL
2 1 (50.00%) .NET
2 1 (50.00%) SQL Server
2 1 (50.00%) IIS
2 1 (50.00%) Visual Studio
2 1 (50.00%) ASP.NET
2 1 (50.00%) Web Services
2 1 (50.00%) Windows
2 1 (50.00%) Business Intelligence
2 1 (50.00%) C#
2 1 (50.00%) MVC
2 1 (50.00%) Agile Software Development
2 1 (50.00%) SQL Server Reporting Services
2 1 (50.00%) SQL Server Integration Services
2 1 (50.00%) WCF
2 1 (50.00%) jQuery
2 1 (50.00%) SQL Server Analysis Services
2 1 (50.00%) SQL Server 2008
2 1 (50.00%) SQL Server 2012
2 1 (50.00%) Software Delivery
2 1 (50.00%) SQL Server 2014
2 1 (50.00%) Windows Server

T-SQL
Co-occurring IT Skills in Livingston 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%) IIS
Database & Business Intelligence
1 1 (50.00%) SQL Server
1 1 (50.00%) SQL Server 2008
1 1 (50.00%) SQL Server 2012
1 1 (50.00%) SQL Server 2014
1 1 (50.00%) SQL Server Analysis Services
1 1 (50.00%) SQL Server Integration Services
1 1 (50.00%) SQL Server Reporting Services
Development Applications
1 1 (50.00%) Visual Studio
Job Titles
1 1 (50.00%) Analyst
1 1 (50.00%) Developer
1 1 (50.00%) Report Analyst
1 1 (50.00%) Software Developer
1 1 (50.00%) SQL Analyst
1 1 (50.00%) SQL Reporting Analyst
Libraries, Frameworks & Software Standards
1 1 (50.00%) .NET
1 1 (50.00%) ASP.NET
1 1 (50.00%) jQuery
1 1 (50.00%) WCF
1 1 (50.00%) Web Services
Operating Systems
1 1 (50.00%) Windows
1 1 (50.00%) Windows Server
Processes & Methodologies
1 1 (50.00%) Agile Software Development
1 1 (50.00%) Business Intelligence
1 1 (50.00%) MVC
1 1 (50.00%) Software Delivery
Programming Languages
1 2 (100.00%) SQL
2 1 (50.00%) C#
Vendors
1 2 (100.00%) Microsoft