Period
to 23 November 2017

The following table provides summary statistics for contract job vacancies advertised in West Lothian with a requirement for T-SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited T-SQL over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

Transact-SQL
Scotland > West Lothian
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 21 19 22
Rank change year-on-year -2 +3 -10
Contract jobs citing T-SQL 1 4 8
As % of all contract IT jobs advertised in West Lothian 1.10% 5.71% 4.76%
As % of the Programming Languages category 2.04% 8.33% 11.76%
Number of daily rates quoted 1 4 8
West Lothian median daily rate £338 £338 £305
Median daily rate % change year-on-year - +10.66% +5.63%
10th Percentile £319 £313 £263
90th Percentile £356 £363 £379
Scotland median daily rate £400 £350 £350
% change year-on-year +14.29% - -6.67%
Number of hourly rates quoted 0 0 0
West Lothian median hourly rate - - -
Scotland median hourly rate £190.00 £46.13 -
% change year-on-year +311.92% - -

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in West Lothian with a requirement for coding skills.

All Programming Languages
West Lothian
Contract vacancies with a requirement for coding skills 49 48 68
As % of all contract IT jobs advertised in West Lothian 53.85% 68.57% 40.48%
Number of daily rates quoted 40 37 49
West Lothian median daily rate £415 £350 £330
Median daily rate % change year-on-year +18.57% +6.06% -12.00%
10th Percentile £318 £307 £265
90th Percentile £434 £435 £406
Scotland median daily rate £388 £350 £350
% change year-on-year +10.71% - -6.67%
Number of hourly rates quoted 0 0 0
West Lothian median hourly rate - - -
Scotland median hourly rate £24.00 £40.00 £37.50
% change year-on-year -40.00% +6.67% +7.14%

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
Contractor Daily Rate Trend in West Lothian

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing T-SQL in West Lothian.

Contractor daily rate trend for T-SQL in West Lothian

T-SQL
Contract Job Locations in West Lothian

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing T-SQL within the West Lothian region over the 6 months to 23 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Livingston -6 1 £338 -3.57%
T-SQL
Scotland

For the 6 months to 23 November 2017, IT contractor 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 contract ads across the West Lothian region with a requirement for T-SQL.

1 1 (100.00%) C#
1 1 (100.00%) SQL
1 1 (100.00%) VB
1 1 (100.00%) VB.NET
1 1 (100.00%) .NET
1 1 (100.00%) SQL Server
1 1 (100.00%) E-Commerce
1 1 (100.00%) RDBMS
1 1 (100.00%) Microsoft
1 1 (100.00%) Retail
1 1 (100.00%) VB6
1 1 (100.00%) SQL Server 2008
1 1 (100.00%) Relational Database
1 1 (100.00%) SDLC

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 1 (100.00%) RDBMS
1 1 (100.00%) Relational Database
1 1 (100.00%) SQL Server
1 1 (100.00%) SQL Server 2008
General
1 1 (100.00%) Retail
Job Titles
1 1 (100.00%) .NET Developer
1 1 (100.00%) Developer
1 1 (100.00%) Systems Developer
Libraries, Frameworks & Software Standards
1 1 (100.00%) .NET
Processes & Methodologies
1 1 (100.00%) E-Commerce
1 1 (100.00%) SDLC
Programming Languages
1 1 (100.00%) C#
1 1 (100.00%) SQL
1 1 (100.00%) VB
1 1 (100.00%) VB.NET
1 1 (100.00%) VB6
Vendors
1 1 (100.00%) Microsoft