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

SQL (Structured Query Language)
UK > Scotland
6 months to
18 Oct 2017
Same period 2016 Same period 2015
Rank 4 5 4
Rank change year-on-year +1 -1 -1
Permanent jobs citing SQL 1337 961 1294
As % of all permanent IT jobs advertised in Scotland 24.19% 18.06% 20.40%
As % of the Programming Languages category 38.90% 34.11% 41.03%
Number of salaries quoted 758 567 832
Scotland median annual salary £40,000 £40,500 £42,366
Median salary % change year-on-year -1.23% -4.40% +5.92%
10th Percentile £27,850 £26,750 £28,750
90th Percentile £60,000 £60,000 £62,450
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 3437 2817 3154
As % of all permanent IT jobs advertised in Scotland 62.19% 52.93% 49.73%
Number of salaries quoted 2199 1653 1983
Scotland median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -
10th Percentile £28,750 £28,050 £27,500
90th Percentile £65,000 £60,000 £60,000
UK median annual salary £48,500 £47,500 £45,000
% change year-on-year +2.11% +5.56% +1.12%

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 18 October 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 18 October 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 +1 682 £40,000 -10.11% 42
Glasgow 0 501 £42,500 - 32
West Lothian +5 32 £32,500 - 2
Stirling +13 19 £45,000 +36.36% 1
Aberdeen +11 19 £40,000 -6.98% 1
Dundee +2 17 £39,500 +15.32% 2
Fife +5 15 £36,184 +22.66% 2
Orkney Islands - 7 - -
South Lanarkshire -4 6 £42,000 +34.40% 1
Renfrewshire +2 5 £34,400 +19.65% 2
North Lanarkshire -3 5 £42,500 -2.86%
Lothian - 5 £43,000 -
Inverclyde - 4 £45,000 -
Midlothian 0 2 £26,500 -3.64%
Scottish Borders 0 2 £34,500 -1.43%
Lanarkshire - 1 £35,500 - 2
Aberdeenshire - 1 £40,000 -
SQL
UK

