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

Transact-SQL
North West > Lancashire
6 months to
20 Nov 2018
Same period 2017 Same period 2016
Rank 39 19 39
Rank change year-on-year -20 +20 +15
Permanent jobs citing T-SQL 35 80 47
As % of all permanent IT jobs advertised in Lancashire 4.50% 8.96% 5.24%
As % of the Programming Languages category 9.94% 15.24% 9.69%
Number of salaries quoted 32 71 39
Lancashire median annual salary £38,500 £35,000 £35,000
Median salary % change year-on-year +10.00% - -6.67%
10th Percentile £28,750 £29,000 £27,100
90th Percentile £50,000 £46,250 £43,750
North West median annual salary £44,000 £40,000 £40,000
% change year-on-year +10.00% - -

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 352 525 485
As % of all permanent IT jobs advertised in Lancashire 45.30% 58.79% 54.07%
Number of salaries quoted 300 442 436
Lancashire median annual salary £37,500 £35,000 £36,250
Median salary % change year-on-year +7.14% -3.45% +3.57%
10th Percentile £23,500 £25,275 £25,000
90th Percentile £50,442 £47,500 £45,000
North West median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -

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 November 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 November 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
Preston +18 15 £35,000 -20.00% 4
Blackburn +1 9 £35,500 -1.39% 1
Blackpool -11 6 £38,500 +38.74% 3
Ormskirk 0 2 £40,000 +26.98%
Burnley -2 1 £32,500 -10.34% 1
Chorley -22 1 £42,500 +25.93%
T-SQL
North West

