Period
to 23 November 2017

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

Extract, Transform and Load (ETL)
Hampshire > Portsmouth
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 76 42 82
Rank change year-on-year -34 +40 +30
Permanent jobs citing ETL 13 32 6
As % of all permanent IT jobs advertised in Portsmouth 1.88% 4.80% 0.74%
As % of the Processes & Methodologies category 2.12% 5.19% 0.83%
Number of salaries quoted 2 34 5
Portsmouth median annual salary £45,125 £42,500 £34,000
Median salary % change year-on-year +6.18% +25.00% +5.43%
10th Percentile £39,313 £32,500 £26,000
90th Percentile £48,838 £92,500 £71,250
Hampshire median annual salary £45,000 £45,000 £45,000

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

All Process and Methodology Skills
Portsmouth
Permanent vacancies with a requirement for process or methodology skills 613 616 721
As % of all permanent IT jobs advertised in Portsmouth 88.71% 92.49% 88.79%
Number of salaries quoted 534 593 629
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £22,750 £26,500 £25,000
90th Percentile £57,500 £60,000 £58,750
Hampshire median annual salary £42,500 £41,543 £42,500
% change year-on-year +2.30% -2.25% +2.41%

ETL
Job Vacancy Trend in Portsmouth

Job postings citing ETL as a percentage of all IT jobs advertised in Portsmouth.

Job vacancy trend for ETL in Portsmouth

ETL
Salary Trend in Portsmouth

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

Salary trend for ETL in Portsmouth

For the 6 months to 23 November 2017, IT jobs citing ETL 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 Portsmouth region with a requirement for ETL.

1 13 (100.00%) SAP
1 13 (100.00%) BusinessObjects
1 13 (100.00%) SAP Data Services
2 12 (92.31%) Migration
2 12 (92.31%) Data Migration
2 12 (92.31%) Data Cleansing
2 12 (92.31%) Security Cleared
2 12 (92.31%) Data Quality
3 11 (84.62%) SAP HANA
3 11 (84.62%) Data Integration
3 11 (84.62%) BODI
3 11 (84.62%) Stakeholder Management
3 11 (84.62%) Business Intelligence
3 11 (84.62%) BusinessObjects Business Intelligence
4 1 (7.69%) IDoc
4 1 (7.69%) Data Governance
4 1 (7.69%) Star Schema
4 1 (7.69%) Microsoft
4 1 (7.69%) ABAP
4 1 (7.69%) SQL Server
4 1 (7.69%) Crystal Reports
4 1 (7.69%) Microsoft Excel
4 1 (7.69%) Cognos
4 1 (7.69%) Data Warehouse
4 1 (7.69%) Data Modelling
4 1 (7.69%) SQL Server Reporting Services
4 1 (7.69%) DataStage
4 1 (7.69%) BAPI
4 1 (7.69%) SQL Server Integration Services
4 1 (7.69%) BusinessObjects Web Intelligence

ETL
Co-occurring IT Skills in Portsmouth 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:

Applications
1 1 (7.69%) Microsoft Excel
1 1 (7.69%) Spreadsheet
Database & Business Intelligence
1 13 (100.00%) BusinessObjects
1 13 (100.00%) SAP Data Services
2 11 (84.62%) BODI
2 11 (84.62%) BusinessObjects Business Intelligence
2 11 (84.62%) SAP HANA
3 1 (7.69%) BusinessObjects Web Intelligence
3 1 (7.69%) Crystal Reports
3 1 (7.69%) Data Warehouse
3 1 (7.69%) DataStage
3 1 (7.69%) Lumira
3 1 (7.69%) SQL Server
3 1 (7.69%) SQL Server Integration Services
3 1 (7.69%) SQL Server Reporting Services
3 1 (7.69%) Star Schema
Development Applications
1 1 (7.69%) Talend Open Studio
Job Titles
1 13 (100.00%) Developer
2 11 (84.62%) SAP BusinessObjects (BO) Developer
2 11 (84.62%) SAP Developer
3 1 (7.69%) Data Migration Developer
3 1 (7.69%) MIS Developer
Libraries, Frameworks & Software Standards
1 1 (7.69%) BAPI
1 1 (7.69%) IDoc
Processes & Methodologies
1 12 (92.31%) Data Cleansing
1 12 (92.31%) Data Migration
1 12 (92.31%) Migration
2 11 (84.62%) Business Intelligence
2 11 (84.62%) Data Integration
2 11 (84.62%) Stakeholder Management
3 1 (7.69%) Complex ETL
3 1 (7.69%) Data Architecture
3 1 (7.69%) Data Extraction
3 1 (7.69%) Data Governance
3 1 (7.69%) Data Modelling
3 1 (7.69%) Dimensional Modelling
Programming Languages
1 1 (7.69%) ABAP
Qualifications
1 12 (92.31%) Security Cleared
2 1 (7.69%) SC Cleared
Quality Assurance & Compliance
1 12 (92.31%) Data Quality
Vendors
1 13 (100.00%) SAP
2 1 (7.69%) Cognos
2 1 (7.69%) Microsoft
2 1 (7.69%) Talend