For the 6 months to 18 October 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 (32.54%) Agile Software Development
2 431 (32.24%) Finance
3 354 (26.48%) Oracle
4 336 (25.13%) SQL Server
5 332 (24.83%) Java
6 299 (22.36%) C#
7 282 (21.09%) .NET
7 282 (21.09%) Business Intelligence
8 242 (18.10%) Banking
9 235 (17.58%) Microsoft
10 213 (15.93%) Analytical Skills
11 201 (15.03%) JavaScript
11 201 (15.03%) Stakeholder Management
12 179 (13.39%) PL/SQL
13 177 (13.24%) Degree
14 176 (13.16%) HTML
15 168 (12.57%) Infrastructure Management
16 157 (11.74%) Relational Database
17 156 (11.67%) SAS
18 149 (11.14%) CSS
19 145 (10.85%) Python
19 145 (10.85%) TDD
20 142 (10.62%) Analytics
21 136 (10.17%) SDLC
22 135 (10.10%) Mentoring
23 134 (10.02%) Windows
24 128 (9.57%) MVC
25 127 (9.50%) Data Management
26 121 (9.05%) Test Automation
27 120 (8.98%) SQL Server Reporting Services

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 156 (11.67%) SAS
2 49 (3.66%) SharePoint
3 44 (3.29%) Tomcat
4 41 (3.07%) IIS
5 29 (2.17%) Apache
6 27 (2.02%) JBoss
7 24 (1.80%) MS Exchange
8 15 (1.12%) Exchange Server 2010
9 13 (0.97%) Confluence
10 12 (0.90%) WebLogic
11 11 (0.82%) Apache Spark
11 11 (0.82%) Skype for Business
12 9 (0.67%) WebSphere
13 8 (0.60%) CMS
13 8 (0.60%) SharePoint 2013
14 6 (0.45%) BizTalk Server
14 6 (0.45%) Oracle Coherence
14 6 (0.45%) Oracle SOA Suite
15 5 (0.37%) Apache Pig
15 5 (0.37%) WebLogic Portal
Applications
1 41 (3.07%) Microsoft Excel
2 31 (2.32%) Microsoft Office
3 8 (0.60%) MS Visio
4 7 (0.52%) SPSS
5 5 (0.37%) InfoPath
5 5 (0.37%) Microsoft Project
6 4 (0.30%) Mingle
7 3 (0.22%) Photoshop
8 2 (0.15%) Adobe Illustrator
8 2 (0.15%) Microsoft PowerPoint
9 1 (0.075%) EngageOne
Business Applications
1 27 (2.02%) Oracle EBS
2 23 (1.72%) Oracle EBS R12
3 17 (1.27%) Dynamics CRM
4 15 (1.12%) Cognos Business Intelligence
5 12 (0.90%) Oracle HRMS
5 12 (0.90%) Oracle Payroll
6 10 (0.75%) Oracle 11i
7 6 (0.45%) Oracle Financials
7 6 (0.45%) Oracle Procure-to-Pay
7 6 (0.45%) SAP GRC
8 5 (0.37%) Dynamics AX
8 5 (0.37%) Sonata
9 4 (0.30%) Endur
10 3 (0.22%) Cognos TM1
10 3 (0.22%) Dynamics NAV
10 3 (0.22%) NetSuite
10 3 (0.22%) Oracle Applications
11 2 (0.15%) BusinessWorks
11 2 (0.15%) Dynamics SL
11 2 (0.15%) Infor M3
Cloud Services
1 100 (7.48%) Microsoft Azure
2 34 (2.54%) Office 365
3 33 (2.47%) Amazon AWS
4 25 (1.87%) Cloud Computing
5 17 (1.27%) SaaS
6 16 (1.20%) GitHub
7 14 (1.05%) Azure Active Directory
8 11 (0.82%) npm
9 9 (0.67%) Dynamics 365
10 6 (0.45%) Google Cloud Platform
11 3 (0.22%) Amazon S3
11 3 (0.22%) Google Analytics
11 3 (0.22%) Oracle Service Cloud
11 3 (0.22%) Serverless
11 3 (0.22%) Slack
11 3 (0.22%) Trello
12 2 (0.15%) Amazon EMR
12 2 (0.15%) Azure Machine Learning
13 1 (0.075%) Amazon EC2
13 1 (0.075%) CloudFront
Communications & Networking
1 23 (1.72%) Firewall
2 22 (1.65%) TCP/IP
3 21 (1.57%) DNS
4 18 (1.35%) DHCP
5 14 (1.05%) SAN
5 14 (1.05%) Telnet
6 10 (0.75%) Internet
6 10 (0.75%) LAN
6 10 (0.75%) WAN
7 9 (0.67%) VPN
8 8 (0.60%) VLAN
9 7 (0.52%) SMS
10 6 (0.45%) Network Security
10 6 (0.45%) SSL
11 5 (0.37%) GPRS
11 5 (0.37%) HTTP
11 5 (0.37%) SMTP
11 5 (0.37%) SSH
11 5 (0.37%) Wireless
12 4 (0.30%) SNMP
Database & Business Intelligence
1 336 (25.13%) SQL Server
2 157 (11.74%) Relational Database
3 120 (8.98%) SQL Server Reporting Services
4 116 (8.68%) SQL Server Integration Services
5 114 (8.53%) Data Warehouse
6 94 (7.03%) Oracle Database
7 73 (5.46%) Big Data
8 67 (5.01%) RDBMS
9 55 (4.11%) SAS Data Integration Studio
10 54 (4.04%) Base SAS
10 54 (4.04%) SAS Enterprise Guide
11 53 (3.96%) Data Mining
12 50 (3.74%) NoSQL
13 49 (3.66%) QlikView
14 45 (3.37%) SAS Visual Analytics
15 43 (3.22%) SQL Server 2012
16 39 (2.92%) SQL Server Analysis Services
17 33 (2.47%) Oracle Database 11g
18 32 (2.39%) Oracle Database 10g
19 31 (2.32%) DB2
Development Applications
1 92 (6.88%) Git (software)
2 69 (5.16%) JUnit
3 59 (4.41%) Selenium
4 57 (4.26%) JIRA
5 43 (3.22%) ProC
6 35 (2.62%) Subversion
7 34 (2.54%) Team Foundation Server
8 31 (2.32%) Maven
9 30 (2.24%) Jenkins
9 30 (2.24%) Visual Studio
10 22 (1.65%) Cucumber
10 22 (1.65%) Oracle Forms
11 20 (1.50%) Oracle APEX
12 19 (1.42%) Moq
12 19 (1.42%) NUnit
12 19 (1.42%) TeamCity
13 18 (1.35%) Protractor
14 15 (1.12%) Jasmine
14 15 (1.12%) TestNG
15 11 (0.82%) Grunt
General
1 431 (32.24%) Finance
2 242 (18.10%) Banking
3 104 (7.78%) Retail
4 87 (6.51%) Retail Banking
5 36 (2.69%) Investment Banking
6 23 (1.72%) Telecoms
7 21 (1.57%) Manufacturing
8 19 (1.42%) Marketing
9 16 (1.20%) Automotive
10 15 (1.12%) Legal
11 14 (1.05%) Games
12 13 (0.97%) Military
13 12 (0.90%) Advertising
14 9 (0.67%) Electronics
15 8 (0.60%) Financial Institution
15 8 (0.60%) Front Office
16 5 (0.37%) Publishing
17 4 (0.30%) Prime Brokerage
18 3 (0.22%) Law
19 2 (0.15%) Dutch Language
Job Titles
1 478 (35.75%) Developer
2 304 (22.74%) Analyst
3 152 (11.37%) Consultant
4 113 (8.45%) Senior Developer
5 110 (8.23%) SQL Developer
6 98 (7.33%) Java Developer
7 94 (7.03%) SQL Analyst
8 91 (6.81%) Business Analyst
9 86 (6.43%) .NET Developer
10 80 (5.98%) Data Analyst
11 74 (5.53%) Senior Analyst
12 73 (5.46%) C# Developer
13 65 (4.86%) Software Developer
14 62 (4.64%) Software Engineer
15 60 (4.49%) Support Analyst
16 57 (4.26%) SAS Consultant
17 55 (4.11%) DBA
18 51 (3.81%) Technical Analyst
19 48 (3.59%) Technical Business Analyst
20 45 (3.37%) C# .NET Developer
Libraries, Frameworks & Software Standards
1 282 (21.09%) .NET
2 176 (13.16%) HTML
3 149 (11.14%) CSS
4 110 (8.23%) XML
5 98 (7.33%) Spring
6 93 (6.96%) ASP.NET
7 88 (6.58%) Web Services
8 69 (5.16%) Hibernate
9 68 (5.09%) AngularJS
10 67 (5.01%) ASP.NET MVC
11 65 (4.86%) RESTful
11 65 (4.86%) SOAP
12 62 (4.64%) HTML5
13 61 (4.56%) jQuery
14 45 (3.37%) JSON
15 39 (2.92%) J2EE
16 38 (2.84%) CSS3
17 35 (2.62%) REST
18 30 (2.24%) .NET Framework
19 27 (2.02%) JMS
Miscellaneous
1 213 (15.93%) Analytical Skills
2 73 (5.46%) Computer Science
3 32 (2.39%) Enterprise Software
3 32 (2.39%) User Experience
4 27 (2.02%) Greenfield Project
5 26 (1.94%) Algorithms
6 22 (1.65%) Management Information System
7 21 (1.57%) Virtual Team
8 20 (1.50%) Robotics
9 18 (1.35%) Data Structures
10 17 (1.27%) Data Centre
11 16 (1.20%) Mobile App
12 14 (1.05%) EMC VNX
13 13 (0.97%) Fintech
14 11 (0.82%) Credit Risk
14 11 (0.82%) Driving Licence
15 9 (0.67%) Mainframe
16 7 (0.52%) Clustering
16 7 (0.52%) Tandem
17 6 (0.45%) Replication
Operating Systems
1 134 (10.02%) Windows
2 116 (8.68%) Linux
3 90 (6.73%) Unix
4 56 (4.19%) Windows Server
5 33 (2.47%) Windows Server 2008
6 29 (2.17%) Windows Server 2012
7 16 (1.20%) Apple iOS
8 14 (1.05%) Windows Server 2003
9 10 (0.75%) Windows 7
10 9 (0.67%) Android
11 8 (0.60%) AIX
12 7 (0.52%) Mac OS
12 7 (0.52%) Ubuntu
13 5 (0.37%) Red Hat Enterprise Linux
13 5 (0.37%) Windows Phone
14 4 (0.30%) Solaris
14 4 (0.30%) Windows 2000
15 3 (0.22%) Windows 10
15 3 (0.22%) Windows XP
16 2 (0.15%) Windows 8
Processes & Methodologies
1 435 (32.54%) Agile Software Development
2 282 (21.09%) Business Intelligence
3 201 (15.03%) Stakeholder Management
4 168 (12.57%) Infrastructure Management
5 145 (10.85%) TDD
6 142 (10.62%) Analytics
7 136 (10.17%) SDLC
8 135 (10.10%) Mentoring
9 128 (9.57%) MVC
10 127 (9.50%) Data Management
11 121 (9.05%) Test Automation
12 119 (8.90%) Scrum
13 116 (8.68%) Software Engineering
14 100 (7.48%) ETL
15 99 (7.40%) OO
16 83 (6.21%) Data Analysis
17 80 (5.98%) ITIL
17 80 (5.98%) Unit Testing
18 79 (5.91%) Data Modelling
19 67 (5.01%) Continuous Integration
Programming Languages
1 332 (24.83%) Java
2 299 (22.36%) C#
3 201 (15.03%) JavaScript
4 179 (13.39%) PL/SQL
5 145 (10.85%) Python
6 113 (8.45%) T-SQL
7 72 (5.39%) PowerShell
8 50 (3.74%) C++
9 44 (3.29%) SAS Macro
10 43 (3.22%) PROC SQL
11 34 (2.54%) R
12 31 (2.32%) PHP
13 29 (2.17%) Shell Script
14 28 (2.09%) VB
14 28 (2.09%) VB.NET
15 24 (1.80%) Scala
16 22 (1.65%) Perl
17 21 (1.57%) C
18 19 (1.42%) Ruby
19 16 (1.20%) VBA
Qualifications
1 177 (13.24%) Degree
2 40 (2.99%) Microsoft Certification
3 37 (2.77%) Security Cleared
4 30 (2.24%) Numerate Degree
5 14 (1.05%) MCAD
5 14 (1.05%) MCSD
5 14 (1.05%) MCTS
6 11 (0.82%) Computer Science Degree
6 11 (0.82%) ISEB
7 9 (0.67%) MCP
8 8 (0.60%) ISTQB
8 8 (0.60%) MCDBA
8 8 (0.60%) MCITP
9 7 (0.52%) SC Cleared
10 6 (0.45%) OCP
10 6 (0.45%) Oracle Certification
10 6 (0.45%) PhD
10 6 (0.45%) PMI Certification
10 6 (0.45%) SAP Certification
11 4 (0.30%) HND
Quality Assurance & Compliance
1 44 (3.29%) QA
2 22 (1.65%) SLA
3 18 (1.35%) Data Quality
4 9 (0.67%) ISO/IEC 27001
5 4 (0.30%) ISO 9001
5 4 (0.30%) PMO
6 3 (0.22%) MiFID
7 2 (0.15%) Disclosure Scotland
7 2 (0.15%) Dodd-Frank
7 2 (0.15%) EMIR
7 2 (0.15%) ISO 20022
7 2 (0.15%) Sarbanes-Oxley
8 1 (0.075%) GDPR
8 1 (0.075%) IFRS
8 1 (0.075%) IFRS 9
System Software
1 57 (4.26%) Active Directory
2 33 (2.47%) VMware Infrastructure
3 22 (1.65%) vSphere
4 21 (1.57%) Hyper-V
5 18 (1.35%) VMware ESXi
6 11 (0.82%) Firmware
7 9 (0.67%) Docker
8 7 (0.52%) Microsoft App-V
9 6 (0.45%) XenApp
10 5 (0.37%) Oracle RAC
11 4 (0.30%) XenDesktop
12 1 (0.075%) DFS Replication
12 1 (0.075%) HDFS
12 1 (0.075%) LXC
Systems Management
1 26 (1.94%) SCCM
2 22 (1.65%) Opscode Chef
3 15 (1.12%) SCOM
4 10 (0.75%) Oracle RMAN
5 9 (0.67%) Data Guard
5 9 (0.67%) Nagios
6 7 (0.52%) Ansible
6 7 (0.52%) Puppet
6 7 (0.52%) Systems Management Server (SMS)
7 5 (0.37%) Ambari
8 4 (0.30%) Backup Exec
8 4 (0.30%) Host Intrusion Detection System
8 4 (0.30%) Malwarebytes
8 4 (0.30%) Network Intrusion Detection System
8 4 (0.30%) Norton AntiVirus
8 4 (0.30%) Perfmon
8 4 (0.30%) Symantec Endpoint Protection
8 4 (0.30%) Symantec Enterprise Vault
8 4 (0.30%) ZABBIX
9 3 (0.22%) Enterprise Manager Cloud Control
Vendors
1 354 (26.48%) Oracle
2 235 (17.58%) Microsoft
3 89 (6.66%) Teradata
4 57 (4.26%) Cognos
5 55 (4.11%) Informatica
6 52 (3.89%) VMware
7 44 (3.29%) MicroStrategy
8 40 (2.99%) IBM
9 39 (2.92%) Tableau
10 31 (2.32%) Cisco
11 27 (2.02%) HP
12 22 (1.65%) SAP
13 16 (1.20%) EMC
14 13 (0.97%) Cognizant
14 13 (0.97%) Sybase
14 13 (0.97%) TIBCO
15 12 (0.90%) Citrix
16 9 (0.67%) Reuters
16 9 (0.67%) Splunk
17 8 (0.60%) F5