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

SQL (Structured Query Language)
UK > Scotland
6 months to
8 Aug 2020
Same period 2019 Same period 2018
Rank 5 3 3
Rank change year-on-year -2 0 +1
Permanent jobs citing SQL 381 1,160 1,396
As % of all permanent jobs advertised in Scotland 17.97% 22.06% 25.35%
As % of the Programming Languages category 29.33% 38.27% 45.00%
Number of salaries quoted 298 856 994
Median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - +12.50%
10th Percentile £32,500 £29,750 £30,000
90th Percentile £61,625 £62,500 £66,250
UK median annual salary £51,000 £50,000 £47,500
% change year-on-year +2.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,299 3,031 3,102
As % of all permanent IT jobs advertised in Scotland 61.27% 57.65% 56.34%
Number of salaries quoted 858 1,996 2,119
Median annual salary £47,500 £45,000 £45,000
Median salary % change year-on-year +5.56% - +5.88%
10th Percentile £32,500 £30,250 £30,378
90th Percentile £67,500 £65,000 £67,500
UK median annual salary £55,000 £52,500 £50,000
% change year-on-year +4.76% +5.00% +5.26%

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 8 August 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 8 August 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 171 £47,500 +5.56% 17
Edinburgh -4 146 £50,000 +13.64% 39
Aberdeen +11 17 £42,500 +25.00%
Dundee +1 16 £50,000 +33.33% 5
West Lothian 0 11 £32,000 -24.71%
Fife 0 8 £37,500 -16.67%
North Lanarkshire - 3 £55,000 -
Aberdeenshire +2 2 £40,000 -
Stirling 0 2 £29,000 - 1
Renfrewshire - 2 £48,500 -
Perth and Kinross +1 1 £52,500 -
Dumfries and Galloway 0 1 £45,000 -25.00%
East Ayrshire -1 1 £32,000 -36.00%
South Lanarkshire -2 1 - -
SQL
UK

