Period
to 21 November 2017

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 6 months to 21 November 2017 with a comparison to the same period in the previous 2 years.

Transact-SQL
Lancashire > Preston
6 months to
21 Nov 2017
Same period 2016 Same period 2015
Rank 36 36 35
Rank change year-on-year 0 -1 +7
Permanent jobs citing T-SQL 11 7 5
As % of all permanent IT jobs advertised in Preston 4.38% 3.13% 2.51%
As % of the Programming Languages category 6.51% 5.38% 4.07%
Number of salaries quoted 8 5 4
Preston median annual salary £43,750 £40,000 £42,500
Median salary % change year-on-year +9.38% -5.88% +15.65%
10th Percentile £31,250 £34,750 £30,075
90th Percentile £50,000 £43,250 £49,375
Lancashire median annual salary £35,000 £35,000 £37,500
% change year-on-year - -6.67% -4.46%

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 Preston with a requirement for coding skills.

All Programming Languages
Preston
Permanent vacancies with a requirement for coding skills 169 130 123
As % of all permanent IT jobs advertised in Preston 67.33% 58.04% 61.81%
Number of salaries quoted 137 121 109
Preston median annual salary £35,000 £32,500 £37,500
Median salary % change year-on-year +7.69% -13.33% +15.38%
10th Percentile £27,875 £22,750 £25,000
90th Percentile £50,000 £43,750 £45,000
Lancashire median annual salary £35,000 £36,500 £35,000
% change year-on-year -4.11% +4.29% -

T-SQL
Job Vacancy Trend in Preston

Job postings citing T-SQL as a percentage of all IT jobs advertised in Preston.

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 6 months to 21 November 2017.

Salary histogram for T-SQL in Preston

For the 6 months to 21 November 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 11 (100.00%) SQL
1 11 (100.00%) SQL Server Reporting Services
2 9 (81.82%) SQL Server
2 9 (81.82%) SQL Server Integration Services
2 9 (81.82%) SQL Server Analysis Services
3 8 (72.73%) C#
3 8 (72.73%) ASP.NET
3 8 (72.73%) SOAP
3 8 (72.73%) XML
3 8 (72.73%) .NET
3 8 (72.73%) Business Intelligence
4 7 (63.64%) Degree
4 7 (63.64%) SQL Server 2008
5 6 (54.55%) SQL Server 2012
5 6 (54.55%) Analytical Skills
5 6 (54.55%) ITIL
5 6 (54.55%) Finance
6 5 (45.45%) Clustering
6 5 (45.45%) Agile Software Development
6 5 (45.45%) Business Analysis
6 5 (45.45%) Dynamics NAV
6 5 (45.45%) SLA
6 5 (45.45%) PRINCE
6 5 (45.45%) Project Management
6 5 (45.45%) ITIL V2
6 5 (45.45%) High Availability
6 5 (45.45%) Functional Testing
6 5 (45.45%) Incident Management
6 5 (45.45%) User Acceptance Testing
6 5 (45.45%) Power BI

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:

Business Applications
1 5 (45.45%) Dynamics NAV
2 1 (9.09%) Cognos TM1
Database & Business Intelligence
1 11 (100.00%) SQL Server Reporting Services
2 9 (81.82%) SQL Server
2 9 (81.82%) SQL Server Analysis Services
2 9 (81.82%) SQL Server Integration Services
3 7 (63.64%) SQL Server 2008
4 6 (54.55%) SQL Server 2012
5 5 (45.45%) Power BI
6 1 (9.09%) Data Warehouse
6 1 (9.09%) Microsoft Analysis Services
General
1 6 (54.55%) Finance
Job Titles
1 5 (45.45%) Technical Leader
2 4 (36.36%) DBA
2 4 (36.36%) Developer
3 3 (27.27%) .NET Developer
3 3 (27.27%) ASP.NET Developer
3 3 (27.27%) C# .NET Developer
3 3 (27.27%) C# ASP.NET Developer
3 3 (27.27%) C# Developer
3 3 (27.27%) SQL DBA
3 3 (27.27%) SQL Developer
3 3 (27.27%) T-SQL Developer
3 3 (27.27%) XML Developer
4 2 (18.18%) .NET Applications Developer
4 2 (18.18%) Analyst
4 2 (18.18%) Applications Developer
4 2 (18.18%) C# Application Developer
4 2 (18.18%) Data Analyst
4 2 (18.18%) Database Analyst
5 1 (9.09%) Business Developer
5 1 (9.09%) Database Specialist
Libraries, Frameworks & Software Standards
1 8 (72.73%) .NET
1 8 (72.73%) ASP.NET
1 8 (72.73%) SOAP
1 8 (72.73%) XML
Miscellaneous
1 6 (54.55%) Analytical Skills
2 5 (45.45%) Clustering
3 1 (9.09%) Data Structures
Processes & Methodologies
1 8 (72.73%) Business Intelligence
2 6 (54.55%) ITIL
3 5 (45.45%) Agile Software Development
3 5 (45.45%) Business Analysis
3 5 (45.45%) Functional Testing
3 5 (45.45%) High Availability
3 5 (45.45%) Incident Management
3 5 (45.45%) ITIL V2
3 5 (45.45%) PRINCE
3 5 (45.45%) Project Management
3 5 (45.45%) User Acceptance Testing
4 2 (18.18%) Data Architecture
4 2 (18.18%) Data Modelling
5 1 (9.09%) ETL
5 1 (9.09%) ETL Development
5 1 (9.09%) Performance Tuning
5 1 (9.09%) Stakeholder Engagement
Programming Languages
1 11 (100.00%) SQL
2 8 (72.73%) C#
Qualifications
1 7 (63.64%) Degree
2 1 (9.09%) ITIL Certification
2 1 (9.09%) Microsoft Certification
Quality Assurance & Compliance
1 5 (45.45%) SLA
Vendors
1 1 (9.09%) Cognos
1 1 (9.09%) IBM
1 1 (9.09%) Microsoft