Period
to 20 August 2018

The following table provides summary statistics for permanent job vacancies advertised in Staffordshire 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 August 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
West Midlands > Staffordshire
6 months to
20 Aug 2018
Same period 2017 Same period 2016
Rank 23 27 18
Rank change year-on-year +4 -9 +1
Permanent jobs citing T-SQL 76 77 163
As % of all permanent IT jobs advertised in Staffordshire 8.83% 7.67% 12.69%
As % of the Programming Languages category 15.45% 12.60% 19.95%
Number of salaries quoted 73 57 174
Staffordshire median annual salary £40,000 £41,000 £38,500
Median salary % change year-on-year -2.44% +6.49% +2.67%
10th Percentile £30,200 £32,500 £19,750
90th Percentile £52,500 £53,250 £48,000
West Midlands median annual salary £40,000 £41,500 £37,500
% change year-on-year -3.61% +10.67% -

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

All Programming Languages
Staffordshire
Permanent vacancies with a requirement for coding skills 492 611 817
As % of all permanent IT jobs advertised in Staffordshire 57.14% 60.86% 63.63%
Number of salaries quoted 437 513 753
Staffordshire median annual salary £39,500 £37,500 £37,500
Median salary % change year-on-year +5.33% - -
10th Percentile £21,500 £21,600 £22,300
90th Percentile £54,000 £54,950 £52,500
West Midlands median annual salary £42,500 £40,000 £37,500
% change year-on-year +6.25% +6.67% -

T-SQL
Job Vacancy Trend in Staffordshire

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

Job vacancy trend for T-SQL in Staffordshire

T-SQL
Salary Trend in Staffordshire

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

Salary trend for T-SQL in Staffordshire

T-SQL
Salary Histogram in Staffordshire

The salary distribution of IT jobs citing T-SQL in Staffordshire over the 6 months to 20 August 2018.

Salary histogram for T-SQL in Staffordshire

T-SQL
Job Locations in Staffordshire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Staffordshire region over the 6 months to 20 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
Stoke-on-Trent +7 47 £42,500 - 9
Tamworth -16 6 £43,000 +17.81% 3
Lichfield +10 3 £23,000 -45.88% 2
Burton-upon-Trent - 2 £33,250 - 1
Cannock - 2 £28,250 - 2
Stafford +20 1 £40,000 -11.11%
T-SQL
West Midlands

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

1 76 (100.00%) SQL
2 60 (78.95%) SQL Server
3 54 (71.05%) .NET
4 42 (55.26%) C#
5 29 (38.16%) ASP.NET
5 29 (38.16%) SQL Server Integration Services
6 26 (34.21%) SQL Server Reporting Services
6 26 (34.21%) HTML
6 26 (34.21%) MVC
6 26 (34.21%) ASP.NET Web API
7 24 (31.58%) .NET Framework
7 24 (31.58%) JavaScript
8 23 (30.26%) Team Foundation Server
8 23 (30.26%) Entity Framework
9 22 (28.95%) Microsoft Azure
9 22 (28.95%) Agile Software Development
9 22 (28.95%) VB.NET
9 22 (28.95%) CSS
9 22 (28.95%) XML
10 20 (26.32%) Windows
10 20 (26.32%) Microsoft
10 20 (26.32%) Web Development
10 20 (26.32%) SQL Server 2008
11 19 (25.00%) Visual Studio
12 18 (23.68%) WCF
12 18 (23.68%) WinForms
12 18 (23.68%) Problem-Solving
13 17 (22.37%) ASP.NET MVC
14 16 (21.05%) OOP
15 13 (17.11%) Analytical Skills

