Period
to 22 July 2018

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

Data Extraction
UK > England
6 months to
22 Jul 2018
Same period 2017 Same period 2016
Rank 838 869 982
Rank change year-on-year +31 +113 -62
Permanent jobs citing Data Extraction 308 307 270
As % of all permanent IT jobs advertised in England 0.19% 0.18% 0.14%
As % of the Processes & Methodologies category 0.21% 0.20% 0.16%
Number of salaries quoted 258 232 232
England median annual salary £45,000 £45,000 £45,000
10th Percentile £30,875 £25,750 £30,375
90th Percentile £67,650 £71,250 £62,500
UK median annual salary £45,000 £45,000 £45,000

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

All Process and Methodology Skills
England
Permanent vacancies with a requirement for process or methodology skills 146,801 152,519 171,607
As % of all permanent IT jobs advertised in England 90.64% 90.73% 90.03%
Number of salaries quoted 118,100 123,356 144,576
England median annual salary £50,000 £50,000 £50,000
10th Percentile £29,750 £28,250 £27,500
90th Percentile £82,500 £80,000 £78,000
UK median annual salary £50,000 £49,500 £47,500
% change year-on-year +1.01% +4.21% -

Data Extraction
Job Vacancy Trend in England

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

Job vacancy trend for Data Extraction in England

Data Extraction
Salary Trend in England

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

Salary trend for Data Extraction in England

Data Extraction
Salary Histogram in England

The salary distribution of IT jobs citing Data Extraction in England over the 6 months to 22 July 2018.

Salary histogram for Data Extraction in England

Data Extraction
Job Locations in England

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing Data Extraction within the England region over the 6 months to 22 July 2018. 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
London -24 132 £50,000 - 19
South East +19 52 £43,500 +16.00% 1
North of England +24 50 £45,000 +12.50% 9
East of England +28 39 £40,000 - 4
North West +6 35 £45,000 +12.50% 2
Midlands -8 24 £38,750 +3.33% 3
West Midlands +22 18 £36,250 -3.33% 2
South West +12 11 £40,500 +9.46% 3
Yorkshire +30 10 £25,000 -44.44% 6
East Midlands -9 6 £50,000 -4.76% 1
North East -19 5 £70,000 +185.71% 1
Data Extraction
UK

For the 6 months to 22 July 2018, 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 across the England region with a requirement for Data Extraction.

1 230 (74.68%) SQL
2 120 (38.96%) SQL Server
3 115 (37.34%) Business Intelligence
4 105 (34.09%) ETL
5 100 (32.47%) Data Warehouse
6 96 (31.17%) Microsoft Excel
7 95 (30.84%) Finance
8 72 (23.38%) SQL Server Integration Services
8 72 (23.38%) Analytical Skills
9 71 (23.05%) Microsoft
10 70 (22.73%) Oracle
11 69 (22.40%) T-SQL
12 63 (20.45%) Agile Software Development
12 63 (20.45%) Analytics
13 62 (20.13%) SQL Server Reporting Services
14 59 (19.16%) Data Modelling
15 53 (17.21%) Visualisation
16 52 (16.88%) Python
17 51 (16.56%) Problem-Solving
18 49 (15.91%) VBA
19 46 (14.94%) Degree
19 46 (14.94%) Tableau
20 45 (14.61%) Relational Database
21 38 (12.34%) Power BI
22 37 (12.01%) Management Information System
23 36 (11.69%) ERP
24 35 (11.36%) SAS
25 33 (10.71%) Data Quality
26 32 (10.39%) Data Visualisation
26 32 (10.39%) Stakeholder Management

