Period
to 13 July 2020

The following table provides summary statistics for permanent job vacancies 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 13 July 2020 with a comparison to the same period in the previous 2 years.

Data Extraction
UK
6 months to
13 Jul 2020
Same period 2019 Same period 2018
Rank 518 873 883
Rank change year-on-year +355 +10 +11
Permanent jobs citing Data Extraction 320 253 337
As % of all permanent jobs advertised in the UK 0.42% 0.17% 0.19%
As % of the Processes & Methodologies category 0.46% 0.19% 0.20%
Number of salaries quoted 105 209 292
Median annual salary £43,250 £47,500 £45,000
Median salary % change year-on-year -8.95% +5.56% -
10th Percentile £33,000 £31,100 £28,775
90th Percentile £84,000 £75,000 £67,500
UK excluding London median annual salary £40,000 £45,000 £40,000
% change year-on-year -11.11% +12.50% -

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 with a requirement for process or methodology skills.

All Process and Methodology Skills
UK
Permanent vacancies with a requirement for process or methodology skills 70,170 135,755 164,404
As % of all permanent IT jobs advertised in the UK 92.17% 92.21% 92.12%
Number of salaries quoted 55,978 106,868 131,604
Median annual salary £55,000 £52,500 £50,000
Median salary % change year-on-year +4.76% +5.00% +3.09%
10th Percentile £31,916 £30,000 £29,000
90th Percentile £90,000 £86,250 £82,500
UK excluding London median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

Data Extraction
Job Vacancy Trend

Job postings citing Data Extraction as a proportion of all IT jobs advertised.

Job vacancy trend for Data Extraction in the UK

Data Extraction
Salary Trend

3-month moving average salary quoted in jobs citing Data Extraction.

Salary trend for Data Extraction in the UK

Data Extraction
Salary Histogram

Salary distribution for jobs citing Data Extraction over the 6 months to 13 July 2020.

Salary histogram for Data Extraction in the UK

Data Extraction
Top 14 Job Locations

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Extraction within the UK over the 6 months to 13 July 2020. 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
England +341 317 £43,250 -6.99% 15
London +264 214 £57,500 +7.08% 11
UK excluding London +220 104 £40,000 -11.11% 5
South East +144 55 £45,000 -
South West +118 14 £40,000 -5.88% 2
North of England +127 13 £35,000 -26.32%
Midlands +108 12 £75,000 +100.00% 1
Yorkshire +111 8 £37,500 -23.47%
East Midlands +70 7 £75,000 +114.29% 1
Work from Home +68 7 £40,000 -30.43% 4
East of England +99 6 £37,060 +5.88% 1
North West +98 5 £35,000 -22.22%
West Midlands +88 5 £56,250 +27.84%
Scotland +78 3 £36,000 -26.53% 1

For the 6 months to 13 July 2020, IT jobs citing Data Extraction also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads with a requirement for Data Extraction.

1 253 (79.06%) SQL
2 239 (74.69%) Business Intelligence
3 237 (74.06%) ETL
4 232 (72.50%) Analytics
5 220 (68.75%) Analytical Skills
6 209 (65.31%) SQL Server
7 202 (63.13%) Data Analysis
8 200 (62.50%) Degree
9 199 (62.19%) Tableau
10 196 (61.25%) Oracle
11 188 (58.75%) Data Analytics
12 182 (56.88%) Data Lake
13 180 (56.25%) Alteryx
14 179 (55.94%) Proactive Monitoring
14 179 (55.94%) Teradata
15 178 (55.63%) Cadence
15 178 (55.63%) Automation Anywhere
15 178 (55.63%) UiPath
15 178 (55.63%) Blue Prism
16 118 (36.88%) Python
17 102 (31.88%) Visualisation
18 94 (29.38%) System Integration Testing
18 94 (29.38%) Oracle Reports
18 94 (29.38%) Legal
18 94 (29.38%) User Acceptance Testing
19 93 (29.06%) GAAP
20 88 (27.50%) Change Control
21 86 (26.88%) Project Management
22 48 (15.00%) Data Modelling
23 40 (12.50%) Finance

