Period
to 16 February 2019

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 16 February 2019 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
16 Feb 2019
Same period 2018 Same period 2017
Rank 67 48 52
Rank change year-on-year -19 +4 -7
Contract jobs citing T-SQL 9 5 18
As % of all contract IT jobs advertised in Lancashire 1.24% 1.16% 3.03%
As % of the Programming Languages category 2.99% 2.65% 8.11%
Number of daily rates quoted 8 4 16
Lancashire median daily rate £294 £275 £275
Median daily rate % change year-on-year +6.82% - -45.00%
10th Percentile £270 £257 £238
90th Percentile £339 £352 £353
North West median daily rate £375 £325 £325
% change year-on-year +15.38% - -
Number of hourly rates quoted 0 0 0
Lancashire median hourly rate - - -
North West median hourly rate £24.00 £27.00 -
% change year-on-year -11.11% - -

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 301 189 222
As % of all contract IT jobs advertised in Lancashire 41.40% 43.75% 37.37%
Number of daily rates quoted 209 124 157
Lancashire median daily rate £425 £401 £370
Median daily rate % change year-on-year +5.92% +8.45% -1.33%
10th Percentile £258 £263 £263
90th Percentile £625 £543 £530
North West median daily rate £400 £399 £375
% change year-on-year +0.31% +6.33% -
Number of hourly rates quoted 18 21 35
Lancashire median hourly rate £39.50 £42.50 £42.50
Median hourly rate % change year-on-year -7.06% - +6.25%
10th Percentile £11.95 £37.00 £35.38
90th Percentile £44.15 £52.25 £50.00
North West median hourly rate £36.25 £39.00 £40.00
% change year-on-year -7.05% -2.50% +8.11%

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 16 February 2019. 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 -6 2 £300 -16.49% 3
T-SQL
North West

For the 6 months to 16 February 2019, 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 9 (100.00%) SQL
2 6 (66.67%) Migration
2 6 (66.67%) Data Migration
3 5 (55.56%) NHS
4 3 (33.33%) SQL Server Reporting Services
4 3 (33.33%) SystmOne
4 3 (33.33%) SQL Server Integration Services
5 2 (22.22%) ETL
5 2 (22.22%) Data Warehouse
6 1 (11.11%) E-Commerce
6 1 (11.11%) SQL Server
6 1 (11.11%) Microsoft Excel
6 1 (11.11%) Business Intelligence
6 1 (11.11%) C#
6 1 (11.11%) SQL Server 2008
6 1 (11.11%) Power BI
6 1 (11.11%) SQL Server 2014

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:

Applications
1 1 (11.11%) Microsoft Excel
Business Applications
1 3 (33.33%) SystmOne
Database & Business Intelligence
1 3 (33.33%) SQL Server Integration Services
1 3 (33.33%) SQL Server Reporting Services
2 2 (22.22%) Data Warehouse
3 1 (11.11%) Power BI
3 1 (11.11%) SQL Server
3 1 (11.11%) SQL Server 2008
3 1 (11.11%) SQL Server 2014
Job Titles
1 9 (100.00%) Developer
2 7 (77.78%) SQL Developer
3 2 (22.22%) SSRS Developer
4 1 (11.11%) Business Intelligence Developer
4 1 (11.11%) ETL Developer
4 1 (11.11%) SSIS Developer
4 1 (11.11%) T-SQL Developer
Miscellaneous
1 5 (55.56%) NHS
Processes & Methodologies
1 6 (66.67%) Data Migration
1 6 (66.67%) Migration
2 2 (22.22%) ETL
3 1 (11.11%) Business Intelligence
3 1 (11.11%) E-Commerce
Programming Languages
1 9 (100.00%) SQL
2 1 (11.11%) C#