The table below looks at the statistics for ETL skills in IT jobs advertised for the Portsmouth region. Included is a guide to the salaries offered in IT jobs that have cited ETL over the 3 months to 5 December 2016 with a comparison to the same period over the previous 2 years.

3 months to
5 Dec 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 40 54 70
Rank change year-on-year
+14 +16
Permanent jobs citing ETL 18 5 4
As % of all permanent IT jobs located in Portsmouth 5.17% 1.21% 0.99%
As % of the Processes & Methodologies category 5.84% 1.35% 1.11%
Number of salaries quoted 17 5 3
Median salary £38,761 £45,000 £33,500
Median salary % change year-on-year
-13.86% +34.32%
UK excluding London median salary £45,000 £45,000 £45,000
ETL
Hampshire

The following table is for comparison with the above and provides statistics for the entire Processes & Methodologies category in permanent jobs advertised in the Portsmouth region.

Processes & Methodologies Category
Portsmouth
Permanent IT job ads with a match in the
Processes & Methodologies category
308 370 360
As % of all permanent IT jobs located in Portsmouth 88.51% 89.37% 89.11%
Number of salaries quoted 295 332 315
Median salary £40,000 £45,000 £45,000
Median salary % change year-on-year
-11.11% -
90% offered a salary of more than £27,500 £30,000 £30,000
10% offered a salary of more than £60,000 £55,000 £62,500
UK excluding London median salary £45,000 £45,000 £42,500
% change year-on-year
- +5.88%

ETL
Jobs Demand Trend in Portsmouth

The demand trend of job ads across the Portsmouth region citing ETL as a proportion of all IT jobs with a match in the Processes & Methodologies category.

ETL Jobs Demand Trend in Portsmouth

ETL
Salary Trend in Portsmouth

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

ETL Salary Trend in Portsmouth

ETL
Salary Histogram in Portsmouth

This chart provides a salary histogram for IT jobs citing ETL across the Portsmouth region over the 3 months to 5 December 2016.

ETL Salary Histogram in Portsmouth

ETL
Top 30 Related IT Skills in Portsmouth

For the 6 months to 5 December 2016, 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 28 (90.32%) SQL
2 17 (54.84%) Business Intelligence
2 17 (54.84%) SQL Server Reporting Services
2 17 (54.84%) SQL Server Integration Services
3 16 (51.61%) Analytics
4 14 (45.16%) T-SQL
4 14 (45.16%) Oracle
5 13 (41.94%) NoSQL
5 13 (41.94%) Analytical Skills
6 12 (38.71%) SQL Server
6 12 (38.71%) PL/SQL
6 12 (38.71%) Data Warehouse
7 10 (32.26%) Microsoft
7 10 (32.26%) Visualisation
8 9 (29.03%) SQL Server Analysis Services
8 9 (29.03%) Predictive Analytics
9 8 (25.81%) Hibernate
9 8 (25.81%) Spring
9 8 (25.81%) Data Management
9 8 (25.81%) Validation
9 8 (25.81%) Migration
9 8 (25.81%) EAI
9 8 (25.81%) Data Modelling
9 8 (25.81%) JDBC
9 8 (25.81%) Struts
9 8 (25.81%) Taxonomies
9 8 (25.81%) Data Migration
9 8 (25.81%) Data Governance
9 8 (25.81%) Data Visualisation
9 8 (25.81%) Big Data

