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

SQL (Structured Query Language)
UK > Scotland
6 months to
25 Apr 2019
Same period 2018 Same period 2017
Rank 3 3 4
Rank change year-on-year 0 +1 0
Permanent jobs citing SQL 1,270 1,379 1,015
As % of all permanent IT jobs advertised in Scotland 23.54% 23.79% 21.99%
As % of the Programming Languages category 40.55% 42.84% 35.94%
Number of salaries quoted 890 933 527
Scotland median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -
10th Percentile £29,750 £28,250 £27,000
90th Percentile £65,000 £65,000 £58,750
UK median annual salary £49,337 £46,000 £45,000
% change year-on-year +7.25% +2.22% -

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,132 3,219 2,824
As % of all permanent IT jobs advertised in Scotland 58.06% 55.53% 61.18%
Number of salaries quoted 2,092 2,256 1,696
Scotland median annual salary £45,000 £45,000 £42,500
Median salary % change year-on-year - +5.88% +3.66%
10th Percentile £30,250 £29,750 £28,250
90th Percentile £65,000 £68,750 £62,500
UK median annual salary £52,500 £50,000 £47,500
% change year-on-year +5.00% +5.26% +3.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 25 April 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 25 April 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 562 £45,000 - 25
Edinburgh -3 471 £42,178 -0.76% 28
West Lothian +6 96 £42,500 +6.25% 2
Fife +15 28 £45,000 +50.00%
Dundee +3 18 £31,000 -17.33% 2
South Lanarkshire +2 16 £43,500 +2.35%
Aberdeenshire +3 14 £31,750 -18.59%
South Ayrshire -1 12 £50,000 -9.09%
Aberdeen -9 10 £42,500 -15.00% 4
East Ayrshire - 10 £50,000 - 1
Renfrewshire - 6 £45,000 -
Stirling +5 5 - -
Dumfries and Galloway - 5 £60,000 -
Highlands - 2 £52,500 - 1
West Dunbartonshire - 2 £37,750 -
SQL
UK

