The table below looks at the statistics for T-SQL skills in IT contracts advertised for the Lancashire region. Included is a guide to the average contractor rates offered in IT contracts that have cited T-SQL over the 3 months to 12 February 2016 with a comparison to the same period in the previous 2 years.

Note that daily contractor rates and hourly contractor rates are treated separately. When calculating average contractor rates, daily rates are not derived from quoted hourly rates or vice versa.

Location
3 months to
12 Feb 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 42 42 26
Rank change year-on-year
0 -16
Contract jobs citing T-SQL 6 7 8
As % of all contract IT jobs located in Lancashire 1.49% 1.63% 3.31%
As % of the Programming Languages category 3.37% 3.93% 9.41%
Number of daily rates quoted 6 6 7
Average daily rate £450 £350 £200
Average daily rate % change year-on-year
+28.57% +75.00%
90% offered a daily rate of more than £431 £300 £149
10% offered a daily rate of more than £500 £425 £325
UK excluding London average daily rate £350 £325 £301
% change year-on-year
+7.69% +7.88%
Number of hourly rates quoted 0 0 0
Average hourly rate - - -
UK excluding London average hourly rate £32.50 £30.60 £34.00
% change year-on-year
+6.22% -10.01%
T-SQL
North West

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in contract jobs advertised in the Lancashire region.

Programming Languages Category
Lancashire
Contract IT job ads with a match in the
Programming Languages category
178 178 85
As % of all contract IT jobs located in Lancashire 44.28% 41.40% 35.12%
Number of daily rates quoted 125 119 55
Average daily rate £400 £350 £344
Average daily rate % change year-on-year
+14.28% +1.81%
90% offered a daily rate of more than £250 £200 £160
10% offered a daily rate of more than £525 £503 £500
UK excluding London average daily rate £375 £350 £325
% change year-on-year
+7.14% +7.69%
Number of hourly rates quoted 25 10 3
Average hourly rate £40.00 £35.50 £42.00
Average hourly rate % change year-on-year
+12.67% -15.47%
UK excluding London average hourly rate £40.00 £36.00 £34.00
% change year-on-year
+11.11% +5.88%

T-SQL
Jobs Demand Trend in Lancashire

This chart provides a 3-month moving total of IT contractor jobs citing T-SQL across the Lancashire region as a proportion of the total demand within the Programming Languages category.

T-SQL Jobs Demand Trend in Lancashire

T-SQL
Daily Rate Trend in Lancashire

This chart provides the 3-month moving average for daily rates quoted in IT contract jobs citing T-SQL across the Lancashire region.

T-SQL Daily Rate Trend in Lancashire

T-SQL
Hourly Rate Trend in Lancashire

This chart provides the 3-month moving average for hourly rates quoted in IT contractor jobs citing T-SQL across the Lancashire region.

T-SQL Hourly Rate Trend in Lancashire

T-SQL
Contract Job Locations in Lancashire

The table below looks at the demand and provides a guide to the average contractor rates quoted in IT jobs citing T-SQL within the Lancashire region over the 3 months to 12 February 2016. 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
(Use links below to see detailed
statistics and historical trends)
Rank Change
on Same Period
Last Year
Matching
Contract
IT Job Ads
Average
Daily Rate
Last 3 Months
Average Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Blackpool - 5 £450 -
Preston - 1 £413 - 3
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 12 February 2016, IT contractor jobs across the Lancashire region citing T-SQL also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited T-SQL.

1 31 (100.00%) SQL
2 27 (87.10%) SQL Server
3 24 (77.42%) Data Modelling
4 20 (64.52%) Data Warehouse
5 18 (58.06%) SQL Server Reporting Services
6 17 (54.84%) SQL Server Integration Services
7 14 (45.16%) Security Cleared
7 14 (45.16%) Business Intelligence
8 13 (41.94%) Microsoft
8 13 (41.94%) ETL
8 13 (41.94%) PL/SQL
8 13 (41.94%) SQL Server Analysis Services
9 12 (38.71%) Kimball Methodology
9 12 (38.71%) OLAP Cube
9 12 (38.71%) OLAP
9 12 (38.71%) ERwin
10 11 (35.48%) Informatica
10 11 (35.48%) Oracle
10 11 (35.48%) SC Cleared
10 11 (35.48%) Performance Analysis
10 11 (35.48%) SQL Server 2008
10 11 (35.48%) Team Foundation Server
10 11 (35.48%) Dimensional Modelling
11 10 (32.26%) SQL Server 2005
11 10 (32.26%) SQL Server Management Studio (SSMS)
11 10 (32.26%) Visual Studio
11 10 (32.26%) C++
12 9 (29.03%) OLTP
12 9 (29.03%) Data Security
13 6 (19.35%) Unit Testing

