Period
to 21 November 2017

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 6 months to 21 November 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
North West > Lancashire
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 18 42 50
Rank change year-on-year +24 +8 -11
Permanent jobs citing T-SQL 80 47 39
As % of all permanent IT jobs advertised in Lancashire 8.90% 5.21% 3.90%
As % of the Programming Languages category 15.09% 9.61% 7.32%
Number of salaries quoted 71 39 25
Lancashire median annual salary £35,000 £35,000 £37,500
Median salary % change year-on-year - -6.67% -4.46%
10th Percentile £29,000 £27,100 £28,400
90th Percentile £46,250 £43,750 £45,000
North West median annual salary £40,000 £40,000 £40,000

T-SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Lancashire with a requirement for coding skills.

All Programming Languages
Lancashire
Permanent vacancies with a requirement for coding skills 530 489 533
As % of all permanent IT jobs advertised in Lancashire 58.95% 54.21% 53.30%
Number of salaries quoted 447 437 437
Lancashire median annual salary £35,000 £36,500 £35,000
Median salary % change year-on-year -4.11% +4.29% -
10th Percentile £25,400 £25,000 £23,800
90th Percentile £47,500 £45,000 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +6.67%

T-SQL
Job Vacancy Trend in Lancashire

Job postings citing T-SQL as a percentage of all IT jobs advertised in Lancashire.

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 6 months to 21 November 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 6 months to 21 November 2017. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Chorley +8 28 £33,750 -3.57% 3
Burnley +9 18 £36,250 +31.82% 1
Preston 0 11 £43,750 +9.38%
Blackpool +16 4 £27,750 -14.62%
Blackburn +3 3 £36,000 -20.00% 1
Rossendale - 2 £43,750 -
Skelmersdale - 1 £30,000 -
Ormskirk - 1 £31,500 -
T-SQL
North West

