Period
to 24 November 2017

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

Transact-SQL
Cheshire > Macclesfield
6 months to
24 Nov 2017
Same period 2016 Same period 2015
Rank 33 34 11
Rank change year-on-year +1 -23 +6
Permanent jobs citing T-SQL 6 5 18
As % of all permanent IT jobs advertised in Macclesfield 4.23% 2.78% 14.52%
As % of the Programming Languages category 5.94% 3.42% 21.95%
Number of salaries quoted 6 4 23
Macclesfield median annual salary £40,000 £38,750 £40,000
Median salary % change year-on-year +3.23% -3.13% -
10th Percentile £33,875 £31,625 £27,500
90th Percentile £43,750 £54,125 £50,000
Cheshire median annual salary £42,500 £37,500 £40,000
% change year-on-year +13.33% -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 Macclesfield with a requirement for coding skills.

All Programming Languages
Macclesfield
Permanent vacancies with a requirement for coding skills 101 146 82
As % of all permanent IT jobs advertised in Macclesfield 71.13% 81.11% 66.13%
Number of salaries quoted 100 139 72
Macclesfield median annual salary £37,500 £35,000 £35,000
Median salary % change year-on-year +7.14% - -6.67%
10th Percentile £26,250 £22,500 £26,250
90th Percentile £52,500 £61,250 £45,000
Cheshire median annual salary £42,500 £37,500 £39,000
% change year-on-year +13.33% -3.85% +4.00%

T-SQL
Job Vacancy Trend in Macclesfield

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

Job vacancy trend for T-SQL in Macclesfield

T-SQL
Salary Trend in Macclesfield

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

Salary trend for T-SQL in Macclesfield

For the 6 months to 24 November 2017, 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 Macclesfield region with a requirement for T-SQL.

1 6 (100.00%) SQL
1 6 (100.00%) SQL Server Reporting Services
2 5 (83.33%) SQL Server
2 5 (83.33%) SQL Server Integration Services
3 4 (66.67%) Microsoft Excel
4 3 (50.00%) Analytical Skills
4 3 (50.00%) Microsoft Office
4 3 (50.00%) Relational Database
4 3 (50.00%) Dashboard Development
5 2 (33.33%) SQL Server Management Studio (SSMS)
5 2 (33.33%) SQL Server 2012
5 2 (33.33%) SQL Server Analysis Services
6 1 (16.67%) PowerShell
6 1 (16.67%) SQL Server 2008
6 1 (16.67%) Microsoft Azure
6 1 (16.67%) Tableau
6 1 (16.67%) Performance Tuning
6 1 (16.67%) Statistics
6 1 (16.67%) QlikView
6 1 (16.67%) Database Mirroring
6 1 (16.67%) Power BI
6 1 (16.67%) Performance Optimisation
6 1 (16.67%) Perfmon
6 1 (16.67%) Windows Server
6 1 (16.67%) Visual Studio
6 1 (16.67%) Windows
6 1 (16.67%) Data Warehouse
6 1 (16.67%) Data Modelling
6 1 (16.67%) ETL
6 1 (16.67%) Business Intelligence

T-SQL
Co-occurring IT Skills in Macclesfield 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:

Applications
1 4 (66.67%) Microsoft Excel
2 3 (50.00%) Microsoft Office
Cloud Services
1 1 (16.67%) Microsoft Azure
Database & Business Intelligence
1 6 (100.00%) SQL Server Reporting Services
2 5 (83.33%) SQL Server
2 5 (83.33%) SQL Server Integration Services
3 3 (50.00%) Relational Database
4 2 (33.33%) SQL Server 2012
4 2 (33.33%) SQL Server Analysis Services
5 1 (16.67%) Data Warehouse
5 1 (16.67%) Power BI
5 1 (16.67%) QlikView
5 1 (16.67%) SQL Server 2008
Development Applications
1 2 (33.33%) SQL Server Management Studio (SSMS)
2 1 (16.67%) Visual Studio
Job Titles
1 4 (66.67%) Analyst
1 4 (66.67%) Data Analyst
1 4 (66.67%) SQL Analyst
1 4 (66.67%) SQL Data Analyst
2 1 (16.67%) Business Intelligence Developer
2 1 (16.67%) DBA
2 1 (16.67%) Developer
2 1 (16.67%) SQL BI Developer
2 1 (16.67%) SQL DBA
2 1 (16.67%) SQL Developer
2 1 (16.67%) SQL Server DBA
Miscellaneous
1 3 (50.00%) Analytical Skills
2 1 (16.67%) Replication
Operating Systems
1 1 (16.67%) Windows
1 1 (16.67%) Windows Server
Processes & Methodologies
1 3 (50.00%) Dashboard Development
2 1 (16.67%) Agile Software Development
2 1 (16.67%) Business Intelligence
2 1 (16.67%) Data Modelling
2 1 (16.67%) Database Mirroring
2 1 (16.67%) ETL
2 1 (16.67%) Performance Optimisation
2 1 (16.67%) Performance Tuning
2 1 (16.67%) Runbook
2 1 (16.67%) Statistics
Programming Languages
1 6 (100.00%) SQL
2 1 (16.67%) PowerShell
Systems Management
1 1 (16.67%) Perfmon
Vendors
1 1 (16.67%) Microsoft
1 1 (16.67%) Tableau