Period
to 18 November 2018

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 6 months to 18 November 2018 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
6 months to
18 Nov 2018
Same period 2017 Same period 2016
Rank 61 44 45
Rank change year-on-year -17 +1 -19
Contract jobs citing T-SQL 7 7 22
As % of all contract IT jobs advertised in Lancashire 1.04% 1.54% 3.32%
As % of the Programming Languages category 2.43% 4.49% 8.27%
Number of daily rates quoted 5 7 16
Lancashire median daily rate £270 £275 £275
Median daily rate % change year-on-year -1.82% - -45.81%
10th Percentile £212 £256 £229
90th Percentile £309 £369 £344
North West median daily rate £350 £360 £325
% change year-on-year -2.78% +10.77% -7.14%
Number of hourly rates quoted 0 0 2
Lancashire median hourly rate - - £25.00
North West median hourly rate £24.00 £27.00 £25.00
% change year-on-year -11.11% +8.00% -26.47%

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

All Programming Languages
Lancashire
Contract vacancies with a requirement for coding skills 288 156 266
As % of all contract IT jobs advertised in Lancashire 42.79% 34.36% 40.18%
Number of daily rates quoted 209 103 180
Lancashire median daily rate £450 £400 £375
Median daily rate % change year-on-year +12.50% +6.67% -6.25%
10th Percentile £258 £300 £263
90th Percentile £599 £615 £480
North West median daily rate £400 £400 £375
% change year-on-year - +6.67% -
Number of hourly rates quoted 9 24 24
Lancashire median hourly rate £36.23 £42.50 £39.13
Median hourly rate % change year-on-year -14.76% +8.63% +5.74%
10th Percentile £11.00 £37.00 £14.08
90th Percentile £42.50 £50.83 £42.50
North West median hourly rate £33.75 £40.00 £29.53
% change year-on-year -15.63% +35.48% -21.27%

T-SQL
Job Vacancy Trend in Lancashire

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

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 Daily Rate Histogram in Lancashire

The daily rate distribution of IT jobs citing T-SQL in Lancashire over the 6 months to 18 November 2018.

Contractor daily rate histogram 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 6 months to 18 November 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Preston +4 4 £288 -23.33% 4
Blackburn - 1 - - 1
T-SQL
North West

For the 6 months to 18 November 2018, IT contractor 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 contract job ads across the Lancashire region with a requirement for T-SQL.

1 7 (100.00%) SQL
2 3 (42.86%) SQL Server
2 3 (42.86%) Microsoft
3 2 (28.57%) NHS
3 2 (28.57%) OO
3 2 (28.57%) C#
3 2 (28.57%) JavaScript
3 2 (28.57%) SQL Server Reporting Services
3 2 (28.57%) MVC
3 2 (28.57%) Migration
3 2 (28.57%) jQuery
3 2 (28.57%) Data Migration
4 1 (14.29%) PowerShell
4 1 (14.29%) Test Automation
4 1 (14.29%) Inversion of Control
4 1 (14.29%) Entity Framework
4 1 (14.29%) Redis
4 1 (14.29%) NServiceBus
4 1 (14.29%) SQL Server 2012
4 1 (14.29%) AngularJS
4 1 (14.29%) SignalR
4 1 (14.29%) AutoMapper
4 1 (14.29%) Twitter Bootstrap
4 1 (14.29%) Performance Monitoring
4 1 (14.29%) ASP.NET Web API
4 1 (14.29%) Data Centre
4 1 (14.29%) Power BI
4 1 (14.29%) Windows Server
4 1 (14.29%) Task Automation
4 1 (14.29%) Atlassian Bamboo

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:

Application Platforms
1 1 (14.29%) NServiceBus
Applications
1 1 (14.29%) Microsoft Excel
Database & Business Intelligence
1 3 (42.86%) SQL Server
2 2 (28.57%) SQL Server Reporting Services
3 1 (14.29%) Data Warehouse
3 1 (14.29%) MySQL
3 1 (14.29%) Power BI
3 1 (14.29%) Redis
3 1 (14.29%) SQL Server 2012
3 1 (14.29%) SQL Server Integration Services
Development Applications
1 1 (14.29%) Atlassian Bamboo
1 1 (14.29%) Visual Studio
Job Titles
1 6 (85.71%) Developer
2 2 (28.57%) SQL Developer
3 1 (14.29%) Business Intelligence Developer
3 1 (14.29%) C# Developer
3 1 (14.29%) DBA
3 1 (14.29%) Software Developer
3 1 (14.29%) SQL DBA
3 1 (14.29%) SSRS Developer
Libraries, Frameworks & Software Standards
1 2 (28.57%) jQuery
2 1 (14.29%) .NET
2 1 (14.29%) Ajax
2 1 (14.29%) AngularJS
2 1 (14.29%) ASP.NET Web API
2 1 (14.29%) AutoMapper
2 1 (14.29%) CSS
2 1 (14.29%) Entity Framework
2 1 (14.29%) HTML
2 1 (14.29%) SignalR
2 1 (14.29%) Twitter Bootstrap
Miscellaneous
1 2 (28.57%) NHS
2 1 (14.29%) Data Centre
Operating Systems
1 1 (14.29%) Windows
1 1 (14.29%) Windows Server
1 1 (14.29%) Windows Server 2003
Processes & Methodologies
1 2 (28.57%) Data Migration
1 2 (28.57%) Migration
1 2 (28.57%) MVC
1 2 (28.57%) OO
2 1 (14.29%) Agile Software Development
2 1 (14.29%) Business Intelligence
2 1 (14.29%) ETL
2 1 (14.29%) Inversion of Control
2 1 (14.29%) Performance Monitoring
2 1 (14.29%) Task Automation
2 1 (14.29%) TDD
2 1 (14.29%) Test Automation
Programming Languages
1 7 (100.00%) SQL
2 2 (28.57%) C#
2 2 (28.57%) JavaScript
3 1 (14.29%) PHP
3 1 (14.29%) PowerShell
Vendors
1 3 (42.86%) Microsoft