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

Transact-SQL
North West > Lancashire
6 months to
26 May 2018
Same period 2017 Same period 2016
Rank 27 18 29
Rank change year-on-year -9 +11 +36
Permanent jobs citing T-SQL 57 93 56
As % of all permanent IT jobs advertised in Lancashire 6.58% 10.88% 7.24%
As % of the Programming Languages category 12.26% 18.09% 12.53%
Number of salaries quoted 48 88 34
Lancashire median annual salary £35,000 £33,000 £38,750
Median salary % change year-on-year +6.06% -14.84% +7.64%
10th Percentile £23,600 £29,750 £25,500
90th Percentile £57,500 £45,000 £48,000
North West median annual salary £42,500 £37,500 £40,000
% change year-on-year +13.33% -6.25% -

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 465 514 447
As % of all permanent IT jobs advertised in Lancashire 53.70% 60.12% 57.75%
Number of salaries quoted 412 478 377
Lancashire median annual salary £35,000 £35,000 £35,000
10th Percentile £25,025 £22,750 £24,650
90th Percentile £56,250 £47,875 £45,000
North West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +5.96%

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 26 May 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 26 May 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 38 £40,000 - 2
Preston +8 9 £25,000 -33.33% 5
Burnley -5 6 £35,000 -
Blackpool -6 1 £20,500 -34.92%
Blackburn -8 1 £36,000 -24.21% 1
T-SQL
North West

