Period
to 17 August 2019

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

SQL (Structured Query Language)
UK > Scotland
6 months to
17 Aug 2019
Same period 2018 Same period 2017
Rank 3 3 4
Rank change year-on-year 0 +1 0
Permanent jobs citing SQL 1,156 1,412 1,250
As % of all permanent IT jobs advertised in Scotland 22.06% 25.58% 23.47%
As % of the Programming Languages category 38.27% 45.39% 36.92%
Number of salaries quoted 831 980 645
Scotland median annual salary £45,000 £45,000 £40,000
Median salary % change year-on-year - +12.50% -3.03%
10th Percentile £29,750 £29,750 £27,500
90th Percentile £62,500 £65,000 £65,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 3,021 3,111 3,386
As % of all permanent IT jobs advertised in Scotland 57.64% 56.36% 63.57%
Number of salaries quoted 1,979 2,119 2,058
Scotland median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% -
10th Percentile £30,250 £30,250 £28,710
90th Percentile £65,000 £67,500 £67,500
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% -

SQL
Job Vacancy Trend in Scotland

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

Job vacancy trend for SQL 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.

Salary trend for SQL in Scotland

SQL
Salary Histogram in Scotland

The salary distribution of IT jobs citing SQL in Scotland over the 6 months to 17 August 2019.

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 17 August 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 502 £45,000 - 74
Edinburgh -3 491 £44,000 -2.22% 74
West Lothian +2 55 £42,500 +6.25% 5
Fife +10 40 £45,000 +42.86% 5
Dundee -1 19 £37,500 +25.00% 3
Aberdeen -9 9 £34,250 -27.51% 9
South Lanarkshire -1 8 £37,500 -11.76% 1
Stirling +1 6 - - 1
East Ayrshire - 5 £50,000 - 1
Highlands 0 4 £42,500 +21.43% 2
Dumfries and Galloway - 4 £60,000 - 1
Perth and Kinross +2 2 - -
Scottish Borders 0 2 £27,000 -1.82%
Aberdeenshire -2 2 - -
Angus - 1 - -
West Dunbartonshire - 1 £32,500 -
SQL
UK

For the 6 months to 17 August 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.

