The table below looks at the statistics for T-SQL skills in IT jobs advertised for the Preston region. Included is a guide to the average salaries offered in IT jobs that have cited T-SQL over the 3 months to 28 April 2016 with a comparison to the same period in the previous 2 years.

3 months to
28 Apr 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 16 25 17
Rank change year-on-year
+9 -8
Permanent jobs citing T-SQL 8 1 12
As % of all permanent IT jobs located in Preston 10.96% 1.03% 9.84%
As % of the Programming Languages category 15.69% 1.41% 16.22%
Number of salaries quoted 8 1 11
Average salary £40,000 £27,500 £42,500
Average salary % change year-on-year
+45.45% -35.29%
UK excluding London average salary £40,000 £40,000 £38,000
% change year-on-year
- +5.26%
T-SQL
Lancashire

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in permanent jobs advertised in the Preston region.

Programming Languages Category
Preston
Permanent IT job ads with a match in the
Programming Languages category
51 71 74
As % of all permanent IT jobs located in Preston 69.86% 73.20% 60.66%
Number of salaries quoted 48 42 69
Average salary £37,500 £30,000 £37,500
Average salary % change year-on-year
+25.00% -20.00%
90% offered a salary of more than £22,500 £26,800 £30,000
10% offered a salary of more than £45,000 £55,000 £40,000
UK excluding London average salary £41,000 £40,000 £39,500
% change year-on-year
+2.50% +1.26%

T-SQL
Jobs Demand Trend in Preston

This chart provides a 3-month moving total of permanent IT jobs citing T-SQL across the Preston region as a proportion of the total demand within the Programming Languages category.

T-SQL Jobs Demand Trend 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 across the Preston region.

T-SQL Salary Trend in Preston

T-SQL
Salary Histogram in Preston

This chart provides a salary histogram for IT jobs citing T-SQL across the Preston region over the 3 months to 28 April 2016.

T-SQL Salary Histogram in Preston

T-SQL
Top 30 Related IT Skills in Preston

For the 6 months to 28 April 2016, IT jobs across the Preston region citing T-SQL also mentioned the following IT skills in order of popularity. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited T-SQL.

1 10 (100.00%) SQL
2 9 (90.00%) SQL Server
2 9 (90.00%) Business Intelligence
3 8 (80.00%) SQL Server Integration Services
4 7 (70.00%) SQL Server Reporting Services
5 6 (60.00%) ETL
5 6 (60.00%) SQL Server 2012
6 5 (50.00%) Agile Software Development
6 5 (50.00%) Microsoft
7 4 (40.00%) Scrum
7 4 (40.00%) Root Cause Analysis
7 4 (40.00%) Data Integration
7 4 (40.00%) Team Foundation Server
7 4 (40.00%) SQL Server 2014
8 3 (30.00%) Change Data Capture
8 3 (30.00%) Kanban
8 3 (30.00%) Replication
8 3 (30.00%) Clustering
9 2 (20.00%) Project Management
9 2 (20.00%) MS Excel
9 2 (20.00%) Data Warehouse
9 2 (20.00%) Data Modelling
9 2 (20.00%) OLAP
9 2 (20.00%) ASP.NET
9 2 (20.00%) .NET
9 2 (20.00%) SQL Server Analysis Services
9 2 (20.00%) Integration Testing
9 2 (20.00%) Functional Testing
9 2 (20.00%) Relational Database
9 2 (20.00%) Mentoring

T-SQL
Top Related IT Skills in Preston by Category

For the 6 months to 28 April 2016, IT jobs across the Preston region citing T-SQL also mentioned the following IT skills grouped by category. The figures indicate the number of jobs and their proportion against the total number of IT job ads sampled that cited T-SQL. Up to 20 skills are shown per category.

Applications
1 2 (20.00%) MS Excel
Database & Business Intelligence
1 9 (90.00%) SQL Server
2 8 (80.00%) SQL Server Integration Services
3 7 (70.00%) SQL Server Reporting Services
4 6 (60.00%) SQL Server 2012
5 4 (40.00%) SQL Server 2014
6 2 (20.00%) Data Warehouse
6 2 (20.00%) Enterprise Data Warehouse
6 2 (20.00%) OLAP
6 2 (20.00%) OLAP Cube
6 2 (20.00%) Relational Database
6 2 (20.00%) SQL Server Analysis Services
Development Applications
1 4 (40.00%) Team Foundation Server
General
1 1 (10.00%) Finance
1 1 (10.00%) Manufacturing
Job Titles
1 9 (90.00%) Developer
2 5 (50.00%) Business Intelligence Developer
3 4 (40.00%) SQL Developer
4 3 (30.00%) SQL BI Developer
5 2 (20.00%) .NET Developer
5 2 (20.00%) Microsoft BI Developer
5 2 (20.00%) Microsoft Developer
5 2 (20.00%) Software Developer
5 2 (20.00%) SSRS Developer
6 1 (10.00%) Analyst
6 1 (10.00%) ASP.NET Developer
6 1 (10.00%) Business Analyst
6 1 (10.00%) C# Developer
6 1 (10.00%) ERP Analyst
6 1 (10.00%) ERP Business Analyst
6 1 (10.00%) FMCG Analyst
6 1 (10.00%) FMCG Business Analyst
6 1 (10.00%) SQL Server BI Developer
6 1 (10.00%) SQL Server Developer
6 1 (10.00%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 2 (20.00%) .NET
1 2 (20.00%) ASP.NET
2 1 (10.00%) .NET Framework
2 1 (10.00%) ASP.NET MVC
2 1 (10.00%) Classic ASP
2 1 (10.00%) WCF
2 1 (10.00%) Web Services
Miscellaneous
1 4 (40.00%) Data Integration
2 3 (30.00%) Clustering
2 3 (30.00%) Replication
3 1 (10.00%) FMCG
Processes & Methodologies
1 9 (90.00%) Business Intelligence
2 6 (60.00%) ETL
3 5 (50.00%) Agile Software Development
4 4 (40.00%) Root Cause Analysis
4 4 (40.00%) Scrum
5 3 (30.00%) Change Data Capture
5 3 (30.00%) Kanban
6 2 (20.00%) Continuous Improvement
6 2 (20.00%) Data Modelling
6 2 (20.00%) Functional Testing
6 2 (20.00%) Integration Testing
6 2 (20.00%) Mentoring
6 2 (20.00%) Project Management
7 1 (10.00%) Business Analysis
7 1 (10.00%) ERP
7 1 (10.00%) MVC
7 1 (10.00%) OOD
7 1 (10.00%) Software Testing
7 1 (10.00%) Test Scripting
7 1 (10.00%) User Stories
Programming Languages
1 10 (100.00%) SQL
2 1 (10.00%) C#
2 1 (10.00%) VB.NET
Vendors
1 5 (50.00%) Microsoft