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 29 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 Jul 2016
Same period 2015 Same period 2014
Extract, Transform and Load (ETL)
Rank 43 54 75
Rank change year-on-year
+11 +21
Permanent jobs citing ETL 5 1 2
As % of all permanent IT jobs located in Portsmouth 1.76% 0.30% 0.43%
As % of the Processes & Methodologies category 1.92% 0.35% 0.52%
Number of salaries quoted 3 0 2
Median salary £74,250 - £35,500
90% offered a salary of more than £46,850 - £31,900
10% offered a salary of more than £86,850 - £39,100
UK excluding London median salary £45,000 £46,500 £45,000
% change year-on-year
-3.22% +3.33%
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
260 283 381
As % of all permanent IT jobs located in Portsmouth 91.55% 85.24% 82.11%
Number of salaries quoted 250 238 308
Median salary £40,000 £43,000 £40,000
Median salary % change year-on-year
-6.97% +7.50%
90% offered a salary of more than £30,000 £29,850 £24,000
10% offered a salary of more than £60,000 £51,000 £51,500
UK excluding London median salary £45,000 £44,000 £42,500
% change year-on-year
+2.27% +3.52%

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 29 July 2016.

ETL Salary Histogram in Portsmouth

ETL
Top 30 Related IT Skills in Portsmouth

For the 6 months to 29 July 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 14 (87.50%) Business Intelligence
2 11 (68.75%) Microsoft
2 11 (68.75%) MS Excel
2 11 (68.75%) T-SQL
2 11 (68.75%) SQL Server Reporting Services
2 11 (68.75%) SQL Server Integration Services
3 10 (62.50%) SQL Server Analysis Services
3 10 (62.50%) Performance Management
3 10 (62.50%) Dimensional Modelling
3 10 (62.50%) QlikView
3 10 (62.50%) Data Integration
3 10 (62.50%) C#
3 10 (62.50%) SharePoint
3 10 (62.50%) Data Warehouse
3 10 (62.50%) Project Management
3 10 (62.50%) Finance
3 10 (62.50%) Line Management
3 10 (62.50%) Mentoring
3 10 (62.50%) Coaching
4 6 (37.50%) SQL
5 5 (31.25%) PL/SQL
5 5 (31.25%) Oracle
5 5 (31.25%) NoSQL
6 4 (25.00%) Data Visualisation
6 4 (25.00%) Data Governance
6 4 (25.00%) Visualisation
6 4 (25.00%) Big Data
6 4 (25.00%) SaaS
6 4 (25.00%) PaaS
6 4 (25.00%) IaaS

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 10 (62.50%) SharePoint
Applications
1 11 (68.75%) MS Excel
Cloud Services
1 4 (25.00%) IaaS
1 4 (25.00%) PaaS
1 4 (25.00%) SaaS
2 1 (6.25%) Office 365
Database & Business Intelligence
1 11 (68.75%) SQL Server Integration Services
1 11 (68.75%) SQL Server Reporting Services
2 10 (62.50%) Data Warehouse
2 10 (62.50%) QlikView
2 10 (62.50%) SQL Server Analysis Services
3 5 (31.25%) NoSQL
4 4 (25.00%) Big Data
5 1 (6.25%) Data Mining
5 1 (6.25%) MySQL
5 1 (6.25%) Oracle BI EE
5 1 (6.25%) Oracle Database
5 1 (6.25%) Oracle Database 11g
5 1 (6.25%) SQL Server
5 1 (6.25%) SQL Server 2012
Development Applications
1 2 (12.50%) Oracle Forms
General
1 10 (62.50%) Finance
2 1 (6.25%) Advertising
Job Titles
1 10 (62.50%) Business Intelligence Lead
1 10 (62.50%) Team Leader
2 4 (25.00%) Architect
2 4 (25.00%) Data Architect
3 3 (18.75%) Lead Architect
3 3 (18.75%) Lead Data Architect
4 1 (6.25%) Analyst
4 1 (6.25%) Analyst Programmer
4 1 (6.25%) DBA
4 1 (6.25%) Programmer
4 1 (6.25%) Senior Analyst
4 1 (6.25%) Senior Analyst Programmer
4 1 (6.25%) Senior Programme Analyst
4 1 (6.25%) Senior Programmer
4 1 (6.25%) SQL DBA
Libraries, Frameworks & Software Standards
1 4 (25.00%) Hibernate
1 4 (25.00%) JDBC
1 4 (25.00%) Spring
1 4 (25.00%) Struts
Miscellaneous
1 10 (62.50%) Data Integration
2 4 (25.00%) Analytical Skills
2 4 (25.00%) Enterprise Software
2 4 (25.00%) Taxonomies
2 4 (25.00%) Visualisation
3 3 (18.75%) Management Information System
4 1 (6.25%) Statistics
Processes & Methodologies
1 14 (87.50%) Business Intelligence
2 10 (62.50%) Coaching
2 10 (62.50%) Dimensional Modelling
2 10 (62.50%) Line Management
2 10 (62.50%) Mentoring
2 10 (62.50%) Performance Management
2 10 (62.50%) Project Management
3 4 (25.00%) Analytics
3 4 (25.00%) Data Governance
3 4 (25.00%) Data Management
3 4 (25.00%) Data Migration
3 4 (25.00%) Data Modelling
3 4 (25.00%) Data Visualisation
3 4 (25.00%) EAI
3 4 (25.00%) Migration
3 4 (25.00%) Predictive Analytics
3 4 (25.00%) Validation
4 3 (18.75%) Content Management
4 3 (18.75%) TOGAF
4 3 (18.75%) Zachman Framework
Programming Languages
1 11 (68.75%) T-SQL
2 10 (62.50%) C#
3 6 (37.50%) SQL
4 5 (31.25%) PL/SQL
5 1 (6.25%) PowerShell
Vendors
1 11 (68.75%) Microsoft
2 5 (31.25%) Oracle