The following table provides summary statistics for permanent job vacancies advertised in Preston 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 3 months to 22 June 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
Lancashire / Preston
3 months to
22 Jun 2017
Same period 2016 Same period 2015
Rank 29 28 -
Rank change year-on-year -1 -  
Permanent jobs citing T-SQL 11 3 0
As % of all permanent IT jobs advertised in Preston 6.63% 3.13% -
As % of the Programming Languages category 9.24% 4.35% -
Number of salaries quoted 8 3 0
Median salary £35,000 £40,000 -
Median salary % change year-on-year -12.50% -  
UK excluding London median salary £40,000 £40,500 £40,000
% change year-on-year -1.23% +1.25%  

T-SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Preston with a requirement for programming language skills.

Programming Language Skills
Preston
Permanent job vacancies with a requirement for programming language skills 119 69 106
As % of all permanent IT job vacancies advertised in Preston 71.69% 71.88% 67.09%
Number of salaries quoted 101 60 71
Median salary £32,500 £32,500 £30,500
Median salary % change year-on-year - +6.55%  
90% offered a salary of more than £30,500 £22,500 £25,250
10% offered a salary of more than £42,500 £45,000 £45,000
UK excluding London median salary £42,500 £41,000 £40,000
% change year-on-year +3.65% +2.50%  

T-SQL
Job Vacancy Trend in Preston

The job posting trend of jobs advertised in Preston citing T-SQL as a proportion of all permanent or contract IT jobs with a match in the Programming Languages category.

Job vacancy trend for T-SQL in Preston

T-SQL
Salary Trend in Preston

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in Preston.

Salary trend for T-SQL in Preston

T-SQL
Salary Histogram in Preston

The salary distribution of IT jobs citing T-SQL in Preston over the 3 months to 22 June 2017.

Salary histogram for T-SQL in Preston

For the 6 months to 22 June 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 Preston region with a requirement for T-SQL.

1 13 (100.00%) SQL
2 12 (92.31%) SQL Server
3 11 (84.62%) Business Intelligence
3 11 (84.62%) SQL Server Reporting Services
3 11 (84.62%) Degree
4 7 (53.85%) Data Architecture
4 7 (53.85%) Data Modelling
5 6 (46.15%) .NET
6 5 (38.46%) C#
6 5 (38.46%) ASP.NET
6 5 (38.46%) SOAP
6 5 (38.46%) XML
7 4 (30.77%) SQL Server 2008
7 4 (30.77%) Agile Software Development
7 4 (30.77%) SQL Server Integration Services
7 4 (30.77%) SQL Server Analysis Services
7 4 (30.77%) SQL Server 2012
8 3 (23.08%) Functional Testing
8 3 (23.08%) ITIL V2
8 3 (23.08%) High Availability
8 3 (23.08%) Analytical Skills
8 3 (23.08%) Power BI
8 3 (23.08%) Incident Management
8 3 (23.08%) User Acceptance Testing
8 3 (23.08%) Business Analysis
8 3 (23.08%) Dynamics NAV
8 3 (23.08%) Clustering
8 3 (23.08%) ITIL
8 3 (23.08%) Data Warehouse
8 3 (23.08%) Finance

T-SQL
Co-occurring IT Skills in Preston 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 (15.38%) IIS
Business Applications
1 3 (23.08%) Dynamics NAV
Database & Business Intelligence
1 12 (92.31%) SQL Server
2 11 (84.62%) SQL Server Reporting Services
3 4 (30.77%) SQL Server 2008
3 4 (30.77%) SQL Server 2012
3 4 (30.77%) SQL Server Analysis Services
3 4 (30.77%) SQL Server Integration Services
4 3 (23.08%) Data Warehouse
4 3 (23.08%) Power BI
General
1 3 (23.08%) Finance
2 1 (7.69%) Pharmaceutical
Job Titles
1 7 (53.85%) Developer
2 3 (23.08%) Administrator
2 3 (23.08%) Analyst
2 3 (23.08%) Business Intelligence Developer
2 3 (23.08%) Data Administrator
2 3 (23.08%) Data Analyst
2 3 (23.08%) Database Analyst
2 3 (23.08%) DBA
2 3 (23.08%) Technical Leader
3 2 (15.38%) .NET Developer
3 2 (15.38%) Business Developer
3 2 (15.38%) Data Warehouse Developer
3 2 (15.38%) Senior .NET Developer
3 2 (15.38%) Senior Developer
4 1 (7.69%) C# Developer
4 1 (7.69%) HTML Developer
4 1 (7.69%) Senior C# Developer
4 1 (7.69%) Senior Software Developer
4 1 (7.69%) Software Developer
4 1 (7.69%) SQL Developer
Libraries, Frameworks & Software Standards
1 6 (46.15%) .NET
2 5 (38.46%) ASP.NET
2 5 (38.46%) SOAP
2 5 (38.46%) XML
3 2 (15.38%) .NET Framework
3 2 (15.38%) ADO.NET
3 2 (15.38%) CSS
3 2 (15.38%) HTML
3 2 (15.38%) jQuery
3 2 (15.38%) WCF
3 2 (15.38%) XSL
4 1 (7.69%) ASP.NET MVC
Miscellaneous
1 3 (23.08%) Analytical Skills
1 3 (23.08%) Clustering
2 2 (15.38%) Enterprise Software
Processes & Methodologies
1 11 (84.62%) Business Intelligence
2 7 (53.85%) Data Architecture
2 7 (53.85%) Data Modelling
3 4 (30.77%) Agile Software Development
4 3 (23.08%) Business Analysis
4 3 (23.08%) Functional Testing
4 3 (23.08%) High Availability
4 3 (23.08%) Incident Management
4 3 (23.08%) ITIL
4 3 (23.08%) ITIL V2
4 3 (23.08%) PRINCE
4 3 (23.08%) Project Management
4 3 (23.08%) User Acceptance Testing
5 2 (15.38%) Analytics
5 2 (15.38%) Data Analytics
5 2 (15.38%) Kalman Filter
5 2 (15.38%) Multithreading
5 2 (15.38%) Parallel Computing
5 2 (15.38%) Web Application Development
6 1 (7.69%) Load Testing
Programming Languages
1 13 (100.00%) SQL
2 5 (38.46%) C#
3 2 (15.38%) JavaScript
Qualifications
1 11 (84.62%) Degree
2 2 (15.38%) Microsoft Certification
3 1 (7.69%) MCAD
3 1 (7.69%) MCPD
Quality Assurance & Compliance
1 3 (23.08%) SLA
Vendors
1 2 (15.38%) Microsoft
2 1 (7.69%) Epicor
2 1 (7.69%) Oracle