The following table provides summary statistics for permanent job vacancies advertised in Lancashire with a requirement for T-SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited T-SQL over the 3 months to 22 June 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
North West / Lancashire
3 months to
22 Jun 2017
Same period 2016 Same period 2015
Rank 16 36 52
Rank change year-on-year +20 +16  
Permanent jobs citing T-SQL 50 26 22
As % of all permanent IT jobs advertised in Lancashire 11.34% 5.59% 3.77%
As % of the Programming Languages category 18.25% 9.59% 6.18%
Number of salaries quoted 47 12 20
Median salary £35,000 £32,000 £36,000
Median salary % change year-on-year +9.37% -11.11%  
90% offered a salary of more than £29,400 £27,500 £32,950
10% offered a salary of more than £43,500 £47,200 £40,000
UK excluding London median salary £40,000 £40,500 £40,000
% change year-on-year -1.23% +1.25%  

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Lancashire with a requirement for programming language skills.

Programming Language Skills
Lancashire
Permanent job vacancies with a requirement for programming language skills 274 271 356
As % of all permanent IT job vacancies advertised in Lancashire 62.13% 58.28% 60.96%
Number of salaries quoted 238 226 283
Median salary £35,000 £36,000 £35,000
Median salary % change year-on-year -2.77% +2.85%  
90% offered a salary of more than £28,000 £27,500 £26,000
10% offered a salary of more than £47,500 £45,000 £45,000
UK excluding London median salary £42,500 £41,000 £40,000
% change year-on-year +3.65% +2.50%  

T-SQL
Job Vacancy Trend in Lancashire

The job posting trend of jobs advertised in Lancashire citing T-SQL as a proportion of all permanent or contract IT jobs with a match in the Programming Languages category.

Job vacancy trend for T-SQL in Lancashire

T-SQL
Salary Trend in Lancashire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Lancashire.

Salary trend for T-SQL in Lancashire

T-SQL
Salary Histogram in Lancashire

The salary distribution of IT jobs citing T-SQL in Lancashire over the 3 months to 22 June 2017.

Salary histogram for T-SQL in Lancashire

T-SQL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Lancashire region over the 3 months to 22 June 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
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Burnley +8 23 £32,500 +18.18% 2
Preston -1 11 £35,000 -12.50%
Chorley 0 6 £40,000 +26.98% 2
Blackburn 0 3 £47,500 -1.04%
Blackpool - 2 £40,000 - 1
Ormskirk - 1 £31,500 - 1
Rossendale - 1 £40,000 -
Skelmersdale - 1 £30,000 -
T-SQL
North West

For the 6 months to 22 June 2017, IT 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 job ads across the Lancashire region with a requirement for T-SQL.

