Period
to 20 November 2017

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 20 November 2017 with a comparison to the same period in the previous 2 years.

Data Extraction
UK
6 months to
20 Nov 2017
Same period 2016 Same period 2015
Rank 849 947 920
Rank change year-on-year +98 -27 +60
Permanent jobs citing Data Extraction 355 275 401
As % of all permanent IT jobs advertised in the UK 0.20% 0.15% 0.18%
As % of the Processes & Methodologies category 0.22% 0.16% 0.21%
Number of salaries quoted 284 248 308
UK median annual salary £47,500 £43,417 £45,000
Median salary % change year-on-year +9.40% -3.52% +5.88%
10th Percentile £25,750 £27,750 £26,250
90th Percentile £67,500 £62,500 £71,250
UK excluding London median annual salary £42,500 £37,500 £35,000
% change year-on-year +13.33% +7.14% -2.78%

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 161665 167144 194190
As % of all permanent IT jobs advertised in the UK 89.93% 89.36% 88.79%
Number of salaries quoted 127669 138904 159942
UK median annual salary £50,000 £49,500 £47,500
Median salary % change year-on-year +1.01% +4.21% +5.56%
10th Percentile £28,750 £28,000 £27,500
90th Percentile £80,000 £78,750 £77,500
UK excluding London median annual salary £44,000 £42,500 £42,500
% change year-on-year +3.53% - +6.25%

Data Extraction
Job Vacancy Trend

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

Job vacancy trend for Data Extraction in the UK

Data Extraction
Salary Trend

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

Salary trend for Data Extraction in the UK

Data Extraction
Salary Histogram

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

Salary histogram for Data Extraction in the UK

Data Extraction
Top 15 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 20 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
England +121 336 £47,500 +11.76% 16
UK excluding London +85 205 £42,500 +13.33% 14
London +25 141 £52,500 +5.00% 4
North of England +51 74 £48,250 +20.63% 3
North West +18 58 £49,000 +22.50% 2
South East +52 56 £37,500 +13.64% 3
Midlands +22 32 £37,500 +15.38% 5
West Midlands +14 21 £37,500 +11.94% 3
East of England -1 19 £40,000 -11.11%
South West +12 13 £45,000 +38.46% 1
Yorkshire +19 12 £50,000 +75.44% 1
East Midlands +30 11 £40,000 +26.36% 1
Scotland -21 7 £42,500 -15.84% 1
Wales +11 4 £33,500 +54.02% 1
North East - 4 £25,000 -

For the 6 months to 20 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 with a requirement for Data Extraction.

