Period
to 20 February 2018

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 20 February 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
North West > Lancashire
6 months to
20 Feb 2018
Same period 2017 Same period 2016
Rank 21 26 35
Rank change year-on-year +5 +9 +12
Permanent jobs citing T-SQL 72 76 44
As % of all permanent IT jobs advertised in Lancashire 8.75% 7.94% 5.29%
As % of the Programming Languages category 15.55% 14.23% 10.05%
Number of salaries quoted 59 67 27
Lancashire median annual salary £35,000 £33,000 £37,500
Median salary % change year-on-year +6.06% -12.00% +4.90%
10th Percentile £23,950 £29,900 £25,500
90th Percentile £42,750 £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 463 534 438
As % of all permanent IT jobs advertised in Lancashire 56.26% 55.80% 52.71%
Number of salaries quoted 386 488 349
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £24,375 £22,771 £22,750
90th Percentile £55,000 £47,500 £45,650
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 20 February 2018.

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 20 February 2018. 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 +6 42 £35,000 +2.94% 2
Preston +14 9 £25,000 -33.33% 6
Burnley +2 7 £35,000 -
Blackburn -4 3 £36,000 -20.00% 1
Blackpool -1 1 £23,000 -26.98%
T-SQL
North West

For the 6 months to 20 February 2018, IT jobs citing T-SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Lancashire region with a requirement for T-SQL.

