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

Transact-SQL
North West > Lancashire
6 months to
17 Aug 2018
Same period 2017 Same period 2016
Rank 45 20 45
Rank change year-on-year -25 +25 +8
Permanent jobs citing T-SQL 37 94 46
As % of all permanent IT jobs advertised in Lancashire 4.38% 10.60% 5.69%
As % of the Programming Languages category 8.85% 17.15% 10.15%
Number of salaries quoted 33 90 32
Lancashire median annual salary £40,000 £35,000 £35,000
Median salary % change year-on-year +14.29% - -6.67%
10th Percentile £30,500 £29,000 £23,750
90th Percentile £57,500 £47,625 £47,575
North West median annual salary £45,000 £38,500 £39,500
% change year-on-year +16.88% -2.53% -1.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 418 548 453
As % of all permanent IT jobs advertised in Lancashire 49.53% 61.78% 56.06%
Number of salaries quoted 380 483 399
Lancashire median annual salary £37,500 £35,000 £35,000
Median salary % change year-on-year +7.14% - -
10th Percentile £26,000 £25,000 £22,750
90th Percentile £56,250 £47,500 £45,000
North West median annual salary £43,000 £40,000 £40,000
% change year-on-year +7.50% - -

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 17 August 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 17 August 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 -5 14 £50,000 +42.86%
Preston +7 10 £35,000 -6.67% 6
Burnley -5 5 £35,000 -
Blackburn -1 4 £31,000 -34.74%
Ormskirk 0 1 £40,000 +26.98% 2
Blackpool -10 1 £20,500 -34.92%
T-SQL
North West

