Period
to 18 July 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 18 July 2018 with a comparison to the same period in the previous 2 years.

Transact-SQL
UK > Wales
6 months to
18 Jul 2018
Same period 2017 Same period 2016
Rank 90 78 52
Rank change year-on-year -12 -26 -9
Permanent jobs citing T-SQL 43 71 117
As % of all permanent IT jobs advertised in Wales 2.25% 3.33% 4.35%
As % of the Programming Languages category 4.15% 6.57% 8.63%
Number of salaries quoted 35 71 100
Wales median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - +8.11%
10th Percentile £27,500 £25,000 £24,775
90th Percentile £47,000 £51,250 £48,875
UK median annual salary £45,000 £45,000 £45,000

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,037 1,080 1,355
As % of all permanent IT jobs advertised in Wales 54.26% 50.61% 50.35%
Number of salaries quoted 840 967 1,182
Wales median annual salary £40,000 £40,000 £37,500
Median salary % change year-on-year - +6.67% +7.14%
10th Percentile £26,250 £25,550 £22,500
90th Percentile £56,000 £55,000 £50,250
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +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 18 July 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 18 July 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 -3 36 £42,500 +6.25% 5
Mid Wales -18 7 - -
T-SQL
UK

For the 6 months to 18 July 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 43 (100.00%) SQL
1 43 (100.00%) SQL Server
2 35 (81.40%) SQL Server Reporting Services
2 35 (81.40%) SQL Server Integration Services
3 34 (79.07%) Business Intelligence
4 24 (55.81%) SQL Server Analysis Services
4 24 (55.81%) SQL Server 2012
5 18 (41.86%) Finance
5 18 (41.86%) Data Warehouse
6 17 (39.53%) C#
6 17 (39.53%) Microsoft
7 16 (37.21%) ETL
8 14 (32.56%) Java
8 14 (32.56%) SQL Server 2008
9 13 (30.23%) VB
9 13 (30.23%) Visual Studio
9 13 (30.23%) Power BI
10 12 (27.91%) Practice Management
11 11 (25.58%) Team Foundation Server
12 10 (23.26%) MVC
12 10 (23.26%) Microsoft Excel
12 10 (23.26%) XML
13 9 (20.93%) SOAP
13 9 (20.93%) Management Information System
13 9 (20.93%) Microsoft Certification
13 9 (20.93%) REST
13 9 (20.93%) Analytics
13 9 (20.93%) Mentoring
14 8 (18.60%) Tableau
14 8 (18.60%) Data Quality

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 8 (18.60%) SharePoint
2 7 (16.28%) BizTalk Server
2 7 (16.28%) Oracle SOA Suite
3 2 (4.65%) IIS
3 2 (4.65%) Tomcat
4 1 (2.33%) Elasticsearch
Applications
1 10 (23.26%) Microsoft Excel
Cloud Services
1 7 (16.28%) Office 365
2 5 (11.63%) Microsoft Azure
3 2 (4.65%) Amazon AWS
Database & Business Intelligence
1 43 (100.00%) SQL Server
2 35 (81.40%) SQL Server Integration Services
2 35 (81.40%) SQL Server Reporting Services
3 24 (55.81%) SQL Server 2012
3 24 (55.81%) SQL Server Analysis Services
4 18 (41.86%) Data Warehouse
5 14 (32.56%) SQL Server 2008
6 13 (30.23%) Power BI
7 8 (18.60%) Microsoft Analysis Services
8 7 (16.28%) Big Data
8 7 (16.28%) MySQL
8 7 (16.28%) PerformancePoint
9 5 (11.63%) SQL Server 2014
9 5 (11.63%) SQL Server 2016
10 2 (4.65%) Azure SQL Database
10 2 (4.65%) Crystal Reports
11 1 (2.33%) OLAP
11 1 (2.33%) Oracle Reports
11 1 (2.33%) SQL Server 2000
11 1 (2.33%) SQL Server 2005
Development Applications
1 13 (30.23%) Visual Studio
2 11 (25.58%) Team Foundation Server
3 1 (2.33%) SQL Server Management Studio (SSMS)
General
1 18 (41.86%) Finance
2 6 (13.95%) Law
3 2 (4.65%) Legal
3 2 (4.65%) Manufacturing
4 1 (2.33%) Advertising
Job Titles
1 29 (67.44%) Developer
2 19 (44.19%) SQL Developer
3 12 (27.91%) Analyst
4 9 (20.93%) SSIS Developer
5 8 (18.60%) Senior Analyst
5 8 (18.60%) SSRS Developer
6 7 (16.28%) Integration Analyst
6 7 (16.28%) Senior Integration Analyst
7 6 (13.95%) T-SQL Developer
8 5 (11.63%) Business Intelligence Developer
9 3 (6.98%) Senior Developer
9 3 (6.98%) Software Developer
10 2 (4.65%) .NET Developer
10 2 (4.65%) DBA
10 2 (4.65%) Open Source Developer
10 2 (4.65%) Senior .NET Developer
10 2 (4.65%) SQL Analyst
10 2 (4.65%) SQL BI Developer
10 2 (4.65%) SQL DBA
11 1 (2.33%) Senior Database Developer
Libraries, Frameworks & Software Standards
1 10 (23.26%) XML
2 9 (20.93%) REST
2 9 (20.93%) SOAP
3 7 (16.28%) Web Services
4 4 (9.30%) .NET
4 4 (9.30%) CSS
4 4 (9.30%) HTML
5 3 (6.98%) XSLT
6 2 (4.65%) ASP.NET
6 2 (4.65%) ASP.NET MVC
6 2 (4.65%) XForms
7 1 (2.33%) Ajax
7 1 (2.33%) CakePHP
7 1 (2.33%) jQuery
7 1 (2.33%) Sass
Miscellaneous
1 9 (20.93%) Management Information System
2 7 (16.28%) Enterprise Software
2 7 (16.28%) Virtual Team
3 2 (4.65%) Analytical Skills
3 2 (4.65%) NHS
4 1 (2.33%) Greenfield Project
4 1 (2.33%) Xbox
Operating Systems
1 1 (2.33%) Windows
1 1 (2.33%) Windows 10
1 1 (2.33%) Windows 7
1 1 (2.33%) Windows 8
1 1 (2.33%) Windows Server
Processes & Methodologies
1 34 (79.07%) Business Intelligence
2 16 (37.21%) ETL
3 12 (27.91%) Practice Management
4 10 (23.26%) MVC
5 9 (20.93%) Analytics
5 9 (20.93%) Mentoring
6 8 (18.60%) Data Modelling
6 8 (18.60%) ITIL
6 8 (18.60%) Project Management
6 8 (18.60%) Validation
7 7 (16.28%) Agile Software Development
7 7 (16.28%) Business Process Modelling
7 7 (16.28%) Change Data Capture
7 7 (16.28%) Data Integration
7 7 (16.28%) EAI
7 7 (16.28%) Kimball Methodology
7 7 (16.28%) Master Data Management
7 7 (16.28%) Predictive Analytics
7 7 (16.28%) SOA
7 7 (16.28%) Visualisation
Programming Languages
1 43 (100.00%) SQL
2 17 (39.53%) C#
3 14 (32.56%) Java
4 13 (30.23%) VB
5 8 (18.60%) VBA
6 7 (16.28%) PL/SQL
6 7 (16.28%) PowerShell
7 4 (9.30%) JavaScript
8 1 (2.33%) PHP
8 1 (2.33%) VB.NET
Qualifications
1 9 (20.93%) Microsoft Certification
2 7 (16.28%) ITIL Certification
2 7 (16.28%) Postgraduate
3 2 (4.65%) MCSA
4 1 (2.33%) SC Cleared
4 1 (2.33%) Security Cleared
Quality Assurance & Compliance
1 8 (18.60%) Data Quality
2 1 (2.33%) PMO
2 1 (2.33%) QA
Systems Management
1 1 (2.33%) Systems Management Server (SMS)
Vendors
1 17 (39.53%) Microsoft
2 8 (18.60%) Oracle
2 8 (18.60%) Tableau
3 2 (4.65%) Cognos
3 2 (4.65%) Salesforce.com