The following table provides summary statistics for contract job vacancies advertised in Lancashire 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 3 months to 24 June 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
North West / Lancashire
3 months to
24 Jun 2017
Same period 2016 Same period 2015
Rank 38 49 35
Rank change year-on-year +11 -14  
Contract jobs citing T-SQL 5 1 15
As % of all contract IT jobs advertised in Lancashire 1.51% 0.22% 3.75%
As % of the Programming Languages category 7.04% 0.56% 9.38%
Number of daily rates quoted 5 1 10
Median daily rate £263 £225 £275
Median daily rate % change year-on-year +16.66% -18.18%  
90% offered a daily rate of more than £255 £225 £213
10% offered a daily rate of more than £318 £225 £430
UK excluding London median daily rate £350 £350 £325
% change year-on-year - +7.69%  
Number of hourly rates quoted 0 0 0
Median hourly rate - - -
UK excluding London median hourly rate £37.50 £29.00 £20.59
% change year-on-year +29.31% +40.82%  

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Lancashire with a requirement for programming language skills.

Contract Programming Language Skills
Lancashire
Contract job vacancies with a requirement for programming language skills 71 180 160
As % of all contract IT job vacancies advertised in Lancashire 21.39% 40.36% 40.00%
Number of daily rates quoted 35 110 110
Median daily rate £325 £400 £375
Median daily rate % change year-on-year -18.75% +6.66%  
90% offered a daily rate of more than £255 £283 £263
10% offered a daily rate of more than £425 £490 £545
UK excluding London median daily rate £400 £375 £350
% change year-on-year +6.66% +7.14%  
Number of hourly rates quoted 18 11 5
Median hourly rate £42.50 £33.50 £37.00
Median hourly rate % change year-on-year +26.86% -9.45%  
UK excluding London median hourly rate £42.50 £37.50 £36.50
% change year-on-year +13.33% +2.73%  

T-SQL
Job Vacancy Trend in Lancashire

The job posting trend of jobs advertised in Lancashire citing T-SQL as a proportion of all contract or permanent IT jobs with a match in the Programming Languages category.

Job vacancy trend for T-SQL in Lancashire

T-SQL
Contractor Daily Rate Trend in Lancashire

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

Contractor daily rate trend for T-SQL in Lancashire

T-SQL
Contractor Hourly Rate Trend in Lancashire

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing T-SQL in Lancashire.

Contractor hourly rate trend for T-SQL in Lancashire

T-SQL
Contract Job Locations in Lancashire

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 Lancashire region over the 3 months to 24 June 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Median
Daily Rate
Last 3 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Preston - 1 £288 -
T-SQL
North West

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

1 11 (100.00%) SQL
2 8 (72.73%) SQL Server Reporting Services
3 7 (63.64%) HTML
3 7 (63.64%) .NET
3 7 (63.64%) CSS
4 6 (54.55%) XML
4 6 (54.55%) SQL Server
4 6 (54.55%) VB
4 6 (54.55%) VB.NET
4 6 (54.55%) SQL Server Integration Services
5 4 (36.36%) VB6
5 4 (36.36%) Business Intelligence
5 4 (36.36%) XSD
5 4 (36.36%) XSL
6 3 (27.27%) CRM
6 3 (27.27%) Data Warehouse
6 3 (27.27%) JavaScript
6 3 (27.27%) MVC
6 3 (27.27%) C#
6 3 (27.27%) .NET Framework
6 3 (27.27%) Entity Framework
7 2 (18.18%) LINQ to SQL
7 2 (18.18%) ASP.NET MVC 3
7 2 (18.18%) Web Application Development
7 2 (18.18%) SQL Server 2012
7 2 (18.18%) LINQ
7 2 (18.18%) SQL Server Analysis Services
7 2 (18.18%) SQL Server 2008
7 2 (18.18%) ASP.NET MVC
7 2 (18.18%) ITIL Foundation Certificate

T-SQL
Co-occurring IT Skills in Lancashire 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:

Business Applications
1 1 (9.09%) Dynamics AX
Database & Business Intelligence
1 8 (72.73%) SQL Server Reporting Services
2 6 (54.55%) SQL Server
2 6 (54.55%) SQL Server Integration Services
3 3 (27.27%) Data Warehouse
4 2 (18.18%) SQL Server 2005
4 2 (18.18%) SQL Server 2008
4 2 (18.18%) SQL Server 2012
4 2 (18.18%) SQL Server Analysis Services
5 1 (9.09%) Power BI
Development Applications
1 1 (9.09%) Visual Studio
Job Titles
1 11 (100.00%) Developer
2 7 (63.64%) .NET Developer
3 4 (36.36%) VB.NET Developer
4 2 (18.18%) SQL Developer
4 2 (18.18%) SSRS Developer
5 1 (9.09%) Business Intelligence Developer
5 1 (9.09%) Dynamics AX Developer
5 1 (9.09%) SQL BI Developer
Libraries, Frameworks & Software Standards
1 7 (63.64%) .NET
1 7 (63.64%) CSS
1 7 (63.64%) HTML
2 6 (54.55%) XML
3 4 (36.36%) XSD
3 4 (36.36%) XSL
4 3 (27.27%) .NET Framework
4 3 (27.27%) Entity Framework
5 2 (18.18%) ADO.NET
5 2 (18.18%) ASP.NET
5 2 (18.18%) ASP.NET MVC
5 2 (18.18%) ASP.NET MVC 3
5 2 (18.18%) Classic ASP
5 2 (18.18%) LINQ
5 2 (18.18%) LINQ to SQL
5 2 (18.18%) WCF
5 2 (18.18%) Web Services
6 1 (9.09%) ASP.NET Web API
6 1 (9.09%) MDX
6 1 (9.09%) WPF
Miscellaneous
1 2 (18.18%) Analytical Skills
Processes & Methodologies
1 4 (36.36%) Business Intelligence
2 3 (27.27%) CRM
2 3 (27.27%) MVC
3 2 (18.18%) ITIL
3 2 (18.18%) Web Application Development
Programming Languages
1 11 (100.00%) SQL
2 6 (54.55%) VB
2 6 (54.55%) VB.NET
3 4 (36.36%) VB6
4 3 (27.27%) C#
4 3 (27.27%) JavaScript
Qualifications
1 2 (18.18%) HNC
1 2 (18.18%) ITIL Foundation Certificate
Vendors
1 2 (18.18%) Microsoft