Period
to 20 November 2017

The following table provides summary statistics for contract job vacancies advertised in Scotland with a requirement for SQL skills. Included is a benchmarking guide to the contractor rates offered in vacancies that have cited SQL over the 6 months to 20 November 2017 with a comparison to the same period in the previous 2 years.

Note that daily and hourly rates are treated separately in these statistics. When calculating contractor rate percentiles, daily rates are never derived from quoted hourly rates or vice versa.

SQL (Structured Query Language)
UK > Scotland
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 7 6 5
Rank change year-on-year -1 -1 0
Contract jobs citing SQL 684 640 879
As % of all contract IT jobs advertised in Scotland 13.75% 14.90% 14.18%
As % of the Programming Languages category 35.83% 36.89% 45.78%
Number of daily rates quoted 384 437 502
Scotland median daily rate £380 £340 £350
Median daily rate % change year-on-year +11.76% -2.86% -1.06%
10th Percentile £291 £260 £263
90th Percentile £488 £461 £513
UK median daily rate £425 £400 £393
% change year-on-year +6.25% +1.91% +4.67%
Number of hourly rates quoted 16 15 14
Scotland median hourly rate £24.00 £40.00 £40.00
Median hourly rate % change year-on-year -40.00% - +128.57%
10th Percentile £15.06 £14.85 £15.53
90th Percentile £195.00 £48.38 £44.80
UK median hourly rate £27.00 £28.00 £28.00
% change year-on-year -3.57% - +12.00%

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all contract job vacancies advertised in Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Contract vacancies with a requirement for coding skills 1909 1735 1920
As % of all contract IT jobs advertised in Scotland 38.36% 40.39% 30.98%
Number of daily rates quoted 1146 1050 1043
Scotland median daily rate £388 £350 £350
Median daily rate % change year-on-year +10.71% - -6.67%
10th Percentile £283 £263 £260
90th Percentile £525 £475 £500
UK median daily rate £450 £425 £400
% change year-on-year +5.88% +6.25% -
Number of hourly rates quoted 28 31 45
Scotland median hourly rate £27.00 £40.00 £37.50
Median hourly rate % change year-on-year -32.50% +6.67% +7.14%
10th Percentile £15.09 £14.85 £14.48
90th Percentile £195.00 £52.00 £55.00
UK median hourly rate £40.00 £37.50 £37.50
% change year-on-year +6.67% - +21.95%

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
Contractor Daily Rate Trend in Scotland

This chart provides the 3-month moving average for daily rates quoted in contract jobs citing SQL in Scotland.

Contractor daily rate trend for SQL in Scotland

SQL
Contractor Daily Rate Histogram in Scotland

The daily rate distribution of IT jobs citing SQL in Scotland over the 6 months to 20 November 2017.

Contractor daily rate histogram for SQL in Scotland

SQL
Contractor Hourly Rate Trend in Scotland

This chart provides the 3-month moving average for contractor hourly rates quoted in IT jobs citing SQL in Scotland.

Contractor hourly rate trend for SQL in Scotland

SQL
Contractor Hourly Rate Histogram in Scotland

The hourly rate distribution of IT jobs citing SQL in Scotland over the 6 months to 20 November 2017.

Contractor hourly rate histogram for SQL in Scotland

SQL
Contract Job Locations in Scotland

The table below looks at the demand and provides a guide to the median contractor rates quoted in IT jobs citing SQL within the Scotland region over the 6 months to 20 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
Contract
IT Job Ads
Median
Daily Rate
Past 6 Months
Median Daily Rate
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -1 374 £388 +3.33% 30
Glasgow 0 236 £375 +10.29% 43
Renfrewshire 0 16 £412 +28.75%
Aberdeen -6 9 £378 +139.68% 2
Stirling - 8 £263 -
Fife -3 5 £300 +9.09% 1
West Lothian -17 5 £315 -3.08% 1
Dundee +8 4 £400 +10.34% 1
North Lanarkshire - 4 - - 1
Inverclyde - 3 £325 -
South Lanarkshire -4 2 - -
South Ayrshire +6 1 £225 -
Highlands -8 1 £250 -9.09% 3
East Ayrshire - 1 £350 - 1
Perthshire - 1 - - 1
East Lothian - 1 - -
SQL
UK

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

