Period
to 19 December 2018

The median contractor rate for a SQL Analyst was £371 per day in advertised job vacancies in Edinburgh during the 6 months to 19 December 2018.

The first table below provides contractor rate benchmarking and summary statistics including a comparison to 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 Analyst
Scotland > Edinburgh
6 months to
19 Dec 2018
Same period 2017 Same period 2016
Rank 125 132 108
Rank change year-on-year +7 -24 +17
Contract jobs requiring a SQL Analyst 10 11 6
As % of all contract IT jobs advertised in Edinburgh 0.36% 0.37% 0.31%
As % of the Job Titles category 0.37% 0.39% 0.32%
Number of daily rates quoted 6 9 3
Edinburgh median daily rate £371 £388 £325
Median daily rate % change year-on-year -4.19% +19.23% -7.14%
10th Percentile £191 £334 £157
90th Percentile £444 £455 £348
Scotland median daily rate £310 £388 £275
% change year-on-year -20.00% +41.17% -17.13%
Number of hourly rates quoted 0 0 0
Edinburgh median hourly rate - - -
Scotland median hourly rate - - £28.66

The following table is for comparison with the above and includes summary statistics for all contract IT job vacancies advertised in Edinburgh. Most job vacancies include a discernible job title that can be normalized. As such, the figures in the second row provide an indication of the number of contract jobs in our overall sample.

All Contract IT Job Vacancies
Edinburgh
Contract vacancies in Edinburgh with a recognized job title 2,678 2,850 1,886
% of contract IT jobs with a recognized job title 95.13% 95.96% 96.42%
Number of daily rates quoted 1,364 1,675 1,126
Edinburgh median daily rate £425 £400 £400
Median daily rate % change year-on-year +6.25% - +3.23%
10th Percentile £263 £263 £250
90th Percentile £575 £550 £525
Scotland median daily rate £400 £388 £363
% change year-on-year +3.23% +6.90% -2.03%
Number of hourly rates quoted 39 23 34
Edinburgh median hourly rate £17.50 £16.86 £22.50
Median hourly rate % change year-on-year +3.80% -25.07% +18.30%
10th Percentile £11.09 £10.53 £13.43
90th Percentile £44.93 £35.00 £52.00
Scotland median hourly rate £19.00 £20.00 £17.32
% change year-on-year -5.00% +15.47% -13.40%

SQL Analyst
Job Vacancy Trend in Edinburgh

Job postings that featured SQL Analyst in the job title as a percentage of all IT jobs advertised in Edinburgh.

Job vacancy trend for SQL Analyst in Edinburgh

SQL Analyst
Contractor Daily Rate Trend in Edinburgh

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

Contractor daily rate trend for SQL Analyst in Edinburgh

SQL Analyst
Contractor Daily Rate Histogram in Edinburgh

The daily rate distribution of IT jobs citing SQL Analyst in Edinburgh over the 6 months to 19 December 2018.

Contractor daily rate histogram for SQL Analyst in Edinburgh

SQL Analyst
Contractor Hourly Rate Trend in Edinburgh

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

Contractor hourly rate trend for SQL Analyst in Edinburgh

SQL Analyst Skill Set
Top 30 Co-occurring IT Skills in Edinburgh

For the 6 months to 19 December 2018, SQL Analyst contract jobs required the following IT skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all contract job ads across the Edinburgh region featuring SQL Analyst in the job title.

1 8 (80.00%) SQL
2 7 (70.00%) SQL Server
3 4 (40.00%) Finance
4 3 (30.00%) Business Analysis
4 3 (30.00%) Banking
5 2 (20.00%) Credit Risk
5 2 (20.00%) Test Automation
5 2 (20.00%) Data Management
5 2 (20.00%) PL/SQL
5 2 (20.00%) Data Warehouse
5 2 (20.00%) T-SQL
5 2 (20.00%) ETL
5 2 (20.00%) SAS
6 1 (10.00%) TCP/IP
6 1 (10.00%) IBM
6 1 (10.00%) Microsoft
6 1 (10.00%) Active Directory
6 1 (10.00%) BMC
6 1 (10.00%) DataStage
6 1 (10.00%) Control-M
6 1 (10.00%) ERwin
6 1 (10.00%) VBA
6 1 (10.00%) Oracle
6 1 (10.00%) DB2
6 1 (10.00%) XML
6 1 (10.00%) Windows
6 1 (10.00%) Microsoft Excel
6 1 (10.00%) Data Modelling
6 1 (10.00%) Data Mining
6 1 (10.00%) C

SQL Analyst Skill Set
Co-occurring IT Skills in Edinburgh 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 2 (20.00%) SAS
Applications
1 1 (10.00%) Microsoft Excel
Communications & Networking
1 1 (10.00%) TCP/IP
Database & Business Intelligence
1 7 (70.00%) SQL Server
2 2 (20.00%) Data Warehouse
3 1 (10.00%) Data Mining
3 1 (10.00%) DataStage
3 1 (10.00%) DB2
3 1 (10.00%) Relational Database
3 1 (10.00%) SQL Server 2008
3 1 (10.00%) SQL Server 2012
3 1 (10.00%) SQL Server 2014
Development Applications
1 1 (10.00%) ER Studio
1 1 (10.00%) ERwin
General
1 4 (40.00%) Finance
2 3 (30.00%) Banking
3 1 (10.00%) Corporate Banking
3 1 (10.00%) Retail
3 1 (10.00%) Retail Banking
Libraries, Frameworks & Software Standards
1 1 (10.00%) XML
Miscellaneous
1 2 (20.00%) Credit Risk
2 1 (10.00%) Analytical Skills
2 1 (10.00%) Data Structures
Operating Systems
1 1 (10.00%) Windows
1 1 (10.00%) Windows 7
1 1 (10.00%) Windows Server
Processes & Methodologies
1 3 (30.00%) Business Analysis
2 2 (20.00%) Data Management
2 2 (20.00%) ETL
2 2 (20.00%) Test Automation
3 1 (10.00%) Agile Software Development
3 1 (10.00%) BDD
3 1 (10.00%) Data Analysis
3 1 (10.00%) Data Modelling
3 1 (10.00%) Data Validation
3 1 (10.00%) Exploratory Testing
3 1 (10.00%) Incident Management
3 1 (10.00%) Regression Testing
3 1 (10.00%) Risk Analysis
3 1 (10.00%) Stakeholder Engagement
3 1 (10.00%) Stakeholder Management
3 1 (10.00%) TDD
3 1 (10.00%) Test Scripting
3 1 (10.00%) User Acceptance Testing
3 1 (10.00%) User Stories
3 1 (10.00%) Validation
Programming Languages
1 8 (80.00%) SQL
2 2 (20.00%) PL/SQL
2 2 (20.00%) T-SQL
3 1 (10.00%) C
3 1 (10.00%) PowerShell
3 1 (10.00%) VBA
Quality Assurance & Compliance
1 1 (10.00%) GDPR
1 1 (10.00%) QA
System Software
1 1 (10.00%) Active Directory
1 1 (10.00%) VMware Infrastructure
Systems Management
1 1 (10.00%) Control-M
Vendors
1 1 (10.00%) BMC
1 1 (10.00%) IBM
1 1 (10.00%) Microsoft
1 1 (10.00%) Oracle
1 1 (10.00%) VMware