Period
to 19 November 2017

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 19 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
North West > Lancashire
6 months to
19 Nov 2017
Same period 2016 Same period 2015
Rank 46 43 26
Rank change year-on-year -3 -17 +24
Contract jobs citing T-SQL 6 22 55
As % of all contract IT jobs advertised in Lancashire 1.34% 3.34% 5.98%
As % of the Programming Languages category 3.92% 8.27% 16.87%
Number of daily rates quoted 6 16 64
Lancashire median daily rate £306 £275 £508
Median daily rate % change year-on-year +11.36% -45.81% +69.17%
10th Percentile £259 £229 £288
90th Percentile £372 £344 £600
North West median daily rate £363 £325 £350
% change year-on-year +11.54% -7.14% +16.67%
Number of hourly rates quoted 0 2 0
Lancashire median hourly rate - £25.00 -
North West median hourly rate £27.00 £25.00 £34.00
% change year-on-year +8.00% -26.47% +61.90%

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 153 266 326
As % of all contract IT jobs advertised in Lancashire 34.15% 40.36% 35.47%
Number of daily rates quoted 101 180 211
Lancashire median daily rate £400 £375 £400
Median daily rate % change year-on-year +6.67% -6.25% +18.08%
10th Percentile £300 £263 £210
90th Percentile £615 £480 £535
North West median daily rate £400 £375 £375
% change year-on-year +6.67% - +15.38%
Number of hourly rates quoted 24 24 25
Lancashire median hourly rate £42.50 £39.13 £37.00
Median hourly rate % change year-on-year +8.63% +5.74% +18.59%
10th Percentile £37.00 £14.08 £31.45
90th Percentile £50.83 £42.50 £47.33
North West median hourly rate £40.00 £29.01 £37.50
% change year-on-year +37.87% -22.63% +31.87%

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 19 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
Preston -10 1 £375 +20.00% 1
T-SQL
North West

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

1 6 (100.00%) SQL
1 6 (100.00%) Business Intelligence
2 5 (83.33%) SQL Server
2 5 (83.33%) SQL Server Integration Services
3 3 (50.00%) Data Warehouse
3 3 (50.00%) SQL Server Analysis Services
3 3 (50.00%) SQL Server Reporting Services
4 2 (33.33%) CRM
4 2 (33.33%) Dynamics AX
5 1 (16.67%) Security Cleared
5 1 (16.67%) Cognos Report Studio
5 1 (16.67%) Cognos Framework Manager
5 1 (16.67%) Cognos
5 1 (16.67%) MDX
5 1 (16.67%) Cognos Business Intelligence

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 2 (33.33%) Dynamics AX
2 1 (16.67%) Cognos Business Intelligence
Database & Business Intelligence
1 5 (83.33%) SQL Server
1 5 (83.33%) SQL Server Integration Services
2 3 (50.00%) Data Warehouse
2 3 (50.00%) SQL Server Analysis Services
2 3 (50.00%) SQL Server Reporting Services
3 1 (16.67%) Cognos Framework Manager
3 1 (16.67%) Cognos Report Studio
Job Titles
1 6 (100.00%) Developer
2 4 (66.67%) Business Intelligence Developer
2 4 (66.67%) SQL Developer
3 3 (50.00%) SQL BI Developer
4 2 (33.33%) Dynamics AX Developer
5 1 (16.67%) Cognos BI Developer
5 1 (16.67%) Cognos Developer
5 1 (16.67%) SSRS Developer
Libraries, Frameworks & Software Standards
1 1 (16.67%) MDX
Processes & Methodologies
1 6 (100.00%) Business Intelligence
2 2 (33.33%) CRM
Programming Languages
1 6 (100.00%) SQL
Qualifications
1 1 (16.67%) Security Cleared
Vendors
1 1 (16.67%) Cognos