T-SQL
Top Related IT Skills in Lancashire by Category

For the 6 months to 12 February 2016, IT contractor jobs across the Lancashire region citing T-SQL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of contract IT job ads sampled that cited T-SQL. Up to 20 skills are shown per category.

Application Platforms
1 2 (6.45%) SharePoint
Database & Business Intelligence
1 27 (87.10%) SQL Server
2 20 (64.52%) Data Warehouse
3 18 (58.06%) SQL Server Reporting Services
4 17 (54.84%) SQL Server Integration Services
5 13 (41.94%) SQL Server Analysis Services
6 12 (38.71%) OLAP
6 12 (38.71%) OLAP Cube
7 11 (35.48%) SQL Server 2008
8 10 (32.26%) SQL Server 2005
9 9 (29.03%) OLTP
10 2 (6.45%) BusinessObjects
10 2 (6.45%) SQL Server 2012
Development Applications
1 12 (38.71%) ERwin
2 11 (35.48%) Team Foundation Server
3 10 (32.26%) SQL Server Management Studio (SSMS)
3 10 (32.26%) Visual Studio
General
1 1 (3.23%) Back Office
Job Titles
1 24 (77.42%) Developer
2 13 (41.94%) Business Intelligence Developer
3 7 (22.58%) Business Developer
3 7 (22.58%) ETL Tester
3 7 (22.58%) Tester
4 5 (16.13%) ETL Developer
4 5 (16.13%) SQL Developer
5 2 (6.45%) Database Developer
5 2 (6.45%) SQL Server Developer
6 1 (3.23%) Administrator
6 1 (3.23%) C++ Developer
6 1 (3.23%) Data Warehouse Developer
6 1 (3.23%) Informatica Developer
6 1 (3.23%) Informatica ETL Developer
6 1 (3.23%) Microsoft BI Developer
6 1 (3.23%) Microsoft Developer
6 1 (3.23%) NHS BI Developer
6 1 (3.23%) SQL BI Developer
6 1 (3.23%) SQL Server BI Developer
Libraries, Frameworks & Software Standards
1 4 (12.90%) Velocity
2 2 (6.45%) .NET
3 1 (3.23%) XML
Miscellaneous
1 6 (19.35%) Statistics
2 4 (12.90%) Algorithms
3 2 (6.45%) Analytical Skills
4 1 (3.23%) Data Extraction
4 1 (3.23%) NHS
Processes & Methodologies
1 24 (77.42%) Data Modelling
2 14 (45.16%) Business Intelligence
3 13 (41.94%) ETL
4 12 (38.71%) Kimball Methodology
5 11 (35.48%) Dimensional Modelling
5 11 (35.48%) Performance Analysis
6 9 (29.03%) Data Security
7 6 (19.35%) Unit Testing
8 5 (16.13%) Test Scripting
9 3 (9.68%) Migration
10 1 (3.23%) Data Management
10 1 (3.23%) Data Migration
10 1 (3.23%) Facilities Management
10 1 (3.23%) GAP Analysis
10 1 (3.23%) Logical Data Model
10 1 (3.23%) Requirements Analysis
10 1 (3.23%) Software Testing
Programming Languages
1 31 (100.00%) SQL
2 13 (41.94%) PL/SQL
3 10 (32.26%) C++
Qualifications
1 14 (45.16%) Security Cleared
2 11 (35.48%) SC Cleared
3 1 (3.23%) BPSS Clearance
3 1 (3.23%) ISEB
Quality Assurance & Compliance
1 3 (9.68%) Data Quality
2 2 (6.45%) Disclosure Scotland
Vendors
1 13 (41.94%) Microsoft
2 11 (35.48%) Informatica
2 11 (35.48%) Oracle