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

SQL (Structured Query Language)
UK > Scotland
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.

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 31 May 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 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.

1 213 (38.87%) .NET
2 210 (38.32%) C#
3 188 (34.31%) JavaScript
4 182 (33.21%) Agile Software Development
5 171 (31.20%) Azure
6 167 (30.47%) SQL Server
7 155 (28.28%) Microsoft
8 137 (25.00%) Finance
9 118 (21.53%) Python
10 117 (21.35%) Java
11 104 (18.98%) AngularJS
12 95 (17.34%) CSS
13 91 (16.61%) HTML
14 88 (16.06%) ASP.NET
15 82 (14.96%) Oracle
15 82 (14.96%) T-SQL
15 82 (14.96%) React
16 81 (14.78%) DevOps
17 80 (14.60%) Test Automation
18 79 (14.42%) MVC
19 69 (12.59%) AWS
20 67 (12.23%) Software Engineering
20 67 (12.23%) Windows
20 67 (12.23%) Business Intelligence
21 65 (11.86%) Degree
22 64 (11.68%) Problem-Solving
23 60 (10.95%) SQL Server Integration Services
24 58 (10.58%) Linux
25 55 (10.04%) SDLC
26 54 (9.85%) .NET Core

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 17 (3.10%) SAS
2 13 (2.37%) CMS
3 12 (2.19%) EPiServer
3 12 (2.19%) SharePoint
3 12 (2.19%) Tomcat
4 11 (2.01%) Apache Spark
5 7 (1.28%) Umbraco
6 6 (1.09%) Oracle Workflow
7 5 (0.91%) ArcGIS
7 5 (0.91%) JBoss
8 3 (0.55%) Documentum
9 2 (0.36%) Apache
9 2 (0.36%) Elasticsearch
9 2 (0.36%) Exchange Server 2013
9 2 (0.36%) Oracle HTTP Server
10 1 (0.18%) Drupal
10 1 (0.18%) Jupyter
10 1 (0.18%) MS Exchange
10 1 (0.18%) WebSphere
10 1 (0.18%) WordPress
Applications
1 16 (2.92%) Microsoft Office
2 10 (1.82%) Microsoft Excel
3 2 (0.36%) Microsoft PowerPoint
4 1 (0.18%) Microsoft Project
4 1 (0.18%) MS Visio
4 1 (0.18%) SPSS
Business Applications
1 9 (1.64%) Oracle EBS
2 8 (1.46%) Primavera
3 7 (1.28%) Oracle iProcurement
4 6 (1.09%) Oracle EBS R12
4 6 (1.09%) Oracle ERP
5 4 (0.73%) Oracle Assets
5 4 (0.73%) Oracle Cash Management
5 4 (0.73%) Oracle Payables
5 4 (0.73%) Oracle Receivables
5 4 (0.73%) Oracle Subledger Accounting
6 3 (0.55%) Dynamics CRM
7 1 (0.18%) Actimize
7 1 (0.18%) Elite 3E
7 1 (0.18%) Magento
7 1 (0.18%) Oracle Applications
7 1 (0.18%) Oracle Financials
7 1 (0.18%) WebTrends
Cloud Services
1 171 (31.20%) Azure
2 69 (12.59%) AWS
3 33 (6.02%) Power Platform
4 17 (3.10%) SaaS
5 14 (2.55%) Azure Data Factory
6 12 (2.19%) Office 365
6 12 (2.19%) PaaS
7 11 (2.01%) GCP
8 10 (1.82%) GitHub
9 7 (1.28%) IaaS
10 6 (1.09%) Amazon EC2
11 5 (0.91%) Amazon ECS
11 5 (0.91%) AWS CloudFormation
11 5 (0.91%) NuGet
11 5 (0.91%) OpenShift
12 4 (0.73%) Cloud Computing
12 4 (0.73%) Serverless
12 4 (0.73%) Slack
13 3 (0.55%) Azure Functions
13 3 (0.55%) Data Lake Analytics
Communications & Networking
1 10 (1.82%) DHCP
1 10 (1.82%) DNS
2 7 (1.28%) Network Security
3 6 (1.09%) LAN
3 6 (1.09%) TCP/IP
3 6 (1.09%) WAN
4 5 (0.91%) Firewall
4 5 (0.91%) HTTP
5 2 (0.36%) CTI
5 2 (0.36%) Intranet
5 2 (0.36%) Software-Defined Networking
5 2 (0.36%) VPN
6 1 (0.18%) Internet
6 1 (0.18%) SSL
6 1 (0.18%) VLAN
6 1 (0.18%) Wi-Fi
6 1 (0.18%) Wireless
Database & Business Intelligence
1 167 (30.47%) SQL Server
2 60 (10.95%) SQL Server Integration Services
3 46 (8.39%) Relational Database
3 46 (8.39%) SQL Server Reporting Services
4 36 (6.57%) NoSQL
5 33 (6.02%) Power BI
6 25 (4.56%) Big Data
7 23 (4.20%) Data Warehouse
8 22 (4.01%) MySQL
9 21 (3.83%) SQL Server Analysis Services
10 19 (3.47%) Azure SQL Database
11 15 (2.74%) Hadoop
11 15 (2.74%) Oracle Database
12 14 (2.55%) PostgreSQL
13 13 (2.37%) RDBMS
13 13 (2.37%) SQL Server 2012
14 10 (1.82%) MongoDB
14 10 (1.82%) Oracle Reports
15 9 (1.64%) DB2
15 9 (1.64%) QlikView
Development Applications
1 44 (8.03%) Git (software)
2 40 (7.30%) Selenium
3 37 (6.75%) Visual Studio
4 36 (6.57%) Jenkins
5 22 (4.01%) Maven
6 21 (3.83%) Team Foundation Server
7 19 (3.47%) Ant
8 17 (3.10%) JIRA
9 13 (2.37%) JUnit
10 11 (2.01%) GitLab
11 9 (1.64%) Cucumber
12 8 (1.46%) Toad
13 7 (1.28%) Apache Ivy
13 7 (1.28%) SoapUI
13 7 (1.28%) Subversion
14 6 (1.09%) Eclipse
14 6 (1.09%) Gradle
15 5 (0.91%) NUnit
16 4 (0.73%) RubyMine
16 4 (0.73%) TeamCity
General
1 137 (25.00%) Finance
2 32 (5.84%) Public Sector
3 22 (4.01%) Banking
4 20 (3.65%) Retail
5 19 (3.47%) Manufacturing
6 8 (1.46%) Billing
6 8 (1.46%) Local Government
7 5 (0.91%) Pharmaceutical
8 4 (0.73%) General Ledger
9 3 (0.55%) Back Office
9 3 (0.55%) Front Office
10 2 (0.36%) Games
10 2 (0.36%) Law
10 2 (0.36%) Publishing
11 1 (0.18%) Automotive
11 1 (0.18%) Corporate Banking
11 1 (0.18%) Financial Institution
11 1 (0.18%) Marketing
11 1 (0.18%) Private Banking
11 1 (0.18%) Retail Banking
Job Titles
1 244 (44.53%) Developer
2 84 (15.33%) Software Developer
3 81 (14.78%) .NET Developer
4 61 (11.13%) Senior Developer
5 59 (10.77%) Analyst
6 52 (9.49%) Consultant
7 42 (7.66%) Software Engineer
8 41 (7.48%) DBA
9 34 (6.20%) SQL DBA
10 32 (5.84%) Full Stack Developer
11 29 (5.29%) C# Developer
12 25 (4.56%) Senior .NET Developer
13 24 (4.38%) Java Developer
14 23 (4.20%) .NET Software Developer
14 23 (4.20%) Senior Software Developer
14 23 (4.20%) Technical Consultant
15 21 (3.83%) SQL Developer
16 18 (3.28%) C# .NET Developer
17 16 (2.92%) Support Analyst
18 15 (2.74%) .NET Software Engineer
Libraries, Frameworks & Software Standards
1 213 (38.87%) .NET
2 104 (18.98%) AngularJS
3 95 (17.34%) CSS
4 91 (16.61%) HTML
5 88 (16.06%) ASP.NET
6 82 (14.96%) React
7 54 (9.85%) .NET Core
8 47 (8.58%) ASP.NET MVC
9 42 (7.66%) HTML5
10 41 (7.48%) .NET Framework
11 39 (7.12%) ASP.NET Web API
11 39 (7.12%) REST
12 37 (6.75%) RESTful
13 36 (6.57%) Web Services
14 30 (5.47%) jQuery
15 25 (4.56%) XML
16 24 (4.38%) CSS3
17 23 (4.20%) Entity Framework
18 22 (4.01%) JSON
18 22 (4.01%) Node.js
Miscellaneous
1 50 (9.12%) Analytical Skills
2 31 (5.66%) Greenfield Project
3 29 (5.29%) Enterprise Software
4 16 (2.92%) Management Information System
5 11 (2.01%) Data Structures
6 10 (1.82%) Algorithms
7 9 (1.64%) Self-Motivation
8 8 (1.46%) Public Cloud
9 6 (1.09%) Replication
10 5 (0.91%) Cloud Native
10 5 (0.91%) Renewable Energy
10 5 (0.91%) Virtual Team
11 4 (0.73%) e-Health
11 4 (0.73%) Mobile App
11 4 (0.73%) NHS
11 4 (0.73%) User Experience
12 3 (0.55%) Driving Licence
12 3 (0.55%) Market Risk
12 3 (0.55%) Social Media
13 2 (0.36%) Hybrid Cloud
Operating Systems
1 67 (12.23%) Windows
2 58 (10.58%) Linux
3 21 (3.83%) Unix
4 19 (3.47%) Windows Server
5 11 (2.01%) Windows Server 2012
5 11 (2.01%) Windows Server 2016
6 10 (1.82%) Windows 10
7 8 (1.46%) Android
7 8 (1.46%) Windows 7
7 8 (1.46%) Windows 8
8 7 (1.28%) Apple iOS
9 6 (1.09%) Red Hat Enterprise Linux
10 2 (0.36%) CentOS
11 1 (0.18%) Oracle Linux
11 1 (0.18%) Windows Server 2003
Processes & Methodologies
1 182 (33.21%) Agile Software Development
2 81 (14.78%) DevOps
3 80 (14.60%) Test Automation
4 79 (14.42%) MVC
5 67 (12.23%) Business Intelligence
5 67 (12.23%) Software Engineering
6 64 (11.68%) Problem-Solving
7 55 (10.04%) SDLC
8 50 (9.12%) Analytics
9 46 (8.39%) Microservices
9 46 (8.39%) Scrum
10 44 (8.03%) TDD
11 35 (6.39%) Mentoring
12 34 (6.20%) Continuous Integration
12 34 (6.20%) Web Development
13 30 (5.47%) Requirements Gathering
14 29 (5.29%) Computer Science
15 28 (5.11%) ERP
15 28 (5.11%) Performance Tuning
16 27 (4.93%) Machine Learning
Programming Languages
1 210 (38.32%) C#
2 188 (34.31%) JavaScript
3 118 (21.53%) Python
4 117 (21.35%) Java
5 82 (14.96%) T-SQL
6 35 (6.39%) PowerShell
7 30 (5.47%) PL/SQL
8 26 (4.74%) R
9 24 (4.38%) TypeScript
10 20 (3.65%) Ruby
11 17 (3.10%) Groovy
11 17 (3.10%) Scala
12 15 (2.74%) Perl
13 13 (2.37%) PHP
13 13 (2.37%) VB.NET
14 11 (2.01%) C++
15 10 (1.82%) Bash Shell
15 10 (1.82%) Shell Script
16 7 (1.28%) VB
17 4 (0.73%) VBA
Qualifications
1 65 (11.86%) Degree
2 16 (2.92%) Microsoft Certification
3 13 (2.37%) Computer Science Degree
4 5 (0.91%) ISTQB
4 5 (0.91%) PhD
5 3 (0.55%) AWS Certification
5 3 (0.55%) MCSE
6 2 (0.36%) CCNA
6 2 (0.36%) CCNP
6 2 (0.36%) Cisco Certification
6 2 (0.36%) MCITP
6 2 (0.36%) MCTS
6 2 (0.36%) Numerate Degree
7 1 (0.18%) HND
7 1 (0.18%) ITIL Certification
7 1 (0.18%) MCSD
7 1 (0.18%) Six Sigma Master Black Belt
7 1 (0.18%) Six Sigma Yellow Belt
Quality Assurance & Compliance
1 23 (4.20%) QA
2 5 (0.91%) GDPR
3 4 (0.73%) Data Quality
4 3 (0.55%) SLA
5 2 (0.36%) ISO/IEC 27001
System Software
1 52 (9.49%) Docker
2 16 (2.92%) Active Directory
3 11 (2.01%) Hyper-V
4 7 (1.28%) Virtual Machines
5 2 (0.36%) VMware Infrastructure
6 1 (0.18%) Firmware
6 1 (0.18%) Terminal Server
6 1 (0.18%) VMware ESXi
Systems Management
1 41 (7.48%) Kubernetes
2 12 (2.19%) Terraform
3 10 (1.82%) SCCM
4 9 (1.64%) Opscode Chef
5 7 (1.28%) Ansible
6 5 (0.91%) Puppet
7 2 (0.36%) Consul
7 2 (0.36%) Core Impact
7 2 (0.36%) Docker Swarm
7 2 (0.36%) Graphite
7 2 (0.36%) Microsoft Intune
7 2 (0.36%) Nessus
7 2 (0.36%) Nexpose
7 2 (0.36%) Packer
7 2 (0.36%) Prometheus
7 2 (0.36%) SCDPM
7 2 (0.36%) SCOM
7 2 (0.36%) SCOrch
7 2 (0.36%) SCSM
7 2 (0.36%) SCVMM
Vendors
1 155 (28.28%) Microsoft
2 82 (14.96%) Oracle
3 17 (3.10%) Databricks
4 13 (2.37%) Capita
5 9 (1.64%) Tableau
6 8 (1.46%) AppDynamics
6 8 (1.46%) Dynatrace
6 8 (1.46%) Google
6 8 (1.46%) Teradata
7 7 (1.28%) Micro Focus
7 7 (1.28%) MicroStrategy
8 6 (1.09%) Informatica
8 6 (1.09%) Xamarin
9 5 (0.91%) Cognos
10 4 (0.73%) Cisco
10 4 (0.73%) Cognizant
10 4 (0.73%) ESRI
10 4 (0.73%) Jaspersoft
10 4 (0.73%) SAP
11 3 (0.55%) Talend