|
|
|
|
|
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 22 August 2017 with a comparison to the same period in the previous 2 years.
| SQL (Structured Query Language) |
|
|
6 months to
22 Aug 2017 |
Same period 2016 |
Same period 2015 |
| Rank |
4 |
4 |
5 |
| Rank change year-on-year |
0 |
+1 |
-1 |
| Permanent jobs citing SQL |
1262 |
1062 |
1279 |
| As % of all permanent IT jobs advertised in Scotland |
23.47% |
18.72% |
20.39% |
| As % of the Programming Languages category |
36.80% |
36.26% |
40.30% |
| Number of salaries quoted |
652 |
585 |
782 |
| Scotland median annual salary |
£40,000 |
£41,500 |
£42,500 |
| Median salary % change year-on-year |
-3.61% |
-2.35% |
+6.25% |
| 10th Percentile |
£27,500 |
£27,200 |
£28,750 |
| 90th Percentile |
£65,000 |
£61,250 |
£61,250 |
| UK median annual salary |
£45,000 |
£45,000 |
£44,000 |
| % change year-on-year |
- |
+2.27% |
+3.53% |
SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for programming language skills.
| Programming Language Skills Scotland |
| Permanent job vacancies with a requirement for programming language skills |
3429 |
2929 |
3174 |
| As % of all permanent IT job vacancies advertised in Scotland |
63.78% |
51.62% |
50.60% |
| Number of salaries quoted |
2088 |
1678 |
1986 |
| Scotland median annual salary |
£42,500 |
£42,500 |
£41,000 |
| Median salary % change year-on-year |
- |
+3.66% |
+2.50% |
| 10th Percentile |
£28,750 |
£27,925 |
£27,500 |
| 90th Percentile |
£67,500 |
£60,475 |
£60,000 |
| UK median annual salary |
£47,500 |
£47,500 |
£45,000 |
| % change year-on-year |
- |
+5.56% |
+3.45% |
|
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 22 August 2017.
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 22 August 2017.
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 |
+1 |
599 |
£40,000 |
-11.11% |
33 |
| Glasgow |
0 |
509 |
£42,500 |
+6.25% |
42 |
| West Lothian |
-2 |
38 |
£30,000 |
-14.29% |
2 |
| Stirling |
+27 |
17 |
£45,000 |
+36.36% |
3 |
| Aberdeen |
+4 |
16 |
£40,000 |
-11.60% |
2 |
| Fife |
+4 |
15 |
£39,137 |
+32.67% |
2 |
| Dundee |
+1 |
12 |
£39,000 |
+17.73% |
2 |
| South Lanarkshire |
-2 |
5 |
£41,500 |
+14.48% |
3 |
| Lothian |
- |
5 |
£43,000 |
- |
|
| Renfrewshire |
-2 |
4 |
£34,450 |
+14.83% |
|
| Inverclyde |
- |
4 |
£45,000 |
- |
|
| North Lanarkshire |
+7 |
3 |
£40,000 |
+6.67% |
1 |
| Scottish Borders |
+1 |
2 |
£27,750 |
-20.71% |
|
| Midlothian |
+1 |
2 |
£26,500 |
-26.39% |
|
| Aberdeenshire |
- |
1 |
£40,000 |
- |
|
| Perth and Kinross |
- |
1 |
£60,000 |
- |
|
| Strathclyde |
- |
1 |
- |
- |
|
SQL
UK |
For the 6 months to 22 August 2017, IT jobs citing 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 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:
|
|
|
