Period
to 19 October 2018

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

Transact-SQL
UK > Wales
6 months to
19 Oct 2018
Same period 2017 Same period 2016
Rank 84 95 45
Rank change year-on-year +11 -50 +16
Permanent jobs citing T-SQL 49 42 139
As % of all permanent IT jobs advertised in Wales 2.44% 2.16% 5.24%
As % of the Programming Languages category 4.51% 4.72% 10.16%
Number of salaries quoted 45 39 126
Wales median annual salary £42,500 £37,500 £36,467
Median salary % change year-on-year +13.33% +2.83% +4.19%
10th Percentile £27,600 £22,500 £22,500
90th Percentile £54,800 £45,000 £48,750
UK median annual salary £45,500 £45,000 £45,000
% change year-on-year +1.11% - +5.88%

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

All Programming Languages
Wales
Permanent vacancies with a requirement for coding skills 1,086 889 1,368
As % of all permanent IT jobs advertised in Wales 54.00% 45.73% 51.60%
Number of salaries quoted 909 824 1,228
Wales median annual salary £40,000 £40,000 £37,500
Median salary % change year-on-year - +6.67% +7.14%
10th Percentile £26,150 £24,250 £22,500
90th Percentile £61,250 £55,000 £51,250
UK median annual salary £50,000 £48,500 £47,500
% change year-on-year +3.09% +2.11% +5.56%

T-SQL
Job Vacancy Trend in Wales

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

Job vacancy trend for T-SQL in Wales

T-SQL
Salary Trend in Wales

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

Salary trend for T-SQL in Wales

T-SQL
Salary Histogram in Wales

The salary distribution of IT jobs citing T-SQL in Wales over the 6 months to 19 October 2018.

Salary histogram for T-SQL in Wales

T-SQL
Job Locations in Wales

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Wales region over the 6 months to 19 October 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
South Wales +27 46 £42,500 +42.86% 6
West Wales -11 3 £31,000 -17.33% 1
T-SQL
UK

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

1 49 (100.00%) SQL
2 46 (93.88%) SQL Server
3 40 (81.63%) SQL Server Integration Services
4 37 (75.51%) SQL Server Reporting Services
5 30 (61.22%) Business Intelligence
6 23 (46.94%) SQL Server Analysis Services
7 21 (42.86%) Finance
8 20 (40.82%) C#
9 17 (34.69%) SQL Server 2012
10 16 (32.65%) Visual Studio
11 15 (30.61%) Data Warehouse
11 15 (30.61%) SQL Server 2008
12 13 (26.53%) Microsoft
12 13 (26.53%) Java
12 13 (26.53%) VB
13 12 (24.49%) ETL
13 12 (24.49%) Practice Management
13 12 (24.49%) Team Foundation Server
14 11 (22.45%) Visualisation
14 11 (22.45%) Agile Software Development
14 11 (22.45%) MVC
14 11 (22.45%) Microsoft Excel
14 11 (22.45%) XML
15 10 (20.41%) Tableau
16 9 (18.37%) Data Visualisation
17 8 (16.33%) PowerShell
18 7 (14.29%) Microsoft Azure
18 7 (14.29%) VBA
18 7 (14.29%) .NET
19 6 (12.24%) ASP.NET