1 225 (32.89%) Finance
2 224 (32.75%) Agile Software Development
3 193 (28.22%) Java
4 155 (22.66%) Oracle
5 133 (19.44%) SQL Server
6 123 (17.98%) JavaScript
7 110 (16.08%) Linux
8 95 (13.89%) Analytical Skills
9 88 (12.87%) Test Automation
10 87 (12.72%) C#
11 85 (12.43%) PL/SQL
11 85 (12.43%) Windows
12 84 (12.28%) Unix
13 82 (11.99%) Python
14 79 (11.55%) .NET
14 79 (11.55%) Banking
15 77 (11.26%) Relational Database
16 75 (10.96%) HTML
16 75 (10.96%) Microsoft
17 72 (10.53%) Business Intelligence
17 72 (10.53%) Perl
18 71 (10.38%) Spring
19 69 (10.09%) ETL
20 66 (9.65%) XML
20 66 (9.65%) Git (software)
21 64 (9.36%) Data Warehouse
22 62 (9.06%) OO
23 58 (8.48%) T-SQL
23 58 (8.48%) SAS
24 57 (8.33%) Scrum

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 58 (8.48%) SAS
2 29 (4.24%) IIS
3 19 (2.78%) SharePoint
4 16 (2.34%) MQSeries
5 15 (2.19%) CICS
6 14 (2.05%) Tomcat
7 13 (1.90%) Apache
8 12 (1.75%) JBoss
9 11 (1.61%) Oracle SOA Suite
10 9 (1.32%) Confluence
11 4 (0.58%) Apache Spark
11 4 (0.58%) BizTalk Server
11 4 (0.58%) ColdFusion
12 3 (0.44%) CMS
13 2 (0.29%) Apache Solr
13 2 (0.29%) MS Exchange
13 2 (0.29%) WebSphere
13 2 (0.29%) WebSphere Application Server
14 1 (0.15%) Mule
14 1 (0.15%) Skype for Business
Applications
1 30 (4.39%) Microsoft Excel
1 30 (4.39%) Microsoft Office
2 15 (2.19%) Microsoft PowerPoint
3 5 (0.73%) MS Visio
4 4 (0.58%) Microsoft Project
4 4 (0.58%) Spreadsheet
5 2 (0.29%) SPSS
Business Applications
1 15 (2.19%) Markit EDM
2 9 (1.32%) Oracle BPM
3 5 (0.73%) Payment Gateway
4 3 (0.44%) Cognos Business Intelligence
5 2 (0.29%) assyst
5 2 (0.29%) Dynamics CRM
5 2 (0.29%) Oracle Applications
6 1 (0.15%) Cognos TM1
6 1 (0.15%) Dynamics AX
6 1 (0.15%) Infor M3
6 1 (0.15%) Oracle 11i
6 1 (0.15%) Sonata
Cloud Services
1 22 (3.22%) Microsoft Azure
2 18 (2.63%) Amazon AWS
3 6 (0.88%) Office 365
4 5 (0.73%) Google Analytics
4 5 (0.73%) PaaS
5 4 (0.58%) GitHub
5 4 (0.58%) IaaS
6 2 (0.29%) Azure Active Directory
6 2 (0.29%) Cloud Computing
6 2 (0.29%) SaaS
7 1 (0.15%) Azure Data Factory
7 1 (0.15%) npm
7 1 (0.15%) Yammer
Communications & Networking
1 28 (4.09%) SSL
2 17 (2.49%) Firewall
2 17 (2.49%) Kerberos
3 16 (2.34%) HTTP
4 15 (2.19%) SSH
5 13 (1.90%) HTTPS
5 13 (1.90%) Internet
6 10 (1.46%) DNS
7 9 (1.32%) SAN
8 8 (1.17%) DHCP
9 7 (1.02%) TCP/IP
10 4 (0.58%) Skype
11 3 (0.44%) Ethernet
11 3 (0.44%) ISDN
11 3 (0.44%) VoIP
12 2 (0.29%) AMQP
12 2 (0.29%) CTI
12 2 (0.29%) VPN
12 2 (0.29%) VSAN
13 1 (0.15%) NAS
Database & Business Intelligence
1 133 (19.44%) SQL Server
2 77 (11.26%) Relational Database
3 64 (9.36%) Data Warehouse
4 53 (7.75%) RDBMS
5 44 (6.43%) DB2
6 43 (6.29%) NoSQL
6 43 (6.29%) Oracle Database
7 37 (5.41%) SQL Server Integration Services
8 36 (5.26%) SQL Server Reporting Services
9 35 (5.12%) SQL Server Analysis Services
10 27 (3.95%) SQL Server 2012
11 25 (3.65%) Big Data
12 22 (3.22%) MongoDB
12 22 (3.22%) MySQL
12 22 (3.22%) Power BI
13 16 (2.34%) Oracle Reports
14 15 (2.19%) Hadoop
14 15 (2.19%) SQL Server 2008
15 14 (2.05%) Oracle Database 12c
15 14 (2.05%) PowerCenter
Development Applications
1 66 (9.65%) Git (software)
2 45 (6.58%) Maven
3 44 (6.43%) Subversion
4 39 (5.70%) Jenkins
5 28 (4.09%) JIRA
5 28 (4.09%) JUnit
6 26 (3.80%) Mercurial
6 26 (3.80%) Team Foundation Server
7 22 (3.22%) Selenium
8 18 (2.63%) Visual Studio
9 14 (2.05%) Cucumber
10 13 (1.90%) JMeter
10 13 (1.90%) SpecFlow
10 13 (1.90%) TeamCity
11 11 (1.61%) Oracle Forms
12 10 (1.46%) FitNesse
12 10 (1.46%) Hudson
13 9 (1.32%) Ant
14 8 (1.17%) Appium
14 8 (1.17%) JBehave
General
1 225 (32.89%) Finance
2 79 (11.55%) Banking
3 22 (3.22%) Retail Banking
4 11 (1.61%) Investment Banking
4 11 (1.61%) Publishing
5 7 (1.02%) Corporate Banking
6 6 (0.88%) Front Office
6 6 (0.88%) Legal
6 6 (0.88%) Retail
7 5 (0.73%) Law
7 5 (0.73%) Manufacturing
8 4 (0.58%) Telecoms
9 3 (0.44%) Marketing
10 2 (0.29%) Electronics
11 1 (0.15%) Advertising
11 1 (0.15%) Financial Institution
11 1 (0.15%) German Language
11 1 (0.15%) Italian Language
11 1 (0.15%) Private Banking
11 1 (0.15%) Spanish Language
Job Titles
1 300 (43.86%) Developer
2 183 (26.75%) Analyst
3 93 (13.60%) Java Developer
4 57 (8.33%) SQL Developer
5 51 (7.46%) Test Analyst
6 41 (5.99%) Data Analyst
7 40 (5.85%) Consultant
8 31 (4.53%) Business Analyst
8 31 (4.53%) Senior Analyst
9 29 (4.24%) Oracle Developer
10 26 (3.80%) .NET Developer
10 26 (3.80%) Systems Analyst
11 25 (3.65%) Business Intelligence Developer
12 24 (3.51%) Senior Developer
13 22 (3.22%) DBA
14 20 (2.92%) Applications Support
14 20 (2.92%) Senior Test Analyst
15 19 (2.78%) PL/SQL Developer
15 19 (2.78%) Technical Analyst
16 18 (2.63%) Architect
Libraries, Frameworks & Software Standards
1 79 (11.55%) .NET
2 75 (10.96%) HTML
3 71 (10.38%) Spring
4 66 (9.65%) XML
5 55 (8.04%) CSS
6 47 (6.87%) Web Services
7 44 (6.43%) Hibernate
8 35 (5.12%) AngularJS
9 29 (4.24%) RESTful
10 26 (3.80%) ASP.NET
10 26 (3.80%) JSON
11 25 (3.65%) jQuery
12 22 (3.22%) JMS
13 19 (2.78%) HTML5
13 19 (2.78%) SOAP
14 18 (2.63%) Middleware
15 17 (2.49%) Ajax
15 17 (2.49%) React
16 15 (2.19%) ISPF
17 14 (2.05%) J2SE
Miscellaneous
1 95 (13.89%) Analytical Skills
2 37 (5.41%) Data Structures
3 27 (3.95%) Algorithms
4 23 (3.36%) PKI
5 21 (3.07%) Greenfield Project
6 19 (2.78%) Computer Science
7 18 (2.63%) Mainframe
8 17 (2.49%) Enterprise Software
9 13 (1.90%) Credit Risk
10 8 (1.17%) Virtual Team
11 7 (1.02%) User Experience
12 6 (0.88%) Management Information System
13 5 (0.73%) Data Centre
13 5 (0.73%) Equity Derivative
13 5 (0.73%) Mobile App
14 4 (0.58%) Clustering
14 4 (0.58%) Fixed Income
14 4 (0.58%) Market Risk
14 4 (0.58%) SWIFT
15 3 (0.44%) Derivative
Operating Systems
1 110 (16.08%) Linux
2 85 (12.43%) Windows
3 84 (12.28%) Unix
4 43 (6.29%) Windows Server 2012
5 34 (4.97%) Windows Server
6 31 (4.53%) Red Hat Enterprise Linux
7 26 (3.80%) Windows Server 2008
8 20 (2.92%) Windows 7
9 16 (2.34%) Windows 10
10 15 (2.19%) zOS
11 5 (0.73%) Apple iOS
11 5 (0.73%) Solaris
12 3 (0.44%) Windows Server 2003
12 3 (0.44%) Windows XP
13 2 (0.29%) CentOS
13 2 (0.29%) Windows 8
14 1 (0.15%) Android
14 1 (0.15%) Ubuntu
14 1 (0.15%) Windows 2000
14 1 (0.15%) Windows Vista
Processes & Methodologies
1 224 (32.75%) Agile Software Development
2 88 (12.87%) Test Automation
3 72 (10.53%) Business Intelligence
4 69 (10.09%) ETL
5 62 (9.06%) OO
6 57 (8.33%) Scrum
7 49 (7.16%) Continuous Integration
8 47 (6.87%) Data Modelling
9 46 (6.73%) Analytics
9 46 (6.73%) Data Analysis
10 40 (5.85%) BDD
11 34 (4.97%) TDD
11 34 (4.97%) Web Development
12 33 (4.82%) ITIL
12 33 (4.82%) User Acceptance Testing
13 31 (4.53%) Migration
14 29 (4.24%) Asset Management
14 29 (4.24%) SDLC
15 28 (4.09%) Software Engineering
16 27 (3.95%) User Stories
Programming Languages
1 193 (28.22%) Java
2 123 (17.98%) JavaScript
3 87 (12.72%) C#
4 85 (12.43%) PL/SQL
5 82 (11.99%) Python
6 72 (10.53%) Perl
7 58 (8.48%) T-SQL
8 51 (7.46%) PowerShell
9 30 (4.39%) Shell Script
10 21 (3.07%) C++
11 17 (2.49%) REXX
12 16 (2.34%) JCL
12 16 (2.34%) Scala
13 15 (2.19%) Assembly Language
13 15 (2.19%) CLIST
14 14 (2.05%) PHP
14 14 (2.05%) VB
15 12 (1.75%) VB.NET
16 9 (1.32%) Ruby
16 9 (1.32%) VBScript
Qualifications
1 41 (5.99%) Degree
2 28 (4.09%) Security Cleared
3 19 (2.78%) SC Cleared
4 10 (1.46%) ISEB
5 8 (1.17%) Microsoft Certification
6 5 (0.73%) Computer Science Degree
6 5 (0.73%) ISTQB
7 4 (0.58%) Numerate Degree
8 3 (0.44%) DV Cleared
8 3 (0.44%) MCSA
9 2 (0.29%) BPSS Clearance
9 2 (0.29%) CCNA
9 2 (0.29%) CCNP
9 2 (0.29%) CIMA
9 2 (0.29%) Cisco Certification
9 2 (0.29%) HND
9 2 (0.29%) ISTQB Advanced Certification
9 2 (0.29%) MCSD
9 2 (0.29%) MCTS
9 2 (0.29%) VMware Certified Professional (VCP)
Quality Assurance & Compliance
1 21 (3.07%) QA
2 19 (2.78%) Data Quality
3 14 (2.05%) Disclosure Scotland
4 7 (1.02%) EMIR
5 4 (0.58%) ISO/IEC 27001
6 3 (0.44%) GDPR
6 3 (0.44%) SLA
7 2 (0.29%) Dodd-Frank
8 1 (0.15%) Basel II
8 1 (0.15%) ISO 22301
8 1 (0.15%) ISO/IEC 20000
8 1 (0.15%) MiFID
System Software
1 34 (4.97%) Active Directory
2 15 (2.19%) Job Entry Subsystem
2 15 (2.19%) RACF
2 15 (2.19%) Time Sharing Option
3 13 (1.90%) VMware Infrastructure
4 11 (1.61%) Docker
4 11 (1.61%) Microsoft App-V
5 5 (0.73%) Terminal Services
5 5 (0.73%) XenApp
6 4 (0.58%) Virtual Machines
6 4 (0.58%) VMware ESXi
7 3 (0.44%) Apache ZooKeeper
7 3 (0.44%) NFS
8 2 (0.29%) vSphere
9 1 (0.15%) Hyper-V
9 1 (0.15%) OpenAM
9 1 (0.15%) VMware NSX
Systems Management
1 30 (4.39%) SCCM
2 16 (2.34%) Ansible
3 15 (2.19%) zSecure
4 13 (1.90%) WSUS
5 10 (1.46%) IBM BigFix
5 10 (1.46%) Systems Management Server (SMS)
6 9 (1.32%) Opscode Chef
7 8 (1.17%) HP Quality Center
7 8 (1.17%) Puppet
7 8 (1.17%) SCOM
8 6 (0.88%) Netcool
9 4 (0.58%) WMI
10 2 (0.29%) EnCase
10 2 (0.29%) OpenView Configuration Management
11 1 (0.15%) Cobbler
11 1 (0.15%) EMC NetWorker
11 1 (0.15%) Kubernetes
11 1 (0.15%) MAINVIEW
11 1 (0.15%) SolarWinds Orion
11 1 (0.15%) Tivoli
Vendors
1 155 (22.66%) Oracle
2 75 (10.96%) Microsoft
3 45 (6.58%) Sybase
4 32 (4.68%) IBM
5 27 (3.95%) HP
6 21 (3.07%) Red Hat
6 21 (3.07%) Teradata
7 19 (2.78%) VMware
8 16 (2.34%) CA
8 16 (2.34%) Informatica
9 13 (1.90%) Cognos
9 13 (1.90%) Tableau
10 12 (1.75%) Perforce
10 12 (1.75%) Symantec
11 11 (1.61%) SAP
12 9 (1.32%) Dell
13 7 (1.02%) Cisco
13 7 (1.02%) Citrix
13 7 (1.02%) CyberArk
13 7 (1.02%) MicroStrategy