|
|
|
|
|
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 19 April 2018 with a comparison to the same period in the previous 2 years.
| Transact-SQL |
|
|
6 months to
19 Apr 2018 |
Same period 2017 |
Same period 2016 |
| Rank |
27 |
12 |
13 |
| Rank change year-on-year |
-15 |
+1 |
+4 |
| Permanent jobs citing T-SQL |
2 |
19 |
15 |
| As % of all permanent IT jobs advertised in West Lothian |
2.13% |
17.27% |
11.03% |
| As % of the Programming Languages category |
2.94% |
23.46% |
20.55% |
| Number of salaries quoted |
1 |
15 |
7 |
| West Lothian median annual salary |
£45,000 |
£36,500 |
£45,000 |
| Median salary % change year-on-year |
+23.29% |
-18.89% |
+28.57% |
| Scotland median annual salary |
£40,000 |
£40,000 |
£40,000 |
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 |
68 |
81 |
73 |
| As % of all permanent IT jobs advertised in West Lothian |
72.34% |
73.64% |
53.68% |
| Number of salaries quoted |
46 |
68 |
40 |
| West Lothian median annual salary |
£45,000 |
£40,000 |
£36,000 |
| Median salary % change year-on-year |
+12.50% |
+11.11% |
+2.86% |
| 10th Percentile |
£32,500 |
£25,875 |
£30,650 |
| 90th Percentile |
£46,375 |
£50,750 |
£50,000 |
| Scotland median annual salary |
£45,000 |
£42,500 |
£41,250 |
| % change year-on-year |
+5.88% |
+3.03% |
+3.13% |
|
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 19 April 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 |
-4 |
1 |
- |
- |
|
T-SQL
Scotland |
For the 6 months to 19 April 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:
|
|
|