T-SQL
Co-occurring IT Skills in Staffordshire 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 3 (3.95%) IIS
2 2 (2.63%) CMS
Applications
1 6 (7.89%) Photoshop
2 4 (5.26%) Microsoft Excel
3 1 (1.32%) Microsoft Office
Cloud Services
1 22 (28.95%) Microsoft Azure
2 5 (6.58%) Azure Functions
2 5 (6.58%) Google Analytics
2 5 (6.58%) Serverless
3 2 (2.63%) Amazon AWS
Communications & Networking
1 3 (3.95%) Internet
2 2 (2.63%) SMS
3 1 (1.32%) DAB
Database & Business Intelligence
1 60 (78.95%) SQL Server
2 29 (38.16%) SQL Server Integration Services
3 26 (34.21%) SQL Server Reporting Services
4 20 (26.32%) SQL Server 2008
5 11 (14.47%) SQL Server Analysis Services
6 9 (11.84%) SQL Server 2012
7 7 (9.21%) Cosmos DB
7 7 (9.21%) SQL Server 2005
8 5 (6.58%) Redis
9 4 (5.26%) Relational Database
9 4 (5.26%) SQL Server 2016
10 3 (3.95%) OLTP
10 3 (3.95%) Power BI
11 2 (2.63%) SQL Server 2014
12 1 (1.32%) Azure SQL Database
12 1 (1.32%) Crystal Reports
12 1 (1.32%) Data Warehouse
12 1 (1.32%) MySQL
12 1 (1.32%) OLAP
12 1 (1.32%) Spotfire
Development Applications
1 23 (30.26%) Team Foundation Server
2 19 (25.00%) Visual Studio
3 8 (10.53%) NSubstitute
3 8 (10.53%) NUnit
4 7 (9.21%) Git (software)
5 6 (7.89%) Visual Studio Team System
6 4 (5.26%) ReSharper
7 1 (1.32%) Jenkins
General
1 11 (14.47%) Finance
2 3 (3.95%) Retail
3 2 (2.63%) Manufacturing
4 1 (1.32%) Automotive
4 1 (1.32%) Marketing
Job Titles
1 69 (90.79%) Developer
2 25 (32.89%) .NET Developer
3 24 (31.58%) C# Developer
4 23 (30.26%) SQL Developer
5 17 (22.37%) C# .NET Developer
5 17 (22.37%) Software Developer
6 14 (18.42%) Web Developer
7 11 (14.47%) ASP.NET Developer
7 11 (14.47%) C# ASP.NET Developer
8 10 (13.16%) ASP.NET MVC Developer
9 9 (11.84%) .NET Web Developer
9 9 (11.84%) C# Software Developer
10 7 (9.21%) C# Web Developer
11 6 (7.89%) .NET Software Developer
11 6 (7.89%) DBA
11 6 (7.89%) Senior Developer
11 6 (7.89%) Senior Web Developer
11 6 (7.89%) SQL DBA
12 4 (5.26%) Senior ASP.NET Developer
12 4 (5.26%) Senior C# Developer
Libraries, Frameworks & Software Standards
1 54 (71.05%) .NET
2 29 (38.16%) ASP.NET
3 26 (34.21%) ASP.NET Web API
3 26 (34.21%) HTML
4 24 (31.58%) .NET Framework
5 23 (30.26%) Entity Framework
6 22 (28.95%) CSS
6 22 (28.95%) XML
7 18 (23.68%) WCF
7 18 (23.68%) WinForms
8 17 (22.37%) ASP.NET MVC
9 11 (14.47%) RESTful
10 10 (13.16%) Ajax
10 10 (13.16%) jQuery
10 10 (13.16%) SOAP
11 9 (11.84%) ASP.NET Web Forms
12 8 (10.53%) CSS3
12 8 (10.53%) Ninject
12 8 (10.53%) REST
12 8 (10.53%) Web Services
Miscellaneous
1 13 (17.11%) Analytical Skills
2 12 (15.79%) Replication
3 8 (10.53%) Greenfield Project
4 5 (6.58%) Self-Motivation
5 4 (5.26%) Management Information System
6 3 (3.95%) N-Tier
7 2 (2.63%) Analytical Mindset
7 2 (2.63%) Computer Science
8 1 (1.32%) Algorithms
8 1 (1.32%) Social Media
Operating Systems
1 20 (26.32%) Windows
2 5 (6.58%) Android
3 1 (1.32%) Windows Server 2008
3 1 (1.32%) Windows Server 2012
Processes & Methodologies
1 26 (34.21%) MVC
2 22 (28.95%) Agile Software Development
3 20 (26.32%) Web Development
4 18 (23.68%) Problem-Solving
5 16 (21.05%) OOP
6 12 (15.79%) ETL
6 12 (15.79%) Performance Tuning
6 12 (15.79%) Statistics
7 11 (14.47%) Business Intelligence
7 11 (14.47%) Data Development
8 10 (13.16%) Test Automation
9 9 (11.84%) Migration
9 9 (11.84%) OOD
9 9 (11.84%) TDD
9 9 (11.84%) User Acceptance Testing
10 8 (10.53%) Dependency Injection
10 8 (10.53%) Inversion of Control
10 8 (10.53%) Unit Testing
11 6 (7.89%) OO
11 6 (7.89%) Web Design
Programming Languages
1 76 (100.00%) SQL
2 42 (55.26%) C#
3 24 (31.58%) JavaScript
4 22 (28.95%) VB.NET
5 6 (7.89%) XPath
6 3 (3.95%) XAML
7 2 (2.63%) PowerShell
8 1 (1.32%) C++
8 1 (1.32%) Java
8 1 (1.32%) PHP
Qualifications
1 6 (7.89%) Degree
2 4 (5.26%) Microsoft Certification
3 2 (2.63%) Computer Science Degree
Quality Assurance & Compliance
1 4 (5.26%) SLA
2 3 (3.95%) ISO/IEC 27001
Systems Management
1 3 (3.95%) Systems Management Server (SMS)
Vendors
1 20 (26.32%) Microsoft
2 7 (9.21%) IDERA
3 5 (6.58%) Cognos
3 5 (6.58%) Google
3 5 (6.58%) Tableau
4 3 (3.95%) Alteryx
4 3 (3.95%) DevExpress
5 1 (1.32%) TIBCO