Period
to 17 November 2017

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

SQL (Structured Query Language)
UK > Scotland
6 months to
17 Nov 2017
Same period 2016 Same period 2015
Rank 4 5 4
Rank change year-on-year +1 -1 -1
Permanent jobs citing SQL 1363 945 1309
As % of all permanent IT jobs advertised in Scotland 24.17% 18.04% 20.29%
As % of the Programming Languages category 39.39% 33.62% 40.45%
Number of salaries quoted 785 578 824
Scotland median annual salary £40,000 £40,000 £40,000
10th Percentile £27,500 £26,925 £28,075
90th Percentile £60,000 £60,000 £60,000
UK median annual salary £45,000 £45,000 £45,000

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 3460 2811 3236
As % of all permanent IT jobs advertised in Scotland 61.35% 53.66% 50.15%
Number of salaries quoted 2226 1708 2014
Scotland median annual salary £42,500 £42,000 £40,000
Median salary % change year-on-year +1.19% +5.00% -
10th Percentile £28,750 £28,000 £27,500
90th Percentile £63,750 £60,000 £60,000
UK median annual salary £49,500 £47,500 £45,000
% change year-on-year +4.21% +5.56% +2.27%

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 November 2017.

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 November 2017. 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 +2 687 £40,000 -5.88% 17
Glasgow 0 524 £42,500 - 26
West Lothian +8 32 £33,750 +1.50% 1
Aberdeen +8 20 £40,000 +9.59% 1
Stirling +10 19 £42,500 +28.79%
Dundee +8 17 £40,000 +16.78% 1
Fife -1 15 £36,000 +22.03%
Orkney Islands - 11 - -
South Lanarkshire -4 7 £41,500 +32.80%
Renfrewshire +5 5 £34,400 +19.65%
North Lanarkshire 0 5 £42,500 -2.86% 1
Inverclyde - 4 £45,000 -
Midlothian 0 2 £26,500 -3.64%
Aberdeenshire - 2 £40,000 -
Scottish Borders 0 1 £35,000 - 1
Lanarkshire - 1 £35,500 -
Perthshire - 1 - - 1
Lothian - 1 £43,000 -
SQL
UK

For the 6 months to 17 November 2017, IT jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Scotland region with a requirement for SQL.

