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 26 March 2017 with a comparison to the same period in the previous 2 years.

3 months to
26 Mar 2017
Same period 2016 Same period 2015
Transact-SQL
North West / Lancashire
Rank 19 25 51
Rank change year-on-year +6 +26  
Permanent jobs citing T-SQL 39 26 4
As % of all permanent IT jobs advertised in Lancashire 9.42% 7.83% 0.94%
As % of the Programming Languages category 15.73% 14.21% 1.73%
Number of salaries quoted 37 21 4
Median salary £32,500 £40,000 £38,250
Median salary % change year-on-year -18.75% +4.57%  
90% offered a salary of more than £31,500 £26,000 £30,200
10% offered a salary of more than £45,000 £47,500 £40,000
UK excluding London median salary £40,000 £40,000 £40,000

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 248 183 231
As % of all permanent IT job vacancies advertised in Lancashire 59.90% 55.12% 54.23%
Number of salaries quoted 240 161 201
Median salary £35,000 £35,000 £35,000
90% offered a salary of more than £25,000 £26,000 £21,500
10% offered a salary of more than £45,000 £47,500 £45,000
UK excluding London median salary £41,500 £40,500 £40,000
% change year-on-year +2.46% +1.25%  

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 26 March 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 26 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
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Blackpool - 13 £31,500 - 2
Burnley +3 12 £35,000 +16.66% 2
Chorley -1 4 £37,750 -11.17%
Ormskirk - 3 £32,500 -
Blackburn 0 2 £42,500 - 1
Preston -15 2 £43,750 +9.37% 1
Lancaster - 2 £32,000 -
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 26 March 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 76 (91.57%) SQL
2 56 (67.47%) SQL Server
3 43 (51.81%) .NET
4 37 (44.58%) C#
5 35 (42.17%) JavaScript
6 32 (38.55%) SQL Server Integration Services
7 30 (36.14%) Business Intelligence
8 28 (33.73%) Microsoft
9 25 (30.12%) SQL Server Reporting Services
10 22 (26.51%) Power BI
11 20 (24.10%) jQuery
11 20 (24.10%) MVC
11 20 (24.10%) ASP.NET
12 18 (21.69%) Tableau
13 16 (19.28%) VBA
14 15 (18.07%) MS Excel
14 15 (18.07%) HTML
14 15 (18.07%) MDX
14 15 (18.07%) Analytics
15 14 (16.87%) Data Analytics
15 14 (16.87%) Data Analysis
15 14 (16.87%) CSS
16 13 (15.66%) Python
17 12 (14.46%) Twitter Bootstrap
18 11 (13.25%) ASP.NET MVC
18 11 (13.25%) Agile Software Development
18 11 (13.25%) Team Foundation Server
18 11 (13.25%) Data Mining
19 10 (12.05%) Data Modelling
19 10 (12.05%) SQL Server 2008

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 7 (8.43%) SharePoint
2 4 (4.82%) IIS
3 2 (2.41%) CMS
3 2 (2.41%) Drupal
3 2 (2.41%) SAS
3 2 (2.41%) WordPress
4 1 (1.20%) BizTalk Server
Applications
1 15 (18.07%) MS Excel
2 2 (2.41%) MS PowerPoint
2 2 (2.41%) MS Visio
Business Applications
1 2 (2.41%) Dynamics CRM
1 2 (2.41%) Magento
1 2 (2.41%) OpenCart
1 2 (2.41%) osCommerce
Cloud Services
1 4 (4.82%) SaaS
Database & Business Intelligence
1 56 (67.47%) SQL Server
2 32 (38.55%) SQL Server Integration Services
3 25 (30.12%) SQL Server Reporting Services
4 22 (26.51%) Power BI
5 11 (13.25%) Data Mining
6 10 (12.05%) SQL Server 2008
7 6 (7.23%) Data Warehouse
7 6 (7.23%) MySQL
8 5 (6.02%) SQL Server Analysis Services
9 4 (4.82%) Business Intelligence Development Studio
9 4 (4.82%) MongoDB
9 4 (4.82%) SQL Server 2014
10 2 (2.41%) SQL Server 2012
11 1 (1.20%) Enterprise Data Warehouse
11 1 (1.20%) Microsoft Analysis Services
11 1 (1.20%) MS Access
11 1 (1.20%) PostgreSQL
11 1 (1.20%) QlikView
11 1 (1.20%) SQL Server 2016
Development Applications
1 11 (13.25%) Team Foundation Server
2 8 (9.64%) Visual Studio
3 5 (6.02%) Git (software)
4 3 (3.61%) Mercurial
5 2 (2.41%) PHPUnit
6 1 (1.20%) Bazaar
6 1 (1.20%) PhantomJS
6 1 (1.20%) Subversion
General
1 7 (8.43%) Manufacturing
2 3 (3.61%) Advertising
3 2 (2.41%) Marketing
4 1 (1.20%) Finance
4 1 (1.20%) Music Industry
4 1 (1.20%) Pharmaceutical
Job Titles
1 56 (67.47%) Developer
2 29 (34.94%) .NET Developer
3 20 (24.10%) C# Developer
3 20 (24.10%) SQL Developer
4 17 (20.48%) C# .NET Developer
5 16 (19.28%) Analyst
6 14 (16.87%) SQL Analyst
6 14 (16.87%) SQL Data Analyst
7 13 (15.66%) Data Analyst
8 10 (12.05%) SQL Server Analyst
9 9 (10.84%) SSIS Analyst
9 9 (10.84%) SSRS Analyst
10 6 (7.23%) T-SQL Developer
11 5 (6.02%) ASP.NET MVC Developer
11 5 (6.02%) DBA
11 5 (6.02%) SQL DBA
12 4 (4.82%) Senior Developer
12 4 (4.82%) Software Developer
12 4 (4.82%) Software Engineer
12 4 (4.82%) SQL Server Developer
Libraries, Frameworks & Software Standards
1 43 (51.81%) .NET
2 20 (24.10%) ASP.NET
2 20 (24.10%) jQuery
3 15 (18.07%) HTML
3 15 (18.07%) MDX
4 14 (16.87%) CSS
5 12 (14.46%) Twitter Bootstrap
6 11 (13.25%) ASP.NET MVC
7 10 (12.05%) .NET Framework
8 8 (9.64%) REST
9 7 (8.43%) AngularJS
9 7 (8.43%) Entity Framework
9 7 (8.43%) WinForms
10 6 (7.23%) Node.js
11 5 (6.02%) HTML5
11 5 (6.02%) WCF
12 4 (4.82%) XML
13 3 (3.61%) ADO.NET
13 3 (3.61%) SOAP
13 3 (3.61%) XSL
Miscellaneous
1 8 (9.64%) Mobile App
2 5 (6.02%) Clustering
3 4 (4.82%) Enterprise Software
3 4 (4.82%) Smart Meter
4 3 (3.61%) iPad
5 2 (2.41%) Analytical Skills
5 2 (2.41%) User Experience
6 1 (1.20%) Management Information System
6 1 (1.20%) Replication
Operating Systems
1 6 (7.23%) Windows
2 4 (4.82%) Linux
3 3 (3.61%) Windows Server 2008
3 3 (3.61%) Windows Server 2012
Processes & Methodologies
1 30 (36.14%) Business Intelligence
2 20 (24.10%) MVC
3 15 (18.07%) Analytics
4 14 (16.87%) Data Analysis
4 14 (16.87%) Data Analytics
5 11 (13.25%) Agile Software Development
6 10 (12.05%) Data Modelling
7 9 (10.84%) TDD
8 8 (9.64%) Inversion of Control
8 8 (9.64%) Mobile Application Development
8 8 (9.64%) Web Development
9 7 (8.43%) Dependency Injection
9 7 (8.43%) SDLC
10 5 (6.02%) Continuous Integration
10 5 (6.02%) CRM
10 5 (6.02%) E-Commerce
10 5 (6.02%) Performance Tuning
10 5 (6.02%) Software Engineering
11 4 (4.82%) Database Mirroring
11 4 (4.82%) Performance Monitoring
Programming Languages
1 76 (91.57%) SQL
2 37 (44.58%) C#
3 35 (42.17%) JavaScript
4 16 (19.28%) VBA
5 13 (15.66%) Python
6 3 (3.61%) C++
6 3 (3.61%) VB.NET
7 2 (2.41%) ActionScript
7 2 (2.41%) ActionScript 3.0
7 2 (2.41%) Bash Shell
7 2 (2.41%) Perl
7 2 (2.41%) PHP
7 2 (2.41%) Shell Script
8 1 (1.20%) Java
Qualifications
1 6 (7.23%) Degree
2 1 (1.20%) ISEB
2 1 (1.20%) ISTQB
2 1 (1.20%) Microsoft Certification
Vendors
1 28 (33.73%) Microsoft
2 18 (21.69%) Tableau
3 6 (7.23%) DevExpress
4 5 (6.02%) SAP
5 2 (2.41%) Xamarin
5 2 (2.41%) Zend
6 1 (1.20%) Epicor
6 1 (1.20%) HP
6 1 (1.20%) Oracle
Blackpool, Lancashire
Dawson & Walsh
Salary: £35000 - £45000 per annum + Bonus + Pension + Benefits
Posted: 16 hours ago
Blackpool, Lancashire
Dawson & Walsh
Salary: £35000 - £45000 per annum + Bonus + Pension + Benefits
Posted: 16 hours ago
Preston
Nigel Frank International
Salary: £25000 - £32000 per annum + company benefits
Posted: 2 days ago
Blackburn, Lancashire
Oscar
Salary: £35000 - £45000 per annum
Posted: 2 days ago
Burnley, Lancashire
Fruition IT Resources Limited
Salary: £30000 - £35000 per annum + Benefits
Posted: 6 days ago
Burnley
Energize Recruitment Solutions Ltd
Salary: £28000 - £35000 per annum
Posted: 23 days ago