Period
to 21 August 2018

The median annual salary for a Data Analyst was £45,000 in advertised job vacancies in Edinburgh during the 6 months to 21 August 2018.

The first table below provides salary benchmarking and summary statistics including a comparison to same period in the previous 2 years.

Data Analyst
Scotland > Edinburgh
6 months to
21 Aug 2018
Same period 2017 Same period 2016
Rank 127 84 134
Rank change year-on-year -43 +50 -5
Permanent jobs requiring a Data Analyst 24 59 17
As % of all permanent IT jobs advertised in Edinburgh 0.94% 2.33% 0.68%
As % of the Job Titles category 1.00% 2.43% 0.71%
Number of salaries quoted 16 15 10
Edinburgh median annual salary £45,000 £35,000 £40,000
Median salary % change year-on-year +28.57% -12.50% +23.08%
10th Percentile £22,125 £23,250 £26,250
90th Percentile £55,000 £45,000 £45,275
Scotland median annual salary £36,000 £35,000 £31,500
% change year-on-year +2.86% +11.11% -19.23%

The following table is for comparison with the above and includes summary statistics for all permanent 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 permanent jobs in our overall sample.

All Permanent IT Job Vacancies
Edinburgh
Permanent vacancies in Edinburgh with a recognized job title 2,402 2,426 2,382
% of permanent IT jobs with a recognized job title 94.53% 95.78% 95.24%
Number of salaries quoted 1,541 1,455 1,508
Edinburgh median annual salary £45,000 £42,500 £45,000
Median salary % change year-on-year +5.88% -5.56% +2.27%
10th Percentile £28,250 £27,500 £26,250
90th Percentile £74,750 £67,500 £70,000
Scotland median annual salary £45,000 £42,500 £44,000
% change year-on-year +5.88% -3.41% +3.53%

Data Analyst
Job Vacancy Trend in Edinburgh

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

Job vacancy trend for Data Analyst in Edinburgh

Data Analyst
Salary Trend in Edinburgh

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing Data Analyst in Edinburgh.

Salary trend for Data Analyst in Edinburgh

Data Analyst
Salary Histogram in Edinburgh

The salary distribution of IT jobs citing Data Analyst in Edinburgh over the 6 months to 21 August 2018.

Salary histogram for Data Analyst in Edinburgh

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

For the 6 months to 21 August 2018, Data Analyst job roles required the following IT skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Edinburgh region featuring Data Analyst in the job title.

1 16 (66.67%) SQL
2 12 (50.00%) SAS
3 11 (45.83%) Finance
3 11 (45.83%) Analytical Skills
4 10 (41.67%) Data Quality
5 8 (33.33%) Analytics
5 8 (33.33%) Data Governance
5 8 (33.33%) Microsoft Excel
5 8 (33.33%) SQL Server Integration Services
6 7 (29.17%) Microsoft PowerPoint
6 7 (29.17%) Banking
6 7 (29.17%) Business Analysis
6 7 (29.17%) Microsoft Office
6 7 (29.17%) Project Management
7 6 (25.00%) Microsoft Project
7 6 (25.00%) MS Visio
7 6 (25.00%) Root Cause Analysis
8 5 (20.83%) Hadoop
8 5 (20.83%) Data Architecture
9 4 (16.67%) Fintech
9 4 (16.67%) Data Analysis
9 4 (16.67%) ETL
9 4 (16.67%) CRM
9 4 (16.67%) T-SQL
10 3 (12.50%) SQL Server
10 3 (12.50%) Migration
10 3 (12.50%) Stakeholder Management
10 3 (12.50%) SQL Server Reporting Services
10 3 (12.50%) Marketing
10 3 (12.50%) Data Development

Data 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 12 (50.00%) SAS
Applications
1 8 (33.33%) Microsoft Excel
2 7 (29.17%) Microsoft Office
2 7 (29.17%) Microsoft PowerPoint
3 6 (25.00%) Microsoft Project
3 6 (25.00%) MS Visio
4 1 (4.17%) SPSS
Database & Business Intelligence
1 8 (33.33%) SQL Server Integration Services
2 5 (20.83%) Hadoop
3 3 (12.50%) SQL Server
3 3 (12.50%) SQL Server Reporting Services
4 2 (8.33%) Data Warehouse
4 2 (8.33%) IBM InfoSphere
4 2 (8.33%) Relational Database
5 1 (4.17%) Amazon Redshift
5 1 (4.17%) SQL Server 2014
5 1 (4.17%) SQL Server Analysis Services
General
1 11 (45.83%) Finance
2 7 (29.17%) Banking
3 3 (12.50%) Marketing
4 1 (4.17%) Legal
4 1 (4.17%) Retail
Libraries, Frameworks & Software Standards
1 1 (4.17%) .NET
Miscellaneous
1 11 (45.83%) Analytical Skills
2 4 (16.67%) Fintech
3 1 (4.17%) Clustering
3 1 (4.17%) Computer Science
Processes & Methodologies
1 8 (33.33%) Analytics
1 8 (33.33%) Data Governance
2 7 (29.17%) Business Analysis
2 7 (29.17%) Project Management
3 6 (25.00%) Root Cause Analysis
4 5 (20.83%) Data Architecture
5 4 (16.67%) CRM
5 4 (16.67%) Data Analysis
5 4 (16.67%) ETL
6 3 (12.50%) Capacity Planning
6 3 (12.50%) Data Development
6 3 (12.50%) Data Migration
6 3 (12.50%) Migration
6 3 (12.50%) Stakeholder Management
7 2 (8.33%) Campaign Analysis
7 2 (8.33%) Data Cleansing
7 2 (8.33%) Data Transformation
7 2 (8.33%) Data Visualisation
7 2 (8.33%) Post-Campaign Analysis
7 2 (8.33%) Visualisation
Programming Languages
1 16 (66.67%) SQL
2 4 (16.67%) T-SQL
3 3 (12.50%) R
4 2 (8.33%) Python
4 2 (8.33%) VBA
5 1 (4.17%) C
5 1 (4.17%) C#
5 1 (4.17%) C++
5 1 (4.17%) Java
5 1 (4.17%) VB
Qualifications
1 2 (8.33%) Degree
Quality Assurance & Compliance
1 10 (41.67%) Data Quality
2 1 (4.17%) GDPR
Vendors
1 2 (8.33%) IBM
1 2 (8.33%) Informatica
1 2 (8.33%) Microsoft
1 2 (8.33%) Tableau
1 2 (8.33%) Teradata
2 1 (4.17%) Capita
2 1 (4.17%) Oracle
2 1 (4.17%) Pega
2 1 (4.17%) Talend
2 1 (4.17%) Vertica