1 410 (35.47%) Agile Software Development
2 373 (32.27%) .NET
3 357 (30.88%) C#
4 332 (28.72%) Java
5 297 (25.69%) SQL Server
6 295 (25.52%) JavaScript
7 282 (24.39%) Finance
8 253 (21.89%) Microsoft Azure
9 237 (20.50%) Python
10 213 (18.43%) Oracle
11 210 (18.17%) HTML
12 200 (17.30%) Microsoft
13 198 (17.13%) CSS
14 195 (16.87%) Git (software)
15 175 (15.14%) MVC
16 158 (13.67%) Business Intelligence
17 157 (13.58%) SDLC
18 156 (13.49%) Problem-Solving
19 153 (13.24%) AngularJS
20 148 (12.80%) Software Engineering
21 147 (12.72%) ASP.NET
22 141 (12.20%) T-SQL
23 135 (11.68%) PL/SQL
23 135 (11.68%) Test Automation
24 127 (10.99%) ETL
25 122 (10.55%) Amazon AWS
26 119 (10.29%) Big Data
27 118 (10.21%) Relational Database
28 114 (9.86%) Microservices
29 112 (9.69%) Mentoring

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 36 (3.11%) Tomcat
2 32 (2.77%) IIS
3 29 (2.51%) SAS
4 25 (2.16%) Apache Spark
4 25 (2.16%) WebLogic
5 20 (1.73%) SharePoint
5 20 (1.73%) Umbraco
6 18 (1.56%) Apache
7 17 (1.47%) Confluence
8 12 (1.04%) IBM HTTP Server
8 12 (1.04%) JBoss
9 8 (0.69%) MQSeries
10 7 (0.61%) CloudStack
10 7 (0.61%) OpenStack
11 6 (0.52%) Oracle SOA Suite
12 5 (0.43%) Jetty
12 5 (0.43%) MS Exchange
12 5 (0.43%) Oracle Service Bus
12 5 (0.43%) Skype for Business
13 4 (0.35%) CMS
Applications
1 18 (1.56%) Microsoft Office
2 15 (1.30%) Microsoft Excel
3 7 (0.61%) Chatbot
4 5 (0.43%) Microsoft PowerPoint
4 5 (0.43%) MS Visio
5 2 (0.17%) InfoPath
5 2 (0.17%) SPSS
6 1 (0.087%) Acrobat
Business Applications
1 15 (1.30%) Dynamics CRM
2 6 (0.52%) Oracle BPM
3 4 (0.35%) Adobe Campaign
3 4 (0.35%) Dynamics AX
3 4 (0.35%) Dynamics NAV
3 4 (0.35%) Unit4 Business World
4 3 (0.26%) Magento
5 2 (0.17%) Elite 3E
5 2 (0.17%) Hyperion Enterprise
5 2 (0.17%) NetSuite
5 2 (0.17%) Oracle Payables
5 2 (0.17%) Oracle Receivables
6 1 (0.087%) Cognos Business Intelligence
6 1 (0.087%) Epicor Tropos
6 1 (0.087%) HFM
6 1 (0.087%) Hyperion Planning
6 1 (0.087%) Oracle Applications
6 1 (0.087%) Oracle EBS
6 1 (0.087%) PeopleSoft HCM
6 1 (0.087%) SAP S/4HANA
Cloud Services
1 253 (21.89%) Microsoft Azure
2 122 (10.55%) Amazon AWS
3 53 (4.58%) Power Platform
4 42 (3.63%) SaaS
5 34 (2.94%) Google Cloud Platform
6 23 (1.99%) Office 365
7 20 (1.73%) Cloud Computing
8 12 (1.04%) GitHub
9 9 (0.78%) Serverless
10 8 (0.69%) PaaS
11 7 (0.61%) Amazon EC2
11 7 (0.61%) npm
12 5 (0.43%) Amazon S3
12 5 (0.43%) AWS Lambda
13 4 (0.35%) Azure Data Factory
13 4 (0.35%) BlazeMeter
13 4 (0.35%) Sauce Labs
14 3 (0.26%) Dynamics 365
14 3 (0.26%) OpenShift
14 3 (0.26%) Virtual Private Cloud
Communications & Networking
1 30 (2.60%) Firewall
2 20 (1.73%) DNS
3 19 (1.64%) DHCP
4 18 (1.56%) HTTP
5 17 (1.47%) Internet
6 14 (1.21%) TCP/IP
7 8 (0.69%) SSL
8 6 (0.52%) VPN
9 5 (0.43%) Intranet
9 5 (0.43%) SAN
9 5 (0.43%) VLAN
9 5 (0.43%) Wireless
10 4 (0.35%) LAN
11 3 (0.26%) Cisco Firepower
11 3 (0.26%) Cisco Nexus
11 3 (0.26%) NAS
12 2 (0.17%) Cisco IOS
12 2 (0.17%) Ethernet
12 2 (0.17%) IP Telephony
12 2 (0.17%) WAN
Database & Business Intelligence
1 297 (25.69%) SQL Server
2 119 (10.29%) Big Data
3 118 (10.21%) Relational Database
4 94 (8.13%) NoSQL
5 90 (7.79%) Data Warehouse
6 86 (7.44%) SQL Server Integration Services
7 83 (7.18%) SQL Server Reporting Services
8 57 (4.93%) PostgreSQL
9 53 (4.58%) Power BI
10 46 (3.98%) Oracle Database
11 45 (3.89%) RDBMS
12 38 (3.29%) Hadoop
13 37 (3.20%) SQL Server Analysis Services
14 29 (2.51%) MySQL
15 27 (2.34%) GIS
16 26 (2.25%) Azure SQL Database
17 23 (1.99%) SQL Server 2012
18 21 (1.82%) DB2
19 20 (1.73%) QlikView
20 19 (1.64%) MongoDB
Development Applications
1 195 (16.87%) Git (software)
2 88 (7.61%) Jenkins
3 63 (5.45%) TeamCity
4 62 (5.36%) Visual Studio
5 51 (4.41%) JIRA
6 37 (3.20%) Team Foundation Server
7 31 (2.68%) Hudson
8 30 (2.60%) Selenium
9 28 (2.42%) Maven
10 27 (2.34%) Ant
10 27 (2.34%) Oracle Forms
10 27 (2.34%) Subversion
11 25 (2.16%) Cucumber
12 24 (2.08%) NetBeans
13 19 (1.64%) Bitbucket
14 18 (1.56%) Apache Ivy
15 16 (1.38%) JUnit
16 13 (1.12%) Appium
17 11 (0.95%) CA Release Automation
17 11 (0.95%) NUnit
General
1 282 (24.39%) Finance
2 50 (4.33%) Banking
3 31 (2.68%) Financial Institution
4 20 (1.73%) Manufacturing
5 19 (1.64%) Marketing
5 19 (1.64%) Retail
6 16 (1.38%) Investment Banking
7 11 (0.95%) Telecoms
8 7 (0.61%) Games
9 6 (0.52%) Electronics
9 6 (0.52%) Legal
9 6 (0.52%) Retail Banking
10 5 (0.43%) Law
11 3 (0.26%) Billing
11 3 (0.26%) Multimedia
12 2 (0.17%) Corporate Banking
12 2 (0.17%) Front Office
13 1 (0.087%) Advertising
13 1 (0.087%) Automotive
13 1 (0.087%) International Banking
Job Titles
1 570 (49.31%) Developer
2 130 (11.25%) Analyst
3 127 (10.99%) .NET Developer
4 126 (10.90%) Java Developer
5 121 (10.47%) Senior Developer
6 113 (9.78%) Software Developer
7 98 (8.48%) Software Engineer
8 78 (6.75%) C# Developer
9 66 (5.71%) SQL Developer
10 54 (4.67%) Data Engineer
11 47 (4.07%) C# Software Engineer
11 47 (4.07%) Senior Software Developer
12 44 (3.81%) .NET Software Developer
12 44 (3.81%) C# .NET Developer
13 42 (3.63%) DBA
14 40 (3.46%) Lead Developer
15 36 (3.11%) Support Analyst
16 34 (2.94%) Java Engineer
16 34 (2.94%) Senior Software Engineer
16 34 (2.94%) SQL DBA
Libraries, Frameworks & Software Standards
1 373 (32.27%) .NET
2 210 (18.17%) HTML
3 198 (17.13%) CSS
4 153 (13.24%) AngularJS
5 147 (12.72%) ASP.NET
6 112 (9.69%) React
7 93 (8.04%) jQuery
8 86 (7.44%) Web Services
9 85 (7.35%) RESTful
10 80 (6.92%) SOAP
11 79 (6.83%) .NET Core
12 77 (6.66%) ASP.NET MVC
13 65 (5.62%) XML
14 58 (5.02%) .NET Framework
14 58 (5.02%) Spring
15 51 (4.41%) HTML5
16 47 (4.07%) REST
17 42 (3.63%) Hibernate
18 40 (3.46%) WPF
19 37 (3.20%) Node.js
Miscellaneous
1 110 (9.52%) Analytical Skills
2 54 (4.67%) Robotics
3 47 (4.07%) Greenfield Project
4 30 (2.60%) Enterprise Software
5 25 (2.16%) Self-Motivation
6 23 (1.99%) Management Information System
7 22 (1.90%) Mobile App
8 17 (1.47%) Virtual Team
9 16 (1.38%) Credit Risk
9 16 (1.38%) User Experience
10 15 (1.30%) Algorithms
11 10 (0.87%) Clustering
11 10 (0.87%) Derivative
11 10 (0.87%) Hedge funds
11 10 (0.87%) Market Risk
11 10 (0.87%) Replication
12 9 (0.78%) Tandem
13 8 (0.69%) Data Structures
13 8 (0.69%) Linux Command Line
14 7 (0.61%) Driving Licence
Operating Systems
1 111 (9.60%) Windows
2 91 (7.87%) Unix
3 90 (7.79%) Linux
4 49 (4.24%) Windows Server
5 30 (2.60%) Windows Server 2012
6 28 (2.42%) Windows Server 2008
7 23 (1.99%) Android
8 20 (1.73%) Apple iOS
9 9 (0.78%) Windows 7
10 6 (0.52%) Windows 10
11 5 (0.43%) Red Hat Enterprise Linux
12 4 (0.35%) AIX
12 4 (0.35%) Mac OS X
13 3 (0.26%) Mac OS
13 3 (0.26%) MVS
13 3 (0.26%) Solaris
14 2 (0.17%) Windows 2000 Server
Processes & Methodologies
1 410 (35.47%) Agile Software Development
2 175 (15.14%) MVC
3 158 (13.67%) Business Intelligence
4 157 (13.58%) SDLC
5 156 (13.49%) Problem-Solving
6 148 (12.80%) Software Engineering
7 135 (11.68%) Test Automation
8 127 (10.99%) ETL
9 114 (9.86%) Microservices
10 112 (9.69%) Mentoring
11 111 (9.60%) DevOps
12 99 (8.56%) Continuous Integration
13 98 (8.48%) TDD
14 97 (8.39%) Scrum
15 86 (7.44%) OO
16 79 (6.83%) Analytics
17 70 (6.06%) Visualisation
18 62 (5.36%) Web Development
19 57 (4.93%) Continuous Improvement
20 56 (4.84%) Performance Tuning
Programming Languages
1 357 (30.88%) C#
2 332 (28.72%) Java
3 295 (25.52%) JavaScript
4 237 (20.50%) Python
5 141 (12.20%) T-SQL
6 135 (11.68%) PL/SQL
7 77 (6.66%) PowerShell
8 65 (5.62%) TypeScript
9 60 (5.19%) C++
10 59 (5.10%) R
11 47 (4.07%) Ruby
12 35 (3.03%) Java 8
13 34 (2.94%) VB.NET
14 28 (2.42%) Shell Script
15 24 (2.08%) Bash Shell
15 24 (2.08%) C
15 24 (2.08%) PHP
16 23 (1.99%) Perl
16 23 (1.99%) VBA
17 18 (1.56%) Scala
Qualifications
1 109 (9.43%) Degree
2 24 (2.08%) Numerate Degree
3 23 (1.99%) Computer Science Degree
4 21 (1.82%) Microsoft Certification
5 14 (1.21%) PhD
6 13 (1.12%) Cisco Certification
7 12 (1.04%) HND
8 11 (0.95%) OCA
8 11 (0.95%) OCP
8 11 (0.95%) Oracle Certification
9 10 (0.87%) CFA
10 8 (0.69%) CCNP
11 6 (0.52%) ISTQB
12 5 (0.43%) CCNA
12 5 (0.43%) MCSE
12 5 (0.43%) MCTS
13 4 (0.35%) MCSD
13 4 (0.35%) Security Cleared
14 3 (0.26%) MCAD
15 2 (0.17%) MCDBA
Quality Assurance & Compliance
1 59 (5.10%) QA
2 14 (1.21%) Data Quality
3 10 (0.87%) CRD IV
4 3 (0.26%) SLA
5 2 (0.17%) SEPA
6 1 (0.087%) Actionable Recommendations
6 1 (0.087%) COBIT
6 1 (0.087%) GDPR
6 1 (0.087%) ISO/IEC 27001
6 1 (0.087%) NIST
6 1 (0.087%) PCI DSS
System Software
1 37 (3.20%) Docker
2 34 (2.94%) Active Directory
3 16 (1.38%) vSphere
4 11 (0.95%) VMware ESXi
5 10 (0.87%) Active Directory Lightweight Directory Services
5 10 (0.87%) VMware Infrastructure
6 7 (0.61%) Citrix Hypervisor
6 7 (0.61%) Xen
7 6 (0.52%) Hyper-V
8 4 (0.35%) XenApp
9 3 (0.26%) HDFS
9 3 (0.26%) Time Sharing Option
10 2 (0.17%) Tivoli Workload Scheduler
10 2 (0.17%) Virtual Servers
11 1 (0.087%) Apache ZooKeeper
11 1 (0.087%) BitLocker
11 1 (0.087%) Firmware
11 1 (0.087%) Microsoft App-V
11 1 (0.087%) Virtual Machines
Systems Management
1 49 (4.24%) Ansible
2 40 (3.46%) Kubernetes
3 32 (2.77%) Opscode Chef
4 13 (1.12%) Puppet
4 13 (1.12%) Terraform
5 7 (0.61%) BMC PATROL
5 7 (0.61%) Cobbler
6 5 (0.43%) Backup Exec
6 5 (0.43%) Host Intrusion Detection System
6 5 (0.43%) Network Intrusion Detection System
7 4 (0.35%) CA Service Virtualization
7 4 (0.35%) Hadoop YARN
8 3 (0.26%) Data Guard
8 3 (0.26%) Oracle RMAN
8 3 (0.26%) SCOrch
8 3 (0.26%) ZABBIX
9 2 (0.17%) Plesk
9 2 (0.17%) SCCM
9 2 (0.17%) Tivoli
9 2 (0.17%) WSUS
Vendors
1 213 (18.43%) Oracle
2 200 (17.30%) Microsoft
3 33 (2.85%) Tableau
4 32 (2.77%) Google
5 29 (2.51%) IBM
6 21 (1.82%) SAP
7 19 (1.64%) Cisco
8 18 (1.56%) Micro Focus
9 15 (1.30%) Informatica
10 12 (1.04%) Xamarin
11 11 (0.95%) Sybase
11 11 (0.95%) VMware
12 10 (0.87%) Ab Initio
12 10 (0.87%) Databricks
12 10 (0.87%) Salesforce.com
13 9 (0.78%) Cognos
13 9 (0.78%) Netezza
13 9 (0.78%) Red Hat
14 8 (0.69%) Perfecto Mobile
15 6 (0.52%) Teradata