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

SQL (Structured Query Language)
UK > Scotland
6 months to
22 Aug 2017
Same period 2016 Same period 2015
Rank 4 4 5
Rank change year-on-year 0 +1 -1
Permanent jobs citing SQL 1262 1062 1279
As % of all permanent IT jobs advertised in Scotland 23.47% 18.72% 20.39%
As % of the Programming Languages category 36.80% 36.26% 40.30%
Number of salaries quoted 652 585 782
Scotland median annual salary £40,000 £41,500 £42,500
Median salary % change year-on-year -3.61% -2.35% +6.25%
10th Percentile £27,500 £27,200 £28,750
90th Percentile £65,000 £61,250 £61,250
UK median annual salary £45,000 £45,000 £44,000
% change year-on-year - +2.27% +3.53%

SQL is in the programming language skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for programming language skills.

Programming Language Skills
Scotland
Permanent job vacancies with a requirement for programming language skills 3429 2929 3174
As % of all permanent IT job vacancies advertised in Scotland 63.78% 51.62% 50.60%
Number of salaries quoted 2088 1678 1986
Scotland median annual salary £42,500 £42,500 £41,000
Median salary % change year-on-year - +3.66% +2.50%
10th Percentile £28,750 £27,925 £27,500
90th Percentile £67,500 £60,475 £60,000
UK median annual salary £47,500 £47,500 £45,000
% change year-on-year - +5.56% +3.45%

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 22 August 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 22 August 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 599 £40,000 -11.11% 33
Glasgow 0 509 £42,500 +6.25% 42
West Lothian -2 38 £30,000 -14.29% 2
Stirling +27 17 £45,000 +36.36% 3
Aberdeen +4 16 £40,000 -11.60% 2
Fife +4 15 £39,137 +32.67% 2
Dundee +1 12 £39,000 +17.73% 2
South Lanarkshire -2 5 £41,500 +14.48% 3
Lothian - 5 £43,000 -
Renfrewshire -2 4 £34,450 +14.83%
Inverclyde - 4 £45,000 -
North Lanarkshire +7 3 £40,000 +6.67% 1
Scottish Borders +1 2 £27,750 -20.71%
Midlothian +1 2 £26,500 -26.39%
Aberdeenshire - 1 £40,000 -
Perth and Kinross - 1 £60,000 -
Strathclyde - 1 - -
SQL
UK

