Period
to 17 January 2018

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

Transact-SQL
South West > Dorset
6 months to
17 Jan 2018
Same period 2017 Same period 2016
Rank 65 77 60
Rank change year-on-year +12 -17 -18
Permanent jobs citing T-SQL 57 21 72
As % of all permanent IT jobs advertised in Dorset 4.25% 2.16% 4.76%
As % of the Programming Languages category 6.61% 3.30% 8.12%
Number of salaries quoted 56 16 61
Dorset median annual salary £37,500 £45,000 £37,500
Median salary % change year-on-year -16.67% +20.00% +7.14%
10th Percentile £29,000 £37,500 £27,500
90th Percentile £48,125 £47,500 £50,000
South West median annual salary £40,000 £40,000 £37,500
% change year-on-year - +6.67% +4.84%

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

All Programming Languages
Dorset
Permanent vacancies with a requirement for coding skills 862 637 887
As % of all permanent IT jobs advertised in Dorset 64.23% 65.47% 58.66%
Number of salaries quoted 760 565 673
Dorset median annual salary £37,500 £38,250 £37,500
Median salary % change year-on-year -1.96% +2.00% +7.14%
10th Percentile £26,750 £25,000 £26,250
90th Percentile £55,000 £70,250 £52,300
South West median annual salary £42,500 £40,500 £38,500
% change year-on-year +4.94% +5.19% +4.05%

T-SQL
Job Vacancy Trend in Dorset

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

Job vacancy trend for T-SQL in Dorset

T-SQL
Salary Trend in Dorset

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

Salary trend for T-SQL in Dorset

T-SQL
Salary Histogram in Dorset

The salary distribution of IT jobs citing T-SQL in Dorset over the 6 months to 17 January 2018.

Salary histogram for T-SQL in Dorset

T-SQL
Job Locations in Dorset

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Dorset region over the 6 months to 17 January 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
Bournemouth +22 30 £30,000 -33.33% 6
Poole - 14 £45,000 - 2
T-SQL
South West

For the 6 months to 17 January 2018, 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 Dorset region with a requirement for T-SQL.

1 56 (98.25%) SQL
2 55 (96.49%) SQL Server
3 43 (75.44%) C#
4 37 (64.91%) Visual Studio
5 32 (56.14%) Crystal Reports
6 26 (45.61%) Microsoft
7 21 (36.84%) .NET
8 19 (33.33%) HTML
8 19 (33.33%) ASP.NET
8 19 (33.33%) MVC
8 19 (33.33%) ASP.NET MVC
9 18 (31.58%) SQL Server 2008
9 18 (31.58%) SQL Server Reporting Services
10 15 (26.32%) CSS
10 15 (26.32%) JavaScript
11 14 (24.56%) Web Services
11 14 (24.56%) Web Development
11 14 (24.56%) LINQ
11 14 (24.56%) Team Foundation Server
11 14 (24.56%) jQuery
11 14 (24.56%) ASP.NET Web Forms
12 13 (22.81%) SQL Server Management Studio (SSMS)
12 13 (22.81%) Power BI
12 13 (22.81%) Subversion
12 13 (22.81%) Automotive
12 13 (22.81%) Business Intelligence
12 13 (22.81%) Data Warehouse
13 11 (19.30%) ETL
14 10 (17.54%) ERP
14 10 (17.54%) Microsoft Excel