Data Extraction
Co-occurring IT Skills 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 17 (5.31%) Apache Spark
2 10 (3.13%) SAS
3 8 (2.50%) SharePoint
4 7 (2.19%) ArcGIS
5 4 (1.25%) Elasticsearch
5 4 (1.25%) nginx
5 4 (1.25%) Tomcat
6 2 (0.63%) Apache Airflow
6 2 (0.63%) Confluence
6 2 (0.63%) MS Exchange
7 1 (0.31%) Apache
7 1 (0.31%) Jupyter
Applications
1 21 (6.56%) Microsoft Excel
2 8 (2.50%) SPSS
3 5 (1.56%) Microsoft Office
4 1 (0.31%) Spreadsheet
Business Applications
1 8 (2.50%) SAP BPC
2 4 (1.25%) Eikon
2 4 (1.25%) SAP MDG
3 3 (0.94%) Oracle Payables
4 2 (0.63%) SAP GTS
4 2 (0.63%) SAP SD
5 1 (0.31%) Oracle EBS
5 1 (0.31%) Oracle EBS R12
5 1 (0.31%) Oracle ERP
5 1 (0.31%) SAP Business One
5 1 (0.31%) SAP CO
5 1 (0.31%) SAP ERP
5 1 (0.31%) SAP FI
5 1 (0.31%) SAP FI/CO
5 1 (0.31%) SAP InfiniteInsight
5 1 (0.31%) SAP MDM
Cloud Services
1 28 (8.75%) AWS
2 25 (7.81%) Power Platform
3 13 (4.06%) Azure
4 9 (2.81%) SaaS
5 7 (2.19%) AWS Lambda
5 7 (2.19%) Serverless
6 6 (1.88%) GCP
7 4 (1.25%) Amazon EC2
7 4 (1.25%) Amazon ECS
7 4 (1.25%) Amazon EKS
7 4 (1.25%) Amazon S3
7 4 (1.25%) Azure Data Factory
8 3 (0.94%) Amazon EMR
8 3 (0.94%) AWS CloudFormation
8 3 (0.94%) GitHub
8 3 (0.94%) IaaS
8 3 (0.94%) PaaS
9 2 (0.63%) Taleo
10 1 (0.31%) Google Analytics
10 1 (0.31%) OpenShift
Communications & Networking
1 4 (1.25%) SSL
2 3 (0.94%) DNS
2 3 (0.94%) SAN
3 2 (0.63%) CTI
3 2 (0.63%) Internet
3 2 (0.63%) VoIP
3 2 (0.63%) VPN
Database & Business Intelligence
1 209 (65.31%) SQL Server
2 182 (56.88%) Data Lake
3 94 (29.38%) Oracle Reports
4 29 (9.06%) Data Warehouse
5 26 (8.13%) Big Data
6 25 (7.81%) Power BI
7 24 (7.50%) SQL Server Reporting Services
8 22 (6.88%) Hadoop
9 20 (6.25%) SQL Server Integration Services
10 15 (4.69%) SQL Server Analysis Services
11 12 (3.75%) MySQL
12 10 (3.13%) BusinessObjects
12 10 (3.13%) SAP BW
12 10 (3.13%) SAP Data Services
12 10 (3.13%) SAP HANA
13 9 (2.81%) Apache Hive
14 8 (2.50%) Crystal Reports
14 8 (2.50%) NoSQL
15 7 (2.19%) Amazon Redshift
15 7 (2.19%) Enterprise Data Warehouse
Development Applications
1 7 (2.19%) LSMW
2 6 (1.88%) JIRA
3 5 (1.56%) Team Foundation Server
4 4 (1.25%) Visual Studio
5 3 (0.94%) Git (software)
5 3 (0.94%) Travis CI
6 2 (0.63%) Cucumber
6 2 (0.63%) Jenkins
6 2 (0.63%) Maven
6 2 (0.63%) Selenium
6 2 (0.63%) SoapUI
6 2 (0.63%) SOAtest
6 2 (0.63%) WebDriver
7 1 (0.31%) SpecFlow
7 1 (0.31%) SQL Server Management Studio (SSMS)
General
1 94 (29.38%) Legal
2 40 (12.50%) Finance
3 5 (1.56%) Banking
3 5 (1.56%) Law
4 4 (1.25%) Aerospace
4 4 (1.25%) Retail
5 3 (0.94%) Marketing
6 2 (0.63%) Manufacturing
6 2 (0.63%) Telecoms
7 1 (0.31%) Advertising
7 1 (0.31%) Greek Language
7 1 (0.31%) Investment Banking
7 1 (0.31%) Pharmaceutical
7 1 (0.31%) Public Sector
7 1 (0.31%) Wholesale Banking
Job Titles
1 183 (57.19%) Analyst
2 159 (49.69%) Data Analyst
3 63 (19.69%) Senior Analyst
3 63 (19.69%) Senior Data Analyst
4 52 (16.25%) Data Engineer
4 52 (16.25%) Data Manager
5 42 (13.13%) Developer
6 31 (9.69%) Senior Data Engineer
7 26 (8.13%) Business Intelligence Developer
8 19 (5.94%) Data Quality Analyst
8 19 (5.94%) Data Quality Manager
8 19 (5.94%) Quality Analyst
8 19 (5.94%) Quality Manager
9 18 (5.63%) Business Developer
10 16 (5.00%) Business Intelligence Analyst
11 13 (4.06%) Data Scientist
12 10 (3.13%) Analyst Developer
12 10 (3.13%) SAP Developer
13 7 (2.19%) Consultant
13 7 (2.19%) Data Architect
Libraries, Frameworks & Software Standards
1 14 (4.38%) Kafka
2 8 (2.50%) .NET
2 8 (2.50%) Natural Language Processing
3 7 (2.19%) Anaconda
4 6 (1.88%) Web Services
5 5 (1.56%) JSON
6 4 (1.25%) AngularJS
6 4 (1.25%) Apache Avro
6 4 (1.25%) ASP.NET
6 4 (1.25%) ASP.NET MVC
6 4 (1.25%) GraphQL
6 4 (1.25%) REST
6 4 (1.25%) SOAP
7 2 (0.63%) CGI
7 2 (0.63%) MDX
7 2 (0.63%) XML
8 1 (0.31%) BAPI
8 1 (0.31%) ODBC
8 1 (0.31%) Pandas
8 1 (0.31%) PostGIS
Miscellaneous
1 220 (68.75%) Analytical Skills
2 20 (6.25%) Management Information System
3 11 (3.44%) Algorithms
4 9 (2.81%) Credit Risk
5 7 (2.19%) Augmented Reality
5 7 (2.19%) Cloud Native
5 7 (2.19%) Data Structures
5 7 (2.19%) FMCG
5 7 (2.19%) Linked Data
5 7 (2.19%) Replication
5 7 (2.19%) Semantic Web
5 7 (2.19%) User Experience
6 6 (1.88%) Greenfield Project
6 6 (1.88%) Self-Motivation
7 5 (1.56%) Reinsurance
8 2 (0.63%) CCTV
9 1 (0.31%) Market Risk
9 1 (0.31%) Public Cloud
9 1 (0.31%) Robotics
9 1 (0.31%) Video Conferencing
Operating Systems
1 5 (1.56%) Windows
1 5 (1.56%) Windows Server
2 2 (0.63%) Windows 2000
2 2 (0.63%) Windows 7
2 2 (0.63%) Windows 8
2 2 (0.63%) Windows Server 2003
2 2 (0.63%) Windows Server 2008
2 2 (0.63%) Windows XP
Processes & Methodologies
1 239 (74.69%) Business Intelligence
2 237 (74.06%) ETL
3 232 (72.50%) Analytics
4 202 (63.13%) Data Analysis
5 188 (58.75%) Data Analytics
6 179 (55.94%) Proactive Monitoring
7 102 (31.88%) Visualisation
8 94 (29.38%) System Integration Testing
8 94 (29.38%) User Acceptance Testing
9 88 (27.50%) Change Control
10 86 (26.88%) Project Management
11 48 (15.00%) Data Modelling
12 21 (6.56%) Agile Software Development
13 20 (6.25%) Migration
13 20 (6.25%) Problem-Solving
14 19 (5.94%) Data Science
15 17 (5.31%) Data Governance
15 17 (5.31%) DevOps
16 16 (5.00%) Data Management
17 15 (4.69%) Decision-Making
Programming Languages
1 253 (79.06%) SQL
2 118 (36.88%) Python
3 11 (3.44%) C#
4 9 (2.81%) R
5 7 (2.19%) C
6 6 (1.88%) VBA
7 5 (1.56%) T-SQL
8 4 (1.25%) Java
8 4 (1.25%) JavaScript
8 4 (1.25%) Scala
8 4 (1.25%) VB
8 4 (1.25%) VB.NET
9 3 (0.94%) Data Analysis Expressions (DAX)
10 2 (0.63%) Go
11 1 (0.31%) ABAP
11 1 (0.31%) Clojure
11 1 (0.31%) Elixir
11 1 (0.31%) Julia
11 1 (0.31%) Perl
11 1 (0.31%) PHP
Qualifications
1 200 (62.50%) Degree
2 11 (3.44%) Security Cleared
3 8 (2.50%) SC Cleared
4 3 (0.94%) Chartered Engineer
4 3 (0.94%) PhD
5 1 (0.31%) DV Cleared
5 1 (0.31%) ISTQB
Quality Assurance & Compliance
1 93 (29.06%) GAAP
2 31 (9.69%) Data Quality
3 7 (2.19%) Sarbanes-Oxley
4 6 (1.88%) GDPR
5 4 (1.25%) Basel II
5 4 (1.25%) Basel III
6 3 (0.94%) QA
7 2 (0.63%) IFRS
7 2 (0.63%) IFRS 9
7 2 (0.63%) SLA
8 1 (0.31%) Actionable Recommendations
System Software
1 4 (1.25%) Varnish
2 2 (0.63%) Active Directory
3 1 (0.31%) Docker
Systems Management
1 6 (1.88%) Terraform
2 3 (0.94%) Ansible
3 2 (0.63%) DameWare
3 2 (0.63%) Kubernetes
3 2 (0.63%) Norton AntiVirus
3 2 (0.63%) OpenView
3 2 (0.63%) OVSD
3 2 (0.63%) SCCM
4 1 (0.31%) Grafana
4 1 (0.31%) Prometheus
Vendors
1 199 (62.19%) Tableau
2 196 (61.25%) Oracle
3 180 (56.25%) Alteryx
4 179 (55.94%) Teradata
5 178 (55.63%) Automation Anywhere
5 178 (55.63%) Blue Prism
5 178 (55.63%) Cadence
5 178 (55.63%) UiPath
6 30 (9.38%) SAP
7 22 (6.88%) Microsoft
8 8 (2.50%) Cognos
9 7 (2.19%) Google
10 4 (1.25%) Infragistics
11 3 (0.94%) Databricks
11 3 (0.94%) JD Edwards
11 3 (0.94%) Sage
11 3 (0.94%) Sybase
11 3 (0.94%) Vertica
12 2 (0.63%) Adobe
12 2 (0.63%) Workday