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 30 May 2016 with a comparison to the same period over the previous 2 years.

3 months to
30 May 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 31 47 26
Rank change year-on-year
+16 -21
Permanent jobs citing T-SQL 30 19 31
As % of all permanent IT jobs located in Lancashire 6.91% 3.65% 7.09%
As % of the Programming Languages category 11.54% 5.96% 12.60%
Number of salaries quoted 17 18 30
Median salary £32,500 £36,000 £35,000
Median salary % change year-on-year
-9.72% +2.85%
90% offered a salary of more than £27,500 £32,850 £25,900
10% offered a salary of more than £48,000 £40,000 £42,500
UK excluding London median salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%
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
260 319 246
As % of all permanent IT jobs located in Lancashire 59.91% 61.35% 56.29%
Number of salaries quoted 221 251 213
Median salary £35,500 £36,000 £35,000
Median salary % change year-on-year
-1.38% +2.85%
90% offered a salary of more than £27,500 £25,961 £26,000
10% offered a salary of more than £45,000 £46,500 £45,000
UK excluding London median salary £41,000 £40,000 £39,500
% change year-on-year
+2.50% +1.26%

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 30 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 30 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
Chorley -1 12 £31,500 -4.54% 1
Preston - 6 £40,000 - 1
Burnley - 4 £27,500 -
Lancaster - 4 - -
Blackburn +7 3 £48,000 +33.33% 1
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 30 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 56 (100.00%) SQL
2 37 (66.07%) .NET
3 35 (62.50%) ASP.NET
4 25 (44.64%) Windows
5 24 (42.86%) SQL Server
5 24 (42.86%) Windows Server
6 23 (41.07%) SQL Server Reporting Services
7 21 (37.50%) Degree
8 18 (32.14%) Agile Software Development
8 18 (32.14%) User Acceptance Testing
8 18 (32.14%) ITIL
8 18 (32.14%) Electronic Patient Records
8 18 (32.14%) Lorenzo
8 18 (32.14%) Windows Server 2012
9 16 (28.57%) C#
9 16 (28.57%) JavaScript
10 15 (26.79%) CSS
11 14 (25.00%) Business Intelligence
11 14 (25.00%) jQuery
12 12 (21.43%) Microsoft
12 12 (21.43%) MVC
13 11 (19.64%) Scrum
13 11 (19.64%) SQL Server Integration Services
14 10 (17.86%) TDD
14 10 (17.86%) HTML
15 9 (16.07%) Continuous Integration
15 9 (16.07%) SC Cleared
15 9 (16.07%) Security Cleared
15 9 (16.07%) SQL Server 2012
15 9 (16.07%) BDD

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 5 (8.93%) Node.js
2 1 (1.79%) CMS
2 1 (1.79%) Drupal
2 1 (1.79%) WordPress
Applications
1 8 (14.29%) MS Office
2 6 (10.71%) MS Excel
Business Applications
1 18 (32.14%) Lorenzo
2 1 (1.79%) Magento
2 1 (1.79%) OpenCart
2 1 (1.79%) osCommerce
Cloud Services
1 6 (10.71%) Amazon AWS
1 6 (10.71%) Amazon EC2
1 6 (10.71%) Cloud Computing
1 6 (10.71%) Microsoft Azure
2 3 (5.36%) SaaS
Communications & Networking
1 1 (1.79%) Internet
Database & Business Intelligence
1 24 (42.86%) SQL Server
2 23 (41.07%) SQL Server Reporting Services
3 18 (32.14%) Electronic Patient Records
4 11 (19.64%) SQL Server Integration Services
5 9 (16.07%) SQL Server 2012
6 7 (12.50%) Crystal Reports
7 6 (10.71%) Data Warehouse
7 6 (10.71%) SQL Server Analysis Services
8 5 (8.93%) SQL Server 2008
8 5 (8.93%) SQL Server 2014
9 3 (5.36%) OLAP
10 2 (3.57%) Enterprise Data Warehouse
10 2 (3.57%) OLAP Cube
10 2 (3.57%) Power BI
10 2 (3.57%) QlikView
10 2 (3.57%) Relational Database
10 2 (3.57%) SQL Server 2005
11 1 (1.79%) Big Data
11 1 (1.79%) Datazen
11 1 (1.79%) PowerPivot
Development Applications
1 5 (8.93%) Team Foundation Server
2 4 (7.14%) Visual Studio
3 3 (5.36%) Mocha
3 3 (5.36%) Sinon.JS
4 2 (3.57%) SQL Server Management Studio (SSMS)
5 1 (1.79%) AccuRev
5 1 (1.79%) Bazaar
5 1 (1.79%) Git (software)
5 1 (1.79%) JIRA
5 1 (1.79%) Mercurial
5 1 (1.79%) PhantomJS
5 1 (1.79%) PHPUnit
5 1 (1.79%) Subversion
General
1 6 (10.71%) Retail
2 5 (8.93%) Billing
3 3 (5.36%) Finance
4 2 (3.57%) Legal
5 1 (1.79%) Manufacturing
Job Titles
1 31 (55.36%) Developer
2 12 (21.43%) C# Developer
3 10 (17.86%) Business Intelligence Developer
4 9 (16.07%) Applications Support
5 8 (14.29%) .NET Developer
5 8 (14.29%) Analyst
6 7 (12.50%) SQL Developer
7 6 (10.71%) IT Analyst
7 6 (10.71%) Senior C# Developer
7 6 (10.71%) Senior Developer
8 5 (8.93%) ASP.NET Developer
8 5 (8.93%) C# .NET Developer
8 5 (8.93%) Report Analyst
8 5 (8.93%) SQL BI Developer
9 4 (7.14%) .NET Programmer
9 4 (7.14%) ASP.NET MVC Developer
9 4 (7.14%) ASP.NET Programmer
9 4 (7.14%) C# ASP.NET Developer
9 4 (7.14%) Programmer
9 4 (7.14%) WCF Developer
Libraries, Frameworks & Software Standards
1 37 (66.07%) .NET
2 35 (62.50%) ASP.NET
3 15 (26.79%) CSS
4 14 (25.00%) jQuery
5 10 (17.86%) HTML
6 8 (14.29%) ASP.NET MVC
6 8 (14.29%) Twitter Bootstrap
7 7 (12.50%) HTML5
8 6 (10.71%) .NET Framework
8 6 (10.71%) JSON
8 6 (10.71%) REST
8 6 (10.71%) XML
9 5 (8.93%) WCF
10 4 (7.14%) ASP.NET MVC 4
10 4 (7.14%) Entity Framework
10 4 (7.14%) Unity DI Container
11 3 (5.36%) AngularJS
11 3 (5.36%) Chai
11 3 (5.36%) Express
12 2 (3.57%) ASP.NET Web API
Miscellaneous
1 8 (14.29%) iPad
2 6 (10.71%) Management Information System
3 5 (8.93%) Data Integration
3 5 (8.93%) Smart Meter
4 4 (7.14%) Clustering
4 4 (7.14%) Replication
5 3 (5.36%) Enterprise Software
6 1 (1.79%) FMCG
6 1 (1.79%) User Experience
Operating Systems
1 25 (44.64%) Windows
2 24 (42.86%) Windows Server
3 18 (32.14%) Windows Server 2012
4 7 (12.50%) Linux
5 6 (10.71%) Unix
Processes & Methodologies
1 18 (32.14%) Agile Software Development
1 18 (32.14%) ITIL
1 18 (32.14%) User Acceptance Testing
2 14 (25.00%) Business Intelligence
3 12 (21.43%) MVC
4 11 (19.64%) Scrum
5 10 (17.86%) TDD
6 9 (16.07%) BDD
6 9 (16.07%) Continuous Integration
7 8 (14.29%) ETL
8 7 (12.50%) OO
9 6 (10.71%) Pair Programming
10 5 (8.93%) Release Management
10 5 (8.93%) Root Cause Analysis
11 4 (7.14%) Dependency Injection
11 4 (7.14%) Kanban
12 3 (5.36%) Change Data Capture
12 3 (5.36%) Data Modelling
12 3 (5.36%) Kimball Methodology
13 2 (3.57%) Continuous Improvement
Programming Languages
1 56 (100.00%) SQL
2 16 (28.57%) C#
2 16 (28.57%) JavaScript
3 8 (14.29%) VB
4 5 (8.93%) C
5 3 (5.36%) VBA
6 2 (3.57%) Data Analysis Expressions (DAX)
6 2 (3.57%) VB.NET
6 2 (3.57%) VBScript
7 1 (1.79%) Bash Shell
7 1 (1.79%) Perl
7 1 (1.79%) PHP
7 1 (1.79%) Python
7 1 (1.79%) Shell Script
7 1 (1.79%) VB6
Qualifications
1 21 (37.50%) Degree
2 9 (16.07%) BPSS Clearance
2 9 (16.07%) SC Cleared
2 9 (16.07%) Security Cleared
Vendors
1 12 (21.43%) Microsoft
2 1 (1.79%) HP
2 1 (1.79%) Oracle
2 1 (1.79%) SAP
2 1 (1.79%) SYSPRO
2 1 (1.79%) Twitter
2 1 (1.79%) Zend
Preston, Lancashire
Ascent People Ltd
Salary: £28000 per annum
Posted: 2 days ago
Blackburn
Energize Recruitment Solutions Ltd
Salary: £25000 - £30000 per annum + Training opportunities
Posted: 14 days ago
Chorley
Capita plc
Salary: £40000.00 - £45000.00 per annum
Posted: 13 days ago