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 3 months to 30 March 2017 with a comparison to the same period in the previous 2 years.

Extract, Transform and Load (ETL)
Hampshire / Portsmouth
3 months to
30 Mar 2017
Same period 2016 Same period 2015
Rank 51 39 44
Rank change year-on-year -12 +5  
Permanent jobs citing ETL 1 12 7
As % of all permanent IT jobs advertised in Portsmouth 0.30% 4.48% 2.31%
As % of the Processes & Methodologies category 0.33% 5.56% 2.73%
Number of salaries quoted 1 12 7
Median salary £52,500 £45,000 £57,500
Median salary % change year-on-year +16.66% -21.73%  
UK excluding London median salary £45,000 £45,000 £45,000

ETL is in the process and methodology skills category. The next table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Portsmouth with a requirement for process and methodology skills.

Process & Methodology Skills
Portsmouth
Permanent job vacancies with a requirement for process and methodology skills 304 216 256
As % of all permanent IT job vacancies advertised in Portsmouth 90.48% 80.60% 84.49%
Number of salaries quoted 264 201 236
Median salary £42,500 £45,000 £44,750
Median salary % change year-on-year -5.55% +0.55%  
90% offered a salary of more than £28,500 £31,750 £27,800
10% offered a salary of more than £55,000 £59,250 £57,500
UK excluding London median salary £45,000 £45,000 £43,000
% change year-on-year - +4.65%  

ETL
Job Vacancy Trend in Portsmouth

The job posting trend of jobs advertised in Portsmouth citing ETL as a proportion of all permanent or contract IT jobs with a match in the Processes & Methodologies category.

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 30 March 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 10 (83.33%) SQL
1 10 (83.33%) Business Intelligence
1 10 (83.33%) Data Warehouse
2 6 (50.00%) Finance
2 6 (50.00%) Oracle
2 6 (50.00%) Oracle Forms
2 6 (50.00%) SQL Server Reporting Services
2 6 (50.00%) SQL Server Integration Services
2 6 (50.00%) Oracle BI EE
2 6 (50.00%) Analytics
3 5 (41.67%) Oracle E-Business Tax
3 5 (41.67%) Oracle Internet Expenses
3 5 (41.67%) Oracle Payables
3 5 (41.67%) Oracle Receivables
3 5 (41.67%) Oracle EBS R12
3 5 (41.67%) Oracle iProcurement
3 5 (41.67%) Cash Management
3 5 (41.67%) Oracle Workflow
3 5 (41.67%) Oracle Reports
3 5 (41.67%) T-SQL
3 5 (41.67%) Oracle EBS
3 5 (41.67%) Workflow
4 4 (33.33%) XML
4 4 (33.33%) PL/SQL
4 4 (33.33%) MDX
4 4 (33.33%) SQL Server Analysis Services
5 3 (25.00%) Process Improvement
5 3 (25.00%) Toad
5 3 (25.00%) General Ledger
5 3 (25.00%) Business Analysis

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:

Application Platforms
1 5 (41.67%) Oracle Workflow
2 1 (8.33%) SAS
Business Applications
1 5 (41.67%) Oracle EBS
1 5 (41.67%) Oracle EBS R12
1 5 (41.67%) Oracle E-Business Tax
1 5 (41.67%) Oracle Internet Expenses
1 5 (41.67%) Oracle iProcurement
1 5 (41.67%) Oracle Payables
1 5 (41.67%) Oracle Receivables
2 3 (25.00%) Oracle Cash Management
3 2 (16.67%) Oracle Applications
4 1 (8.33%) Oracle ERP
Communications & Networking
1 3 (25.00%) Internet
Database & Business Intelligence
1 10 (83.33%) Data Warehouse
2 6 (50.00%) Oracle BI EE
2 6 (50.00%) SQL Server Integration Services
2 6 (50.00%) SQL Server Reporting Services
3 5 (41.67%) Oracle Reports
4 4 (33.33%) SQL Server Analysis Services
5 3 (25.00%) OLAP
5 3 (25.00%) Oracle Discoverer
6 2 (16.67%) OLAP Cube
6 2 (16.67%) Oracle BI Publisher
6 2 (16.67%) Oracle Database
6 2 (16.67%) Oracle Database 11g
6 2 (16.67%) Relational Database
6 2 (16.67%) SQL Server
7 1 (8.33%) Business Intelligence Development Studio
7 1 (8.33%) Crystal Reports
7 1 (8.33%) Microsoft Analysis Services
7 1 (8.33%) Power BI
7 1 (8.33%) QlikView
Development Applications
1 6 (50.00%) Oracle Forms
2 3 (25.00%) Toad
3 2 (16.67%) JDeveloper
4 1 (8.33%) Team Foundation Server
4 1 (8.33%) Visual Studio
General
1 6 (50.00%) Finance
2 3 (25.00%) General Ledger
3 2 (16.67%) Advertising
4 1 (8.33%) Local Government
Job Titles
1 9 (75.00%) Developer
2 3 (25.00%) SQL Developer
3 2 (16.67%) Analyst
3 2 (16.67%) Business Intelligence Analyst
3 2 (16.67%) Business Intelligence Developer
3 2 (16.67%) Oracle Developer
3 2 (16.67%) SQL Analyst
3 2 (16.67%) T-SQL Developer
4 1 (8.33%) Applications Consultant
4 1 (8.33%) Business Developer
4 1 (8.33%) Consultant
4 1 (8.33%) E-Business Developer
4 1 (8.33%) Oracle Applications Technical Consultant
4 1 (8.33%) Oracle Consultant
4 1 (8.33%) Senior Developer
4 1 (8.33%) Senior SQL Developer
4 1 (8.33%) SSAS Developer
4 1 (8.33%) SSIS Developer
4 1 (8.33%) SSRS Developer
4 1 (8.33%) Technical Consultant
Libraries, Frameworks & Software Standards
1 4 (33.33%) MDX
1 4 (33.33%) XML
2 2 (16.67%) Apache Flex
2 2 (16.67%) CSS
2 2 (16.67%) HTML
3 1 (8.33%) .NET
Miscellaneous
1 2 (16.67%) Analytical Skills
Operating Systems
1 3 (25.00%) Unix
Processes & Methodologies
1 10 (83.33%) Business Intelligence
2 6 (50.00%) Analytics
3 5 (41.67%) Cash Management
3 5 (41.67%) Workflow
4 3 (25.00%) Business Analysis
4 3 (25.00%) Process Improvement
5 2 (16.67%) Dimensional Modelling
5 2 (16.67%) ETL Development
5 2 (16.67%) Personalization
5 2 (16.67%) SDLC
6 1 (8.33%) Agile Software Development
6 1 (8.33%) Customer Requirements
6 1 (8.33%) ERP
6 1 (8.33%) Predictive Analytics
6 1 (8.33%) Root Cause Analysis
Programming Languages
1 10 (83.33%) SQL
2 5 (41.67%) T-SQL
3 4 (33.33%) PL/SQL
4 3 (25.00%) Java
4 3 (25.00%) Shell Script
5 2 (16.67%) JavaScript
6 1 (8.33%) C#
Qualifications
1 1 (8.33%) Degree
Quality Assurance & Compliance
1 1 (8.33%) Data Quality
1 1 (8.33%) QA
Vendors
1 6 (50.00%) Oracle
2 3 (25.00%) Microsoft
3 1 (8.33%) Pegasus