For the 6 months to 20 November 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 33 (94.29%) SQL
2 29 (82.86%) SQL Server
3 23 (65.71%) SQL Server Reporting Services
4 21 (60.00%) SQL Server Integration Services
5 20 (57.14%) Business Intelligence
6 13 (37.14%) SQL Server Analysis Services
7 12 (34.29%) ETL
8 11 (31.43%) Microsoft
8 11 (31.43%) Data Warehouse
8 11 (31.43%) C#
9 10 (28.57%) .NET
9 10 (28.57%) SQL Server 2008
10 9 (25.71%) Power BI
10 9 (25.71%) Migration
11 8 (22.86%) JavaScript
11 8 (22.86%) jQuery
11 8 (22.86%) SQL Server 2012
12 6 (17.14%) ASP.NET
12 6 (17.14%) MVC
12 6 (17.14%) Agile Software Development
13 5 (14.29%) Windows
13 5 (14.29%) Kimball Methodology
13 5 (14.29%) AngularJS
13 5 (14.29%) Visualisation
14 4 (11.43%) Windows Server 2012
14 4 (11.43%) Inversion of Control
14 4 (11.43%) Data Migration
14 4 (11.43%) OO
14 4 (11.43%) CSS
14 4 (11.43%) Data Analysis

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 2 (5.71%) SharePoint
2 1 (2.86%) NServiceBus
Applications
1 1 (2.86%) Microsoft Excel
Business Applications
1 1 (2.86%) Sage 500
Cloud Services
1 3 (8.57%) Microsoft Azure
2 1 (2.86%) Dynamics 365
Database & Business Intelligence
1 29 (82.86%) SQL Server
2 23 (65.71%) SQL Server Reporting Services
3 21 (60.00%) SQL Server Integration Services
4 13 (37.14%) SQL Server Analysis Services
5 11 (31.43%) Data Warehouse
6 10 (28.57%) SQL Server 2008
7 9 (25.71%) Power BI
8 8 (22.86%) SQL Server 2012
9 2 (5.71%) MySQL
9 2 (5.71%) QlikView
9 2 (5.71%) Snowflake Schema
10 1 (2.86%) OLAP
10 1 (2.86%) PowerPivot
10 1 (2.86%) Redis
10 1 (2.86%) Relational Database
10 1 (2.86%) SQL Server 2016
Development Applications
1 3 (8.57%) Visual Studio
2 1 (2.86%) Atlassian Bamboo
2 1 (2.86%) SQL Server Management Studio (SSMS)
2 1 (2.86%) Team Foundation Server
General
1 4 (11.43%) Finance
2 3 (8.57%) Manufacturing
3 2 (5.71%) Advertising
3 2 (5.71%) Automotive
4 1 (2.86%) Billing
4 1 (2.86%) Retail
Job Titles
1 28 (80.00%) Developer
2 15 (42.86%) Business Intelligence Developer
3 13 (37.14%) SQL Developer
4 9 (25.71%) C# Developer
5 8 (22.86%) SQL BI Developer
6 7 (20.00%) .NET Developer
6 7 (20.00%) C# .NET Developer
7 6 (17.14%) T-SQL Developer
8 4 (11.43%) Support Engineer
9 3 (8.57%) 3rd Line Support
9 3 (8.57%) 3rd Line Support Engineer
9 3 (8.57%) Analyst
9 3 (8.57%) ASP.NET Developer
9 3 (8.57%) Business Intelligence Analyst
9 3 (8.57%) C# ASP.NET Developer
9 3 (8.57%) DBA
9 3 (8.57%) Integration Developer
9 3 (8.57%) SQL DBA
9 3 (8.57%) SSRS Developer
9 3 (8.57%) XML Developer
Libraries, Frameworks & Software Standards
1 10 (28.57%) .NET
2 8 (22.86%) jQuery
3 6 (17.14%) ASP.NET
4 5 (14.29%) AngularJS
5 4 (11.43%) CSS
6 3 (8.57%) HTML
6 3 (8.57%) SOAP
6 3 (8.57%) Twitter Bootstrap
6 3 (8.57%) XML
7 2 (5.71%) Ajax
7 2 (5.71%) ASP.NET Web API
7 2 (5.71%) Entity Framework
8 1 (2.86%) .NET Framework
8 1 (2.86%) ASP.NET MVC 4
8 1 (2.86%) AutoMapper
8 1 (2.86%) LINQ
8 1 (2.86%) MDX
8 1 (2.86%) Ruby on Rails
8 1 (2.86%) SignalR
8 1 (2.86%) Web Services
Miscellaneous
1 3 (8.57%) Analytical Skills
1 3 (8.57%) Greenfield Project
2 2 (5.71%) Data Centre
2 2 (5.71%) Mobile App
3 1 (2.86%) Analytical Mindset
3 1 (2.86%) Data Structures
3 1 (2.86%) Management Information System
Operating Systems
1 5 (14.29%) Windows
2 4 (11.43%) Windows Server
2 4 (11.43%) Windows Server 2012
Processes & Methodologies
1 20 (57.14%) Business Intelligence
2 12 (34.29%) ETL
3 9 (25.71%) Migration
4 6 (17.14%) Agile Software Development
4 6 (17.14%) MVC
5 5 (14.29%) Kimball Methodology
5 5 (14.29%) Visualisation
6 4 (11.43%) Data Analysis
6 4 (11.43%) Data Management
6 4 (11.43%) Data Migration
6 4 (11.43%) Decision-Making
6 4 (11.43%) Incident Management
6 4 (11.43%) Inversion of Control
6 4 (11.43%) OO
6 4 (11.43%) Problem-Solving
7 3 (8.57%) Data Modelling
7 3 (8.57%) Dimensional Modelling
7 3 (8.57%) User Acceptance Testing
8 2 (5.71%) Investment Management
8 2 (5.71%) Test Automation
Programming Languages
1 33 (94.29%) SQL
2 11 (31.43%) C#
3 8 (22.86%) JavaScript
4 1 (2.86%) C++
4 1 (2.86%) Data Analysis Expressions (DAX)
4 1 (2.86%) Java
4 1 (2.86%) PHP
4 1 (2.86%) Python
4 1 (2.86%) Ruby
Qualifications
1 3 (8.57%) Degree
Vendors
1 11 (31.43%) Microsoft
2 4 (11.43%) VMware
3 2 (5.71%) Tableau
4 1 (2.86%) Sage