Period
to 26 September 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 26 September 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
26 Sep 2018
Same period 2017 Same period 2016
Rank 62 47 54
Rank change year-on-year -15 +7 -32
Contract jobs citing T-SQL 4 8 14
As % of all contract IT jobs advertised in Lancashire 0.63% 1.39% 1.86%
As % of the Programming Languages category 1.69% 5.56% 4.58%
Number of daily rates quoted 2 8 8
Lancashire median daily rate £231 £281 £263
Median daily rate % change year-on-year -17.78% +7.14% -46.70%
10th Percentile £183 £251 £227
90th Percentile £282 £366 £334
North West median daily rate £350 £361 £325
% change year-on-year -3.11% +11.15% -5.80%
Number of hourly rates quoted 0 0 2
Lancashire median hourly rate - - £25.00
North West median hourly rate £55.00 £27.00 £25.00
% change year-on-year +103.70% +8.00% +28.21%

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 236 144 306
As % of all contract IT jobs advertised in Lancashire 37.05% 24.96% 40.75%
Number of daily rates quoted 177 88 187
Lancashire median daily rate £470 £375 £390
Median daily rate % change year-on-year +25.33% -3.85% -2.50%
10th Percentile £264 £261 £263
90th Percentile £574 £615 £500
North West median daily rate £400 £395 £375
% change year-on-year +1.27% +5.33% -
Number of hourly rates quoted 12 23 25
Lancashire median hourly rate £40.13 £41.50 £37.50
Median hourly rate % change year-on-year -3.31% +10.67% +1.35%
10th Percentile £13.44 £36.38 £14.35
90th Percentile £43.00 £44.00 £42.50
North West median hourly rate £35.00 £39.13 £28.50
% change year-on-year -10.54% +37.28% -22.97%

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 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 26 September 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 +22 3 £231 -30.19% 2
Blackburn - 1 - - 3
T-SQL
North West

For the 6 months to 26 September 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 4 (100.00%) SQL
2 3 (75.00%) Microsoft
2 3 (75.00%) SQL Server
3 2 (50.00%) C#
3 2 (50.00%) JavaScript
3 2 (50.00%) OO
3 2 (50.00%) jQuery
3 2 (50.00%) MVC
4 1 (25.00%) Agile Software Development
4 1 (25.00%) TDD
4 1 (25.00%) SQL Server Reporting Services
4 1 (25.00%) Ajax
4 1 (25.00%) SQL Server Integration Services
4 1 (25.00%) Atlassian Bamboo
4 1 (25.00%) PowerShell
4 1 (25.00%) Test Automation
4 1 (25.00%) Inversion of Control
4 1 (25.00%) Entity Framework
4 1 (25.00%) Redis
4 1 (25.00%) NServiceBus
4 1 (25.00%) SQL Server 2012
4 1 (25.00%) AngularJS
4 1 (25.00%) SignalR
4 1 (25.00%) AutoMapper
4 1 (25.00%) Twitter Bootstrap
4 1 (25.00%) Performance Monitoring
4 1 (25.00%) ASP.NET Web API
4 1 (25.00%) Data Centre
4 1 (25.00%) Power BI
4 1 (25.00%) Windows Server

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 (25.00%) NServiceBus
Database & Business Intelligence
1 3 (75.00%) SQL Server
2 1 (25.00%) MySQL
2 1 (25.00%) Power BI
2 1 (25.00%) Redis
2 1 (25.00%) SQL Server 2012
2 1 (25.00%) SQL Server Integration Services
2 1 (25.00%) SQL Server Reporting Services
Development Applications
1 1 (25.00%) Atlassian Bamboo
1 1 (25.00%) Visual Studio
Job Titles
1 3 (75.00%) Developer
2 1 (25.00%) Business Intelligence Developer
2 1 (25.00%) C# Developer
2 1 (25.00%) DBA
2 1 (25.00%) Software Developer
2 1 (25.00%) SQL DBA
Libraries, Frameworks & Software Standards
1 2 (50.00%) jQuery
2 1 (25.00%) .NET
2 1 (25.00%) Ajax
2 1 (25.00%) AngularJS
2 1 (25.00%) ASP.NET Web API
2 1 (25.00%) AutoMapper
2 1 (25.00%) CSS
2 1 (25.00%) Entity Framework
2 1 (25.00%) HTML
2 1 (25.00%) SignalR
2 1 (25.00%) Twitter Bootstrap
Miscellaneous
1 1 (25.00%) Data Centre
Operating Systems
1 1 (25.00%) Windows
1 1 (25.00%) Windows Server
1 1 (25.00%) Windows Server 2003
Processes & Methodologies
1 2 (50.00%) MVC
1 2 (50.00%) OO
2 1 (25.00%) Agile Software Development
2 1 (25.00%) Business Intelligence
2 1 (25.00%) ETL
2 1 (25.00%) Inversion of Control
2 1 (25.00%) Performance Monitoring
2 1 (25.00%) Task Automation
2 1 (25.00%) TDD
2 1 (25.00%) Test Automation
Programming Languages
1 4 (100.00%) SQL
2 2 (50.00%) C#
2 2 (50.00%) JavaScript
3 1 (25.00%) PHP
3 1 (25.00%) PowerShell
Vendors
1 3 (75.00%) Microsoft