T-SQL
Co-occurring IT Skills in Dorset 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 (5.26%) SharePoint
2 1 (1.75%) BizTalk Server
Applications
1 10 (17.54%) Microsoft Excel
Business Applications
1 5 (8.77%) SAP Business ByDesign
1 5 (8.77%) SAP Business One
Cloud Services
1 1 (1.75%) Microsoft Azure
Database & Business Intelligence
1 55 (96.49%) SQL Server
2 32 (56.14%) Crystal Reports
3 18 (31.58%) SQL Server 2008
3 18 (31.58%) SQL Server Reporting Services
4 13 (22.81%) Data Warehouse
4 13 (22.81%) Power BI
5 9 (15.79%) BusinessObjects
5 9 (15.79%) QlikView
5 9 (15.79%) Semantic Layer
6 7 (12.28%) SQL Server Integration Services
7 5 (8.77%) SQL Server Analysis Services
8 4 (7.02%) Relational Database
8 4 (7.02%) SQL Server 2012
9 2 (3.51%) PowerPivot
10 1 (1.75%) Enterprise Data Warehouse
10 1 (1.75%) SAP HANA
10 1 (1.75%) SQL Server 2016
Development Applications
1 37 (64.91%) Visual Studio
2 14 (24.56%) Team Foundation Server
3 13 (22.81%) SQL Server Management Studio (SSMS)
3 13 (22.81%) Subversion
General
1 13 (22.81%) Automotive
2 8 (14.04%) Finance
Job Titles
1 47 (82.46%) Developer
2 17 (29.82%) Software Developer
3 10 (17.54%) SQL Developer
4 9 (15.79%) Business Intelligence Consultant
4 9 (15.79%) Consultant
4 9 (15.79%) Database Developer
5 8 (14.04%) .NET Developer
6 6 (10.53%) Crystal Reports Developer
6 6 (10.53%) Report Developer
7 4 (7.02%) .NET Software Developer
8 3 (5.26%) Junior
8 3 (5.26%) Junior Database Developer
8 3 (5.26%) Junior Developer
9 2 (3.51%) Analyst
9 2 (3.51%) Business Intelligence Analyst
9 2 (3.51%) Business Intelligence Developer
10 1 (1.75%) C# ASP.NET Developer
10 1 (1.75%) C# Developer
10 1 (1.75%) Data Warehouse Analyst
10 1 (1.75%) WinForms Developer
Libraries, Frameworks & Software Standards
1 21 (36.84%) .NET
2 19 (33.33%) ASP.NET
2 19 (33.33%) ASP.NET MVC
2 19 (33.33%) HTML
3 15 (26.32%) CSS
4 14 (24.56%) ASP.NET Web Forms
4 14 (24.56%) jQuery
4 14 (24.56%) LINQ
4 14 (24.56%) Web Services
5 9 (15.79%) REST
6 5 (8.77%) WinForms
7 4 (7.02%) SOAP
7 4 (7.02%) WCF
7 4 (7.02%) WSDL
7 4 (7.02%) XML
7 4 (7.02%) XSLT
8 2 (3.51%) .NET Framework
9 1 (1.75%) ASP.NET Web API
9 1 (1.75%) Classic ASP
9 1 (1.75%) KnockoutJS
Miscellaneous
1 1 (1.75%) Fintech
Operating Systems
1 4 (7.02%) Windows
Processes & Methodologies
1 19 (33.33%) MVC
2 14 (24.56%) Web Development
3 13 (22.81%) Business Intelligence
4 11 (19.30%) ETL
5 10 (17.54%) ERP
6 7 (12.28%) Visualisation
7 6 (10.53%) Agile Software Development
7 6 (10.53%) Analytics
8 5 (8.77%) Data Management
8 5 (8.77%) Data Visualisation
9 4 (7.02%) Scrum
9 4 (7.02%) Service Delivery
10 1 (1.75%) Customer Requirements
10 1 (1.75%) Data Analysis
10 1 (1.75%) Data Modelling
10 1 (1.75%) Mentoring
10 1 (1.75%) SDLC
Programming Languages
1 56 (98.25%) SQL
2 43 (75.44%) C#
3 15 (26.32%) JavaScript
4 9 (15.79%) VBA
5 5 (8.77%) VB.NET
Vendors
1 26 (45.61%) Microsoft
2 9 (15.79%) Cognos
2 9 (15.79%) Tableau
3 5 (8.77%) SAP
4 1 (1.75%) Citrix