ETL
Top Related 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 (16.13%) Oracle Workflow
2 1 (3.23%) SAS
Applications
1 7 (22.58%) MS Excel
Business Applications
1 5 (16.13%) Oracle EBS
1 5 (16.13%) Oracle EBS R12
1 5 (16.13%) Oracle E-Business Tax
1 5 (16.13%) Oracle Internet Expenses
1 5 (16.13%) Oracle iProcurement
1 5 (16.13%) Oracle Payables
1 5 (16.13%) Oracle Receivables
2 3 (9.68%) Oracle Cash Management
3 2 (6.45%) Oracle Applications
4 1 (3.23%) Oracle ERP
Cloud Services
1 6 (19.35%) IaaS
1 6 (19.35%) PaaS
1 6 (19.35%) SaaS
2 5 (16.13%) Office 365
Communications & Networking
1 3 (9.68%) Internet
Database & Business Intelligence
1 17 (54.84%) SQL Server Integration Services
1 17 (54.84%) SQL Server Reporting Services
2 13 (41.94%) NoSQL
3 12 (38.71%) Data Warehouse
3 12 (38.71%) SQL Server
4 9 (29.03%) SQL Server Analysis Services
5 8 (25.81%) Big Data
6 6 (19.35%) Oracle BI EE
7 5 (16.13%) Data Mining
7 5 (16.13%) MySQL
7 5 (16.13%) Oracle Reports
7 5 (16.13%) SQL Server 2012
8 3 (9.68%) OLAP
8 3 (9.68%) Oracle Discoverer
8 3 (9.68%) Power BI
9 2 (6.45%) Oracle BI Publisher
9 2 (6.45%) Oracle Database
9 2 (6.45%) Oracle Database 11g
9 2 (6.45%) Qlik Sense
9 2 (6.45%) Relational Database
Development Applications
1 6 (19.35%) Oracle Forms
2 5 (16.13%) Visual Studio
3 3 (9.68%) Toad
4 2 (6.45%) JDeveloper
General
1 6 (19.35%) Finance
2 5 (16.13%) Advertising
3 3 (9.68%) General Ledger
4 2 (6.45%) Law
5 1 (3.23%) Local Government
Job Titles
1 11 (35.48%) Developer
2 9 (29.03%) DBA
2 9 (29.03%) SQL DBA
3 8 (25.81%) Architect
3 8 (25.81%) Data Architect
4 5 (16.13%) Lead Architect
4 5 (16.13%) Lead Data Architect
5 4 (12.90%) SQL Developer
6 3 (9.68%) Business Intelligence Developer
6 3 (9.68%) T-SQL Developer
7 2 (6.45%) Analyst
7 2 (6.45%) Business Intelligence Analyst
7 2 (6.45%) Oracle Developer
7 2 (6.45%) SQL Analyst
8 1 (3.23%) Applications Consultant
8 1 (3.23%) Business Developer
8 1 (3.23%) Consultant
8 1 (3.23%) Data Warehouse Developer
8 1 (3.23%) Oracle Consultant
8 1 (3.23%) Technical Consultant
Libraries, Frameworks & Software Standards
1 8 (25.81%) Hibernate
1 8 (25.81%) JDBC
1 8 (25.81%) Spring
1 8 (25.81%) Struts
2 4 (12.90%) XML
3 3 (9.68%) MDX
4 2 (6.45%) Apache Flex
4 2 (6.45%) CSS
4 2 (6.45%) HTML
Miscellaneous
1 13 (41.94%) Analytical Skills
2 10 (32.26%) Visualisation
3 8 (25.81%) Enterprise Software
3 8 (25.81%) Taxonomies
4 5 (16.13%) Management Information System
4 5 (16.13%) Statistics
Operating Systems
1 3 (9.68%) Unix
Processes & Methodologies
1 17 (54.84%) Business Intelligence
2 16 (51.61%) Analytics
3 9 (29.03%) Predictive Analytics
4 8 (25.81%) Data Governance
4 8 (25.81%) Data Management
4 8 (25.81%) Data Migration
4 8 (25.81%) Data Modelling
4 8 (25.81%) Data Visualisation
4 8 (25.81%) EAI
4 8 (25.81%) Migration
4 8 (25.81%) Validation
5 5 (16.13%) Cash Management
5 5 (16.13%) Content Management
5 5 (16.13%) Workflow
6 3 (9.68%) Agile Software Development
6 3 (9.68%) Big Data Analytics
6 3 (9.68%) Business Analysis
6 3 (9.68%) Data Analytics
6 3 (9.68%) Data Architecture
6 3 (9.68%) Process Improvement
Programming Languages
1 28 (90.32%) SQL
2 14 (45.16%) T-SQL
3 12 (38.71%) PL/SQL
4 5 (16.13%) PowerShell
5 3 (9.68%) Java
5 3 (9.68%) Shell Script
6 2 (6.45%) JavaScript
Qualifications
1 1 (3.23%) Degree
Quality Assurance & Compliance
1 3 (9.68%) QA
Vendors
1 14 (45.16%) Oracle
2 10 (32.26%) Microsoft
3 2 (6.45%) Tableau
4 1 (3.23%) Pegasus