Period
to 23 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for Data Extraction skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited Data Extraction over the 6 months to 23 November 2017 with a comparison to the same period in the previous 2 years.

Data Extraction
UK > Scotland
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 218 206 242
Rank change year-on-year -12 +36 -6
Permanent jobs citing Data Extraction 7 10 4
As % of all permanent IT jobs advertised in Scotland 0.12% 0.19% 0.062%
As % of the Processes & Methodologies category 0.14% 0.21% 0.069%
Number of salaries quoted 4 10 2
Scotland median annual salary £42,500 £50,500 £38,750
Median salary % change year-on-year -15.84% +30.32% -18.42%
10th Percentile £32,600 £38,375 £36,625
90th Percentile £54,500 £50,750 £39,875
UK median annual salary £47,500 £44,000 £45,000
% change year-on-year +7.95% -2.22% +7.14%

Data Extraction is in the Processes and Methodologies 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 process or methodology skills.

All Process and Methodology Skills
Scotland
Permanent vacancies with a requirement for process or methodology skills 5127 4738 5824
As % of all permanent IT jobs advertised in Scotland 90.84% 91.34% 90.86%
Number of salaries quoted 3274 2875 3684
Scotland median annual salary £45,000 £44,500 £42,500
Median salary % change year-on-year +1.12% +4.71% +2.41%
10th Percentile £28,250 £28,250 £27,575
90th Percentile £65,875 £65,000 £63,925
UK median annual salary £50,000 £49,500 £47,500
% change year-on-year +1.01% +4.21% +5.56%

Data Extraction
Job Vacancy Trend in Scotland

Job postings citing Data Extraction as a percentage of all IT jobs advertised in Scotland.

Job vacancy trend for Data Extraction in Scotland

Data Extraction
Salary Trend in Scotland

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

Salary trend for Data Extraction in Scotland

Data Extraction
Salary Histogram in Scotland

The salary distribution of IT jobs citing Data Extraction in Scotland over the 6 months to 23 November 2017.

Salary histogram for Data Extraction in Scotland

Data Extraction
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Extraction within the Scotland region over the 6 months to 23 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
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Edinburgh -22 6 £45,000 -10.89%
Glasgow -13 1 £40,000 -5.88% 1
Data Extraction
UK

For the 6 months to 23 November 2017, IT jobs citing Data Extraction 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 Data Extraction.

1 6 (85.71%) SQL
2 4 (57.14%) Analytics
3 3 (42.86%) ETL
3 3 (42.86%) Finance
4 2 (28.57%) Stakeholder Management
4 2 (28.57%) R
4 2 (28.57%) Data Analysis
4 2 (28.57%) SAS
4 2 (28.57%) Business Intelligence
4 2 (28.57%) SQL Server
4 2 (28.57%) Data Analytics
4 2 (28.57%) Performance Tuning
5 1 (14.29%) Analytical Skills
5 1 (14.29%) ETL Development
5 1 (14.29%) Digital Analytics
5 1 (14.29%) Prescriptive Analytics
5 1 (14.29%) Numerate Degree
5 1 (14.29%) JavaScript
5 1 (14.29%) Oracle Database
5 1 (14.29%) Python
5 1 (14.29%) PhD
5 1 (14.29%) Data Warehouse
5 1 (14.29%) Data Mining
5 1 (14.29%) MySQL
5 1 (14.29%) Oracle
5 1 (14.29%) MicroStrategy
5 1 (14.29%) SPSS
5 1 (14.29%) MATLAB
5 1 (14.29%) Project Management
5 1 (14.29%) Statistical Analysis

Data Extraction
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 2 (28.57%) SAS
Applications
1 1 (14.29%) SPSS
Cloud Services
1 1 (14.29%) Amazon AWS
Database & Business Intelligence
1 2 (28.57%) SQL Server
2 1 (14.29%) Big Data
2 1 (14.29%) Data Mining
2 1 (14.29%) Data Warehouse
2 1 (14.29%) MySQL
2 1 (14.29%) Oracle Database
General
1 3 (42.86%) Finance
Job Titles
1 4 (57.14%) Analyst
2 2 (28.57%) Database Analyst
2 2 (28.57%) Insight Analyst
3 1 (14.29%) Big Data Analyst
3 1 (14.29%) Data Analyst
3 1 (14.29%) Data Analytics Specialist
3 1 (14.29%) Data Insight Analyst
3 1 (14.29%) Data Manager
3 1 (14.29%) Developer
3 1 (14.29%) Insight Data Analyst
3 1 (14.29%) Junior
3 1 (14.29%) Junior Analyst
3 1 (14.29%) MicroStrategy Developer
3 1 (14.29%) SQL Analyst
3 1 (14.29%) SQL Data Analyst
Miscellaneous
1 1 (14.29%) Analytical Skills
Processes & Methodologies
1 4 (57.14%) Analytics
2 3 (42.86%) ETL
3 2 (28.57%) Business Intelligence
3 2 (28.57%) Data Analysis
3 2 (28.57%) Data Analytics
3 2 (28.57%) Performance Tuning
3 2 (28.57%) Stakeholder Management
4 1 (14.29%) Data Cleansing
4 1 (14.29%) Data Governance
4 1 (14.29%) Digital Analytics
4 1 (14.29%) ETL Development
4 1 (14.29%) Predictive Analytics
4 1 (14.29%) Prescriptive Analytics
4 1 (14.29%) Project Management
4 1 (14.29%) Statistical Analysis
4 1 (14.29%) Statistics
4 1 (14.29%) Visualisation
Programming Languages
1 6 (85.71%) SQL
2 2 (28.57%) R
3 1 (14.29%) JavaScript
3 1 (14.29%) MATLAB
3 1 (14.29%) Python
Qualifications
1 1 (14.29%) Degree
1 1 (14.29%) Numerate Degree
1 1 (14.29%) PhD
Quality Assurance & Compliance
1 1 (14.29%) Data Quality
Vendors
1 1 (14.29%) MicroStrategy
1 1 (14.29%) Oracle