|
|
|
|
|
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 14 November 2019 with a comparison to the same period in the previous 2 years.
| SQL (Structured Query Language) |
|
|
6 months to
14 Nov 2019 |
Same period 2018 |
Same period 2017 |
| Rank |
4 |
3 |
4 |
| Rank change year-on-year |
-1 |
+1 |
+1 |
| Permanent jobs citing SQL |
957 |
1,402 |
1,363 |
| As % of all permanent IT jobs advertised in Scotland |
20.37% |
25.92% |
24.17% |
| As % of the Programming Languages category |
34.52% |
45.34% |
39.34% |
| Number of salaries quoted |
657 |
959 |
782 |
| Scotland median annual salary |
£43,500 |
£45,000 |
£40,000 |
| Median salary % change year-on-year |
-3.33% |
+12.50% |
- |
| 10th Percentile |
£28,750 |
£29,500 |
£27,550 |
| 90th Percentile |
£60,000 |
£65,000 |
£60,000 |
| UK median annual salary |
£50,000 |
£47,500 |
£45,000 |
| % 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 |
2,772 |
3,092 |
3,465 |
| As % of all permanent IT jobs advertised in Scotland |
59.00% |
57.17% |
61.44% |
| Number of salaries quoted |
1,729 |
2,036 |
2,228 |
| Scotland median annual salary |
£45,000 |
£45,000 |
£42,500 |
| Median salary % change year-on-year |
- |
+5.88% |
+2.41% |
| 10th Percentile |
£30,000 |
£30,000 |
£28,675 |
| 90th Percentile |
£64,000 |
£65,000 |
£63,750 |
| UK median annual salary |
£52,500 |
£50,000 |
£49,000 |
| % change year-on-year |
+5.00% |
+2.04% |
+3.16% |
|
SQL
Job Vacancy Trend in Scotland
Job postings citing SQL as a percentage of all IT jobs advertised in Scotland.
SQL
Salary Trend in Scotland
This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Scotland.
SQL
Salary Histogram in Scotland
The salary distribution of IT jobs citing SQL in Scotland over the 6 months to 14 November 2019.
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 14 November 2019.
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 |
| Glasgow |
0 |
452 |
£45,000 |
-5.26% |
58 |
| Edinburgh |
-2 |
413 |
£42,500 |
-4.49% |
59 |
| West Lothian |
0 |
21 |
£42,500 |
+6.25% |
7 |
| Aberdeen |
-5 |
20 |
£37,500 |
-12.79% |
7 |
| Fife |
+4 |
14 |
£37,500 |
+19.05% |
2 |
| Dundee |
-10 |
12 |
£40,750 |
+23.48% |
3 |
| Stirling |
-5 |
5 |
£32,500 |
-15.58% |
|
| South Lanarkshire |
-3 |
4 |
£36,000 |
-15.29% |
|
| Scottish Borders |
-1 |
3 |
£27,000 |
-5.26% |
1 |
| North Lanarkshire |
-2 |
3 |
£40,000 |
-20.00% |
2 |
| Highlands |
+5 |
2 |
£32,500 |
-7.14% |
|
| Perth and Kinross |
+2 |
2 |
- |
- |
|
| Dumfries and Galloway |
- |
2 |
£60,000 |
- |
|
| Inverclyde |
+4 |
1 |
- |
- |
2 |
| Aberdeenshire |
-2 |
1 |
- |
- |
|
| Angus |
- |
1 |
- |
- |
|
SQL
UK |
For the 6 months to 14 November 2019, 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:
|
|
|
