|
|
|
|
|
The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 31 May 2020 with a comparison to the same period in the previous 2 years.
| SQL (Structured Query Language) |
|
|
6 months to
31 May 2020 |
Same period 2019 |
Same period 2018 |
| Rank |
5 |
3 |
3 |
| Rank change year-on-year |
-2 |
0 |
+1 |
| Permanent jobs citing SQL |
548 |
1,226 |
1,406 |
| As % of all permanent jobs advertised in Scotland |
18.67% |
23.09% |
24.61% |
| As % of the Programming Languages category |
31.39% |
39.79% |
43.92% |
| Number of salaries quoted |
394 |
894 |
999 |
| Median annual salary |
£45,000 |
£45,000 |
£45,000 |
| 10th Percentile |
£31,250 |
£29,549 |
£29,250 |
| 90th Percentile |
£60,000 |
£65,000 |
£65,000 |
| UK median annual salary |
£50,000 |
£50,000 |
£47,500 |
| % change year-on-year |
- |
+5.26% |
+5.56% |
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 Scotland with a requirement for coding skills.
| All Programming Languages Scotland |
| Permanent vacancies with a requirement for coding skills |
1,746 |
3,081 |
3,201 |
| As % of all permanent IT jobs advertised in Scotland |
59.49% |
58.03% |
56.03% |
| Number of salaries quoted |
1,126 |
2,094 |
2,237 |
| Median annual salary |
£45,000 |
£44,000 |
£45,000 |
| Median salary % change year-on-year |
+2.27% |
-2.22% |
+5.88% |
| 10th Percentile |
£31,250 |
£30,000 |
£30,000 |
| 90th Percentile |
£65,000 |
£65,000 |
£68,000 |
| UK median annual salary |
£55,000 |
£52,000 |
£50,000 |
| % change year-on-year |
+5.77% |
+4.00% |
+5.26% |
|
SQL
Job Vacancy Trend in Scotland
Job postings citing SQL as a proportion of all IT jobs advertised in Scotland.
SQL
Salary Trend in Scotland
3-month moving average salary quoted in jobs citing SQL in Scotland.
SQL
Salary Histogram in Scotland
Salary distribution for jobs citing SQL in Scotland over the 6 months to 31 May 2020.
SQL
Job Locations in Scotland
The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL within the Scotland region over the 6 months to 31 May 2020.
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 |
| Edinburgh |
0 |
236 |
£50,000 |
+17.65% |
17 |
| Glasgow |
-1 |
227 |
£45,000 |
- |
14 |
| Aberdeen |
+7 |
29 |
£42,500 |
+25.00% |
1 |
| Dundee |
+2 |
18 |
£45,000 |
+45.16% |
1 |
| West Lothian |
-3 |
12 |
£32,500 |
-23.53% |
|
| Fife |
-2 |
6 |
£38,500 |
-14.44% |
|
| South Lanarkshire |
-2 |
4 |
£35,000 |
-17.65% |
|
| Renfrewshire |
-3 |
4 |
£48,500 |
+7.78% |
|
| North Lanarkshire |
- |
4 |
£47,500 |
- |
1 |
| Stirling |
+1 |
3 |
£52,500 |
- |
|
| Aberdeenshire |
0 |
2 |
£40,000 |
- |
|
| Dumfries and Galloway |
+1 |
1 |
£45,000 |
-25.00% |
|
| East Ayrshire |
-1 |
1 |
£32,000 |
-36.00% |
2 |
| Perth and Kinross |
- |
1 |
£52,500 |
- |
|
| Strathclyde |
- |
1 |
£40,000 |
- |
|
SQL
UK |
For the 6 months to 31 May 2020, IT jobs citing 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 Scotland region with a requirement for SQL.
SQL
Co-occurring IT Skills in Scotland 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:
|
|
|
