Period
to 19 June 2018

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

Transact-SQL
South West > Cornwall
6 months to
19 Jun 2018
Same period 2017 Same period 2016
Rank 55 50 41
Rank change year-on-year -5 -9 -
Permanent jobs citing T-SQL 13 3 6
As % of all permanent IT jobs advertised in Cornwall 4.11% 0.94% 3.16%
As % of the Programming Languages category 6.60% 1.95% 6.45%
Number of salaries quoted 5 4 6
Cornwall median annual salary £33,500 £35,250 £32,000
Median salary % change year-on-year -4.96% +10.16% -
10th Percentile £23,400 £30,500 £28,000
90th Percentile £35,250 £38,750 £67,500
South West median annual salary £42,500 £40,000 £37,500
% change year-on-year +6.25% +6.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 Cornwall with a requirement for coding skills.

All Programming Languages
Cornwall
Permanent vacancies with a requirement for coding skills 197 154 93
As % of all permanent IT jobs advertised in Cornwall 62.34% 48.13% 48.95%
Number of salaries quoted 98 123 82
Cornwall median annual salary £35,000 £37,500 £32,500
Median salary % change year-on-year -6.67% +15.38% +8.33%
10th Percentile £21,425 £24,450 £20,200
90th Percentile £65,625 £55,000 £42,500
South West median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - +6.67%

T-SQL
Job Vacancy Trend in Cornwall

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

Job vacancy trend for T-SQL in Cornwall

T-SQL
Salary Trend in Cornwall

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

Salary trend for T-SQL in Cornwall

T-SQL
Job Locations in Cornwall

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Cornwall region over the 6 months to 19 June 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
Newquay -15 7 - -
Hayle +2 3 £33,500 +1.52%
St Ives - 1 £23,000 -
T-SQL
South West

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

1 13 (100.00%) SQL
2 12 (92.31%) Business Intelligence
2 12 (92.31%) SQL Server Integration Services
3 11 (84.62%) SQL Server Analysis Services
3 11 (84.62%) Microsoft Analysis Services
3 11 (84.62%) SQL Server Reporting Services
3 11 (84.62%) Microsoft
3 11 (84.62%) Data Warehouse
3 11 (84.62%) Power BI
4 10 (76.92%) SQL Server
5 8 (61.54%) Data Modelling
5 8 (61.54%) ETL
5 8 (61.54%) Validation
5 8 (61.54%) Data Integration
5 8 (61.54%) Analytics
5 8 (61.54%) Enterprise Software
6 7 (53.85%) Master Data Management
6 7 (53.85%) Mentoring
6 7 (53.85%) Virtual Team
6 7 (53.85%) Business Process Modelling
6 7 (53.85%) Finance
6 7 (53.85%) Data Science
6 7 (53.85%) Predictive Analytics
6 7 (53.85%) PerformancePoint
6 7 (53.85%) REST
6 7 (53.85%) Data Quality
6 7 (53.85%) Oracle SOA Suite
6 7 (53.85%) Office 365
6 7 (53.85%) Big Data
6 7 (53.85%) SQL Server 2012

T-SQL
Co-occurring IT Skills in Cornwall 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 7 (53.85%) BizTalk Server
1 7 (53.85%) Oracle SOA Suite
1 7 (53.85%) SharePoint
2 1 (7.69%) WordPress
Applications
1 1 (7.69%) Microsoft Excel
Cloud Services
1 7 (53.85%) Office 365
2 2 (15.38%) Microsoft Azure
3 1 (7.69%) Azure Data Factory
3 1 (7.69%) SaaS
Database & Business Intelligence
1 12 (92.31%) SQL Server Integration Services
2 11 (84.62%) Data Warehouse
2 11 (84.62%) Microsoft Analysis Services
2 11 (84.62%) Power BI
2 11 (84.62%) SQL Server Analysis Services
2 11 (84.62%) SQL Server Reporting Services
3 10 (76.92%) SQL Server
4 7 (53.85%) Big Data
4 7 (53.85%) MySQL
4 7 (53.85%) PerformancePoint
4 7 (53.85%) SQL Server 2012
5 3 (23.08%) NoSQL
6 1 (7.69%) Azure SQL Database
Development Applications
1 1 (7.69%) Git (software)
1 1 (7.69%) SQL Server Management Studio (SSMS)
1 1 (7.69%) Visual Studio
General
1 7 (53.85%) Finance
Job Titles
1 7 (53.85%) Analyst
1 7 (53.85%) Integration Analyst
1 7 (53.85%) Senior Analyst
1 7 (53.85%) Senior Integration Analyst
2 6 (46.15%) Developer
3 4 (30.77%) Business Intelligence Developer
4 3 (23.08%) Data Warehouse Developer
5 1 (7.69%) .NET Developer
5 1 (7.69%) .NET Software Developer
5 1 (7.69%) ASP Developer
5 1 (7.69%) ASP.NET MVC Developer
5 1 (7.69%) C# .NET Developer
5 1 (7.69%) C# Developer
5 1 (7.69%) C# Software Developer
5 1 (7.69%) Graduate
5 1 (7.69%) Graduate Business Intelligence Developer
5 1 (7.69%) Graduate Developer
5 1 (7.69%) Microsoft BI Developer
5 1 (7.69%) Microsoft Developer
5 1 (7.69%) SQL Developer
Libraries, Frameworks & Software Standards
1 7 (53.85%) REST
1 7 (53.85%) SOAP
1 7 (53.85%) Web Services
2 1 (7.69%) .NET
2 1 (7.69%) AngularJS
2 1 (7.69%) ASP.NET Web API
2 1 (7.69%) jQuery
Miscellaneous
1 8 (61.54%) Enterprise Software
2 7 (53.85%) Management Information System
2 7 (53.85%) Virtual Team
3 1 (7.69%) Replication
Processes & Methodologies
1 12 (92.31%) Business Intelligence
2 8 (61.54%) Analytics
2 8 (61.54%) Data Integration
2 8 (61.54%) Data Modelling
2 8 (61.54%) ETL
2 8 (61.54%) Validation
3 7 (53.85%) Business Process Modelling
3 7 (53.85%) Change Data Capture
3 7 (53.85%) Data Science
3 7 (53.85%) EAI
3 7 (53.85%) ITIL
3 7 (53.85%) Kimball Methodology
3 7 (53.85%) Master Data Management
3 7 (53.85%) Mentoring
3 7 (53.85%) Predictive Analytics
3 7 (53.85%) Project Management
3 7 (53.85%) SOA
4 1 (7.69%) Data Cleansing
4 1 (7.69%) Migration
4 1 (7.69%) MVC
Programming Languages
1 13 (100.00%) SQL
2 7 (53.85%) PL/SQL
3 1 (7.69%) C#
3 1 (7.69%) JavaScript
3 1 (7.69%) PHP
3 1 (7.69%) VBA
Qualifications
1 7 (53.85%) ITIL Certification
1 7 (53.85%) Microsoft Certification
1 7 (53.85%) Postgraduate
Quality Assurance & Compliance
1 7 (53.85%) Data Quality
Vendors
1 11 (84.62%) Microsoft
2 7 (53.85%) Oracle
3 1 (7.69%) RedGate