The table below looks at the prevalence of the term Data Extraction in IT jobs advertised for the City of London region. Included is a guide to the salaries offered in IT jobs that have cited Data Extraction over the 3 months to 24 January 2017 with a comparison to the same period over the previous 2 years.

3 months to
24 Jan 2017
Same period 2016 Same period 2015
Data Extraction
London / City of London
Rank 217 249 304
Rank change year-on-year
+32 +55
Permanent jobs citing Data Extraction 15 10 13
As % of all permanent IT jobs located in the City of London 0.30% 0.16% 0.13%
As % of the Miscellaneous category 0.59% 0.33% 0.29%
Number of salaries quoted 15 7 11
Median salary £60,000 £32,500 £55,000
Median salary % change year-on-year
+84.61% -40.90%
90% offered a salary of more than £33,200 £30,500 £50,000
10% offered a salary of more than £100,000 £55,500 £67,500
UK excluding London median salary £42,500 £34,000 £35,000
% change year-on-year
+25.00% -2.85%

The following table is for comparison with the above and provides statistics for the entire Miscellaneous category in permanent jobs advertised in the City of London region.

Miscellaneous Category
City of London
Permanent IT job ads with a match in the
Miscellaneous category
2544 3074 4521
As % of all permanent IT jobs located in the City of London 50.64% 48.05% 44.71%
Number of salaries quoted 2339 2718 3870
Median salary £60,000 £60,000 £55,000
Median salary % change year-on-year
- +9.09%
90% offered a salary of more than £35,000 £38,000 £35,000
10% offered a salary of more than £97,500 £80,000 £90,000
UK excluding London median salary £42,500 £42,500 £40,000
% change year-on-year
- +6.25%

Data Extraction
Jobs Demand Trend in the City of London

The demand trend of job ads across the City of London region citing Data Extraction as a proportion of all IT jobs with a match in the Miscellaneous category.

Data Extraction Jobs Demand Trend in the City of London

Data Extraction
Salary Trend in the City of London

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

Data Extraction Salary Trend in the City of London

Data Extraction
Salary Histogram in the City of London

This chart provides a salary histogram for IT jobs citing Data Extraction across the City of London region over the 3 months to 24 January 2017.

Data Extraction Salary Histogram in the City of London

Data Extraction
Top 30 Related IT Skills in the City of London

For the 6 months to 24 January 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 City of London region with a requirement for Data Extraction.

1 19 (82.61%) Analytics
2 13 (56.52%) Python
2 13 (56.52%) Degree
3 12 (52.17%) SQL
4 10 (43.48%) ETL
5 9 (39.13%) Banking
5 9 (39.13%) Finance
5 9 (39.13%) Hadoop
6 8 (34.78%) Tableau
7 7 (30.43%) Impala
7 7 (30.43%) Apache Spark
7 7 (30.43%) SDLC
7 7 (30.43%) Apache Hive
7 7 (30.43%) Mathematics
7 7 (30.43%) Linux
7 7 (30.43%) MapReduce
8 6 (26.09%) Business Intelligence
8 6 (26.09%) Java
8 6 (26.09%) R
8 6 (26.09%) Data Visualisation
8 6 (26.09%) Visualisation
9 4 (17.39%) Google Analytics
9 4 (17.39%) Analytical Skills
9 4 (17.39%) Data Analytics
9 4 (17.39%) Google
9 4 (17.39%) Data Management
9 4 (17.39%) SQL Server
9 4 (17.39%) MS Excel
9 4 (17.39%) Microsoft
9 4 (17.39%) Data Modelling