T-SQL
Co-occurring IT Skills in Wales 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 (4.08%) Appian
2 1 (2.04%) Elasticsearch
Applications
1 11 (22.45%) Microsoft Excel
Cloud Services
1 7 (14.29%) Microsoft Azure
2 4 (8.16%) Amazon AWS
3 1 (2.04%) IaaS
3 1 (2.04%) PaaS
3 1 (2.04%) SaaS
Communications & Networking
1 1 (2.04%) SAN
Database & Business Intelligence
1 46 (93.88%) SQL Server
2 40 (81.63%) SQL Server Integration Services
3 37 (75.51%) SQL Server Reporting Services
4 23 (46.94%) SQL Server Analysis Services
5 17 (34.69%) SQL Server 2012
6 15 (30.61%) Data Warehouse
6 15 (30.61%) SQL Server 2008
7 6 (12.24%) SQL Server 2016
8 5 (10.20%) Power BI
8 5 (10.20%) SQL Server 2014
9 3 (6.12%) Microsoft Analysis Services
9 3 (6.12%) Oracle Database
10 2 (4.08%) Azure SQL Database
11 1 (2.04%) Crystal Reports
11 1 (2.04%) OLAP
11 1 (2.04%) OLAP Cube
11 1 (2.04%) Oracle Database 10g
Development Applications
1 16 (32.65%) Visual Studio
2 12 (24.49%) Team Foundation Server
3 2 (4.08%) Git (software)
3 2 (4.08%) Jenkins
4 1 (2.04%) SQL Server Management Studio (SSMS)
General
1 21 (42.86%) Finance
2 6 (12.24%) Law
3 3 (6.12%) Marketing
4 2 (4.08%) Legal
5 1 (2.04%) Advertising
Job Titles
1 28 (57.14%) Developer
2 18 (36.73%) SQL Developer
3 7 (14.29%) Business Intelligence Developer
4 6 (12.24%) Analyst
4 6 (12.24%) DBA
4 6 (12.24%) SQL DBA
4 6 (12.24%) SSIS Developer
4 6 (12.24%) SSRS Developer
4 6 (12.24%) T-SQL Developer
5 4 (8.16%) .NET Developer
6 3 (6.12%) Data Warehouse Developer
6 3 (6.12%) Infrastructure Engineer
6 3 (6.12%) SQL Analyst
7 2 (4.08%) Business Intelligence Analyst
7 2 (4.08%) Senior .NET Developer
7 2 (4.08%) Senior Developer
7 2 (4.08%) Senior Software Engineer
7 2 (4.08%) Software Engineer
7 2 (4.08%) SQL BI Developer
8 1 (2.04%) Business Developer
Libraries, Frameworks & Software Standards
1 11 (22.45%) XML
2 7 (14.29%) .NET
3 6 (12.24%) ASP.NET
4 5 (10.20%) CSS
4 5 (10.20%) HTML
5 2 (4.08%) Ajax
5 2 (4.08%) ASP.NET MVC
5 2 (4.08%) HTML5
5 2 (4.08%) jQuery
5 2 (4.08%) JSON
5 2 (4.08%) REST
5 2 (4.08%) SOAP
5 2 (4.08%) XSLT
6 1 (2.04%) CGI
6 1 (2.04%) Sass
Miscellaneous
1 5 (10.20%) Analytical Skills
2 3 (6.12%) Fintech
3 2 (4.08%) Clustering
3 2 (4.08%) Digital Media
3 2 (4.08%) Enterprise Software
3 2 (4.08%) Replication
4 1 (2.04%) Self-Motivation
4 1 (2.04%) User Experience
Operating Systems
1 2 (4.08%) Windows
1 2 (4.08%) Windows Server
2 1 (2.04%) Windows 10
2 1 (2.04%) Windows 7
2 1 (2.04%) Windows 8
2 1 (2.04%) Windows Server 2008
2 1 (2.04%) Windows Server 2012
Processes & Methodologies
1 30 (61.22%) Business Intelligence
2 12 (24.49%) ETL
2 12 (24.49%) Practice Management
3 11 (22.45%) Agile Software Development
3 11 (22.45%) MVC
3 11 (22.45%) Visualisation
4 9 (18.37%) Data Visualisation
5 6 (12.24%) ETL Development
5 6 (12.24%) SDLC
6 5 (10.20%) Decision-Making
6 5 (10.20%) Problem-Solving
7 4 (8.16%) Continuous Improvement
7 4 (8.16%) CRM
7 4 (8.16%) Data Security
7 4 (8.16%) Dimensional Modelling
7 4 (8.16%) Mentoring
8 3 (6.12%) Data Cleansing
8 3 (6.12%) Infrastructure Engineering
8 3 (6.12%) Performance Tuning
9 2 (4.08%) Functional Programming
Programming Languages
1 49 (100.00%) SQL
2 20 (40.82%) C#
3 13 (26.53%) Java
3 13 (26.53%) VB
4 8 (16.33%) PowerShell
5 7 (14.29%) VBA
6 3 (6.12%) JavaScript
7 2 (4.08%) VB.NET
Qualifications
1 4 (8.16%) MCSA
1 4 (8.16%) Microsoft Certification
2 1 (2.04%) Degree
2 1 (2.04%) DV Cleared
2 1 (2.04%) SC Cleared
2 1 (2.04%) Security Cleared
Quality Assurance & Compliance
1 2 (4.08%) SLA
2 1 (2.04%) Data Quality
2 1 (2.04%) QA
Systems Management
1 1 (2.04%) Failover Clustering
1 1 (2.04%) Microsoft Clustering
1 1 (2.04%) Systems Management Server (SMS)
Vendors
1 13 (26.53%) Microsoft
2 10 (20.41%) Tableau
3 4 (8.16%) Salesforce.com
4 3 (6.12%) Oracle
5 2 (4.08%) Cognos
6 1 (2.04%) Facebook
6 1 (2.04%) NetApp
6 1 (2.04%) RedGate