1 435 (31.91%) Agile Software Development
2 411 (30.15%) Finance
3 355 (26.05%) Oracle
4 341 (25.02%) SQL Server
5 331 (24.28%) Java
6 326 (23.92%) C#
7 307 (22.52%) .NET
8 287 (21.06%) Business Intelligence
9 238 (17.46%) Microsoft
10 215 (15.77%) Banking
11 209 (15.33%) JavaScript
12 203 (14.89%) Analytical Skills
13 186 (13.65%) PL/SQL
14 185 (13.57%) Stakeholder Management
15 178 (13.06%) HTML
15 178 (13.06%) Degree
16 155 (11.37%) CSS
17 152 (11.15%) TDD
18 151 (11.08%) SAS
19 149 (10.93%) Infrastructure Management
19 149 (10.93%) Relational Database
20 146 (10.71%) Python
21 144 (10.56%) Analytics
22 137 (10.05%) Windows
23 132 (9.68%) MVC
24 130 (9.54%) Data Warehouse
24 130 (9.54%) SDLC
25 128 (9.39%) Software Engineering
26 126 (9.24%) Mentoring
27 123 (9.02%) Data Management

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 151 (11.08%) SAS
2 47 (3.45%) SharePoint
3 42 (3.08%) IIS
4 33 (2.42%) Tomcat
5 28 (2.05%) Apache
6 27 (1.98%) JBoss
7 20 (1.47%) MS Exchange
8 15 (1.10%) Apache Spark
9 14 (1.03%) Exchange Server 2010
10 13 (0.95%) Confluence
11 12 (0.88%) Skype for Business
11 12 (0.88%) WebLogic
12 10 (0.73%) CMS
13 7 (0.51%) WebSphere
14 6 (0.44%) BizTalk Server
14 6 (0.44%) WebLogic Portal
15 5 (0.37%) GemFire
15 5 (0.37%) Oracle Coherence
16 4 (0.29%) Oracle SOA Suite
16 4 (0.29%) Umbraco
Applications
1 34 (2.49%) Microsoft Excel
2 29 (2.13%) Microsoft Office
3 12 (0.88%) MS Visio
4 8 (0.59%) SPSS
5 7 (0.51%) InfoPath
6 4 (0.29%) Microsoft PowerPoint
6 4 (0.29%) Mingle
7 3 (0.22%) Photoshop
8 2 (0.15%) Adobe Illustrator
9 1 (0.073%) EngageOne
Business Applications
1 26 (1.91%) Oracle EBS
2 23 (1.69%) Oracle EBS R12
3 12 (0.88%) Cognos Business Intelligence
3 12 (0.88%) Dynamics CRM
3 12 (0.88%) Oracle HRMS
3 12 (0.88%) Oracle Payroll
4 10 (0.73%) Oracle 11i
5 6 (0.44%) Oracle Financials
5 6 (0.44%) Oracle Procure-to-Pay
5 6 (0.44%) SAP GRC
6 5 (0.37%) Dynamics AX
6 5 (0.37%) NetSuite
7 4 (0.29%) Endur
7 4 (0.29%) Infor M3
8 3 (0.22%) Dynamics NAV
8 3 (0.22%) Oracle Applications
8 3 (0.22%) Sonata
9 2 (0.15%) BusinessWorks
9 2 (0.15%) Dynamics SL
9 2 (0.15%) Epicor Tropos
Cloud Services
1 107 (7.85%) Microsoft Azure
2 37 (2.71%) Amazon AWS
3 28 (2.05%) Office 365
4 25 (1.83%) Cloud Computing
5 19 (1.39%) SaaS
6 16 (1.17%) GitHub
7 14 (1.03%) Azure Active Directory
8 13 (0.95%) npm
9 12 (0.88%) Google Cloud Platform
10 11 (0.81%) Dynamics 365
11 3 (0.22%) Amazon S3
11 3 (0.22%) Serverless
11 3 (0.22%) Slack
12 2 (0.15%) Amazon SQS
12 2 (0.15%) Azure Data Factory
12 2 (0.15%) Azure Machine Learning
12 2 (0.15%) BlazeMeter
12 2 (0.15%) BrowserStack
12 2 (0.15%) Google Analytics
12 2 (0.15%) Oracle Service Cloud
Communications & Networking
1 25 (1.83%) Firewall
2 23 (1.69%) TCP/IP
3 22 (1.61%) DNS
4 20 (1.47%) DHCP
5 16 (1.17%) SAN
6 15 (1.10%) Telnet
7 11 (0.81%) VLAN
7 11 (0.81%) VPN
8 9 (0.66%) Internet
9 8 (0.59%) SMS
10 7 (0.51%) HTTP
10 7 (0.51%) LAN
10 7 (0.51%) WAN
10 7 (0.51%) Wireless
11 6 (0.44%) SSL
12 5 (0.37%) GPRS
12 5 (0.37%) SNMP
12 5 (0.37%) SSH
13 4 (0.29%) SMTP
14 3 (0.22%) Network Security
Database & Business Intelligence
1 341 (25.02%) SQL Server
2 149 (10.93%) Relational Database
3 130 (9.54%) Data Warehouse
4 116 (8.51%) SQL Server Reporting Services
5 110 (8.07%) SQL Server Integration Services
6 104 (7.63%) Oracle Database
7 91 (6.68%) Big Data
8 60 (4.40%) NoSQL
8 60 (4.40%) RDBMS
9 53 (3.89%) Data Mining
10 51 (3.74%) Base SAS
11 50 (3.67%) QlikView
12 48 (3.52%) SAS Data Integration Studio
12 48 (3.52%) SAS Enterprise Guide
13 41 (3.01%) Oracle Database 11g
14 40 (2.93%) SAS Visual Analytics
15 39 (2.86%) SQL Server Analysis Services
16 36 (2.64%) Oracle Database 10g
17 35 (2.57%) DB2
17 35 (2.57%) MongoDB
Development Applications
1 109 (8.00%) Git (software)
2 57 (4.18%) JUnit
3 54 (3.96%) JIRA
4 52 (3.82%) Selenium
5 41 (3.01%) Visual Studio
6 39 (2.86%) Subversion
7 35 (2.57%) ProC
8 33 (2.42%) Team Foundation Server
9 30 (2.20%) Maven
10 25 (1.83%) Jenkins
11 23 (1.69%) Oracle APEX
11 23 (1.69%) Oracle Forms
12 20 (1.47%) Cucumber
13 19 (1.39%) Moq
13 19 (1.39%) NUnit
14 18 (1.32%) TeamCity
15 16 (1.17%) NetBeans
15 16 (1.17%) Protractor
16 13 (0.95%) Grunt
16 13 (0.95%) gulp
General
1 411 (30.15%) Finance
2 215 (15.77%) Banking
3 89 (6.53%) Retail Banking
4 26 (1.91%) Investment Banking
5 23 (1.69%) Manufacturing
5 23 (1.69%) Telecoms
6 19 (1.39%) Marketing
7 16 (1.17%) Advertising
7 16 (1.17%) Legal
8 14 (1.03%) Games
9 13 (0.95%) Automotive
9 13 (0.95%) Military
10 12 (0.88%) Electronics
10 12 (0.88%) Retail
11 10 (0.73%) Financial Institution
12 6 (0.44%) Front Office
13 5 (0.37%) Law
13 5 (0.37%) Publishing
14 4 (0.29%) Prime Brokerage
15 2 (0.15%) Back Office
Job Titles
1 509 (37.34%) Developer
2 310 (22.74%) Analyst
3 145 (10.64%) Consultant
4 106 (7.78%) Senior Developer
5 105 (7.70%) SQL Developer
6 96 (7.04%) Java Developer
7 91 (6.68%) SQL Analyst
8 89 (6.53%) .NET Developer
9 88 (6.46%) Business Analyst
10 83 (6.09%) Data Analyst
11 73 (5.36%) Senior Analyst
11 73 (5.36%) Software Engineer
12 69 (5.06%) C# Developer
13 62 (4.55%) Software Developer
14 60 (4.40%) Support Analyst
15 54 (3.96%) DBA
16 47 (3.45%) Oracle Developer
16 47 (3.45%) SAS Consultant
17 45 (3.30%) Technical Analyst
18 44 (3.23%) Business Intelligence Developer
Libraries, Frameworks & Software Standards
1 307 (22.52%) .NET
2 178 (13.06%) HTML
3 155 (11.37%) CSS
4 106 (7.78%) XML
5 102 (7.48%) ASP.NET
6 93 (6.82%) Spring
7 90 (6.60%) Web Services
8 76 (5.58%) AngularJS
9 72 (5.28%) RESTful
10 68 (4.99%) SOAP
11 64 (4.70%) HTML5
12 63 (4.62%) ASP.NET MVC
12 63 (4.62%) Hibernate
13 55 (4.04%) jQuery
14 45 (3.30%) JSON
15 42 (3.08%) .NET Framework
16 41 (3.01%) REST
17 40 (2.93%) J2EE
18 39 (2.86%) CSS3
19 35 (2.57%) Entity Framework
Miscellaneous
1 203 (14.89%) Analytical Skills
2 73 (5.36%) Computer Science
3 35 (2.57%) Algorithms
4 33 (2.42%) User Experience
5 32 (2.35%) Robotics
6 30 (2.20%) Enterprise Software
7 27 (1.98%) Greenfield Project
8 23 (1.69%) Management Information System
9 19 (1.39%) Virtual Team
10 18 (1.32%) Data Centre
10 18 (1.32%) Mobile App
11 17 (1.25%) Data Structures
12 14 (1.03%) EMC VNX
13 12 (0.88%) Driving Licence
13 12 (0.88%) Fintech
14 11 (0.81%) Optoelectronics
15 10 (0.73%) Credit Risk
15 10 (0.73%) Mainframe
16 8 (0.59%) Replication
17 7 (0.51%) iPhone
Operating Systems
1 137 (10.05%) Windows
2 107 (7.85%) Linux
3 89 (6.53%) Unix
4 56 (4.11%) Windows Server
5 30 (2.20%) Windows Server 2008
6 27 (1.98%) Windows Server 2012
7 15 (1.10%) Windows Server 2003
8 14 (1.03%) Apple iOS
9 9 (0.66%) Windows 7
10 8 (0.59%) Android
10 8 (0.59%) Mac OS
11 7 (0.51%) Windows Phone
12 6 (0.44%) AIX
12 6 (0.44%) Solaris
12 6 (0.44%) Ubuntu
13 5 (0.37%) Red Hat Enterprise Linux
14 2 (0.15%) Windows 10
14 2 (0.15%) Windows 2000
14 2 (0.15%) Windows Vista
14 2 (0.15%) Windows XP
Processes & Methodologies
1 435 (31.91%) Agile Software Development
2 287 (21.06%) Business Intelligence
3 185 (13.57%) Stakeholder Management
4 152 (11.15%) TDD
5 149 (10.93%) Infrastructure Management
6 144 (10.56%) Analytics
7 132 (9.68%) MVC
8 130 (9.54%) SDLC
9 128 (9.39%) Software Engineering
10 126 (9.24%) Mentoring
11 123 (9.02%) Data Management
12 122 (8.95%) Test Automation
13 117 (8.58%) Scrum
14 108 (7.92%) ETL
15 98 (7.19%) OO
16 95 (6.97%) Data Analysis
17 85 (6.24%) Data Modelling
18 77 (5.65%) ITIL
18 77 (5.65%) Unit Testing
19 71 (5.21%) Continuous Integration
Programming Languages
1 331 (24.28%) Java
2 326 (23.92%) C#
3 209 (15.33%) JavaScript
4 186 (13.65%) PL/SQL
5 146 (10.71%) Python
6 117 (8.58%) T-SQL
7 76 (5.58%) PowerShell
8 55 (4.04%) C++
9 36 (2.64%) R
9 36 (2.64%) SAS Macro
10 35 (2.57%) PROC SQL
11 28 (2.05%) PHP
12 26 (1.91%) C
13 25 (1.83%) Shell Script
13 25 (1.83%) VB.NET
14 23 (1.69%) VB
15 22 (1.61%) Scala
16 20 (1.47%) Perl
16 20 (1.47%) Ruby
17 15 (1.10%) TypeScript
Qualifications
1 178 (13.06%) Degree
2 39 (2.86%) Microsoft Certification
3 37 (2.71%) Security Cleared
4 33 (2.42%) Numerate Degree
5 14 (1.03%) MCAD
5 14 (1.03%) MCSD
5 14 (1.03%) MCTS
6 13 (0.95%) Computer Science Degree
7 12 (0.88%) ISEB
8 8 (0.59%) ISTQB
8 8 (0.59%) MCDBA
8 8 (0.59%) MCITP
8 8 (0.59%) PhD
9 7 (0.51%) SC Cleared
10 6 (0.44%) MCP
10 6 (0.44%) Oracle Certification
11 5 (0.37%) OCP
11 5 (0.37%) SAP Certification
12 4 (0.29%) HND
12 4 (0.29%) Postgraduate
Quality Assurance & Compliance
1 46 (3.37%) QA
2 22 (1.61%) SLA
3 13 (0.95%) Data Quality
4 9 (0.66%) ISO/IEC 27001
5 4 (0.29%) ISO 9001
5 4 (0.29%) PMO
6 2 (0.15%) Disclosure Scotland
6 2 (0.15%) GDPR
6 2 (0.15%) ISO 20022
6 2 (0.15%) MiFID
6 2 (0.15%) Sarbanes-Oxley
7 1 (0.073%) Dodd-Frank
7 1 (0.073%) EMIR
7 1 (0.073%) IFRS
7 1 (0.073%) IFRS 9
System Software
1 56 (4.11%) Active Directory
2 35 (2.57%) VMware Infrastructure
3 25 (1.83%) vSphere
4 21 (1.54%) Hyper-V
5 20 (1.47%) VMware ESXi
6 13 (0.95%) Firmware
7 9 (0.66%) Docker
8 7 (0.51%) Microsoft App-V
9 6 (0.44%) Oracle RAC
9 6 (0.44%) XenApp
10 4 (0.29%) XenDesktop
11 1 (0.073%) HDFS
Systems Management
1 29 (2.13%) SCCM
2 22 (1.61%) Opscode Chef
3 19 (1.39%) SCOM
4 11 (0.81%) Oracle RMAN
5 9 (0.66%) Data Guard
5 9 (0.66%) Nagios
6 7 (0.51%) Ansible
6 7 (0.51%) Puppet
6 7 (0.51%) Systems Management Server (SMS)
7 6 (0.44%) Backup Exec
7 6 (0.44%) Host Intrusion Detection System
7 6 (0.44%) Malwarebytes
7 6 (0.44%) Network Intrusion Detection System
7 6 (0.44%) Norton AntiVirus
8 4 (0.29%) Perfmon
8 4 (0.29%) Symantec Endpoint Protection
8 4 (0.29%) Symantec Enterprise Vault
8 4 (0.29%) ZABBIX
9 3 (0.22%) Ambari
9 3 (0.22%) Rancher
Vendors
1 355 (26.05%) Oracle
2 238 (17.46%) Microsoft
3 83 (6.09%) Teradata
4 55 (4.04%) Informatica
5 54 (3.96%) VMware
6 50 (3.67%) Cognos
7 47 (3.45%) MicroStrategy
8 36 (2.64%) Tableau
9 33 (2.42%) Cisco
10 32 (2.35%) IBM
11 28 (2.05%) SAP
12 26 (1.91%) HP
13 15 (1.10%) EMC
13 15 (1.10%) Sybase
13 15 (1.10%) TIBCO
14 13 (0.95%) Cognizant
14 13 (0.95%) Google
15 11 (0.81%) Citrix
16 10 (0.73%) Symantec
17 9 (0.66%) Apple