For the 6 months to 25 April 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 453 (35.67%) Agile Software Development
2 436 (34.33%) Java
3 396 (31.18%) C#
4 364 (28.66%) JavaScript
5 363 (28.58%) Finance
6 362 (28.50%) .NET
7 348 (27.40%) SQL Server
8 290 (22.83%) Oracle
9 269 (21.18%) Python
10 268 (21.10%) HTML
11 222 (17.48%) CSS
12 209 (16.46%) Git (software)
12 209 (16.46%) Test Automation
13 202 (15.91%) Microsoft
14 197 (15.51%) PL/SQL
15 189 (14.88%) MVC
15 189 (14.88%) Business Intelligence
16 178 (14.02%) OO
17 174 (13.70%) Microsoft Azure
17 174 (13.70%) Relational Database
18 162 (12.76%) Problem-Solving
19 158 (12.44%) AngularJS
20 153 (12.05%) Analytical Skills
21 151 (11.89%) TDD
22 147 (11.57%) T-SQL
23 146 (11.50%) Software Engineering
24 144 (11.34%) NoSQL
25 139 (10.94%) SDLC
26 135 (10.63%) Windows
27 134 (10.55%) 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 51 (4.02%) SAS
2 40 (3.15%) SharePoint
3 39 (3.07%) IIS
4 34 (2.68%) Apache Spark
4 34 (2.68%) Confluence
5 30 (2.36%) Tomcat
6 27 (2.13%) MQSeries
6 27 (2.13%) WebSphere
7 22 (1.73%) Umbraco
7 22 (1.73%) WebLogic
8 19 (1.50%) Apache
9 12 (0.94%) JBoss
9 12 (0.94%) WebSphere Application Server
10 11 (0.87%) WildFly
11 6 (0.47%) MS Exchange
12 5 (0.39%) Skype for Business
13 4 (0.31%) Apache Pig
13 4 (0.31%) CMS
13 4 (0.31%) Elasticsearch
14 3 (0.24%) IBM Notes
Applications
1 30 (2.36%) Microsoft Excel
2 26 (2.05%) Microsoft Office
3 10 (0.79%) Microsoft PowerPoint
4 8 (0.63%) MS Visio
5 6 (0.47%) Chatbot
6 2 (0.16%) InfoPath
7 1 (0.079%) Acrobat
7 1 (0.079%) SPSS
Business Applications
1 33 (2.60%) Oracle EBS
2 24 (1.89%) Oracle ERP
3 18 (1.42%) Dynamics CRM
4 15 (1.18%) Dynamics AX
5 4 (0.31%) Markit EDM
6 3 (0.24%) Magento
7 2 (0.16%) Dynamics NAV
7 2 (0.16%) Elite 3E
7 2 (0.16%) HFM
7 2 (0.16%) Oracle 11i
7 2 (0.16%) Oracle Applications
7 2 (0.16%) Oracle EBS R12
7 2 (0.16%) Oracle HRMS
7 2 (0.16%) Oracle Payroll
8 1 (0.079%) Cognos Business Intelligence
8 1 (0.079%) Cognos TM1
8 1 (0.079%) Hyperion Planning
8 1 (0.079%) Infor CloudSuite Industrial (formerly SyteLine)
8 1 (0.079%) PeopleSoft HCM
Cloud Services
1 174 (13.70%) Microsoft Azure
2 123 (9.69%) Amazon AWS
3 30 (2.36%) SaaS
4 28 (2.20%) Google Cloud Platform
5 21 (1.65%) Dynamics 365
6 17 (1.34%) GitHub
6 17 (1.34%) Office 365
7 12 (0.94%) Cloud Computing
8 10 (0.79%) PaaS
9 7 (0.55%) Amazon EC2
9 7 (0.55%) Amazon S3
9 7 (0.55%) Serverless
10 5 (0.39%) Azure Data Factory
11 4 (0.31%) AWS Lambda
11 4 (0.31%) BlazeMeter
11 4 (0.31%) npm
11 4 (0.31%) Sauce Labs
12 3 (0.24%) Amazon EMR
12 3 (0.24%) Amazon SQS
12 3 (0.24%) Google Analytics
Communications & Networking
1 20 (1.57%) DNS
2 17 (1.34%) Firewall
3 16 (1.26%) Internet
4 13 (1.02%) TCP/IP
5 12 (0.94%) HTTP
5 12 (0.94%) SSL
6 9 (0.71%) SAN
7 8 (0.63%) AMQP
8 7 (0.55%) DHCP
9 5 (0.39%) VLAN
9 5 (0.39%) VPN
9 5 (0.39%) Wireless
10 4 (0.31%) LAN
10 4 (0.31%) NAS
10 4 (0.31%) Remote Desktop
11 3 (0.24%) Cisco Firepower
11 3 (0.24%) Cisco IOS
11 3 (0.24%) Cisco Nexus
11 3 (0.24%) Ethernet
11 3 (0.24%) Intranet
Database & Business Intelligence
1 348 (27.40%) SQL Server
2 174 (13.70%) Relational Database
3 144 (11.34%) NoSQL
4 126 (9.92%) SQL Server Reporting Services
5 114 (8.98%) SQL Server Integration Services
6 108 (8.50%) Big Data
7 94 (7.40%) PostgreSQL
8 91 (7.17%) Data Warehouse
9 65 (5.12%) Hadoop
9 65 (5.12%) MySQL
10 60 (4.72%) RDBMS
11 46 (3.62%) Power BI
12 44 (3.46%) Oracle Database
13 43 (3.39%) Oracle Reports
14 41 (3.23%) Apache Cassandra
15 38 (2.99%) SQL Server Analysis Services
16 33 (2.60%) SQL Server 2012
17 28 (2.20%) QlikView
18 27 (2.13%) Bigtable
19 25 (1.97%) Oracle BI Publisher
Development Applications
1 209 (16.46%) Git (software)
2 94 (7.40%) Jenkins
3 91 (7.17%) Visual Studio
4 79 (6.22%) Selenium
5 72 (5.67%) JIRA
6 62 (4.88%) Cucumber
7 54 (4.25%) TeamCity
8 51 (4.02%) Hudson
9 43 (3.39%) Oracle Forms
10 40 (3.15%) Subversion
11 38 (2.99%) Maven
12 37 (2.91%) Team Foundation Server
13 29 (2.28%) SpecFlow
14 23 (1.81%) NUnit
15 22 (1.73%) Eclipse
15 22 (1.73%) JUnit
16 20 (1.57%) NetBeans
17 18 (1.42%) Oracle APEX
18 17 (1.34%) SQL Server Management Studio (SSMS)
19 16 (1.26%) Gradle
General
1 363 (28.58%) Finance
2 70 (5.51%) Banking
3 28 (2.20%) Financial Institution
4 21 (1.65%) Retail
5 10 (0.79%) Corporate Banking
6 9 (0.71%) Investment Banking
6 9 (0.71%) Marketing
7 8 (0.63%) Games
8 7 (0.55%) Manufacturing
9 6 (0.47%) Telecoms
10 5 (0.39%) Legal
10 5 (0.39%) Retail Banking
11 3 (0.24%) Automotive
11 3 (0.24%) Multimedia
11 3 (0.24%) Private Banking
12 2 (0.16%) Law
13 1 (0.079%) Electronics
13 1 (0.079%) International Banking
Job Titles
1 607 (47.80%) Developer
2 192 (15.12%) Analyst
3 150 (11.81%) Java Developer
4 147 (11.57%) .NET Developer
5 123 (9.69%) Software Developer
6 112 (8.82%) Software Engineer
7 95 (7.48%) Senior Developer
8 83 (6.54%) C# Developer
9 67 (5.28%) SQL Developer
10 61 (4.80%) Test Analyst
11 52 (4.09%) C# .NET Developer
12 51 (4.02%) Java Engineer
13 47 (3.70%) .NET Software Developer
14 44 (3.46%) C# Software Engineer
15 40 (3.15%) Senior Analyst
16 39 (3.07%) Oracle Developer
17 38 (2.99%) Data Engineer
17 38 (2.99%) Test Engineer
18 36 (2.83%) Java Software Engineer
19 35 (2.76%) Senior .NET Developer
Libraries, Frameworks & Software Standards
1 362 (28.50%) .NET
2 268 (21.10%) HTML
3 222 (17.48%) CSS
4 158 (12.44%) AngularJS
5 126 (9.92%) ASP.NET
6 119 (9.37%) XML
7 104 (8.19%) Web Services
8 95 (7.48%) jQuery
9 91 (7.17%) Spring
10 77 (6.06%) React
11 74 (5.83%) HTML5
11 74 (5.83%) JSON
12 73 (5.75%) .NET Framework
13 69 (5.43%) SOAP
14 67 (5.28%) RESTful
15 60 (4.72%) REST
16 58 (4.57%) Hibernate
17 55 (4.33%) CSS3
18 53 (4.17%) ASP.NET MVC
19 51 (4.02%) .NET Core
Miscellaneous
1 153 (12.05%) Analytical Skills
2 62 (4.88%) Greenfield Project
3 44 (3.46%) Management Information System
3 44 (3.46%) Robotics
4 41 (3.23%) Enterprise Software
5 37 (2.91%) Fintech
6 36 (2.83%) Virtual Team
7 26 (2.05%) Mobile App
8 23 (1.81%) Algorithms
9 17 (1.34%) User Experience
10 14 (1.10%) Data Structures
11 12 (0.94%) Self-Motivation
12 10 (0.79%) Clustering
13 9 (0.71%) Derivative
13 9 (0.71%) Embedded Systems
14 8 (0.63%) Driving Licence
14 8 (0.63%) Linux Command Line
14 8 (0.63%) Video\Live Streaming
15 7 (0.55%) Credit Risk
15 7 (0.55%) Replication
Operating Systems
1 135 (10.63%) Windows
2 109 (8.58%) Linux
3 71 (5.59%) Unix
4 51 (4.02%) Windows Server
5 47 (3.70%) Apple iOS
6 42 (3.31%) Android
7 17 (1.34%) Windows Server 2008
8 16 (1.26%) Windows Server 2012
9 8 (0.63%) Windows 7
10 4 (0.31%) Solaris
11 3 (0.24%) MVS
11 3 (0.24%) Windows 10
11 3 (0.24%) Windows 2000 Server
12 1 (0.079%) AIX
12 1 (0.079%) Red Hat Enterprise Linux
Processes & Methodologies
1 453 (35.67%) Agile Software Development
2 209 (16.46%) Test Automation
3 189 (14.88%) Business Intelligence
3 189 (14.88%) MVC
4 178 (14.02%) OO
5 162 (12.76%) Problem-Solving
6 151 (11.89%) TDD
7 146 (11.50%) Software Engineering
8 139 (10.94%) SDLC
9 123 (9.69%) Scrum
10 122 (9.61%) Continuous Integration
11 119 (9.37%) ETL
12 108 (8.50%) Analytics
13 98 (7.72%) BDD
14 91 (7.17%) Microservices
15 86 (6.77%) Mentoring
16 85 (6.69%) Unit Testing
17 80 (6.30%) Computer Science
18 74 (5.83%) DevOps
19 72 (5.67%) Data Modelling
Programming Languages
1 436 (34.33%) Java
2 396 (31.18%) C#
3 364 (28.66%) JavaScript
4 269 (21.18%) Python
5 197 (15.51%) PL/SQL
6 147 (11.57%) T-SQL
7 92 (7.24%) C++
8 63 (4.96%) PowerShell
9 58 (4.57%) R
10 50 (3.94%) PHP
11 35 (2.76%) Shell Script
11 35 (2.76%) TypeScript
11 35 (2.76%) VB.NET
12 29 (2.28%) XPath
13 27 (2.13%) Ruby
13 27 (2.13%) VBA
14 24 (1.89%) C
15 22 (1.73%) Perl
16 21 (1.65%) Java 8
16 21 (1.65%) Scala
Qualifications
1 134 (10.55%) Degree
2 22 (1.73%) Computer Science Degree
2 22 (1.73%) Microsoft Certification
3 20 (1.57%) Numerate Degree
4 12 (0.94%) HND
5 11 (0.87%) Security Cleared
6 10 (0.79%) Cisco Certification
6 10 (0.79%) OCA
6 10 (0.79%) OCP
6 10 (0.79%) Oracle Certification
7 8 (0.63%) PhD
8 7 (0.55%) MCSA
8 7 (0.55%) MCSD
9 6 (0.47%) CFA
9 6 (0.47%) MCSE
10 5 (0.39%) CCNP
10 5 (0.39%) ISTQB
10 5 (0.39%) MCAD
10 5 (0.39%) MCTS
11 3 (0.24%) ISEB
Quality Assurance & Compliance
1 81 (6.38%) QA
2 27 (2.13%) Data Quality
3 8 (0.63%) GDPR
4 6 (0.47%) CRD IV
5 5 (0.39%) SLA
6 3 (0.24%) ISO/IEC 27001
6 3 (0.24%) PMO
7 2 (0.16%) SEPA
8 1 (0.079%) Actionable Recommendations
8 1 (0.079%) COBIT
8 1 (0.079%) IFRS
8 1 (0.079%) IFRS 9
8 1 (0.079%) PCI DSS
System Software
1 55 (4.33%) Docker
2 46 (3.62%) Active Directory
3 13 (1.02%) VMware Infrastructure
3 13 (1.02%) vSphere
4 10 (0.79%) VMware ESXi
5 5 (0.39%) XenApp
6 4 (0.31%) HDFS
7 3 (0.24%) Time Sharing Option
7 3 (0.24%) Virtual Servers
8 2 (0.16%) Apache Flume
8 2 (0.16%) Xen
8 2 (0.16%) XenServer
9 1 (0.079%) BitLocker
9 1 (0.079%) Firmware
9 1 (0.079%) Hyper-V
9 1 (0.079%) Samba
9 1 (0.079%) Virtual Machines
Systems Management
1 64 (5.04%) Ansible
2 32 (2.52%) Kubernetes
3 29 (2.28%) Puppet
4 26 (2.05%) Opscode Chef
5 7 (0.55%) Terraform
6 5 (0.39%) Backup Exec
6 5 (0.39%) Host Intrusion Detection System
6 5 (0.39%) Network Intrusion Detection System
7 4 (0.31%) Ambari
7 4 (0.31%) CA Service Virtualization
8 3 (0.24%) Hadoop YARN
8 3 (0.24%) MaaS360
8 3 (0.24%) Microsoft Clustering
8 3 (0.24%) Oracle RMAN
8 3 (0.24%) SCOrch
8 3 (0.24%) ZABBIX
9 2 (0.16%) Data Guard
9 2 (0.16%) Prometheus
9 2 (0.16%) WMI
9 2 (0.16%) WSUS
Vendors
1 290 (22.83%) Oracle
2 202 (15.91%) Microsoft
3 36 (2.83%) Google
4 35 (2.76%) Tableau
5 17 (1.34%) Xamarin
6 16 (1.26%) SAP
7 15 (1.18%) Cisco
7 15 (1.18%) VMware
8 14 (1.10%) MicroStrategy
9 12 (0.94%) IBM
9 12 (0.94%) Netezza
9 12 (0.94%) Sybase
9 12 (0.94%) TIBCO
10 11 (0.87%) CA
10 11 (0.87%) Solace
11 10 (0.79%) Ab Initio
11 10 (0.79%) AppDynamics
11 10 (0.79%) HP
11 10 (0.79%) Teradata
12 9 (0.71%) Informatica