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 22 March 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.

3 months to
22 Mar 2017
Same period 2016 Same period 2015
Transact-SQL
North West / Lancashire
Rank 24 44 40
Rank change year-on-year +20 -4  
Contract jobs citing T-SQL 6 11 5
As % of all contract IT jobs advertised in Lancashire 2.96% 2.52% 1.33%
As % of the Programming Languages category 9.38% 5.67% 3.88%
Number of daily rates quoted 6 10 4
Median daily rate £275 £450 £400
Median daily rate % change year-on-year -38.88% +12.50%  
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 £20.75 £32.50 £30.60
% change year-on-year -36.15% +6.22%  

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 64 194 129
As % of all contract IT job vacancies advertised in Lancashire 31.53% 44.50% 34.22%
Number of daily rates quoted 32 127 80
Median daily rate £325 £375 £350
Median daily rate % change year-on-year -13.33% +7.14%  
90% offered a daily rate of more than £275 £250 £200
10% offered a daily rate of more than £425 £578 £520
UK excluding London median daily rate £388 £375 £350
% change year-on-year +3.33% +7.14%  
Number of hourly rates quoted 19 27 10
Median hourly rate £43.00 £41.50 £45.50
Median hourly rate % change year-on-year +3.61% -8.79%  
90% offered a hourly rate of more than £39.00 £35.40 £35.50
10% offered a hourly rate of more than £55.00 £47.33 £46.09
UK excluding London median hourly rate £41.64 £40.00 £36.00
% change year-on-year +4.10% +11.11%  

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 hourly rates quoted in IT contractor 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 22 March 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
Fleetwood - 4 £275 -
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 22 March 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 15 (93.75%) SQL
2 14 (87.50%) .NET
3 13 (81.25%) VB.NET
3 13 (81.25%) HTML
3 13 (81.25%) XML
3 13 (81.25%) CSS
3 13 (81.25%) SQL Server Reporting Services
3 13 (81.25%) SQL Server Integration Services
4 10 (62.50%) VB
5 9 (56.25%) XSD
5 9 (56.25%) XSL
6 8 (50.00%) VB6
7 7 (43.75%) SQL Server
8 6 (37.50%) SQL Server 2012
9 5 (31.25%) SQL Server 2008
9 5 (31.25%) ASP.NET
9 5 (31.25%) Microsoft
10 4 (25.00%) LINQ
10 4 (25.00%) Web Services
10 4 (25.00%) C#
10 4 (25.00%) JavaScript
11 3 (18.75%) ADO.NET
11 3 (18.75%) Classic ASP
11 3 (18.75%) ITIL
11 3 (18.75%) MVC
11 3 (18.75%) SQL Server 2005
11 3 (18.75%) LINQ to SQL
12 2 (12.50%) Entity Framework
12 2 (12.50%) ASP.NET MVC 3
12 2 (12.50%) Web Application Development

