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

Transact-SQL
South West > Cornwall
6 months to
16 Aug 2018
Same period 2017 Same period 2016
Rank 50 53 41
Rank change year-on-year +3 -12 -
Permanent jobs citing T-SQL 10 5 13
As % of all permanent IT jobs advertised in Cornwall 3.37% 1.35% 4.71%
As % of the Programming Languages category 5.38% 2.46% 9.85%
Number of salaries quoted 5 6 9
Cornwall median annual salary £33,500 £37,500 £50,000
Median salary % change year-on-year -10.67% -25.00% -
10th Percentile £23,400 £30,500 £45,250
90th Percentile £35,250 £42,500 £67,500
South West median annual salary £41,000 £40,000 £38,000
% change year-on-year +2.50% +5.26% +2.70%

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 186 203 132
As % of all permanent IT jobs advertised in Cornwall 62.63% 54.72% 47.83%
Number of salaries quoted 102 163 100
Cornwall median annual salary £33,500 £40,000 £30,000
Median salary % change year-on-year -16.25% +33.33% -7.69%
10th Percentile £19,450 £26,250 £21,175
90th Percentile £47,375 £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 16 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
Newquay -19 4 - -
Hayle +2 3 £33,500 +1.52%
St Ives -3 1 £23,000 -42.50%
T-SQL
South West

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

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