For the 6 months to 21 November 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 80 (100.00%) SQL
2 57 (71.25%) SQL Server
3 45 (56.25%) Business Intelligence
4 33 (41.25%) SQL Server Integration Services
5 30 (37.50%) SQL Server Reporting Services
5 30 (37.50%) .NET
6 23 (28.75%) VBA
6 23 (28.75%) Microsoft
7 22 (27.50%) SQL Server 2008
8 20 (25.00%) SQL Server Analysis Services
9 18 (22.50%) CSS
9 18 (22.50%) HTML
9 18 (22.50%) JavaScript
10 17 (21.25%) Degree
11 16 (20.00%) C#
11 16 (20.00%) ASP.NET
11 16 (20.00%) XML
12 15 (18.75%) Power BI
12 15 (18.75%) Tableau
13 14 (17.50%) Data Analytics
13 14 (17.50%) SQL Server 2012
13 14 (17.50%) REST
13 14 (17.50%) Analytics
13 14 (17.50%) Dashboard Development
13 14 (17.50%) Data Warehouse
13 14 (17.50%) Management Information System
13 14 (17.50%) MDX
14 13 (16.25%) Finance
14 13 (16.25%) SQL Server 2014
14 13 (16.25%) SQL Server 2016

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 6 (7.50%) BizTalk Server
1 6 (7.50%) SharePoint
2 1 (1.25%) IIS
Applications
1 6 (7.50%) Microsoft Excel
2 1 (1.25%) Microsoft Office
Business Applications
1 6 (7.50%) Cognos Business Intelligence
2 5 (6.25%) Dynamics NAV
3 1 (1.25%) Cognos TM1
3 1 (1.25%) Dynamics AX
3 1 (1.25%) Payment Gateway
3 1 (1.25%) Sage 50
Cloud Services
1 1 (1.25%) Azure Machine Learning
1 1 (1.25%) Dynamics 365
1 1 (1.25%) Microsoft Azure
1 1 (1.25%) Office 365
Communications & Networking
1 1 (1.25%) Internet
Database & Business Intelligence
1 57 (71.25%) SQL Server
2 33 (41.25%) SQL Server Integration Services
3 30 (37.50%) SQL Server Reporting Services
4 22 (27.50%) SQL Server 2008
5 20 (25.00%) SQL Server Analysis Services
6 15 (18.75%) Power BI
7 14 (17.50%) Data Warehouse
7 14 (17.50%) SQL Server 2012
8 13 (16.25%) SQL Server 2014
8 13 (16.25%) SQL Server 2016
9 8 (10.00%) Microsoft Analysis Services
10 6 (7.50%) DTS
10 6 (7.50%) SQL Server 2005
11 5 (6.25%) PostgreSQL
12 4 (5.00%) Oracle Database
13 2 (2.50%) Crystal Reports
14 1 (1.25%) Hadoop
14 1 (1.25%) MS Access
14 1 (1.25%) ZAP BI
Development Applications
1 2 (2.50%) Git (software)
2 1 (1.25%) Visual Studio
General
1 13 (16.25%) Finance
2 6 (7.50%) Manufacturing
3 4 (5.00%) Retail
Job Titles
1 55 (68.75%) Developer
2 39 (48.75%) SQL Developer
3 23 (28.75%) Analyst
4 22 (27.50%) Business Intelligence Developer
5 21 (26.25%) SQL BI Developer
6 19 (23.75%) SQL Analyst
7 13 (16.25%) SQL Server Developer
7 13 (16.25%) Tableau Developer
8 12 (15.00%) T-SQL Developer
9 8 (10.00%) .NET Developer
9 8 (10.00%) Data Analyst
9 8 (10.00%) Front End Developer (Client-Side Developer)
9 8 (10.00%) JavaScript Developer
9 8 (10.00%) Power BI Developer
10 7 (8.75%) Data Warehouse Developer
10 7 (8.75%) HTML CSS Developer
10 7 (8.75%) HTML Developer
10 7 (8.75%) Node.js Developer
10 7 (8.75%) SQL Server BI Developer
10 7 (8.75%) SQL Server Data Warehouse Developer
Libraries, Frameworks & Software Standards
1 30 (37.50%) .NET
2 18 (22.50%) CSS
2 18 (22.50%) HTML
3 16 (20.00%) ASP.NET
3 16 (20.00%) XML
4 14 (17.50%) MDX
4 14 (17.50%) REST
5 12 (15.00%) jQuery
5 12 (15.00%) Node.js
5 12 (15.00%) Twitter Bootstrap
6 11 (13.75%) HTML5
7 10 (12.50%) Express
8 9 (11.25%) Apache Cordova
8 9 (11.25%) SOAP
9 4 (5.00%) Hibernate
9 4 (5.00%) Spring
10 2 (2.50%) AngularJS
10 2 (2.50%) ASP.NET MVC
10 2 (2.50%) JSON
10 2 (2.50%) LINQ
Miscellaneous
1 14 (17.50%) Management Information System
2 6 (7.50%) Analytical Skills
2 6 (7.50%) Clustering
2 6 (7.50%) Fintech
3 3 (3.75%) Greenfield Project
4 1 (1.25%) Data Structures
Operating Systems
1 7 (8.75%) Windows
2 6 (7.50%) Windows Server 2008
2 6 (7.50%) Windows Server 2012
Processes & Methodologies
1 45 (56.25%) Business Intelligence
2 14 (17.50%) Analytics
2 14 (17.50%) Dashboard Development
2 14 (17.50%) Data Analytics
3 12 (15.00%) TDD
4 9 (11.25%) Agile Software Development
4 9 (11.25%) High Availability
5 8 (10.00%) ETL
6 7 (8.75%) Front End Development
7 6 (7.50%) Asset Management
7 6 (7.50%) Data Analysis
7 6 (7.50%) Information Management
7 6 (7.50%) ITIL
7 6 (7.50%) Wealth Management
8 5 (6.25%) Business Analysis
8 5 (6.25%) Incident Management
8 5 (6.25%) ITIL V2
8 5 (6.25%) PRINCE
8 5 (6.25%) Project Management
8 5 (6.25%) User Acceptance Testing
Programming Languages
1 80 (100.00%) SQL
2 23 (28.75%) VBA
3 18 (22.50%) JavaScript
4 16 (20.00%) C#
5 4 (5.00%) Java
5 4 (5.00%) PL/SQL
6 3 (3.75%) VB
7 2 (2.50%) VB.NET
8 1 (1.25%) PHP
8 1 (1.25%) VBScript
Qualifications
1 17 (21.25%) Degree
2 2 (2.50%) Master's Degree
3 1 (1.25%) ITIL Certification
3 1 (1.25%) Microsoft Certification
Quality Assurance & Compliance
1 5 (6.25%) SLA
System Software
1 7 (8.75%) VMware Infrastructure
2 1 (1.25%) Hyper-V
Vendors
1 23 (28.75%) Microsoft
2 15 (18.75%) Tableau
3 7 (8.75%) Cognos
3 7 (8.75%) IBM
3 7 (8.75%) VMware
4 4 (5.00%) Oracle
5 1 (1.25%) CyberSource
5 1 (1.25%) Sage