For the 6 months to 8 August 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 126 (33.07%) C#
2 123 (32.28%) SQL Server
2 123 (32.28%) Azure
3 115 (30.18%) .NET
4 114 (29.92%) JavaScript
5 107 (28.08%) Agile Software Development
6 98 (25.72%) Finance
7 91 (23.88%) Microsoft
8 74 (19.42%) Java
8 74 (19.42%) Python
9 66 (17.32%) DevOps
10 62 (16.27%) AngularJS
11 59 (15.49%) HTML
12 55 (14.44%) Linux
12 55 (14.44%) AWS
12 55 (14.44%) Test Automation
12 55 (14.44%) SQL Server Integration Services
13 54 (14.17%) Oracle
14 53 (13.91%) CSS
15 51 (13.39%) MVC
16 49 (12.86%) Software Engineering
17 48 (12.60%) ASP.NET
18 47 (12.34%) Business Intelligence
18 47 (12.34%) React
19 45 (11.81%) Windows
20 44 (11.55%) Analytics
21 40 (10.50%) Git (software)
22 38 (9.97%) SQL Server Reporting Services
23 37 (9.71%) HTML5
23 37 (9.71%) Degree

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 10 (2.62%) Apache Spark
1 10 (2.62%) SAS
2 9 (2.36%) Tomcat
3 8 (2.10%) SharePoint
4 5 (1.31%) JBoss
5 4 (1.05%) Apache
5 4 (1.05%) ArcGIS
6 3 (0.79%) Umbraco
7 2 (0.52%) Exchange Server 2013
7 2 (0.52%) Oracle HTTP Server
7 2 (0.52%) WordPress
8 1 (0.26%) CMS
8 1 (0.26%) Drupal
8 1 (0.26%) Moodle
8 1 (0.26%) MS Exchange
8 1 (0.26%) nginx
8 1 (0.26%) Oracle Workflow
8 1 (0.26%) Sitecore CMS
Applications
1 8 (2.10%) Microsoft Excel
2 7 (1.84%) Microsoft Office
3 1 (0.26%) Microsoft PowerPoint
Business Applications
1 6 (1.57%) Oracle ERP
2 4 (1.05%) Hyperion Planning
2 4 (1.05%) Oracle Assets
2 4 (1.05%) Oracle Cash Management
2 4 (1.05%) Oracle Payables
2 4 (1.05%) Oracle Receivables
2 4 (1.05%) Oracle Subledger Accounting
3 3 (0.79%) Oracle EBS
4 2 (0.52%) Magento
4 2 (0.52%) Primavera
5 1 (0.26%) Actimize
5 1 (0.26%) Elite 3E
5 1 (0.26%) Oracle Applications
5 1 (0.26%) Oracle EBS R12
5 1 (0.26%) Oracle iProcurement
5 1 (0.26%) WebTrends
Cloud Services
1 123 (32.28%) Azure
2 55 (14.44%) AWS
3 27 (7.09%) Power Platform
4 20 (5.25%) SaaS
5 13 (3.41%) Azure Data Factory
6 12 (3.15%) PaaS
7 10 (2.62%) Office 365
8 9 (2.36%) GCP
8 9 (2.36%) IaaS
9 5 (1.31%) Amazon EC2
9 5 (1.31%) Amazon ECS
9 5 (1.31%) AWS CloudFormation
9 5 (1.31%) Cloud Computing
9 5 (1.31%) NuGet
9 5 (1.31%) OpenShift
10 4 (1.05%) GitHub
11 3 (0.79%) Amazon EMR
11 3 (0.79%) Azure Functions
11 3 (0.79%) Data Lake Analytics
11 3 (0.79%) Serverless
Communications & Networking
1 8 (2.10%) LAN
1 8 (2.10%) TCP/IP
1 8 (2.10%) WAN
2 7 (1.84%) Network Security
3 6 (1.57%) Firewall
4 4 (1.05%) CTI
4 4 (1.05%) DHCP
4 4 (1.05%) DNS
4 4 (1.05%) Software-Defined Networking
5 2 (0.52%) HTTP
5 2 (0.52%) Intranet
5 2 (0.52%) SSL
6 1 (0.26%) Internet
6 1 (0.26%) VLAN
6 1 (0.26%) VPN
Database & Business Intelligence
1 123 (32.28%) SQL Server
2 55 (14.44%) SQL Server Integration Services
3 38 (9.97%) SQL Server Reporting Services
4 29 (7.61%) Relational Database
5 27 (7.09%) Data Warehouse
5 27 (7.09%) Power BI
6 22 (5.77%) NoSQL
6 22 (5.77%) SQL Server Analysis Services
7 21 (5.51%) Big Data
8 18 (4.72%) MySQL
9 15 (3.94%) Azure SQL Database
10 14 (3.67%) SQL Server 2012
11 10 (2.62%) RDBMS
12 8 (2.10%) Hadoop
12 8 (2.10%) PostgreSQL
13 7 (1.84%) MongoDB
13 7 (1.84%) Oracle Database
14 6 (1.57%) Apache Hive
14 6 (1.57%) Azure SQL Data Warehouse
14 6 (1.57%) QlikView
Development Applications
1 40 (10.50%) Git (software)
2 34 (8.92%) Selenium
3 28 (7.35%) Jenkins
4 20 (5.25%) Maven
5 13 (3.41%) GitLab
5 13 (3.41%) Team Foundation Server
6 12 (3.15%) JIRA
6 12 (3.15%) Visual Studio
7 10 (2.62%) JUnit
8 9 (2.36%) Ant
8 9 (2.36%) Cucumber
8 9 (2.36%) Subversion
9 7 (1.84%) SoapUI
10 6 (1.57%) Gradle
11 4 (1.05%) Gatling
11 4 (1.05%) Metasploit
11 4 (1.05%) REST Assured
11 4 (1.05%) RubyMine
11 4 (1.05%) TeamCity
11 4 (1.05%) WebScarab
General
1 98 (25.72%) Finance
2 17 (4.46%) Manufacturing
3 15 (3.94%) Public Sector
4 12 (3.15%) Banking
5 7 (1.84%) Retail
6 6 (1.57%) Financial Institution
7 5 (1.31%) Billing
8 4 (1.05%) General Ledger
9 3 (0.79%) Pharmaceutical
10 2 (0.52%) Law
10 2 (0.52%) Local Government
10 2 (0.52%) Marketing
10 2 (0.52%) Publishing
11 1 (0.26%) Back Office
11 1 (0.26%) Corporate Banking
11 1 (0.26%) Front Office
11 1 (0.26%) Private Banking
11 1 (0.26%) Retail Banking
Job Titles
1 159 (41.73%) Developer
2 51 (13.39%) Analyst
3 46 (12.07%) .NET Developer
4 44 (11.55%) Software Developer
5 29 (7.61%) Senior Developer
5 29 (7.61%) Software Engineer
6 28 (7.35%) DBA
7 25 (6.56%) SQL DBA
8 24 (6.30%) C# Developer
9 23 (6.04%) Consultant
10 16 (4.20%) Java Developer
11 14 (3.67%) Support Analyst
12 13 (3.41%) C# .NET Developer
12 13 (3.41%) Full Stack Developer
13 12 (3.15%) Applications Support
13 12 (3.15%) SQL Developer
14 11 (2.89%) Applications Support Analyst
14 11 (2.89%) Data Engineer
14 11 (2.89%) Monitoring Engineer
14 11 (2.89%) Test Analyst
Libraries, Frameworks & Software Standards
1 115 (30.18%) .NET
2 62 (16.27%) AngularJS
3 59 (15.49%) HTML
4 53 (13.91%) CSS
5 48 (12.60%) ASP.NET
6 47 (12.34%) React
7 37 (9.71%) HTML5
8 32 (8.40%) .NET Core
9 28 (7.35%) .NET Framework
10 26 (6.82%) RESTful
11 23 (6.04%) Web Services
12 22 (5.77%) ASP.NET MVC
13 21 (5.51%) CSS3
13 21 (5.51%) REST
14 20 (5.25%) ASP.NET Web API
15 17 (4.46%) jQuery
16 16 (4.20%) Entity Framework
17 15 (3.94%) JSON
18 14 (3.67%) Spring
19 13 (3.41%) XML
Miscellaneous
1 31 (8.14%) Analytical Skills
2 21 (5.51%) Enterprise Software
3 15 (3.94%) Greenfield Project
4 12 (3.15%) Mobile App
5 9 (2.36%) Self-Motivation
6 8 (2.10%) Management Information System
7 7 (1.84%) Cloud Native
7 7 (1.84%) Data Structures
8 6 (1.57%) Renewable Energy
8 6 (1.57%) Replication
9 5 (1.31%) Virtual Team
10 4 (1.05%) Algorithms
10 4 (1.05%) Hybrid Cloud
10 4 (1.05%) User Experience
11 3 (0.79%) Driving Licence
11 3 (0.79%) e-Health
11 3 (0.79%) Market Risk
11 3 (0.79%) Public Cloud
11 3 (0.79%) Social Media
12 2 (0.52%) SCADA
Operating Systems
1 55 (14.44%) Linux
2 45 (11.81%) Windows
3 25 (6.56%) Unix
4 12 (3.15%) Windows Server
5 8 (2.10%) Windows Server 2012
5 8 (2.10%) Windows Server 2016
6 7 (1.84%) Android
6 7 (1.84%) Red Hat Enterprise Linux
7 6 (1.57%) Apple iOS
8 4 (1.05%) Windows 10
9 2 (0.52%) CentOS
9 2 (0.52%) Windows 7
9 2 (0.52%) Windows 8
10 1 (0.26%) Oracle Linux
Processes & Methodologies
1 107 (28.08%) Agile Software Development
2 66 (17.32%) DevOps
3 55 (14.44%) Test Automation
4 51 (13.39%) MVC
5 49 (12.86%) Software Engineering
6 47 (12.34%) Business Intelligence
7 44 (11.55%) Analytics
8 37 (9.71%) SDLC
9 36 (9.45%) Problem-Solving
9 36 (9.45%) Scrum
10 35 (9.19%) TDD
11 31 (8.14%) Mentoring
12 23 (6.04%) Microservices
13 22 (5.77%) ERP
14 20 (5.25%) ETL
15 19 (4.99%) API Testing
15 19 (4.99%) Continuous Integration
15 19 (4.99%) Performance Tuning
16 18 (4.72%) Data Modelling
16 18 (4.72%) Migration
Programming Languages
1 126 (33.07%) C#
2 114 (29.92%) JavaScript
3 74 (19.42%) Java
3 74 (19.42%) Python
4 35 (9.19%) T-SQL
5 26 (6.82%) PL/SQL
6 20 (5.25%) Perl
7 19 (4.99%) PowerShell
8 16 (4.20%) R
9 15 (3.94%) Scala
10 14 (3.67%) Ruby
11 12 (3.15%) C++
11 12 (3.15%) TypeScript
12 11 (2.89%) Groovy
13 10 (2.62%) PHP
13 10 (2.62%) Shell Script
14 8 (2.10%) Bash Shell
15 6 (1.57%) VB.NET
16 5 (1.31%) C
16 5 (1.31%) MATLAB
Qualifications
1 37 (9.71%) Degree
2 12 (3.15%) Microsoft Certification
3 6 (1.57%) Computer Science Degree
4 4 (1.05%) AWS Certification
4 4 (1.05%) CCNA
4 4 (1.05%) CCNP
4 4 (1.05%) Cisco Certification
4 4 (1.05%) ISTQB
4 4 (1.05%) MCITP
4 4 (1.05%) MCSE
4 4 (1.05%) MCTS
5 3 (0.79%) PhD
6 2 (0.52%) MCDBA
7 1 (0.26%) HND
7 1 (0.26%) ITIL Certification
Quality Assurance & Compliance
1 8 (2.10%) QA
2 7 (1.84%) Data Quality
3 2 (0.52%) GDPR
3 2 (0.52%) ISO/IEC 27001
4 1 (0.26%) SLA
System Software
1 32 (8.40%) Docker
2 5 (1.31%) Active Directory
2 5 (1.31%) Hyper-V
3 4 (1.05%) Virtual Machines
4 1 (0.26%) Terminal Server
4 1 (0.26%) VMware Infrastructure
Systems Management
1 29 (7.61%) Kubernetes
2 11 (2.89%) Terraform
3 9 (2.36%) Opscode Chef
4 7 (1.84%) Ansible
5 4 (1.05%) Core Impact
5 4 (1.05%) Nessus
5 4 (1.05%) Nexpose
5 4 (1.05%) Puppet
5 4 (1.05%) SCCM
6 2 (0.52%) Consul
6 2 (0.52%) Docker Swarm
6 2 (0.52%) Grafana
6 2 (0.52%) Graphite
6 2 (0.52%) Microsoft Intune
6 2 (0.52%) Packer
6 2 (0.52%) SCDPM
6 2 (0.52%) SCOM
6 2 (0.52%) SCOrch
6 2 (0.52%) SCSM
6 2 (0.52%) SCVMM
Vendors
1 91 (23.88%) Microsoft
2 54 (14.17%) Oracle
3 13 (3.41%) Databricks
4 11 (2.89%) AppDynamics
4 11 (2.89%) Dynatrace
5 10 (2.62%) Google
6 7 (1.84%) Capita
6 7 (1.84%) MicroStrategy
7 6 (1.57%) Cisco
8 5 (1.31%) Hyperion
8 5 (1.31%) Solace
9 4 (1.05%) Cognizant
9 4 (1.05%) Cognos
9 4 (1.05%) Informatica
9 4 (1.05%) Talend
9 4 (1.05%) TIBCO
9 4 (1.05%) Xamarin
10 3 (0.79%) SAP
10 3 (0.79%) Sybase
10 3 (0.79%) Tableau