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

3 months to
3 May 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 26 46 25
Rank change year-on-year
+20 -21
Permanent jobs citing T-SQL 33 15 37
As % of all permanent IT jobs located in Lancashire 8.15% 3.31% 8.33%
As % of the Programming Languages category 14.16% 5.58% 14.51%
Number of salaries quoted 24 14 35
Median salary £37,500 £36,250 £35,000
Median salary % change year-on-year
+3.44% +3.57%
90% offered a salary of more than £26,000 £31,100 £24,500
10% offered a salary of more than £47,850 £40,000 £42,500
UK excluding London median salary £40,000 £40,000 £38,000
% change year-on-year
- +5.26%
T-SQL
North West

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

Programming Languages Category
Lancashire
Permanent IT job ads with a match in the
Programming Languages category
233 269 255
As % of all permanent IT jobs located in Lancashire 57.53% 59.38% 57.43%
Number of salaries quoted 206 213 228
Median salary £35,000 £35,000 £35,000
90% offered a salary of more than £26,000 £25,000 £25,000
10% offered a salary of more than £45,000 £50,500 £45,000
UK excluding London median salary £41,000 £40,000 £39,250
% change year-on-year
+2.50% +1.91%

T-SQL
Jobs Demand Trend in Lancashire

The demand trend of job ads across the Lancashire region citing T-SQL as a proportion of all IT jobs with a match in the Programming Languages category.

T-SQL Jobs Demand Trend 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 across the Lancashire region.

T-SQL Salary Trend in Lancashire

T-SQL
Salary Histogram in Lancashire

This chart provides a salary histogram for IT jobs citing T-SQL across the Lancashire region over the 3 months to 3 May 2016.