T-SQL
Top Related 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 (6.25%) Apache
1 1 (6.25%) BizTalk Server
1 1 (6.25%) IIS
1 1 (6.25%) SAS
1 1 (6.25%) SharePoint
Business Applications
1 1 (6.25%) Cognos Business Intelligence
Communications & Networking
1 1 (6.25%) Firewall
Database & Business Intelligence
1 13 (81.25%) SQL Server Integration Services
1 13 (81.25%) SQL Server Reporting Services
2 7 (43.75%) SQL Server
3 6 (37.50%) SQL Server 2012
4 5 (31.25%) SQL Server 2008
5 3 (18.75%) SQL Server 2005
6 2 (12.50%) Data Warehouse
7 1 (6.25%) Cognos Framework Manager
7 1 (6.25%) Cognos Report Studio
7 1 (6.25%) MySQL
7 1 (6.25%) Oracle Database
7 1 (6.25%) Oracle Database 12c
7 1 (6.25%) RDBMS
7 1 (6.25%) Relational Database
7 1 (6.25%) SQL Server Analysis Services
Development Applications
1 2 (12.50%) Team Foundation Server
1 2 (12.50%) Visual Studio
2 1 (6.25%) SQL Server Management Studio (SSMS)
General
1 1 (6.25%) Advertising
1 1 (6.25%) Finance
Job Titles
1 15 (93.75%) Developer
2 13 (81.25%) .NET Developer
3 10 (62.50%) VB.NET Developer
4 1 (6.25%) Cognos Developer
4 1 (6.25%) DBA
4 1 (6.25%) Oracle DBA
4 1 (6.25%) Oracle SQL Server DBA
4 1 (6.25%) SQL DBA
4 1 (6.25%) SQL Developer
4 1 (6.25%) SQL Server DBA
4 1 (6.25%) SSIS Developer
4 1 (6.25%) SSRS Developer
Libraries, Frameworks & Software Standards
1 14 (87.50%) .NET
2 13 (81.25%) CSS
2 13 (81.25%) HTML
2 13 (81.25%) XML
3 9 (56.25%) XSD
3 9 (56.25%) XSL
4 5 (31.25%) ASP.NET
5 4 (25.00%) LINQ
5 4 (25.00%) Web Services
6 3 (18.75%) ADO.NET
6 3 (18.75%) Classic ASP
6 3 (18.75%) LINQ to SQL
7 2 (12.50%) .NET Framework
7 2 (12.50%) ASP.NET MVC
7 2 (12.50%) ASP.NET MVC 3
7 2 (12.50%) Entity Framework
7 2 (12.50%) WCF
8 1 (6.25%) HTML5
8 1 (6.25%) jQuery
8 1 (6.25%) WPF
Miscellaneous
1 2 (12.50%) Analytical Skills
2 1 (6.25%) Oracle Licensing
Operating Systems
1 1 (6.25%) CentOS
1 1 (6.25%) Linux
Processes & Methodologies
1 3 (18.75%) ITIL
1 3 (18.75%) MVC
2 2 (12.50%) Business Intelligence
2 2 (12.50%) Web Application Development
3 1 (6.25%) Agile Software Development
3 1 (6.25%) Analytics
3 1 (6.25%) Data Extraction
3 1 (6.25%) Data Modelling
3 1 (6.25%) ETL
3 1 (6.25%) Information Management
3 1 (6.25%) ITIL V3
3 1 (6.25%) ITSM
3 1 (6.25%) Kimball Methodology
3 1 (6.25%) Performance Optimisation
3 1 (6.25%) Project Management
3 1 (6.25%) Service Delivery
3 1 (6.25%) Service Management
3 1 (6.25%) Software Licensing
3 1 (6.25%) Waterfall
Programming Languages
1 15 (93.75%) SQL
2 13 (81.25%) VB.NET
3 10 (62.50%) VB
4 8 (50.00%) VB6
5 4 (25.00%) C#
5 4 (25.00%) JavaScript
6 1 (6.25%) PHP
6 1 (6.25%) PL/SQL
6 1 (6.25%) VBScript
Qualifications
1 2 (12.50%) HNC
1 2 (12.50%) ITIL Foundation Certificate
2 1 (6.25%) CESG Certified Professional
2 1 (6.25%) Citrix Certification
2 1 (6.25%) MCSE
2 1 (6.25%) Microsoft Certification
2 1 (6.25%) VMware Certified Professional (VCP)
System Software
1 1 (6.25%) MetaFrame
1 1 (6.25%) VMware Infrastructure
Vendors
1 5 (31.25%) Microsoft
2 1 (6.25%) Citrix
2 1 (6.25%) Cognos
2 1 (6.25%) Oracle
2 1 (6.25%) VMware
Chorley, Lancashire
FT Select
Rate: From £35,000 to £40,000 per annum plus benefits
Posted: 5 days ago