1 72 (100.00%) SQL
2 58 (80.56%) SQL Server
3 39 (54.17%) Microsoft
4 37 (51.39%) Business Intelligence
5 31 (43.06%) SQL Server Integration Services
6 23 (31.94%) Data Warehouse
7 21 (29.17%) SQL Server Reporting Services
8 19 (26.39%) VBA
8 19 (26.39%) .NET
9 17 (23.61%) JavaScript
10 15 (20.83%) C#
10 15 (20.83%) Windows
10 15 (20.83%) Finance
10 15 (20.83%) VMware
10 15 (20.83%) VMware Infrastructure
11 14 (19.44%) SQL Server 2005
11 14 (19.44%) DTS
11 14 (19.44%) Windows Server 2008
11 14 (19.44%) Windows Server 2012
12 13 (18.06%) SQL Server 2016
12 13 (18.06%) HTML
12 13 (18.06%) ASP.NET
12 13 (18.06%) CSS
13 12 (16.67%) MVC
14 11 (15.28%) Management Information System
14 11 (15.28%) ETL
14 11 (15.28%) OO
14 11 (15.28%) Data Analytics
14 11 (15.28%) Analytics
14 11 (15.28%) SQL Server 2008

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 8 (11.11%) SharePoint
2 7 (9.72%) BizTalk Server
3 1 (1.39%) CMS
3 1 (1.39%) MS Exchange
3 1 (1.39%) NServiceBus
3 1 (1.39%) SAS
Applications
1 1 (1.39%) Microsoft Excel
Business Applications
1 7 (9.72%) Cognos Business Intelligence
2 3 (4.17%) Cognos TM1
Cloud Services
1 1 (1.39%) Amazon AWS
1 1 (1.39%) SaaS
Communications & Networking
1 8 (11.11%) LAN
1 8 (11.11%) VLAN
1 8 (11.11%) WAN
2 1 (1.39%) DNS
2 1 (1.39%) Firewall
2 1 (1.39%) SAN
2 1 (1.39%) TCP/IP
Database & Business Intelligence
1 58 (80.56%) SQL Server
2 31 (43.06%) SQL Server Integration Services
3 23 (31.94%) Data Warehouse
4 21 (29.17%) SQL Server Reporting Services
5 14 (19.44%) DTS
5 14 (19.44%) SQL Server 2005
6 13 (18.06%) SQL Server 2016
7 11 (15.28%) SQL Server 2008
8 10 (13.89%) Power BI
8 10 (13.89%) SQL Server 2014
8 10 (13.89%) SQL Server Analysis Services
9 9 (12.50%) SQL Server 2012
10 8 (11.11%) Microsoft Analysis Services
11 4 (5.56%) PostgreSQL
12 2 (2.78%) Oracle Database
13 1 (1.39%) MS Access
13 1 (1.39%) MySQL
13 1 (1.39%) OLAP
13 1 (1.39%) OLAP Cube
13 1 (1.39%) Redis
Development Applications
1 10 (13.89%) Visual Studio
2 2 (2.78%) Team Foundation Server
3 1 (1.39%) Atlassian Bamboo
3 1 (1.39%) Selenium
3 1 (1.39%) SQL Server Management Studio (SSMS)
3 1 (1.39%) Subversion
General
1 15 (20.83%) Finance
2 3 (4.17%) Retail
3 2 (2.78%) Manufacturing
Job Titles
1 42 (58.33%) Developer
2 24 (33.33%) SQL Developer
3 20 (27.78%) Analyst
4 19 (26.39%) SQL Analyst
5 15 (20.83%) Business Intelligence Developer
6 13 (18.06%) SQL BI Developer
7 12 (16.67%) Software Developer
8 10 (13.89%) .NET Developer
8 10 (13.89%) C# Developer
8 10 (13.89%) C# Software Developer
8 10 (13.89%) SQL Server Developer
9 8 (11.11%) 2nd Line Engineer
9 8 (11.11%) 2nd Line Support
9 8 (11.11%) 2nd Line Technical Support Engineer
9 8 (11.11%) C# .NET Developer
9 8 (11.11%) Data Analyst
9 8 (11.11%) Support Engineer
9 8 (11.11%) Technical Engineer
9 8 (11.11%) Technical Support
9 8 (11.11%) Technical Support Engineer
Libraries, Frameworks & Software Standards
1 19 (26.39%) .NET
2 13 (18.06%) ASP.NET
2 13 (18.06%) CSS
2 13 (18.06%) HTML
3 10 (13.89%) MDX
4 9 (12.50%) ASP.NET MVC
5 8 (11.11%) jQuery
6 6 (8.33%) Twitter Bootstrap
7 5 (6.94%) REST
8 4 (5.56%) .NET Framework
8 4 (5.56%) Entity Framework
8 4 (5.56%) Node.js
9 3 (4.17%) AngularJS
9 3 (4.17%) ASP.NET MVC 4
9 3 (4.17%) HTML5
10 2 (2.78%) Express
10 2 (2.78%) Hibernate
10 2 (2.78%) JSON
10 2 (2.78%) Spring
10 2 (2.78%) XML
Miscellaneous
1 11 (15.28%) Management Information System
2 7 (9.72%) Fintech
3 2 (2.78%) Mobile App
4 1 (1.39%) Analytical Skills
4 1 (1.39%) Data Protection Act
4 1 (1.39%) Data Structures
Operating Systems
1 15 (20.83%) Windows
2 14 (19.44%) Windows Server 2008
2 14 (19.44%) Windows Server 2012
3 1 (1.39%) Android
3 1 (1.39%) Apple iOS
3 1 (1.39%) Unix
Processes & Methodologies
1 37 (51.39%) Business Intelligence
2 12 (16.67%) MVC
3 11 (15.28%) Analytics
3 11 (15.28%) Data Analytics
3 11 (15.28%) ETL
3 11 (15.28%) OO
4 10 (13.89%) Dashboard Development
4 10 (13.89%) ITIL
5 9 (12.50%) Continuous Improvement
6 8 (11.11%) Data Analysis
6 8 (11.11%) Service Delivery
6 8 (11.11%) Service Management
7 7 (9.72%) Asset Management
7 7 (9.72%) Front End Development
7 7 (9.72%) Information Management
7 7 (9.72%) Wealth Management
8 6 (8.33%) Agile Software Development
8 6 (8.33%) Stakeholder Management
8 6 (8.33%) TDD
9 5 (6.94%) Performance Tuning
Programming Languages
1 72 (100.00%) SQL
2 19 (26.39%) VBA
3 17 (23.61%) JavaScript
4 15 (20.83%) C#
5 2 (2.78%) Java
5 2 (2.78%) PL/SQL
5 2 (2.78%) PowerShell
6 1 (1.39%) PHP
6 1 (1.39%) VB
6 1 (1.39%) VB.NET
Qualifications
1 10 (13.89%) Degree
2 2 (2.78%) ITIL Certification
2 2 (2.78%) Microsoft Certification
3 1 (1.39%) CCNA
3 1 (1.39%) Cisco Certification
Quality Assurance & Compliance
1 2 (2.78%) GDPR
System Software
1 15 (20.83%) VMware Infrastructure
2 8 (11.11%) Active Directory
3 1 (1.39%) vSphere
Systems Management
1 8 (11.11%) FortiGate
Vendors
1 39 (54.17%) Microsoft
2 15 (20.83%) VMware
3 10 (13.89%) Cognos
3 10 (13.89%) Tableau
4 9 (12.50%) IBM
5 8 (11.11%) Cisco
5 8 (11.11%) HP
5 8 (11.11%) Intel
5 8 (11.11%) Juniper
5 8 (11.11%) ProCurve
5 8 (11.11%) Sophos
6 2 (2.78%) Capita
6 2 (2.78%) Oracle
7 1 (1.39%) Google
7 1 (1.39%) Twitter