T-SQL Salary Histogram 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 3 May 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
(Click see detailed
statistics and trends)
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
Preston +11 8 £40,000 +45.45% 1
Blackburn +7 7 £42,500 +18.05% 2
Chorley -4 7 £37,000 +13.84%
Darwen - 5 £26,000 -
Lancaster - 4 - -
Burnley - 2 £30,000 -
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 3 May 2016, 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 55 (100.00%) SQL
2 35 (63.64%) .NET
3 33 (60.00%) ASP.NET
4 25 (45.45%) Windows
4 25 (45.45%) SQL Server Reporting Services
5 24 (43.64%) SQL Server
5 24 (43.64%) Windows Server
6 21 (38.18%) Degree
7 18 (32.73%) User Acceptance Testing
7 18 (32.73%) ITIL
7 18 (32.73%) Electronic Patient Records
7 18 (32.73%) Lorenzo
7 18 (32.73%) Windows Server 2012
8 15 (27.27%) Business Intelligence
8 15 (27.27%) Agile Software Development
9 14 (25.45%) C#
9 14 (25.45%) JavaScript
10 13 (23.64%) CSS
10 13 (23.64%) SQL Server Integration Services
10 13 (23.64%) SC Cleared
10 13 (23.64%) Security Cleared
10 13 (23.64%) BPSS Clearance
11 12 (21.82%) jQuery
11 12 (21.82%) Microsoft
11 12 (21.82%) MVC
12 11 (20.00%) Scrum
13 10 (18.18%) SQL Server 2012
14 8 (14.55%) HTML
14 8 (14.55%) TDD
14 8 (14.55%) ASP.NET MVC

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 3 (5.45%) Node.js
2 1 (1.82%) CMS
2 1 (1.82%) Drupal
2 1 (1.82%) WordPress
Applications
1 6 (10.91%) MS Office
2 5 (9.09%) MS Excel
Business Applications
1 18 (32.73%) Lorenzo
2 1 (1.82%) Magento
2 1 (1.82%) OpenCart
2 1 (1.82%) osCommerce
Cloud Services
1 6 (10.91%) Amazon AWS
1 6 (10.91%) Amazon EC2
1 6 (10.91%) Cloud Computing
1 6 (10.91%) Microsoft Azure
2 1 (1.82%) SaaS
Communications & Networking
1 1 (1.82%) Internet
Database & Business Intelligence
1 25 (45.45%) SQL Server Reporting Services
2 24 (43.64%) SQL Server
3 18 (32.73%) Electronic Patient Records
4 13 (23.64%) SQL Server Integration Services
5 10 (18.18%) SQL Server 2012
6 6 (10.91%) Crystal Reports
7 5 (9.09%) Data Warehouse
7 5 (9.09%) SQL Server 2008
7 5 (9.09%) SQL Server 2014
8 4 (7.27%) SQL Server Analysis Services
9 2 (3.64%) Enterprise Data Warehouse
9 2 (3.64%) OLAP
9 2 (3.64%) OLAP Cube
9 2 (3.64%) Relational Database
9 2 (3.64%) SQL Server 2005
10 1 (1.82%) Big Data
10 1 (1.82%) Microsoft Analysis Services
10 1 (1.82%) PostgreSQL
10 1 (1.82%) QlikView
10 1 (1.82%) SQL Server 2000
Development Applications
1 5 (9.09%) Team Foundation Server
2 4 (7.27%) Visual Studio
3 1 (1.82%) AccuRev
3 1 (1.82%) Bazaar
3 1 (1.82%) Git (software)
3 1 (1.82%) JIRA
3 1 (1.82%) Mercurial
3 1 (1.82%) Mocha
3 1 (1.82%) PhantomJS
3 1 (1.82%) PHPUnit
3 1 (1.82%) Sinon.JS
3 1 (1.82%) SQL Server Management Studio (SSMS)
3 1 (1.82%) Subversion
General
1 6 (10.91%) Retail
2 5 (9.09%) Billing
3 4 (7.27%) Finance
4 1 (1.82%) Legal
4 1 (1.82%) Manufacturing
4 1 (1.82%) Marketing
Job Titles
1 30 (54.55%) Developer
2 12 (21.82%) C# Developer
3 10 (18.18%) Business Intelligence Developer
4 9 (16.36%) SQL Developer
5 8 (14.55%) .NET Developer
6 7 (12.73%) Analyst
6 7 (12.73%) SQL BI Developer
7 6 (10.91%) Report Analyst
7 6 (10.91%) Senior C# Developer
7 6 (10.91%) Senior Developer
8 5 (9.09%) Applications Support
8 5 (9.09%) ASP.NET Developer
8 5 (9.09%) C# .NET Developer
8 5 (9.09%) IT Analyst
9 4 (7.27%) .NET Programmer
9 4 (7.27%) ASP.NET Programmer
9 4 (7.27%) C# ASP.NET Developer
9 4 (7.27%) C# Programmer
9 4 (7.27%) Programmer
9 4 (7.27%) WCF Developer
Libraries, Frameworks & Software Standards
1 35 (63.64%) .NET
2 33 (60.00%) ASP.NET
3 13 (23.64%) CSS
4 12 (21.82%) jQuery
5 8 (14.55%) ASP.NET MVC
5 8 (14.55%) HTML
6 7 (12.73%) HTML5
7 6 (10.91%) .NET Framework
7 6 (10.91%) JSON
7 6 (10.91%) REST
7 6 (10.91%) Twitter Bootstrap
7 6 (10.91%) XML
8 5 (9.09%) WCF
9 4 (7.27%) ASP.NET MVC 4
9 4 (7.27%) Entity Framework
9 4 (7.27%) Unity DI Container
10 3 (5.45%) AngularJS
11 2 (3.64%) ASP.NET Web API
11 2 (3.64%) CSS3
12 1 (1.82%) Express
Miscellaneous
1 7 (12.73%) iPad
2 5 (9.09%) Data Integration
2 5 (9.09%) Management Information System
2 5 (9.09%) Smart Meter
3 4 (7.27%) Clustering
3 4 (7.27%) Replication
4 1 (1.82%) Analytical Skills
4 1 (1.82%) Enterprise Software
4 1 (1.82%) FMCG
4 1 (1.82%) User Experience
Operating Systems
1 25 (45.45%) Windows
2 24 (43.64%) Windows Server
3 18 (32.73%) Windows Server 2012
4 7 (12.73%) Linux
5 6 (10.91%) Unix
Processes & Methodologies
1 18 (32.73%) ITIL
1 18 (32.73%) User Acceptance Testing
2 15 (27.27%) Agile Software Development
2 15 (27.27%) Business Intelligence
3 12 (21.82%) MVC
4 11 (20.00%) Scrum
5 8 (14.55%) TDD
6 7 (12.73%) BDD
6 7 (12.73%) Continuous Integration
6 7 (12.73%) ETL
6 7 (12.73%) OO
7 6 (10.91%) Pair Programming
8 5 (9.09%) Release Management
8 5 (9.09%) Root Cause Analysis
9 4 (7.27%) Dependency Injection
9 4 (7.27%) Kanban
10 3 (5.45%) Change Data Capture
10 3 (5.45%) Kimball Methodology
11 2 (3.64%) Continuous Improvement
11 2 (3.64%) Functional Testing
Programming Languages
1 55 (100.00%) SQL
2 14 (25.45%) C#
2 14 (25.45%) JavaScript
3 7 (12.73%) VB
4 5 (9.09%) C
5 2 (3.64%) VB.NET
6 1 (1.82%) Bash Shell
6 1 (1.82%) Data Analysis Expressions (DAX)
6 1 (1.82%) Perl
6 1 (1.82%) PHP
6 1 (1.82%) Python
6 1 (1.82%) Shell Script
6 1 (1.82%) VB6
6 1 (1.82%) VBA
6 1 (1.82%) VBScript
Qualifications
1 21 (38.18%) Degree
2 13 (23.64%) BPSS Clearance
2 13 (23.64%) SC Cleared
2 13 (23.64%) Security Cleared
Vendors
1 12 (21.82%) Microsoft
2 1 (1.82%) HP
2 1 (1.82%) Twitter
2 1 (1.82%) Zend
Blackburn, Lancashire
Nigel Frank International Ltd
Salary: £40000 - £45000 per annum
Posted: 12 hours ago
Lytham St. Annes, Lancashire
Ascent People Ltd
Salary: £30000 per annum
Posted: 4 days ago
Blackpool, Lancashire
Ascent People Ltd
Salary: £18000 - £25000 per annum
Posted: 4 days ago
Blackburn
Energize Recruitment Solutions Ltd
Salary: £25000 - £30000 per annum + Training opportunities
Posted: 11 days ago
Lancashire
Capita plc
Posted: 12 days ago