1 86 (95.56%) SQL
2 57 (63.33%) .NET
3 48 (53.33%) SQL Server
4 46 (51.11%) JavaScript
5 41 (45.56%) C#
6 30 (33.33%) HTML
6 30 (33.33%) CSS
6 30 (33.33%) jQuery
7 27 (30.00%) Business Intelligence
8 25 (27.78%) Twitter Bootstrap
9 24 (26.67%) TDD
9 24 (26.67%) SQL Server Integration Services
10 21 (23.33%) SQL Server Reporting Services
10 21 (23.33%) Express
10 21 (23.33%) Node.js
11 20 (22.22%) REST
11 20 (22.22%) HTML5
12 19 (21.11%) ASP.NET
12 19 (21.11%) Apache Cordova
13 18 (20.00%) Greenfield Project
14 16 (17.78%) Microsoft
15 15 (16.67%) Degree
15 15 (16.67%) SDLC
15 15 (16.67%) SQL Server 2008
16 14 (15.56%) MVC
17 13 (14.44%) PostgreSQL
18 12 (13.33%) Agile Software Development
18 12 (13.33%) SQL Server 2014
19 11 (12.22%) Clustering
19 11 (12.22%) Python

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 5 (5.56%) IIS
2 3 (3.33%) SharePoint
3 1 (1.11%) CMS
3 1 (1.11%) Drupal
3 1 (1.11%) SAS
3 1 (1.11%) WordPress
Applications
1 6 (6.67%) Microsoft Excel
2 2 (2.22%) Microsoft PowerPoint
2 2 (2.22%) MS Visio
Business Applications
1 3 (3.33%) Dynamics NAV
2 2 (2.22%) Dynamics CRM
3 1 (1.11%) Magento
3 1 (1.11%) OpenCart
3 1 (1.11%) osCommerce
Communications & Networking
1 2 (2.22%) Internet
Database & Business Intelligence
1 48 (53.33%) SQL Server
2 24 (26.67%) SQL Server Integration Services
3 21 (23.33%) SQL Server Reporting Services
4 15 (16.67%) SQL Server 2008
5 13 (14.44%) PostgreSQL
6 12 (13.33%) SQL Server 2014
7 9 (10.00%) SQL Server Analysis Services
8 8 (8.89%) Data Warehouse
9 7 (7.78%) Power BI
10 5 (5.56%) Microsoft Analysis Services
10 5 (5.56%) SQL Server 2012
10 5 (5.56%) SQL Server 2016
11 4 (4.44%) MongoDB
12 2 (2.22%) Data Mining
13 1 (1.11%) MySQL
Development Applications
1 7 (7.78%) Team Foundation Server
2 5 (5.56%) Git (software)
3 4 (4.44%) Visual Studio
4 3 (3.33%) Mercurial
5 1 (1.11%) Bazaar
5 1 (1.11%) PhantomJS
5 1 (1.11%) PHPUnit
5 1 (1.11%) Subversion
General
1 6 (6.67%) Manufacturing
2 4 (4.44%) Finance
3 3 (3.33%) Music Industry
4 2 (2.22%) Advertising
4 2 (2.22%) Marketing
5 1 (1.11%) Pharmaceutical
5 1 (1.11%) Retail
Job Titles
1 69 (76.67%) Developer
2 24 (26.67%) .NET Developer
3 20 (22.22%) SQL Developer
4 18 (20.00%) C# Developer
5 17 (18.89%) C# .NET Developer
6 13 (14.44%) JavaScript Developer
7 11 (12.22%) Analyst
7 11 (12.22%) DBA
8 8 (8.89%) HTML CSS Developer
8 8 (8.89%) HTML Developer
8 8 (8.89%) SQL DBA
8 8 (8.89%) SQL Server Developer
8 8 (8.89%) T-SQL Developer
9 7 (7.78%) Applications Developer
9 7 (7.78%) Front End Developer (Client-Side Developer)
9 7 (7.78%) Node.js Developer
9 7 (7.78%) SSIS Developer
10 6 (6.67%) Data Analyst
11 5 (5.56%) Business Intelligence Developer
11 5 (5.56%) C# Software Developer
Libraries, Frameworks & Software Standards
1 57 (63.33%) .NET
2 30 (33.33%) CSS
2 30 (33.33%) HTML
2 30 (33.33%) jQuery
3 25 (27.78%) Twitter Bootstrap
4 21 (23.33%) Express
4 21 (23.33%) Node.js
5 20 (22.22%) HTML5
5 20 (22.22%) REST
6 19 (21.11%) Apache Cordova
6 19 (21.11%) ASP.NET
7 10 (11.11%) ASP.NET MVC
8 8 (8.89%) XML
9 7 (7.78%) .NET Framework
10 6 (6.67%) SOAP
10 6 (6.67%) WinForms
11 5 (5.56%) WCF
12 4 (4.44%) AngularJS
12 4 (4.44%) Entity Framework
13 3 (3.33%) Razor View Engine
Miscellaneous
1 18 (20.00%) Greenfield Project
2 11 (12.22%) Clustering
3 5 (5.56%) Analytical Skills
3 5 (5.56%) Mobile App
4 4 (4.44%) Replication
5 3 (3.33%) Enterprise Software
5 3 (3.33%) iPad
6 1 (1.11%) Management Information System
6 1 (1.11%) User Experience
Operating Systems
1 4 (4.44%) Windows
2 3 (3.33%) Linux
3 1 (1.11%) Windows Server 2008
3 1 (1.11%) Windows Server 2012
Processes & Methodologies
1 27 (30.00%) Business Intelligence
2 24 (26.67%) TDD
3 15 (16.67%) SDLC
4 14 (15.56%) MVC
5 12 (13.33%) Agile Software Development
6 9 (10.00%) Data Modelling
7 8 (8.89%) Performance Tuning
8 7 (7.78%) Data Architecture
8 7 (7.78%) Front End Development
8 7 (7.78%) High Availability
8 7 (7.78%) Web Development
9 6 (6.67%) Software Engineering
10 5 (5.56%) Analytics
10 5 (5.56%) Data Analytics
10 5 (5.56%) Mobile Application Development
11 4 (4.44%) Continuous Integration
11 4 (4.44%) Dependency Injection
11 4 (4.44%) Performance Monitoring
11 4 (4.44%) Unit Testing
11 4 (4.44%) User Acceptance Testing
Programming Languages
1 86 (95.56%) SQL
2 46 (51.11%) JavaScript
3 41 (45.56%) C#
4 11 (12.22%) Python
5 4 (4.44%) VBA
6 3 (3.33%) C++
7 2 (2.22%) ActionScript
7 2 (2.22%) ActionScript 3.0
7 2 (2.22%) PHP
8 1 (1.11%) Bash Shell
8 1 (1.11%) Perl
8 1 (1.11%) Shell Script
8 1 (1.11%) VB
8 1 (1.11%) VBScript
Qualifications
1 15 (16.67%) Degree
2 2 (2.22%) Microsoft Certification
3 1 (1.11%) MCAD
3 1 (1.11%) MCPD
Quality Assurance & Compliance
1 3 (3.33%) SLA
Vendors
1 16 (17.78%) Microsoft
2 6 (6.67%) DevExpress
3 4 (4.44%) Tableau
4 3 (3.33%) SAP
5 2 (2.22%) Epicor
5 2 (2.22%) Xamarin
6 1 (1.11%) HP
6 1 (1.11%) Oracle
6 1 (1.11%) Zend
Burnley, Lancashire
Greywood Associates Limited
Salary: £40000 - £42000 per annum + bens
Posted: 13 hours ago
Burnley, Lancashire
Fruition IT Resources Limited
Salary: £30000 - £45000 per annum + Benefits
Posted: Yesterday
Blackpool, Lancashire
Dawson & Walsh
Salary: £35000 - £45000 per annum + Bonus + Pension + Benefits
Posted: 3 days ago
Chorley, Lancashire
Verticality Ltd
Salary: Salary £30-35k DOE + extensive benefits
Posted: 3 days ago
Lancashire
Hays Specialist Recruitment Ltd
Salary: £25000.00 - £30000.00 per annum
Posted: 7 days ago
Ormskirk
Hays Specialist Recruitment Ltd
Salary: £28000.00 - £35000.00 per annum
Posted: 10 days ago
Chorley
Applause IT Ltd
Salary: £25000 - £35000 per annum
Posted: 8 days ago