Period
to 29 October 2020

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 29 October 2020 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
UK > Scotland
6 months to
29 Oct 2020
Same period 2019 Same period 2018
Rank 7 3 3
Rank change year-on-year -4 0 +1
Permanent jobs citing SQL 317 1,001 1,386
As % of all permanent jobs advertised in Scotland 18.49% 20.86% 25.87%
As % of the Programming Languages category 28.46% 35.23% 44.97%
Number of salaries quoted 272 715 974
Median annual salary £47,500 £43,500 £45,000
Median salary % change year-on-year +9.20% -3.33% +12.50%
10th Percentile £32,500 £29,000 £29,750
90th Percentile £68,750 £60,000 £65,000
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +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,114 2,841 3,082
As % of all permanent IT jobs advertised in Scotland 64.99% 59.20% 57.52%
Number of salaries quoted 819 1,775 2,066
Median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - +5.88%
10th Percentile £32,500 £30,000 £30,000
90th Percentile £68,750 £65,000 £65,000
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +1.01%

SQL
Job Vacancy Trend in Scotland

Job postings citing SQL as a proportion of all IT jobs advertised in Scotland.

Job vacancy trend for SQL in Scotland

SQL
Salary Trend in Scotland

3-month moving average salary quoted in jobs citing SQL in Scotland.

Salary trend for SQL in Scotland

SQL
Salary Histogram in Scotland

Salary distribution for jobs citing SQL in Scotland over the 6 months to 29 October 2020.

Salary histogram for SQL in Scotland

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 29 October 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
Glasgow -1 170 £47,500 +5.56% 36
Edinburgh -5 98 £47,500 +7.95% 47
Dundee +5 19 £55,000 +37.50% 7
Fife 0 10 £32,500 -13.33% 1
Aberdeen +6 4 £62,500 +66.67% 1
West Lothian -4 2 £48,500 +14.12% 4
Aberdeenshire +2 1 - - 3
Scottish Borders -2 1 - -
Stirling -5 1 £24,000 -26.15% 1
SQL
UK

For the 6 months to 29 October 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.

1 110 (34.70%) C#
2 100 (31.55%) Azure
3 98 (30.91%) Agile Software Development
4 88 (27.76%) Finance
5 87 (27.44%) Microsoft
6 84 (26.50%) JavaScript
7 83 (26.18%) .NET
8 82 (25.87%) SQL Server
9 75 (23.66%) Java
10 71 (22.40%) Python
11 66 (20.82%) Software Engineering
12 60 (18.93%) DevOps
13 53 (16.72%) Scrum
13 53 (16.72%) AWS
14 52 (16.40%) Oracle
15 51 (16.09%) SDLC
16 49 (15.46%) Linux
17 48 (15.14%) C++
18 47 (14.83%) OO
19 44 (13.88%) Business Intelligence
19 44 (13.88%) React
20 43 (13.56%) HTML
20 43 (13.56%) AngularJS
21 42 (13.25%) SaaS
22 41 (12.93%) SQL Server Integration Services
22 41 (12.93%) Test Automation
22 41 (12.93%) Mentoring
23 37 (11.67%) Data Warehouse
24 35 (11.04%) Microservices
25 34 (10.73%) Git (software)

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:

Application Platforms
1 13 (4.10%) Apache Spark
2 6 (1.89%) Apache
2 6 (1.89%) Confluence
2 6 (1.89%) SAS
2 6 (1.89%) SharePoint
3 5 (1.58%) IIS
4 2 (0.63%) JBoss
4 2 (0.63%) SugarCRM
5 1 (0.32%) Apache Airflow
5 1 (0.32%) Elasticsearch
5 1 (0.32%) Luigi
5 1 (0.32%) Moodle
5 1 (0.32%) MS Exchange
5 1 (0.32%) Mule
5 1 (0.32%) Mule ESB
5 1 (0.32%) nginx
5 1 (0.32%) WordPress
Applications
1 6 (1.89%) Microsoft Excel
2 3 (0.95%) Microsoft PowerPoint
3 2 (0.63%) Microsoft Office
4 1 (0.32%) Spreadsheet
Business Applications
1 4 (1.26%) Hyperion Planning
2 2 (0.63%) Actimize
2 2 (0.63%) Dynamics CRM
2 2 (0.63%) Magento
2 2 (0.63%) NetSuite
2 2 (0.63%) Oracle Receivables
3 1 (0.32%) Dynamics NAV
3 1 (0.32%) Shopify
3 1 (0.32%) Unit4 Business World
Cloud Services
1 100 (31.55%) Azure
2 53 (16.72%) AWS
3 42 (13.25%) SaaS
4 26 (8.20%) Power Platform
5 16 (5.05%) Cloud Computing
6 14 (4.42%) GCP
7 13 (4.10%) IaaS
7 13 (4.10%) Office 365
8 8 (2.52%) PaaS
9 6 (1.89%) GitHub
9 6 (1.89%) Serverless
10 4 (1.26%) Amazon EMR
11 3 (0.95%) AWS Lambda
11 3 (0.95%) Virtual Private Cloud
12 2 (0.63%) Amazon Kinesis
12 2 (0.63%) Amazon S3
12 2 (0.63%) AWS Data Pipeline
12 2 (0.63%) Azure Data Factory
13 1 (0.32%) AWS CloudFormation
13 1 (0.32%) Dynamics 365
Communications & Networking
1 15 (4.73%) TCP/IP
2 10 (3.15%) LAN
2 10 (3.15%) WAN
3 8 (2.52%) Firewall
4 7 (2.21%) CTI
4 7 (2.21%) Software-Defined Networking
5 5 (1.58%) VPN
6 3 (0.95%) HTTP
6 3 (0.95%) Internet
7 2 (0.63%) Intranet
7 2 (0.63%) SSL
8 1 (0.32%) Cisco IOS
8 1 (0.32%) DHCP
8 1 (0.32%) DNS
8 1 (0.32%) H.323
8 1 (0.32%) Network Security
8 1 (0.32%) SAN
8 1 (0.32%) VoIP
Database & Business Intelligence
1 82 (25.87%) SQL Server
2 41 (12.93%) SQL Server Integration Services
3 37 (11.67%) Data Warehouse
4 27 (8.52%) NoSQL
5 25 (7.89%) Power BI
6 24 (7.57%) SQL Server Analysis Services
6 24 (7.57%) SQL Server Reporting Services
7 17 (5.36%) Relational Database
8 15 (4.73%) MySQL
9 13 (4.10%) Big Data
9 13 (4.10%) BusinessObjects
9 13 (4.10%) PostgreSQL
10 11 (3.47%) Oracle Database
11 9 (2.84%) Azure SQL Database
11 9 (2.84%) Hadoop
11 9 (2.84%) MongoDB
12 7 (2.21%) Apache Hive
12 7 (2.21%) Mixpanel
12 7 (2.21%) QlikView
12 7 (2.21%) SQL Server 2012
Development Applications
1 34 (10.73%) Git (software)
2 16 (5.05%) Selenium
3 15 (4.73%) GitLab
4 13 (4.10%) JIRA
5 9 (2.84%) FitNesse
5 9 (2.84%) JMeter
5 9 (2.84%) SpecFlow
6 8 (2.52%) Jenkins
7 7 (2.21%) Metasploit
7 7 (2.21%) WebScarab
8 6 (1.89%) Bitbucket
9 5 (1.58%) Atlassian Bamboo
9 5 (1.58%) Cucumber
9 5 (1.58%) FishEye
9 5 (1.58%) Subversion
10 4 (1.26%) Gatling
10 4 (1.26%) TeamCity
11 2 (0.63%) CA Release Automation
11 2 (0.63%) SoapUI
11 2 (0.63%) Team Foundation Server
General
1 88 (27.76%) Finance
2 11 (3.47%) Banking
3 10 (3.15%) Manufacturing
4 6 (1.89%) Financial Institution
5 3 (0.95%) Back Office
5 3 (0.95%) Front Office
5 3 (0.95%) Law
5 3 (0.95%) Pharmaceutical
6 2 (0.63%) Investment Banking
6 2 (0.63%) Local Government
6 2 (0.63%) Public Sector
7 1 (0.32%) Games
7 1 (0.32%) German Language
7 1 (0.32%) Marketing
7 1 (0.32%) Publishing
7 1 (0.32%) Retail
7 1 (0.32%) Telecoms
Job Titles
1 121 (38.17%) Developer
2 49 (15.46%) Software Engineer
3 33 (10.41%) Software Developer
4 31 (9.78%) Analyst
5 15 (4.73%) .NET Software Engineer
5 15 (4.73%) Senior Software Engineer
6 14 (4.42%) .NET Developer
6 14 (4.42%) Azure Engineer
6 14 (4.42%) DBA
7 13 (4.10%) Architect
8 12 (3.79%) C# Software Engineer
8 12 (3.79%) Data Engineer
8 12 (3.79%) SQL DBA
9 11 (3.47%) Senior Developer
10 10 (3.15%) C# Developer
10 10 (3.15%) Cloud Architect
10 10 (3.15%) Platform Engineer
11 9 (2.84%) Business Intelligence Developer
11 9 (2.84%) DevOps Engineer
11 9 (2.84%) Full Stack Developer
Libraries, Frameworks & Software Standards
1 83 (26.18%) .NET
2 44 (13.88%) React
3 43 (13.56%) AngularJS
3 43 (13.56%) HTML
4 32 (10.09%) CSS
5 31 (9.78%) HTML5
6 26 (8.20%) .NET Core
6 26 (8.20%) ASP.NET
7 25 (7.89%) .NET Framework
8 24 (7.57%) jQuery
9 20 (6.31%) XML
10 19 (5.99%) REST
11 18 (5.68%) Ajax
12 16 (5.05%) ASP.NET MVC
13 15 (4.73%) Backbone.js
13 15 (4.73%) RESTful
14 14 (4.42%) JSON
15 12 (3.79%) J2EE
16 11 (3.47%) Express
16 11 (3.47%) Web Services
Miscellaneous
1 22 (6.94%) Mobile App
2 20 (6.31%) Data Structures
2 20 (6.31%) Enterprise Software
3 18 (5.68%) Greenfield Project
4 15 (4.73%) Algorithms
5 13 (4.10%) Analytical Skills
6 7 (2.21%) Cloud Native
6 7 (2.21%) Hybrid Cloud
6 7 (2.21%) Renewable Energy
7 3 (0.95%) Equities
7 3 (0.95%) Social Media
8 2 (0.63%) Analytical Mindset
8 2 (0.63%) Fixed Income
8 2 (0.63%) Reference Data
8 2 (0.63%) Replication
8 2 (0.63%) SCADA
8 2 (0.63%) Virtual Team
9 1 (0.32%) Public Cloud
9 1 (0.32%) Self-Motivation
9 1 (0.32%) Smart Energy
Operating Systems
1 49 (15.46%) Linux
2 28 (8.83%) Windows
3 19 (5.99%) Unix
4 6 (1.89%) Windows Server
5 5 (1.58%) Android
5 5 (1.58%) Red Hat Enterprise Linux
6 3 (0.95%) Apple iOS
7 2 (0.63%) CentOS
8 1 (0.32%) Oracle Linux
Processes & Methodologies
1 98 (30.91%) Agile Software Development
2 66 (20.82%) Software Engineering
3 60 (18.93%) DevOps
4 53 (16.72%) Scrum
5 51 (16.09%) SDLC
6 47 (14.83%) OO
7 44 (13.88%) Business Intelligence
8 41 (12.93%) Mentoring
8 41 (12.93%) Test Automation
9 35 (11.04%) Microservices
10 33 (10.41%) MVC
11 31 (9.78%) TDD
12 28 (8.83%) Artificial Intelligence
13 27 (8.52%) Analytics
13 27 (8.52%) Continuous Integration
14 25 (7.89%) Migration
15 24 (7.57%) API Testing
15 24 (7.57%) BDD
16 22 (6.94%) Sprint Retrospective
17 21 (6.62%) Fintech
Programming Languages
1 110 (34.70%) C#
2 84 (26.50%) JavaScript
3 75 (23.66%) Java
4 71 (22.40%) Python
5 48 (15.14%) C++
6 26 (8.20%) PL/SQL
7 20 (6.31%) C
8 17 (5.36%) Java 8
8 17 (5.36%) PowerShell
9 16 (5.05%) Scala
10 15 (4.73%) R
11 13 (4.10%) Shell Script
12 12 (3.79%) Perl
13 9 (2.84%) Bash Shell
14 7 (2.21%) Ruby
14 7 (2.21%) T-SQL
15 6 (1.89%) PHP
16 3 (0.95%) Apple Swift
16 3 (0.95%) Kotlin
16 3 (0.95%) MATLAB
Qualifications
1 13 (4.10%) Microsoft Certification
2 11 (3.47%) Degree
3 7 (2.21%) AWS Certification
3 7 (2.21%) CCNA
3 7 (2.21%) CCNP
3 7 (2.21%) Cisco Certification
3 7 (2.21%) MCSE
4 4 (1.26%) MCITP
4 4 (1.26%) MCTS
5 2 (0.63%) Computer Science Degree
5 2 (0.63%) ITIL Foundation Certificate
5 2 (0.63%) MCDBA
5 2 (0.63%) MCSA
6 1 (0.32%) HND
6 1 (0.32%) PhD
Quality Assurance & Compliance
1 23 (7.26%) QA
2 22 (6.94%) Data Quality
3 2 (0.63%) ISO/IEC 27001
3 2 (0.63%) Sarbanes-Oxley
System Software
1 18 (5.68%) Docker
2 4 (1.26%) Active Directory
3 3 (0.95%) Hyper-V
4 2 (0.63%) VMware Infrastructure
5 1 (0.32%) Apache ZooKeeper
5 1 (0.32%) HDFS
5 1 (0.32%) XenApp
Systems Management
1 15 (4.73%) Ansible
2 12 (3.79%) Kubernetes
3 7 (2.21%) Core Impact
3 7 (2.21%) Nessus
3 7 (2.21%) Nexpose
4 5 (1.58%) Terraform
5 3 (0.95%) Opscode Chef
6 2 (0.63%) SCCM
7 1 (0.32%) Hadoop YARN
7 1 (0.32%) Microsoft Intune
7 1 (0.32%) Puppet
7 1 (0.32%) XenMobile
Vendors
1 87 (27.44%) Microsoft
2 52 (16.40%) Oracle
3 23 (7.26%) Atlassian
4 19 (5.99%) Ceridian
5 12 (3.79%) Google
6 10 (3.15%) EnterpriseDB
7 9 (2.84%) Cisco
8 8 (2.52%) Informatica
9 7 (2.21%) AppDynamics
9 7 (2.21%) Dynatrace
9 7 (2.21%) SAP
10 5 (1.58%) Apple
10 5 (1.58%) Hyperion
10 5 (1.58%) Red Hat
10 5 (1.58%) Solace
11 4 (1.26%) Salesforce.com
11 4 (1.26%) SolarWinds
11 4 (1.26%) Teradata
11 4 (1.26%) TIBCO
11 4 (1.26%) Xamarin