1 206 (58.03%) SQL
2 146 (41.13%) Business Intelligence
3 124 (34.93%) ETL
4 100 (28.17%) Microsoft Excel
5 99 (27.89%) SQL Server
6 95 (26.76%) Finance
7 89 (25.07%) Analytical Skills
8 87 (24.51%) Data Warehouse
9 84 (23.66%) Data Management
10 80 (22.54%) Oracle
10 80 (22.54%) Tableau
11 77 (21.69%) Analytics
11 77 (21.69%) SAP
12 71 (20.00%) Microsoft
13 63 (17.75%) Data Modelling
13 63 (17.75%) Degree
14 60 (16.90%) Python
15 55 (15.49%) Visualisation
15 55 (15.49%) Data Governance
16 48 (13.52%) SQL Server Reporting Services
17 46 (12.96%) Data Quality
18 45 (12.68%) SQL Server Integration Services
19 44 (12.39%) ERP
20 42 (11.83%) QlikView
21 40 (11.27%) C#
22 39 (10.99%) T-SQL
22 39 (10.99%) Windows
22 39 (10.99%) Management Information System
23 38 (10.70%) R
24 37 (10.42%) Relational Database

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 33 (9.30%) SAS
2 27 (7.61%) SharePoint
3 21 (5.92%) Apache Spark
4 3 (0.85%) Apache
4 3 (0.85%) NetWeaver
4 3 (0.85%) SharePoint Server
5 2 (0.56%) Apache Pig
5 2 (0.56%) Elasticsearch
5 2 (0.56%) Smallworld
6 1 (0.28%) Apache Solr
Applications
1 100 (28.17%) Microsoft Excel
2 25 (7.04%) SPSS
3 21 (5.92%) Microsoft Office
4 12 (3.38%) Microsoft PowerPoint
5 8 (2.25%) Spreadsheet
6 7 (1.97%) MS Visio
7 4 (1.13%) Microsoft Project
8 3 (0.85%) Doxygen
9 2 (0.56%) SPSS Modeler
10 1 (0.28%) Abaqus
10 1 (0.28%) SOLIDWORKS
Business Applications
1 17 (4.79%) SAP ERP
2 16 (4.51%) SAP InfiniteInsight
3 7 (1.97%) Oracle EBS
4 5 (1.41%) Oracle ERP
5 4 (1.13%) NetSuite
6 3 (0.85%) Adobe Campaign
7 2 (0.56%) SAP PM
8 1 (0.28%) Dynamics AX
8 1 (0.28%) Dynamics NAV
8 1 (0.28%) FastStats
8 1 (0.28%) Sage 200
8 1 (0.28%) Sage X3
8 1 (0.28%) WebTrends
Cloud Services
1 29 (8.17%) Amazon AWS
2 16 (4.51%) OpenShift
3 13 (3.66%) Microsoft Azure
4 3 (0.85%) Google Analytics
5 2 (0.56%) AWS Data Pipeline
5 2 (0.56%) GitHub
5 2 (0.56%) SaaS
6 1 (0.28%) Adobe Analytics
6 1 (0.28%) Amazon EC2
6 1 (0.28%) Azure Data Factory
6 1 (0.28%) Google Cloud Platform
6 1 (0.28%) Office 365
Communications & Networking
1 2 (0.56%) DHCP
1 2 (0.56%) DNS
2 1 (0.28%) FIX Connectivity
2 1 (0.28%) LAN
2 1 (0.28%) TCP/IP
2 1 (0.28%) WAN
Database & Business Intelligence
1 99 (27.89%) SQL Server
2 87 (24.51%) Data Warehouse
3 48 (13.52%) SQL Server Reporting Services
4 45 (12.68%) SQL Server Integration Services
5 42 (11.83%) QlikView
6 37 (10.42%) Relational Database
7 35 (9.86%) BusinessObjects
8 33 (9.30%) NoSQL
9 29 (8.17%) RDBMS
10 28 (7.89%) Hadoop
11 27 (7.61%) Big Data
12 24 (6.76%) Spotfire
13 22 (6.20%) SAP BW
14 20 (5.63%) Power BI
15 19 (5.35%) Apache Hive
16 18 (5.07%) MS Access
17 16 (4.51%) BusinessObjects Business Intelligence
18 15 (4.23%) Crystal Reports
18 15 (4.23%) Oracle BI EE
19 13 (3.66%) Pentaho
Development Applications
1 17 (4.79%) SQL Server Management Studio (SSMS)
2 15 (4.23%) Talend Open Studio
3 11 (3.10%) Git (software)
4 10 (2.82%) Visual Studio
5 8 (2.25%) JUnit
5 8 (2.25%) Rational Rhapsody
6 5 (1.41%) Team Foundation Server
7 3 (0.85%) GCC
7 3 (0.85%) GDB
7 3 (0.85%) Jenkins
7 3 (0.85%) Subversion
7 3 (0.85%) TeamCity
8 2 (0.56%) JIRA
8 2 (0.56%) RStudio
9 1 (0.28%) LSMW
9 1 (0.28%) Maven
9 1 (0.28%) Oracle Forms
General
1 95 (26.76%) Finance
2 34 (9.58%) Retail
3 31 (8.73%) Marketing
4 21 (5.92%) Back Office
5 19 (5.35%) Banking
6 18 (5.07%) Pharmaceutical
7 10 (2.82%) Advertising
7 10 (2.82%) Legal
8 9 (2.54%) Manufacturing
9 8 (2.25%) Games
10 6 (1.69%) Billing
11 5 (1.41%) Aerospace
11 5 (1.41%) Front Office
12 4 (1.13%) Financial Institution
12 4 (1.13%) Law
13 3 (0.85%) French Language
14 1 (0.28%) Digital Economy
14 1 (0.28%) Investment Banking
14 1 (0.28%) Retail Banking
14 1 (0.28%) Telecoms
Job Titles
1 128 (36.06%) Analyst
2 93 (26.20%) Developer
3 46 (12.96%) Data Analyst
4 37 (10.42%) Architect
5 32 (9.01%) Data Architect
6 31 (8.73%) Data Manager
7 28 (7.89%) Business Intelligence Architect
8 25 (7.04%) Business Intelligence Analyst
8 25 (7.04%) Business Intelligence Developer
9 20 (5.63%) Analytics Manager
9 20 (5.63%) Data Analytics Manager
10 19 (5.35%) SQL Analyst
11 18 (5.07%) Data Scientist
12 17 (4.79%) Graduate
12 17 (4.79%) SAP Developer
13 16 (4.51%) C# Developer
13 16 (4.51%) SAP BW Developer
14 15 (4.23%) Junior
15 14 (3.94%) Business Developer
15 14 (3.94%) Change Analyst
Libraries, Frameworks & Software Standards
1 26 (7.32%) .NET
2 22 (6.20%) Web Services
3 18 (5.07%) Middleware
4 13 (3.66%) WPF
5 10 (2.82%) ASP.NET
5 10 (2.82%) REST
5 10 (2.82%) XML
6 5 (1.41%) ASP.NET MVC
6 5 (1.41%) HTML
6 5 (1.41%) WCF
7 4 (1.13%) .NET Framework
7 4 (1.13%) Angular 2
8 3 (0.85%) Boost C++ Libraries
8 3 (0.85%) CSS
8 3 (0.85%) STL
9 2 (0.56%) HTML5
9 2 (0.56%) jQuery
9 2 (0.56%) SOAP
9 2 (0.56%) XSD
9 2 (0.56%) XSLT
Miscellaneous
1 89 (25.07%) Analytical Skills
2 39 (10.99%) Management Information System
3 34 (9.58%) Computer Science
4 28 (7.89%) Virtual Team
5 23 (6.48%) Algorithms
6 18 (5.07%) Life Science
7 15 (4.23%) Data Structures
8 8 (2.25%) NHS
8 8 (2.25%) Renewable Energy
8 8 (2.25%) Smart Energy
9 7 (1.97%) Driving Licence
10 6 (1.69%) Enterprise Software
11 5 (1.41%) Greenfield Project
12 4 (1.13%) Client/Server
12 4 (1.13%) Reinsurance
12 4 (1.13%) Smart Meter
13 3 (0.85%) Wiki
14 2 (0.56%) Credit Risk
14 2 (0.56%) Reference Data
14 2 (0.56%) Replication
Operating Systems
1 39 (10.99%) Windows
2 20 (5.63%) Unix
3 15 (4.23%) Linux
4 1 (0.28%) Windows 10
4 1 (0.28%) Windows 7
4 1 (0.28%) Windows 8
4 1 (0.28%) Windows Server
4 1 (0.28%) Windows Server 2008
4 1 (0.28%) Windows Server 2012
Processes & Methodologies
1 146 (41.13%) Business Intelligence
2 124 (34.93%) ETL
3 84 (23.66%) Data Management
4 77 (21.69%) Analytics
5 63 (17.75%) Data Modelling
6 55 (15.49%) Data Governance
6 55 (15.49%) Visualisation
7 44 (12.39%) ERP
8 37 (10.42%) Stakeholder Management
9 35 (9.86%) ITIL
10 33 (9.30%) Master Data Management
11 29 (8.17%) Mathematics
12 26 (7.32%) Data Analysis
12 26 (7.32%) Data Analytics
13 25 (7.04%) Data Visualisation
13 25 (7.04%) Time Management
14 24 (6.76%) CRM
15 22 (6.20%) Data Integration
15 22 (6.20%) SDLC
16 21 (5.92%) Statistical Analysis
Programming Languages
1 206 (58.03%) SQL
2 60 (16.90%) Python
3 40 (11.27%) C#
4 39 (10.99%) T-SQL
5 38 (10.70%) R
6 34 (9.58%) PL/SQL
7 31 (8.73%) Java
7 31 (8.73%) VBA
8 10 (2.82%) Scala
9 8 (2.25%) C
9 8 (2.25%) JavaScript
10 6 (1.69%) C++
11 5 (1.41%) VB.NET
12 4 (1.13%) ABAP
12 4 (1.13%) MATLAB
13 3 (0.85%) AWK
13 3 (0.85%) Perl
13 3 (0.85%) Shell Script
13 3 (0.85%) VB
13 3 (0.85%) VBScript
Qualifications
1 63 (17.75%) Degree
2 14 (3.94%) PhD
2 14 (3.94%) Security Cleared
3 12 (3.38%) Computer Science Degree
4 8 (2.25%) SC Cleared
5 5 (1.41%) MCSA
5 5 (1.41%) MCSE
5 5 (1.41%) Microsoft Certification
6 4 (1.13%) ISEB
6 4 (1.13%) Numerate Degree
7 3 (0.85%) ITIL Foundation Certificate
Quality Assurance & Compliance
1 46 (12.96%) Data Quality
2 5 (1.41%) NEBOSH
3 3 (0.85%) Actionable Recommendations
3 3 (0.85%) SLA
4 1 (0.28%) HL7
4 1 (0.28%) ISO 9001
4 1 (0.28%) ISO/IEC 27001
System Software
1 3 (0.85%) Active Directory
2 1 (0.28%) Apache Flume
2 1 (0.28%) vSphere
Systems Management
1 16 (4.51%) Ganglia
Vendors
1 80 (22.54%) Oracle
1 80 (22.54%) Tableau
2 77 (21.69%) SAP
3 71 (20.00%) Microsoft
4 22 (6.20%) Informatica
5 19 (5.35%) Teradata
6 15 (4.23%) Talend
7 13 (3.66%) ServiceNow
7 13 (3.66%) Xerox
8 10 (2.82%) MuleSoft
9 9 (2.54%) Hyperion
10 8 (2.25%) MicroStrategy
11 6 (1.69%) Google
12 5 (1.41%) Cloudera
12 5 (1.41%) Hortonworks
12 5 (1.41%) MapR
12 5 (1.41%) Sage
13 4 (1.13%) Adobe
13 4 (1.13%) Epicor
13 4 (1.13%) Siemens