Data Extraction
Co-occurring IT Skills in England 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 35 (11.36%) SAS
2 8 (2.60%) SharePoint
3 7 (2.27%) Confluence
4 5 (1.62%) Apache Spark
5 4 (1.30%) Tomcat
6 3 (0.97%) Apache
7 2 (0.65%) Elasticsearch
8 1 (0.32%) CICS
8 1 (0.32%) Oracle SOA Suite
8 1 (0.32%) SharePoint Server
Applications
1 96 (31.17%) Microsoft Excel
2 25 (8.12%) Microsoft Office
3 19 (6.17%) Spreadsheet
4 15 (4.87%) MS Visio
4 15 (4.87%) SPSS
5 11 (3.57%) Microsoft PowerPoint
6 9 (2.92%) Microsoft Project
7 3 (0.97%) Stata
8 1 (0.32%) AutoCAD
8 1 (0.32%) Chatbot
8 1 (0.32%) SPSS Modeler
Business Applications
1 13 (4.22%) Infor SunSystems
2 9 (2.92%) SAP ERP
3 8 (2.60%) Cognos Business Intelligence
3 8 (2.60%) Cognos TM1
4 4 (1.30%) Dynamics CRM
4 4 (1.30%) Markit EDM
4 4 (1.30%) Oracle Financials
4 4 (1.30%) SAP GRC
4 4 (1.30%) SAP InfiniteInsight
5 3 (0.97%) Adobe Campaign
5 3 (0.97%) Epicor Tropos
5 3 (0.97%) FastStats
5 3 (0.97%) NetSuite
5 3 (0.97%) SAP BPC
5 3 (0.97%) SAP Oil and Gas
6 2 (0.65%) Dynamics AX
6 2 (0.65%) Infor M3
6 2 (0.65%) Movex
6 2 (0.65%) Oracle EBS
7 1 (0.32%) Oracle ERP
Cloud Services
1 14 (4.55%) Microsoft Azure
2 11 (3.57%) SaaS
3 8 (2.60%) Amazon AWS
4 6 (1.95%) IBM Blueworks
5 3 (0.97%) Office 365
6 2 (0.65%) SuccessFactors
7 1 (0.32%) Amazon EMR
7 1 (0.32%) Google Cloud Platform
Communications & Networking
1 8 (2.60%) FTP
2 4 (1.30%) SMS
3 2 (0.65%) Firewall
3 2 (0.65%) LAN
3 2 (0.65%) WAN
4 1 (0.32%) ATM
4 1 (0.32%) Broadband
4 1 (0.32%) Cisco IOS
4 1 (0.32%) DHCP
4 1 (0.32%) DNS
4 1 (0.32%) Intranet
4 1 (0.32%) TCP/IP
4 1 (0.32%) VPN
Database & Business Intelligence
1 120 (38.96%) SQL Server
2 100 (32.47%) Data Warehouse
3 72 (23.38%) SQL Server Integration Services
4 62 (20.13%) SQL Server Reporting Services
5 45 (14.61%) Relational Database
6 38 (12.34%) Power BI
7 31 (10.06%) SQL Server Analysis Services
8 24 (7.79%) NoSQL
8 24 (7.79%) RDBMS
9 21 (6.82%) MySQL
10 20 (6.49%) Hadoop
11 18 (5.84%) QlikView
12 17 (5.52%) Crystal Reports
12 17 (5.52%) OLAP
13 16 (5.19%) BusinessObjects
14 15 (4.87%) Data Mining
15 14 (4.55%) OLAP Cube
16 12 (3.90%) SAP Data Services
16 12 (3.90%) SQL Server 2008
17 10 (3.25%) SQL Server 2016
Development Applications
1 16 (5.19%) JIRA
2 6 (1.95%) Visual Studio
3 5 (1.62%) LSMW
4 4 (1.30%) Eclipse
5 2 (0.65%) Selenium
5 2 (0.65%) SQL Server Management Studio (SSMS)
5 2 (0.65%) Team Foundation Server
6 1 (0.32%) Bitbucket
6 1 (0.32%) Cucumber
6 1 (0.32%) Git (software)
6 1 (0.32%) LoadRunner
6 1 (0.32%) RStudio
6 1 (0.32%) SoapUI
6 1 (0.32%) SpecFlow
6 1 (0.32%) TeamCity
General
1 95 (30.84%) Finance
2 23 (7.47%) Marketing
3 15 (4.87%) Banking
4 13 (4.22%) Retail
5 12 (3.90%) Advertising
6 10 (3.25%) Publishing
7 9 (2.92%) Legal
8 8 (2.60%) Investment Banking
9 6 (1.95%) Manufacturing
9 6 (1.95%) Pharmaceutical
10 5 (1.62%) Law
11 4 (1.30%) Billing
12 3 (0.97%) Back Office
13 2 (0.65%) Telecoms
14 1 (0.32%) Automotive
14 1 (0.32%) Front Office
14 1 (0.32%) Games
14 1 (0.32%) General Ledger
Job Titles
1 116 (37.66%) Analyst
2 86 (27.92%) Developer
3 35 (11.36%) Business Intelligence Developer
4 29 (9.42%) SQL Developer
5 27 (8.77%) Data Analyst
6 21 (6.82%) Business Analyst
7 17 (5.52%) Senior Developer
7 17 (5.52%) SSIS Developer
7 17 (5.52%) Systems Analyst
8 16 (5.19%) Business Intelligence Analyst
8 16 (5.19%) Senior Analyst
8 16 (5.19%) Systems Manager
9 15 (4.87%) Report Analyst
10 14 (4.55%) Architect
10 14 (4.55%) ETL Developer
10 14 (4.55%) SSRS Developer
11 13 (4.22%) Business Systems Analyst
11 13 (4.22%) Senior Business Intelligence Developer
12 12 (3.90%) Data Manager
12 12 (3.90%) Technical Analyst
Libraries, Frameworks & Software Standards
1 21 (6.82%) HTML
2 13 (4.22%) CSS
3 12 (3.90%) .NET
4 11 (3.57%) XML
5 7 (2.27%) XSD
6 5 (1.62%) BAPI
6 5 (1.62%) IDoc
6 5 (1.62%) Kafka
6 5 (1.62%) RESTful
6 5 (1.62%) Spring
7 4 (1.30%) Hibernate
7 4 (1.30%) J2EE
7 4 (1.30%) Java EE
7 4 (1.30%) JSP
7 4 (1.30%) NumPy
7 4 (1.30%) Oracle Fusion
7 4 (1.30%) Pandas
7 4 (1.30%) Spring MVC
8 3 (0.97%) ASP.NET
8 3 (0.97%) Web Services
Miscellaneous
1 72 (23.38%) Analytical Skills
2 37 (12.01%) Management Information System
3 18 (5.84%) Computer Science
4 16 (5.19%) Data Structures
5 14 (4.55%) Self-Motivation
6 13 (4.22%) Greenfield Project
7 12 (3.90%) Credit Risk
8 11 (3.57%) e-Learning
9 9 (2.92%) Life Science
10 5 (1.62%) Algorithms
10 5 (1.62%) Replication
10 5 (1.62%) SCADA
11 3 (0.97%) Analytical Mindset
11 3 (0.97%) Clustering
11 3 (0.97%) FMCG
11 3 (0.97%) Industry 4.0
11 3 (0.97%) Reinsurance
12 2 (0.65%) Driving Licence
12 2 (0.65%) NHS
13 1 (0.32%) Mainframe
Operating Systems
1 17 (5.52%) Windows
2 11 (3.57%) Linux
2 11 (3.57%) Windows Server
3 4 (1.30%) Unix
4 2 (0.65%) Red Hat Enterprise Linux
4 2 (0.65%) Windows 7
5 1 (0.32%) AIX
5 1 (0.32%) Windows 10
Processes & Methodologies
1 115 (37.34%) Business Intelligence
2 105 (34.09%) ETL
3 63 (20.45%) Agile Software Development
3 63 (20.45%) Analytics
4 59 (19.16%) Data Modelling
5 53 (17.21%) Visualisation
6 51 (16.56%) Problem-Solving
7 36 (11.69%) ERP
8 32 (10.39%) Data Visualisation
8 32 (10.39%) Stakeholder Management
9 30 (9.74%) Data Management
10 27 (8.77%) Data Integration
10 27 (8.77%) Project Management
11 26 (8.44%) Data Analysis
11 26 (8.44%) Performance Tuning
12 24 (7.79%) PRINCE2
13 23 (7.47%) Business Analysis
14 21 (6.82%) Statistics
15 20 (6.49%) User Acceptance Testing
16 19 (6.17%) Data Analytics
Programming Languages
1 230 (74.68%) SQL
2 69 (22.40%) T-SQL
3 52 (16.88%) Python
4 49 (15.91%) VBA
5 30 (9.74%) Java
6 26 (8.44%) C#
7 21 (6.82%) PL/SQL
8 20 (6.49%) JavaScript
9 15 (4.87%) R
10 10 (3.25%) ABAP
10 10 (3.25%) PowerShell
11 9 (2.92%) C
12 8 (2.60%) C++
13 7 (2.27%) Bash Shell
14 4 (1.30%) Perl
14 4 (1.30%) Scala
15 3 (0.97%) VB.NET
15 3 (0.97%) VBScript
16 2 (0.65%) Shell Script
16 2 (0.65%) VB
Qualifications
1 46 (14.94%) Degree
2 9 (2.92%) SC Cleared
2 9 (2.92%) Security Cleared
3 4 (1.30%) Computer Science Degree
4 3 (0.97%) CISA
4 3 (0.97%) Oracle Certification
5 2 (0.65%) CISSP
5 2 (0.65%) Postgraduate
6 1 (0.32%) ITIL Foundation Certificate
6 1 (0.32%) Master's Degree
6 1 (0.32%) PRINCE2 Certification
Quality Assurance & Compliance
1 33 (10.71%) Data Quality
2 6 (1.95%) IFRS
2 6 (1.95%) IFRS 9
2 6 (1.95%) SLA
3 3 (0.97%) GDPR
4 2 (0.65%) Actionable Recommendations
5 1 (0.32%) HL7
5 1 (0.32%) ISO/IEC 27001
5 1 (0.32%) PCI DSS
System Software
1 6 (1.95%) Docker
2 2 (0.65%) Active Directory
3 1 (0.32%) Virtual Servers
3 1 (0.32%) VMware Infrastructure
Systems Management
1 3 (0.97%) Failover Clustering
1 3 (0.97%) Microsoft Clustering
1 3 (0.97%) Oracle Enterprise Manager
Vendors
1 71 (23.05%) Microsoft
2 70 (22.73%) Oracle
3 46 (14.94%) Tableau
4 31 (10.06%) SAP
5 20 (6.49%) Alteryx
6 19 (6.17%) Informatica
7 16 (5.19%) Infor
7 16 (5.19%) Teradata
8 12 (3.90%) Cognos
9 11 (3.57%) Adobe
10 7 (2.27%) Capita
10 7 (2.27%) Talend
11 5 (1.62%) Salesforce.com
12 4 (1.30%) Sage
13 3 (0.97%) Epicor
13 3 (0.97%) Google
13 3 (0.97%) IFS
13 3 (0.97%) Splunk
14 2 (0.65%) Twitter
14 2 (0.65%) Vertica