For the 6 months to 17 August 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 36 (97.30%) SQL
2 28 (75.68%) SQL Server
3 20 (54.05%) SQL Server Reporting Services
4 18 (48.65%) Business Intelligence
5 17 (45.95%) SQL Server Analysis Services
6 14 (37.84%) C#
6 14 (37.84%) .NET
7 13 (35.14%) Microsoft
7 13 (35.14%) SQL Server Integration Services
8 10 (27.03%) JavaScript
9 9 (24.32%) ASP.NET
9 9 (24.32%) Agile Software Development
10 8 (21.62%) Data Warehouse
11 7 (18.92%) Performance Tuning
11 7 (18.92%) Degree
11 7 (18.92%) PowerShell
11 7 (18.92%) Test Automation
11 7 (18.92%) SQL Server 2012
11 7 (18.92%) CSS
11 7 (18.92%) HTML
11 7 (18.92%) MVC
11 7 (18.92%) ETL
12 6 (16.22%) Visual Studio
12 6 (16.22%) OO
12 6 (16.22%) jQuery
13 5 (13.51%) Analytics
13 5 (13.51%) Data Visualisation
13 5 (13.51%) Visualisation
13 5 (13.51%) Data Architecture
13 5 (13.51%) Data Modelling

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 (2.70%) NServiceBus
1 1 (2.70%) SharePoint
Applications
1 1 (2.70%) Microsoft Excel
Business Applications
1 1 (2.70%) Sage 500
Cloud Services
1 4 (10.81%) Amazon AWS
1 4 (10.81%) SaaS
2 1 (2.70%) Dynamics 365
Database & Business Intelligence
1 28 (75.68%) SQL Server
2 20 (54.05%) SQL Server Reporting Services
3 17 (45.95%) SQL Server Analysis Services
4 13 (35.14%) SQL Server Integration Services
5 8 (21.62%) Data Warehouse
6 7 (18.92%) SQL Server 2012
7 5 (13.51%) Power BI
8 4 (10.81%) OLAP
8 4 (10.81%) PostgreSQL
8 4 (10.81%) SQL Server 2008
9 3 (8.11%) OLAP Cube
9 3 (8.11%) SQL Server 2016
10 2 (5.41%) Microsoft Analysis Services
10 2 (5.41%) MySQL
10 2 (5.41%) QlikView
10 2 (5.41%) Snowflake Schema
10 2 (5.41%) SQL Server 2014
11 1 (2.70%) PowerPivot
11 1 (2.70%) Redis
11 1 (2.70%) Relational Database
Development Applications
1 6 (16.22%) Visual Studio
2 4 (10.81%) Selenium
2 4 (10.81%) SQL Server Management Studio (SSMS)
2 4 (10.81%) Subversion
3 1 (2.70%) Atlassian Bamboo
3 1 (2.70%) Team Foundation Server
General
1 2 (5.41%) Advertising
1 2 (5.41%) Finance
1 2 (5.41%) Manufacturing
2 1 (2.70%) Automotive
2 1 (2.70%) Retail
Job Titles
1 26 (70.27%) Developer
2 12 (32.43%) SQL Developer
3 10 (27.03%) Business Intelligence Developer
4 9 (24.32%) C# Developer
5 8 (21.62%) .NET Developer
5 8 (21.62%) Analyst
5 8 (21.62%) C# .NET Developer
6 6 (16.22%) DBA
6 6 (16.22%) SQL DBA
7 5 (13.51%) Data Analyst
7 5 (13.51%) Software Developer
7 5 (13.51%) SQL Analyst
7 5 (13.51%) T-SQL Developer
8 4 (10.81%) .NET Software Developer
8 4 (10.81%) C# Software Developer
8 4 (10.81%) SQL BI Developer
8 4 (10.81%) SQL Data Analyst
9 3 (8.11%) Business Intelligence Analyst
9 3 (8.11%) C# ASP.NET Developer
9 3 (8.11%) XML Developer
Libraries, Frameworks & Software Standards
1 14 (37.84%) .NET
2 9 (24.32%) ASP.NET
3 7 (18.92%) CSS
3 7 (18.92%) HTML
4 6 (16.22%) jQuery
5 4 (10.81%) ASP.NET MVC
5 4 (10.81%) Entity Framework
6 3 (8.11%) .NET Framework
6 3 (8.11%) AngularJS
6 3 (8.11%) SOAP
6 3 (8.11%) XML
7 2 (5.41%) ASP.NET MVC 4
7 2 (5.41%) REST
7 2 (5.41%) Twitter Bootstrap
7 2 (5.41%) Web Services
8 1 (2.70%) Ajax
8 1 (2.70%) Angular 2
8 1 (2.70%) ASP.NET Web API
8 1 (2.70%) AutoMapper
8 1 (2.70%) SignalR
Miscellaneous
1 4 (10.81%) Data Protection Act
2 2 (5.41%) Analytical Skills
2 2 (5.41%) Fintech
3 1 (2.70%) Analytical Mindset
3 1 (2.70%) Data Centre
3 1 (2.70%) Management Information System
3 1 (2.70%) Mobile App
3 1 (2.70%) Self-Motivation
Operating Systems
1 4 (10.81%) Unix
2 2 (5.41%) Windows
2 2 (5.41%) Windows Server
2 2 (5.41%) Windows Server 2012
Processes & Methodologies
1 18 (48.65%) Business Intelligence
2 9 (24.32%) Agile Software Development
3 7 (18.92%) ETL
3 7 (18.92%) MVC
3 7 (18.92%) Performance Tuning
3 7 (18.92%) Test Automation
4 6 (16.22%) OO
5 5 (13.51%) Analytics
5 5 (13.51%) Data Architecture
5 5 (13.51%) Data Modelling
5 5 (13.51%) Data Visualisation
5 5 (13.51%) Visualisation
6 4 (10.81%) Data Analytics
6 4 (10.81%) Data Protection
6 4 (10.81%) DevOps
6 4 (10.81%) Inversion of Control
6 4 (10.81%) Migration
6 4 (10.81%) Refactoring
7 3 (8.11%) Statistics
7 3 (8.11%) TDD
Programming Languages
1 36 (97.30%) SQL
2 14 (37.84%) C#
3 10 (27.03%) JavaScript
4 7 (18.92%) PowerShell
5 4 (10.81%) VB.NET
6 3 (8.11%) VBA
7 2 (5.41%) VB
7 2 (5.41%) VBScript
8 1 (2.70%) C++
8 1 (2.70%) Data Analysis Expressions (DAX)
8 1 (2.70%) Java
8 1 (2.70%) PHP
8 1 (2.70%) Python
8 1 (2.70%) Ruby
Qualifications
1 7 (18.92%) Degree
Vendors
1 13 (35.14%) Microsoft
2 4 (10.81%) Capita
3 2 (5.41%) Tableau
3 2 (5.41%) VMware
4 1 (2.70%) Sage