For the 6 months to 22 August 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 427 (33.84%) Agile Software Development
2 386 (30.59%) Finance
3 345 (27.34%) Oracle
4 333 (26.39%) Java
5 313 (24.80%) SQL Server
6 303 (24.01%) C#
7 279 (22.11%) .NET
8 232 (18.38%) Business Intelligence
9 227 (17.99%) Analytical Skills
10 224 (17.75%) Banking
11 212 (16.80%) Microsoft
12 197 (15.61%) JavaScript
13 193 (15.29%) Relational Database
14 183 (14.50%) PL/SQL
15 169 (13.39%) HTML
16 166 (13.15%) Degree
17 162 (12.84%) Stakeholder Management
18 158 (12.52%) CSS
19 156 (12.36%) Python
20 155 (12.28%) Infrastructure Management
21 147 (11.65%) MVC
22 144 (11.41%) Analytics
23 141 (11.17%) SDLC
24 137 (10.86%) SAS
25 136 (10.78%) Linux
25 136 (10.78%) TDD
26 126 (9.98%) Software Engineering
26 126 (9.98%) Scrum
26 126 (9.98%) Mentoring
27 125 (9.90%) XML

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 137 (10.86%) SAS
2 49 (3.88%) Tomcat
3 43 (3.41%) IIS
4 40 (3.17%) SharePoint
5 26 (2.06%) MS Exchange
6 24 (1.90%) JBoss
7 21 (1.66%) WebLogic
8 19 (1.51%) Apache
9 16 (1.27%) Exchange Server 2010
10 15 (1.19%) WebSphere
11 14 (1.11%) CMS
12 11 (0.87%) Skype for Business
13 9 (0.71%) Apache Spark
13 9 (0.71%) Confluence
13 9 (0.71%) Oracle SOA Suite
13 9 (0.71%) SharePoint 2013
14 7 (0.55%) Blackberry Enterprise Server
15 5 (0.40%) Apache Pig
15 5 (0.40%) Exchange Server 2013
15 5 (0.40%) WebLogic Portal
Applications
1 58 (4.60%) Microsoft Excel
2 29 (2.30%) Microsoft Office
3 9 (0.71%) Photoshop
4 8 (0.63%) Adobe Illustrator
5 6 (0.48%) Microsoft Project
5 6 (0.48%) MS Visio
5 6 (0.48%) SPSS
6 2 (0.16%) Mingle
7 1 (0.079%) EngageOne
7 1 (0.079%) Microsoft PowerPoint
Business Applications
1 20 (1.58%) Oracle EBS
2 16 (1.27%) Dynamics CRM
3 14 (1.11%) Oracle EBS R12
4 12 (0.95%) Cognos Business Intelligence
5 10 (0.79%) Oracle HRMS
5 10 (0.79%) Oracle Payroll
6 8 (0.63%) Oracle 11i
7 6 (0.48%) SAP GRC
7 6 (0.48%) Sonata
8 4 (0.32%) Dynamics NAV
8 4 (0.32%) Oracle Financials
8 4 (0.32%) Oracle Procure-to-Pay
9 3 (0.24%) Cognos TM1
9 3 (0.24%) Oracle Applications
10 2 (0.16%) Dynamics AX
10 2 (0.16%) Infor M3
10 2 (0.16%) JDE EnterpriseOne
10 2 (0.16%) NetSuite
11 1 (0.079%) Eloqua
11 1 (0.079%) Markit EDM
Cloud Services
1 107 (8.48%) Microsoft Azure
2 48 (3.80%) Amazon AWS
3 32 (2.54%) Office 365
4 20 (1.58%) Cloud Computing
5 16 (1.27%) GitHub
6 13 (1.03%) SaaS
7 10 (0.79%) Azure Active Directory
8 9 (0.71%) Google Cloud Platform
9 3 (0.24%) Slack
9 3 (0.24%) Trello
10 2 (0.16%) Amazon EC2
10 2 (0.16%) Amazon S3
10 2 (0.16%) Dynamics 365
10 2 (0.16%) Google Analytics
10 2 (0.16%) iPaaS
10 2 (0.16%) PaaS
10 2 (0.16%) Yammer
11 1 (0.079%) Amazon EMR
11 1 (0.079%) CloudFront
11 1 (0.079%) Oracle Service Cloud
Communications & Networking
1 19 (1.51%) DNS
2 16 (1.27%) TCP/IP
3 14 (1.11%) DHCP
3 14 (1.11%) LAN
3 14 (1.11%) WAN
4 13 (1.03%) Firewall
4 13 (1.03%) SAN
5 8 (0.63%) Internet
5 8 (0.63%) Intranet
5 8 (0.63%) Network Security
6 6 (0.48%) SSL
7 5 (0.40%) LDAP
8 4 (0.32%) HTTP
8 4 (0.32%) SMTP
8 4 (0.32%) SSH
8 4 (0.32%) VLAN
9 3 (0.24%) ATM
9 3 (0.24%) Kerberos
9 3 (0.24%) VPN
10 2 (0.16%) SMS
Database & Business Intelligence
1 313 (24.80%) SQL Server
2 193 (15.29%) Relational Database
3 123 (9.75%) Data Warehouse
4 120 (9.51%) SQL Server Integration Services
5 106 (8.40%) RDBMS
5 106 (8.40%) SQL Server Reporting Services
6 91 (7.21%) Oracle Database
7 66 (5.23%) Big Data
8 56 (4.44%) SQL Server 2012
9 50 (3.96%) Base SAS
10 49 (3.88%) SAS Enterprise Guide
11 48 (3.80%) SAS Data Integration Studio
12 43 (3.41%) DB2
13 41 (3.25%) NoSQL
14 40 (3.17%) Oracle Database 10g
15 39 (3.09%) Data Mining
15 39 (3.09%) QlikView
16 38 (3.01%) SAS Visual Analytics
17 35 (2.77%) Oracle Database 11g
17 35 (2.77%) SQL Server 2014
Development Applications
1 90 (7.13%) Git (software)
2 76 (6.02%) JUnit
3 74 (5.86%) Selenium
4 50 (3.96%) JIRA
5 47 (3.72%) Jenkins
6 37 (2.93%) Maven
6 37 (2.93%) ProC
7 33 (2.61%) Team Foundation Server
8 32 (2.54%) Subversion
9 30 (2.38%) Cucumber
9 30 (2.38%) Visual Studio
10 22 (1.74%) Oracle Forms
11 21 (1.66%) TeamCity
12 18 (1.43%) Oracle APEX
12 18 (1.43%) Protractor
13 16 (1.27%) Ant
13 16 (1.27%) Jasmine
14 15 (1.19%) TestNG
15 13 (1.03%) Moq
15 13 (1.03%) NUnit
General
1 386 (30.59%) Finance
2 224 (17.75%) Banking
3 81 (6.42%) Retail
4 62 (4.91%) Retail Banking
5 44 (3.49%) Investment Banking
6 25 (1.98%) Automotive
7 17 (1.35%) Telecoms
8 13 (1.03%) Military
9 12 (0.95%) Legal
9 12 (0.95%) Marketing
10 11 (0.87%) Manufacturing
11 10 (0.79%) Front Office
11 10 (0.79%) Games
12 7 (0.55%) Financial Institution
13 6 (0.48%) Advertising
14 4 (0.32%) Prime Brokerage
15 3 (0.24%) Electronics
16 2 (0.16%) Back Office
16 2 (0.16%) Law
17 1 (0.079%) Publishing
Job Titles
1 516 (40.89%) Developer
2 242 (19.18%) Analyst
3 139 (11.01%) Senior Developer
4 134 (10.62%) Consultant
5 115 (9.11%) SQL Developer
6 111 (8.80%) Java Developer
7 93 (7.37%) .NET Developer
8 82 (6.50%) C# Developer
9 71 (5.63%) SQL Analyst
10 64 (5.07%) Software Developer
11 62 (4.91%) Senior Analyst
12 61 (4.83%) Business Analyst
13 57 (4.52%) SAS Consultant
14 56 (4.44%) Data Analyst
15 54 (4.28%) Software Engineer
16 52 (4.12%) Senior Java Developer
17 50 (3.96%) DBA
18 48 (3.80%) Technical Analyst
19 45 (3.57%) Oracle Developer
19 45 (3.57%) Technical Business Analyst
Libraries, Frameworks & Software Standards
1 279 (22.11%) .NET
2 169 (13.39%) HTML
3 158 (12.52%) CSS
4 125 (9.90%) XML
5 108 (8.56%) ASP.NET
5 108 (8.56%) Spring
6 93 (7.37%) Web Services
7 79 (6.26%) SOAP
8 76 (6.02%) jQuery
9 72 (5.71%) ASP.NET MVC
10 69 (5.47%) AngularJS
11 67 (5.31%) HTML5
12 65 (5.15%) Hibernate
12 65 (5.15%) RESTful
13 57 (4.52%) JSON
14 43 (3.41%) CSS3
15 34 (2.69%) JMS
15 34 (2.69%) REST
16 33 (2.61%) WCF
17 32 (2.54%) Entity Framework
Miscellaneous
1 227 (17.99%) Analytical Skills
2 80 (6.34%) Computer Science
3 42 (3.33%) Enterprise Software
4 34 (2.69%) Greenfield Project
5 27 (2.14%) User Experience
6 24 (1.90%) Management Information System
7 20 (1.58%) Algorithms
8 19 (1.51%) Data Centre
9 18 (1.43%) Data Structures
9 18 (1.43%) Fintech
10 17 (1.35%) Credit Risk
10 17 (1.35%) Virtual Team
11 15 (1.19%) Mainframe
12 13 (1.03%) Mobile App
13 10 (0.79%) EMC VNX
14 9 (0.71%) Hedge funds
15 8 (0.63%) Blackberry
15 8 (0.63%) Derivative
15 8 (0.63%) Fixed Income
15 8 (0.63%) Tandem
Operating Systems
1 136 (10.78%) Linux
2 119 (9.43%) Unix
3 105 (8.32%) Windows
4 37 (2.93%) Windows Server
5 27 (2.14%) Windows Server 2008
6 23 (1.82%) Windows Server 2012
7 19 (1.51%) Apple iOS
8 15 (1.19%) AIX
9 13 (1.03%) Android
10 10 (0.79%) Ubuntu
11 7 (0.55%) Windows Server 2003
12 6 (0.48%) Mac OS
12 6 (0.48%) zOS
13 5 (0.40%) Solaris
13 5 (0.40%) Windows 2000
14 4 (0.32%) Red Hat Enterprise Linux
15 3 (0.24%) Debian
15 3 (0.24%) Windows 7
16 2 (0.16%) CentOS
17 1 (0.079%) Windows 8
Processes & Methodologies
1 427 (33.84%) Agile Software Development
2 232 (18.38%) Business Intelligence
3 162 (12.84%) Stakeholder Management
4 155 (12.28%) Infrastructure Management
5 147 (11.65%) MVC
6 144 (11.41%) Analytics
7 141 (11.17%) SDLC
8 136 (10.78%) TDD
9 126 (9.98%) Mentoring
9 126 (9.98%) Scrum
9 126 (9.98%) Software Engineering
10 124 (9.83%) OO
11 119 (9.43%) Test Automation
12 102 (8.08%) ETL
13 93 (7.37%) Data Management
14 88 (6.97%) Unit Testing
15 71 (5.63%) Data Analysis
16 68 (5.39%) Continuous Integration
17 62 (4.91%) ITIL
17 62 (4.91%) People Management
Programming Languages
1 333 (26.39%) Java
2 303 (24.01%) C#
3 197 (15.61%) JavaScript
4 183 (14.50%) PL/SQL
5 156 (12.36%) Python
6 117 (9.27%) T-SQL
7 60 (4.75%) PowerShell
8 49 (3.88%) C++
9 43 (3.41%) Shell Script
10 40 (3.17%) Scala
11 39 (3.09%) Perl
11 39 (3.09%) R
11 39 (3.09%) VB
12 38 (3.01%) SAS Macro
13 37 (2.93%) PROC SQL
14 33 (2.61%) VB.NET
15 32 (2.54%) PHP
16 22 (1.74%) VBA
17 20 (1.58%) Ruby
18 19 (1.51%) C
Qualifications
1 166 (13.15%) Degree
2 32 (2.54%) Security Cleared
3 28 (2.22%) Microsoft Certification
4 23 (1.82%) Numerate Degree
5 22 (1.74%) Computer Science Degree
6 15 (1.19%) ISTQB
7 14 (1.11%) ISEB
8 13 (1.03%) MCP
9 10 (0.79%) OCP
9 10 (0.79%) Oracle Certification
9 10 (0.79%) SAP Certification
10 7 (0.55%) PhD
10 7 (0.55%) PMI Certification
11 6 (0.48%) MCAD
11 6 (0.48%) MCSD
11 6 (0.48%) MCTS
12 5 (0.40%) HND
12 5 (0.40%) SC Cleared
13 3 (0.24%) AWS Certification
13 3 (0.24%) MCSE
Quality Assurance & Compliance
1 46 (3.65%) QA
2 26 (2.06%) SLA
3 25 (1.98%) Data Quality
4 9 (0.71%) MiFID
5 7 (0.55%) ISO/IEC 27001
6 6 (0.48%) Dodd-Frank
6 6 (0.48%) EMIR
7 4 (0.32%) Basel III
8 2 (0.16%) Disclosure Scotland
8 2 (0.16%) ISO 20022
8 2 (0.16%) ISO 9001
8 2 (0.16%) PMO
9 1 (0.079%) GDPR
9 1 (0.079%) IFRS
9 1 (0.079%) IFRS 9
System Software
1 56 (4.44%) Active Directory
2 28 (2.22%) VMware Infrastructure
3 17 (1.35%) VMware ESXi
4 16 (1.27%) Hyper-V
5 13 (1.03%) Oracle RAC
6 12 (0.95%) Docker
7 11 (0.87%) vSphere
8 8 (0.63%) Microsoft App-V
8 8 (0.63%) XenApp
9 7 (0.55%) XenDesktop
10 4 (0.32%) Firmware
11 2 (0.16%) HDFS
11 2 (0.16%) Job Entry Subsystem
11 2 (0.16%) RACF
11 2 (0.16%) Time Sharing Option
11 2 (0.16%) Virtual Machines
12 1 (0.079%) KVM
12 1 (0.079%) LXC
12 1 (0.079%) NFS
12 1 (0.079%) Samba
Systems Management
1 20 (1.58%) Opscode Chef
2 19 (1.51%) SCCM
3 18 (1.43%) Oracle RMAN
4 17 (1.35%) Data Guard
5 13 (1.03%) Puppet
6 12 (0.95%) SCOM
7 9 (0.71%) Ansible
8 8 (0.63%) Nagios
9 7 (0.55%) Symantec Endpoint Protection
9 7 (0.55%) Symantec Enterprise Vault
10 5 (0.40%) Ambari
11 3 (0.24%) Enterprise Manager Cloud Control
11 3 (0.24%) ZABBIX
12 2 (0.16%) Failover Clustering
12 2 (0.16%) Grafana
12 2 (0.16%) HockeyApp
12 2 (0.16%) HP Quality Center
12 2 (0.16%) Terraform
12 2 (0.16%) zSecure
13 1 (0.079%) Capistrano
Vendors
1 345 (27.34%) Oracle
2 212 (16.80%) Microsoft
3 70 (5.55%) Teradata
4 54 (4.28%) Cognos
5 51 (4.04%) IBM
6 48 (3.80%) MicroStrategy
7 45 (3.57%) Informatica
8 43 (3.41%) VMware
9 36 (2.85%) Tableau
10 26 (2.06%) Sybase
11 24 (1.90%) Cisco
11 24 (1.90%) HP
12 21 (1.66%) SAP
13 18 (1.43%) Perforce
14 17 (1.35%) Cognizant
15 13 (1.03%) CA
15 13 (1.03%) Splunk
16 12 (0.95%) Citrix
16 12 (0.95%) EMC
17 9 (0.71%) Adobe