Data Extraction
Top Related IT Skills in the City of London 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 7 (30.43%) Apache Spark
2 2 (8.70%) SAS
3 1 (4.35%) Apache
3 1 (4.35%) Apache Solr
3 1 (4.35%) Mule
3 1 (4.35%) Oracle Service Bus
3 1 (4.35%) WebLogic
3 1 (4.35%) WebSphere
Applications
1 4 (17.39%) MS Excel
2 2 (8.70%) MS Project
2 2 (8.70%) MS Visio
Business Applications
1 1 (4.35%) Salesforce.com CRM
Cloud Services
1 4 (17.39%) Google Analytics
2 1 (4.35%) Force.com
Database & Business Intelligence
1 9 (39.13%) Hadoop
2 7 (30.43%) Apache Hive
2 7 (30.43%) Impala
3 4 (17.39%) Mixpanel
3 4 (17.39%) Power BI
3 4 (17.39%) SQL Server
4 2 (8.70%) Base SAS
4 2 (8.70%) BusinessObjects
4 2 (8.70%) Data Warehouse
4 2 (8.70%) MySQL
4 2 (8.70%) QlikView
4 2 (8.70%) Relational Database
4 2 (8.70%) SQL Server Reporting Services
5 1 (4.35%) Big Data
5 1 (4.35%) Data Mining
5 1 (4.35%) MongoDB
5 1 (4.35%) NoSQL
Development Applications
1 3 (13.04%) Git (software)
1 3 (13.04%) Jenkins
1 3 (13.04%) JIRA
2 2 (8.70%) Ant
3 1 (4.35%) Capybara
3 1 (4.35%) Cucumber
3 1 (4.35%) Jasmine
3 1 (4.35%) Mocha
3 1 (4.35%) PhantomJS
3 1 (4.35%) RSpec
3 1 (4.35%) Selenium
3 1 (4.35%) Talend Open Studio
General
1 9 (39.13%) Banking
1 9 (39.13%) Finance
2 2 (8.70%) Automotive
2 2 (8.70%) Billing
3 1 (4.35%) Law
3 1 (4.35%) Legal
3 1 (4.35%) Manufacturing
Job Titles
1 10 (43.48%) Analyst
2 7 (30.43%) Programmer
2 7 (30.43%) Python Programmer
3 6 (26.09%) Data Analyst
4 4 (17.39%) Business Intelligence Analyst
4 4 (17.39%) Developer
5 2 (8.70%) Analyst Developer
5 2 (8.70%) Developer Analyst
5 2 (8.70%) Integration Developer
5 2 (8.70%) Senior Analyst
5 2 (8.70%) Senior Data Analyst
5 2 (8.70%) SQL Analyst
5 2 (8.70%) SQL Data Analyst
5 2 (8.70%) SQL Developer
5 2 (8.70%) T-SQL Developer
6 1 (4.35%) Automation Engineer
6 1 (4.35%) Data Scientist
6 1 (4.35%) Development Engineer
6 1 (4.35%) QA Software Engineer
6 1 (4.35%) Software QA Engineer
Libraries, Frameworks & Software Standards
1 2 (8.70%) Middleware
1 2 (8.70%) RESTful
1 2 (8.70%) Web Services
2 1 (4.35%) Gherkin
2 1 (4.35%) JSON
2 1 (4.35%) Lucene
2 1 (4.35%) Natural Language Processing
2 1 (4.35%) OAuth
2 1 (4.35%) Regular Expression
2 1 (4.35%) REST
2 1 (4.35%) XML
Miscellaneous
1 7 (30.43%) Mathematics
2 6 (26.09%) Visualisation
3 4 (17.39%) Analytical Skills
4 2 (8.70%) Data Structures
5 1 (4.35%) User Experience
5 1 (4.35%) Virtual Team
Operating Systems
1 7 (30.43%) Linux
2 2 (8.70%) Unix
2 2 (8.70%) Windows
Processes & Methodologies
1 19 (82.61%) Analytics
2 10 (43.48%) ETL
3 7 (30.43%) MapReduce
3 7 (30.43%) SDLC
4 6 (26.09%) Business Intelligence
4 6 (26.09%) Data Visualisation
5 4 (17.39%) Data Analytics
5 4 (17.39%) Data Management
5 4 (17.39%) Data Modelling
6 3 (13.04%) Agile Software Development
6 3 (13.04%) Data Analysis
7 2 (8.70%) CRM
7 2 (8.70%) Data Governance
7 2 (8.70%) Data Privacy
7 2 (8.70%) Data Security
7 2 (8.70%) E-Commerce
7 2 (8.70%) People Management
7 2 (8.70%) Scrum
7 2 (8.70%) Service Delivery
7 2 (8.70%) Statistical Analysis
Programming Languages
1 13 (56.52%) Python
2 12 (52.17%) SQL
3 6 (26.09%) Java
3 6 (26.09%) R
4 4 (17.39%) MATLAB
5 3 (13.04%) Ruby
6 2 (8.70%) T-SQL
7 1 (4.35%) JavaScript
Qualifications
1 13 (56.52%) Degree
Quality Assurance & Compliance
1 3 (13.04%) QA
2 2 (8.70%) Data Quality
Vendors
1 8 (34.78%) Tableau
2 4 (17.39%) Google
2 4 (17.39%) Microsoft
3 2 (8.70%) Informatica
3 2 (8.70%) Oracle
3 2 (8.70%) Platfora
4 1 (4.35%) Salesforce.com
4 1 (4.35%) Talend
4 1 (4.35%) Zuora