|
|
|
|
|
The following table provides summary statistics for permanent job vacancies advertised in West Lothian 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 23 October 2018 with a comparison to the same period in the previous 2 years.
| Transact-SQL |
|
|
6 months to
23 Oct 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
38 |
14 |
17 |
| Rank change year-on-year |
-24 |
+3 |
+7 |
| Permanent jobs citing T-SQL |
3 |
8 |
5 |
| As % of all permanent IT jobs advertised in West Lothian |
1.64% |
10.26% |
5.43% |
| As % of the Programming Languages category |
2.88% |
14.81% |
10.00% |
| Number of salaries quoted |
3 |
7 |
4 |
| West Lothian median annual salary |
£27,000 |
£32,500 |
£36,250 |
| Median salary % change year-on-year |
-16.92% |
-10.34% |
+3.57% |
| 10th Percentile |
£25,900 |
£28,100 |
£31,625 |
| 90th Percentile |
£32,500 |
£39,550 |
£45,625 |
| Scotland median annual salary |
£40,000 |
£40,000 |
£38,000 |
| % change year-on-year |
- |
+5.26% |
-5.00% |
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 West Lothian with a requirement for coding skills.
| All Programming Languages West Lothian |
| Permanent vacancies with a requirement for coding skills |
104 |
54 |
50 |
| As % of all permanent IT jobs advertised in West Lothian |
56.83% |
69.23% |
54.35% |
| Number of salaries quoted |
47 |
41 |
41 |
| West Lothian median annual salary |
£40,000 |
£40,000 |
£36,000 |
| Median salary % change year-on-year |
- |
+11.11% |
-10.00% |
| 10th Percentile |
£22,200 |
£24,000 |
£25,250 |
| 90th Percentile |
£52,500 |
£50,000 |
£46,250 |
| Scotland median annual salary |
£45,000 |
£42,500 |
£42,500 |
| % change year-on-year |
+5.88% |
- |
+6.25% |
|
T-SQL
Job Vacancy Trend in West Lothian
Job postings citing T-SQL as a percentage of all IT jobs advertised in West Lothian.
T-SQL
Salary Trend in West Lothian
This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL in West Lothian.
T-SQL
Job Locations in West Lothian
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the West Lothian region over the 6 months to 23 October 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 |
| Livingston |
-10 |
3 |
£27,000 |
-8.47% |
|
T-SQL
Scotland |
For the 6 months to 23 October 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 West Lothian region with a requirement for T-SQL.
T-SQL
Co-occurring IT Skills in West Lothian 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:
|
|
|