For the 6 months to 26 May 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 57 (100.00%) SQL
2 44 (77.19%) SQL Server
3 30 (52.63%) Microsoft
4 25 (43.86%) Business Intelligence
5 23 (40.35%) SQL Server Integration Services
6 21 (36.84%) SQL Server Reporting Services
7 20 (35.09%) .NET
8 18 (31.58%) C#
9 17 (29.82%) Data Warehouse
10 16 (28.07%) JavaScript
10 16 (28.07%) SQL Server Analysis Services
11 14 (24.56%) HTML
11 14 (24.56%) ASP.NET
11 14 (24.56%) CSS
12 13 (22.81%) MVC
12 13 (22.81%) Visual Studio
12 13 (22.81%) OO
13 12 (21.05%) ASP.NET MVC
13 12 (21.05%) Finance
14 11 (19.30%) Performance Tuning
15 10 (17.54%) Agile Software Development
16 9 (15.79%) VMware
16 9 (15.79%) PowerShell
16 9 (15.79%) Test Automation
16 9 (15.79%) VMware Infrastructure
16 9 (15.79%) Windows
16 9 (15.79%) ITIL
17 8 (14.04%) VBA
17 8 (14.04%) DTS
17 8 (14.04%) LAN

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 1 (1.75%) BizTalk Server
1 1 (1.75%) CMS
1 1 (1.75%) MS Exchange
1 1 (1.75%) NServiceBus
1 1 (1.75%) SharePoint
Business Applications
1 2 (3.51%) Cognos TM1
2 1 (1.75%) Cognos Business Intelligence
Cloud Services
1 5 (8.77%) Amazon AWS
1 5 (8.77%) SaaS
Communications & Networking
1 8 (14.04%) LAN
1 8 (14.04%) VLAN
1 8 (14.04%) WAN
2 1 (1.75%) DNS
2 1 (1.75%) Firewall
2 1 (1.75%) SAN
2 1 (1.75%) TCP/IP
Database & Business Intelligence
1 44 (77.19%) SQL Server
2 23 (40.35%) SQL Server Integration Services
3 21 (36.84%) SQL Server Reporting Services
4 17 (29.82%) Data Warehouse
5 16 (28.07%) SQL Server Analysis Services
6 8 (14.04%) DTS
6 8 (14.04%) SQL Server 2005
7 5 (8.77%) Microsoft Analysis Services
7 5 (8.77%) PostgreSQL
7 5 (8.77%) SQL Server 2014
7 5 (8.77%) SQL Server 2016
8 4 (7.02%) OLAP
8 4 (7.02%) OLAP Cube
8 4 (7.02%) SQL Server 2012
9 3 (5.26%) Power BI
10 1 (1.75%) MySQL
10 1 (1.75%) Redis
Development Applications
1 13 (22.81%) Visual Studio
2 5 (8.77%) Selenium
2 5 (8.77%) SQL Server Management Studio (SSMS)
2 5 (8.77%) Subversion
3 2 (3.51%) Team Foundation Server
4 1 (1.75%) Atlassian Bamboo
General
1 12 (21.05%) Finance
2 3 (5.26%) Retail
3 1 (1.75%) Manufacturing
Job Titles
1 36 (63.16%) Developer
2 14 (24.56%) Software Developer
2 14 (24.56%) SQL Developer
3 13 (22.81%) C# Developer
3 13 (22.81%) C# Software Developer
4 12 (21.05%) .NET Developer
5 11 (19.30%) .NET Software Developer
5 11 (19.30%) Analyst
5 11 (19.30%) Business Intelligence Developer
5 11 (19.30%) C# .NET Developer
6 10 (17.54%) SQL Analyst
7 8 (14.04%) 2nd Line Engineer
7 8 (14.04%) 2nd Line Support
7 8 (14.04%) 2nd Line Technical Support
7 8 (14.04%) 2nd Line Technical Support Engineer
7 8 (14.04%) ASP.NET MVC Developer
7 8 (14.04%) Support Engineer
7 8 (14.04%) Technical Engineer
7 8 (14.04%) Technical Support
7 8 (14.04%) Technical Support Engineer
Libraries, Frameworks & Software Standards
1 20 (35.09%) .NET
2 14 (24.56%) ASP.NET
2 14 (24.56%) CSS
2 14 (24.56%) HTML
3 12 (21.05%) ASP.NET MVC
4 5 (8.77%) .NET Framework
4 5 (8.77%) Entity Framework
5 4 (7.02%) ASP.NET MVC 4
5 4 (7.02%) jQuery
6 3 (5.26%) MDX
6 3 (5.26%) REST
6 3 (5.26%) Web Services
7 1 (1.75%) AngularJS
7 1 (1.75%) AutoMapper
7 1 (1.75%) HTML5
7 1 (1.75%) JSON
7 1 (1.75%) LINQ
7 1 (1.75%) SignalR
7 1 (1.75%) WCF
7 1 (1.75%) XML
Miscellaneous
1 5 (8.77%) Data Protection Act
1 5 (8.77%) Fintech
2 4 (7.02%) Management Information System
3 1 (1.75%) Mobile App
3 1 (1.75%) Self-Motivation
Operating Systems
1 9 (15.79%) Windows
2 8 (14.04%) Windows Server 2008
2 8 (14.04%) Windows Server 2012
3 5 (8.77%) Unix
Processes & Methodologies
1 25 (43.86%) Business Intelligence
2 13 (22.81%) MVC
2 13 (22.81%) OO
3 11 (19.30%) Performance Tuning
4 10 (17.54%) Agile Software Development
5 9 (15.79%) ITIL
5 9 (15.79%) Test Automation
6 8 (14.04%) Analytics
6 8 (14.04%) Continuous Improvement
6 8 (14.04%) Data Analytics
6 8 (14.04%) Front End Development
6 8 (14.04%) Service Delivery
6 8 (14.04%) Service Management
6 8 (14.04%) Stakeholder Management
7 7 (12.28%) ETL
8 6 (10.53%) Data Architecture
9 5 (8.77%) Data Protection
9 5 (8.77%) Refactoring
9 5 (8.77%) TDD
9 5 (8.77%) Wealth Management
Programming Languages
1 57 (100.00%) SQL
2 18 (31.58%) C#
3 16 (28.07%) JavaScript
4 9 (15.79%) PowerShell
5 8 (14.04%) VBA
6 5 (8.77%) VB.NET
7 3 (5.26%) VB
8 2 (3.51%) VBScript
9 1 (1.75%) PHP
Qualifications
1 7 (12.28%) Degree
2 1 (1.75%) CCNA
2 1 (1.75%) Cisco Certification
2 1 (1.75%) ITIL Certification
2 1 (1.75%) Microsoft Certification
Quality Assurance & Compliance
1 2 (3.51%) GDPR
System Software
1 9 (15.79%) VMware Infrastructure
2 8 (14.04%) Active Directory
3 1 (1.75%) vSphere
Systems Management
1 8 (14.04%) FortiGate
Vendors
1 30 (52.63%) Microsoft
2 9 (15.79%) VMware
3 8 (14.04%) Cisco
3 8 (14.04%) HP
3 8 (14.04%) Intel
3 8 (14.04%) Juniper
3 8 (14.04%) ProCurve
3 8 (14.04%) Sophos
4 3 (5.26%) Capita
4 3 (5.26%) Cognos
4 3 (5.26%) Tableau
5 2 (3.51%) IBM
6 1 (1.75%) Google
6 1 (1.75%) Twitter